CCMDB Wiki

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

← Older edit
m Text replacement - "[[Category: " to "[[Category:"
 
(261 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>
=== automate re-linking of tables ===
Ask for the phi and centralized directories and reconnect.


=== s_table reconciliation ===
==New change request==
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.
<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>


=== 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}}


=== importing csvs ===
=== Move Linked Pairs ===
* '''problem importing csv files is with the date field... need to give it the right import specs'''Ttenbergen 17:34, 2013 November 4 (CST)
{{Todo
** Brad will look into that one, in a different file.
| 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?


== Related articles ==
{{Related Articles}}


[[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"