CCMDB Wiki

Centralized data front end.accdb Change Log 2025: Difference between revisions

← Older editNewer edit →
Line 8: Line 8:
* added Sub ListModuleEntities(moduleName As String) and dump_all_vba to [[_Global module]] to help document code
* added Sub ListModuleEntities(moduleName As String) and dump_all_vba to [[_Global module]] to help document code
* added Sub DumpAllQueries_UTF8() to [[_Global module]] to help document queries
* added Sub DumpAllQueries_UTF8() to [[_Global module]] to help document queries
* added some code for data modelling:
** added [[Function wrangle_Boarding_Loc()]] to [[module _Unique_CFE]] to generate a derived table with is_first_ER and is_first_non_ER columns; those were very expensive to calculate on the fly, running this is much faster. [[User:Ttenbergen|Ttenbergen]] 13:23, 9 July 2025 (CDT)
** also added the queries for this: manifest_BoardingLoc, manifest_BoardingLoc_firstTemp, manifest_BoardingLoc_firstTemp
* updated connector.confirm_files_and_links() to behave if the old LMS or Tiss28 files are not present (ie re-connect only if present)
* updated connector.confirm_files_and_links() to behave if the old LMS or Tiss28 files are not present (ie re-connect only if present)
* updated [[Overstay2 module]]  
* updated [[Overstay2 module]]  
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.accdb_Change_Log_2025"