Re: Easy Populate support
I had some long time consuming delays with easy populate and wasn't able to find a solution online. I wanted to share my problem and solution. I figure if I had the problem others must too. I have a client who's supplier sends him an xlsx file with most data needed for the easy populate csv file, however it doesn't easily covert because of commas, quotes - apostrophes (used for measurement description), bullet points and more. Hours of frustrations.
First if your using Open Office calc open your downloaded easy populate cvs file and convert it (save as) to a .ods spreadsheet for a friendly work area. DO-NOT convert it to an xl file. I found the hard way that open office will limit the number of characters in a table cell cutting my descriptions length in half. - I was scratch my head for hours.
Second because the upload file needs to be a .csv you can't have commas quotes or apostrophes. What do I do when my product description needs em'? I searched and searched online and I read a lot about what options to select when I save as csv. Nothing worked. Somehow I remembered my old school basic html special characters. After I had place in all the descriptions I did a find and replace
Comma - , replace with ,
quotes - " replace with "
Apostrophe - ' replace with '
Bullet Points - • replace with •
Then save as .csv leave the field delimiter as a comma and delete the quote from text delimiter so it's blank.
Now your csv file is ready to be imported. I hope this helps and save you from frustration and time.
Re: Easy Populate support
Hi, have just installed this onto a fresh install of 1.5.1 on local server, only other addon is Quick Updates (latest version)
Upon clicking 'install configuration' at top, the bottom half of the easy populate page looks like this
Attachment 13147
if I run the uninstall script the text at the bottom vanishes
have no idea what I am doing wrong
any help greatly appreciated
pete
Re: Easy Populate support
Guys,
I am trying to use easy_populate_csv_for_zencart_v1.5.x_v1.2.5.7c... but no matter what I do, the SQL files bombs and there is no entry in the Configuration menu. This is a clean install.
Thought? Help?
David
Re: Easy Populate support
I am getting this error when trying to upload a file? I have tried to manually upload and that works but then I get the same error
Upload Results
File uploaded.
Temporary filename:
User filename: data live sheet.csv
Size: 0
ERROR: file doesn't exist
Re: Easy Populate support
check in your tools section that is where mine was installed however it will not import a file...
Re: Easy Populate support
Hello everyone,
I am sorry if this question has already been asked but I searched the forum and could not find an answer. :(
My problem is that I have almost 23000 products in my store and when I try to download a complete .CSV file, create a complete .cs or froogle file in temp directory through easy populate my screen just goes white after about a minute and the link of the white/blank page is this:
http://www.domain/admin/easypopulate...am&dltype=full
Is it safe to assume that there is a time restraint somewhere? Or, do I have too many products? When I uploaded my products originally using easy populate I did it by product type so it wasn't one large upload. But since I have uploaded everything, I have moved categories around and I need to export everything the way it stands now so I can't do it by product type anymore.
I am using zen cart 1.5.1 and I just downloaded the latest version of Easy populate about 3 weeks ago. Not sure the version.:blush:
Please someone tell me this is an easy fix for a novice/beginner (fingers crossed).
Thank you.
Re: Easy Populate support
My Easy populate tab under configuration opens my Super Orders config. I can't access the Easy populate Config. Can anyone tell me how to fix this?
Thanks,
Tom
Re: Easy Populate support
So frustrated. I need to know how to first
1. download the existing products and categories (which I need first!)
2. add more or update the excel file
3. Upload the new CVS file
Is there some documentation please?
Re: Easy Populate support
easy populate does not show up in zen cart tool bar
please help
i installed easy populate admin folder in my admin directory.
the easy populate admin folder has the same name as my admin directory.
the files are all visible, within my ftp directory.
easypopulate_4_export.php (permissions 644)
i also installed the zen cart 1.3 extra files. (permissions 755)
in my stores admin directory
what am i doing wrong?
thanks
art
art
Re: Easy Populate support
ok I am absolutely loosing my mind, I have uninstalled and reinstalled 3 times today, even did a clean backup from a known good working time, and this is what I am getting whenever I try to upload a file regardless of size, or how much info is in the .csv. However when I go in and check if everything has been loaded up properly it seems to be (I have tested this on files of 1, 10, and 20 changes). which generally would not be that big of a deal, leave it as it is and move on. However I have a file with over 100k changes that need to be made, I have broke this down into files of 500 however it is nearly impossible to track all those updates 1 by 1 and would take more time doing so than going in and manually doing the changes. I would like to think that even in spite of my error that I am getting that everything is being inserted correctly, however with no way to check at once (the list that shows you what has been changed and what has not).
I have tried everything I can think of, I have changed my php memory alotment from 128m to 512m, I have changed the time out from 60 to 240, I have even gone in and optimized the memory alotmont and maximum connections to the database and yet I still get this error am I doing something wrong? My website is "b u l l y s p e r f o r m a n c e . c o m" I do not get this error on any other pages, and I have checked my error logs on the vps and I do not see anything related to the erasypopulate, just a bunch of errors about pictures missing on products where I need to go in and update them to the new picture name, so that the database is looking for the right file.
any help would be greatly apreciated.
HTML Code:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, and inform them of the time the error occurred, and anything you might have done that may have caused the error.