AbleCommerce Client Tools

Version: AbleCommerce Client Tools (V4), version 5.6.0.0

Applies to: AbleCommerce 5.5, Asp.Net and CFMX versions

Download: AbleCommerce_ClientTools_V4.zip

Release Date:  9/5/2006

AbleCommerce Client Tools

AbleCommerce Client Tools is a separate download and installation of a client application that can be used with the latest versions of either AbleCommerce 5.5 Asp.Net or AbleCommerce 5.5 CFMX.  The utility can be used for several purposes.

The components of the installer include:

• Export data from an AbleCommerce 5.x store for importation to a 7.x store.  

• • To export your store, see the instructions below.

  • To import your store to AbleCommerce 7, see DataPort Utility instructions.

Theoretically, it is possible to import data from 3.x and 4.x stores to AbleCommerce 7, however, it has not been tested.

• Export data from an AbleCommerce 3.x, 4.x, or 5.x store for importation to a 5.x store.  

• Data Transfer utility for QuickBooks (from AbleCommerce to QuickBooks)

• Data Transfer utility for UPS WorldShip (from AbleCommerce to Worldship, and Worldship to AbleCommerce)

System Requirements for Store Export Utility

• Requires a datasource connection to the AbleCommerce database(s)

• Microsoft .NET Framework Version 1.1

System Requirements for Data Transfer Utility

• The ability to access an AbleCommerce 5.x store with an Admin username/password

• Microsoft .NET Framework Version 1.1

• Tested and supported for QuickBooks 2005 or QuickBooks 2006 (Standard and Pro editions only)

• Tested and supported for UPS WorldShip (versions 4.0 through 7.0)

INSTRUCTIONS to INSTALL

1. Download the utility using the link above.  After extracting the AbleCommerce_ClientTools.msi, double-click to install.

2. Once the client tools are installed, you can access the Export Utility by going to Windows Start > Programs > Able Solutions > AbleCommerce Client Tools > Store Export Utility

RUNNING THE STORE EXPORT WIZARD

For 3.x versions:  You will need to create two (2) datasources if you are exporting from a 3.x installation.  The first one should be to the "main" database and the second should be to the associated "security" database.  During export, you will enter the "main" datasource first, and you will be prompted to select the second "security" datasource.

For multiple store exports:  If you have multiple stores in each database, you will have an opportunity to select which stores you want to export.  We recommend exporting one store at a time.

1. Select the datasource that contains the AbleCommerce storegroup data.

2. If the database is password protected, then enter the Username and Password.

3. The default location of the new Export XML file is c:\acexport.xml, change this if desired.

4. Click the Next > button to continue and a page similar to the following will be displayed.
    

5. Available stores will be displayed in the left-side frame, select one or more stores and click the ">" button to move them into the right-side frame.

6. Click the Next > button to continue. A page like the one shown below will appear.
    

7. Click the Start button to begin. Wait for the progress meter to indicate completion and click Finish.

POTENTIAL ERRORS:

Using an AbleCommerce 5 CFMX - build 1357 database -

When exporting with latest version of the Client Tool, you may get an error similar to this:

Invalid column name PaymentStatus and PaymentStatusReason.  

Add the following two columns to the PAYMENTS table and re-run the export.  

paymentStatus (int)

paymentStatusReason (nvarchar)
 

Change Log

This section is a log of the changes that occur to the AbleCommerce Client Tools.  The latest version and download are available in the section above. Each change is documented in the list below.  

Further development on this utility has been discontinued.

AbleCommerce Client Tools - Data Export utility for AbleCommerce

AbleCommerce Client Tools - Data Transfer utility for QuickBooks

AbleCommerce Client Tools - Data Transfer utility for UPS WorldShip