Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › PowerStore › Powerstore General / Announcements › Importing data into PowerStore database

Importing data into PowerStore database

Thread began 11/25/2011 5:39 am by mrs | Last modified 11/28/2011 7:27 am by Jason Byrnes | 573 views | 1 replies |

11/25/2011 5:39 am | #1 mrs

Importing data into PowerStore database

Hi, I have received lots of Microsoft Excel files each with many rows of data that needs to be entered into the powerstore database. :(

Is there any way that I can import the data rather than enter it one record a time in the admin section, or a GUI for MySQL?

Thanks

Mat

11/28/2011 7:27 am | #2 Jason ByrnesWebAssist

Power Store does not offer support for importing data.

PHPMyAdmin and most other GUI Tools do offer support for importing CSV files.

you can save the Excel file as a CSV and import the CSV data, but you will need to make sure to map the CSV Columns to the Power Store products columns correctly.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.