What was the process to print all the field values from extracted json?

Help Document Understanding
,
1

@alexcabuz This feature is so amazing!!! Already Started working today in this .
Will you guys help me on how can i get an individual values like all the fields from the dataset output (Say output Dataset : ds)
I am trying with for each activity and trying to print , but it was not expected filed results some random text i got …

Help me guys, what was the process to print all the field values from extracted json.

Regards,
Sriram

2

Hello @Sriram07 - please try to use the Export Extraction Results activity - this will generate a DataSet with all the values.

You can then do a ForEach table in dataSet.Tables (as DataTable)
do

  • excel application scope with an excel file name, then
  • write range (tab name: table.Name) values in table.

You should be able to see all the content of the exported data in the excel sheet afterwards.

1 Like
3

Any chance you can elaborate on this a little more. I’m not seeing a lot of information about getting the dataSet parsed and into excel in the documentation and I have been unable to figure it out.

I took the demo invoice reader file, added an “export extraction results” activity to convert the extractionResults to a DataSet. After that, I am not certain how to get the fields extracted into excel or any format other than the .json that the demo has set up.

Any help is appreciated. Thanks!

Invoices_example.xaml (22.5 KB)

4

Hello @wbader,

This is how my workflow looks like:

image
image551×545 10.2 KB

So what happens here is:

  1. I use Export Extraction Results and set the output to a variable called “validatedDS” (DataSet)
  2. I do a For Each dt in validatedDS.Tables, and I set the type argument to System.Data.DataTable
  3. inside the For Each loop, I do a Write Range to a file of my choice (I am using the name of the document being processed, in my case stored in the “item” string variable), and i write a tab with the name dt.TableName, and in that tab I write the entire dt DataTable.
    To make sure you can view the field names as well, please check the AddHeaders option of the Write Range activity.

NB: I am using the Excel package 2.6.2.

Hope this helps,

Ioana

1 Like
5

I am not clear in “dt.TableName” ?
TableName?

And also When i am executing as same as your workflow after export extraction results , But i am not getting expected results its only giving the last 6 fields only i don’t know why .
Will you tell me ? why?

6

@Sriram07
if confidentiality is not an issue, please send me the full workflow with one file that the issue reproduces on - I would like to have a look and see what is not working.
THanks!

7

This is fantastic. Thank you so much. I would not have figured this out on my own.

8

@Ioana_Gligan will you help me on this ?
What is that tablename ? is this a member of datatable ? or what ?

9

Yes, table name is a member of the DataTable.

10

please allow to rotate the invoice while in the validation station, otherwise will be tedious for the personnel to validate the document in the horizontal mode

1 Like
11

It’s a work in progress already @saibuntoe :slight_smile: Thanks for the feedback!

12

We have page rotation now, forgot to follow up :smiley: