|
How do I connect my own products database? |
|
|
|
If you want to connect your own products database (MS Access, MySQL, Oracle, DB2, ...) to your VirtueMart catalog, here is the easiest ways to proceed!
Using our VMCClient (open souce VB.NET sample) and MS Excel:
Right now, our sample uses MS Excel as we do not know what is your current product database provider (MySQL, Oracle, MS Access, ...), but you could use the MS Excel query wizard, to query your own database in the predefined category or products fields layout (used by our sample), and then import this spreadsheet into our VB.NET sample. You will then see your data in our sample datagrid, and you can push the update button to manage and maintain your remote VirtueMart eCommerce. Using our VMCClient (open souce VB.NET sample) and the underlying Dot.Net datatable object:
Right now, our free VB.NET sample client uses a Dot.Net dataset and an underlying datatable objects filled-up with an Excel spreadsheet as a demo linked to a datagrid to visualize it. You could very easily replace the datatable content with one of your query on top of your products DB using ODBC.
All you have to respect is the current datatable layout (categories or products), map your own DB fields to current datatable fields. When done, the VB.NET sample modified will fill-up the datatable with your records instead of the xls spreadsheet, the result will be visible in the sample datagrid, and you can push the update button to update remotely your Joomla website VM database.
Full customizationIf you do not want to use the VB.NET sample, you can of course program your own application, which can call the VMConnector webservices functions from most of today's programming languages (C#, VB, C++, Java, php, ...) and operating systems (Linux, Macintosh, ...). Our free sample, shows you anyway how to call our VMConnector Webservices, and what are the different arguments in and out.
|