I finally have it working thanks for your help, this will help me tremendously, I will rename the directory now, hopefully nothing changes after I do so.Quote:
Originally Posted by mc12345678
Printable View
I finally have it working thanks for your help, this will help me tremendously, I will rename the directory now, hopefully nothing changes after I do so.Quote:
Originally Posted by mc12345678
I am using EP4 in a 1.5.3 site. Using Open Office and comma delimited... Saving as a CSV file. Upload and import. Getting the following error for all products: No model field in record. This line was not imported. Attaching csv file for you to see.
Thanks for any help you can give me....
~anne
Records are not saved correctly...
Each column (v_products_model for example) is not properly delimited...
Right now everything is separated by a tab, and instead of a double quote, the text is surrounded by a single quote. These differences cause issues for the upload.
What seems like the "easy" way to correct the example that was uploaded is to open the file, selecting:
Character Set: Unicode (UTF-8) seemed to work
Language: Default - English (USA)
From row: 1
separated by: Tab
With Text Delimiter as the single quote.
Checkbox for Quoted field as text marked.
No other indicators.
Then, the first column will have a " at the beginning of each cell which should be removed.
The values in the v_products_name_1 column should have extra spaces removed (LL. Bean bag-Small for example)
The last column has extra data at the end of each row for that column. (",,,) Those could be mass removed with a search and replace..
Then once all of the issues have been corrected perform a save as: file type: Test CSV (.csv) (*.csv)
check the checkbox for Edit filter settings. Select Save and then in the questions asked save it the following way:
Character Set: Unicode (UTF-8)
Field delimiter: , (comma)
Text delimiter: " (double quote)
I set it to Quote all text cells and Save cell content as shown, but wasn't sure about the quote all text cells. I believe chadderuski had some good guidance about how to save the file(s).
The above "directions" are from working with Open Office Version 4.1.1.
Thanks! I will try this tomorrow.
I have the exact same problem. Please help as I have no idea how to do what you described.Quote:
Originally Posted by stellarweb
Tried removing and reinstalling easy populate with no luck. I am using ZC 1.53
Please see this post: http://www.zen-cart.com/showthread.p...54#post1260554Quote:
Originally Posted by keith z
The issue is not fully/properly incorporating USU into the store. There are instructions on how to do that. The solution offered above was to create a new admin subdirectory with all of the same configure.php settings, but only offering EP4 in that admin directory.
hi
i want upload a description data with easy populate
i can use i file whit simple file csv with fileds: v_products_model and v_products_description_2 ???
i have a error and dont possible atachement csv file!!! where is the error log of easy populATE4 ??
THANKS
Errors captured/documented by EP4 are in an errorlog listed in the files to be imported/downloaded. New errors are added to the end of the file. If this file has been in the file list for a long time it may contain multiple errors that do not relate to the current issue.Quote:
Originally Posted by salvo72
Btw, I am not entirely sure that the code currently supports only a total of two columns being in the upload file. I would have to look to see what changes might be necessary to support that.
Hi, I have installed EP4 on a 1.5.3 zencart site. I have noticed I get the following when using this add-on
"An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer"
When I check my logs folder, the error is as follows.
"[29-Nov-2014 16:01:47 Europe/London] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/izzy/public_html/ZC153-test5/renamedaddy/easypopulate_4_import.php on line 881"
I don't know what I have done wrong :(
I do not get this error on a 1.5.1 site.
All help appreciated!
Which ver of EP4 was installed on ZC 1.53 and what plugins are also installed on the ZC site?Quote:
Originally Posted by izzysoup