Extract Data from Multiple forms

Help Studio
, ,
1

So I followed the documentation on extracting data from forms with Extracting data from forms

I can’t upload .xaml because it has API keys on it and other confidential information but this process works when I direct the file path to 1 specific file.

How do I have this loop through thousands of forms? I have approximately 11k forms I need to run this process on and export to excel.

2

@atarantino

Use a for each file in folder and use this inside that

Cheers

3

so that works to loop through but the results don’t save. they override one another and the only results that I see is the data from the last PDF it processes.

4

@atarantino

Use merge datatable…Then you can merge the data and write all at once

Or write the data to multiple sheets by changing sheetname to filename or so

cheers

5

can you help explain how to use merge datatable from a dataset?

6

@atarantino

requiredtable = dataSet.Tables[0]

This will give you dattable

MergedDT = requiredtable.Clone()

Do the clone in a if condition or only once…else the data would be lost

Now use a merge datatable with requiredtable as source and MergedDT as destination

Hope this helps

cheers

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.