Instructions for exporting data using MCHP Export.accdb: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
|||
| (8 intermediate revisions by 2 users not shown) | |||
| Line 25: | Line 25: | ||
==== Contents of the export files ==== | ==== Contents of the export files ==== | ||
* [[MCHP Export.accdb]] : before 2020-05-05, the exported file contains from the beginning of the database to the current time. Starting 2020-05-05, the data file being sent start always from 2019-01-01 to current. | * [[MCHP Export.accdb]] : before 2020-05-05, the exported file contains from the beginning of the database to the current time. Starting 2020-05-05, the data file being sent start always from 2019-01-01 to current. | ||
* [[ | * [[PHI.mdb]] contains always from the beginning of the database to current. | ||
==== Temporary instruction re:[[LAU Collection Project]] ==== | |||
* starting 2025-03-01, Non-medicine wards or Lower Acute units [[LAU]] have been collected as a temporary project [[LAU Collection Project]] and incorporated into [[CCMDB.accdb]]. These records need to be excluded manually from the export files before sending. | |||
** How? create a sub-folder under the S:\MED\MED_CCMED\CCMDB_Special_Projects\MCHP and label it by yyyy-mm-dd (the date when the export files were done). Copy the [[MCHP Export.accdb]] and the [[PHI.mdb]] from the desktop into the sub-folder. | |||
*** Open the [[MCHP Export.accdb]] and click L_LOG_MCHP table. Filter those records having service location with loc_type LAU or right click any record under [[D ID field]] and choose '''text filters contains LAU''' ). Then delete them all and consequently the related tables should clear out as well. | |||
*** Similarly open [[PHI.mdb]] and click L_PHI table. Filter those records by right clicking any record under [[D ID field]] and choose '''text filters contains LAU'''. Then delete them all. | |||
* End date: none yet | |||
=== sending === | === sending === | ||
* review to make sure there are no big outstanding questions that will make our data look bad; a page on the wiki that might help with this is [[Portal related pages with questions]] | * review to make sure there are no big outstanding questions that will make our data look bad; a page on the wiki that might help with this is [[Portal related pages with questions]] | ||
* Zip the individual files by using the 7-zip file manager - find the files and click '''ADD''' and it will open a screen. Rename the files into CCMDB_MCHP_export_date and CCMDB_phi_date. Encrypt the zip files by using the passwords indicated from the excel file of Passwords_MainOffice from the shared folder. | * Zip the individual files by using the 7-zip file manager - find the files and click '''ADD to archive''' and it will open a screen. Rename the files into CCMDB_MCHP_export_date and CCMDB_phi_date. Encrypt the zip files by using the passwords indicated from the excel file of Passwords_MainOffice from the shared folder. | ||
* after zipping the files in the next two steps, try opening them on a different computer before sending them out of office; we had a problem with the zipped file during the 2020-04-30 send. | * after zipping the files in the next two steps, try opening them on a different computer before sending them out of office; we had a problem with the zipped file during the 2020-04-30 send. | ||
* the zipped [[MCHP Export.accdb]] and password protected | * the zipped [[MCHP Export.accdb]] and password protected | ||
| Line 57: | Line 63: | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category: MCHP]] | [[Category:MCHP]] | ||