Transfer Tracker.mdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
Line 4: Line 4:
:: [[Regional Server]]\Output\Transfer_Tracker.mdb
:: [[Regional Server]]\Output\Transfer_Tracker.mdb


It gets this from the backup files.  
It gets its content from the backup files.  


When you open the program, it displays the data from the last time someone has update it, and the date of that update in the top left corner.
When you open the program, it displays the data that was in the most recent data backup from the last time someone has clicked the "update" button it, and the date of that update in the top left corner.  
 
To update it, press the button.  


The program doesn't automatically update because the update can take about 2 minutes. Didn't want to force you to wait when the most recent data might be good enough.  
The program doesn't automatically update because the update can take about 2 minutes. Didn't want to force you to wait when the most recent data might be good enough.  
Line 16: Line 14:


== bugs ==
== bugs ==
* Trish got the following ERROR message when running update for transfer tracker
* also there are two files in this list with a site and location.  Thought this was part of minimal data set?--[[User:TOstryzniuk|TOstryzniuk]] 17:51, 27 January 2011 (CST)
** Could not find file'\\sbghnwfs0101\NSSVOL1\shared\ICU_DATA_COLLECTION\data\VIC_N5\CCMDB.mdb' Error in sub DB_DB_Coverter().
** Trish, I don't understand what you mean. Do you mean ''without'' a site and location? I think those were part of an earlier test, they aren't showing up any more now that I have re-imported.
*** Ah, we changed the names of directories at the Vic since made the program. Ideally it should be self-updating, but I have not figured out how to make that work yet. It will no longer look for Vic_N5 now.  
 


* also there are two files in this list with a site and location.  Thought this was part of minimal data set?--[[User:TOstryzniuk|TOstryzniuk]] 17:51, 27 January 2011 (CST)
== Potential improvements ==
** Trish, I don't understand what you mean. Do you mean ''without'' a site and location? I think those were part of an earlier test, they aren't showing up any longer with the new
* use self-updating directory listing to import rather than a static list (this doesn't affect functionality while things work, it just makes the program a bit more resilient. Right now there is an error if any site can't be found, and if a new site is added and the hard-code is not amended the site just won't import) [[User:Ttenbergen|Ttenbergen]] 11:33, 1 March 2011 (CST)  


* Tina, when I update this most of the dates of discharge are still in 2010 so I am sure it is not current.  Take a look .  Laura
** You were right. This still looked at the database structure before the Jan 1 changes. It now looks at the new ones. [[User:Ttenbergen|Ttenbergen]] 16:33, 16 February 2011 (CST)




[[Category: IT Instructions]]
[[Category: IT Instructions]]

Revision as of 12:33, 1 March 2011

Transfer_Tracker.mdb is a repository of all discharges on our ward within the last 2 weeks.

You can find the transfer tracker at

Regional Server\Output\Transfer_Tracker.mdb

It gets its content from the backup files.

When you open the program, it displays the data that was in the most recent data backup from the last time someone has clicked the "update" button it, and the date of that update in the top left corner.

The program doesn't automatically update because the update can take about 2 minutes. Didn't want to force you to wait when the most recent data might be good enough.

Let me know what you think. Ttenbergen 21:37, 30 December 2010 (CST)


bugs

  • also there are two files in this list with a site and location. Thought this was part of minimal data set?--TOstryzniuk 17:51, 27 January 2011 (CST)
    • Trish, I don't understand what you mean. Do you mean without a site and location? I think those were part of an earlier test, they aren't showing up any more now that I have re-imported.


Potential improvements

  • use self-updating directory listing to import rather than a static list (this doesn't affect functionality while things work, it just makes the program a bit more resilient. Right now there is an error if any site can't be found, and if a new site is added and the hard-code is not amended the site just won't import) Ttenbergen 11:33, 1 March 2011 (CST)