Easy Populate

[deemurphy]

Does Easy Populate let you import your data from an excel spreadsheet into your mysql database?

Thank you
LadyDee

[deemurphy]

Does Easy Populate let you import your data from an excel spreadsheet into your mysql database?

Thank you
LadyDee

OK, I have gotten most of this to work by using the documentation that schoolboy created. However when I download the file that was created for my temp directory there is not much in there. There are 668 rows in my file and I only get two returned. I do not know what I am doing wrong. I have read the directions two times or more and made any changes it recommended.

Thank you
LadyDee

[deemurphy]

Could someone please help with this problem. My data for each manufacturer is quite large like 600 products for 20 manufacturers. It would be very time consuming to import this manually.

Thank you
LadyDee

[ALiepinieks]

you can use excel, however you should be importing comma or tab delimited files, as easy populate will not recognise the excel file format. the two lines that were returned in the temp file are probably just the first attempt (and subsequent failure) to read this file.

you can save your excel file when it is ready for importing by using the file->save as... function, and choosing the file type "*.csv". you'll lose your formatting, but that is of little consequence except when it comes to dates and numbers so be careful how you format those columns (can sometimes take a little playing around to get it right depending on how much info you're uploading).

[deemurphy]

I have tried what you stated already. If I do a save as and let the window box open, I same it as a text file with tab delimited. There are three types of cvs files that it can be save in and they are cvs comma delimited (new not to used that one) cvs (macintosh) and cvs (ms-dos). I am only geting the headers, like v_products_model, etc. I even cut the file down to 100 rows and still get the same. Also I have tried it with EOREOR at the end of every line and at the end of only the last line, I aways get the same thing.

Thank you
LadyDee

[ALiepinieks]

can you tell me what version of easy populate you're using?