Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

multiexcerpt-include-macro
name

...

Header
templateData[]
pageHow to article - Include Page stuff
addpanelfalse

Info

Use this page to find example workflows for Aura Digital Workforce.

...

Multiexcerpt fast include block macro
nameIntroduction
templateData[]
pageHow to article - Include Page stuff
addpanelfalse

Multiexcerpt fast include block macro
nameVideo
templateData[]
pageHow to article - Include Page stuff
addpanelfalse

Multiexcerpt fast include block macro
nameScript
templateData[]
pageHow to article - Include Page stuff
addpanelfalse

This example will extract content from a folder with 1040 tax returns. We will then export all data extracted from the fillable form fields to Excel.

Code Block
//Copy the files in resources section below and change the path below to where they are stored
$folder = "C:\1040"
//Create a datatable to store the results we are extracting from
Create Datatable $TaxForms
//Add the columns that we will use to store the data
Add Columns "First Name", "Last Name", "SSN", "Total Amount (1a)", "Other Income (1h)", "Source"
Foreach($pdf in $folder)
{
//This command below will extract all PDF information including from fillable fields
Extract From $pdf
//We will add a Pause here to let you view the extract field names
//You can view the values in the Variable Panel that is on the right of the Editor
Pause
//We can open a PDF to view the corresponding values to choose the correct form field variable Aura auto generated
//The form field names are taken from the internal names of each form field
//You can remove or comment out the Pause command above when ready to run again after inspecting the values
//Now we want to switch to use the datatable created above to store the values
Switch to $TaxForms
//We add rows with the corresponding data
Add Row $_TopmostSubform0Page10f1_020, $_TopmostSubform0Page10f1_030, $_TopmostSubform0Page10YourSocial0f1_040, $_TopmostSubform0Page10f1_280, $_TopmostSubform0Page10f1_350, $pdf
}
//Click the Open Results button below
Add Result $TaxForms
Send Results to Desktop
Multiexcerpt fast include block macro
nameAutomatic Detection
templateData[]
pageHow to article - Include Page stuff
addpanelfalse

Aura has features which will auto detect PDF data, including checkboxes, radio buttons, fillable form fields, text, textbox values, radio button controls etc…

...

Multiexcerpt fast include block macro
nameResources
templateData[]
pageHow to article - Include Page stuff
addpanelfalse

View file
name1040.zip
View file
namef1040(6).pdf
View file
namef1040(5).pdf
View file
namef1040(4).pdf
View file
namef1040(3).pdf
View file
namef1040(2).pdf
View file
namef1040(1).pdf
View file
namef1040.pdf

Multiexcerpt fast include block macro
nameRelated Articles
templateData[]
pageHow to article - Include Page stuff
addpanelfalse
Filter by label (Content by label)
showLabelsfalse
max10
showSpacefalse
cqllabel in ( "kb-how-to-article-aria" , "kb-tech-aria" , "value" , "input" , "get" , "text" , "message" , "box" ) and label in ( "kb-command-reference-aria" , "kb-how-to-article-aria" , "kb-tech-aria" )
Include Page
Snippet - How-to Foot - Aria
Snippet - How-to Foot - Aria
Include Page
Snippet - Footer - Tech
Snippet - Footer - Tech