Technical documentation > Importing data

The FastTrak database has a simple API for importing data, consisting of set of stored procedures. The API allows you to write four different types of data to the database:

•Demographics

•Diagnoses

•Medication

•Labdata

All data is marked as imported, allowing you to rollback (remove) the imported data. This gives the opportunity to repeat an import if the import process is improved.

Permissions

When importing data, the the database user doing the import should have the role DataImport granted. A separate user for this purpose could be created. To grant the role, use the FastAdmin.EXE program, or a general SQL Server management application.

Importing data

Importing data

Permissions

When importing data, the the database user doing the import should have the role DataImport granted. A separate user for this purpose could be created. To grant the role, use the FastAdmin.EXE program, or a general SQL Server management application.

Version

The import process is described as it applies to database version 401. To check database version, execute the procedure GetDatabaseInfo.