Combining PDF Attachments with DDX, then send separat...

[techddx]

I have a dynamic number of pdf attachments as input from an adaptive form, and would like to merge all attached pdfs into a single pdf using DDX, then have it send separately with the Document of Record with the Send Email step. However I encountered an issue with the Send Email step with the following: 

Caused by: com.adobe.granite.workflow.WorkflowException: GetPropertyValue failed as value corresponding to VARIABLE:attachments for type class java.lang.Object is NULL

The DDX is as follows:

<DDX xmlns="http://ns.adobe.com/DDX/1.0/"> 
    <PDF result="Attachments.pdf"> 
         <PDF source="fileAttachment"/> 
    </PDF> 
</DDX>

Input map for invoke ddx:

The "attachment" path matches the output attachment folder of the adaptive form

Output map:

The output document is saved into the "attachments" document variable

Send Email step with Document of Record and attachments document:

 I am unsure why the value for attachments is NULL. Any help on this is appreciated, thank you!

EDIT - testing workflowuser's process:

The following is the dynamic table with file attachments. The ordering is PDFs 1,2,3,4, but the resultant PDF from the process gives ordering 2,3,4,1. 

[workflowuser]

here is the updated bundle

https://documentcloud.adobe.com/link/track?uri=urn:aaid:scds:US:a9005085-7f50-4876-af8a-49a25c81b69e

I also removed the system.out.println  statements and moved them to log.debug. If you want to see the logs you can enable debug logs for this bundle

[techddx]

This is perfect, thank you!

[techddx]

Hi workflowuser, I think i may have found a bug. When you use an xml schema as the adaptive form model, the repeating panel method to add attachments generates an empty ddx file. Using a single file attachment button still works however.

[workflowuser]

can you paste the Data.xml contents from your workflow payload path after the form is submitted.

[techddx]

Sorry, how do you access the Data.xml after form submission? Is it through the CRX?

[techddx]

<?xml version="1.0" encoding="UTF-8"?> <afData> <afUnboundData> <data/> </afUnboundData> <afBoundData> <formData xmlns:xfa="http://www.xfa.org/schema/xfa-data/1.0/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <processingInfo> <contractor/> <contractorEmail/> <contractAgency/> <contractAgencyEmail/> </processingInfo> <stdAgreementDetails> <scoID/> <agreementNumber/> <purchaseAuthNumber/> <startDate/> <endDate/> <maxAmount/> <exemption/> </stdAgreementDetails> <contractorInfo> <contractorName/> <printedName/> <contractorTitle/> <contractorBusinessAddr/> <city/> <state/> <zip/> </contractorInfo> <contractAgencyInfo> <contractAgencyName/> <printedName2/> <agencyNameTitle/> <contractAgencyAddress/> <contractCity/> <contractState/> <contractZip/> </contractAgencyInfo> <exhibitsTable> <Row1> <ExhibitA/> <TitleA/> <PageA/> </Row1> <Row2> <ExhibitB/> <TitleB/> <PageB/> </Row2> <Row3> <ExhibitC/> <TitleC/> <PageC/> </Row3> <Row4> <ExhibitD/> <TitleD/> <PageD/> </Row4> </exhibitsTable> </formData> </afBoundData> <afSubmissionInfo> <computedMetaInfo/> <stateOverrides/> <signers/> <afPath>/content/dam/formsanddocuments/assembleattachmentsoriginalwithschema</afPath> <afSubmissionTime>20200922121748</afSubmissionTime> </afSubmissionInfo> </afData>

[techddx]

and fyi, the attachments are all in the attachments folder in the payload

[workflowuser]

in the Data.xml, I do not see any fileattachment nodes. where are the attachments?

[techddx]

Hi workflowuser, is there a cap on the number of attachments? I am testing the bank statements repeating panel. When i attach 20 attachments, the ddx is no longer generated.

[workflowuser]

in your crx go to 

/var/fd/dashboard/payload/server0/<latest Date>/<mostrecentfolder>/

[techddx]

Thanks, i found the payload path. How do I retrieve the Data.xml contents?

[workflowuser]

just double click on the Data,xml file

