Quote Originally Posted by ButterflyPressInk View Post
New Post: Attribute File has Mismatched Headers and Data

It was because EPA version 3.03 promised:
"Bugfix: attributes export file header names corrected - caused broken attributes upload."
that I paid for the Advanced version of EP. However, it does not seem to have helped (see below.) The attribute headers are still wrong. the headers are picking up option names/values that have been deleted from the db while the actual data is ok, i think.

I AM DEAD IN THE WATER WITHOUT THIS. my site depends on pricing by attributes so I really, really, really need help!

I copied one piece of the txt file and transposed it to show the mismatch:

v_attribute_options_id_20 21
v_attribute_options_name_20_en Select Print Size:
v_attribute_values_id_20_1 66
v_attribute_values_price_20_1
v_attribute_values_name_20_1_en 4" x 6"
v_attribute_values_id_20_2 67
v_attribute_values_price_20_2
v_attribute_values_name_20_2_en 5" x 7"
v_attribute_values_id_20_3 68
v_attribute_values_price_20_3
v_attribute_values_name_20_3_en 8" x 10"

See how the option id =20 but the value of the id is =21? I deleted option id#20 in the db but the data is correct for id#21.

Please help! I have posted this to the zencart builder forum, i have sent a ticket [YZN-54237-446] to Nicholas with no reply and I have searched all messages and k-bases to no avail. TO whomever can help, THank you, thank you, thank you!
Well, I still have heard ZILCH from Nicholas or anybody else on this post - I am actually going to give up and do the attributes manually because I have wasted waaaaaayyyy too much time not being able to fix this!!!

But here's an update which may or may not tie into others's issues:
1. I had to use Open Office to open the attributes txt file because My Mac Excel 2004 won't recognize more than 200 something columns. OO actually recognized utf8 and handles the file well.

2. I chop up the att txt file into smaller pieces so i can convert them to .xls

3. I work in Excel and save the .xls to tab delimited .txt file. (xls to txt works great for EP's Full_ or EPA's Store_ files. The uploads work well.)

What's worked so far for attributes:
1. If I chop up the file to only my first option id - that's never been deleted - the db update works fine.

2. If I select just option id # 21 which is referred to as #20 since I had a deletion before it, I can't get either file to work:
a. the file with headers called #20 and data called #21, nor
b. where i've changed the headers to match the data as id #21

What's weird is that both of them report "products updated successfully." but when I go in thru phpmyadmin, nothing has been changed at all whatsoever.


Have I chopped up the file too much? Or does EP's att headers (or EPA's for that matter) JUST NOT WORK???

ALSO, Does anybody know how to export/import safely using PHPMyAdmin? Export as csv? What import options do you use???

Good luck to us all!!!