/
How to Import Company Parameters

How to Import Company Parameters

You can export the Parameters table to XLSX or CSV, modify the data and import the modified table back to Pricefx.

  1. Go to the table that you want to export and in the 3 Dots menu select the Import Parameters option.

    Do not use the Export option to export the table. The exported file will not contain the table header and you will not be able to correctly import it back.

  2. In the Import Parameters dialog Step 1, click Export CSV or Export Excel.

  3. Edit the exported file as needed but do not change the header.

  4. Import the file back to Pricefx using the Step 2 Upload CSV or Excel file button.

  5. Decide if you want to append or overwrite the existing data.
    Note that any filters applied to the Company Parameters table are disregarded when you export the table, meaning that it will always contain all the data. When you import the file back and select the ‘Overwrite all existing data’ option, it will overwrite all the data, not only the visible filtered rows.

    • Add new lines to existing data – Valid records from the uploaded file will be added to the existing records. Records with duplicate keys will be omitted.

    • Overwrite all existing data – After import, the table will mirror the content of the upload file (though only valid records will be imported). Records that are not in the upload file will be deleted without any recovery option.

  6. Click Import.

Note:

  • For a correct import back to Company Parameters table, the header must respect the format label [column_name] for columns. This means that the label cannot contain square brackets ([ ]) as it would break the import.

  • When importing matrix tables, there is a character limit for each cell: Matrix,Matrix2, Matrix3 - 255 characters, Matrix4 - 150 characters, Matrix5-6 - 100 characters.

 

Related content

Import or Export Line Items
Import or Export Line Items
More like this
Company Parameters
Company Parameters
Read with this
How to Import Company Parameters
How to Import Company Parameters
More like this
Managing Data in Pricefx Using Excel Client
Managing Data in Pricefx Using Excel Client
More like this
Lookup Tables / Company Parameters (Quick Reference)
Lookup Tables / Company Parameters (Quick Reference)
Read with this

Found an issue in documentation? Write to us.

 
Pricefx version 14.0