Where is the Compatibility Matrix going to be relocated?


In January 2020, IBM developerWorks displayed the following banner message:

“The developerWorks Connections Platform is now in read-only mode and content is only available for viewing. No new wiki pages, posts, or messages may be added. Please see our FAQ for more information. The developerWorks Connections platform will officially shut down on March 31, 2020 and content will no longer be available. More details available on our FAQ.

Where is the Compatibility Matrix going to be relocated?

(1) In February 2020, the Compatibility Matrix and several related pages were officially relocated to IBM Support as follows:

(2) Since January 2020, the above information is also available in the independent (or backup) wiki:

  • TRIRIGAFEEDIA Wiki
    https://tririgafeedia.wiki
  • Note that this wiki may or may not contain the latest updates, but it strives to do so.

[Admin: This post is related to the 11.14.14 post about the latest Compatibility Matrix. To see other related posts, use the Matrix tag.]

Continue reading →

Where are the new TRIRIGA forums going to be located?


Official Forums

Officially, as of February 2020, the TRIRIGA forums on IBM developerWorks were migrated to IBM Support. Here’s the link. You might notice that the URL includes the “TRIRIGA Platform” forum tag. Theoretically, if everything works properly, this tag should allow you to filter for the migrated TRIRIGA forum posts.

Unfortunately, in order to post, the IBM Support Forums require you to request access to a specified product. Although this might be normal behavior for certain Support sites, this isn’t very convenient for a so-called “forum”. I didn’t expect it. Even as an employee of an IBM partner, I don’t have a Customer Number.

In any case, here’s the following request process. Good luck!

  • (1) In the upper-right corner of the Support page, open the user menu and select the Support Access option.
  • (2) In the Support Access page, click the Request Access button.
  • (3) In the Support Access popup, select the specific TRIRIGA Product (required), enter your Customer Number (required), and select the Country where the product is located (strange but required).
  • (4) Click the Submit button.

Independent Forums

Independently, we already see TRIRIGA forums or groups on social media, like the Facebook group “TRIRIGA Around the World” and Google group “triDeveloper“. But if you’d rather avoid Facebook and Google, I’ve set up an alternative Flarum-based forum called “TRIRIGAFEEDIA Forum“, which includes links to our archived forums from developerWorks. Although this forum is still pretty new and quiet, its light-and-fluid look-and-feel might impress you. Curious about it? I’ll see you there!

Content Migration

[Admin: This post appeared first on TRIRIGAFEEDIA.]

Continue reading →

Reaching another TRIRIGAFEEDIA milestone


Last week, December 5th, 2019 was the 5th anniversary of TRIRIGAFEEDIA. Another impressive milestone! Where have I been? Well, let’s just say that 2018 and 2019 have been very busy years. And I have no doubt that 2020 will be just as interesting, if not more so. Speaking of which, you might’ve noticed that IBM developerWorks is showing an important banner at the top of its wiki pages:

“The developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this wiki will no longer be available.”

However, I’ve also learned that our specific wiki will remain frozen in read-only mode until the end of January 2020 before disappearing. Despite the challenges, the TRIRIGA team has been busily preparing a new wiki platform alternative. While the initial wiki pages may be populated as soon as January 2020, more and more batches will steadily follow, and the final pages may appear several months later.

So if you have a favorite wiki page that you might need during our migration process, I encourage you to print them to PDF for safekeeping. In any case, I’m excited about what I’ve seen of the cool new wiki platform so far. Stay tuned! Thanks again for reading, following, and feeding TRIRIGAFEEDIA. I appreciate it!

[Updated 12.13.19]

Interestingly, one day after I posted this entry, IBM updated their wiki banner:

“The developerWorks Connections platform will be sunset on January 2, 2020. This wiki will no longer be available unless an extension has been requested.”

[Updated 12.19.19]

Unfortunately, IBM didn’t approve the direction of our new wiki alternative. So we’ll discuss our next steps in January 2020. Meanwhile, I’ve learned that our current wiki will remain frozen in read-only mode until the end of March 2020. Stay tuned!

[Admin: This post appeared first on TRIRIGAFEEDIA.]

Continue reading

UX: How do you create and save a record in UX via a workflow?


