OMrun Help
Version 4.x
Version 4.x
  • Introduction
    • Features
      • 📊Facts
      • 🔢Figures
    • System Requirements
    • Terms and Definitions
    • Release Notes
      • 📄Version 4.2
      • 📄Version 4.1
      • 📄Version 4.0
    • ❓Getting Help
  • Installation
    • ↘️Install OMrun
      • 📃OMrun Paths
      • 🔑License Key
    • ✔️Verify Setup
    • 🗑️Uninstall OMrun
  • Configuration
    • Data Adaptor
      • Data Queries
    • Program Adaptor
    • Dashboard Configuration
    • Customize own adapter
      • Own data adapter
      • Own program adapter
    • Configuration Files
      • PublishConfig.cfg
      • OMrunDataProvider.cfg
      • OMrunGuiProvider.cfg
      • OMrun.exe.config
    • Using Variables
      • OMrun Variables
      • Environment Variables
      • Parameter
  • Start OMrun
    • Start via Desktop
    • Start via Batch File
    • Start via Task Scheduler
  • Menu Functions
    • ▶️Button Execute
    • ⏹️Button Stop
    • 🎓Button License
    • ⚙️Button Configuration
    • 📥Button Export
    • ❓Button Help
    • 📌Button About
    • 🗂️Button Windows
    • ⏩Shortcuts and Functions
  • Element Overview
    • Navigation Tree
    • Business System
    • Component
    • Environment
    • Scenario
    • Test Data Object
      • Query
      • Body
      • Business Mapping
    • Test Program Object
      • Batch
      • CSV Converter
      • Data Staging
      • Housekeeping
      • Json Converter
      • Program
      • RTL Generator
      • XML Converter
      • XML Converter XL
    • Parameter List
  • Result Analysis
    • Color Codes
    • OMrun Test Results
    • Excel Result Reports
    • OMdashboard
Powered by GitBook
On this page
  • Abstract
  • Input
  • Output
  1. Element Overview
  2. Test Program Object

CSV Converter

PreviousBatchNextData Staging

Last updated 1 year ago

Abstract

Plug-in to convert any flat file into comma separated values file (CSV) within OMrun.

Input

Execution parameters to invoke a conversion:

Field @param1 (Input file) [mandatory]

  • Description: Source location incl. file name + extension

  • Syntax: <full path>\<file name>.<ext>

  • Example: @TestData\Flatfile.txt

Field @param2 (Output path + file) [mandatory]

  • Description: Target location of converted file incl. file name + extension

  • Syntax: <full path>\<file name>.<ext>

  • Example: @TestData\Converted.csv

Field @param3 (2 Delimiter character/s) [1 mandatory]

  • Description: Delimiter before/after conversion without any space (delimiter will not change if one is applied only)

  • Syntax: <1 or 2 delimiters>

  • Example: |; [delimiter before conversion = | and after conversion = ;]

Field @param4 (Additional character before and after any value) [optional]

  • Description: additional character around any value after conversion (needed in special cases to keep leading/trailing spaces)

  • Syntax: <character>

  • Example: @

Output

The converted file contains the same content but with replaced delimiters and double quotes before and after each value ["value"]. Output format of the CSV file will be ANSI by default. Different formats could be set in config file (admin rights needed): C:\Program Files\OMIS\OMrun\BuiltInTests\OMrunPlugIn\_CsvConverter.exe.config