CCMDB.accdb: Difference between revisions

Line 13:

See the [[:Category:Development Documentation | Development Documentation Category]]

~~=DISCUSSION=~~

*Access “(CCMDB)”. This article is pretty sparse at the moment. I would like each data collectors to collaborate in the development of this article. There are a number of questions in there to get things started, sort of a template. Basically what is needed is the “steps” followed to go through ACCESS (CCMDB.mdb) before data files are SEND to the regional server? Some of you may have some “good tips” that others can learn from so please add them to this articles. Any little detail from each collector will help this article grow into a useful guide. Don’t worry about how you put the information in this article or spelling etc. It can be reorganized as we go.

~~--[[User:TOstryzniuk|TOstryzniuk]] 23:21, 13 March 2009 (CDT):[[Image:MottiGrassGrow.gif]]~~

== Before Synching ==

Some of you seem to do extensive checks before synching and letting CCMDB.mdb do checks for you. I am curious - why? I thought we made the ccmdb to automate and facilitate these checks. Any thoughts? [[User:Ttenbergen|Ttenbergen]] 22:25, 4 May 2009 (CDT)

Some of you seem to do extensive checks before synching and letting CCMDB.mdb do checks for you. I am curious - why? I thought we made the ccmdb to automate and facilitate these checks. Any thoughts? [[User:Ttenbergen|Ttenbergen]] 22:25, 4 May 2009 (CDT) {{discussion}}

== Synching ==

Line 30:

Line 27:

==Deleting data on PDA after sending from access==

**Before sending, I check my PDA to see if I have entered all my data.Ensuring info is ~~complete on completed profiles.~~

What is the process everyone should follow '''before''' deleting sent patients from the PDA? Some people check with Pagasa, some check on the regional server that data has actually been posted. Is it a common occurrence for data not to have been posted? [[User:Ttenbergen|Ttenbergen]] 22:32, 4 May 2009 (CDT) {{discussion}}

~~Ensure computer is onto regional server.~~

*go to regional server Output folder.

~~Sync my~~ PDA.

~~In microsoft active sync~~, check ~~for errors, press ok once~~

~~scrolled through and no errors.~~

~~In microsoft active sync, click explore.~~

~~Double click HandDBase 3.~~

~~Highlight L logs.~~

~~Edit-copy, make small.~~

~~Log into~~ regional server~~, LHandiBase~~

~~Click S5~~.

~~Edit, paste, yes to all.~~

~~once~~ it ~~hightlights blue, I make it small.~~

~~Turn off PDA, resync.~~

~~Check files~~ for ~~errors in microsoft active sync.~~

~~Click onto new folder.~~

~~Open with cookies.~~

~~V_temp studies, checker.~~

~~If no errors, click edit profiles.~~

~~Filter on top right corner.~~

~~Click through completed profiles.~~

~~Fill in missing~~ data ~~highlighted by yellow.~~

~~Once all profiles checked complete, close the door.~~

~~Hit send.~~

~~Add batch no.~~

~~Add initials.~~

~~Check true/false-scroll over lines~~ to ~~ready dates.~~

~~Click out, click yes to save~~, ~~approx 5 save's.~~

go to regional server Output folder.

Check Vic folder

go to recent batch #.CSV

Line 65:

Line 35:

Delete completed profiles off PDA.

[[User:WGobert|gogogirl]] 16:19, 18 March 2009 (CDT)

~~{{discussion}}~~

*After closing access I click on output, then your unit open up the info and check. eg the number of completes, admits, comorbs, etc. I then delete my completes on my PDA--[[User:PStein|PStein]] 08:36, 18 March 2009 (CDT)

~~discussion~~

*After sending you check your output by opening twister and clicking on output, then find your site and click on the batch number csv you just sent. Your sent files should appear, scroll across and make sure the areas that have to have information in them ie. admit date and time etc. are filled in. If everything looks OK close out and you can deiete your completed files. Lois -- [[User:LBilesky|LBilesky]] 14:47, 17 March 2009 (CDT)

Line 76:

Line 46:

**Confused, why gather this information when we are expecting lap-tops soon and the process will change?--[[User:JHutton|JHutton]] 09:53, 16 March 2009 (CDT)

***Thank you for your contribution. All sites being able to use a lap-top is some time away. At this time we will only use laptops at one site for beta testing. Never-the-less, the lap top will employ the use of '''MS ACCESS''' for collection and entry, therefore the above steps are will still apply. --[[User:TOstryzniuk|TOstryzniuk]] 13:26, 16 March 2009 (CDT)

**** Articles describing most of these steps already existed. Please make sure you do a search before starting an article so you don't duplicate work that has already been done.

**** Articles describing most of these steps already existed. Please make sure you do a search before starting an article so you don't duplicate work that has already been done. That said, I am glad to see so many of you providing input! [[User:Ttenbergen|Ttenbergen]] 22:32, 4 May 2009 (CDT)

