dashCommerce

I have a database of over 30K of products with categories and sub categories. The database is an Access database and zI am trying to import everything into dashCommerce. I am not sure what is easier, writing a custom application with the current access db or trying to import the data into dashCommerce. Does anyone have any experience in this area? I could use some sample scripts or any help in the right direction.

Hi webpro6030,

I have a psuedo import program that I wrote in FoxPro.  You can write it in the language of your preference.  I basically create the .SQL script files that contain the Insert SQL commands.  Then I run the Insert Commands from SQL Server Management Studio.

Louis

Thanks for your quick response. I found a great utility that seems to script all of the objects and data straight into a sql server database. It is called "dbcopy" and works great.

Here is the url:  DbCopy

http://www.dbnetgrid.com/dbnetgrid/default.aspx

Thnaks again.

Why not set up an ODBC connection to the SQL DB and link in the tables.  Then you can run an append query and match everything up.  This works just fine.  I had to split my list of 40K products into two append queries, but otherwise looks great.  You will probably have to do some mapping and field manipulation anyway.

Could you give me more detail on how you did this. I am not sure how to setup the ODBC connection and append the data. Thanks.

Hi Kim6030,

I'm not the one who used the dbCopy program but setting up an ODBC connection is easy enough. Just go to the Windows Administrative Tools, ODBC and create a new ODBC connection.

Louis

On one hand, you really need to understand the basics of Access, SQL and how to work in databases.  I couldn't possibly explain it all, but I can get you pointed in the right direction.  Maybe you know someone who could help you set it up.

 In Access you can link tables from other databases.  But if the database is not on your computer, or in your local network you need to link it from a Datasource set up on your computer.  You do that in the windows control panel called "Data Sources (ODBC)" found in administrative tools.  You should add a new machine datasource of type SQL Server.  Fill in the information about your SQL database.

Then in access you add a linked table, under type select ODBC data source.  You pick the data source you created for your website db and then you will see a list of all the tables.  Highlight all the ones you want linked into Access, such as Category, Product, ProductCategoryMap, etc.  I would check the save password button as well.  Then you have these tables you can work with inside of your Access DB.  You can append new products from a local table to your remote database, do update queries, delete products or change their status.

Those are things you need to study about DB in general to complete, but they aren't that hard overall.  Good luck.