Quote Originally Posted by chadderuski View Post
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:
Code:
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