JMSync - Cabinet Vision Integration

In this article:

What Is JMSync?

Installing JMSync

JMSync Set Up:

If You Are Using Cabinet Vision 2024-2025 (requires JMSync 1.0.4 or later)

If You Are Using Cabinet Vision 2023 or Earlier

Creating a Test Job with CV and JMSync

Troubleshooting and Advanced Set Up

Installing JMSync

Setting up Cabinet Vision with your product codes is easier with JMSync Installation.

If you don't have this program yet, please install JMSync 1.0.4.

1. Download, then extract this zip file.
2. Run the installer. (This will install the program and open JMSync.)
3. In Jobman, navigate to Settings > Integrations. (Note: This must be done by a Jobman Administrator.)
4. Select Cabinet Vision, then click Connect to Cabinet Vision.
5. You will see your login credentials displayed on the screen:       
6. In JMSync, go to Settings > Upload.                           
7. Enter the details shown on the Cabinet Vision screen in Jobman:

8. You should now see in Jobman that you are connected:

   

JMSync Set Up

If You Are Using Cabinet Vision 2024-2025

1. In JMSync, navigate to Reports:

   

2. Click Add New.
3. Name: CV(Version Number) Materials 
4. Connection Method: SQL Database
5. Copy the following connection string: mssql://(localdb)/CV25/CV-
6. Paste into the Connection String field (see image above)
7. Locate your Report.mdf file on your computer. This is typically located in C:\ProgramData\Hexagon\CABINET VISION\CV 2025\Database\report.mdf

Note, this connection string may need to be adjusted for your local environment. You may have to load Microsoft SQL Server Management Studio to find the correct path to the report.mdf file for your environment.

8. Copy and paste the report location string (from step 7) into the Connection String field after "mssql://(localdb)/CV25/CV-"

   Your connection string should now look something like this:

   mssql://(localdb)/CV25/CV-C:\ProgramData\Hexagon\CABINET VISION\CV 2025\Database\report.mdf

   It could also look like this:

   mssql://(localdb)/CV25/CV-C:\Cabinet Vision\CV 2025\Database\report.mdf

9. Leave the SQL Username and SQL Password fields blank.
10. Leave Update Frequency off
11. Click Load Tables. You will need to select the following as a minimum:

• Accessories
• Cabinets
• CXMaterials2 
• CxMaterialVendor
• CxPart2 
• Job Info 
• Parts 
• Rooms 

If you are missing any of these tables, see Troubleshooting.

12. Click Save.

If You Are Using Cabinet Vision 2023 or Earlier

1. In JMSync, navigate to Reports:
2. Click Add New.
3. Name: CV(Version Number) Materials 
4. Connection Method: Local File

5. Locate your Report Database:

   (For local installations): C:\Cabinet Vision\Solid_(CV Version Number\Database\Report.accdb 

   (For network installations): <server name or mapped network drive letter>/cabinetvision (or planit)/users/<user profile>/Report.accdb

• Note: If you are using CV 2022 or earlier, you will need a Report.mdb file, not Report.accdb.

6. Click Load Tables. You will need to select the following as a minimum:

• Accessories
• Cabinets
• CXMaterials2 
• CxMaterialVendor
• CxPart2 
• Job Info 
• Parts 
• Rooms 

7. Click Save.

Creating a Test Job with CV and JMSync

1. Ensure you have a piece of hardware set up in CV (e.g. a hinge) with an SKU (see example below).

2. Create a new job in CV that has the same job number as one of your test jobs in Jobman. The job should include a two-door cabinet that contains your example hinge.
3. Save all changes to the job in CV.
4. In CV, navigate to Reports.
5. Run any report. (This will populate Cabinet Vision's database with the information that Jobman requires.)
6. Run JMSync. (In the main window, click Upload [Report Name].)

7. You should see a Success window pop up:

   

Troubleshooting

Q. I clicked Load Tables and the program froze.

A. This is caused by an issue with your Connection String. Double-check that the path to the Report.mdb is correct and contains no typos. If it is correct, contact help@jobman.com for further support.

Q. I clicked Load Tables and I'm missing some of the tables to be uploaded required.

A. If you cannot see the CxMaterialVendor table, you will need to enable this by following these steps:

1. From the main screen of Cabinet Vision, open any job.
2. Navigate to Report Centre.
3. Click Set Up Reports.
4. In the next screen, go to Material Summary.
5. Click the (+) icon, then in the table, select Material Vendor Map.

5. Click Save and you will now have created the required buttons to run the profiles. 

Example: 

When correctly mapped, the tables should show as below.

Select Cabinets/CX Part/Job Info/Parts/CX Material (Highest number)/CX Part/Rooms and then save. 

Once the report is uploaded, q "Success" notification will appear, displaying materials and quantities added to the Materials list for that job.  

Clicking Upload CV11 Hardware will verify product codes in Cabinet Vision against Jobman, as shown below.

The Materials list will be now populated. If you had this screen already open, you will need to refresh. 

What Next?

Populate Job Materials from Cabinet Vision

See Managing Job Resource Materials for more info.

Populate Job Deliverables from Cabinet Vision

See Populating Deliverables with Cabinet Vision and JMSync for more info.

Populate Jobman's Catalogue from Cabinet Vision

This is considered an advanced procedure, and is not supported by Jobman. It can, however, save time creating your Catalogue if done correctly.

You will need some freeware, such as MDB viewer Plus (http://www.alexnolan.net/software/mdb_viewer_plus.htm), and proficiency with Excel.

1. Open Cabinet Vision’s Report.MDB with MDB viewer Plus and navigate to the CXMaterialsColumn. 
2. Export to Excel and change the .txt extension to .csv. 
3. Open the .csv file and remove the data you do not need, then format the remaining data for importing into Jobman, using the guidelines found here: https://docs.jobmanapp.com/article/167-importing-catalogue-items