Skip to main content
Question

AssystETM - variables as substitution keywords

  • January 20, 2025
  • 7 replies
  • 65 views

akudama
Do Gooder (Partner)
Forum|alt.badge.img+1
  • Do Gooder (Partner)
  • 4 replies

Hi everyone,

 

I am setting a datamapper in AssystETM to create an event based on the import of a mail.

I set the datamapper and I can create the event without particular problems with the “standard” values of an event (affected user, mail, item, etc.).

Now, I would like to also track the To and CC fields of the mail I’m importing; the final result I wish to achieve is to have all these fields and to be able to insert them in an action template that I can use, for example, with a mail to customer action.

For that scope, i will need to create at least 3 substitution keywords to be used (one for the To filed, one for Cc and one that combines them).

I was already able to create a variable in my datamapper to extract the required fields, but now I am struggling creating the keywords.

I started creating a variable in my datamapper, but I can’t find any information regarding using datamapper variables as substitution keyword. Do you know if that is possible?

I’d like to use variables if I am capable, but if it’s not possibile, I can use other field marked as strings without problems; I thought that for my needs the User1 Field Char 1-3 are the best options, but I can’t find any useful looking at the Assyst Javadocs to implement these fields, when I try the variables are always not valorized.

I try with

$new.event.user1_field_char1

$new.event.user1_field_char1.name

$new.event.user1_field_char1.content

 

but without any success.

 

Could you help me understand what is the correct notation for that?

Many thanks in advance!

7 replies

Forum|alt.badge.img+10

The action template and substitution keywords only have access to the event that was logged by ETM. The mapper variables only exist during the evaluation of an ETM import & are discarded after that. 

I think you will need to store TO & CC into fields on the event (either standard or custom fields) and then define the substitution keywords that reference these fields.


akudama
Do Gooder (Partner)
Forum|alt.badge.img+1
  • Author
  • Do Gooder (Partner)
  • 4 replies
  • January 20, 2025
Paul McCulloch wrote:

The action template and substitution keywords only have access to the event that was logged by ETM. The mapper variables only exist during the evaluation of an ETM import & are discarded after that. 

I think you will need to store TO & CC into fields on the event (either standard or custom fields) and then define the substitution keywords that reference these fields.

Hi Paul and thanks for the answer,

 

I tried what you suggest, I created thre custom fields in customizer for my event form, after that in the datamapper I assigned the custom choice and the Shortcorde, I noticed that if I do so, trying to debug with a previous import I don’t get any values, but if I leave my elements as variables, I get the results.

In the 1st picture you can see the configuration and debug result with the custom value, in the 2nd as a variable (for the custom, the result is the same when the no value is to use null or to skip)

 

Is it something about the type of voice (“Custom”) that I choose?

 

 

 


Forum|alt.badge.img+10

A couple of things could be happening:

  1. The datamapper doesn’t know which event form to use. Have you specified the custom form in the mapper?
  2. The form definition in ETM is out of synch with that in assyst. Try clicking the clear cache button in the Platform menu
  3. The form definition in assystREST is out out of synch. Try deleting the web session for IPaaS/ETM (in assyst web) *and* clicking the clear cache button in the Platform menu.
  4. There could be a bug in the preview function. Try just using a fixed value in the mapper expression & use it to log a new event.

akudama
Do Gooder (Partner)
Forum|alt.badge.img+1
  • Author
  • Do Gooder (Partner)
  • 4 replies
  • January 24, 2025
Paul McCulloch wrote:

A couple of things could be happening:

  1. The datamapper doesn’t know which event form to use. Have you specified the custom form in the mapper?
  2. The form definition in ETM is out of synch with that in assyst. Try clicking the clear cache button in the Platform menu
  3. The form definition in assystREST is out out of synch. Try deleting the web session for IPaaS/ETM (in assyst web) *and* clicking the clear cache button in the Platform menu.
  4. There could be a bug in the preview function. Try just using a fixed value in the mapper expression & use it to log a new event.

Hi Paul, sorry for the delay in my answer

 

I try what you suggested, but I can’t import the values in my mail in my form. I’m sure I am missing something, right now this is my datamapper:

 

First I set what is the custom form to be used, than I set a variable with the data I need, and debugging it always works. Next I select the custom voice and I put the shortcode of my custom field on the form (this for is a single-line string) but the field is not evaluated, even if I put a simple fixed text value as the custom expression or the variable expression.

 

I try to run an import with these configurations, but it always failed with this (not very useful) message:

 

I think it could be about the custom field I am trying to use, because if I use other fields or if I “exclude” the custom from the datamapper configuration, it runs smoothly everytime.

 

Following the Wiki I try to put as literal value for the custom short code just the shortcode (TOMAIL), the shortcode as a text (“TOMAIL”) and the combination custom.TOMAIL.shortCode but without success.

This is my custom field

Am I writing it in the wrong way?


Forum|alt.badge.img+10

Did you try points 2&3?


akudama
Do Gooder (Partner)
Forum|alt.badge.img+1
  • Author
  • Do Gooder (Partner)
  • 4 replies
  • January 24, 2025
Paul McCulloch wrote:

Did you try points 2&3?

Hi Paul,

Yes, I confim that I tried both points but, unfortunately, the result is the same


Forum|alt.badge.img+10

Can you log a ticket with the service desk please? If you could attach the import log file from a failed import then that will help.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings