Instructions for importing a batch of DSM Data: Difference between revisions
Ttenbergen (talk | contribs) m →Cleanup |
Ttenbergen (talk | contribs) |
||
| Line 25: | Line 25: | ||
# wait for the check to complete, about half an hour | # wait for the check to complete, about half an hour | ||
# if the program tells you there are new labs, review them and ask Trish or Allan if any of them should be considered as part of our counts | # if the program tells you there are new labs, review them and ask Trish or Allan if any of them should be considered as part of our counts | ||
#* open the following | #* open the following queries ('''they are based on labs imported within the last hour''') | ||
#** | #** s_group_ListNewlyAdded | ||
#** | #** s_mapping_lab_ListNewlyAdded | ||
#* If Trish or Allan says any of them need to be added talk to Tina, we can document that process when it next happens. It involves editing table s_mapping_labs or s_group to accommodate the new data. | #* If Trish or Allan says any of them need to be added talk to Tina, we can document that process when it next happens. It involves editing table s_mapping_labs or s_group to accommodate the new data. | ||
#** Essentially it's a matter of mapping the right entry in the column that matches the reference tables to the records we want to count. If you look at it it will be pretty intuitive. | |||
=== actual data import === | === actual data import === | ||