Instructions for importing a batch of DSM Data: Difference between revisions
Ttenbergen (talk | contribs) |
|||
| Line 38: | Line 38: | ||
=== Run consistency checks === | === Run consistency checks === | ||
* [[query Import_request_matcher]] | * [[query Import_request_matcher]] | ||
* | ===Get the Number of D_ID with no match lab DSM=== | ||
* Follow the steps below. | |||
** Open [[DSM_Labs_Consistency_check.accdb]] | ** Open [[DSM_Labs_Consistency_check.accdb]] | ||
** Open [[query Import_request_matcher]] | ** Open [[query Import_request_matcher]] | ||
| Line 47: | Line 48: | ||
** Go to X CCMDB DSM Lab imports Archive_raw then to the folder you want to save | ** Go to X CCMDB DSM Lab imports Archive_raw then to the folder you want to save | ||
** Click Export data with formatting and layout then rename Ex. (No_Match_DSM_450.xlsx) then save. | ** Click Export data with formatting and layout then rename Ex. (No_Match_DSM_450.xlsx) then save. | ||
=== Cleanup === | === Cleanup === | ||