CCMDB Wiki

Centralized data front end.accdb Change Request: Difference between revisions

← Older edit
m Text replacement - "[[Category: " to "[[Category:"
 
(268 intermediate revisions by 4 users not shown)
Line 1: Line 1:
''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''
''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''


This article contains requested changes for [[Centralized data front end.mdb]]. See [[]] for it's change log.
This article contains requested changes for [[Centralized data front end.accdb]]. See [[Centralized data front end.accdb Change Log]] for it's change log.


== Requested Changes ==
<big>'''Generally items should be discussed and flagged for change on their own page, and not here. Only changes that don't have wiki pages yet should be listed here.'''</big>
=== s_table reconciliation ===
Front end needs access to most s_table data. I set up a copy process to the regeional server, but Brad rightly pointed out that this would be better off right in the program. Need to import s_tables into front_end, update update-process to include this as part of the deal.


=== Sending SendDtTm ===
==New change request==
*[[Centralized_data.mdb]] - Fix SendDtTm.  Patient that are entered onto laptop AND completed BETWEEN sending dates each week, are missing SendDtTm stamp.  Details as per email sent today. [[User:TOstryzniuk|Trish Ostryzniuk]] 17:51, 2013 October 21 (CDT)
<big>'''Generally items should be discussed and flagged for change on their own page, and not here. Only changes that don't have wiki pages yet should be listed here.'''</big>
**Still not working as per Pagasa to Tina Nov 8.13
* [[Centralized_data.mdb_Change_Log#time_sent_and_time_completed]]


=== Error Checking Queries required ===
{{Todo
we should probably revisit [[:Category:Cleaner.mdb Data Integrity Checks‏‎]] in this context. 
| who = Tina
| todo_added = 2021-07-15 
| todo_action =  
| question = _dev_CFE
* CCI and ICD10 make button for Pagasa}}


==== Duplicate entry caused by changed location ====
=== Move Linked Pairs ===
* generate request to notify Pagasa if location changed after first send (generates duplicate entries) Ttenbergen 16:23, 2013 September 11 (CDT)
{{Todo
| who = Tina
| todo_added = 2021-07-15 
| todo_action =  
| question = _dev_CFE
* Linked pairs, better storage }}
As discussed with Julie to prevent her having to rerun it and to insure that what Pagasa queries against is same as what Julie uses.
* need to change the query and process from one that re-does all, every time, to one that only updates new.
** How will that work for individual older records that were edited?


=== importing csvs ===
== Related articles ==
* '''problem importing csv files is with the date field... need to give it the right import specs'''Ttenbergen 17:34, 2013 November 4 (CST)
{{Related Articles}}
** Brad will look into that one, in a different file.


 
[[Category:Development Documentation]]
[[Category: Development Documentation]]
[[Category:2013 data upgrades]]
[[category:2013 data upgrades]]
[[Category:Centralized data front end.accdb]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.accdb_Change_Request"