CabMaster Imports How To V11

Importing Data into CabMaster Software

Attached is a simple Excel file that could be used to try this.

Importing Data into CabMaster Products

CabMaster and its associated products have the ability to import a wide variety data directly to the program, in this document we will outline how to import settings for cabinets.

How to Import

To start with, there are 2 different items to import.

1, Global settings, such as Job No, Customer name & address etc. These items are common for the entire job and there values are found under Drawing Properties.

2, These are Cabinet / Parts and their associated properties. This is where you select a Floor 1 Door Cabinet and you can specify such things as its width, height and materials etc. These items are all cabinet / part specific.

Both Global and Cabinet properties are imported differently from within the import file but this will be discussed further later it this HowTo.

When preparing to import a value, you first need to find its field, in this case we would like to import the global “Address” field found under Drawing Properties / “My Setup”.

Import Data into CabMaster

Once found, hover the mouse over the field and a popup will appear below, this tells you the variable we will need. In this case “AccountAddress1” is the variable we are after (the variable will always follow ‘for’). This can be done for as many Global values as required. 

For this example we will take the “Floor 1 Door”.

This is the name of the cabinet we will import, it is very import to get this name correct.

We can then setup to import Cabinets/Parts by finding their name. To do this we can look for the desired cabinet in the Cabinet drop down list, as per example below. This is the name of the cabinet we will import. It is very important to get this name correct.

Import Data into CabMaster

The only limitation here is the Cabinet / Part name MUST be in the currently loaded library when you import the list file into CabMaster, otherwise it won’t be found and will be ignored.

The last thing we need are the values we would like to change on the Cabinet / Part, such as Height or Width etc.

These are found the same way as the Global variables except this time we are looking at the fields on a Cabinet. As per the example below, we can get the variable for “Width” we simply hover the mouse over that field, then the popup will appear below with the required variable. In this case “CabWidth” is the variable we are after (the variable will always follow ‘for’).

This process can be repeated for as many Cabinet / Part variables required.

Import Data into CabMaster

Generating an import file

Now that we know what we want to import, it’s time to create the import file.

Firstly, we need to look at the “Global” values we discussed. Global values get input first, they all require a ~ (Tilde) in front of them to show they are a “Global” value and they read left to right.
Import Data into CabMaster

They are then followed by the Cabinet / Part values which are in rows and column format with a header field first, of the variable required.

These always start with first field being “code”, this is the name of the cabinet / part required then followed by all the other variables going left to right as headers and the required values for each Cabinet / Part going top down.

Import Data into CabMaster

NOTE: ONLY the values you wish to change from default are required to be filled in, as per the example below, 1 cabinet my require a field changed and the next Cabinet may not, so this field can be left blank.

A completed file should look something like the sample below.

Import Data into CabMaster

Please also note that global values are not actually required for this import to work successfully, so if no global values are required for an import, the entire top section that starts with the ~ can be removed and the import files first line should be the “header” line starting with “code”.

Creating an import file

These files can be created from a number of different programs, such as ERP or Design program, Text Editor, from a WebSite page or even in Excel.

They are a simple Tab delimited format file.

Saving the import file (From Excel)

Now we have all our data in the file we need to save it as a tab file format.

To do this, we need to save the file as tab format as shown below, however as this will only change the extension to a .txt, we will then need to change the file extension from .txt to .tab manually as CabMaster will not import a .txt file.

Import Data into CabMaster

Importing into CabMaster

Importing this list file into CabMaster can be achieved by navigating to the file menu (The CabMaster Box) in the top left of the program, navigate to import and then select “Import Item List”.

Import Data into CabMaster

Now all we need to do is select the tab file we have created and we have successfully imported our file.

TIP: Click the attachment to download this HowTo to your desktop as a .pdf

    • Related Articles

    • Customising a cabinet in CabMaster Software

      Customise a Cabinet Cabinets can be customised before or after they are placed on the drawing. For comprehensive discussions see also the following: CabMasterPro Help topics [F1] : Topic Discusses Cabinet Properties Different ways to select cabinets ...
    • Opening Earlier Version Drawings in CabMaster V10.1

      If you are using a Cloud2 Licence, the earliest version of CabMaster you will be able to open is V10.1 This Document will show you how you can open V8, V9 and V10 drawings in CabMasterV10.1 Note: You cannot import drawings using Designer CL or ...
    • What's New - CabMaster V10.1 Build 80 Release Update

      Attached is a document that shows what is new in V10.1
    • Understanding Universal Cabinets

      Universal Cabinets The Universal cabinets have been designed as highly customisable, versatile options within CabMaster. A single Universal cabinet can be used to create something as large as a full-sized wardrobe, or something as small as a standard ...
    • How to run CabMaster as Administrator in a Domain Setup

      CabMaster Software will always be wanting to run as an Administrator, so if you are working in a Active Directory environment and restricting local admin rights then you will need to look at this article link below from Microsoft, the except from the ...