Import CSV/Excel data Into Cubit Pricelist Follow

Importing a price list from a CSV/Excel file is a very similar process to the process for importing a job that was discussed in the first half of this document. To import the price list you can follow these steps:

1) First you will need to create a new price list that you can import the CSV/Excel information into. You can do this by clicking the arrow under the ‘New Job’ button on the ribbon of the Job Manager screen, and selecting ‘Price List’.




2) Once you have created the new price list, open it up and click the Excel button on the ribbon.



3) When you click the Excel button you will get an import window appear. Click the button that has three dots on it next to where it says ‘File:’


4) The next window to pop up will be the Open windows. Browse to the location where you have the CSV/Excel file saved, highlight the CSV/Excel file and click the Open button. 



5) The import window will appear displaying the information in the CSV/Excel file. On this screen you will need to tell the software what columns refer to what information. This is done by selecting the column type from the ‘Source Column:’ section on the right hand side of the window. Once you have selected the columns click the insert button.


After following these steps the information will have been imported into the price list, and you will now be able work on this information in Cubit.

Please note: Import can sort the data upto 2 levels (Trade and Item) only. 

Sample CSV/Excel template shown below to import items under every Trade.

 TradeHeading1   Trade1Item1 Column1 column2 column3 etc
 TradeHeading1   Trade1Item2 Column1 column2 column3 etc
 TradeHeading2   Trade2Item1 Column1 column2 column3 etc
 TradeHeading2   Trade2Item2 Column1 column2 column3 etc
 TradeHeading2   Trade2Item3  Column1 column2 column3 etc
 TradeHeading2   Trade2Item4  Column1 column2 column3 etc
 TradeHeading2   Trade2Item5  Column1 column2 column3 etc
 TradeHeading2   Trade2Item6  Column1 column2 column3 etc
 TradeHeading2   Trade2Item7 Column1 column2 column3 etc
 TradeHeading3 Trade3Item1 Column1 Column2 Column3 etc

 

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.