❗
Note: ISPnext does not process imports on request.
This must be carried out by a user with 'Client Administrator' rights
This must be carried out by a user with 'Client Administrator' rights
When you use the import process 'Contracts - Import contracts', you need to upload a file containing contract data. For this, use the template that you can download in step 2 of the import process.
Below all columns from the import template are explained. If the import file does not meet these requirements, the import will fail.
Below you can see an example of part of a correctly completed import file:
These contracts will be added as active contracts and will be visible after the import in Contracts > Contracts > Active. Do not include existing contracts in the import sheet to avoid duplicate contracts.
| Column | Explanation | Requirements | Mandatory |
| Contractid | The reference number of the contract. In the contract this is the column 'Ref.'. | Maximum 50 numeric characters. | Yes |
| SupplierReference | The reference number of the supplier in Vendors to which the contract must be linked. | Maximum 50 alphanumeric characters. | Yes |
| ContractName | The name of the contract. | Maximum 200 alphanumeric characters. | Yes |
| ContractDescription | A description of the contract. | Maximum 500 alphanumeric characters. | No |
| ContractNumber1 | Enter the first contract number here. In the contract this is the column 'Contract number - 1'. | Maximum 50 alphanumeric characters. | No |
| ContractNumber2 | Enter the second contract number here. In the contract this is the column 'Contract number - 2'. | Maximum 50 alphanumeric characters. | No |
| ContractNumber3 | Enter the third contract number here. In the contract this is the column 'Contract number - 3'. | Maximum 50 alphanumeric characters. | No |
| ContractStartDate | Enter the start date of the contract here (DD-MM-YYYY). | A valid date in the DD-MM-YYYY format. | Yes |
| ContractEndDate | Enter the end date of the contract here (DD-MM-YYYY). | A valid date in the DD-MM-YYYY format. | Yes |
| ContractStatus | Enter the name of the contract status here, found in Admin > Contract settings > Tables > Contract statuses. | Maximum 50 alphanumeric characters. | No |
| ContractType | Enter the name of the contract type here, found in Admin > Contract settings > Tables > Contract types. | Maximum 50 alphanumeric characters. | No |
| ContractCostCentre | Enter the reference of the cost centre here, found in Admin > Tables > Cost centres. | Maximum 50 alphanumeric characters. | No |
| ContractTerminatePeriodNum | The number of times the specified contract termination period (ContractTerminatePeriod). | Maximum 50 alphanumeric characters. | No |
| ContractTerminatePeriod | The contract termination period (day, week, month, quarter, year). | Maximum 50 alphanumeric characters. | No |
| ContractOptieStilzwijgendVerlengen | Indicate whether the contract may be tacitly extended (True, False) | Maximum 50 alphanumeric characters. | No |
| ContractVerlengTermijnNum | The number of times the specified contract extension period (ContractTerminatePeriod). | Maximum 50 alphanumeric characters. | No |
| ContractVerlengTermijn | The contract extension period (day, week, month, quarter, year). | Maximum 50 alphanumeric characters. | No |
| ContractRemarks | Comments on the contract. | Maximum 500 alphanumeric characters. | No |
| ContractAantalVerlengingen | The number of times the contract may be extended. | Maximum 50 alphanumeric characters. | No |
| ContractOwner | The display name of the contract owner, found in Admin > General settings > Users > Active. | Maximum 100 alphanumeric characters. | No |
| ContractParent | The name of the main contract, found in Contracts > Contracts > Active. | Maximum 200 alphanumeric characters. | No |
| ContractProcedure | The contract procedure name of the contract procedure to be linked to the contract, found in Admin > Contract settings > Tables > Contract procedures. | Maximum 50 alphanumeric characters. | No |
| ContractCompany | The name of the company to be linked, found in Admin > Tables > Companies. | Maximum 50 alphanumeric characters. | No |
| ContractIndexInfo | Enter indexing information for the contract here. | Maximum 250 alphanumeric characters. | No |
| ContractInkoopvoorwaarden | Indicate whether the purchasing conditions have been accepted (True, False). | Maximum 50 alphanumeric characters. | No |
| ContractProjectNummer | Enter the project number of the linked project. | Maximum 50 alphanumeric characters. | No |
| ContractWeging | Enter how often this contract counts in Vendor Rating calculations. | Maximum 50 alphanumeric characters. | No |
| ContractOpdrachtgever | The display name of the client, found in Admin > General settings > Users > Active. | Maximum 100 alphanumeric characters. | No |
| ContractNoCompliance | Indicate here whether this contract should be taken into account when calculating contract compliance in Spend (True, False). | Maximum 100 alphanumeric characters. | No |
| ContractSjabloon | Enter the name of the contract template to be linked here, found in Admin > Contract settings > Tables > Contract templates. | Maximum 100 alphanumeric characters. | No |