Hello, I am having a problem defining boundries on this text file. Since the line quantity varies per datapage, I am getting out of bounds errors when I toggle my records.
Here is a link to the data:
You’ve got form feeds before each page, so by default when you create a new data mapping config, it will create 1 record per page. But I assume you want to have a single record for all the pages that form a single Invoice.
In that case, you define your Page Delimiter Type to be On text and you select the region that contains the string “Page 1” on the upper hand corner of the first page (row 2, columns 125-131). That instructs the DataMapper to start a new record when it encounters that exact string in that exact spot. Then you specify that the start of the record should actually occur 1 line before the text is encountered by selecting -1 in the Lines before/after parameter.
That should do it.
Have you tried cutting on FF and triggering on text change?
This seems to be giving me consistent results. One invoice per record.
Hi,
You could set the page delimiter to cut on FF instead of number of lines and set the Boundaries to trigger On text -> On changes of the cycle number which is unique for each record. I have attached the data mapper boundary settings for your reference.
https://learn.objectiflune.com/qa-blobs/208423976522719939.ol-datamapper