videobus Posted May 20, 2006 Share Posted May 20, 2006 I've finally got EP to work, but can't figure out why it's inserting each item 2x, first in the correct category, and second one into wrong product categories. When I compared the import text file with the categories, it insert the first one in the correct category, and then the same item is inserted the second time in the wrong category using the one from item following it. BTW the v_date_avail field is blank and the v_date_added is the date you see in the file. Example: 1st insertion: .COM FOR MURDER Horror (correct category) 2nd insertion: .COM FOR MURDER Gamecube (dup and incorrect category, using the next item's category). 1st insertion: 007 (GAMECUBE) Gamecube (correct category) 2nd insertion: 007 (GAMECUBE) Xbox (dup and incorrect category, using the next item's category). The website is www.mybroadwayvideo.info (not on line yet). Here is a sample of the input file with the heading (I inserted cr/lf after each record to make it easier to read for this post): v_products_model v_products_name_1 v_products_price v_date_avail v_date_added v_products_quantity v_categories_name_1 v_tax_class_title v_status EOREOR 472690 .COM FOR MURDER 0.00 2004-10-01 1 Horror Taxable Goods Active EOREOR 462579 007 (GAMECUBE) 0.00 2004-02-23 1 Gamecube Taxable Goods Active EOREOR 511973 007 AGENT UNDER FIRE 0.00 2006-03-08 2 XBox Taxable Goods Active EOREOR 453996 007 AGENT UNDER FIRE (PS-2) 0.00 2006-03-10 1 Playstation 2 Taxable Goods Active EOREOR 324102 007 AGENT UNDER FIRE (PS2-INST 0.00 2006-03-10 1 Playstation 2 Taxable Goods Active EOREOR 459863 007 AGENT UNDER FIRE (XB) 0.00 2006-03-07 1 XBox Taxable Goods Active EOREOR 502313 007 AGENT UNDER FIRE INST. 0.00 2001-11-27 1 Playstation 2 Taxable Goods Active EOREOR 516151 007 AGENT UNDER FIRE(XB-INSTR) 0.00 2006-03-07 1 XBox Taxable Goods Active EOREOR 517548 007 INST. (GAMECUBE) 0.00 2004-02-23 1 Gamecube Taxable Goods Active EOREOR 459808 007 NIGHTFIRE (GC) 0.00 2006-03-24 1 Gamecube Taxable Goods Active EOREOR I know I'm asking for a lot, but I'm under a tight timetable to get this working. Any help/suggestions/hints will be greatly appreciated. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.