-=neo=- Posted November 19, 2003 Posted November 19, 2003 Hi, As I'm working on my site I found something that may help when using EP. I was having problems with categories and prices not coming up correctly and when I looked at my excel doc they were all correct :blink: . So I found a process which makes it much easier. Instead of keeping your files in an excel format. Keep them in a tab delimited text format and just right click on the file and open with excel. You will find the errors that you were not seeing previously. I.E. I had a carriage return inside one product field so because of that one mistake when excel was saving the file in a tab delimited format the carriage return would throw off the columns. Everything would import incorrectly. So now that I am saving all of my files as tab delimited text files I don't have that problem anymore. Side note: ALWAYS make sure before you save the file as a txt file again that the number format must be general. If the number format isn't general you will import 1 and 2 dollar items. Good for your customers but not good for you ;) The problem with winning the rat race is at the end you're still a rat.
Guest Posted February 24, 2004 Posted February 24, 2004 I have tried your idea and it is not working for me. I have also tried the GENERAL format for the number but for some reason, it will drop anything in that field that begins or includes letters. In other words, it will not import alphanumeric characters. Strange thing is, when I imported into other tables, my product_id includes these exact alphanumeric characters but those tables imported just fine. My products_attributes table will not import the products_id properly. :(
mikey boy Posted December 9, 2004 Posted December 9, 2004 I have tried your idea and it is not working for me. I have also tried the GENERAL format for the number but for some reason, it will drop anything in that field that begins or includes letters. In other words, it will not import alphanumeric characters. Strange thing is, when I imported into other tables, my product_id includes these exact alphanumeric characters but those tables imported just fine. My products_attributes table will not import the products_id properly. :( <{POST_SNAPBACK}> I've had nothing but trouble with Easy Populate, it hangs when uploading, won't upload all the products (stops at around 3,600) & a lot of prices, images & descriptions are blank. I've checked for carriage returns, but found nothing. I use Tab_delim format to save but that doesn't help either. Does anyone have any suggestions apart from entering 7,800+ items by hand? If there's an alternatibve to EP I'd like to hear about it. :thumbsup:
Rob123 Posted December 24, 2004 Posted December 24, 2004 If you have troubles uploading a large text file, you can split the file using your favorite text editor and upload 2 or 3 files. Works for me, Robert
Guest Posted December 25, 2004 Posted December 25, 2004 the ep documentation talks about splitting your files, as well as the ep file itself (many items in there you need to change for your site). for support with easypopulate, see: http://www.oscommerce.com/forums/index.php?showtopic=64945 I've had nothing but trouble with Easy Populate, it hangs when uploading, won't upload all the products (stops at around 3,600) & a lot of prices, images & descriptions are blank. I've checked for carriage returns, but found nothing. I use Tab_delim format to save but that doesn't help either. Does anyone have any suggestions apart from entering 7,800+ items by hand? If there's an alternatibve to EP I'd like to hear about it. :thumbsup: <{POST_SNAPBACK}>
Guest Posted December 25, 2004 Posted December 25, 2004 your excel file should have no number fields, they should be text fields. also there should be no currency fields, only text fields. for support with ep: http://www.oscommerce.com/forums/index.php?showtopic=64945 I have tried your idea and it is not working for me. I have also tried the GENERAL format for the number but for some reason, it will drop anything in that field that begins or includes letters. In other words, it will not import alphanumeric characters. Strange thing is, when I imported into other tables, my product_id includes these exact alphanumeric characters but those tables imported just fine. My products_attributes table will not import the products_id properly. :( <{POST_SNAPBACK}>
jackywang Posted November 9, 2005 Posted November 9, 2005 Hi, SOS help needed with Easy Populate. I downloaded the complete file using Easy Populate basic, saved it as csv file, opened it in Excel, and added a few new categories, saved it as csv, then loaded the updated file using Easy Populate. Then I redownload using Easy Populate to check the file content, my added records were missing! and the new categories did not show on the web. Can you kindly instruct how to use Easy Populate feature ASAP? Does it only work with certain file format? Do I have to somehow purge the databases before I reload data (if so from where? presume myPHPadmin?) Do I have to specify which table to load? and how? Thanks a lot for your help. jack :(
jeeperz Posted December 6, 2005 Posted December 6, 2005 I downloaded the complete file using Easy Populate basic, saved it as csv file, opened it in Excel, and added a few new categories, saved it as csv... Did you specify the seperator as a comma in the easypopulate.php file?
thewrath1 Posted December 8, 2005 Posted December 8, 2005 If you are having troublw with EasyPopulate, then you might like to try this... Export / Edit and Import an Excel CSV via phpmyadmin Piece of cake - import products prices etc from a csv http://www.oscommerce.com/forums/index.php?showtopic=172479 Q/ How many therapist's does it take to change a lightbulb? A/ Two. But the lightbulb has to really 'want' to change.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.