Combining PDF Attachments with DDX, then send separately with Document of Record in AEM OSGi Workflow

techddx

15-09-2020

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

techddx_0-1600213093578.png

Output map:

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

techddx_1-1600213301535.png

Send Email step with Document of Record and attachments document:

techddx_2-1600213476906.png

 

 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. 

techddx_0-1600299274726.png

 

Accepted Solutions (0)

Answers (14)

Answers (14)

workflowuser

Employee

Sep 22, 2020

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>

workflowuser

Employee

22-09-2020

in your crx go to 

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

 

workflowuser

Employee

21-09-2020

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

workflowuser

Employee

21-09-2020

workflowuser_0-1600708540154.png

 

the new bundle can be downloaded from here

https://documentcloud.adobe.com/link/track?uri=urn:aaid:scds:US:63e0e5ce-9099-42ca-ac0d-d4f9f764d2dd

Sample form

https://documentcloud.adobe.com/link/track?uri=urn:aaid:scds:US:f389a099-be09-4c9d-a612-5bd2063076e2

In the process step we can specify the order in which you want the attachments to be assembled.In this screenshot attachment added to the field called idcard will be the first pdf followed by attachments added to the bankstatements which is a field in a table that can grow

GirishBedekar

18-09-2020

Let us know if you have problems creating your own bundle

Ii could give you the ready to use bundle but would be better for you to try creating the bundle

i can definitely help you with the code

GirishBedekar

17-09-2020

This document will help you get stated with creating your first OSGI bundle

https://docs.adobe.com/content/help/en/experience-manager-learn/forms/adaptive-forms/custom-process-...

you will need to familiarize your self with DDX for creating the bundle to accomplish your task

also take a look at the xml file in your payload folder in the crx

GirishBedekar

17-09-2020

I recommend you to use a panel and in that panel let your users add the attachment. One file only

make that panel repeatable 

so when the user submits the form  grab the data.xml That holds your submitted data and iterate through the panels and create your ddx accordingly 

GirishBedekar

17-09-2020

Will your file names will always be the same?

either way this cannot be done without writing custom code 

you will have to create the ddx with the pdf source elements in the right order then use that ddx to assemble the documents

workflowuser

Employee

16-09-2020

Deploy and start the custom bundle and do the following. in your workflow drop process step component.( this will replace the invoke DDX step) associate the process with Assemble Task Attachments. this code assembles the  PDF  attachments of the Adaptive Form and stores it in a file called assembled-pdf.pdf under the payload folder. Create a variable called assembledPDF of type Document. Use the Set Variable component to initialize the variable as shown in the screen shot . You can use this variable in your send email step

workflowuser_0-1600277927375.png

workflowuser_1-1600278092459.png

Let me know if you have trouble getting this to work

In the meantime, I will investigate why the invoke DDX step is not working

BTW the code also writes the assembledpdf to the folder of your aem installation

 

workflowuser

Employee

15-09-2020

are the form attachments getting assembled into one pdf?