|
Confirm Upload Results |
  
|
|
Confirm Upload Results |
|
All 'Time Saver' Excel uploads process on a EnergySteward.com backend server. Each of these uploads will post critical runtime information about the upload in the common audit area within EnergySteward.com . Within minutes, after uploading an Excel file, you can run the audit report to list the results of the batch upload. Any errors encountered during the upload will be displayed on this report, and row level failures are reported. Successful updates will list in the run statistics. The steps to running this audit report include:
| 1. | Find the audit event report |
| 2. | Submit the audit event report with appropriate parameters |
| 3. | Browse results of the audit report |
| 4. | Potentially correct and re-upload errant data rows |
1. Find the audit event report..... - The audit report is typically found in the 'Administration | Adhoc Administration Reports...' area. However, this report can be posted to any/all other menus within EnergySteward.com based on your system administrators discretion.
2. Submit the audit event report with appropriate parameters... You should run the audit report for the upload events that occured within the timeframe which you originally uploaded the Excel file. For example; if you uploaded the excel file at approximately 1:10 PM (CST) then you can set the from and thru dates to 1:00 PM (1300 military) thru 2:00 PM (1400 military). In that way, you will only be getting those events applicable. Important note: The audit logs also lists out the original file name uploaded, so you can confirm you are looking at the log consistent with the spreadsheet you uploaded.
Below is a sample screen shot on entering these parameters.
3. Browse results of the audit report... Once the report has completed running, it can be browsed to see the results of the upload. Below is a screen shot of what this audit report will typically look like:
4. Potentially correct and re-upload errant data rows... With the audit report and your original spreadsheet you should have what you need to create/update a spreadsheet which will re-upload the errant rows (with corrections of course).