Import Log: Difference between revisions
Ttenbergen (talk | contribs) No edit summary |
TOstryzniuk (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
''' this article may be the evil twin of [[ImportLog]] | ''' 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. | 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 Care[[TMSX]]database or the Master Medicine [[MedTMS]]database repository. | ||
Other parts of the data that is sent if automatically appeneded other databases the reside on the [[Regional Server]] See [[Data Repositories]]. | |||
The Import log file which records the following information: | |||
*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 | ||
*import date | *import date | ||
*number of files in the batch sent from a site | *number of files in the batch sent from a site | ||
*start or first study number in main database that the first file in batch | *start or first database study number in main database that the first file in the batch appends to. | ||
*end | *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 import log is not readable in current format. The programmer is working on electronic version which will eliminate the need to print out this log each week. [[User:TOstryzniuk|Trish Ostryzniuk]] 18:57, 2012 October 25 (EDT) | |||
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 log file== | ==Location of log file== | ||
| Line 24: | Line 32: | ||
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. | ||
*note: September 6.12 - The Database Programmer is working on changing [[PDA Uploader]].exe so that the import log is saved as a CSV. Currently log has some machine language written into it which makes it unreadable. We cannot view, print or export it. Only the PDA Uploader can execute it to output in readable format. | *note: September 6.12 - The Database Programmer is working on changing [[PDA Uploader]].exe so that the import log is saved as a CSV. Currently log has some machine language written into it which makes it unreadable. We cannot view, print or export it. Only the PDA Uploader can execute it to output in readable format. | ||
When programmer makes the changes we will no long print & store these logs in binders.[[User:TOstryzniuk|Trish Ostryzniuk]] | |||
==Electonic Record== | |||
When programmer makes the changes we will no long print & store these logs in binders. 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== | ||
[[Category:Master Database Programs]] | [[Category:Master Database Programs]] | ||
Revision as of 16:57, 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 Repositories.
The Import 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 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.
- The import log is not readable in current format. The programmer is working on electronic version which will eliminate the need to print out this log each week. Trish Ostryzniuk 18:57, 2012 October 25 (EDT)
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 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 Record
A print out is done every week and stored in an binder in the office. One for Critical Care and another one for Medicine.
- note: September 6.12 - The Database Programmer is working on changing PDA Uploader.exe so that the import log is saved as a CSV. Currently log has some machine language written into it which makes it unreadable. We cannot view, print or export it. Only the PDA Uploader can execute it to output in readable format.
Electonic Record
When programmer makes the changes we will no long print & store these logs in binders. Will have this in place before end of 2012. Trish Ostryzniuk 18:57, 2012 October 25 (EDT)