JMSync - Cabinet Vision Integration

What is Cabinet Vision Integration & JMSync?

Cabinet Vision Integration

Maximising efficiencies whilst minimising waste is the goal of any business wishing to increase profits. Linking Jobman to your CAD CAM & accounting software will:

Reduced double data input.
Minimise human error.
Minimise time wasted.
Move processes along faster.
Highlight other inefficiencies.

Available for Cabinet Vision version 9 onwards Jobman can turn your BOM (Bill of Materials) into a Purchase Order while drawing down from any stock that you might have with the aid of JMSync.

JMSync

JMSync, is a standalone application that is designed to run locally for Cabinet Vision users that are responsible for purchase ordering. JMSync can be configured to read & send required information from Cabinet Vision’s access tables & convert them to a much smaller file size that is suitable for file transfer over the internet into Jobman.

Please Note: JMSync can query the report.mdb table for hardware items and the psnc_cv.mdb for sheet counting. Jobman can identify product codes in the report database (for hardware items) in the SKU field in versions 9 and onwards or by placing the #(productcode) after the description.

Board material quantities are only properly known when optimised and why it needs to point to the psnc_cv.mdb in the NC database. Currently there isn’t an SKU field in this database so placing a product code after the description on board materials is only possible for Jobman’s recognition to populate Jobman.

Information & Example:

Generating a bill of materials from Cabinet Vision can be done by yourself or is now supported by Cabinet Vision Australia as Solid Setup Plus: https://www.planitaustralia.com.au/solid-setup-plus

Jobman only requires Qty and Product Codes for importing.

For this to work :

Product codes between systems must match between Cabinet Vision and Jobman.
The sequential Job Number created by Jobman is required to name the Cabinet Vision file. This will be referenced by JMSync to send information to the correct place in Jobman.

The Product Code can be in either the material SKU field or after the material description by a# symbol.

Example: Blum Motion 110 Instera#71B3590

Install JMSync & Connect with Jobman

Setting up your Cabinet Vision with Product Codes is easier with JMSync Installation.

For the zip.file download for the JMSync installer please click here.

Download and double click to open the installer package once download is complete.
This will launch the pop up shown below, click on the 'Settings' button.
Click on the 'Upload' tab under settings.
Go to your Jobman Settings from the User Menu Panel & open 'Integrations'.
Click on Cabinet Vision.
Enter the details in the JMSync Installer to match in Jobman as shown below.

Now you've connected Cabinet Vision & Jobman you can create upload buttons by clicking into the 'Reports' tab in the Settings of your JMSync.

Double click on the installer to open JMSync

Click on the Settings button on the top right hand corner.

Materials Report

Name: CV(Version Number) Materials
Report Database (For local installations): C:\Cabinet Vision\Solid_(CV Version Number\Database\Report.mdb
Report Database (For network installations): Do a search for report.mdb on your server.
Select the tables to be uploaded:

Accessories
Cabinets
CXMaterials2
CxPart2
Job Info
Parts
Rooms

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, the ‘Success’ notification will display and show the add sheets and their qty added to the Job Raw Materials for that job number. 

Clicking on the Upload CV11 Hardware button 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.

Populating Jobman’s Catalogue from Cabinet Vision data

This is considered a slightly advanced subject and is not supported by Jobman. You can however reduce copious amounts of time depending on the amount of data you are trying to import.

Achieve this with a freeware such as MDB viewer Plus http://www.alexnolan.net/software/mdb_viewer_plus.htm and some Excel knowledge.

Open Cabinet Vision’s Report.MDB with MDB viewer Plus and navigate to the CXMaterialsColumn.
Export to Excel and change the .txt extension to .csv.
Open the .csv file and remove the data you do not needand make suitable for Jobman Material import as per this article. https://docs.jobmanapp.com/article/167-importing-catalogue-items