Has anyone tested EPA with V 1.3.8? Is it compatible?
thanks!

:frusty:Not sure what I am doing wrong here, but when I upload my file to add to the database, I get the following errors:

Warning: move_uploaded_file(/home/prettypa/public_html/store/temp/Full-EP2007Dec09-1212_2.txt) [function.move-uploaded-file]: failed to open stream: Permission denied in /home/prettypa/public_html/store/admin/includes/functions/extra_functions/easypopulate_functions.php on line 32

Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move '/tmp/phpzkkBvH' to '/home/prettypa/public_html/store/temp/Full-EP2007Dec09-1212_2.txt' in /home/prettypa/public_html/store/admin/includes/functions/extra_functions/easypopulate_functions.php on line 32

File uploaded.
Temporary filename: /tmp/phpzkkBvH
User filename: Full-EP2007Dec09-1212_2.txt
Size: 6345

Warning: file(/home/prettypa/public_html/store/temp/Full-EP2007Dec09-1212_2.txt) [function.file]: failed to open stream: No such file or directory in /home/prettypa/public_html/store/admin/easypopulate.php on line 822

Warning: Invalid argument supplied for foreach() in /home/prettypa/public_html/store/admin/easypopulate.php on line 861

tootsiebelle - First thing I would check that you have up loaded all the files correctly and that the permissions are right for those files as you are getting 'Permission denied ' & 'No such file ' errors. Re-upload the files one by one and see what that brings.

Nope, tried that, and CHMOD all the files...still get errors

tootsiebelle - Right, next thing is check your file locations as stated in the Readme.txt ( Stupid question you do have a 'temp' folder ? if so check the location.

1. Change the name of the "admin" directory in this package to suit your zencart installation
2. **The temp folder is configured to reside in your store directory. If you store is not in the
   site root (eg. /mystore/) then the temp directory must also go in this directory.**3) If you want to re-name the uploads (temp) folder, ensure that you configure Easy Populate to
   reflect this change after installation
3. Upload all files in their respective directories.
4. Go to Admin -> Tools -> Easy Populate. If prompted to install Easy Populate, click on the
   link provided. Otherwise, type in your browser address bar ?langer=install after /easypopulate.php
   (eg. YOUR_ADMIN/easypopulate.php?langer=install). If you wish to remove and re-install the default
   config settings, type ?langer=remove after /easypopulate.php
   (eg. YOUR_ADMIN/easypopulate.php?langer=remove) and begin this step again.
5. Go to Admin -> Configuration -> Easy Populate, and configure the upload directory if you have
   changed it from default. Also, ensure that the correct date format is set for your upload files.
6. If this mod gives you more time with your family or friends, and/or less customer headaches, please
   consider a donation to [email protected] to ensure this module is continually supported and improved :-)

IMPORTANT!!!

**** your temp folder must have owner permissions to read/write/execute (chmod 700) for EP to work**.
EP now adjusts this for you (unless you have a windows server - ask your host to adjust permissions on this folder for the IIS web server)
** The temp folder has example downloaded files in it. You may wish to delete these before uploading.
** It is recommended that you download a file 1st and use this as a template for your uploads (install should do this for you..)
** If for some reason the config install fails, you can upload the SQL file provided using Admin -> Tools -> Install SQL Patches

That's it!
REMEMBER TO BACK UP EVERYTHING FIRST!

Thanks Scrat! The problem was the permissions on the TEMP file!!!! Thanks a bunch!:clap:

tootsiebelle:

Thanks Scrat! The problem was the permissions on the TEMP file!!!! Thanks a bunch!:clap:

Spoke too soon! Now I am getting:
No model field in record. This line was not imported

How do I fix this? The field is in the file, but I don't have anything in it. Do I need to assign something like a item number?

ie. Black Eyelets... model number is blk_round?:unsure:

tootsiebelle - > the most common issue is that the model number/ref has to be unique to that one product.

The best way to test any imports is set up a product in Zencart add attributes etc and then download the complete file and the attribute file and then open them in OO or Excel and see the structure/format. Then just copy the first product row as an example and add additional products ( with unique model ref's) and then import and I would put money on it it would just work great (Version 1.2.5.4 and 3 )
Also read this FAQ below it does work

Fireflyz:

Has anyone tested EPA with V 1.3.8? Is it compatible?
thanks!

Works fine on mine

Anyone know why I can't upload a complete description when I go to look at an item the description is cut off yet the full description is in the file when I upload it. yet when it is done only 256 bits shows here is a sample
http://afdeals.com/index.php?main_page=product_info&products_id=19456

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 !

tonysebay:

Works fine on mine

Good to know..Thanks for the reply!

Scrat:

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

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.

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"),');

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.

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

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

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

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.

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.

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