> For the complete documentation index, see [llms.txt](https://docs.videc.de/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.videc.de/acron-9.3/en/anlagenkonfiguration/prozessanbindung/provider/providerid/treiberauswahl/universeller-import-von-stoerungen-und-meldungen.md).
# Universal import of malfunctions and messages
#### Background
The ACRON Provider is used for all interfaces for data transfer from the process. This also applies to the file interface. In this, the files being imported are stored in a configurable path (import path). The Provider cyclically checks whether a new file has been created in this path. If it has, the data from this file are automatically imported into the ACRON database. Following successful import, the file is deleted from the ACRON Provider. Any errors occurring during import are written to the Provider's log file. The log file is located in the ACRON installation path under /Log. Text files with virtually any structure can be imported. Freely combinable format instructions specify the file structure. With this driver, alerts and messages can be imported.
The structure of the text file is specified by two key properties:
* The general format, including any headers
* The format of the following data lines.
#### Time stamp input
The time stamp is entered in the following formats:
Hour Minute Second Millisecond Type
The specifications Second Millisecond Type are optional, so do not have to be included.
The following characters can be used as separators between the entries:
* Dot
* Colon
* Blank
* NO separator
If NO separator is used, the entries must be made with the following numbers of digits:
Hour, minute and second two digits each, millisecond three digits
The Type may have the following value:
| | |
| -------- | ------------------------------------------- |
| U or u | The time is indicated in UTC. |
| S or s | The time is indicated in local Summer time. |
| AM or am | Morning |
| PM or pm | Afternoon |
If the type field is not filled out, ACRON assumes that it is local time.
| | |
| -------------- | ------------------------------------------- |
| `8:20:30` | 8:20:30 hours, 0 milliseconds, local time |
| `8:20:30U` | 8:20:30 hours, 0 milliseconds, UTC time |
| `082030U` | 8:20:30 hours, 0 milliseconds, UTC time |
| `8:20:30PM` | 8:20:30 hours, 0 milliseconds, local time |
| `8:20:30:278` | 8:20:30 hours, 278 milliseconds, local time |
| `8:20:30:278u` | 8:20:30 hours, 278 milliseconds, UTC time |
## Driver
### Driver file
Display the name of the selected driver and select a driver from the list of installed drivers
### Version
Version of the driver file
### Interface type
Display the driver interface type
### Data transfer type
Description of the data transfer type
## Driver parameters
### Full path for import files
Full path where the files to be imported are located.
The basic format is specified by means of individual parameter entries. The parameters can be distributed across the two input boxes as desired. For missing entries predefined defaults are used.
Syntax and parameters of the format specification (all column and row entries begin with 1!)
| Ident | Description | Options | Default | Explanation |
| ----- | ------------------- | ------------------------ | ---------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| F | File | \[File mask] | F\[\*.csv] | Only files of this type are read-in |
| U | File coding | \[AUTO] | U\[AUTO] | Automatic detection of the file encoding based on a BOM (byte order mark - see ) |
| | | \[ANSI] | | File coding is in ANSI |
| | | \[UTF8] | | File coding is in UTF-8 |
| | | \[UTF16LE] | | File coding is in UTF-16 Little Endian |
| S | Separator | \[characters] | S\[;] | This character separates the columns. If a second character is displayed here, it is interpreted as a column separator for the header, e.g. S\[;/]. |
| FH | Fix header cols | \[format] | | For files without separators and fixed column width: This format specification only applies to columns in the header rows, and describes the column widths with their respective start and end positions in the row, starting with column 1. The position indicators start at 1. e.g. FH\[1-20, 21-47, 63-78], three fixed columns in the header: Column 1 from position 1 to 20 Column 2 from position 21 to 47 Column 3 from position 63 to 78 |
| FD | Fix data cols | \[format] | | For files without separators and fixed column width: This format specification only applies to columns in the data rows, and describes the column widths with their respective start and end positions in the row, starting with column 1. The position indicators start at 1. e.g. FD\[1-20, 21-47, 63-78], three fixed columns in the data rows: Column 1 from position 1 to 20 Column 2 from position 21 to 47 Column 3 from position 63 to 78 |
| G | Line ignore | \[character string, ...] | | Ignores all rows beginning with the specified texts. |
| C | Count header | \[number] | C\[0] | Indicates how many header rows are included. |
| R | Repeat header | \[number] | R\[0] | If the header recurs, after how many rows it recurs each time is specified here. |
| | | \[N] | | Every row beginning with a non-numerical character (0-9) is interpreted as a new header row. |
| T | Tagname origin | \[D] \[F] \[Format] | T\[D] | Tag name is on each data line. Tag name is produced from file name. Tag name from header: e.g. T\[2,4] header row 2 with columns 4-8 contains the tag name |
| B | Tag name separator | \[characters] | B\[] | The tag name is cut off after this character. |
| E | Extension Sep. | \[Separator] | | If the tag name comprises two columns, the second part is appended by the specified separator character, e.g. Station123\_Sensor97. If the tag name does not comprise two columns, do not specify this parameter! |
| D | Date | \[D] \[F] \[Format] | D\[D] | Date is on each data line. Date is produced from file name. Date from header: e.g. D\[2,4] Date is on header line 2 in column 4. |
| Y | Date Format | \[Y2MD] | Y\[Y4MD] | 2-digit year indicator in format Year/Month/Day; any separator, including none |
| | | \[Y4MD] | | 4-digit year indicator in format Year/Month/Day; any separator, including none |
| | | \[DMY4] | | 4-digit year indicator in format Day/Month/Year; any separator, including none |
| | | \[DMY2] | | 2-digit year indicator in format Day/Month/Year; any separator, including none |
| | | \[MDY4] | | 4-digit year indicator in format Month/Day/Year; any separator, including none |
| | | \[Y2MDU] | | 2-digit year indicator in format Year/Month/Day; any separator, including none, all times in UTC |
| | | \[Y4MDU] | | 4-digit year indicator in format Year/Month/Day; any separator, including none, all times in UTC |
| | | \[DMY4U] | | 4-digit year indicator in format Day/Month/Year; any separator, including none, all times in UTC |
| | | \[DMY2U] | | 2-digit year indicator in format Day/Month/Year; any separator, including none, all times in UTC |
| | | \[MDY4U] | | 4-digit year indicator in format Month/Day/Year; any separator, including none, all times in UTC |
| | | \[U] | | Date and time in Unix time format (seconds since 1970). Fractions of seconds can optionally be entered after the decimal point or comma. Example: 1311737244.011178 |
| | | \[UL] | | Date and time in Unix time format (seconds since 1970) in local time. Fractions of seconds can optionally be entered after the decimal point or comma. Example: 1311737244.011178 |
| I | Ignore | \[characters] | I\[" ] | Indicates the prefix characters for all fields except the tag name that are ignored, e.g. I\[" ] ignores the prefix characters, quotation marks and blank spaces. |
| J | Ignore | \[characters] | J\[" ] | Indicates the suffix characters for all fields except the tag name that are ignored, e.g. J\[" ] ignores the suffix characters, quotation marks and blank spaces. |
| K | Ignore | \[characters] | K\[" ] | Indicates the prefix characters for the tag name that are ignored, e.g. K\[" ] ignores the prefix characters, quotation marks and blank spaces. |
| L | Ignore | \[characters] | L\[" ] | Indicates the suffix characters for the tag name that are ignored. e.g. L\[" ] ignores the suffix characters, quotation marks and blank spaces. |
| X | Thousands separator | \[] | X\[] | No thousands separator included in numbers. |
| | | \[.] | | Thousands separator is a point |
| | | \[,] | | Thousands separator is a comma. This is not the decimal separator! |
### Format description (continued)
The basic format is specified by means of individual parameter entries. The parameters can be distributed across the two input boxes as desired. For missing entries predefined defaults are used.
Syntax and parameters of the format specification (all column and row entries begin with 1!)
| Ident | Description | Options | Default | Explanation |
| ----- | ------------------- | ------------------------ | ---------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| F | File | \[File mask] | F\[\*.csv] | Only files of this type are read-in |
| U | File coding | \[AUTO] | U\[AUTO] | Automatic detection of the file encoding based on a BOM (byte order mark - see ) |
| | | \[ANSI] | | File coding is in ANSI |
| | | \[UTF8] | | File coding is in UTF-8 |
| | | \[UTF16LE] | | File coding is in UTF-16 Little Endian |
| S | Separator | \[characters] | S\[;] | This character separates the columns. If a second character is displayed here, it is interpreted as a column separator for the header, e.g. S\[;/]. |
| FH | Fix header cols | \[format] | | For files without separators and fixed column width: This format specification only applies to columns in the header rows, and describes the column widths with their respective start and end positions in the row, starting with column 1. The position indicators start at 1. e.g. FH\[1-20, 21-47, 63-78], three fixed columns in the header: Column 1 from position 1 to 20 Column 2 from position 21 to 47 Column 3 from position 63 to 78 |
| FD | Fix data cols | \[format] | | For files without separators and fixed column width: This format specification only applies to columns in the data rows, and describes the column widths with their respective start and end positions in the row, starting with column 1. The position indicators start at 1. e.g. FD\[1-20, 21-47, 63-78], three fixed columns in the data rows: Column 1 from position 1 to 20 Column 2 from position 21 to 47 Column 3 from position 63 to 78 |
| G | Line ignore | \[character string, ...] | | Ignores all rows beginning with the specified texts. |
| C | Count header | \[number] | C\[0] | Indicates how many header rows are included. |
| R | Repeat header | \[number] | R\[0] | If the header recurs, after how many rows it recurs each time is specified here. |
| | | \[N] | | Every row beginning with a non-numerical character (0-9) is interpreted as a new header row. |
| T | Tagname origin | \[D] \[F] \[Format] | T\[D] | Tag name is on each data line. Tag name is produced from file name. Tag name from header: e.g. T\[2,4] header row 2 with columns 4-8 contains the tag name |
| B | Tag name separator | \[characters] | B\[] | The tag name is cut off after this character. |
| E | Extension Sep. | \[Separator] | | If the tag name comprises two columns, the second part is appended by the specified separator character, e.g. Station123\_Sensor97. If the tag name does not comprise two columns, do not specify this parameter! |
| D | Date | \[D] \[F] \[Format] | D\[D] | Date is on each data line. Date is produced from file name. Date from header: e.g. D\[2,4] Date is on header line 2 in column 4. |
| Y | Date Format | \[Y2MD] | Y\[Y4MD] | 2-digit year indicator in format Year/Month/Day; any separator, including none |
| | | \[Y4MD] | | 4-digit year indicator in format Year/Month/Day; any separator, including none |
| | | \[DMY4] | | 4-digit year indicator in format Day/Month/Year; any separator, including none |
| | | \[DMY2] | | 2-digit year indicator in format Day/Month/Year; any separator, including none |
| | | \[MDY4] | | 4-digit year indicator in format Month/Day/Year; any separator, including none |
| | | \[Y2MDU] | | 2-digit year indicator in format Year/Month/Day; any separator, including none, all times in UTC |
| | | \[Y4MDU] | | 4-digit year indicator in format Year/Month/Day; any separator, including none, all times in UTC |
| | | \[DMY4U] | | 4-digit year indicator in format Day/Month/Year; any separator, including none, all times in UTC |
| | | \[DMY2U] | | 2-digit year indicator in format Day/Month/Year; any separator, including none, all times in UTC |
| | | \[MDY4U] | | 4-digit year indicator in format Month/Day/Year; any separator, including none, all times in UTC |
| | | \[U] | | Date and time in Unix time format (seconds since 1970). Fractions of seconds can optionally be entered after the decimal point or comma. Example: 1311737244.011178 |
| | | \[UL] | | Date and time in Unix time format (seconds since 1970) in local time. Fractions of seconds can optionally be entered after the decimal point or comma. Example: 1311737244.011178 |
| I | Ignore | \[characters] | I\[" ] | Indicates the prefix characters for all fields except the tag name that are ignored, e.g. I\[" ] ignores the prefix characters, quotation marks and blank spaces. |
| J | Ignore | \[characters] | J\[" ] | Indicates the suffix characters for all fields except the tag name that are ignored, e.g. J\[" ] ignores the suffix characters, quotation marks and blank spaces. |
| K | Ignore | \[characters] | K\[" ] | Indicates the prefix characters for the tag name that are ignored, e.g. K\[" ] ignores the prefix characters, quotation marks and blank spaces. |
| L | Ignore | \[characters] | L\[" ] | Indicates the suffix characters for the tag name that are ignored. e.g. L\[" ] ignores the suffix characters, quotation marks and blank spaces. |
| X | Thousands separator | \[] | X\[] | No thousands separator included in numbers. |
| | | \[.] | | Thousands separator is a point |
| | | \[,] | | Thousands separator is a comma. This is not the decimal separator! |
### Data line specification
Description of the columns containing the actual data. Each column is specified by a letter. In the file, up to 100 columns may contain any desired number of data lines.
| Ident | Description: | Explanation |
| ----- | -------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| T | Tagname | The variable name for this column is displayed here. |
| E | Extension Name | If the variable name comprises two columns, the second part is in this column. |
| I | Ignore | Ignore this column. |
| D | Date/Time | The column contains the date and optionally the time. |
| X | Time | The column contains the time, if not included in date column. |
| M | Milliseconds | The column contains milliseconds, if not included in time column. |
| V | Value | The current value which has led to the alert being triggered. |
| G | Group | The alert group; if blank, "Default" is set. |
| C | Description | Optionally the description of the alert |
| N | Event | The alert event; if blank, 4 is assumed. Permitted: 1 KMT: Alert begins 2 GHT: Alert ends 3 QIT: Active alert has been acknowledged 4 NEW: New value alert, message 5 RST: System has been restarted (All open alerts are ended, active alerts must be re-signaled.) |
| Y | Eventtype | The alert type, if blank DISK is assumed. Permissible values: [Limit value alerts](https://github.com/Dataforum-Software/gitbook/blob/master/acron/9.3/en/designer/glossar/grenzwertalarm.md): HIHI, HI, LO, LOLO [Deviation alerts](https://github.com/Dataforum-Software/gitbook/blob/master/acron/9.3/en/designer/glossar/abweichungsalarm.md): ABW1, ABW2 [Modification alerts](https://github.com/Dataforum-Software/gitbook/blob/master/acron/9.3/en/designer/glossar/aenderungsalarm.md): MODF Binary alerts 1: DISK Binary alerts 2: OPR Binary alerts 3: LGK Binary alerts 4: DDE Binary alerts 5: SYS |
| O | Operator | The name of the logged-in user |
| P | Priority | The priority of the alert, if blank 0 is assumed. Permissible: 0-999. |
| A | Text | The alert / message text |
## Settings
### Measure interval
This setting specifies the time interval to search for new files for data import.
Recommended entry 60 sec.
### Always display provider window on top
Provider windows are always displayed on top
### Activate test mode
Display a window with diagnostic messages
On startup the ACRON Provider opens a window with diagnostic messages. The log file is stored under the relevant provider name in the ACRON installation path, in the `Log` directory.
Note
As diagnosis mode heavily influences the performance of the application, and the recorded messages can normally only be evaluated by Technical Support, you should only activate it when prompted to do so by Support.
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.videc.de/acron-9.3/en/anlagenkonfiguration/prozessanbindung/provider/providerid/treiberauswahl/universeller-import-von-stoerungen-und-meldungen.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.