Centralized data front end.accdb Change Request

From CCMDB Wiki
Revision as of 00:01, 2013 November 19 by Ttenbergen (talk | contribs) (→‎Duplicate entry caused by changed location: bet Pagasa has a query for that by now :-))
Jump to navigation Jump to search

see the 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.

Requested Changes

SAS front end for labs

make query for SAS to give names of labs with legacy numbers. See S_AllLabsTable

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.

Error Checking Queries required

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

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.
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.accdb_Change_Request&oldid=35914"