Import Log: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
mNo edit summary
TOstryzniuk (talk | contribs)
mNo edit summary
Line 1: Line 1:
This is a log files that is created automatically created by the PDA reader.exe.  When a file is uploaded to the master database; for Medicine [[MedTMS]] or Critical Care[[TMSX]], it records the batch number, name of CSV file, import date, number of files in the batch and start and end main database study number batch was appended to.
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 Care[[TMSX]]), 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==
==Location of log file==

Revision as of 18:31, 2012 September 6

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