Extract data from an image and create an excel sheet with the extracted data

hi @AhmedMetwally ,

You can use the Document Automation for this. You can create a new Learning instance and add all required Fields to be extracted under that. Later, upload the file and start extracting it. Depending on the extraction accuracy, you may need to re-upload the file couple of time in order for a successful extraction. 

The extracted data will be saved as a CSV file. Hope this will help. 

 

Yes, it is very helpful! Thank you. “The Task is in the queue and will soon be processed.” Any idea how to solve this issue? 

Where you are getting this message?

Did you ever figure out this issue? (“The Task is in the queue and will soon be processed”)  documents are stuck in queue and never get processed

Hi @edglydo ,

After documents are stuck in queue, you have to validate them manually.  

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/iq-bot/native/idp-validate-documents.html.

Please note that if the documents are trained or captured the all the required field value from documents which will processed directly.

Thanks @Tamil Arasu10  but in this case the 100% good, sample documents from AA, do not show up in the validation task either.  I am able to manually run the extract and download bots but the automated workflow/queue trigger does not work.  When run manually the docs, using the pre-built AA invoice model have data extracted without error.  Is there anyway to see this queue ? and/or logs for debugging?  Thanks

Use OCR action

Do string manipulation for input the data into Excel