Milyli Support

Milyli Support

  • User Guides
  • Resources
  • Videos
  • Schedule Training

›Resources

Home

  • Getting Started

Certification

  • BCE - FAQ

Regular Expressions

  • General PII
  • Financial Accounts
  • Government Ids

Resources

  • CSV Import Templates
  • dtSearch Syntax Characters

Importing Rules via CSV

When creating a Blackout project, sometimes there are more terms than could be manually entered as word/phrase rules. With Blackout Import Templates, up to 100,000 rules can be uploaded to a Blackout project.

Image-based projects, native Excel projects, and PDF projects will use the same import template, with slight variations. The tables below will describe how the import template should be populated if using the plain CSV template along with a links to download the import template with pre-populated dropdowns and the unpopulated CSV file.

What to know

  • Each file is a macro-enabled Excel. The Excel file includes dropdowns for the following sections that have a limited number of values that can be entered:
    • Markup Type
    • Markup Subtype
    • Markup Scope
  • Before the template can be used it must be saved as a CSV file.
  • A CSV file without the dropdowns is also available for download.

Note: If using the macro-enabled Excel file, the Markup Subtype section will change based on the selected Markup Type.

How to use CSV Import Templates

  1. Download the desired import template
  2. Fill in the desired information within the template.
  3. Within Excel, click the ‘File’ button and choose ‘Save As’
  4. Use the file type drop down and save as a CSV file
  5. A message will appear alerting you that multiple sheets cannot be saved. This is normal. Click ‘OK’.

After saving the template as a CSV, it can be used with Blackout.

Image Based Template

ColumnDescriptionAccepted Values
Word/PhraseThe exact word or phrase being searched
(does not support dtSearch or wildcard syntax)
Any text/phrase inputs that are valid in Blackout
Regular Expression NameSets the name of the regular expression after the job has been run to be easily selected laterAny text that can be used to identify the RegEx later
RegExEnter the Regular Expression for the rule here
Markup TypeSets the Markup Type of the ruleRedaction or Highlight
Markup SubtypeSets the Markup SubType for a ruleRedaction Markup Type: Black, Text, Cross, White, Inverse

Highlight Markup Type: Yellow, Green, Blue, Orange, Pink, Purple
Markup TextApplies the entered text to a text based redactionAny text that can be used to identify the redaction
Markup ScopeSets the Markup Scope for a ruleWord, Line, Paragraph, Block, Page, Document
Markup ReasonSets the Markup Reason for a ruleAny text that will allow you to identify the markup reason
dtSearchEnter a dtSearch syntax for the rule here

Download the image rule template with dropdowns
Download the image template CSV

Excel Based Template

ColumnDescriptionAccepted Values
Word/PhraseThe exact word or phrase being searched
(does not support dtSearch or wildcard syntax)
Any text/phrase inputs that are valid in Blackout
Regular Expression NameSets the name of the regular expression after the job has been run to be easily selected laterAny text that can be used to identify the RegEx later
RegExEnter the Regular Expression for the rule here
Markup TypeSets the Markup Type of the ruleRedaction, Highlight, Inverse, or InverseHighlight
Markup SubtypeSets the Markup SubType for a ruleRedaction Markup Type: Black, Text, White

Highlight Markup Type: Yellow, Green, Blue, Orange, Pink, Purple
Markup TextApplies the entered text to a text based redactionAny text that can be used to identify the redaction
Markup ScopeSets the Markup Scope for a ruleCell, Word, Row, Column, Sheet
Markup ReasonSets the Markup Reason for a ruleAny text that will allow you to identify the markup reason
dtSearchEnter a dtSearch syntax for the rule here

Download the Excel rule template with dropdowns
Download the Excel rule template CSV

PDF Based Template

ColumnDescriptionAccepted Values
Word/PhraseThe exact word or phrase being searched
(does not support dtSearch or wildcard syntax)
Any text/phrase inputs that are valid in Blackout
Regular Expression NameSets the name of the regular expression after the job has been run to be easily selected laterAny text that can be used to identify the RegEx at a later time
RegExEnter the Regular Expression for the rule here
Markup TypeSets the Markup Type of the ruleRedaction, Highlight
Markup SubtypeSets the Markup SubType for a ruleRedaction Markup Type: Black, Text, White

Highlight Markup Type: Yellow, Green, Blue, Orange, Pink, Purple
Markup TextApplies the entered text to a text based redactionAny text that can be used to identify the redaction
Markup ScopeSets the Markup Scope for a ruleCharacter, Word, Line
Markup ReasonSets the Markup Reason for a ruleAny text that will allow you to identify the markup reason
dtSearchEnter a dtSearch syntax for the rule here

Download the PDF rule template with dropdowns
Download the PDF rule template CSV

← Government IdsdtSearch Syntax Characters →
  • What to know
  • How to use CSV Import Templates
  • Image Based Template
  • Excel Based Template
  • PDF Based Template
Milyli Support
Learn
User guidesResourcesVideos
Explore
About MilyliCase Studies
Connect
TwitterLinkedInCareers
Copyright © 2023 Milyli, Inc