How to modify a CSV import configuration

Discussion in 'AVReporter Questions' started by Nagy Ottó, Jul 16, 2014.

  1. Nagy Ottó

    Nagy Ottó Administrator Staff Member

    A schema.ini file contains the configuration settings of the CSV import groups.
    There is a sample in the AVReporter program folder (Default: C:\Program Files (x86)\KONSYS\AvReporter\bin\AVR Connection Center\sample).

    1st step: Create a schema.ini file in the target folder where you would like to download the CSV file from the EGX300.

    2nd step: Edit the ini file...
    A configuration example:
    [log.csv]
    ColNameHeader=True
    Format=Delimited(;)
    DateTimeFormat=yyyy-mm-dd hh:nn:ss
    Col1=Namespace Char Width 255
    Col2=Source Char Width 250
    Col3=Quantity Char Width 200
    Col4=Unit Char Width 200
    Col5=Timestamp Date
    Col6=Value Float


    3rd step: Modify the filename to the downloaded filename (Example: [log.csv] -> [PM9C.csv])

    4rd step: Modify the parameters... Delimiter, Date-time format, Columns...

    Example: The csv delimiter is "," modify the format parameter to Delimited(,).

    Attached Files:

Share This Page