Skip to main content
Version: 10.2
warning

This page is intentionally hidden from navigation but remains accessible via direct link. It is retained for internal reference purposes only and may contain outdated or transitional content.

LogparserCSV Configuration

The LogParserCSV is an application that will convert any CSV format file into Open iT standard data format.

Requirements​

  • Open iT Core Server version 9.4 or later
  • Administrative rights
  • CSV file with proper column naming
  • Activated periodic log data collection of license manager(s)

Proper Column Naming for the Input CSV File​

The LogparserCSV needs the correct header of the input CSV file to convert the file into the Open iT standard data format.

Make sure to follow these rules:

  • Always start with time:time. Open iT standard format always start with the collection time.
  • The required columns are product:string::* and feature:string::*. The sorting in these two columns are not strict.
Example CSV File Header
time:time,product:string::*,licenseid:string,duration:int64,siteid:string,featureid:string,feature:string::*,feature_version:string,user:string,host:string,used_licenses:int32

Converting CSV file(s) to Open iT Data Format​

These are the required steps to convert CSV file(s) to Open iT standard data format:

  1. Open a command prompt with Administrator level privileges.

  2. Go to the bin directory, which is by default in C:\Program Files\OpeniT\Core\bin, run the command:

    Command Syntax
    cd $BIN_DIR
    Example
    cd C:\Program Files\OpeniT\Core\bin

  3. Run the command:

    Command Syntax
    openit_logparsercsv --srcdir "$TEMP_DIR/LogFileCollector" --srcpattern "*.data" --srcfilehandling rename --trgdir "$TARGET_DIR"

    where $TEMP_DIR is the temporary directory, which is by default in C:\ProgramData\OpeniT\Data\temp and $TARGET_DIR is the directory where to save the output file.

    REQUIRED:

    NameDescription
    --srcdirThe source directory where the CSV file(s) are located.
    --srcpatternThe file pattern(s) that will be read by the parser. By default, the value is *, which will read all the file patterns in the source directory. Some example srcpatterns are:
    • *.csv
    • sample*.csv
    • *.csv*
    --srcfilehandlingThis parameter specifies what the binary will do after parsing. The possible values are:
    • delete - delete the source file after parsing
    • rename - rename the source file to .parsed after parsing
    • leave - leave the file unmodified after parsing
    --trgdirThe target directory where the converted file will be saved.
    Required LogparserCSV Parameters

    OPTIONAL:

    NameDescription
    --debugThis will enable debugging when debug value is used.
    --formatThe format of the output.
    --logdirThe directory where the debug log will be saved.
    Optional LogparserCSV Parameters

    Example
    openit_logparsercsv --srcdir "C:\ProgramData\OpeniT\Data\temp\LogFileCollector" --srcpattern "*.data" --srcfilehandling rename --trgdir "C:\Program Files\OpeniT\Core\output"

    The output file must be in the specified target directory.