{"id":277,"date":"2016-11-30T17:35:15","date_gmt":"2016-11-30T09:35:15","guid":{"rendered":"http:\/\/www.irspossystem.com\/wiki\/2016\/11\/30\/1-3-4-how-to-export-import-item\/"},"modified":"2018-09-28T11:35:33","modified_gmt":"2018-09-28T03:35:33","slug":"1-3-4-how-to-export-import-item","status":"publish","type":"post","link":"https:\/\/www.irspossystem.com\/wiki\/2016\/11\/30\/1-3-4-how-to-export-import-item\/","title":{"rendered":"1.3.4- How to export & import item"},"content":{"rendered":"

Export database into excel<\/strong><\/p>\n

1. Select utility
\n2. Click on export
\n3. On table name choose either item,vendor or customer<\/p>\n

4. On table type choose the item type<\/p>\n

5. On table column tick that data that needed<\/p>\n

6. Click on right arrow to confirm<\/p>\n

7. All the selected data will shown up in export<\/p>\n

8. Click refresh<\/p>\n

9. Sample of export database will shown here<\/p>\n

10. Click export to confirm export to desktop<\/p>\n

\"i3\"<\/p>\n

11. System will show information that successful exported<\/p>\n

\"i2\"<\/p>\n

\u00a0<\/strong><\/p>\n

Import excel into database
\n<\/strong><\/p>\n

1. Click on utility<\/p>\n

2. Select export<\/p>\n

3. Select table<\/p>\n

4. Enter the path of excel located<\/p>\n

5. Click on load excel<\/p>\n

6. Successful loaded data will shows here<\/p>\n

7. Problem data will show here<\/p>\n

\"i4\"<\/p>\n","protected":false},"excerpt":{"rendered":"

Export database into excel 1. Select utility 2. Click on export 3. On table name choose either item,vendor or customer 4. On table type choose the item type 5. On table column tick that data that needed 6. Click on right arrow to confirm 7. All the selected data will shown up in export 8. […] More<\/a><\/p>\n","protected":false},"author":1,"featured_media":274,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[47,48],"class_list":["post-277","post","type-post","status-publish","format-standard","has-post-thumbnail","category-item","tag-export","tag-import"],"_links":{"self":[{"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/posts\/277","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/comments?post=277"}],"version-history":[{"count":3,"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/posts\/277\/revisions"}],"predecessor-version":[{"id":826,"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/posts\/277\/revisions\/826"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/media\/274"}],"wp:attachment":[{"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/media?parent=277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/categories?post=277"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/tags?post=277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}