Using FTLabImp.EXE

<< Click to Display Table of Contents >>

Navigation:  Technical documentation > Importing data >

Using FTLabImp.EXE

Previous pageReturn to chapter overviewNext page

The program FTLabImp.EXE can be used to import a subset of Kith XML messages.  

 

Specifying the connection string

The connection string must be in the form of a UDL-file with the name FTLabImp.UDL or FastTrak.UDL.  If both are present, FastTrak.UDL is used.  This file must be located in the same folder as the executable.  Using integrated NT security is recommended, as this will eliminate the need to store the password in the UDL file.

 

Command line parameters

The source data (XML message files) will be processed using a file pattern specified with the SourcePath command line option.  A typical example could be:

 

FTLabImp SourcePath=d:\well\inbox\*.xml StudyName=GBD

 

The second parameter, StudyName, is the protocol the data will be imported into.  This has no effect for laboratory data, as this type of data is shared between protocols in a database.

 

Adding missing persons

Adding the parameter AddPerson to the command line will allow FTLabImp to add new persons to the database when importing messages.  This can only happen if the name is specified using the format "Doe, John" (with comma), or if both first and last name of the patient is already present in the Person table.

 

Permissions

The database user specified in the UDL file must exist in the database, and must be granted the DataImport role.

 

Archive folder

Processed files are moved into a subdirectiry called Archive\XXX where XXX is the message description, e.g. CLIN.  The subdirectories must exist, they  are not created by FTKithImp.EXE.

 

Limitations

Currently, FTKithImp.EXE will only import clinical chemistry messages.  Support for other message types, like discharge summaries (Epikrise) and microbiological results has not been released.