[workflowuser]

your Data.xml should look something like this. It should have fileAttachment elements in it

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<afData>
<afUnboundData>
<data>
<tableItem11>Testing</tableItem11>
<telephonebill>
<fileAttachment>aa.png</fileAttachment>
</telephonebill>
<Row2>
<bankstatements>
<fileAttachment>adls.png</fileAttachment>
</bankstatements>
</Row2>
<idcard>
<fileAttachment>etrade.PNG</fileAttachment>
</idcard>
</data>
</afUnboundData>
<afBoundData>
<data xmlns:xfa="http://www.xfa.org/schema/xfa-data/1.0/"/>
</afBoundData>
<afSubmissionInfo>
<computedMetaInfo/>
<stateOverrides/>
<signers/>
<afPath>/content/dam/formsanddocuments/assembleattachments</afPath>
<afSubmissionTime>20200920124211</afSubmissionTime>
</afSubmissionInfo>
</afData>

[GirishBedekar]

https://docs.adobe.com/content/help/en/experience-manager-65/forms/adaptive-forms-basic-authoring/cr...

[techddx]

Hi Giresh, i was able to resolve the repeating panel issue by adding a subform in the xdp and rewriting the schema. Thank you

[GirishBedekar]

Great. How about the issue of 20 attachments?

[techddx]

It still does not work when there are 20 or more attachments.

[GirishBedekar]

Did you enable the log for the bundle?

check the logs it should give you more information 

Are these attachments all pdf files?

[techddx]

Hi Girish, yes all attachments are pdf

[techddx]

Here is a portion of the Data.xml after form submission:

<?xml version="1.0" encoding="UTF-8"?>
<afData>
    <afUnboundData>
        <data>
            <attachment1>
                <fileAttachment>1.pdf</fileAttachment>
            </attachment1>
            <attachment2>
                <fileAttachment>2.pdf</fileAttachment>
            </attachment2>
            <attachment3>
                <fileAttachment>3.pdf</fileAttachment>
            </attachment3>
            <attachment4>
                <fileAttachment>4.pdf</fileAttachment>
            </attachment4>
            <attachment5>
                <fileAttachment>5.pdf</fileAttachment>
            </attachment5>
            <attachment6>
                <fileAttachment>6.pdf</fileAttachment>
            </attachment6>
            <attachment7>
                <fileAttachment>7.pdf</fileAttachment>
            </attachment7>
            <attachment8>
                <fileAttachment>8.pdf</fileAttachment>
            </attachment8>
            <attachment9>
                <fileAttachment>9.pdf</fileAttachment>
            </attachment9>
            <attachment10>
                <fileAttachment>10.pdf</fileAttachment>
            </attachment10>
            <attachment11>
                <fileAttachment>11.pdf</fileAttachment>
            </attachment11>
            <attachment12>
                <fileAttachment>12.pdf</fileAttachment>
            </attachment12>
            <attachment13>
                <fileAttachment>13.pdf</fileAttachment>
            </attachment13>
            <attachment14>
                <fileAttachment>14.pdf</fileAttachment>
            </attachment14>
            <attachment15>
                <fileAttachment>15.pdf</fileAttachment>
            </attachment15>
            <attachment16>
                <fileAttachment>16.pdf</fileAttachment>
            </attachment16>
            <attachment17>
                <fileAttachment>17.pdf</fileAttachment>
            </attachment17>
            <attachment18>
                <fileAttachment>18.pdf</fileAttachment>
            </attachment18>
            <attachment19>
                <fileAttachment>19.pdf</fileAttachment>
            </attachment19>
            <attachment20>
                <fileAttachment>20.pdf</fileAttachment>
            </attachment20>
        </data>
    </afUnboundData>
    <afBoundData>
        <formData xmlns:xfa="http://www.xfa.org/schema/xfa-data/1.0/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
            <processingInfo>
                <contractor>123</contractor>

All 20 attachments appear in the Data.xml, but the pdf is not assembled. The same problem happens with the repeating bankstatement panels in the bundle

[GirishBedekar]

You will need to change the parameter in the workflow step to reflect your attachment element