When you create a custom table in Adobe Campaign, you may want to build a form in AEM that maps to that custom table.
This document describes how to create custom form mappings. When you complete the steps in this document, you will be providing your users with an event page where they can sign up for an upcoming event. You then follow up with these users via Adobe Campaign.
You need to have the following installed:
See Integrating AEM with Adobe Campaign Classic for more information.
In order to create custom form mappings, you need to follow these high-level steps, which are described in detail in the following sections:
Start by creating a custom table in Adobe Campaign. In this example, we are using the following definition to create an event table:
<element autopk="true" label="Event" labelSingular="Event" name="event">
<attribute label="Event Date" name="eventdate" type="date"/>
<attribute label="Event Name" name="eventname" type="string"/>
<attribute label="Email" name="email" type="string"/>
<attribute label="Number of Seats" name="seats" type="long"/>
</element>
After you create the event table, run the Update database structure wizard to create the table.
In Adobe Campaign, tap/click Add to create a new extension of the Seed addresses (nms) table.
Now, use the fields from the event table to extend the seed table:
<element label="Event" name="custom_cus_event">
<attribute name="eventname" template="cus:event:event/@eventname"/>
<attribute name="eventdate" template="cus:event:event/@eventdate"/>
<attribute name="email" template="cus:event:event/@email"/>
<attribute name="seats" template="cus:event:event/@seats"/>
</element>
After this, run Update database wizard to apply the changes.
In Administration/Campaign Management, go to Target Mappings and add a new Target Mapping.
Make sure you use a meaningful name for Internal name.
In this step, you are adding a delivery template that uses the created Target mapping.
In Resources/Templates, navigate to the Delivery Template and duplicate the existing AEM delivery. When you click To, select the create event Target mapping.
In AEM, make sure you have configured a Cloud Service in Page Properties.
Then, in the Adobe Campaign tab, select the delivery that was created in Creating a Custom Delivery Template.
When configuring the fields, make sure you specify unique element-names for the form-fields.
After the fields are configured, you need to manually change the mapping.
In CRXDE-lite, go the jcr:content (of the page) node and change the acMapping value to the internal name of the Target mapping.
In the configuration of the form, make sure you check the checkbox to create if non existing
You can now submit the form and validate on the Adobe Campaign side whether the values are saved.
“Invalid type for value ‘02/02/2015’ from element ‘@eventdate’ (document of type ‘Event ([adb:event])’)”
When submitting the form, this error is logged in the error.log in AEM.
This is due to an invalid format for the date field. The workaround is to supply yyyy-mm-dd as the value.