Easy Populate 1.2.5.4 support

[tonysebay]

tonysebay - To start you need to do a little fault finding!

# Is this a new issue on a new install?
# Is it a new issue on a old install?
# What editor are you using Excel or Oo, CSVed
# Have you checked the .txt file before import, that the rest of the text appears?
# How many products are you trying to upload at once?

I have checked the SQL update for 1.3.8 and it hasn't changed any values in the Product description values in the database, I would guest its not a Zencart/easypop. problem !

Thanks Scrat, After looking deeper at the problem I noticed that the v_products_description_en was missing on top. Thus not letting me update the text. I noticed a few were having problems with description Cut off using Excel. I found that if you past the description into notepad and recopy from notepad, then past into excel The whole description will go into excel with no problem.
Thanks again
Tony

[plateaultd]

1366 Incorrect integer value: '' for column 'configuration_group_id' at row 1
in:
[INSERT INTO configuration_group VALUES ('', 'Easy Populate', 'Config options for Easy Populate', '1', '1')] 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.

So I fixed that by getting rid of the 1st '' and specifying fields; then I hit another error...
1366 Incorrect integer value: '' for column 'configuration_id' at row 1
in:
[INSERT INTO configuration VALUES ('', 'Uploads Directory', 'EASYPOPULATE_CONFIG_TEMP_DIR', 'temp/', 'Name of directory for your uploads (default:

Has anyone else ran into this problem?
Is there a quick fix?
Does the commercial version work? We recommended this product to a customer.

[Scrat]

plateaultd - Mysql 5 SQL Install file see reply no #855 of this thread:
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"),');

[plateaultd]

I found another problem with ZC and MySQL 5, which is fixed by turning off strict mode in MySQL. Comment out the sql-mode line in your my.ini and restart mysql.
# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

This also fixes the problem with Easy Populate.

plateaultd - Mysql 5 SQL Install file see reply no #855 of this thread:
If anyone is needing this the install.sql file for the database for MySql 5

[YairOz]

Hey Guys

First of all thank you for this great software...

I'm getting an error every time Im importing files into easy-populate...

The products are still being imported but I had some errors and had to change a few "product description" so easy populate will accept it, so I don't know if this error is doing something but I wanna fix it anyway...

The error is:
Progress: >
Warning: strpos() [function.strpos]: Empty delimiter. in /home/playrus/public_html/***MYADMINCATEGORY***/includes/easypopulate/easypopulate_import.php on line 39

I couldn't find anything about it in this tread... someone had this problem or know how to fix it????


Another question:
Reagarding to the product description.. I tried to upload some product descriptions in HTML language, but easy populate wouldn't accept it until I deleted all the spaces between the HTML codes and text.

Example:

 
<p>
<h3>Product Name</h3>
</p>

Had to be changed to:

 
<p><h3>Product Name</h3></p>

Anyone have an answer for one of those questions?
Thank You For Replaying

[YairOz]

Hey Guys

Just an update regarding to my second question: I found out that using notepad++ and in the end join lines (so all the HTML is on one line) solve the problem and easy populate is accepting the product.

I just don't understand this error message.....

[Scrat]

YairOz - Its the usual test I would start with, if you have products in your zencart, do a complete download, open that in excel or OO (Do not use Notepad as you will not get the right file format to import (which is a TAB sep file )) remove all the products expect the header row and one row (one product) save this and try and upload to zencart via Easypop.
See if this gives you any errors and work from there .

By the looks of your error it is EP is struggling to find the string separater ('Empty delimiter') and it is just seeing the whole file as a string.

[YairOz]

YairOz - Its the usual test I would start with, if you have products in your zencart, do a complete download, open that in excel or OO (Do not use Notepad as you will not get the right file format to import (which is a TAB sep file )) remove all the products expect the header row and one row (one product) save this and try and upload to zencart via Easypop.
See if this gives you any errors and work from there .

By the looks of your error it is EP is struggling to find the string separater ('Empty delimiter') and it is just seeing the whole file as a string.

I did as you said...

The product was added ok.... like I said, I don't know if this error is affecting something... but it still shows up, like every time...

[Scrat]

YairOz -

/home/playrus/public_html/***MYADMINCATEGORY***/includes/easypopulate/easypopulate_import.php on line 39

I think you need to check your easypop. install as you should not have a easypopulate folder the easypopulate.php file should be just in the ' includes/' folder.
One question? which version are you using as the more I think about this it doesn't seem version 1.2.5.4 with the name of the above file, 1.2.5.4 which is the proven version. I know there are some new versions in the download section but I think they a little buggy, search this thread for links to the down of version 1.2.5.4 if you are not using it.

[YairOz]

YairOz -
I think you need to check your easypop. install as you should not have a easypopulate folder the easypopulate.php file should be just in the ' includes/' folder.
One question? which version are you using as the more I think about this it doesn't seem version 1.2.5.4 with the name of the above file, 1.2.5.4 which is the proven version. I know there are some new versions in the download section but I think they a little buggy, search this thread for links to the down of version 1.2.5.4 if you are not using it.

Im using easy populate advanced 3.0.3 which I've download from http://www.zencartbuilder.com

I checked the files structure on my server with the zip file I got... looks fine... every file is where it suppose to be...