Easy Populate 1.2.5.4 support

[elkbow]

Not really correct...

A TXT file is a TXT file - not an Excel File.

TXT files can be IMPORTED into Excel, as long as you tell Excel what the delimiter is. (the FIELD delimiter).

The delimiter can actually be ANY CHARACTER - a space, a comma, a tab, a percentage sign, a semi colon...

Usually, the field delimiter in a TXT file is a TAB or a COMMA. (Though when it's a COMMA, it is usually saved as a CSV file (Comma-Separated-Values).

Unfortunately, we cannot give you lesson on how to use spreadhseets. Find a tutorial on the web.

Ah, sorry about that. Meant to say a .txt will open in Excel. I wonder when they will seperate in this forum, the fact that there are multiple EP versions since this is 1.2.5.4 which I have never had a problem within 9 stores and questions still come up for 1.2.5.6 and 1.2.5.7 ???

[wmorris]

I am experimenting the mod. When I download it then import to excel and do a few changes. When I move one item to another category and delete from the old category and up load it to the database it still show in the old category. what is that?

[wmorris]

I hate this mod. it is causing more problems. What it is doing is. When move a product to another category (Not Copy) it is copying the category as a new category. And its link a product to another category. I just hate this mod.

[moryoav]

I need the csv/txt files that are saved in the tmp dir to be saved with UTF8 encoding. How do I do that?

Thanks!

Y.

[schoolboy]

I hate this mod. it is causing more problems. What it is doing is. When move a product to another category (Not Copy) it is copying the category as a new category. And its link a product to another category. I just hate this mod.

It can be frustrating, but you have to "think like a computer" when you work with easy populate.

Computers are incredibly stupid, but absolutely obedient. They will do EXACTLY what you tell them to do!

In your case, if you do not REMOVE the product from the ORIGINAL category before changing it to the NEW category, both easy populate and zencart will assume that you want to LINK the products.

So, after you get your first easy populate file dump you must work out what the V_STATUS needs to be... If you want to MOVE products, you will first have to DELETE them.

So your first RUN of easy populate back into the store will be a v_status = 9 for all products you want to move.

I usually create a seaprate spreadsheet for these products, because once I have done the v_status = 9 upload, I then take the SAME spreadsheet, change the categories, then make v_status = 1.

Then I run that file through EP again.

The second time, (As there are NO products of that model number in the database) easy populate adds them as NEW products into the different categories.

PS... when using v_status=9, be sure to BACKUP all data... AND backup your images folder... v_status=9 will delete the product and its image...

[wmorris]

I was using this version Easy Populate is 1.2.5.7.csv and I had to uninstall it then install the Version 1.2.5.4 I am getting errors like these:

Admin on the top page in pink color:

EasyPopulate uploads folder not found!
NIX SERVERS: Your uploads folder is either missing, or you have altered the name and/or directory of your uploads folder without configuring this in EasyPopulate.
WINDOWS SERVERS: Please request your web host to assign write permissions to the uploads folder. This is usually granted through Windows server user account IUSR_COMPUTERNAME.
Your configuration indicates that your uploads folder is named tempEP/, and is located in /home/content/m/o/r/morristech/html/, however this cannot be found.
EasyPopulate cannot upload files until you have provided an uploads folder with read/write/execute permissions for the site owner (chmod 700)

and this when I try install the MySQL file:

1062 Duplicate entry 'EASYPOPULATE_CONFIG_TEMP_DIR' for key 2
in:
[INSERT INTO configuration VALUES ('', 'Uploads Directory', 'EASYPOPULATE_CONFIG_TEMP_DIR', 'temp/', 'Name of directory for your uploads (default: temp/).', last_insert_id(), '0', NULL, now(), NULL, NULL), ('', 'Upload File Date Format', 'EASYPOPULATE_CONFIG_FILE_DATE_FORMAT', 'm-d-y', 'Choose order of date values that corresponds to your uploads file, usually generated by MS Excel. Raw dates in your uploads file (Eg 2005-09-26 09:00:00) are not affected, and will upload as they are.', last_insert_id(), '1', NULL, now(), NULL, 'zen_cfg_select_option(array("m-d-y", "d-m-y", "y-m-d"),'), ('', 'Default Raw Time', 'EASYPOPULATE_CONFIG_DEFAULT_RAW_TIME', '09:00:00', 'If no time value stipulated in upload file, use this value. Usefull for ensuring specials begin after a specific time of the day (default: 09:00:00)', last_insert_id(), '2', NULL, now(), NULL, NULL), ('', 'Split File On # Records', 'EASYPOPULATE_CONFIG_SPLIT_MAX', '300', 'Default number of records for split-file uploads. Used to avoid timeouts on large uploads (default: 300).', last_insert_id(), '3', NULL, now(), NULL, NULL), ('', 'Maximum Category Depth', 'EASYPOPULATE_CONFIG_MAX_CATEGORY_LEVELS', '7', 'Maximum depth of categories required for your store. Is the number of category columns in downloaded file (default: 7).', last_insert_id(), '4', NULL, now(), NULL, NULL), ('', 'Upload/Download Prices Include Tax', 'EASYPOPULATE_CONFIG_PRICE_INC_TAX', 'false', 'Choose to include or exclude tax, depending on how you manage prices outside of Zen Cart.', last_insert_id(), '5', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'), ('', 'Make Zero Qty Products Inactive', 'EASYPOPULATE_CONFIG_ZERO_QTY_INACTIVE', 'false', 'When uploading, make the status Inactive for products with zero qty (default: false).', last_insert_id(), '6', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'), ('', 'Smart Tags Replacement of Newlines', 'EASYPOPULATE_CONFIG_SMART_TAGS', 'true', 'Allows your description fields in your uploads file to have carriage returns and/or new-lines converted to HTML line-breaks on uploading, thus preserving some rudimentary formatting (default: true).', last_insert_id(), '7', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'), ('', 'Advanced Smart Tags', 'EASYPOPULATE_CONFIG_ADV_SMART_TAGS', 'false', 'Allow the use of complex regular expressions to format descriptions, making headings bold, add bullets, etc. Configuration is in ADMIN/easypopulate.php (default: false).', last_insert_id(), '8', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'), ('', 'Debug Logging', 'EASYPOPULATE_CONFIG_DEBUG_LOGGING', 'true', 'Allow Easy Populate to generate an error log on errors only (default: true)', last_insert_id(), '9', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Can someone help me fix this?

[wmorris]

I have fixed my problem

[Ajeh]

What was the solution that you discovered worked for you?

[wmorris]

I have an issue.

When I do a change to experiment with.

I have an item is "#13129"

It was on lets say Category 1 and I move it Category 2.

its shows this:

#13129 Category 1 so I deleted Category 1 to Category 2

Then when I upload it to the db I get duplicates (Links) Catorgies so Its not moving that product to another categories. What am I doing wrong?

[wmorris]

It can be frustrating, but you have to "think like a computer" when you work with easy populate.

Computers are incredibly stupid, but absolutely obedient. They will do EXACTLY what you tell them to do!

In your case, if you do not REMOVE the product from the ORIGINAL category before changing it to the NEW category, both easy populate and zencart will assume that you want to LINK the products.

So, after you get your first easy populate file dump you must work out what the V_STATUS needs to be... If you want to MOVE products, you will first have to DELETE them.

So your first RUN of easy populate back into the store will be a v_status = 9 for all products you want to move.

I usually create a seaprate spreadsheet for these products, because once I have done the v_status = 9 upload, I then take the SAME spreadsheet, change the categories, then make v_status = 1.

Then I run that file through EP again.

The second time, (As there are NO products of that model number in the database) easy populate adds them as NEW products into the different categories.

PS... when using v_status=9, be sure to BACKUP all data... AND backup your images folder... v_status=9 will delete the product and its image...

Sorry I still don't like this mod. its wastes my time typing everything in and will take forever.