Check what you learned: Data Management

Eight questions. Pick the best answer for each, then click Check my answers at the bottom. Nothing is saved; you can take it as many times as you like.

1. The lab emailed you a spreadsheet of test results. Where do you start?

Data Management, then Import CenterData Management, then Export CenterType each result in by hand

2. You do not have a file yet and want to know what columns to use. What do you do?

Click the Templates tab and download a blank templateGuess the columnsCall the lab

3. The meter company sends a file every month with its own column names. What saves you time?

Save a column mapping once under Templates & MappingRename the columns by hand every monthAsk them to change their file

4. An import finished but 12 rows failed. Where are they?

Error Handling, with the reason on each rowGone for goodIn the Recycle Bin

5. You deleted a customer yesterday and need it back. Where do you look first?

Data Management, then Recycle BinCustomer Management, then SearchCall Utilops

6. How long does a deleted record wait in the Recycle Bin?

30 days24 hoursForever

7. An import put 400 bad readings in. What is the fastest way to take all of them out?

Change History, find a row from the import, click Undo OperationDelete each reading by handImport the file again

8. Someone changed a record last week and it was wrong. The green message is long gone. Where do you go?

Data Management, then Change HistoryRecycle BinExport Center