EasyPopulate 4.0 Support Thread

[k9dug]

OK, csv file download problem solved.

There is an .htaccess file in the admin directory (or whatever you have named yours).

In there, by default, only certain file types are allowed in direct HTTP requests:

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

You just need to add "csv" in there too:

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

I don't know if there is an instruction anywhere in the EP4 docs to alter this, or if this update should be part of the install process?...


Always a simple answer. Always a bugger finding it.

[chadderuski]

OK, csv file download problem solved.

There is an .htaccess file in the admin directory (or whatever you have named yours).

In there, by default, only certain file types are allowed in direct HTTP requests:

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

You just need to add "csv" in there too:

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

I don't know if there is an instruction anywhere in the EP4 docs to alter this, or if this update should be part of the install process?...


Always a simple answer. Always a bugger finding it.

Hey K9!

Good catch! The other time I've seen this occur is when your config.php file has some extra slashes in the path directives. This sometimes happens with auto installer in cpanel.

I'll be sure to add your discover to the doc **when** I can get around to finishing them.

-chadd

[double-happiness]

Can anyone help with this please?

My install of Easy Populate is working fine, but is missing from the 'configuration' menu.

I downloaded what looks to be the latest version from http://www.zen-cart.com/downloads.php?do=file&id=868

I've tried to upload the SQL patch to no avail.

MySQL v5.0.9
Zen Cart v1.5.1
EP v1.2.5.7c

[chadderuski]

Can anyone help with this please?

My install of Easy Populate is working fine, but is missing from the 'configuration' menu.

I downloaded what looks to be the latest version from http://www.zen-cart.com/downloads.php?do=file&id=868

I've tried to upload the SQL patch to no avail.

MySQL v5.0.9
Zen Cart v1.5.1
EP v1.2.5.7c

You are not using my EasyPopulate 4. This thread is only for EP4 .... you can download EP4 from the link on the first page.

[double-happiness]

You are not using my EasyPopulate 4. This thread is only for EP4 .... you can download EP4 from the link on the first page.

Thanks for the reply. I'm unsure if I should upgrade or not. I'm a bit puzzled as the documentation says "NO streaming upload or download" but at the same time "To download your exported file, you will need to "right-click, save-as". Download is a must-have feature for me as I need the flle with all product URLs for Google Shopping products feed.

[double-happiness]

Update to my last post...

So I've upgraded to EP4 now. I am getting seriously confused though. When I go to 'Tools' > 'Easy Populate 4', I don't see any option to download my inventory with all the product URLs. Any file I can download via EP4 doesn't have them, I can only get the product URLs via the older version of EP.

I am also now getting huge files down with 7-8,000 items when there only should be 5,300 items in my store. I don't understand why the system is not purging all my existing inventory and replacing it with the 5300 items in my upload?

I've tried to add custom fields including weight and barcode to my product database but that doesn't seem to have worked at all. They all just show as 'FALSE' in the EP4 window. I see there is a field for 'Product UPC Code' under 'Custom Products Fields' but that has 'FALSE' next to it and I have no idea what I'm supposed to do with that.

I am getting really muddled now and I seem to be compounding my problems by adding in extra unknowns and issues. All I want to do is upload my inventory with the weights and barcodes specified for each item, and then download it with the product URLs appended.

[double-happiness]

Now attempting to purge my entire inventory and start from scratch by deleting categories, but it seemed to be too much for the server as the admin page became inaccessible and eventually my site went down altogether for a time, with 'WARNING: An Error occurred, please refresh the page and try again.' Tried to work around by creating extra database users in MySQL and editing /includes/configure.php to the rotating users tweak as on http://www.zen-cart.com/showthread.p...728#post144728 but that didn't work either so I had to switch back. It seems my shop works fine so long as I never try to update the inventory. There has to be an easier way than this... :sighs:

[k9dug]

Hey K9!

Good catch! The other time I've seen this occur is when your config.php file has some extra slashes in the path directives. This sometimes happens with auto installer in cpanel.

