FlexiLayout: having two tables in Blocks and exporting them

  • 175 Views
  • Last Post 29 January 2018
smoothwood posted this 29 December 2017

Hello there,   I have an issue when having two tables in Blocks and exporting them   Background: I extract two tables from the document,  so I create two table Blocks, when exporting these two tables to excel, the data in first table is correct, but the data in second table duplicated.    Symptom: the number of data rows in first table is 18 and the exported excel contains 18 data rows which is correct,. The number of data rows in second table is 3, so the EXPECTED number of data rows in second exported excel should be 3,  but the actual number of data rows in second exported excel was 3*18 = 54, 3 expected data rows repetitively exported for 18 times. it seems each time when exporting one row for first table, 3 rows of second table exported that's why we have 3 * 18 = 54 rows in second excel. I tried to switch the two table Blocks order in FlexiLayout, the result is similar, the first excel contains 3 rows which is correct, and the second excel contains 18 * 3 = 54 row.   Could you please advise what's causing it and how to solve this issue?

Order By: Standard | Newest | Votes
Ekaterina posted this 09 January 2018

Hello,

Could you please give us additional information what product do you using (FC10/FC11/FC12)?

smoothwood posted this 09 January 2018

it's FC11

Thanks

Ekaterina posted this 10 January 2018

Hello,

We cannot reproduce the issue on our side, so could you please send us your project, sample images and the screenshot that shows your layout structure.

smoothwood posted this 16 January 2018

Hello Ekaterina,

Attached the pdf, please advise how I can send the project to you as zip file is not supported

Thanks 

Attached Files

Ekaterina posted this 17 January 2018

Hello,

We offer  you to upload the project  archived with password-protection on any file storage by your choice, and then send us the link and the password by private message on this forum.

Otherwise you may contact your regional support and get private channel for transferring your project.

smoothwood posted this 17 January 2018

Hello, 

please download the whole project from here:

https://goo.gl/QkQjmq

pdf included in "document" folder 

spreadsheets which includes extracted data are in "parsed" folder, if you go to that folder, you will see the issue I am talking about. 

FlexiCapture project file is in ./TableDemo/TableDemo/New Project folder 

Thanks!

 

Ekaterina posted this 22 January 2018

Hello,

Before we address this issue to the HQ support, could you please describe us how you expect these tables to look like in the resulting .xls file? 

In any case you may use the script export to put the information from your tables in the resulting file as you wish.

Using scripts in ABBYY FlexiCapture > Scripts for customizing processing stages > Types of scripts > Export script

smoothwood posted this 23 January 2018

There are two tables to be exported, I hope they are in two different Excel files.

Attached the expected results in Excel, please find here - https://goo.gl/ac641A

Thank!

Ekaterina posted this 26 January 2018

Hello,

Please use custom script export for this purpose. (Using scripts in ABBYY FlexiCapture > Scripts for customizing processing stages > Types of scripts > Export script Developer Help)

smoothwood posted this 27 January 2018

Hello Ekaterina,

Thanks very much for your reply, I still have two questions:

1. The issue I described above is identified as an FlexiCapture issue? It will be fixed in the next release?

2. For my case here, I think I can use custom script to export data if standard export can't meet my needs, but could you please share with me some examples regarding exporting tables by using custom scripts as I didn't find useful examples

Thanks!

Ekaterina posted this 29 January 2018

Hello,

This case currently under investigation in the ABBYY HQ 2nd line.

Using scripts in ABBYY FlexiCapture > Scripts for customizing processing stages > Sample scripts > Sample scripts describing export

Close