toolman Posted August 7, 2006 Share Posted August 7, 2006 Hi there, I have a microsoft access database / mdb that i want to upload into osC. Is this possible? Many thanks Link to comment Share on other sites More sharing options...
kgt Posted August 7, 2006 Share Posted August 7, 2006 Use ODBC or dump your data into csv files. Contributions Discount Coupon Codes Donations Link to comment Share on other sites More sharing options...
toolman Posted August 7, 2006 Author Share Posted August 7, 2006 ok thanks, but i have no idea how to do that. do i donwload a program or something? Link to comment Share on other sites More sharing options...
toolman Posted August 7, 2006 Author Share Posted August 7, 2006 ok thanks, but i have no idea how to do that. do i donwload a program or something? Link to comment Share on other sites More sharing options...
kgt Posted August 7, 2006 Share Posted August 7, 2006 Databases are not like files. There's not really a way to just open a database in another program and have it just magically work. There are tools to help you migrate data, but you need to understand how the data is laid out. The table structure in OSCommerce is no doubt very different from the table structure of your Access database. OSCommerce expects that the tables it uses have certain field names and they're in a certain order. If you're not familiar with the process, then I would recommend that you export your database to csv files. You will use Microsoft Access to do this. You may then edit your csv files (you can edit csv files using MS Excel) and use Easy Populate to upload them. http://www.oscommerce.com/community/contributions,500 You will need to edit your csv files in excel to get them into the proper format expected by easy populate. Contributions Discount Coupon Codes Donations Link to comment Share on other sites More sharing options...
toolman Posted August 7, 2006 Author Share Posted August 7, 2006 Thanks.. i have installed easypopulate. I have gone to admin and it says upload ep file. I have converted my database to a cvs file and have headings: productid, name, description etc. Is this correct? Where do i find the names that these columns should be? Many thanks :) Link to comment Share on other sites More sharing options...
kgt Posted August 8, 2006 Share Posted August 8, 2006 Read the documentation for easy populate and/or look in the support thread for easy populate. Contributions Discount Coupon Codes Donations Link to comment Share on other sites More sharing options...
toolman Posted August 8, 2006 Author Share Posted August 8, 2006 HI, When i click on download Download Complete tab-delimited .txt file to edit I get this error: 1146 - Table 'db_store.TABLE_PRODUCTS_STOCK' doesn't exist select products_stock_quantity from TABLE_PRODUCTS_STOCK where products_id = '1' and products_stock_attributes = '3-5' I take it this is a mysql error? Link to comment Share on other sites More sharing options...
kgt Posted August 8, 2006 Share Posted August 8, 2006 You downloaded a version that is intended to work with QTPro. Download a version of EP that DOES NOT say "designed to work with QTPro" or "for Discount Groups" or something like that. Those are designed to work with the named contributions. If you don't have those contributions installed, you'll get an error. Contributions Discount Coupon Codes Donations Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.