Load CSV

This option enables you to configure the CSV settings.

The CSV setting contains the following options:

• Data Output Type: Normally set to CSV, where the output data will be written in a CSV file. When you select NONE, no CSV file is created.

• Output Destination: Select the output destination type to store the output file type in the Destination folder. The destination type can be Filesystem, S3 or AVEVA Cloud Storage.

  • File System Details:

    • Output Path: Type the Output file path or click Browse for Folder button to enter the output file path.

  • S3 Bucket Details: For more information, see Accessing an AWS S3 Bucket.

• Create Tag List CSV Report: If you want to get a CSV file report containing a list of all the tagged objects and classifications in the output folder, select Create Tag List CSV Report.

• CSV Columns: In the CSV Columns field, add the additional comma separated columns to export the objects' attributes and associations in the CSV export. For further details about how to configure the column definitions, see Appendix B: CSV Reporting.

• Generate Headers in CSV: If you select this setting then the names of the attributes or associations are written to the first row of the CSV file. The header level information contains configuration file data and date of creation and so on.

• Replicate Input Structure: If you select this option, the output file is generated in a duplicate path. This is replicated input folder structure in output folder if you point on input location of input files containing also subfolders with files of such type.

• Save Settings: After you have selected the required settings, click this to save the CSV settings.

Creation of Large CSV Files in Load CSV and Transform's CSV Reports

When the data being written to a CSV file exceeds 1,000,000 rows, the Gateway automatically splits the output into multiple CSV files, such that for every additional 1,000,000 rows, a new CSV file is generated.

For example:

• The first file will be named: test_AfterTransformation.csv

• The second file (for the next 1,000,000 rows) will be: test_AfterTransformation_1.csv

• The third: test_AfterTransformation_2.csv and so on.