Follow

How to import a csv file into a MaxCut Job

MaxCut has the functionality to import sheet materials, edging materials, hardware materials & input items jobs in via a csv file. The following describes how to import input item jobs into MaxCut using a csv file format.

What is a csv file

A csv file format is a text based file format that many programs use to export/import information including software like Microsoft Excel.

Below, I've edited a csv file in excel with various panels I would like to import into MaxCut.

Excel_file.png

Importing into MaxCut

In MaxCut, to import a csv file click the Import button on the Input Items tab.

Import_csv_file.png

You then will be asked to select which csv file you would like to import. Select the appropriate csv file.

Import_file_dialog.png

You will then be presented with a import screen. On this screen you will need to ensure several things...

Delimiter used in the csv file

You will need to determine what delimiter was used in the csv file and tell MaxCut this.

Delimiters_Selection.png

If you select the incorrect delimiter the preview will show you that it is messed up. In the below example I've selected "space" as my delimiter which is incorrect for this file resulting in the preview showing incorrect results.

Incorrect_delimiter.png

Match csv columns to correct MaxCut fields

On the sidebar you need to match the csv columns up with the relevant MaxCut fields.

Import_Columns.png

Exclude First Row

You will also need to determine whether MaxCut should exclude the first row of the import file. Usually this is the case as this row would describe the column headers.

Exclude_first_row.png

Once you have matched things up correctly

Once all your settings are correct, the preview section should resemble what your file looks like.

Correct_matching.png

On clicking the "Import" button these items will now come into the MaxCut job.

MaxCut_Job.png

Help getting your csv format correct

Download an example csv file

You can download an example of a csv file to have a working copy to work towards that you can edit.

Export a csv file from MaxCut

Another way to get an example csv file is to add some input items into MaxCut, export them and then look at the example csv file it creates. You can do this by.

Adding example items to a job

Example_Job.png

Selecting the export job option from the toolbar.

Export_Button.png

Selecting just the default values from the export dialogue and clicking the export button.

Export_Dialogue.png

This will then prompt you where to save your csv file. Once saved you can open this file in an editor like Excel or a text editor and play around with the values.

Excel.png

0 Comments

Please sign in to leave a comment.
Powered by Zendesk