Create an import-definition: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(18 dazwischenliegende Versionen von 3 Benutzern werden nicht angezeigt)
Zeile 2: Zeile 2:
The data import reads out the records, they can be individually modelled and then transferred to the firesys MeetingPoint.  
The data import reads out the records, they can be individually modelled and then transferred to the firesys MeetingPoint.  


== The functions ==
== Video: Create an Import -Definition ==
=== Create an Import definition ===
 
Define how the data from the upstream system is transferred “modelled” to the MeetingPoint with the help of firesys.  
Define how the data from the upstream system is transferred “modelled” to the MeetingPoint with the help of firesys.  


{{Vorlage:Video-Import-Definition_erstellenENG}}
{{Vorlage:Video-Import-Definition_erstellen-English}}


== File selection ==
== File selection ==
Zeile 12: Zeile 12:


=== Data source ===
=== Data source ===
Clicking on the radiobutton opens the file selection dialog in which you can select .csv or .txt files.  
Clicking on the radiobutton opens the file selection dialog in which you can select .csv or .txt files. In this step you can also include exports from WeSustain (link) or figures directly from Envoria (link).
=== Details ===
=== Details ===
==== Title ====
<b> Title </b> <br>
The title serves to visually differentiate the import definitions in the manager. The title must be unique and is restricted to 150 characters.   
The title serves to visually differentiate the import definitions in the manager. The title must be unique and is restricted to 150 characters.   
==== Description ====
 
<b> Description </b> <br>
The description serves to visually differentiate the import definitions in the manager. The entry is restricted to 255 characters.  
The description serves to visually differentiate the import definitions in the manager. The entry is restricted to 255 characters.  
=== Target in the MeetingPoint ===
=== Target in the MeetingPoint ===
==== Account group ====
 
<b> Account group </b> <br>
An existing account group must be selected from the MeetingPoint into which the data is imported.  
An existing account group must be selected from the MeetingPoint into which the data is imported.  
==== Key date ====
 
<b> Key date </b> <br>
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.   
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.   


Zeile 30: Zeile 34:
=== 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.  
<b> Encoding </b> <br>
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 without BOM
| 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 ====
<b> Column headings </b>
If this option is activated, the headings are read out from the first row of the import file.<br>
If this option is activated, the headings are read out from the first row of the import file.<br>
If this option is activated, the first row of the import file is read out as the record.<br>
If this option is activated, the first row of the import file is read out as the record.<br>
The column headings are displayed in the dialog with column 1 to column x.  
The column headings are displayed in the dialog with column 1 to column x.  
==== Column separator ====
<b> Column separator </b>
The separator with which the different columns are recognised in the import files.<br>
The separator with which the different columns are recognised in the import files.<br>
Only one character can be selected as the separator.  
Only one character can be selected as the separator.  
==== Replacement character for invalid characters ====
<b> Replacement character for invalid characters </b>
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.<br>
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.<br>
For more information about the replacement character, see [[Working_with_master_values|&rarr; Working with master values]]
For more information about the replacement character, see [[The_account_workbook|&rarr; Working with master values]]


=== Number format ===
=== Number format ===
==== Decimal separator ====
<b> Decimal separator </b>
The following characters can be selected as the decimal separators: None, point, comma.
The following characters can be selected as the decimal separators: None, point, comma.
==== Thousands separator ====
<b> Thousands separator </b>
The following characters can be selected as the thousands separators: None, point, comma, blank, apostrophe.
The following characters can be selected as the thousands separators: None, point, comma, blank, apostrophe.


Zeile 54: Zeile 104:
This area contains the live view of the import options.
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:  
Columns must be defined to import the data into the firesys MeetingPoint. Four types are available for the data columns:  
* Value
* Account
* Account
* Label
* Label
* Value
* Comment
* Comment
The Account, Description and Value columns are mandatory for the data import; the Comment column is optional.  
The Value, Account and Description columns are mandatory for the data import; the Comment column is optional.  
All columns can be assigned only once.
All columns can be assigned only once.
=== Sum up columns ===
Creates a new column in which several existing columns can be summed up vertically without changing the data source. The Totals column must be given a name and at least two existing columns serving as summands of the new column must be defined. This Totals column can then be assigned a type just like any other column (Account / Name / Value / Comment).


=== Import options ===
=== Import options ===
Zeile 69: Zeile 123:
Make your selection from various import options and prioritise the sequence in which the options should be applied.<br>
Make your selection from various import options and prioritise the sequence in which the options should be applied.<br>


==== Add option ====
<b>[[Datei:Image-Common-Plus.48.png|link=|16px]]  Add </b>
Opens a dialog for adding an import option. The individual selection options depend on the target columns that are selected.
Opens a dialog for adding an import option. The individual selection options depend on the target columns that are selected.


