How to import...

[CallieJo]

How to set up my text file full of products (not products but we'll call them that) to import into reviewpost?

My text file is outlined like so with thousands of entries:

Name of Business
Address Of Business
Phone Number Of Business

How to import this without doing it all one by one in the front of RP?

I've already created fields for the last two in admin for all categories.

I tried to look at the products field in phpmyadmin.
I copied the format and added them into my text file in the right order and then tried to get them into the database. Alls I get is errors. Just a big fat mess!

Therefore, after wasting hours and not getting anythang done right...I am asking here.

I see there are comments about importing as a csv file. I've searched the net and see that csv files are items separated by commas. Okay, so if I put a comma after each item how do I make the database take that information?

Ugh! I'm just so lost on everythang here. I keep searching these forums and google all day for answers and I can't find anythang at all that works for me. This is my second question I've been working on all day with no result.

Can someone please explain how to turn a text file into csv and import into the database product area or turn it into an sql file that I can import.

Thanks

[CallieJo]

Invalid field count in CSV input on line 1.

That is the error I get from trying to import a csv file.

Any suggestions?

[Chuck S]

You need to look at the structure of the products table and then arrange your csv file columns to the number of columns and appropriate data in order that it needs to be or insert dummy columns where needed.

[CallieJo]

I tried that. However, when I try to import it into the database I don't think it likes it for some reason or I need to create some sort of insert commands. I tried copying the products table and inserting my own data as a test. The above error is what comes back.

I guess maybe it's more complicated than I thought and would have to manually implement all businesses and info by hand. I believe someone else might be interested in this later, but after all day yesterday I've given up and will go the hard route.

Thanks for your reply, though.

[DrSKiZZ]

Did anyone ever figure this out?

[Chuck S]

This was an issue of her using some third party program more than likely phpmyadmin and CSV files. Since it never dealt with Reviewpost persay other than her making sure she had the right number of fields in her CSV file to import into a reviewpost table I can not say