|
|
| Line 51: |
Line 51: |
|
| |
|
| == Set record as vetted == | | == Set record as vetted == |
| At this point all records with problems will have had the [[Record Status field]] set to "questioned" so the remaining ones that are set to "sent" are clean and can be set to "vetted". Press the "vet all sent" button. This will change all records currently set to "sent" to "vetted". | | At this point all records with problems will have had the [[Record Status field]] set to "questioned" so the remaining ones that are set to "sent" are clean and can be set to "vetted". |
|
| |
|
| | | # Press the "vet all sent" button. |
| When all data is cleaned, the last query is ''NDC_unvetted''
| | # The program will display a count of how many records have each of the recorstatatus possibilities. |
| * does that query actually do anything for us? Ttenbergen 23:07, 2014 September 29 (CDT)
| | #* take note of the "sent" number and click OK |
| | | # The program will tell how many records it is about to update. 'you are about to update ___ rows' |
| On the 'RecStatus' column
| | #* If this number is the same as the number of sent records, click OK, if not click cancel and try to figure out what is wrong. |
| | | # This will change all records currently set to "sent" to "vetted". |
| Right click the first one
| |
| | |
| Sort by Z to A which will sort by Sent, Questioned, Incomplete statuses
| |
| | |
| Scroll down to the last 'sent' record, to see how many records will be vetted
| |
| * should that query just change to have only "sent"s? Ttenbergen 23:07, 2014 September 29 (CDT) | |
| | |
| Then click the ''Vet All Sent'' button
| |
| | |
| Prompts 'are you sure'
| |
| | |
| answer Yes
| |
| | |
| prompts 'you are about to run ...'
| |
| | |
| answer Yes
| |
| | |
| prompts 'you are about to update ___ rows'
| |
| | |
| answer Yes
| |
| | |
| The number in the ''___ rows'', should be the same as the last 'sent' record from your scroll down
| |
| | |
| e.g. if your last 'sent' record was 25, then the prompt will say 'you are about to update 25 rows'
| |
| * has the number ever been anything different? Ttenbergen 23:07, 2014 September 29 (CDT)
| |
| ** yes it has [[User:PTorres|PTorres]] 10:55, 2014 October 1 (CDT)
| |
| | |
| * Tina will replace this process with a tally msgox that comes up when "vet all" is pressed, ok, how many will be updated, ok, [[User:PTorres|PTorres]] 10:55, 2014 October 1 (CDT)
| |
| * NDC unvetted can then be deleted[[User:PTorres|PTorres]] 10:55, 2014 October 1 (CDT)
| |
| {{discussion}}
| |
|
| |
|
| == Push up data == | | == Push up data == |