I'll be sure to add your discover to the doc **when** I can get around to finishing them.

-chadd

Cheers Chadd.

Now, I am on my way to using this software, I just don't have a manual. I don't want to start throwing switches to see what happens and I don't want to sift through a million forum posts. Can you tell me where to read basic instructions on how to insert and update product attributes?

(In particular, the fields:
products_attributes.options_values_price
products_options.products_options_name
products_options_values.products_options_values_name).

Thanks,

Gav

[chadderuski]

Cheers Chadd.

Now, I am on my way to using this software, I just don't have a manual. I don't want to start throwing switches to see what happens and I don't want to sift through a million forum posts. Can you tell me where to read basic instructions on how to insert and update product attributes?

(In particular, the fields:
products_attributes.options_values_price
products_options.products_options_name
products_options_values.products_options_values_name).

Thanks,

Gav

There are basic instruction on how to import attributes in the README.txt file that was included in the zip you downloaded from github.

Be sure to use Dr. Bytes MySQL Backup Tool... this way you can experiment without and roll back should something go awry.

Also, it is really recommended that you create a mirror of your live install for experimentation and testing. I always create LIVE, MIRROR and TESTING sites. This does take more time and effort initially, but it can really save your behind.

I also use the AutoMySQLBackup VER 2.5.1 to do daily MySQL backups. The script is quite good, and will rotate your old backups according to the schedule you want (daily, weekly, monthly).

-chadd

[k9dug]

There are basic instruction on how to import attributes in the README.txt file that was included in the zip you downloaded from github.

Be sure to use Dr. Bytes MySQL Backup Tool... this way you can experiment without and roll back should something go awry.

Also, it is really recommended that you create a mirror of your live install for experimentation and testing. I always create LIVE, MIRROR and TESTING sites. This does take more time and effort initially, but it can really save your behind.

I also use the AutoMySQLBackup VER 2.5.1 to do daily MySQL backups. The script is quite good, and will rotate your old backups according to the schedule you want (daily, weekly, monthly).

-chadd

OK, now getting somewhere.

I did a fresh install of ZC 1.5.1, with all example products.
Then installed Backup MySQL Plugin, backed up the DB, installed EP4 (all ok).

Then I generated one of each of the 11 types of export file for a copies of the original product data.

As I am specifically interested in creating and updating attributes and attribute prices, I then ran several tests on the file "Attrib-Detailed-EP2013Jun18-134609.csv":

1. Deleted all except for 5 rows showing "MG200MMS" in v_products_model (ie all 5 varieties of a single product).
Altered all the values for v_options_values_price.
Uploaded and imported - all test values appeared correctly in the front end. (Great! - first time this far).

2. Starting with the same 5 rows, I then emptied all columns except
v_products_model
v_products_options_name
v_products_options_values_name
v_options_values_price
These are the ones I am interested in.

This failed and generated the following errors:

Output page top:

Warning File Import Completed with issues.
Warning An SQL error has occured. Please check your input data for tabs within fields and delete these. 
If this error continues, please forward your error log to the Easy Populate maintainer

Output page bottom:

Import Results

Filename: Attrib-Detailed-EP2013-test2-a.csv

SKIPPED! - Attribute Entry on Model: MG200MMS - Not Found!
SKIPPED! - Attribute Entry on Model: MG200MMS - Not Found!
SKIPPED! - Attribute Entry on Model: MG200MMS - Not Found!
SKIPPED! - Attribute Entry on Model: MG200MMS - Not Found!
SKIPPED! - Attribute Entry on Model: MG200MMS - Not Found!
Finished Processing Import File

Updated records: 0
New Imported records: 0
Errors Detected: 5
Warnings Detected: 0
Memory Usage: 6322296
Memory Peak: 6463696
Execution Time: 0.0096170902252197 seconds.

3. I then tried deleting out all columns except for the four I'm interested in.
Same errors as above.

Can you tell me which columns are required and which are optional?

I want to minimise as much as possible the size of the spreadsheet.

Thanks,

gav