HIPAA File (834/835/837) to Excel Command Line Program

This program is running as a standalone program in a "Command Prompt Window". The executable file name is HipaaConvert.exe. You can run this program in a command Line Window, or write a command script file to do batch processing. If you need a graphic user interface for batch processing, please check "HIPAA File to Excel Batch" program.

You can download a trial version here: Download


Command Syntax:

HIPAAConvert /input="Full_Qualified_Folder\Input835.txt" /output="Fully_Qualified_Folder\out.csv" /overwrite=yes /Log="Fully_Qualified_Log_Folder" /license /csv /excel


Where:

An example of a Fully Qualifier Folder is : C:\Users\John Doe\Documents
An example of an input file is: C:\Users\John Doe\Documents\test835.txt

/input= specifies the input file name. Double quote the file name if there is blank space in the file name. You can use wildcards (* and ?) to include multiple input files. See notes below. This is the only required parameter.

/output= specifies the output file or output folder in case wildcards is used. Use fully qualified name if you want to specifiy output folder different from the current folder, the executable command file folder.

/overwrite=Yes/No, This program will overwirte an existing file when you specifiy this parameter. In absentence of this parameter and a file has the same name as the output file, this program exits and flags an error.

/log= specifies the log file folder location. If this parameter is not present, log folder is set to user's Documents folder, like "C:\users\John Doe\Documents". The log file name is Log-yyyymmdd.txt". It is created for each daily run, where yyyy-year, mm-month, dd-date.

/license display license information on command line windows (Screen).

/csv output CSV file format. This is the default output format if no output format is specified.

/excel output Excel file format

Command parameters are case insensitive. /input= and /InPut= are the same.

How to use wildcards to specify multiple input files

When you use * or ? in the /input parameter, the /output parameter is used to specify the output folder. The output file name will be same as the input file name with csv or xlsx extension depending upon the output file format.

If you do not specify the output parameter, the output files will be placed in the input file folder.

Examples:

HipaaConvert /license"

Program displays your license information on the command line window (screen).

HipaaConvert /input="c:\input\test835.txt"

output file will be "c:\input\test835.csv"

HipaaConvert /input="c:\input\test835.txt" /output="c:\output\test835.txt"

output file will be "c:\output\test835.csv"

HipaaConvert /input="c:\input\test835.txt /excel"

output file will be "c:\input\test835.xlsx"

HipaaConvert /input="c:\input\*.txt"

Assume you have test1.txt and test2.txt in folder c:\input.
This command converts them to test1.csv and test2.csv files in the same folder

HipaaConvert /input="c:\input\*.txt" /output="c:\output"

Assume you have test1.txt and test2.txt in folder c:\input.
This command converts them to test1.csv and test2.csv files and saves them in folder c:\output.