==== Edit ====
<b>[[Datei:Image.Common.Edit.48.png|link=|16px]] Edit </b>
Opens the selected import option for editing.  
Opens the selected import option for editing.  


==== Delete ====
<b>[[Datei:Image.Trans.Term.Delete.48.png|link=|16px]] Delete </b>
Deletes the selected import options.  
Deletes the selected import options.  


==== Activate ====
<b>[[Datei:Image.Cell.FileImport.ActivateOption.16.png|16px]] Activate </b>
Reactivates the selected deactivated import options.  
Reactivates the selected deactivated import options.  


==== Deactivate ====
<b>[[Datei:Image.Cell.FileImport.DeactivateOption.16.png|16px]] Deactivate </b>
Deactivates the selected import options so that they are no longer applied.  
Deactivates the selected import options so that they are no longer applied.  


==== Prioritise higher ====
<b>[[Datei:Image.Common.Arrow.Up.16.png|16px]] Prioritise higher </b>
Prioritises the selected import option upwards, so that it is applied earlier.  
Prioritises the selected import option upwards, so that it is applied earlier.  
==== Prioritise lower ====
 
<b>[[Datei:Image-Common-ArrowDown.png|16px]] Prioritise lower </b>
Prioritises the selected import option downwards, so that it is applied later.  
Prioritises the selected import option downwards, so that it is applied later.  
=== Import options detailed view===
=== Import options detailed view===
==== [[Datei:Rz Fileimport Platzhalter auffüllen.png|link=|16px]] Fill ====
<b> [[Datei:Rz Fileimport Platzhalter auffüllen.png|link=|16px]] Fill </b>
Select a number and a fill character. The number of characters in the column is increased to this number with the fill character.   
Select a number and a fill character. The number of characters in the column is increased to this number with the fill character.   


==== [[Datei:Rz Fileimport Filtern.png|link=|16px]] Filter====
<b> [[Datei:Image.Cell.FileImport.Option.SkipEmpty.24.png|link=|16px]] Skip the record if cells are empty </b>
Rows that do not have any content are skipped during the data import.
 
<b> [[Datei:Rz Fileimport Faktor.png|link=|16px]] Factor </b>
Multiplies or divides the imported values by a certain factor.
 
<b> [[Datei:Rz Fileimport Filtern.png|link=|16px]] Filter </b>
If rows with certain texts should be excluded from the import process, they can be filtered out according to certain parameters.   
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 ====
<b> [[Datei:Image.Cell.FileImport.Option.Grouping.24.png|link=|16px]] Grouping </b>
Rows that do not have any content are skipped during the data import.  
Combines all account values of an account.


==== Import empty cells as 0 ====
<b> [[Datei:Image.Cell.FileImport.Option.FillEmptyCells.24.png|link=|16px]] Import empty cells as 0 </b>
Cells that do not have any values are enhanced with a "0" and imported during the data import.
Cells that do not have any values are enhanced with a "0" and imported during the data import.


==== [[Datei:Rz Fileimport Faktor.png|link=|16px]] Factor ====
<b> [[Datei:Rz Fileimport Prefix.png|link=|16px]] Prefix </b>
Multiplies or divides the imported values by a certain factor.
 
==== [[Datei:Rz Fileimport Prefix.png|link=|16px]] Prefix ====
The text that is entered is displayed before the selected record.  
The text that is entered is displayed before the selected record.  


==== [[Datei:Rz Fileimport Sufix.png|link=|16px]] Suffix ====
<b> [[Datei:Rz Fileimport Sufix.png|link=|16px]] Suffix </b>
The text that is entered is displayed after the selected record.  
The text that is entered is displayed after the selected record.  


==== [[Datei:Rz Fileimport Text löschen.png|link=|16px]] Delete text ====
<b> [[Datei:Rz Fileimport Text einfügen.png|link=|16px]] Insert text </b>
The configured text/number is deleted when the data is imported.
This option is used to fill empty cells with a particular text.  


==== [[Datei:Rz Fileimport Text ersetzen.png|link=|16px]] Replace text ====
<b> [[Datei:Rz Fileimport Text ersetzen.png|link=|16px]] Replace text </b>
Select a text that is replaced by a different text when the data is imported.   
Select a text that is replaced by a different text when the data is imported.   


==== [[Datei:Rz Fileimport Text einfügen.png|link=|16px]] Insert text ====
<b> [[Datei:Rz Fileimport Text löschen.png|link=|16px]] Delete text </b>
This option is used to fill empty cells with a particular text.  
The configured text/number is deleted when the data is imported.
 


== Siehe auch ==  
== See also ==  





Aktuelle Version vom 27. Februar 2023, 15:03 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.

Video: Create an Import -Definition

Define how the data from the upstream system is transferred “modelled” to the MeetingPoint with the help of firesys.

A detailed explanation of the individual steps

