Français: Español:  Italia:  Português: Nederland: Chinese:  Russian: Deutsch:

Welcome to the VMConnector live DEMO / Tutorial

(This demo uses VMConnector 1.1.x for Virtuemart 1.1.x and Joomla 1.5.x. VMConnector 1.0.x for Virtuemart 1.0.x and Joomla 1.0.x. is similar to this demo))

If you would like to understand right away the main VMConnector client/server concept, it's worth spending 20 minutes to go through this Quick Install and Tutorial.

VMConnector module is already installed on our Virtuemart DEMO database, so all you need to do, is to download our DEMO VMCClient and install it on your PC (or local server).

FLASH DEMO link

NEW VIDEO-TUTORIALS (Install VMConnector and VMCClient / create your first Virtuemart catalog with VMConnector and the VMCClient)

 TO START WITH VMCONNECTOR AND ITS VMCCLIENT, please follow this procedure:

1. Download the DEMO VMCCLIENT: Download link
   
   

   VMCClient:

2. Unzip to a temporary folder the downloaded ZIP file, and double click on "setup.exe" to install.
   
   
• IMPORTANT NOTE:
  
  
• Remove any regular VMCClient installation before trying to install this DEMO version.
• The VMCClient DEMO is a locked version and you cannot use it for your shop. When you are done with the tutorial demo, remove it and install the latest VMCClient from the main install procedures.
  
  
• The MS Framework 3.5 is required, the "setup.exe" will download and install it if required from Microsoft web site.
  
  
• System requirements:
  
  
• Supported Operating Systems: Windows Server 2003; Windows Server 2008; Windows Vista; Windows XP
• Processor: 400 MHz Pentium processor or equivalent (Minimum); 1GHz Pentium processor or equivalent (Recommended)
• RAM:96 MB (Minimum); 256 MB (Recommended)
• Hard Disk: Up to 500 MB of available space may be required
• CD or DVD Drive: Not required
• Display: 800 x 600, 256 colors (Minimum); 1024 x 768 high color, 32-bit (Recommended)
  
  
3. VMCClient starts automatically.
   (Please note that the VMCClient is open source vb.net, and you can customize it if required, to get data from any existing product database or source. For more advanced integrators or programmers, you can even build your own client [ php, c++, Java, ...] to call VMConnector web services functions).
   
   
4. IMPORTANT NOTE: This VMCClient DEMO client is locked for the DEMO purpose, if you want to use the evaluation or the production version of VMCClient and VMConnector, you need to uninstall the VMCClient DEMO program and install the unlocked VMCClient from the install procedures . 

TO TEST AND UNDERSTAND THE MAIN VMCONNECTOR CONCEPT, please follow this tutorial:

1. Make sure the VMCClient is up and running (you can also have a look to the flash demo )
   
   
2. On the "Controls" tab, please use:
   
   
• URL: http://www.idtsa.com/demo
  
  
• ID: demo
  
  
• Password: demo
  
  
3. Select the "1 - Orders" tab and click "Get VM Sale Orders ..." button.
   (All VM Orders are downloaded as no special criteria were specified on the "Controls" tab page).
   
   
4. Click on "Export Order rows to file" button, override default file name "VMOrders.xls" to "Virtuemart.xls".
   
   

   Virtuemart Sale Orders, Customers, and ordered products are exported to an MS Excel Spreadsheet:

   
   
   

   
   
5. Once orders have been downloaded, select the "2 - Customers" tab and click "Get Customers based ..." button.
   (All VM Customers information are downloaded based on previous sale orders downloaded).
   
   
6. Click on "Export Customer rows to file" button, override default file name "VMOrderCustomers.xls" to "Virtuemart.xls" (click Yes to replace the file).
   (We want to get all different sheets in the same MS Excel file "Virtuemart.xls")
   
   
7. Once customers have been downloaded, select the "3 - Products" tab and click "Get Products  based ..." button.
   (All VM products information are downloaded based on previous sale orders downloaded).
   
   
8. Click on "Export Product rows to file" button, override default file name "VMOrdersProducts.xls" to "Virtuemart.xls" (click Yes to replace the file).
   (We want to get all different sheets in the same MS Excel file "Virtuemart.xls")
   
   
9. IF you are a QuickBook user, you can click on the QuickBooks tab (only after downloading all 3 previous tabs), and export Customers and Invoices to QuickBooks IIF file. Please note that this is ONE IIF file implementation and it may vary according to QuickBooks version and accounts.
   
   
10. Select the "Catalog Categories" tab and click "Get VM Catalog Categories ..." button.
    
    
• All VM Catalog Categories information are downloaded based on category name selection text field. If you write "hand|tools|...", you will get only categories containing the words (hand or tools).
  
  
• Once the Categories are downloaded, if you click to select Category rows (+Ctrl or +Shift), and click on the "Get VM Products based on your Category selection" button. You will download only Products and child products related to the category rows previously selected.
  
  

  Specific category selection using part of category's name:

  

  
  
11. Click on "Export category rows to file" button, override default file name "VMCatCat.xls" to "Virtuemart.xls" (click Yes to replace the file).
    (We want to get all different sheets in the same MS Excel file "Virtuemart.xls")
    
    
12. Select the "Catalog Products" tab and click "Get All VM Catalog Products..." button.
    
    
• All VM Catalog Products information are downloaded based on default shopper group.
  
  
• If you want to download products with another shopper group prices, please click on the desired Shopper Group line and download again the products.
  
  
13. Click on "Export product rows to file" button, override default file name "VMCatProd.xls" to "Virtuemart.xls" (click Yes to replace the file).
    (We want to get all different sheets in the same MS Excel file "Virtuemart.xls").
    
    
14. The last "Product Types" tab is used to query and validate all product types and parameters + values to update VM catalog products with a visual reference for valid names and values.
    
    
15. Once these steps have been performed, locate your "Virtuemart.xls" file and open it.
    You can see that all previously exported sheets are in one single "Virtuemart.xls" file.
    
    
16. To update Virtuemart catalog products and categories, you can manipulate related Excel sheets, product and category rows or cells. More specific rules are specified within MS Excel commands help for VirtueMart Catalog Maintenance
    
    
    
    
    
    
    
    
17. Once you have updated the "Virtuemart.xls" spreadsheet, do not forget to save it.
    
    
18. Switch to the VMCClient, select "Catalog Products" tab and click "Import Excel file..." button. Select the "Virtuemart.xls" file and click ok.
    
    
• Please note that the XLS sheet imported, correspond to the name specified in the bottom right end conner: "Please enter XLS sheet name".
  
  
• This sheet name is used to export and import data to and from the spreadsheet.
  
  
19. If the import is fine, you can then click on the "Upload VM Products" button. After a confirmation all the XLS product lines will be uploaded to Virtuemart according to the "product_action"command field (productAdd, productUpdate, productDelete). See MS Excel commands help for VirtueMart Catalog Maintenance for more information on this.
    
    
20. For "Catalog categories", do the same as for  "Catalog Products" but on "Catalog Categories" tab.
    
    
21. IMPORTANT NOTE:To avoid having many different users uploading uncoherant data to our DEMO database, we have disabled the upload web services functions in the DEMO tool. Of course, all the VMConnector web services functions are available in our evaluation and production version.

Now, if you feel like testing it on your own server
you can download the VMConnector evaluation versions !!!