Import Log: Difference between revisions
TOstryzniuk (talk | contribs) mNo edit summary |
TOstryzniuk (talk | contribs) mNo edit summary |
||
| Line 5: | Line 5: | ||
Other parts of the data that is sent if automatically appeneded other databases the reside on the [[Regional Server]] See [[:Category: Data Repository | Data Repository]]. | Other parts of the data that is sent if automatically appeneded other databases the reside on the [[Regional Server]] See [[:Category: Data Repository | Data Repository]]. | ||
==Information on Import Log== | |||
*append batch number | *append batch number | ||
*name of CSV file that was sent from site: e.g. 50_HSC_MICU_GH.txt | *name of CSV file that was sent from site: e.g. 50_HSC_MICU_GH.txt | ||
| Line 13: | Line 13: | ||
*end of last database study number in main database that last file in the batch appends to. | *end of last database study number in main database that last file in the batch appends to. | ||
The data processor prints out the Import Log report each week when she appends data to master database | The data processor prints out the Import Log report each week when she appends data to master database. | ||
==Yearly changes== | |||
At the beginning of each New Year, the import log file is renamed by the data processor and the record is kept in backup folder for that year. A new log file will automatically be created with the append batch number starting back at number one. This is done to avoid large numeric batch numbers. | At the beginning of each New Year, the import log file is renamed by the data processor and the record is kept in backup folder for that year. A new log file will automatically be created with the append batch number starting back at number one. This is done to avoid large numeric batch numbers. | ||
==Location of Import log file== | ==Location of Import log file== | ||
===Paper Import log file=== | |||
*Blue label binder for ICU -paper printout | |||
*Red label binder for MED -paper printout | |||
**A print out is done every week and stored in an binder in the office. One for Critical Care and another one for Medicine. | |||
*** | |||
===Electronic Import log file=== | |||
The automatically created log file is located on the local C drive of main data processor's computer: | |||
Critical Care [[TMSX]] database: | Critical Care [[TMSX]] database: | ||
| Line 32: | Line 33: | ||
*C:\MEDPDAdnld\[[ImportLog]]\'''MedicalLog.log''' | *C:\MEDPDAdnld\[[ImportLog]]\'''MedicalLog.log''' | ||
The import log is not readable in current format. September 6.12 - The Database Programmer is working on changing [[PDA Uploader]].exe for both [[TMSX]] & [[MedTMS]] so that the import log is saved as a CSV (more user friendly file). Currently the import log has some machine language written into it which makes rather unreadable. The only way this log is legible is if PDA uploader executes a printout. We will stop printing and storing these paper logs in binders above once update is completed. Will have this in place before end of 2012. [[User:TOstryzniuk|Trish Ostryzniuk]] 18:57, 2012 October 25 (EDT) | |||
==Use of Import log== | ==Use of Import log== | ||
Revision as of 17:20, 2012 October 25
this article may be the evil twin of ImportLog Also referred to as the Append Log.
This is a log files that is created automatically by the PDA Uploader.exe. every time the Data Processor uploads (appends) most of the sent csv files to either the Master Critical CareTMSXdatabase or the Master Medicine MedTMSdatabase repository. Other parts of the data that is sent if automatically appeneded other databases the reside on the Regional Server See Data Repository.
Information on Import Log
- 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 database study number in main database that the first file in the batch appends to.
- end of last database study number in main database that last file in the batch appends to.
The data processor prints out the Import Log report each week when she appends data to master database.
Yearly changes
At the beginning of each New Year, the import log file is renamed by the data processor and the record is kept in backup folder for that year. A new log file will automatically be created with the append batch number starting back at number one. This is done to avoid large numeric batch numbers.
Location of Import log file
Paper Import log file
- Blue label binder for ICU -paper printout
- Red label binder for MED -paper printout
- A print out is done every week and stored in an binder in the office. One for Critical Care and another one for Medicine.
- A print out is done every week and stored in an binder in the office. One for Critical Care and another one for Medicine.
Electronic Import log file
The automatically created log file is located on the local C drive of main data processor's computer:
Critical Care TMSX database:
- C:\CritPDAdnld\ImportLog\CriticalLog.log
Medicine database MedTMS:
- C:\MEDPDAdnld\ImportLog\MedicalLog.log
The import log is not readable in current format. September 6.12 - The Database Programmer is working on changing PDA Uploader.exe for both TMSX & MedTMS so that the import log is saved as a CSV (more user friendly file). Currently the import log has some machine language written into it which makes rather unreadable. The only way this log is legible is if PDA uploader executes a printout. We will stop printing and storing these paper logs in binders above once update is completed. Will have this in place before end of 2012. Trish Ostryzniuk 18:57, 2012 October 25 (EDT)
Use of Import log
- pagasa & Julie...Trish Ostryzniuk 19:01, 2012 October 25 (EDT)