EasyPopulate 4.0 Support Thread

chadderuski:

Hi Seth,

EP4 will not assign random numbers to your products on upload. This will generate an error, and that data line will be skipped. Your copy must have been modified at some point.

1.2.5.4 does have a bug concerning Manufacturers. This has been fixed in EP4.

You need ONLY used Open Office to create your CSV from your .xls file. So you can continue to work normally with excel, and then only use OO to open your xls and export your CSV. At some point in the future I'll revisit the excel issue, but that will be after I've completed attributes and some other planned improvements. EP4 is also UTF-8 aware so users can properly use it with mult-byte languages. I do not believe that EP 1.2.5.4 handles multi-byte characters correctly.

Note: you can install EP4 along side your EP 1.2.5.4. Just be aware that the upload files are very different.

-chadd

Hi

Thanks for the quick response :smile:

Your version seems perfect, however I have one problem.
I have narrowed the source of the random manufacturers down to when I upload the Model/Price/Quantity file in the previous EP (this is odd because there isn't even a manufacturer tab in the file :unsure: )

The solutions would be to use your new version, but your columns are not arranged in the order I need for my excel update file.
Is there any way I can re-arrange the order of the tabs (v_products_model, etc)

Thanks
S

I downloaded and installed Easy Populate 4.0-9773477 yesterday. I am able to download a files but when I upload and import I get nothing. I even tried downloading 1 category, deleting the items from that category and uploading the file I just downloaded. Nothing. I am running php 4.4.9 (Zend: 1.3.0), Zencart 1.3.9 and did use OpenOffice to create my csv files and follow the directions in the beginning of these posts. This is the error in my debug file (admin directory changed here for security purposes)

PHP Warning: array_flip() [<a href='function.array-flip'>function.array-flip</a>]: The argument should be an array in /homepages/39/e339678439/htdocs/zencart/admin/easypopulate_4_import.php on line 66.

What am I doing wrong?

SethF:

Hi

Thanks for the quick response :smile:

Your version seems perfect, however I have one problem.
I have narrowed the source of the random manufacturers down to when I upload the Model/Price/Quantity file in the previous EP (this is odd because there isn't even a manufacturer tab in the file :unsure: )

The solutions would be to use your new version, but your columns are not arranged in the order I need for my excel update file.
Is there any way I can re-arrange the order of the tabs (v_products_model, etc)

Thanks
S

Hi

Please disregard this post. I re-wrote my update file to understand EP4's column arrangement.

This addon has solved my manufacturer issue :smile: The only problem I have is that I have to use open office. Please could you add Excel support with future versions.

Thanks
S

SethF:

Hi

Thanks for the quick response :smile:

Your version seems perfect, however I have one problem.
I have narrowed the source of the random manufacturers down to when I upload the Model/Price/Quantity file in the previous EP (this is odd because there isn't even a manufacturer tab in the file :unsure: )

The solutions would be to use your new version, but your columns are not arranged in the order I need for my excel update file.
Is there any way I can re-arrange the order of the tabs (v_products_model, etc)

Thanks
S

Hey Seth. Column order should not matter. Do a test with just 1 line of data.
It's the column headers that MUST be correct (and NO SPACES at the end of the either, i.e. "v_products_model ").

Sharemmoments:

I downloaded and installed Easy Populate 4.0-9773477 yesterday. I am able to download a files but when I upload and import I get nothing. I even tried downloading 1 category, deleting the items from that category and uploading the file I just downloaded. Nothing. I am running php 4.4.9 (Zend: 1.3.0), Zencart 1.3.9 and did use OpenOffice to create my csv files and follow the directions in the beginning of these posts. This is the error in my debug file (admin directory changed here for security purposes)

PHP Warning: array_flip() [<a href='function.array-flip'>function.array-flip</a>]: The argument should be an array in /homepages/39/e339678439/htdocs/zencart/admin/easypopulate_4_import.php on line 66.

What am I doing wrong?

What version of PHP are you using? PHP4 can act strange with array_flip(). You should ask your host to upgrade you to PHP5 if you are on still on PHP4. There are a couple of other PHP4 related issues also.

Alternatively, the first line of your CSV file is "wrong". PM or attach a copy of your CSV file and I'll look at it.

Hi. I installed EasyPopulate per instructions, but I must have done something wrong. It seems to have installed correctly from the zen admin tool, I click on Tools | Easy Populate 4, and it loads the EP page.

When I click the upload button, I'm shot straight to my ZC Admin login page. Even if I manually upload the file to the temp directory, when i click import it does the same thing. I'm confused!

Andy

I'm sorry, I forgot to mention that there were no errors reported in my error log.

adiamond:

I'm sorry, I forgot to mention that there were no errors reported in my error log.

I have seen this happen when zencart was installed via a CPANEL script, and the url's for the store were improperly recorded in the config.php files.

Check your configuration files and look for something like this: http://www.mystore.com//myadmin
See that second pair "//" ??? That should only be one like this: http://www.mystore.com/myadmin

I saw this very recently with another user and was able to fix it with just a few clicks to correct cofigure.php, just be sure to fix both copies in the admin and includes directories.
This will also mess with EP 1.2.5.4 which has come up from time to time. If this isn't the cause, I'd have to look at your install. You can PM me and I'll see what I can do to help.

-Chadd

Hi, thanks for your help. You were right, there were numerous extra "/" in the configure files. I've corrected them and at least it doesn't shoot me back to the login screen anymore! However, when I click import this time - of the example files in the EP folder, I get:

SKIPPED: model not found:TEST RGB
SKIPPED: model not found:TEST CMYK

SKIPPED: model not found:TEST 1
SKIPPED: model not found:TEST 2

adiamond:

Hi, thanks for your help. You were right, there were numerous extra "/" in the configure files. I've corrected them and at least it doesn't shoot me back to the login screen anymore! However, when I click import this time - of the example files in the EP folder, I get:

SKIPPED: model not found:TEST RGB
SKIPPED: model not found:TEST CMYK

> 
> 
> ```
SKIPPED: model not found:TEST 1
SKIPPED: model not found:TEST 2

Those two example files are for the basic attribute importing only. You would first have to create those products, and then import attributes to them.

Add a category and product normally through the zencart admin, then do a full export. This will give you your file format and column headers.

-chadd

Ok, it is properly creating the export .csv file, and I can download it manually via ftp. If I left click the "Download" link I get a 500 error, and if I right click the Download link and do a "save as" the file is filled with the same 500 error. So, I believe it has something to do with adding the proper permissions in my .htaccess file, in the temp directory. I read something in the instructions about adding "allow" in my .htaccess file for .txt and .csv files, but I'm not sure what code I need to add to my .htaccess file to accomplish this.

Thanks!

adiamond:

Ok, it is properly creating the export .csv file, and I can download it manually via ftp. If I left click the "Download" link I get a 500 error, and if I right click the Download link and do a "save as" the file is filled with the same 500 error. So, I believe it has something to do with adding the proper permissions in my .htaccess file, in the temp directory. I read something in the instructions about adding "allow" in my .htaccess file for .txt and .csv files, but I'm not sure what code I need to add to my .htaccess file to accomplish this.

Thanks!

You can put an .htaccess in your temp folder (say under your secret admin). This has worked for me (someone may have a cleaner version):

DirectoryIndex index.php

# deny *everything*
<FilesMatch ".*\..*">
  Order Allow,Deny
 # Deny from all
</FilesMatch>

# but now allow just *certain* necessary files:
<FilesMatch "(^$|^favicon.ico$|.*\.(php|js|css|jpg|gif|png|csv|txt|log)$)">
  Order Allow,Deny
  Allow from all
</FilesMatch>

IndexIgnore */*

# The following makes adjustments to the SSL protocol for Internet Explorer browsers
<IfModule mod_setenvif.c>
  <IfDefine SSL>
    SetEnvIf User-Agent ".*MSIE.*" \
             nokeepalive ssl-unclean-shutdown \
             downgrade-1.0 force-response-1.0
  </IfDefine>
</IfModule>

That worked great! Thank you!

chadderuski:

Hi Kerry,

Hmmm. Yes, I never quite understood why EP 1.2.5.4 would allow you to upload price with tax, only to calculate the price without tax before inserting into the database, or why that would be useful. But I left this code in place. I figured this may help in other countries. In the US, better to calculate tax at checkout.

Go to Configuration -> Easy Populate 4 and set "Upload/Download Prices Include Tax" to true. Test that and let me know if that works for you as expected.

Sorry Chadderuski, there was a lot of problems I had with EP4 so I've gone back to the older working version

I will check with my web hosting company to see about the php version getting upgraded. In the mean time here is a copy of the csv file I was trying to upload.

Sharemmoments:

I will check with my web hosting company to see about the php version getting upgraded. In the mean time here is a copy of the csv file I was trying to upload.

Your data structure looks fine.

However, you will need to use unique v_products_model numbers. Each of the 3 records in the data had the same products_model. What happens in this instance is that each successive duplicate over writes the previous record's data.

The ONE exception (and it needs careful checking) is where you want to LINK a product to another category. To do this you would duplicate the record as is, and then ONLY change the Category. Best to keep those records together.

Your host should upgrade for free. PHP 4 has been deprecated and there is really no reason to not upgrade. I would even hazard to guess that your php predates 4.2... If your host won't upgrade, look for a new provider. No reason to be running php 4.

chadderuski:

Your data structure looks fine.

However, you will need to use unique v_products_model numbers. Each of the 3 records in the data had the same products_model. What happens in this instance is that each successive duplicate over writes the previous record's data.

The ONE exception (and it needs careful checking) is where you want to LINK a product to another category. To do this you would duplicate the record as is, and then ONLY change the Category. Best to keep those records together.

Your host should upgrade for free. PHP 4 has been deprecated and there is really no reason to not upgrade. I would even hazard to guess that your php predates 4.2... If your host won't upgrade, look for a new provider. No reason to be running php 4.

Thanks, I will contact my ISP. I know they are doing an upgrade to the Linux OS next week so I will see if PHP is getting updated as well and then try again. Thanks for the information on the products_model. All of the existing products have the same model so I will know going forward to change that and then work to change those already listed.

I have just installed the easypopulate 4.0 to my site which is using 1.5.0v upgrade. But everytime I try to import a file I get logged out and somer one please help. I followed all the instruction so I am lost now. my site is buybackissuesonline.com

Check back 10 posts, #128, and see if you have the same problem I did. Basically, in your include/configure.php files, your host app that installed zen cart may have inadvertently inserted a bunch of extra "/"'s in all the paths. If your address looks like http://example.com//admin when you access your admin interface, then that's probably the case. if it is, you need to go through both of your configure files, line by line and delete all the extra "/"s.

I did check my configure and found obout 4 instances of // and the end of the url's. All of the rest has just one /'