HIMSS Webinar: How Process Intelligence Transforms Healthcare Service Delivery and Costs
June 28th, 2018 1pm CT
Register here

Automating the Data Manager Utility

To run the DataManager utility from the command line, you call the DataManager executable with the following parameters:

/CONFIG – full path to the. TPI DataManager Job configuration file
/IN1 – /IN100 – the names of the files loaded into the DataManager in the same order they exist in the Job
/OUT1 – /OUT100 – the name of the file(s) generated in DataManager, in the same output order

Example Statement:

>”Path to DataManager Executable (datamanager.exe)” /CONFIG “Path to .TPI DataManager Job File” /IN1 “First Input File in the DataManager Job” /IN2 “Second Input File in the DataManager Job” /OUT1 “Output File in the DataManager Job”

 

Example Scenario

We want to do a simple join between 2 CSV files in order to include data from a second file in our main source. In this scenario, there are a few files necessary in order to run this job.

First, we need a DataManager .TPI file which executes the join logic:

.TPI DataManager Job File – Join.TPI

Next, we need our 2 source CSV files with corresponding data fields:
2 Source Files – Order to Cash Sample TPI Data.CSV & Order to Cash Shipping Source Data.CSV

Lastly, we want to specify the output file where we should save the resulting data:
1 Output File – OUTPUT_FILE.CSV

For the example and corresponding files above, the command line statement looks like this:

>”C:\Program Files\…\datamanager.exe /CONFIG “C:\…\JOIN.TPI” /IN1 “C:\…\ Order to Cash Shipping Source Data.CSV” /IN2 “C:\…\ Order to Cash Sample TPI Data.CSV” /OUT1 “C:\…\Order to Cash Sample\OUTPUT_FILE.csv”