A2019 PDF Form Fields Extraction | Automation Anywhere

 RPA | A2019 Form Fields Data Extraction| Automation Anywhere - Part-40

A2019 Form Fields Data Extraction  - In this blog we will explore about the another useful concept i.e. how to extract form fields data extraction. We will also cover the practical implementation to extract the form data extraction from the website.

So before we see how to extract form fields from pdf file using A2019 Automation Anywhere community edition let us first define the meaning of form fields.

Form Fields - Form Fields are various data fields that are available for use in our forms in a pdf file. The form fields can consists of various data formats such as text, checkbox, labels etc. and these are tied with either default fields or custom fields.

Attached is the sample look as to how the form field pdf file looks like.

Now we will see how to build the bot to extract form fields data from pdf file using A2019 Automation Anywhere community edition which is now called as Automation 360. The steps that we need to follow to extract form fields are as follows:-

• Drag and drop the PDF utils command. In the properties section browse for the file from the required folder location and store the output in the dictionary variable data type.
• Drag and drop the Open action of Excel basic package. In the properties section browse for the file from the required folder location, check the sheet contains header check box and select the read-write mode and finally pass in the session name.
• Then drag and drop the loop command and in the properties section select for each key in the dictionary and then select the dictionary variable which we have created in the previous step and assign the output to the variable which can be of "any" data type.
• Then drag and drop the set cell command to write the dictionary key value to the excel file which we opened. In the properties section pass in the session name and select specific cell radio button give the cell name in which we want to write the data and then pass in the value that needs to be written.
• Then using the Number increment action increment the counter variable to increase the value of the counter variable created by 1.
• Re-assign or reset the counter variable to 2 using the Number: Assign command or action.
• Then drag and drop the loop command and in the iterator field select for each value in the dictionary as the loop iterator. Pass the dictionary variable name and assign the output to the variable whose data type is "any".
• Then drag and drop the set cell command to write the dictionary value to the excel file which we opened. In the properties section pass in the session name and select specific cell radio button give the cell name in which we want to write the data and then pass in the value that needs to be written.
• Then using the Number increment action increment the counter variable to increase the value of the counter variable created by 1.
• In the end outside of both the loops drag and drop the Excel basic close action to close the excel file which was opened. In the properties section pass in the session name which was used to open the excel file and check the checkbox to save the changes when closing the file. This will save all the changes that has been made by the user in the excel file.

With that we have discussed the steps to read extract and write the data into the excel file from form fields in the pdf file. The code snippet for all the steps discussed is given below.

So as shown above in the picture this is how we can extract form fields from a PDF file using A2019 Automation Anywhere also known as Automation 360.

With that we have come to the end of our discussion of this blog where we discussed as to how we can extract the form fields from the pdf file and write the extracted field into excel file using A2019 Automation Anywhere.

If you have any queries then you can raise your queries in the comment section and I will be more than happy to answer all of your queries.

I request everyone to please provide your feedback as the feedback you provide matters the most to me.