Importing data

<< Click to Display Table of Contents >>

Navigation:  Technical documentation >

Importing data

Previous pageReturn to chapter overviewNext page

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:







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.



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.



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