...
This page is designed as a way to organize the issues around importing data into StudyTRAX from an existing database. "Out-of-the-Box" StudyTRAX uses MS Excel to import data. There is a good bit of functionality built . Before importing the datain StudyTRAX to accommodate this, however, the questions and issues below should be addressedaddressed BEFORE importing data.
Current System
In order to prepare the data for import via Excel, it is helpful to know:
...
Often when converting data over form another system, there are a number of desired changes to be made. In short, a decision will need to be made on whether to import that data "As-Is" for historical reference, or will there be an attempt made to combine the old database and new project in StudyTRAX. If the later, typically there will need to be a way to identify subjects collected in the old system versus new. Also, errors of omission (i.e., old subjects not having values for the planned new fields [i.e., specificity errors]) will need to be discussed).