I’ve got most of this worked out. So I can trigger a workflow from a UX web page. But I am stuck on how to take data created in the UX application, feed it to the workflow, place that data into record fields, and then create a draft record. This is the UX code that is feeding data back to TRIRIGA. The data is valid. I am just stumped on how to feed it into a workflow. Any ideas?

var newRec = {
triHoursNU: vFixedTotal,
triControlNumberCN: triControlNumberCN,
triDateTX: mm + “/” + dd + “/” + yyyy, 
triIdTX: triIdTX,
triNameTX: fName + ” ” + lName
};
console.log(newRec);
this.$.timeLogQueryDs.createRecord(newRec, TriPlatDs.RefreshType.BOTH, 
“createLog”, “create” ) 
.then(function(){
this.$.toastBlue2.show(); 
}.bind(this));

When you create a record, let’s say you have a data source called “peopleDs”, you create an object and then pass it to the create method of the data source. The names should match the data source exposed field names. I also recommend looking at the documentation for your TRIRIGA instance at: /p/web/doc.

[Admin: The same question is also posted in the main UX Framework forum. To see other related posts, use the UX Framework tag or Perceptive tag.]

Continue reading

What are the Oracle Database settings for 10.5.2 and 3.5.2?


I wanted to see if anyone has set up the following settings in an Oracle Database for TRIRIGA 10.5.2 and 3.5.2:

  • 1. NLS_LENGTH_SEMANTICS: Should this be set to CHAR? In our current production environment, it’s set to BYTE, but the TRIRIGA support documentation says that this can lead to data loss, so they recommend using CHAR.
  • 2. NLS_CHARACTERSET: This is set to WE8ISO8859P1 in our current production environment, but the support document says that it must be UTF-8 or UTF-16.
  • 3. Block size: This is set to 8k, but the documentation recommends using 16k.

For (1) and (2), if you never want to store multibyte characters, then what you have is fine. But if you do, then you must use what the support documentation suggests.  Once you have your database created, it is difficult and time-consuming to change it, and it needs to be done outside of TRIRIGA. As for (3), I would encourage you to use 16k, since it will allow you better throughput and paging, unless you have a strong reason why you need to stay at 8k.

[Admin: This post is related to the 04.04.16 post about database character settings. NLS refers to National Language Support parameters in Oracle. To see other related posts, use the Multibyte tag, MBCS tag, or NLS tag.]

Continue reading

How do you use Dynamic Workflow settings in Call Workflow task?


I am looking for some explanations for the “Dynamic Workflow” property settings in the Call Workflow task. When should I use it?

The Dynamic Workflow property and fields allows you to pull the workflow name to execute from a task > field, instead of the workflow name being hard-coded in the workflow. The field must contain the workflow name to execute.

Excerpt from the “Application Building” (3.5.3, PDF) user guide:

Dynamic Workflow: The values of this field are used to dynamically define the name of the workflow that this task will launch. For the “Task with Workflow Name” drop-down list, select the task record that contains the workflow name. For the “Workflow Name Field”, select the field on the task record that contains the workflow name. This record field must contain the workflow name that you want to launch.

[Admin: To see other related posts, use the Workflow tag or Workflow Builder tag.]

Continue reading

Is there any tool which imports currency conversion rates?


We are looking for an integration solution which allows you to import currency conversion rates. It seems that this data is not based on a BO, so I think traditional integration tools such as DataConnect (DC), Data Integrator (DI), and Integration Object won’t work. Have you seen this kind of requirement? Are there any solutions other than using SQL script? I’ve tried the SQL below, and it seems to be working.

INSERT INTO BUDGET_CURRENCY_CONVERSION (CONVERSION_GROUP, FROM_CURRENCY_CODE, TO_CURRENCY_CODE, CONVERSION_RATE, START_DATE, END_DATE, INSTANCE_ID) VALUES (‘LIBA’, ‘Chinese Yuan’, ‘Euro’, 0.13, {ts ‘2017-01-01 01:00:00’}, {ts ‘2017-12-31 01:00:00’}, BUDGET_CURRENCY_ID_SEQ.nextval)

BusinessConnect (a.k.a. Connector for Business Applications or CBA) is the best method to use for this. Here’s the PDF. The putCurrencyConversionRates method is what you would want to use.

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

Continue reading