> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://support.robaws.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Importing projects

| Do read the [general information about data import](https://support.robaws.com/en/article/import-general-explanation-18g6g1c/) in Robaws as well.

## Projects

### Column titles
| Column title | Field in Robaws |
| ---- |
| UPDATE_BY | Field that is used for the update |
| NR | Number of the project |
| NAME | Planningname |
| STATUS | Status |
| STREET | Street |
| ZIPCODE | Postcode |
| CITY | City |
| COUNTRY | Country |
| CLIENTNR | Customer number, has to be the same as the column 'NR' in the tab clients |
| CLIENTNAME | Customer name, has to be the same as the column 'NAME' in the tab clients |
| ENDCLIENTNR | End customer number, has to be the same as the column 'NR' in the tab clients |
| ENDCLIENTNAME | End customer name, has to be the same as the column 'NAME' in the tab clients |
| DATE | Date |
| REF | Customer reference |
| PLANNINGGROUP | Planning group |
| RSZ | Yard nr. NSSO |

### UPDATE_BY
For projects, the update can be carried out on the basis of 2 fields:
* NAME:
The project is looked up on the basis of the planningname.
* NR
The project is looked up on the basis of the number.

||| So in the UPDATE_BY column you fill in NR or NAME, and not the value of the field — you do that in the column concerned.

### Tarifs

You enter the tarifs that are linked to the project through the tab 'articledeviation'. There you can link a tarif to a project by using the columns 'PROJECTID' or 'PROJECTNR'.