{"id":150,"date":"2008-07-15T00:19:00","date_gmt":"2008-07-14T16:19:00","guid":{"rendered":"http:\/\/j178.mtgbb.com\/189"},"modified":"2011-02-28T16:23:03","modified_gmt":"2011-02-28T08:23:03","slug":"toad-data-import-from-xls","status":"publish","type":"post","link":"https:\/\/j178.mtgbb.com\/?p=150","title":{"rendered":"Toad Data Import (from XLS)"},"content":{"rendered":"<p>Toad Data Import (from XLS)<\/p>\n<p>1. Menu \u2192 Database \u2192 Import \u2192 Table Data<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1232699825.png\" alt=\"\" title=\"toad01\" width=\"574\" height=\"336\" class=\"alignnone size-full wp-image-341\" srcset=\"https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1232699825.png 574w, https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1232699825-300x175.png 300w\" sizes=\"auto, (max-width: 574px) 100vw, 574px\" \/><\/p>\n<p><!--more--><br \/>\n2. Select schema\u3001Object Type\u3001Object Name, Click \u300cShow Data\u300d, Click \u300cExecute Wizard\u300d<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1252007826.png\" alt=\"\" title=\"toad02\" width=\"504\" height=\"266\" class=\"alignnone size-full wp-image-342\" srcset=\"https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1252007826.png 504w, https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1252007826-300x158.png 300w\" sizes=\"auto, (max-width: 504px) 100vw, 504px\" \/><\/p>\n<p>3. Import data from excel, \u6307\u5b9a\u532f\u5165\u6a94\u6848\u683c\u5f0f\u70ba excel \u6a94<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1295574681.png\" alt=\"\" title=\"toad03\" width=\"394\" height=\"272\" class=\"alignnone size-full wp-image-343\" srcset=\"https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1295574681.png 394w, https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1295574681-300x207.png 300w\" sizes=\"auto, (max-width: 394px) 100vw, 394px\" \/> <\/p>\n<p>4. Select data source, \u9078\u64c7\u532f\u5165\u4f86\u6e90\u6a94\u6848<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1003689359.png\" alt=\"\" title=\"toad04\" width=\"395\" height=\"271\" class=\"alignnone size-full wp-image-344\" srcset=\"https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1003689359.png 395w, https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1003689359-300x205.png 300w\" sizes=\"auto, (max-width: 395px) 100vw, 395px\" \/> <\/p>\n<p>5. Choose data format, \u6307\u5b9a\u532f\u5165\u6a94\u6848\u4e2d\u683c\u5f0f, \u5305\u62ec\u555f\u59cb\u6b04\u4f4d\u3001\u7d50\u675f\u6b04\u4f4d\u3001\u65e5\u671f\u683c\u5f0f\u7b49.<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1242530839.png\" alt=\"\" title=\"toad05\" width=\"395\" height=\"271\" class=\"alignnone size-full wp-image-345\" srcset=\"https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1242530839.png 395w, https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1242530839-300x205.png 300w\" sizes=\"auto, (max-width: 395px) 100vw, 395px\" \/><\/p>\n<p>6. Auto mapping fields, \u7a0b\u5f0f\u4f9d\u7167\u6b04\u4f4d\u9806\u5e8f, \u81ea\u52d5\u5c07\u8cc7\u6599\u8207\u6b04\u4f4d<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1329690370.png\" alt=\"\" title=\"toad06\" width=\"426\" height=\"293\" class=\"alignnone size-full wp-image-346\" srcset=\"https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1329690370.png 426w, https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1329690370-300x206.png 300w\" sizes=\"auto, (max-width: 426px) 100vw, 426px\" \/><\/p>\n<p>7. Specify mapping fields, \u8abf\u6574\u5c0d\u61c9\u6b04\u4f4d<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1180029509.png\" alt=\"\" title=\"toad07\" width=\"432\" height=\"296\" class=\"alignnone size-full wp-image-347\" srcset=\"https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1180029509.png 432w, https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1180029509-300x205.png 300w\" sizes=\"auto, (max-width: 432px) 100vw, 432px\" \/> <\/p>\n<p>8. Review, \u9810\u89bd\u8cc7\u6599\u7d50\u679c<\/p>\n<div class=\"imageblock center\" style=\"text-align: center; clear: both;\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/j178.mtgbb.com\/attach\/1\/1296279439.png\" alt=\"\u7528\u6236\u63d2\u5165\u5716\u7247\" width=\"429\" height=\"295\" \/><\/div>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1296279439.png\" alt=\"\" title=\"toad08\" width=\"429\" height=\"295\" class=\"alignnone size-full wp-image-348\" srcset=\"https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1296279439.png 429w, https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1296279439-300x206.png 300w\" sizes=\"auto, (max-width: 429px) 100vw, 429px\" \/><\/p>\n<p>9. Execute, append data from xls, \u958b\u59cb\u57f7\u884c\u532f\u5165<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1202708455.png\" alt=\"\" title=\"toad09\" width=\"440\" height=\"304\" class=\"alignnone size-full wp-image-349\" srcset=\"https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1202708455.png 440w, https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1202708455-300x207.png 300w\" sizes=\"auto, (max-width: 440px) 100vw, 440px\" \/><\/p>\n<p>10. Import completed, \u532f\u5165\u5b8c\u7562<br \/>\n <img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1044572136.png\" alt=\"\" title=\"toad10\" width=\"600\" height=\"322\" class=\"alignnone size-full wp-image-350\" srcset=\"https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1044572136.png 600w, https:\/\/j178.mtgbb.com\/wp-content\/uploads\/2008\/07\/1044572136-300x161.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Toad Data Import (from XLS) 1. Menu \u2192 Database \u2192 Import &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-150","post","type-post","status-publish","format-standard","hentry","category-database"],"_links":{"self":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts\/150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=150"}],"version-history":[{"count":0,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts\/150\/revisions"}],"wp:attachment":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=150"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}