CCMDB Wiki

DSM Labs Consistency check.accdb: Difference between revisions

← Older editNewer edit →
m Ttenbergen moved page DSM Labs Importer.mdb to DSM Labs Consistency check.accdb without leaving a redirect: no longer called what it was
mNo edit summary
Line 2: Line 2:


The program  
The program  
::([[DSM_Lab_Extract#File_Share]])\DSM Labs Importer.mdb
::([[DSM_Lab_Extract#File_Share]])\DSM Labs Consistency check.accdb
Imports Lab data as provided by DSM
generates request extracts and imports lab data as provided by DSM


== Instructions for requesting a file ==
== Requesting/importing ==
* Copy file to a local directory
* [[Instructions for requesting a batch of data from DSM]]
* Put [[Centralized_data.mdb]] into same directory
* [[Instructions for importing a batch of DSM Data]]
* Right-click on query ''w'' and choose export
* put the file into file exchange location (see [[DSM_Lab_Extract#File_Share]])
* contact our DSM Contact (see [[DSM_Lab_Extract#Contacts]])
 
== Instructions for importing a file ==
* Put the following to a local directory
** [[Centralized_data.mdb]]
** [[DSM_Labs_Consistency_check.accdb]]
** [[PHI.mdb]]
** [[CCMDB.mdb]]
* open DSM_Labs_Consistency_check.accdb
* click the "Import DSM .csv" button and follow instructions
* ('''once out of testing''') Move [[Centralized_data.mdb]] back to master directory


[[Category:DSM Labs Extract]]
[[Category:DSM Labs Extract]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=DSM_Labs_Consistency_check.accdb"