Main Page: Difference between revisions

From Grooper Wiki
No edit summary
No edit summary
Line 19: Line 19:
|-style="background-color:#d8f3f1" valign="top"
|-style="background-color:#d8f3f1" valign="top"
|
|
[[file:data-rule-icon.png|right]]
<blockquote style="font-size:14pt">
<blockquote style="font-size:14pt">
''[[Data Rule]]''
''[[Delimited Extract]]''
</blockquote>
</blockquote>


The '''Data Rule''' object allows for complex validation and manipulation of a '''Data Model's''' '''Data Elements''' ('''Data Fields''', '''Data Sections''', and '''Data Tables''') in Grooper.
''Delimited Extract'' is one of the '''''Extract Method''''' options for '''Data Table''' objects in a '''Data Model'''. This method extracts tabular data from a delimiter-separated text file, such as a CSV file.
 
This allows users to create a conditional hierarchy of actions to take if certain conditions met.  These conditions are configured using .NET, LINQ and/or lambda expressions.  When the expression is "triggered", either evaluating to "true" or "false", certain actions can be made. These include:


* ''Calculate Value'' - This action sets the value of a '''Data Field''' or cells a '''Data Column''', using calculate expressions to perform mathematical or concatenation operations of '''Data Elements'''.
This is the fastest, simplest and most effective method of extracting data from character delimited files, such as comma delimited CSV files or TXT files delimited by commas or other characters.
* ''Clear Item'' - This action clears the value of a '''Data Element'''.
* ''Append'' - This action can add the value of a '''Data Element''' to a another, allowing you to add entries to a table, multi-instance section or multi-cardinality field.
* ''Copy'' - This action copies or moves the value of a '''Data Element'''.
* ''Parse Value'' - This action uses a regular expression pattern to return part of a '''Data Field's''' value or cell in a '''Data Column's''' value.
* ''Raise Issue'' - This action adds an issue to the issue log, used for validating a '''Data Element'''.  This action can also be used to flag the '''Data Element'''.


These trigger conditions and subsequent actions set on the '''Data Rules''' objects are executed through the '''Apply Rules''' activity after data is extracted from an '''Extract''' activityOptionally, '''Data Model''', '''Data Section''', and/or '''Data Table''' elements may be configured to execute a '''Data Rule''' during a user attended review activity (i.e. '''Data Review'''), by setting the object's '''''Validate Rule'''''.
{|cellpadding="10" cellspacing="5"
|-style="background-color:#36b0a7; color:white"
|style="font-size:14pt"|'''FYI'''
|
''Delimited Extract'' is new to version '''2021'''.  In older versions, this functionality was achieved with the ''CSV Extract'' table extraction method.  ''Delimited Extract'' expands the ''CSV Extract'' functionality to extract tabular data from TXT files using delimiter characters besides a comma, such as semicolons or pipe characters.
|}
|
|
The earliest examples of OCR (Optical Character Recognition) can be traced back to the  1870s.  Early OCR devices were actually invented to aid the blind.  This included "text-to-speech" devices that would scan black print and produce sounds a blind person could interpret, as well as "text-to-tactile" machines which would convert luminous sensations into tactile sensations.  Machines such as these would allow a blind person to read printed text not yet converted to Braille.
The earliest examples of OCR (Optical Character Recognition) can be traced back to the  1870s.  Early OCR devices were actually invented to aid the blind.  This included "text-to-speech" devices that would scan black print and produce sounds a blind person could interpret, as well as "text-to-tactile" machines which would convert luminous sensations into tactile sensations.  Machines such as these would allow a blind person to read printed text not yet converted to Braille.

Revision as of 08:19, 9 June 2021

Getting Started

Grooper was built from the ground up by BIS, a company with 35 years of continuous experience developing and delivering new technology. Grooper is an intelligent document processing and digital data integration solution that empowers organizations to extract meaningful information from paper/electronic documents and other forms of unstructured data.

The platform combines patented and sophisticated image processing, capture technology, machine learning, natural language processing, and optical character recognition to enrich and embed human comprehension into data. By tackling tough challenges that other systems cannot resolve, Grooper has become the foundation for many industry-first solutions in healthcare, financial services, oil and gas, education, and government.

Getting Started
Install and Setup
2.90 Reference Documentation
Featured Articles Did you know?

Delimited Extract

Delimited Extract is one of the Extract Method options for Data Table objects in a Data Model. This method extracts tabular data from a delimiter-separated text file, such as a CSV file.

This is the fastest, simplest and most effective method of extracting data from character delimited files, such as comma delimited CSV files or TXT files delimited by commas or other characters.

FYI

Delimited Extract is new to version 2021. In older versions, this functionality was achieved with the CSV Extract table extraction method. Delimited Extract expands the CSV Extract functionality to extract tabular data from TXT files using delimiter characters besides a comma, such as semicolons or pipe characters.

The earliest examples of OCR (Optical Character Recognition) can be traced back to the 1870s. Early OCR devices were actually invented to aid the blind. This included "text-to-speech" devices that would scan black print and produce sounds a blind person could interpret, as well as "text-to-tactile" machines which would convert luminous sensations into tactile sensations. Machines such as these would allow a blind person to read printed text not yet converted to Braille.

The first business to install an OCR reader was the magazine Reader's Digest in 1954. The company used it to convert typewritten sales reports into machine readable punch cards.

It would not be until 1974 that OCR starts to form as we imagine it now with Ray Kurzweil's development of the first "omni-font" OCR software, capable of reading text of virtually any font.


New in 2.9 Featured Use Case

Welcome to Grooper 2.9!
Below you will find helpful links to all the articles about the new/changed functionality in this version of Grooper.

Compile Stats Microsoft Office Integration Document Viewer Separation and Separation Review
Data Review Confidence Multiplier Data Element Overrides Database Export
CMIS Lookup Content Type Filter Output Extractor Key Box (CMIS Binding)
LINQ to Grooper Objects

They’re Saving Over 5,000 Hours Every Year in Data Discovery and Processing


American Airlines Credit Union has transformed their data workflows, quickly saving thousands of hours in electronic data discovery , resulting in much greater efficiency and improved member services.

Discover how they:

  • Quickly found 40,000 specific files among one billion
  • Easily integrated with data silos and content management systems when no other solution would
  • Have cut their mortgage processing time in half (and they process mortgages for 47 branch offices!)
  • Learn from the document and electronic data discovery experts at BIS!

You can access the full case study clicking this link.

Feedback

Feedback

We value your feedback!

Help us improve our product by leaving us a review on Gartner.com.

Click the image to the left to submit a review.


Other Resources