> ## 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 posts

For the import of the posts, the 'posts' and 'postslines' tabs are used. The connection is made on the basis of the 'CHAPTER' column. This has to be the same on both tabs so the lines are linked to the right post. 

## Importing or would you rather duplicate?

#### Importing
Importing posts has advantages, but certainly disadvantages as well: it is only possible to import the **content of the post** (fairly complex), but if you then want to add **formulas and parameters** to your posts, you have to do that manually again for every post, one by one.  Those cannot be imported.

#### Duplicating
That is why we often advise you to work out one post thoroughly by hand in Robaws first, and then **duplicate** it.  That way you duplicate all formulas and parameters as well, and you only have to adjust the items in the calculation per post.  This saves a lot of work if you use parameters and formulas.

| Make sure you also read the [general information about data import](https://support.robaws.com/en/article/import-general-explanation-18g6g1c/) in Robaws.

## Posts

##### Column titles
| Column title | Field in Robaws |
| ---- |
| UPDATE_BY | Field that is used for the update |
| NAME | Post name |
| NR | Number |
| UNITTYPE | Unit |
| SALEPRICE | Selling price |
| DESCRIPTION | Extra description |
| POSTTYPE | Post type, this is how you set the line type - You enter a specific value for this. (see below) |
| CALCULATIONTYPE | Cost type (see overview below) |
| AGREEMENTTYPE | Type (SOG, FH, ... ) |
| ACTIVITY | Activity |
| ARTICLEGROUP | Item group |
| DEVIANTSALESNAME | Salesname |
| BTWTYPE | VAT tariff |
| CHAPTER | Post number |

|| Enter the VAT tariff with the exact name of the tariff as it appears in Robaws, for example: 21%, 6%, ..
|| For the activities and item groups, Robaws looks for a match in the database. If an exact match is found, it is linked to the item. If not, a new item is created that is linked to the item straight away.  Please note, the search is case sensitive!

###### Cost type
Possible values for the cost type:
* Arbeid (= labor)
* Material (= material)
* OA (= subcontractor)
* Materieel (= equipment)
* Kost  (= Indirect costs)

###### Post type

* Line: P
* Title: H
* Total: T
* Quantity: A
* Check: C
* Variant: V
* Text: Tx
* Chapters: H1, H2, H3, H4, ...


### UPDATE_BY
For posts, the update can be carried out on the basis of 4 fields: 
* ARTICLEID :
The most accurate way to update an existing post, because the id is always unique. You find the id in the export of the posts. 
* NAME:
The post is looked up on the basis of the name. 
* NR
The 3rd way is on the basis of the number, and is only possible if you work with numbers. 
* CHAPTER
Finally, you can opt for chapter, and then Robaws searches on the post number

||| So in the UPDATE_BY column you fill in ARTICLEID, NR, CHAPTER or NAME and not the value of the field, which you fill in in the column concerned.

## Post lines
The 'CHAPTER' column is always mandatory because it is what makes the link with the post. 

##### Column titles
| Column title | Field in Robaws |
| ---- |
| NR | Post number, has to be the same as the 'CHAPTER' column on the posts tab |
| AMOUNT | Quantity |
| UNITTYPE | Unit |
| PRICE | Selling price (see the explanation [below](#6-price-and-costprice)) |
| COSTPRICE | Cost price (see the explanation [below](#6-price-and-costprice)) |
| DESCRIPTION | Description |
| ACTIVITY | Activity |
| ARTICLENR | Item number, has to be the same as the 'NR' column on the articles tab |
| CALCULATIONTYPE | Cost type (see the overview [above ](#6-cost-type)for the options) |
| PRICESTRATEGY | The pricing strategy for the line (see the overview [below ](#6-pricestrategy)for the options) |

###### Price and costprice
By default, the post lines in Robaws follow the price of the item (pricing strategy 'follow item price').  
If you want to deviate from that, you can import a different selling price and cost price.  Robaws then calculates the margin automatically.  
In that case, set the pricing strategy to 'custom price'.

|| It is not possible to import the margin of the post lines.  Calculate the cost price and the selling price and import those, with pricing strategy 'custom price'.  The margin is calculated in Robaws.

###### Pricestrategy
With the import you can also import the pricing strategy for the lines of the post.
You have the following options:

* FOLLOW_ARTICLE_PRICE: follow item price
* CUSTOM_PRICE: custom price
* CUSTOM_MARGIN: custom margin