How do you send emails that show local time not server time?


I have a requirement. Whenever a user receives an email from the TRIRIGA application, the date-time should be displayed in local time, not the current server time. This should be based on different multiple time zones and not any particular one. Can anyone help me to achieve this through workflow activities in TRIRIGA?

[Admin: To see other related posts, use the Time Zone tag or Email tag.]

Continue reading

Advertisements

How do you get notifications of events in your external email?


“Whenever a user submits a request for resource reservation, he gets a notification in his portal. However, I am not able to get that notification in a personal email like abc@gmail.com. I have added this email in the user profile. Also, in the notification window, it shows that the external mail is abc@gmail.com. But I am still not able to get any emails if I login in that email account.”

I have a similar question as well. I would like the service technician to get an email notification if the work task has been assigned to him. Is that possible in TRIRIGA?

[Admin: To see other related posts, use the Email tag or Notifications tag.]

Continue reading

Is there a way to export query results as attachment to email?


I have two questions:

  • (1) Is there any way to export the results of a query and send them as an attachment to a particular email ID?
  • (2) Is there any way to schedule to get the report results and automatically send them in Excel to an email ID?

[Admin: This post is related to the 03.15.16 post, 05.04.15 post, and 01.24.15 post about sending BIRT reports via email.]

Continue reading

IV96646: Incorrect triCreatedSY in HTML attached to notification


When a notification is sent that contains an HTML document with the triCreatedSY (Created) and triModifiedSY (Modified) fields, the date values being shown are the same value, even when the record was modified well after it was created.

A parsing error was occurring when converting the String value into the Long value. Moving forward, we resolved an issue to display the correct values for the triModifiedSY and triCreatedSY fields in the email notification message.

[Admin: A similar article is also posted in the IBM Support PortalTo see other related posts, use the Notifications tag.]

Continue reading

How do you integrate Exchange with TRIRIGA using IBM Domino?


I’m trying to do a reservation integration between Exchange (Outlook 365) and TRIRIGA. But since TRIRIGA is on-premise, it has several firewall restrictions in order to reach Exchange. As a solution, we are using IBM Domino to relay the SMTP messages from Exchange to TRIRIGA. The flow would be:

  • User books a room on Exchange using the web client.
    • The Send connector sends the email to Domino by using the forwarding contact for the room.
  • Domino receives the email and forwards it to the TRIRIGA server.
    • It should relay the message without modifying it in any way.
  • TRIRIGA receives and processes the SMTP message.
    • What we expected: The reservation should’ve been created.
    • What we see: TRIRIGA can’t find the room. It seems that the SMTP message is missing the “spec_id” of the room.

Has anyone implemented a similar solution? From Exchange to Domino to TRIRIGA? If yes, how did you configure the environments? Where should the “spec_id” be in the SMTP message that is sent to TRIRIGA?

[Admin: To see other related posts, use the SMTP tag or Outlook tag.]

Continue reading

IV96454: Notification images do not show due to removed HTML tags


When a notification sends HTML code in an email, the images are not displayed because the platform is stripping away the HTML tags for images.

We needed to add the tag to the list of HTML tags allowed in outgoing emails. When the platform sent outgoing mail, some HTML tags were stripped from the message. Moving forward, the tag is no longer one that is removed, so that you can send messages with images.

[Admin: This post is related to the 11.03.15 post about showing an HTML image in the notification content.  To see other related posts, use the HTML tag.]

Continue reading

How do you update a record with Data Integrator?


I’m trying to update a record using Data Integrator. But currently, I have no good results with this. The record is just added, not updated. I would appreciate it if you could show me an example of updating the value of an existing record for an employee’s email address below. I might not have understood the publish name, or the unique key of TRIRIGA.

  • (1) triIdTX: 1000004: This is the system generated number at record creation. I assume it’s used as the unique key. (I am not sure if it is the publish name or not.)
  • (2) triLastName: Aaaaaaaa: This is the value with the same value when creating a record.
  • (3) triFirstName: Bbbbbbbb: This is the value with the same value when creating a record.
  • (4) triEmailTX: xxxxx@yy.zz.com: It was not set when creating a record. And I want to set this value as an update value.

Also, let’s suppose that some values are already set to other fields of triPeople, but are not specified in Data Integrator.

You are correct that it’s adding a record because you’re not using the Publish Name. Take a look at the documentation in Application Building for the IBM TRIRIGA Application Platform 3: Data Management (3.4.x PDF p.35 | 3.5.2 PDF p.31). I confirmed the publish name in our latest release is the same as documented: Last Name + ‘, ‘ + First Name + ‘ – ‘ + ID.

[Admin: To see other related posts, use the Data Integrator tag.]

Continue reading