Static values

You can put any static value in the cell as the field value. For example, given that we have a ‘text_with_summary’ field called ‘Body’. You can put the content HTML of the page directly into the cell in the ‘Body (body)’ column. During the import process, the Workbench will store the static values as-is.

Tokens

Tokens are used for dynamically-generated field values. During the import process, the Workbench will parse the token and generate the value based on the token type.

Tokens are specified in the following format:

[TokenType:TokenValue]

Currently, the Workbench supports the following types of tokens:

Rule tokens

Rule tokens are used to specify a rule for the field data. They use the convention [rule:ruleID]

  • For example: [rule:1]

You can find the ID numbers for rules in the Rules tab.

File tokens

Files tokens are used to reference a file. They are usually used for file fields. They use the convention [file:fileID]

  • For example: [file:1]

You can find the ID numbers for files in the Files tab.

Include tokens

Include tokens are used to reference the content of external files.. They are very useful for when you have long content which is not appropriate to put directly into excel cells. With include tokens, you can put the content into individual text files, and only reference these files in the Excel. They use the convention [include:filepath]

  • For example: [include:include/intranet.html]

The filepath is the file’s relative path to the zip archive root folder. The zip archive root folder is the folder contains the ‘content.xlsx’ file. For example, you create a folder called ‘long-text’ under the root folder and a text file called ‘content.txt’ inside the ‘long-text’ directory. To reference the content of ‘content.txt’, you need to use the following token:

[include:long-text/content.txt]

Attribute tokens

Attribute tokens are mainly used for attributes of fields, such as the format and summary attributes of ‘text_with_summary’ fields.  The convention [attr:format=value] is used for the format attribute.

  • For example: [attr:format=rich_text]

The convention [attr:summary=value] is used for the summary attribute.

  • For example: [attr:summary=This is a summary of page 1].