Create a Template that Uses the Custom Pages in dspCompose™

Before performing this task:

Create a looped template and process in Integrate. Refer to Configure Process Template Loops for a BDC Script Template with Looping Enabled or Configure Process Template Loops for a GUI Script Template with Looping Enabled in Integrate for more information.
Create all tt Tables and tx Views for the Integrate Process
Create rt Tables from the tt Tables
Create Custom Pages and Views

Once all of the custom pages and their views are created, follow these steps to use them in dspCompose™.

NOTE: A Post Message table must be defined on the Template (Post Message Table) page (Team > Templates > Vertical View > Configuration > Post Message Tables). This page must have a record for the Data Entry table that contains the column where the returned Post Message is stored. If the Post Message table is not defined, an error displays when a user clicks Post on the Request (Roles) page and the posting process stops.

To create a template that uses the custom pages:

Select Team on the Navigation pane.
Click Templates for a team.
Click Add.

NOTE: If creating the template on the Create Template page, do not use the Create From Integrate Template option to create the template.

View the field descriptions for the Templates page’s Vertical View.
Enter a name in Template Name field.
Select Custom Setup from the Type list box.
Select the target ERP system connection from the Connection list box.
Click Save.
Click Configuration tab.
Click Post Message Tables.
Click Add.

View the field descriptions for the Template (Post Message Tables) page.

NOTE: When the custom template is saved, one post message table is created by default. A post message table for the main table created in Create all tt Tables and tx Views for the Integrate Process must also be added.
Select the data source that stores the tt tables created in Create all tt Tables and tx Views for the Integrate Process from the DATA SOURCE ID list box.
Select the tt table name for the header table from the TABLE NAME list box.
Select ID from the POSTING PRIMARY KEY COLUMN list box.
Select PostError from the POST ERROR COLUMN list box.
Select PostMessage from the POST MESSAGE COLUMN list box.
Click Save.
Click Add.

View the field descriptions for the Template (Post Message Tables) page.
Select the data source that stores the rt tables created in Create all tt Tables and tx Views for the Integrate Process from the DATA SOURCE ID list box.
Select the rt table name for the header table from the TABLE NAME list box.
Select ID from the POSTING PRIMARY KEY COLUMN list box.
Select PostError from the POST ERROR COLUMN list box.
Select PostMessage from the POST MESSAGE COLUMN list box.
Click Save.

NOTE: The following steps must be performed for each additionaltt / rt table combination:
Click Add.

View the field descriptions for the Template (Post Message Tables) page.
Select the data source that stores the tt tables created in Create all tt Tables and tx Views for the Integrate Process from the DATA SOURCE ID list box.
Select the tt table name for the detail table from the TABLE NAME list box.
Select ParentID from the POSTING PRIMARY KEY COLUMN list box.
Select PostError from the POST ERROR COLUMN list box.
Select PostMessage from the POST MESSAGE COLUMN list box.
Click Save.
Click Add.
Select the data source that stores the rt tables created in Create all tt Tables and tx Views for the Integrate Process from the DATA SOURCE ID list box.
Select the rt table name for the detail table from the TABLE NAME list box.
Select ParentID from the POSTING PRIMARY KEY COLUMN list box.
Select PostError from the POST ERROR COLUMN list box.
Select PostMessage from the POST MESSAGE COLUMN list box.
Click Save.

To continue configuring the template:

Navigate to the Templates page’s Vertical View.
Click Configuration tab.
Click Edit.

View the field descriptions for the Templates page’s Vertical View.
Select the name of the Integrate template created in Create a Looped Template and Process in Integrate from the Integrate Template ID list box.
Select the name of the Integrate process created in Create a Looped Template and Process in Integrate from the Integrate Process ID list box.
Click Advanced tab.
Select the component name that contains the Archive pages created for the header loop in Create Archive Pages from the Template Archive WebAppID list box.
Select the page name for the Archive page created in Create Archive Pages from the Template Archive Page ID list box.

NOTE: The page listed here will be the page linked to from Archive Page ID on the Request page after posting. Depending upon the business requirements, modifications may need to be made to this page and underlying view to link to pages for the other data entered and archived.
Click Save.
Click Custom Archive Tables.

View the field descriptions for the Template (Archive Settings) page
Click Add.
Select the component name that contains the tt tables created in Create all tt tables and tx views for the Integrate Process from the ACTIVE TABLE DATA SOURCE ID list box.
Select the tt header table name from the Active Table Name list box.
Select the component name that contains the rt tables created in Create rt Tables from the tt Tables from the ARCHIVE TABLE DATA SOURCE ID list box.
Select the corresponding rt table name from the ARCHIVE TABLE NAME list box.

NOTE: Repeat steps 11-15 for each of the tt/rtdetail tables created for the Integrate Process loops.

Continue with Add Custom Roles for the Looped Template.

Was this article helpful?

Sorry about that.

Why wasn't this helpful? (check all that apply)

I couldn't find the information I needed.

The content has errors or is unclear.

The content is incomplete: More information or context is needed.

Thanks for your feedback.

Want to tell us more?

Send an email to our authors to leave your feedback.

Email us

Great!

Thanks for your feedback.