Easy Populate 1.2.5.4 support

Scrat - I appreciate that but the instructions say it's better to delete fields that you're not using so that's why I deleted them. Also, I have attempted to upload a file created by EP with the same results?:lamo:

I'm thinking I must not be opening and/or saving the file correctly in Open Office Calc. I downloaded the complete file, added one item, ftp'd the file to /temp, then uploaded using EP. One of the catagories for an item i didn't add created a new root category, and the new item did not show up. Any ideas?

mstar:

Could someone tell me how to do a split file in easy populate? I'm trying to upload over 10,000 products into the db, but it's too large of a file so I need to do a split file. Could someone help me?

I've found it's easier to upload the entire file via FTP to the temp directory and load it from there. Splitting shouldn't be necessary. Of course, a backup before proceeding never hurts!
Dennis

denliv:

I've found it's easier to upload the entire file via FTP to the temp directory and load it from there. Splitting shouldn't be necessary. Of course, a backup before proceeding never hurts!
Dennis

Thanks Dennis, but how do you upload the file via FTP to the temp directory? Could you explain and I'll give you as much info as I can to help you help me through it? Please and thank you! Your greatly appreciated! :yes:

hankthtank:

I'm thinking I must not be opening and/or saving the file correctly in Open Office Calc. I downloaded the complete file, added one item, ftp'd the file to /temp, then uploaded using EP. One of the catagories for an item i didn't add created a new root category, and the new item did not show up. Any ideas?
http://www.zen-cart.com/forum/showthread.php?p=519777
Have answered your other post at url above

That did it Misty. Thank you!!!!

mstar:

Thanks Dennis, but how do you upload the file via FTP to the temp directory? Could you explain and I'll give you as much info as I can to help you help me through it? Please and thank you! Your greatly appreciated! :yes:

Sorry, I thought you'd be familiar with ftp'ing - how did you install your cart? It's usually done via ftp. There's a bunch of free ftp programs available (I recommend snapfiles.com for excellent freeware - go to the freeware section instead of shareware). FileZilla is a popular one.

Alternatively, if your web server has the cpanel control panel you can upload files via the file handler there. Once your Easy Populate file is ready upload it to the temp folder which is in the root of your store directory. Upload in text mode, not binary, if using ftp. Then you can go back into your store's admin panel and import it.

Hope this helps. You can contact me via private message if you need more assistance.

Dennis

I know how to use Easy populate except I am now stuck on a situation with the spreadsheet. For example I have say 300 products I am trying to upload and when I get to the column to mark the default location for the picture all my products consist for example of a 5 digit number: 12345 and they each have to end with .jpg to point to my pictures. Well instead of putting .jpg 1 by 1 down the column of 300 I took in excel and did a Concatenate to combine 2 cells into one. I then name that cell v_products_image and save it like I normally due but I hide the 2 cells I used to make this into one cell. When I go to upload I keep getting the error ERROR! - Column count mismatch on row 2 - The likely cause of this is inconsistant use of a text delimiter in your file or an obscure character in a product name of description.
Ensure there is no text delimiter, or all fields (including column headings) are delimited.
You may alternatively need to adjust the value of "$ep_overrides['file_buffer']" higher in your overrides file.
for each line. IS there a fix for this issue or do I have to 1 by 1 enter .jpg into the original column? With excel cant we use formulas to combine columns and then be able to save an upload like normal? Please help thank you. I have over 3000 products and to do it one by one will take FOREVER>

I know how to use Easy populate except I am now stuck on a situation with the spreadsheet. For example I have say 300 products I am trying to upload and when I get to the column to mark the default location for the picture all my products consist for example of a 5 digit number: 12345 and they each have to end with .jpg to point to my pictures. Well instead of putting .jpg 1 by 1 down the column of 300 I took in excel and did a Concatenate to combine 2 cells into one. I then name that cell v_products_image and save it like I normally due but I hide the 2 cells I used to make this into one cell. When I go to upload I keep getting the error ERROR! - Column count mismatch on row 2 - The likely cause of this is inconsistant use of a text delimiter in your file or an obscure character in a product name of description.
Ensure there is no text delimiter, or all fields (including column headings) are delimited.
You may alternatively need to adjust the value of "$ep_overrides['file_buffer']" higher in your overrides file.
for each line. IS there a fix for this issue or do I have to 1 by 1 enter .jpg into the original column? With excel cant we use formulas to combine columns and then be able to save an upload like normal? Please help thank you. I have over 3000 products and to do it one by one will take FOREVER>

