Import Log

Also referred to as the AppendLog.

This is a log files that is created automatically by the PDA Reader/PDA Uploaderexe. 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) Data Repository.

Other parts of the data that is sent are automatically appended other Data Repositories. that reside on the Regional Server.

Information on Import Log

• append batch number
• name of CSV file that was sent from site to Regional Server: 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.

Weekly printout

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

A paper print out is done every week after appending data to master database and the paper is stored in an binder in the office.

• Blue label binder for ICU -paper printout
• Red label binder for MED -paper printout

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\Import Log\CriticalLog.log

Medicine database MedTMS:

• C:\MEDPDAdnld\Import Log\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 Data Processor executes a printout from the PDA Reader/PDA Uploader.exe. 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)

• There will be a maximum of 40 characters allowed in the label name for sent CSV data file. If we want electronic log, current PDA reader has a problem with sent files names longer than 16 characters. It truncates the label name when it reads in the log files names. 40 character max will give us some flexibilty and we will than not have to be so strict with these files names, example - resent data where we typed in added info into send file so Pagasa is clear it is a resend or test also some staff do not use only two letters for their intials when sending files.- Trish Ostryzniuk 20:57, 2012 October 25 (EDT)

Use of Import log

1. Easy to find out the study number who sent that batch and the date it was sent.PTorres 12:09, 2012 October 26 (EDT)
2. Error investigation-can trace back to orginal sent file. List helps narrow down quickly which append batch sent file is in.
   • I still don't understand how this helps. So, let's assume you find a patient with an error. You need the collector to fix the error. If you send the info about the patient, incl. identifiers and admit and discharge dates to the collector, they should be abel to get the file from med records, right? How does having a batch number make this any easier? Ttenbergen 14:44, 2012 October 31 (EDT) Template:Discussion

• Pagasa & Julie...Trish Ostryzniuk 19:01, 2012 October 25 (EDT)