Import of Extended Texts for the ProBatch text module
The Import Extended Texts report can be used to import texts for the ProBatch text module. The texts can be imported for master data, e.g. items, vendors or customers, as well as for transaction data, e.g. sales orders and purchase orders.
Create Ext. Texts Import Template
The import is made from an Excel file. This must contain a specific format depending on the target table, that means the columns in the Excel file must be in a certain order. The Excel file can be created using the task Create Ext. Texts Import Template. This task creates one Excel file with several tabs, one for each target table, and the relevant fields.
Example: Import Standard Texts
The ProBatch Standard Text is filled as followed:
| Field | Description |
|---|---|
| Template Code | Code of the text module template that is assigned to this text module. The template code is used to set the fields for display/print control. |
| Text Type | Text type of the text module. The following values are permitted: - 1 or header text - 2 or footer text The column must be omitted, for example, when importing the item texts (that is, the text type column must not exist in the Excel file). |
| Description | Description of the text module |
| all languages / language code | The text can be valid for all (insert yes in the column all languages) or for a specific language. |
| Starting date, Ending date | Starting and Ending date of the validity of the text module. |
| Text | Text of the text module. The text can have a maximum length of 250 characters. To Import Extended Texts with more characters, the Excel file must contain several lines, each containing the same values in the other columns. These lines must be contained in the Excel file in sequence. |
Example: Import Text of a sales line
The Sales Line is filled as followed:
| Field | Description |
|---|---|
| Document Type | Inset the document type |
| Document No. | Document No. to which the text belongs. |
| Line No. | Document line no. to which the text belongs. |
| Template Code | Code of the text module template that is assigned to this text module. The template code is used to set the fields for display/print control. |
| Description | Description of the text module |
| Text | Text of the text module. The text can have a maximum length of 250 characters. To Import Extended Texts with more characters, the Excel file must contain several lines, each containing the same values in the other columns. These lines must be contained in the Excel file in sequence. |
Import of Text Modules
To start the import of the texts, start the Import Extended Texts function. The following options are available in the request window Import Extended Texts:
| Field | Description |
|---|---|
| Sheet Name | Here you must write the Excel sheet name that contains the data to be imported. |
| Import of Ext. Texts for Table | Select the assigned table for which the texts are to be imported. |
| Add Extended Texts | If this field is marked, then already existing texts for the respective master data record are not deleted and the texts contained in the file are created additionally. |
| Start with Line No. | This field can be used to specify the Line number from the Excel sheet from which the import is to take place. Example: The first row in the sheet is a header row. It is imported from line no. 2. |
After confirming with OK, a file selection dialog opens for selecting the Excel file containing the texts. When selected the file, the texts will be imported.
The Excel Sheets have to be imported individually.