CCMDB Wiki

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

← Older edit
m Text replacement - "[[Category: " to "[[Category:"
 
(258 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 [[Centralized data front end.mdb Change Log]] 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>
=== fix date format ===
* as per [[Log#2013-11-18]]


=== automate re-linking of tables ===
==New change request==
Ask for the phi and centralized directories and reconnect.
<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 ===
{{Todo
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.
| who = Tina
| todo_added = 2021-07-15 
| todo_action =  
| question = _dev_CFE
* CCI and ICD10 make button for Pagasa}}


=== Error Checking Queries required ===
=== Move Linked Pairs ===
we should probably revisit [[:Category:Cleaner.mdb Data Integrity Checks‏‎]] in this context.
{{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"