<< Click to Display Table of Contents >> Navigation:  Working with Spreadsheets > Spreadsheet Import Through Command Line

How can I use command line to import spreadsheets?

The HIPAA Authorizer application does provide import facility through command line interface. Import configuration can only be done through UI. Follow the steps below to complete an import though command lines:

 

1.Search for the "Command Prompt" in the Start menu of your computer and open it.

 

 

2.Copy the following command then paste it into the command window and press "Enter":

 

C:\>cmd.exe D:\Keyur\Import\Import2.xlsx,I,T,false,false,false

 

This will set the spreadsheet import settings. See the arguments of the command below:

 

File Path (D:\Keyur\Import\Import2.xlsx)

This portion signifies the file path from where you want to import the data.

 

Import (I)

This argument provides the detail of the import operation.

 

Database Configuration Selection

 

Test (T)

This argument represents test Database and P for Production (Prod) Database. Based on this parameter value, imported claim data would be inserted either on a Test or Live Database.

 

Excel Format (IsSingleSheet — true/false)
This parameter accepts a boolean value for whether the imported file is SingleSheet or MultiSheet. In the above example, it is being passed as "false," meaning that imported spreadsheets are multi-sheet format.

 

IsComplianceCheck
This parameter checks for whether to perform compliance checks before import operation or not.