Easy Populate 1.2.5.4 support

[denliv]

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

[mstar]

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!

[misty]

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

[hankthtank]

That did it Misty. Thank you!!!!

[denliv]

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!

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

[buyersparadise]

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>

[buyersparadise]

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>

[awhfy99]

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.

[Ryk]

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

[mediathing]

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