Last service demands SAP B1 : Can I use VMConnector to integrate my Virtuemart with SAP B1?

 

BUY ONLINE - VM SHOP





Lost your Password?
No account yet? Register
Download Area
Show Cart
Your Cart is currently empty.
 
Solution Graphics
VMConnector extension for Virtuemart
How do I connect my own products database? PDF Print E-mail

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!


  1. 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.

  2. 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.


  3. Full customization

    If 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.



 
© 2010 IDT SA - IT Consulting & Professional Solution Provider