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" /csv /excel

HIPAAConvert /help

HIPAAConvert /license

HIPAAConvert /config


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.

/OutputHeader instructs program to output 835 header, payment group information, and provider adjustment data to the output file. If this parameter is not present, only 835 payment information is exported to the output file. This parameter apply to both Excel and CSV output file format. For output Excel file, header information is stored in a different sheet in Excel file. For CSV output file, these data are save in different files. See example below.

/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.

/config display output file configuration windows. For detail, go to Output Configuration.

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

/activate834 activate your HIPAA 834 conversion license. You need to purchase a subscription at www.hsu-computing.com before activation. This option will prompt you to enter a user name and password. You need to use the user name used to purchase the subscription at our website. Use /activate835, /activate837P, and /activate837I to activate other HIPAA file conversions.

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

/excel output Excel file format

/R2 set output file to old R2 format (this is for our customers who are using older formats)

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 in the command line window (screen).

HipaaConvert /config

Display program output file configuration menu. You can configure output file format, select output data element, select output Excel columns. For more information about configuration, go to Output Configuration

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 the 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 the folder c:\input.
This command converts them to test1.csv and test2.csv files and saves them in the folder c:\output.

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

Assume you have test1.txt and test2.txt in the folder c:\input.
For input file test1.txt, program will generate the following output files in c:\output folder:

Where: Similar files will be generated for test2.txt file.