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.