Read CSV files with the Qixium Agent

Make a local export usable

CSV Reader reads files from a local directory through the Agent. An application or a PowerShell script can produce the export. The Reader does not itself execute that export script.

Configuration

Create a CSV Reader connection, assign its Agent, reload configurations and complete the generated file under C:\Qixium\configs\CSVReader. Configure directoryPath and the actual separator. The source spells its field seperator; retain the names in your generated file. It uses an empty literal and relations: [] for a basic configuration without relations.

Stable keys

Use a genuinely unique, stable source key for each row. Agree when an export is complete and ready to read. Check headers, separators and required values before scheduling writes.

Choose processing and logging

The source prefers Data Link because of run logging. Map required fields to an entity and verify the result. External Data Portals is another documented route. Select fields deliberately rather than automatically importing every new column.

Handle missing data explicitly

Distinguish an empty valid export from an incomplete or failed export. Truncate target table clears the destination before loading and should not be the default. Define missing-record handling separately.

PowerShell export step · CSV integrations

Back to Agent and connectors

Sources and version

• CSV Reader

Sources reviewed on 6 November 2026. Screen names and capabilities depend on your installed version and configuration.