The simplest method to use is to create a CSV list with the columns listed below in that order. You can leave values blank in the columns. You can download a sample here to start with.
Qty, Part, Color1, Color2, Modifier, Element
To create the Import Source, go to an MR and click the Import button. Then right-click on the list of Import Sources and Add a new one and name it accordingly, like 'Adesk CSV' or something.
Once it's been added, right-click the new source and Change Type to CSV (with or without a header row, the sample has a header). Then you can select the source and click OK to start an import.
The way the imports work is it will let you map materials as you import. You should see a list of materials on the right from the CSV and you would fill in the columns on the left for the corresponding material in CN. You can add new Parts/Colors on the fly as you go as well. It will store these mappings and load them the next time you import from that source.
How to import from Cabinet Vision
This sequence was captured from support issue HLP-6412 for a customer’s specific format. The TXT query is included as an example and may need tailoring for each instance.
Create the import
Open Crows Nest (CN) and go to any existing MR on any Project
Click the Import button on the MR
In the ‘Select a Source’ window, right-click then click on or hover over ‘Add’ to open the flyout textbox on the right, enter a name for the import like ‘CV’ and then press Enter
Right-click the new source and ‘Change Type to…’ then ‘MS Access Database File’
Then right click the new source and click ‘Edit Query’
Paste the contents of the file below (MR Import from CabinetVision.txt) into the query editor window and then click OK
Use the Import
Open Cabinet Vision (CV) and open the job you want to import
Go to Report Center and load the Material Summary (optimized) report, this will populate the Report.mdb file with the necessary data.
Go to Crows Nest (CN) and make a new MR on the matching Project
Click the Import button
Select the CV source in the list and click OK. The first time you do this, you’ll need to browse to the location of your Report.mdb file. You may need help to find the right one. The next time you import, you can right-click the CV source in the list and uncheck the ‘Prompt for File’ option and you won’t have to select the file each time.
This should open the ‘Import MR Items’ window with the data loaded from the CV data file so you can map the materials from CV to CN and populate the MR.