Show Menu
TOPICS×

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.
  1. Use the
    Create element
    button to create a field.
  2. 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.
    If you leave the
    Label
    field empty, it will automatically be completed from the ID. We recommend using 30 characters maximum.
  3. To modify one of the fields, check the
    Edit Properties
    button.
  4. In the
    Field definition
    screen, you can define a category that will be used for the audience and targeting, or even add a description.
  5. 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.
  6. 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.
  7. 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.
  8. Check the
    Add automatic ID
    field to automatically generate an ID. Please note that existing entities will remain empty.
  9. To modify the way in which the name of the resource elements will appear in the lists and creation steps, check the
    Personalize the resource title
    box. Select a field from those you created for this resource.
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.
  1. 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.
  2. Use the
    Create element
    button to create a key.
    The
    Label
    and
    ID
    fields are completed by default but you can edit them.
    We recommend using 30 characters maximum.
  3. 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.

Defining indexes

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.
  1. Use the
    Create element
    button to create an index.
  2. The
    Label
    and
    ID
    fields are completed by default, but you can edit them.
    We recommend using 30 characters maximum.
  3. To define the elements making up this index, select the fields from those that you created for this resource.
  4. Click
    Confirm
    .
The indexes that were created appear in the list in the
Index
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.
  1. Click the
    Edit properties
    button to add a description.
  2. If needed, modify the label and ID of the resource.
    We recommend using 30 characters maximum.
  3. 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.
  4. 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.
  1. Create an extension to the profiles resource or create a new resource.
  2. In the data structure definition, check the
    Add automatic ID field
    option, under the
    Fields
    section.
  3. 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 activating the option. Only new records will have an ACS ID. This field is in read-only mode. You cannot modify it.