Easy Populate 1.2.5.4 support

[Ariejester]

Hi, Ive installed easy populate but when uploading the .txt file I got:

No model field in record. This line was not imported

So I created all the categories via zencarts admin for my products which match those in the .csv and the tab text file.
But whenever I upload the .txt file I still get the same problem. Also when I check the actual site it has created lots more categories with no products in them, the categories are all numbers such as:

0.01
0.02
0.03
0.04
0.05

etc. etc.

Can someone tell me where I'm going wrong. As when I upload the dvd example spreadsheet thats in the temp file that works. I have double and triple checked the headings for each column and the model one which is the first one is titled

v_products_model

which seems to be correct as it matches the one in the dvd file that works. I have downscaled my list to 200 products to see if that works, as there are approx 3000 products in total.

The headers Im using are (in actual spreadsheet order):

v_products_model
v_products_image
v_products_name_1
v_products_description_1
v_products_description_2
v_products_description_3
v_products_description_4
v_products_price
v_products_weight
v_manufacturers_name
v_categories_name_1
v_categories_name_2
v_categories_name_3
EOREOR (what is this by the way? - Ive kept it in for now - can I delete this column)

Any help would be appreciated as I'm completely stuck and cannot see what I've done wrong!

[kyates]

I'm having loads of hassle with Easy Populate. Any help appreciated!

I've installed it, and can even use it to upload a product, but it won't upload more than one product at a time.

I've downloaded my original file from Easy Populate, and i'm using Excel to edit it. The file is then saved as Tab Delimited format from Excel and uploaded. Everytime I add a new product, it just replaces the last one.

I've tried to upload the Tab Delimited file with about 300 products, but it just doesn't do it. The Easy Populate page displays that the product has been updated, but it just replaces the last one in the database and none of the others are there.

Has anyone experienced this?

Could it be something to do with formatting in Excel such as bullet points?

Heeeeeellllllllp Meeeeeeeeee

Ky

[kbmets7]

I'm having loads of hassle with Easy Populate. Any help appreciated!

I've installed it, and can even use it to upload a product, but it won't upload more than one product at a time.

I've downloaded my original file from Easy Populate, and i'm using Excel to edit it. The file is then saved as Tab Delimited format from Excel and uploaded. Everytime I add a new product, it just replaces the last one.

I've tried to upload the Tab Delimited file with about 300 products, but it just doesn't do it. The Easy Populate page displays that the product has been updated, but it just replaces the last one in the database and none of the others are there.

Has anyone experienced this?

Could it be something to do with formatting in Excel such as bullet points?

Heeeeeellllllllp Meeeeeeeeee

Ky

Do you have this field at the top, and at the end of every row: EOREOR?

it tells the program that it is the end of one product, and another product is on the next line. If you don't it will only read the first product.

[newbird]

Hi,

I'm trying to install Easy Populate 1.2.5.5 for Zen Cart 1.3.8a. My system is running MySQL 5.

I received the following message after clicking on install:
"Easy Populate Configuration Missing. Please install your configuration by clicking here".

So I clicked "here" and received the following.

"Success Installation Successfull! A full download of your store has been done and is available in your uploads (temp) directory. You can use this as your 1st template for uploading/updating products."

Why is it that I don't have to run install.sql as mentioned below? I'm worried that I have messed up something.

Regards.

If anyone is needing this the install.sql file for the database for MySql 5

# MySql 5 Config 
# Install Easy Populate Configuration v1.2.5.4
INSERT INTO `configuration_group` VALUES (NULL, 'Easy Populate', 'Config options for Easy Populate', '1', '1');

UPDATE `configuration_group` SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

INSERT INTO `configuration` VALUES (NULL, 'Uploads Directory', 'EASYPOPULATE_CONFIG_TEMP_DIR', 'temp/', 'Name of directory for your uploads (default: temp/).', last_insert_id(), '0', NULL, now(), NULL, 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"),'),
(NULL, 'Default Raw Time', 'EASYPOPULATE_CONFIG_DEFAULT_RAW_TIME', '09:00:00', 'If no time value stipulated in upload file, use this value. Useful for ensuring specials begin after a specific time of the day (default: 09:00:00)', last_insert_id(), '2', NULL, now(), NULL, 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),
(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),
(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"),'),
(NULL, '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"),'),
(NULL, '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"),'),
(NULL, '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"),'),
(NULL, '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"),'); 

Enjoy !

[kbalona]

I bought EP Advanced and just finished uploading over 12,000 products to my store. After a few tests (because I didn't know what I was doing) I uploaded without a hitch and all the products display fine. Well worth the $65.

[newbird]

Anyway, just for the record, I did manage to upload my products (tried 50 items at one go) successfully. Really convenient, saved me quite a bit of time.

[jaskarn]

hi,
is there any limit on how many products can be uploaded at one time. my supplier gives me a file with over 37000 products and every time i upload or download to zencart it takes ages.

[erika_311]

I downloaded my .txt file through EZ popluate. I then edited my products (I didn't origianlly have a model number with some of them so I added a model number). I uploaded the .txt file through EZ popluate, added it to the database.

It created duplicate products instead of overwriting the original product. Am I doing something wrong?
Thank you for your time. I love this contribution, I am just confused I think.

[lkzone]

Newbird, you wrote>>Why is it that I don't have to run install.sql as mentioned below? I'm worried that I have messed up something.

In the install.txt it said to only run the SQL if the config install fails. It sounds like your config install went fine. And I saw that you had success uploading products, so that's great.

My Issues:

1) Knowing the answer is out there somewhere...Why am I getting
"No model field in record. This line was not imported | | | | | " after I upload?

2) When I attempt to browse to my txt file, the Upload function doesn't execute but if I load my txt file to the temp folder and use that "form" (Import from Temp Dir (temp/), the upload does execute correctly. Has anyone seen this?

I would LOVE to see this thread/forum split up by the moderator!!

Thanks.

[misty]

It created duplicate products instead of overwriting the original product. Am I doing something wrong?

No that is correct. Easy Populate is governed by model numbers.. your original
products did not have any, so as far as EP is concerned, products did not exist;
so it added them for you, using model numbers you entered.