[[Category:IT Instructions]]

[[Category: Data Repository]]

[[Category: Questions_IT]]

@@ Line 13: / Line 13: @@
 See the [[:Category:Development Documentation | Development Documentation Category]]
-=DISCUSSION=
-*Access “(CCMDB)”.  This article is pretty sparse at the moment.   I would like each data collectors to collaborate in the development of this article.  There are a number of questions in there to get things started, sort of a template.  Basically what is needed is the “steps” followed to go through ACCESS (CCMDB.mdb) before data files are SEND to the regional server?    Some of you may have some “good tips” that others can learn from so please add them to this articles.  Any little detail from each collector will help this article grow into a useful guide.  Don’t worry about how you put the information in this article or spelling etc.  It can be reorganized as we go.
---[[User:TOstryzniuk|TOstryzniuk]] 23:21, 13 March 2009 (CDT):[[Image:MottiGrassGrow.gif]]
 == Before Synching ==
-Some of you seem to do extensive checks before synching and letting CCMDB.mdb do checks for you. I am curious - why? I thought we made the ccmdb to automate and facilitate these checks. Any thoughts? [[User:Ttenbergen|Ttenbergen]] 22:25, 4 May 2009 (CDT)
+Some of you seem to do extensive checks before synching and letting CCMDB.mdb do checks for you. I am curious - why? I thought we made the ccmdb to automate and facilitate these checks. Any thoughts? [[User:Ttenbergen|Ttenbergen]] 22:25, 4 May 2009 (CDT) {{discussion}}
 == Synching ==
@@ Line 30: / Line 27: @@
 ==Deleting data on PDA after sending from access==
-**Before sending, I check my PDA to see if I have entered all my data.Ensuring info is complete on completed profiles.
+What is the process everyone should follow '''before''' deleting sent patients from the PDA? Some people check with Pagasa, some check on the regional server that data has actually been posted. Is it a common occurrence for data not to have been posted? [[User:Ttenbergen|Ttenbergen]] 22:32, 4 May 2009 (CDT) {{discussion}}
-Ensure computer is onto regional server.
+*go to regional server  Output folder.
-Sync my PDA.
-In microsoft active sync, check for errors, press ok once
-scrolled through and no errors.
-In microsoft active sync, click explore.
-Double click HandDBase 3.
-Highlight L logs.
-Edit-copy, make small.
-Log into regional server, LHandiBase
-Click S5.
-Edit, paste, yes to all.
-once it hightlights blue, I make it small.
-Turn off PDA, resync.
-Check files for errors in microsoft active sync.
-Click onto new folder.
-Open with cookies.
-V_temp studies, checker.
-If no errors, click edit profiles.
-Filter on top right corner.
-Click through completed profiles.
-Fill in missing data highlighted by yellow.
-Once all profiles checked complete, close the door.
-Hit send.
-Add batch no.
-Add initials.
-Check true/false-scroll over lines to ready dates.
-Click out, click yes to save, approx 5 save's.
-go to regional server  Output folder.
 Check Vic folder
 go to recent batch #.CSV
@@ Line 65: / Line 35: @@
 Delete completed profiles off PDA.
 [[User:WGobert|gogogirl]] 16:19, 18 March 2009 (CDT)
-{{discussion}}
 *After closing access I click on output, then your unit open up the info and check. eg the number of completes, admits, comorbs, etc. I then delete my completes on my PDA--[[User:PStein|PStein]] 08:36, 18 March 2009 (CDT)
-~~discussion~~
 *After sending you check your output by opening twister and clicking on output, then find your site and click on the batch number csv you just sent. Your sent files should appear, scroll across and make sure the areas that have to have information in them ie. admit date and time etc. are filled in. If everything looks OK close out and you can deiete your completed files. Lois -- [[User:LBilesky|LBilesky]] 14:47, 17 March 2009 (CDT)
@@ Line 76: / Line 46: @@
 **Confused, why gather this information when we are expecting lap-tops soon and the process will change?--[[User:JHutton|JHutton]] 09:53, 16 March 2009 (CDT)
 ***Thank you for your contribution.  All sites being able to use a lap-top is some time away. At this time we will only use laptops at one site for beta testing.     Never-the-less, the lap top will employ the use of '''MS ACCESS''' for collection and entry, therefore the above steps are will still apply. --[[User:TOstryzniuk|TOstryzniuk]] 13:26, 16 March 2009 (CDT)
-**** Articles describing most of these steps already existed. Please make sure you do a search before starting an article so you don't duplicate work that has already been done.
+**** Articles describing most of these steps already existed. Please make sure you do a search before starting an article so you don't duplicate work that has already been done. That said, I am glad to see so many of you providing input! [[User:Ttenbergen|Ttenbergen]] 22:32, 4 May 2009 (CDT)
 [[Category:IT Instructions]]
 [[Category: Data Repository]]
 [[Category: Questions_IT]]