Centralized data front end.accdb Change Request

see the Development Documentation Category for other development logs

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

Requested Changes

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

• 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. Trish Ostryzniuk 17:51, 2013 October 21 (CDT)
  • 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

we should probably revisit Category:Cleaner.mdb Data Integrity Checks‏‎ in this context.

Duplicate entry caused by changed location

• generate request to notify Pagasa if location changed after first send (generates duplicate entries) Ttenbergen 16:23, 2013 September 11 (CDT)

importing csvs

• problem importing csv files is with the date field... need to give it the right import specsTtenbergen 17:34, 2013 November 4 (CST)
  • Brad will look into that one, in a different file.