Importing question responses from a file with the Command Line

You can use the Command Line module to import subject data into your database from a CSV or XML file. This call imports the file into the Batch Data Loading buffer and then uploads them into the database.

Import files must be formatted correctly, as described for CSV and XML.

The Command Line provides a separate method for entering single question responses.

Parameters

Ensure you follow the required conventions when specifying user credentials and visit/eForm parameters.

Parameter	Description
Functionality identifier	"BIU"
User credentials	User name/Password/Database/Userrole
Path and name of file	Full path and name of .csv or .xml file to be imported. You can also import data from a .bat file but you must ensure it is located in the same folder as the 'InferMed.M40.MACRO_BD.exe' file.

Command Line format

Importing a batch response file:

/BIU/Username/Password/Database/Role/Path and name of import file

Example

This will import the batch file 'Import_46.csv' from the C:\ Folder:

InferMed.M40.MACRO_BD.exe /BIU/rde/macrotm/demo/FullUser/C:\Import_46.csv

Return to top

Errors

For each call, a Command Line error will be written to a BIUCL log file in the AppPath.Temp folder if the command line is not in the correct format, e.g. missing or unexpected parameters.

Two additional levels of checking take place when importing a file:

Firstly, each file is checked to ensure it can be successfully imported into the Response Buffer. If the import fails at this stage the error information can only be viewed in the Message field of the Buffer in the Batch Data Loading module.

Secondly, each file is checked to ensure it can be successfully uploaded to the MACRO database. If the import fails at this stage the error information is logged in a BIUCL log file in the AppPath.Temp folder.

Return to top