Import Log

This is a log files that is created automatically by the PDA Uploader.exe. When a csv file from a data collection site is uploaded to the master database (for Medicine MedTMS or Critical CareTMSX), by the data processor, the PDA uploader creates a log file which records the following information:

• append batch number
• name of CSV file that was sent from site: e.g. 50_HSC_MICU_GH.txt
• import date
• number of files in the batch sent from a site
• start or first study number in main database that the first file in batch appended to.
• end or last study number in main database that last file in batch was appended to.

At the beginning of the new year, this log file is renamed and and new log file starts with the append batch number starting back at number one. This is done because the append number would become to huge.

Location of log file

Is located on the local C drive of main data processor's computer.

Critical Care:

• C:\CritPDAdnld\ImportLog\CriticalLog.log

Medicine:

• C:\MedPDAdnld\ImportLog\MedLog.log

Paper

A print out is done every week and stored in an office binder.

• note: September 6.12 - The Database Programmer is working on changing PDA Uploader so that the import log is saved as a CSV. Once this is done, no more print out and storing of paper.Trish Ostryzniuk 19:33, 2012 September 6 (CDT)