Configuring the resource's data structure
After creating a new custom resource, you must configure the data structure.
When editing the resource, in the Data structure tab, you can add:
Adding fields to a resource
You can add new fields to a resource to store data that are not part of the out of the box data model.
- Use the Create element button to create a field.
- Specify a label, an ID, a field type, and define the maximum length authorized for this field.The ID field is mandatory and must be unique for each field added.Use 30 characters maximum.
- To modify one of the fields, check the Edit Properties button.
- In the Field definition screen, you can define a category that will be used for the audience and targeting, or even add a description.
- Check the Specify a list of authorized values option if you need to define values that will be offered to the user (enumeration values).Then, click Create element and specify a Label and Value . Add as many values as needed.
- Once you have added your fields, check the Add audit fields box to include fields detailing the creation date, the user that created the resource, the date, and the author of the last modification.
- Check the Add access authorization management fields box to include the fields stating who has access rights to that particular resource.These fields appear in the data and metadata that can be displayed once the database update has been carried out. For more on this, refer to the Updating the database structure section.
- Check the Add automatic ID field to automatically generate an ID. Please note that existing entities will remain empty. For more on this, refer to the Generating a unique ID for profiles and custom resources .
- To modify the way in which the name of the resource elements will appear in the lists and creation steps, check the Customize the title of the resource elements box. Select a field from those you created for this resource.If you do not check this option, the automatic primary key (which is automatically created each time an entity is added to the table) will be used when you list all the entities from this table.
The fields of your resource are now defined.
Defining identification keys
Each resource must have at least one unique key. For example, you can specify a key so that two products cannot have the same ID in a purchase table.
- Specify it in the Automatic primary key section the size for the storage if you would like to have a technical key automatically and incrementally generated.
- Use the Create element button to create a key.The Label and ID fields are completed by default but you can edit them.Use 30 characters maximum.
- To define the elements making up this key, click Create element and select the fields that you created for this resource.Created keys are displayed in the Custom keys section.
Your identification keys for the resource are now created.
To learn about best practices when creating identification keys, see this section .
An index can reference one or several resource fields. Indexes allow the database to sort records in order to recover them more easily. They optimize the performances of SQL queries.
Defining indexes is recommended but not mandatory.
- Use the Create element button to create an index.
- The Label and ID fields are completed by default, but you can edit them.Use 30 characters maximum.
- To define the elements making up this index, select the fields from those that you created for this resource.
- Click Confirm .
The indexes that were created appear in the list in the Index section.
To learn about best practices when creating indexes, see this section .
Defining sending logs extension
The sending log extension allows you:
- to extend dynamic report capabilities by adding profile custom fields
- to extend the sending logs data with segment code and profile data
Extend with a segment code
The user can extend the logs with the segment code coming from the workflow engine.
The segment code must be defined into the workflow.
To activate this extension, check the option Add segment code .
For more information on segment code, refer to the Segmentation section.
Extend with a profile field
The administrator should have extended the Profile resource with a custom field.
Click Add field and select any custom field from the profile resource.
In order to generate a new sub-dimension linked to the Profile dimension, check the Add this field in Dynamic reporting as a new dimension option.
From Dynamic Reporting, you can drag and drop the custom field dimension into a freeform table.
For more information on Dynamic Reporting, refer to the List of components .
The number of fields sent to Dynamic Reporting is limited to 20.
Editing resource properties
In the custom resource screen, the Summary pane indicates the status of the newly created resource. You can manage its access and its general properties.
- Click the Edit properties button to add a description.
- If needed, modify the label and ID of the resource.Use 30 characters maximum.
- If you need to restrict the access to this resource to certain organizational units, specify them here. Only users from authorized units will be able to work with this resource in the application.
- Save the modifications.
Your modifications are saved. You need to publish the resource again to apply them.
Generating a unique ID for profiles and custom resources
By default, profiles and custom resources have no business ID when they are created. You can enable an option that generates automatically a unique ID when elements are created. This ID can be used to:
- Identify exported records easily in an external tool.
- Reconcile records when importing updated data processed in another application.
It can be enabled for profiles and custom resources only.
- Create an extension to the profiles resource or create a new resource.
- In the data structure definition, check the Add automatic ID field option, under the Fields section.Only new records will have an ACS ID. The ACS ID field will remain empty for profiles or elements created before activating this option.
- Save and publish the modification made to the resource. If you want this mechanism to apply for elements created via the API, check the option to extend the API.
The ACS ID field is now available and automatically populated when new elements are created manually, from the API, or inserted from an import workflow. The ACS ID field is a UUID field and is indexed.
When exporting profiles or custom resources, you can now add the ACS ID column if it has been enabled for that resource. You can reuse this ID in your external tools to identify records.
When re-importing data that have been processed/updated in another application (for example a CRM), you can reconcile it easily with this unique ID.
The ACS ID field is not updated for profiles or elements created before enabling the option. Only new records will have an ACS ID.
This field is in read-only mode. You cannot modify it.