Create an import-definition: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
Zeile 30: | Zeile 30: | ||
=== Preview === | === Preview === | ||
This is a view of the data structure of the import file. | This is a view of the data structure of the import file. | ||
==== Encoding ==== | |||
If the encoding of the data source could not be determined, it must be manually defined here. | |||
The supported encodings of the .csv files can be found in the table below: | |||
{| class="wikitable" | |||
|- | |||
! style="text-align: left ; scope="col"| Encoding | |||
! style="text-align: left ; scope="col"| Supported | |||
|- | |||
! style="text-align: left ;scope="row"| UTF-8 | |||
| The encoding is supported and automatically recognized. | |||
|- | |||
! style="text-align: left ; scope="row"| UTF-16 BE | |||
| The encoding is supported and automatically recognized. | |||
|- | |||
! style="text-align: left ; scope="row"| UTF-16 LE | |||
| The encoding is supported and automatically recognized. | |||
|- | |||
! style="text-align: left ; scope="row"| UTF-8 | |||
| The encoding is supported but not automatically detected. | |||
|- | |||
! style="text-align: left ; scope="row"| ANSI Latin 1 | |||
| The encoding is supported but not automatically detected. | |||
|- | |||
! style="text-align: left ; scope="row"| ANSI Cyrillic | |||
| The encoding is supported but not automatically detected. | |||
|- | |||
! style="text-align: left ; scope="row"| 8859-1 Latin 1 | |||
| The encoding is supported but not automatically detected. | |||
|- | |||
! style="text-align: left ; scope="row"| 8859-5 Cyrillic | |||
| The encoding is supported but not automatically detected. | |||
|- | |||
! style="text-align: left ; scope="row"| 8859-15 Latin 9 | |||
| The encoding is supported but not automatically detected. | |||
|- | |||
! style="text-align: left ; scope="row"| UTF-32 BE | |||
| The encoding is not supported. | |||
|- | |||
! style="text-align: left ; scope="row"| UTF-32 LE | |||
| The encoding is not supported. | |||
|- | |||
|} | |||
=== File settings === | === File settings === | ||
==== Column headings ==== | ==== Column headings ==== |
Version vom 5. August 2020, 12:21 Uhr
You can use the data import to integrate a very large number of records from .csv or .txt source files quickly in the firesys environment. The data import reads out the records, they can be individually modelled and then transferred to the firesys MeetingPoint.
The functions
Create an Import definition
Define how the data from the upstream system is transferred “modelled” to the MeetingPoint with the help of firesys.
Vorlage:Video-Import-Definition erstellenENG
File selection
Data source
Clicking on the radiobutton opens the file selection dialog in which you can select .csv or .txt files.
Details
Title
The title serves to visually differentiate the import definitions in the manager. The title must be unique and is restricted to 150 characters.
Description
The description serves to visually differentiate the import definitions in the manager. The entry is restricted to 255 characters.
Target in the MeetingPoint
Account group
An existing account group must be selected from the MeetingPoint into which the data is imported.
Key date
An existing key date can be selected from the MeetingPoint or a new key date can be entered. All data in the data source is imported on this key date during the import.
File settings
Preview
This is a view of the data structure of the import file.
Encoding
If the encoding of the data source could not be determined, it must be manually defined here.
The supported encodings of the .csv files can be found in the table below:
Encoding | Supported |
---|---|
UTF-8 | The encoding is supported and automatically recognized. |
UTF-16 BE | The encoding is supported and automatically recognized. |
UTF-16 LE | The encoding is supported and automatically recognized. |
UTF-8 | The encoding is supported but not automatically detected. |
ANSI Latin 1 | The encoding is supported but not automatically detected. |
ANSI Cyrillic | The encoding is supported but not automatically detected. |
8859-1 Latin 1 | The encoding is supported but not automatically detected. |
8859-5 Cyrillic | The encoding is supported but not automatically detected. |
8859-15 Latin 9 | The encoding is supported but not automatically detected. |
UTF-32 BE | The encoding is not supported. |
UTF-32 LE | The encoding is not supported. |
File settings
Column headings
If this option is activated, the headings are read out from the first row of the import file.
If this option is activated, the first row of the import file is read out as the record.
The column headings are displayed in the dialog with column 1 to column x.
Column separator
The separator with which the different columns are recognised in the import files.
Only one character can be selected as the separator.
Replacement character for invalid characters
You can select a single character, or no character, to replace invalid characters in the import file. The default setting for the “Replacement character for invalid characters” is the “Blank character” parameter.
For more information about the replacement character, see → Working with master values
Number format
Decimal separator
The following characters can be selected as the decimal separators: None, point, comma.
Thousands separator
The following characters can be selected as the thousands separators: None, point, comma, blank, apostrophe.
Assignment & options
Column assignment and preview
This area contains the live view of the import options. Columns must be defined to import the data into the firesys MeetingPoint. Four types are available for the data columns:
- Account
- Label
- Value
- Comment
The Account, Description and Value columns are mandatory for the data import; the Comment column is optional. All columns can be assigned only once.
Import options
Additional import options can be created that are applied when the data is imported. These options can be used for modelling the data and subsequently transferring it to the firesys MeetingPoint.
Options
Make your selection from various import options and prioritise the sequence in which the options should be applied.
Add option
Opens a dialog for adding an import option. The individual selection options depend on the target columns that are selected.
Edit
Opens the selected import option for editing.
Delete
Deletes the selected import options.
Activate
Reactivates the selected deactivated import options.
Deactivate
Deactivates the selected import options so that they are no longer applied.
Prioritise higher
Prioritises the selected import option upwards, so that it is applied earlier.
Prioritise lower
Prioritises the selected import option downwards, so that it is applied later.
Import options detailed view
Fill
Select a number and a fill character. The number of characters in the column is increased to this number with the fill character.
Filter
If rows with certain texts should be excluded from the import process, they can be filtered out according to certain parameters.
Skip the record if cells are empty
Rows that do not have any content are skipped during the data import.
Import empty cells as 0
Cells that do not have any values are enhanced with a "0" and imported during the data import.
Factor
Multiplies or divides the imported values by a certain factor.
Prefix
The text that is entered is displayed before the selected record.
Suffix
The text that is entered is displayed after the selected record.
Delete text
The configured text/number is deleted when the data is imported.
Replace text
Select a text that is replaced by a different text when the data is imported.
Insert text
This option is used to fill empty cells with a particular text.
Siehe auch
An overview of the data-import-manager
The interface of the data-import-manager
The list view in the data-import-manager