Running a Blackout Native Excel Job
A Blackout Native Excel Job is run just as an image based job would run. After creating the initial job you can kick off the process by clicking the Run button at the top of the page.
When a job is running there are several things taking place simultaneously. See below for more details on what is happening.
- Queued: The job will be queued until it is picked up by a Blackout Redaction Job Agent.
- Qualifying documents for redaction: Blackout will run the saved search, read through extracted text, and build a set of documents that match the search criteria.
- Redacting documents: Blackout will use the coordinates obtained by OCR to create markups using the Word/Phrase or Regex Rules established on the Create Job page.
- Complete: When all markups have been applied, the job is complete.
If you are familiar with Imaged based jobs you will notice that a Native Excel Blackout job does not include the OCR process that takes the brunt of the time a standard job does. Blackout native excel works with just the extracted text on the document, typically resulting in much faster jobs!
After the job completes, a page is displayed providing information about the job run.
- Job run length: The total run time for the most recent job run.
- Redactions per hour: The number of redactions places on documents every hour. This number is currently based on the total redactions placed across all runs while the time is based on just this run. (This will be changed in a future release.)
- Pages per hour: The number of pages that go through the entire process of qualification to redaction. This number is currently based on the total pages processed across all runs while the time is based on just this run. (This will be changed in a future release.)
- Redactions placed: The number of redactions placed by the most recent run. Clicking on this link will take you to a saved search of all documents with redactions placed by Blackout.
Additionally, in the Advanced Stats tab, Blackout provides advanced statistics about the job.
- Documents Processed: The number of documents that went through the qualification process.
- Pages Redacted: The number of unique pages with redactions placed on them.
- Missing Redactions: The total count of redactions that were expected to be placed. Clicking the View Missing Redactions link will take you to a full list of missing redactions along with the term that was missed, the text that was expected and the approximate location that was checked.
Formulas and Merged Cells
When a Blackout job runs it will automatically flatten the excel file to ensure that formulas are not modified by redacted content in the excel. After this step Blackout will then unmerge any merged cells. By performing both of these actions we ensure that there is no data lost after the content is removed from the worksheet. These two actions ensure that Blackout runs smoothly and guarantees the integrity of the data in the workbook.
To delete all redactions or highlights applied during previous runs of a Blackout job, click the Delete Markups button in the Blackout Job console. You can then edit and re-run Blackout jobs as needed.
Note: All markups previously created by the current Blackout Job will be deleted including markups that have been manually edited or accepted.
Revert Markups on a Single Excel Document
After you run a Blackout job, if during the QC process you notice that Blackout redacted more than you had expected you are able to revert the entire document back to its original state.
While on the document in question on the upper right toolbar click on the Revert document to return the document to the original state.
Note: This will remove all markups on the document, including any other sheets that may be part of the file.
For more information on using the Relativity document viewer to manually modify single excel documents refer to the Using Blackout to manually redact Excel in Relativity Document viewer [LINK]section of the user guide