Easy Populate 1.2.5.4 support

[ButterflyPressInk]

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!!!

[misty]

I work in Excel and save the .xls to tab delimited .txt file.

Try using Open Office.. works much better with EP than excel.

[ButterflyPressInk]

Try using Open Office.. works much better with EP than excel.

I would but I can't save from OO to a tab delimited .txt file. I'm using OO 3.0 beta. What format do you save it to so that EP accepts it?

[misty]

I would but I can't save from OO to a tab delimited .txt file. I'm using OO 3.0 beta. What format do you save it to so that EP accepts it?

Has to be .csv format

[chadderuski]

Has to be .csv format

Just to add to Misty... once you select .csv it will give you the option of which delimeters to use. Here is where you'll select TAB.

-cj

[timbo77]

I just downloaded easy pop. and now i need to know were to put the files first folder is admin 2 is temp
I'm totally new to this and need help.
plus do I have to edit any php.

Thank you

[minshop.no]

I just downloaded easy pop. and now i need to know were to put the files first folder is admin 2 is temp
I'm totally new to this and need help.
plus do I have to edit any php.

Thank you

Hi Timbo77.

I just did the install yesterday, and there is a step-by-step guide in the Install.txt file in the package you downloaded which will guide your way through.

Remember to backup your database and files before trying. You will find guides on how-to if your search this forum for backup.

Good luck

[timbo77]

I don't know why this is happening can someone help me please

Warning: move_uploaded_file(/home/tcgifts/public_html/gifts/temp/Full-EP2008Jun02-2311.txt) [function.move-uploaded-file]: failed to open stream: Permission denied in /home/tcgifts/public_html/gifts/admin/includes/functions/extra_functions/easypopulate_functions.php on line 57

Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move '/tmp/phplEbLEv' to '/home/tcgifts/public_html/gifts/temp/Full-EP2008Jun02-2311.txt' in /home/tcgifts/public_html/gifts/admin/includes/functions/extra_functions/easypopulate_functions.php on line 57

Warning: file(/home/tcgifts/public_html/gifts/temp/Full-EP2008Jun02-2311.txt) [function.file]: failed to open stream: No such file or directory in /home/tcgifts/public_html/gifts/admin/easypopulate.php on line 1201

Warning: Invalid argument supplied for foreach() in /home/tcgifts/public_html/gifts/admin/easypopulate.php on line 1301


Thank you

[awhfy99]

I don't know why this is happening can someone help me please

Warning: move_uploaded_file(/home/tcgifts/public_html/gifts/temp/Full-EP2008Jun02-2311.txt) [function.move-uploaded-file]: failed to open stream: Permission denied in /home/tcgifts/public_html/gifts/admin/includes/functions/extra_functions/easypopulate_functions.php on line 57

Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move '/tmp/phplEbLEv' to '/home/tcgifts/public_html/gifts/temp/Full-EP2008Jun02-2311.txt' in /home/tcgifts/public_html/gifts/admin/includes/functions/extra_functions/easypopulate_functions.php on line 57

Warning: file(/home/tcgifts/public_html/gifts/temp/Full-EP2008Jun02-2311.txt) [function.file]: failed to open stream: No such file or directory in /home/tcgifts/public_html/gifts/admin/easypopulate.php on line 1201

Warning: Invalid argument supplied for foreach() in /home/tcgifts/public_html/gifts/admin/easypopulate.php on line 1301


Thank you

I'm assuming that you read the instructions, and you have a /temp folder created and it's permissions are set correctly (it is chmod 777). If that is not the case, try that first, as that is the most likely cause!

[maxim]

Greetings all,

I have large files to import, which I was previously able to upload via splitting the file. Recently, the server on my host - hostgator - hasn't been allowing me to split or upload files properly. The host gave me SSH access - mind you, I'm a newbie here - to do the upload. (I'm using putty for SSH.)

Here are my questions:

1) I noticed in tutorials on SSH that the file name ends in ".sql". Should I use that extension or use the ".txt" extension on my file?

2) The host recommended that I not split the file. Do I need to change anything on the Easy Populate configuration since I'm not splitting the file?

Any and all advice is appreciated. I may not be able to reply to responses right away...the toddler might need its momma.

Thanks a bunch.

Newbie Linda