...
This example will extract content from a folder with 1099 1040 tax formsreturns. 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 iswill differentextract fromall 'Extract From', as it only extracts fillable form field data
//and is faster
Extract FieldsPDF 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
|
Aura has features which will auto detect PDF data, including checkboxes, radio buttons, fillable form fields, text, textbox values, radio button controls etc…
...
Image Added
...