The simple way to do what you want is to paste your image numbers into the correct column. Then format that column as a number (they should then look like 12345.00, etc). From there, do a find /replace and replace the .00 with a .jpg, presto, they are all changed. You can then reformat it back to text but I don't think it would matter if you didn't. Let me know if you need futher clarification.

@buyersparadise - you're only hiding the "working" cells, not removing them so they are still there as far as the code is concerned...therefore the column count is wrong as far as EP is concerned.

Do your concatenation and use Paste special to put the values in the images column; delete your "working" cells.

Can I use a url under v_products_image?

...Also, when adding new products, do I have to add them onto the end of the complete file or can I just use a blank template with the header I need and upload, say 30 products?...If so, what should I call the file?

Thanks

mediathing -

Can I use a url under v_products_image?
No you cannot

...Also, when adding new products, do I have to add them onto the end of the complete file or can I just use a blank template with the header I need and upload, say 30 products?...If so, what should I call the file?
As long as you have the headers on the first row you can add new products as many as you want, but up 300 is the most with out problems. Make sure you have unique model id's

Thanks for the answers, helps a alot. A couple more questions:

Does it make a difference what the file is called, I am using open office and when I save it gives me an option regarding what type to save as?

Does the file have to have all the headers or just the ones that I want (name, image, qty, desc, cat).

When I upload a file, this will only make additions to the product DB and will not remove anything. For example my store currently has around 400 products. If I create a file with 50 products adn upload it, it will just add these and not assume that this is now the "full list".

Thanks for your help.

I am getting a Line Delimiter not found! error when I try to import a small file containing new items.

I can go into easypopulate_overides.php and change $ep_overrides['linebreak']" to true and the first line will import correctly but the rest of the file will not.

I am on a Linux server and using Excel to create the spreadsheet, which I save as a txt file.

Please help.

Hi,
I have a couple of questions on this mod.

1. Is it possible for Zencart for automatically import a file into its database at a fixed time, instead of me manually loging in and uploading it. My supplier can automatically connect to my store via FTP and drop a tab-delimited file in a folder every night, so Zencart only has to detect the file and put it into its database.

2. Is it possible to have more than one upload file? I have about 5 suppliers who can supply me with a tab-delimited file every night or so, and I want those files to be imported at different times at night, but I want the database to be updated with the products. I’m not sure and may be wrong but is it true that if i upload with a file full of products and then upload with a different file with different products- Will my whole catalog be overwritten or will the new records from the other file update my database.

Thank you in advance, sorry for the length of the questions.

Thanks for the advice. Problem is I tried that and it wont work how come? Once it finds the .000 then it ask what i want to replace it with and I type .jpg and it keeps telling me excel cannot find a match. next to the replace it has a preview and format area. DO I change any thing on there? what should the within, search, and look in be on and should the match case and match entire cell content be checked? Thanks.

Well now I cant get the concatenation to work but when I did try that once before it didnt work could you email me how to do this? [email protected] just send me an example of the formula and how you did it thanks!

mediathing - 1.Has to be a .txt file in a TAB delimited format but can be named what ever you like (xxxx.txt, newfile.txt, lastupload-08-03-2008.txt )etc
2. It must have the model heading but as from the readme file you can exclude unwanted columns but not tried it personnally.
3. It will upload new products, and update others if in the file if the status column is marked 1 if that column is marked 9 it will delete that product. Other than that just upload new products and it will not effect the rest of the DB.

CJ Internet Sales - Try a test, download a complete file from the DB, remove all the rows except the first row (Headers) and two products with out changing anything else and then up load that file back into Zen, this should give you a result of Two products updated. If this works it means your current upload file is incorrect in foramt some way so you must check that. Check you have 'EOREOR' on the end of each row.

jaskarn - Yes this would be possible, if you know php, if you don't have a look at cron jobs this may be able to do it for you. I don't use cron myself someone else maybe able to advise you better.

buyersparadise -
This will join column A1(sheet1) +'.jpg' and put it on sheet2

=CONCATENATE(Sheet1!A1,".jpg")

I am still having one problem with my inventory that has been uploaded using EP. All the items upload fine now, however, my categories are messed up on the store. For example, when I uploaded Wyse Terminals, a new Terminals category, with a lone subcategory, Wyse Terminals was created. I have checked my upload files, and they seem to be setup correctly. Another weird thing, is the double categories do not show up in admin, so I have no idea how to even manually correct this.

If you want to see what I'm talking about, my website is https://www.centrixcs.com.

Any ideas? Thanks.