Job Options - separate by record.tables.field

OL Connect Enterprise General
1

Hi:

Is it possible to separate by a variable found in record.tables.field please?

If yes, how do I do this?

Thank you,

CC

2

Hi Cecile,

Do you mean separate your output PDF based on a detail table field? Where in “Job Options” are you referring to? A little more info of what you are trying to achieve is needed for me to help.

Regards,

S

3

Hi Sharne,

Sorry…

So, basically, we render these postcards as a standard PDF output right now using XML data.

The address portion of the data has been sent as

EN
POSTCARD_CCD

NAME OF PERSON
ADDRESS1    
THREE HILLS AB  T0M 2A0

The xml add for the address can only be extracted as a table (i.e. records.address).

At the present moment, we are able to create two PDFs with the Job Option separating by PrintLanguage and TemplateName. This renders an English PDF file and a French PDF file.

However, now we need to separate by Canada, US, and Foreign. So, when we are creating the Job Option to separate by Address info, we are not able to access that data because it is within a table.

Is there a way to do this?

Note: We have created a variable to test whether Province is true or false (ON, AB, MB, etc == CANADA.), and we have been able to see that it works. We are able to access the record.tables to get the true or false answer. When we try to do the same within the job option, it does not allow us to do this as the record.address is not listed in the Document Set category. How can we get around this?

Thank you so much for your help.

Cecile

4

Hi Cecile,

Had a hectic week, sorry for not replying. Without seeing your data I am only speculating here. Also I don’t work with XML much except when I wrote that script for you. In my experience I am able to use a condition in the data mappers steps to extract a value within a detail table. Doing that you would surely be able to use this new field to do the separation.

If you could send me the exact data that you are using, minus any personal info, I would be able to take a look.

However, looking at the line in the XML sample you provided it looks to me that you would need to split that line (THREE HILLS AB T0M 2A0) and loop through it to get the AB value you need in order to see that it is indeed a Canada address. Just not sure how the condition steps work with XML.

I’m also assuming that you are referring to the Job Creation - Use Grouping options in the Print Presets?

Regards,

S