Easy Populate 1.2.5.4 support

Here is an image of what I am talking about:

bkeaton:

I have downloaded the other version and I don't like it. You have to type everything in that is what I don't want. Typing it in is wastes my time. Is there another way to do this?

Type into what?

At some point, someone is going to have to CREATE the data relating to a product (unless you are a magician and can get the computer to do this by itself).

So even if the data is originally captured on paper, carved in stone, scrawled on payrus, written with a stick on beach sand... the fact is that the data is created by a person.

So, by getting the data into a spreadsheet all you do is save a lot of time. Once you have this in spreadsheet format, saving it to Easy Populate formats is quick and straightforward.

The image you provide is OsCommerce... what relevance does it have to zencart?

hello I did a wrong thing with EP, I insert wrong prices for 200 products.
Now when I change and reupload the file with right prices, I see always old files, why?

Please :frusty:

sorry solved I had saved wrong the file to upload :P

schoolboy:

Type into what?

At some point, someone is going to have to CREATE the data relating to a product (unless you are a magician and can get the computer to do this by itself).

So even if the data is originally captured on paper, carved in stone, scrawled on payrus, written with a stick on beach sand... the fact is that the data is created by a person.

So, by getting the data into a spreadsheet all you do is save a lot of time. Once you have this in spreadsheet format, saving it to Easy Populate formats is quick and straightforward.

The image you provide is OsCommerce... what relevance does it have to zencart?

I know its from OsCommerce is there a way we can make an add-on like this for Zen-Cart?

schoolboy:

1.2.5.4 is available HERE

Why this version is using text file instead of excel. To me you have to through to look what you are looking for it wastes time. I just don't like it at all.

bkeaton:

Why this version is using text file instead of excel. To me you have to through to look what you are looking for it wastes time. I just don't like it at all.

Ah, Text file known as .txt is a Excel file. Open the file in Excel.

It will not open up as an excel file.

bkeaton:

I know its from OsCommerce is there a way we can make an add-on like this for Zen-Cart?

Yes... of course you can. Zencart is opensource so you can do whatever you like when creating modules. When you've finished it, maybe you'd like to put it in the Free Add-ons. I have a couple of modules I built in the free add-ons, so there's no reason why you can't have some there too...

elkbow:

Ah, Text file known as .txt is a Excel file. Open the file in Excel.

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.

I'm using EP to set up my shop-
I set it up working, with various attributes, with set prices, NOT '+' prices.

Then I downloaded the EP file, so I could see the way it laid out the attributes etc, and copied them for all the products I needed.

When I uploaded it all again, although all the attributes are now present on all the items, they are all '+' Prices.

Is there a way of changing this in EP instead of editing each product?

schoolboy:

Yes... of course you can. Zencart is opensource so you can do whatever you like when creating modules. When you've finished it, maybe you'd like to put it in the Free Add-ons. I have a couple of modules I built in the free add-ons, so there's no reason why you can't have some there too...

It would be nice if someone can make a module for the Multiple Products. I am not very good in PHP but I am trying.

schoolboy:

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

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?

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.

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.

bkeaton:

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

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?

I have fixed my problem

What was the solution that you discovered worked for you? :smile: