Updated Bulk Export/Import module

Post by jty » Fri Oct 17, 2008 10:31 pm

Hello
Just wondering, is there an "append" version of this module?
Cuz - I'm adding fields and it looks like everytime I import, it cleans out the database and re-inserts the whole spreadsheet
But I don't know how to mod this module to include my new fields so I'm losing my tailor-made data fields

I'm probably asking for too much again 

Post by Qphoria » Fri Oct 17, 2008 11:56 pm

Post by jty » Sat Oct 18, 2008 12:31 am

Post by Qphoria » Sat Oct 18, 2008 2:07 am

Post by jty » Sat Oct 18, 2008 2:32 am

Yeah, something like that.
The Franscais Carte appends new rows without touching the current ones but that's about all that's great about it.
I'm thinking about people with 10,000+ products and additional modded fields
If they had other fields not in the import, they would have a nightmare inputting all 10,000+ products x 5 options and import them at once and then go hunting for the data corruption.
If, on the other hand, the import didn't touch the existing rows, they could do them by eg categories. Check it, if it's OK, do the next category.
In my situation, I got lost with the options and matching it to the product ID 

Post by bruce » Sat Oct 18, 2008 6:22 pm

Update would then not delete any products that you wanted to remove via the spreadsheet.

The product_id is maintained by import/export so perhaps a better way of implementing additional fields would be in a separate table from the core design. You still have to change the sql statements for getting product information into your store to join to the new table but since you are already changing the templates, it is not too much extra effort.

This way, the core import/export works out of the box for everyone and your custom fields are not trashed when you import and the links are preserved.

The only downside (every silver lining has a cloud  ) is that you cannot load the short description using import/export.

Post by jty » Sat Oct 18, 2008 6:52 pm

Post by Qphoria » Sat Oct 18, 2008 8:22 pm

bruce wrote: every silver lining has a cloud 

LOL I'm pretty sure that's not how the saying goes....

Post by red8ii8 » Sat Nov 08, 2008 2:54 am

Post by bruce » Sat Nov 08, 2008 6:52 am

Post by Tomas_cze » Sat Nov 15, 2008 1:02 am

<b>Warning</b>:  tempnam() [<a href='function.tempnam'>function.tempnam</a>]: open_basedir restriction in effect. File() is not within the allowed path(s): (/data/www/www_exit-site_com) in <b>/data/www/www_exit-site_com/shop/admin/OLE/PPS/File.php</b> on line <b>87</b><br />

Post by JNeuhoff » Sat Nov 15, 2008 1:52 am

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig

Post by Tomas_cze » Sat Nov 15, 2008 2:16 am

Post by yl » Tue Dec 23, 2008 12:09 pm

Post by yl » Tue Dec 23, 2008 1:34 pm

After I removed the file .htaccess I got the admin login back. Problem solved!!

Post by yl » Tue Dec 23, 2008 2:13 pm

Post by yl » Tue Dec 23, 2008 2:28 pm

Post by JNeuhoff » Tue Dec 23, 2008 9:50 pm

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig

Post by Qphoria » Wed Dec 24, 2008 12:54 am