Versions Compared

Key

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

...

Code Block
languagenone
Create Datatable $InvoiceData
Add Datatable Columns "Document Type","Company Name","Invoice Number","PO Number","Total Amount","Tax Amount","Freight Amount","Account Name","Company Address","Invoice Date","Order Date","Delivery Date","Account Number","GST Number","Customer ID"
//The folder below is also located in your My Documents\Documents\Digital Workforce\Aura Digital Worker\Assets\
//You could remove the C:\ if you want to use the example data from the Aura installer
$folder = "C:\Mixed Invoices"
foreach ($pdf in $folder)
{
//By default, Aura will attempt to auto -detect.
//The -invoice parameter is optional
//If -invoice is used, Aura will use Microsoft Form Recognizer to pull additional data from PDFs
//Below is without the -invoice and will auto -detect file context, but may retrieve less data
//Extract from $pdf
Extract from $pdf -invoice

//Use a Pause command below to view the variable values extracted
//WeYou can remove the pause once weyou gothave all of the variablevariables weyou need for completing the below
//Pause
//Click the Resume button to continue
//You can remove the Pause to try this again without stopping
//WeYou want to now add the values extracted to the datatable
switch to $InvoiceData

//Next we, use 'If' command to check if the invoice is from Acme
if ($_CompanyName contains "Acme")
{
//If it is an Acme invoice, we add the relevant details from that invoice
//into the datatable
Add Datatable Row $_Classification_Name,$_CompanyName,$_InvoiceNumber,$_PurchaseOrder,$_Total,$_Tax,$_Shipping,"NA","NA",$_InvoiceDate,$_OrderDate,$_DeliveryDate,"NA","NA",$_CustomerNumber
}
if ($_CompanyName contains "Brawn Manufacture")
{
Add Datatable Row $_Classification_Name,$_CompanyName,$_InvoiceNumber,"NA",$_Total,$_Tax,"NA","NA","NA",$_InvoiceDate,"NA","NA","NA","NA","NA"
}
}

//Below, weyou can add the datatable result after all rows are added
Add Result $InvoiceData
//Below, weyou can send the results to Aura Desktop
//Look for "Open Results" button once it is complete
Send Results to Desktop

...

View file
nameMixed Invoices.zip
View file
nameBrawn Manufacturer Invoice4.pdf
View file
nameBrawn Manufacturer Invoice3.pdf
View file
nameBrawn Manufacturer Invoice2.pdf
View file
nameBrawn Manufacturer Invoice1.pdf
View file
nameAcmeSuppliesInvoice3.pdf
View file
nameAcmeSuppliesInvoice2.pdf
View file
nameAcmeSuppliesInvoice1.pdf
View file
nameAcmeSuppliesInvoice.pdf

Include Page
Snippet - How-to Foot - Aria
Snippet - How-to Foot - Aria
Multiexcerpt fast include block macro
nameRelated Articles
templateData[]
pageHow to Article - Include Page Stuff
addpanelfalse
Filter by label (Content by label)
showLabelsfalse
showSpacefalse
cqllabel in ( "kb-how-to-article-aria" , "kb-tech-aria" , "value" , "log" , "message" , "write" , "web" , "input" , "enter" ) and label in ( "kb-command-reference-aria" , "kb-how-to-article-aria" , "kb-tech-aria" , "aria" )

...

Include Page
Snippet - Footer - Tech
Snippet - Footer - Tech