Import CSV

Imports a CSV file from a visual energy evaluation folder or the file system and saves the values in the target type, i.e. a metering point measured variable. The file must contain at least one column with a timestamp and one column with the value. The status can also be imported. If no status is included in the CSV file, a default status can be set for all values. The file name can be specified using a wildcard (*). Only the file name or the source file may be specified.

Where can I find this workflow?

Data Collection section => Metering point => Measured variables => Automation

Parameters

Directory	Disabled or SMB share Path to the directory (optional) Server Share Authentication SMB version Transport type Authentication method
Disabled / SMB share	Selection Disabled – No output directory SMB share – Requires details of the shared directory.
Path to the directory	Text (optional) – Path
Server	Text / IP address – FQDN – name or IP address
Share	Text – Name of the share
Authentication	Anonymous – No user account required Domain (optional) – Name of the share domain Username – Name of the user with access to the share Password – Password of the user with access to the share
SMB version	Can usually be left at the default setting 3.1.1 (Default) 2.0
Transport type	Direct over TCP NetBIOS over TCP
Authentication method	Detect automatically (default) NTLM V2 NTLM V1 with enhanced security NTLM V1

NOTICE

The user configured for the share must have sufficient permissions for the desired function within the file system.

When setting up the share, please bear in mind the entire process. During export, any existing files may be overwritten. After a successful import, the file may need to be deleted or moved to a subfolder. If these subfolders do not exist, the user configured for the share must have permissions to create them.

Source file	Select – Select a file from a visual energy evaluation folder.
Action after import	Selection – Possible actions after a successful import in the evaluation folder or file system: Move file to a subfolder Delete file No action
Delimiter	Selection Semicolon Tab
Timestamp is UTC	Selection Yes – The timestamp is interpreted as UTC time. No – The timestamp is interpreted as the local time at the location.
Date and time	Selection Date and time in a single column Date and time in separate columns
Column index: Date and time	Number – Specifies the column index containing the end timestamp (date and time). The column index starts at 1. The maximum column index is 20.
Column index: Date	Number – Specifies the column index containing the end timestamp (date). The column index starts at 1. The maximum column index is 20.
Column index: End timestamp	Number – Specifies the column index containing the end timestamp (time). The column index starts at 1. The maximum column index is 20.
Column index: Value	Number – Specifies the column index of the value. The column index starts at 1. The maximum column index is 20.
Column index: Status	Number – Specifies the column index of the status. The column index starts at 1. The maximum column index is 20. If no status is present in the CSV file, the column index must be set to 0. The value of the “Default status” parameter is then used for the status.
Table header / header row	Yes / No Output parameter: Should the output include a table header (column headings)? Input parameter: Does the table have a table header (column headings)?
Number of header lines	Number – The number of header lines
Default status	Selection – Default value for the measured value status. 0 – Original value 1 – Replacement value 2 – Temporary / Estimated value
Completion trigger	Trigger – Specifies the trigger that is executed once the workflow has finished.
Notification text / title	Text – As informative a statement as possible. Those responsible for energy management should be able to gain an immediate overview of the issue from the notification text.
Priority	Selection – Priority of the notification. 0 (no priority) up to 6 (very high priority).

Version	Date	Change
2.14	12/04/2025	“Filename” parameter replaced with “ImportDirectory”
2.13	03/16/2023	“DeleteAfterImport” parameter replaced with “ActionAfterImport”
2.12	11/14/2021	Added Message.AssignedWorkflowID property to define the link between a message and the workflow assignment that created it
2.11	08/02/2022	Description updated
2.10	07/18/2022	UPDATE: Added display of the file line for invalid date/time
2.9	12/20/2021	UPDATE: Date and time can be specified in separate columns. ColumnIndexValue and ColumnIndexState are required parameters.
2.8	12/06/2021	Updated validation of the imported file Lines without a value are assigned a value of 0 and status 4.
2.7	07/15/2021	FIX: Workflow termination with an exception when data cannot be written to the database (WriteData activity returns false).
2.6	02/25/2021	FIX: Workflow termination when columns are empty.
2.5	07/14/2020	Added “DocumentTargetFolderItem” parameter
2.4	09/16/2019	Added “Header lines” parameter Added wildcard to the filename Added optional message output (“MessageText” argument)
2.3	05/09/2019	Description updated
2.2	07/04/2018	UPDATE: Workflow termination if the import file cannot be found
2.1	07/19/2017	FIX: Data-import failure with ambiguous times during daylight saving time
2.0	05/12/2017	Multi-target workflows
1.5	05/24/2017	Exception indicates the line number at which the data could not be parsed.
1.4	05/19/2017	Existing backup file deleted
1.3	05/15/2017	Prevented import of invalid statuses; created start timestamp for OBIS of type EnergyFeed