Database Conversion from Jamison Computer Systems

 

The following article provides step-by-step instructions for extracting data from a business application called “Wholesale Distribution” developed by Jamison Computer Systems.    There are two database extraction methods that can be used to convert data from a Jamison Computer Systems application to  ManageMore Business Software.    ManageMore provides a built-in database mapping tool that can be manually used to convert data from nearly any software system and  works best with software applications that provide straightforward file export to XLS, CSV, or TXT file format.   Our second database conversion option is a more custom software conversion process which offers a higher level of data extraction,  but will need to be evaluated by our development team to ensure you  have a compatible Jamison software version that we have successfully converted other clients from.   In general, our recommendation is to use the second option mentioned if your software is up to date with the developers current release.

 

Database Conversion Method 1 (Import Mapping Method)

This method is our traditional conversion technique used for most software applications our clients were previously using.   We recommend you skip this section and go straight to the more refined Database Conversion Method 2, unless you have been instructed by our development team to use this method because of potential issues with an outdated Jamison Computer System release or when there is a problem accessing the Jamison Computer System (JCS) database directly.

 

Database Conversion Method 2 (Custom Software Conversion – RECOMMENDED)

This method should work for most users who are on a relatively updated software release of Jamison Computer Systems(JCS) application.  The steps here involve using an application you will download (referred to as MDB Viewer Plus) and using this tool to access the Jamison database for exporting.    Once you have extracted the necessary databases, you will continue the rest of the conversion process from within the ManageMore program.

Jamison stores all of your database information in a file called wsdist.mdb.  You must be able to locate this file on your pc or computer network in order to extract your database and perform the ManageMore database conversion.  If you are not familiar with how to find this file using Windows File Explorer,  please call our technical support for assistance.   The step-by-step instructions will assume you already know where your current program and wsdist.mdf database resides.

Here are the step-by-step instructions for extracting data from JCS.

1. Download the MDB Viewer Plus program into the same folder where your Jamison Computer Systems application currently resides.  This should be the same folder name that contains your application database called wsdist.mdb.
(by default, Jamison uses the folder named \wsdist for the application and the database itself)

2.  After this program is download, run the mdbplus.exe application.

3. Click on the folder icon within the MDB Viewer Plus to open the wsdist.mdb database (See Figure 1).


Figure 1: MDB Viewer Plus application

 

4. Select the wsdist.mdb file to open (see Figure 2)


Figure 2: Select MDB File

 

5. Choose “Select tables to open” and press OK.

Figure 3: Open Options

6. Select the appropriate tables you want exported (See Figure 4).

Figure 4: Select tables to Open

7. Select the Inventory and choose Data… Export Data…

Figure 5: Data Export

 

8. Now export the Customer database.

Figure 6: Export Customer Table


Start the ManageMore Conversion Process

Once all relevant database files have been exported from JCS, you are ready to start the conversion process in ManageMore.  We will assume you have already created a company profile for your business (i.e. File… New Company…) and are ready to import your database.  1. From the main menu, go to File… Open Company… and to enter your company database.  
2. From the main menu, go to File… Convert Database… Custom Software…

3. Select “Jamison Computer System” from the drown down list of conversion programs.

4.  Select the import files you created into the appropriate fields.

5. Click Finish to start the conversion process.

6. Evaluate the database conversion and contact technical support if you have any further questions.

 

Conversion Issues Detected… What Do I Do?

There are a few possible scenarios where your database may not have converted as you were expecting.  

a. The software version you are using from JCS is too old or JCS has possibly made very recent changes to their database tables and our development team will need to adjust ManageMore to address the changes introduced.

b. Your recorded certain data in JCS fields that ManageMore was not looking for.

c.  Your JCS database is corrupt and not all data exported properly.

We recommend you contact technical support to report any issues with the converted database.