Migrating from Os commerce

[faringo]

Anyone give me a clue as to where to start to migrate my very busy os comm erce site to actinic without too much down time and how to use the current database in os comm erce for actinic? If possible.

I am pretty strong on design skills but absolutelly a muppet when it comes to databases (no offence to kermit and friends).

Paul

[cdicken]

It's been a while since I had a good look at the solution you are migrating from. From memory, all the products are stored within a mySQL database, which you can open in Access by doing the following:

1) Create a new blank database using MS Access

2) Go to 'File | Get External Data | Link Tables'.

3) In 'Files of Type' at the bottom, select 'ODBC Data Sources'

4) You then select the 'Machine Data Sources' tab and select the 'MySQL ODBC Driver' from the list (the Data Source Name should be the same as server name that your database sites on).

You then log into the database and MS Access brings the data in. One of the tables within the database is called 'products' or 'stock' or something. You can right click on the table, select 'Save As/Export' and then save it as a csv file that you can open in Excel and import into Actinic using 'File | Import Catalog...'.

The only thing you have to watch in importing into Actinic is that the prices have to be in pence in pure number format. You may need to use Excel to multiply all your prices by 100 to do this (and remove any currency formatting).

This all presumes you have installed the MySQL ODBC driver on your PC. If not, this can be downloaded from HERE.

What I don't know is how to configure an ODBC driver to connect to a remote server. I've only ever done it with a local db and it was quite easy. See how you get on, and respond on this thread if you have further questions.