Configure your parser

To configure the parser to load your CSV files, copy %DNAInstallRoot%\MeasurementAdvisor\sdk\MeasUtil.FileImportParser.ExampleCSVParser\measFileImportCSVParser.json to %DNADataRoot%\MeasurementAdvisor\config\Settings and edit the file.

This configuration file will load the example data in sdk\MeasUtil.FileImportParser.ExampleCSVParser\HMRExampleData.txt

Use the information in ConfigureExampleFileImport.sql to manually create the FileImport definition using the AVEVA Measurement Advisor Client application.

Start the AVEVA Measurement Advisor Client.

Navigate to View, and then File Import Summary and then New.

Configure the properties based on the contents of the ConfigureExampleFileImport.sql file. Adjust as required.

Do the following to load the example data into the AVEVA Measurement Advisor database:

1. Open a Windows PowerShell window.

2. Navigate to $env:DNAInstallRoot\MeasurementAdvisor\bin.

3. Run the following command:

   MeasFileImport.exe -S CLOUDDB -T ExampleCSVParser -r