To add a new Import definition in the Data Import Manager:

  1. Create an Import definition after which your data should be inserted into the MeetingPoint. Select the “Data Import Manager” button in the “Data Import” group in the “*Content” menu bar.
    → The data import manager opens.

  2. Choose the “Create” button in the “Import definition” group.
    → A dialogue box opens.

  3. File selection: In the dialog you have the possibility to select a data source from which the data should be read. In the Details area, further meta information can be added to the import definition. As a target for your data you can use an already existing key date in the firesys-MeetingPoint or you can define a new one at this point.

  4. Click on “Next” to go to the “File Settings” tab.

  5. File settings: Determine whether column headings are present in the import file If this is the case, the option will not transfer the first line of the file. Furthermore the column delimiter must be specified, so that firesys can recognize and transfer the records correctly.

  6. In the area “Number format” the decimal separator and the thousand separator of the import file are set.

  7. Click on “Next” to access the “Assignment & Options” tab.

  8. Assignment & Options: In the area “Column assignment and preview” the data records must be structured. The area contains the live view of the import options. To import the data into the firesys-MeetingPoint the columns of the import file must be defined. There are four types for the data columns to choose from:

    • account

    • name

    • value

    • comment

  9. The account, name and value columns are mandatory for data import; the Comment column is optional. All columns can only be assigned once.

  10. In the area “Import options” additional options can be created that are applied when the data is read in. With the help of these options the data can be modelled and then transferred to the firesys-MeetingPoint.

  11. In the video, an option is created to divide the account values by 1 million during transfer.

  12. There are further options, the choices depend on the “target column”.

  13. If you want to work with multiple read options, the order in which the options should be applied must be defined.

  14. Click on “Finish” to enter the data import manager.
    → The created import definition is now available.

File selection

Die Standard-Ansicht des Excel-Daten-Managers

Data source

Clicking on the radiobutton opens the file selection dialog in which you can select .csv or .txt files. In this step you can also include exports from WeSustain (link) or figures directly from Envoria (link).

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

Die Standard-Ansicht des Excel-Daten-Managers

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 without BOM 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

Die Standard-Ansicht des Excel-Daten-Managers

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:

  • Value
  • Account
  • Label
  • Comment

The Value, Account and Description columns are mandatory for the data import; the Comment column is optional. All columns can be assigned only once.

Sum up columns

Creates a new column in which several existing columns can be summed up vertically without changing the data source. The Totals column must be given a name and at least two existing columns serving as summands of the new column must be defined. This Totals column can then be assigned a type just like any other column (Account / Name / Value / Comment).

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.

Die Einlesoptionen des Daten-Import

Options

Make your selection from various import options and prioritise the sequence in which the options should be applied.

Image-Common-Plus.48.png Add Opens a dialog for adding an import option. The individual selection options depend on the target columns that are selected.

Image.Common.Edit.48.png Edit Opens the selected import option for editing.

Image.Trans.Term.Delete.48.png Delete Deletes the selected import options.

Image.Cell.FileImport.ActivateOption.16.png Activate Reactivates the selected deactivated import options.

Image.Cell.FileImport.DeactivateOption.16.png Deactivate Deactivates the selected import options so that they are no longer applied.

Image.Common.Arrow.Up.16.png Prioritise higher Prioritises the selected import option upwards, so that it is applied earlier.

Image-Common-ArrowDown.png Prioritise lower Prioritises the selected import option downwards, so that it is applied later.

Import options detailed view

Rz Fileimport Platzhalter auffüllen.png Fill Select a number and a fill character. The number of characters in the column is increased to this number with the fill character.

Image.Cell.FileImport.Option.SkipEmpty.24.png Skip the record if cells are empty Rows that do not have any content are skipped during the data import.

Rz Fileimport Faktor.png Factor Multiplies or divides the imported values by a certain factor.

Rz Fileimport Filtern.png Filter If rows with certain texts should be excluded from the import process, they can be filtered out according to certain parameters.

Image.Cell.FileImport.Option.Grouping.24.png Grouping Combines all account values of an account.

Image.Cell.FileImport.Option.FillEmptyCells.24.png Import empty cells as 0 Cells that do not have any values are enhanced with a "0" and imported during the data import.

Rz Fileimport Prefix.png Prefix The text that is entered is displayed before the selected record.

Rz Fileimport Sufix.png Suffix The text that is entered is displayed after the selected record.

Rz Fileimport Text einfügen.png Insert text This option is used to fill empty cells with a particular text.

Rz Fileimport Text ersetzen.png Replace text Select a text that is replaced by a different text when the data is imported.

Rz Fileimport Text löschen.png Delete text The configured text/number is deleted when the data is imported.


See also

Navigation hoch.svg An overview of the data-import-manager
Navigation rechts.svg The interface of the data-import-manager
Navigation rechts.svg The list view in the data-import-manager

Further contents

firesys website
Customer area
YouTube