How do you migrate documents from one environment to another?


Is it possible to migrate documents from one TRIRIGA environment to another?

Yes, documents can be migrated from one environment to another, but I would recommend that you focus on “system” documents like BIRT reports, or Excel sheets used for offline processes. I would not use object migration (OM) to migrate documents in large quantities…

[Admin: This post is related to the 12.02.16 post about integrating with CMIS or ECM solutions, the 06.09.16 post about using an ECM solution instead of Document Manager, and the 04.13.16 post about uploading 6500 locations with several attachments each.]

Continue reading

Can you remove TRIRIGA BIRT report files from /tmp folder in Linux?


Can the IBM TRIRIGA BIRT report files be removed from /tmp folder in Linux? We can see BIRT-related files in the Linux /tmp folder being generated from the TRIRIGA user sessions… Can these files be removed from the system on a regular basis?

Yes, they can be removed. You can remove those BIRT temporary files from the /tmp folder if they are at least 2 days old, even if the system is up and running (no need to shut it down). We do not expect user sessions holding BIRT report rendering for more than 1 day, but we are letting it go 2 days for security. For new versions (3.5 and onward), this works better and we do not expect to have a large amount of BIRT-report related files in the /tmp folder (but this may happen for older versions).

Continue reading

What does the Form link in a TRIRIGA manager query do?


I see the Form link on my IBM TRIRIGA queries. What is it for? Can it be disabled?

The Form link allows you to display report forms for selected records. For example, this could be an HTML form or a BIRT form. If you’re using the Home > Portfolio > People > Employees page, by selecting records and clicking on the Forms link, there might not be a report form assigned to that specific navigation item, so therefore you might get an empty window.

There is no way to remove the Form link from an OOB as-delivered design for 3.3, 3.4, 3.5.0, 3.5.1 and 3.5.2. If this is set up properly in the navigation item, the records will be returned in a separate window by using the form you have specified. You must select records before you click on the Form link, otherwise, an error message will show up. You define the report form for the Form link in the Navigation Item Editor tool.

Continue reading

How do you install BIRT Designer 4.6.0 with TRIRIGA 3.5.1 and later?


Starting in TRIRIGA 3.5.1, a new BIRT engine was introduced with your TRIRIGA installation. This is BIRT engine version 4.6.0.

To customize or create new reports, as well to convert your old BIRT 4.3.1 reports, you need the same BIRT Designer version. This Designer runs on the Neon Eclipse platform and you can use your current Java 1.8 with it (in older designers, you needed a Java 1.6, 32-bit, to make it work). This new version is optimized for Mac (in older versions, a lot of manual steps were needed). Also, you can have it as an application now. For Windows, it remains a folder in the location of your choice.

Another often-raised topic is about “upgrading from 4.3.1 to 4.6.0”. The fact is you can have both installed in your machine. They are separate installations. The caveat here is that you cannot use the same workspace for 4.6.0, if you already have 4.3.1 installed, so you just need to rename the workspace used for the first time.

So let’s start with what you need…

[Admin: This post is related to the 08.19.16 post about failing to connect with 3.5.1, and the 08.18.16 post about getting an HTTP Error 500.]

Continue reading

ValuD: Is TRIRIGA OOB reporting good for your business needs?


In this era of big data and predictive analytics, the Facilities Management industry has undergone a sea change in terms of data management and utilization… In such a scenario, the question arises as to whether the in-app reporting features offered by these tools, like the Report Manager offered by IBM TRIRIGA, are comprehensive enough for the purposes of strategic management and analysis. In order to analyze whether IBM TRIRIGA ad-hoc reporting capabilities can satisfy the reporting requirements of your business, you first need to recognize its scope and limitations…

The idea behind ad-hoc reporting is to enable users to create their own report. They should be able to decide on the fields, sorting, or grouping that they might require in their report. By letting the user decide on these criteria, ad-hoc reports ensure that a significant portion of the development time is freed, since the developer no longer needs to produce reports based on individual report requirements.

By and large, IBM TRIRIGA ad-hoc reporting, in itself, should be comprehensive enough for most businesses. But on the other hand, if extensive formatting is what you need, the IBM TRIRIGA ad-hoc report manager may not be enough. IBM TRIRIGA has sought to overcome this limitation by integrating with Eclipse BIRT. Business Intelligence and Reporting Tools (BIRT) is an open source reporting and business intelligence tool which IBM TRIRIGA advanced reporting uses to create data visualizations and reports. Using an IBM TRIRIGA plugin for the BIRT application, you get to experience the power of data mining and predictive analytics, right there, in your IBM TRIRIGA Report Manager…

[Admin: This post is related to the 09.28.16 post by ValuD about when to use OOB in-app reporting versus BIRT reporting.]

Continue reading

Why does the BIRT report time out before the email is sent?


When you have a large data set and a record triggers a notification that sends an email when a BIRT report link is attached, if the query takes too long to retrieve results, users will not be able to see the report. The session will expire before the email containing the link is sent. For example, click on the link to a BIRT report in the email notification, and you will receive a message stating the session has expired. Other messages have been observed, as well as the request to sign back in.

By default, a report is written against the active session. So, if the session times out, the report is lost. To resolve the problem, you may check the “Queued” box in the Options tab of the report. That way, the report will run in the background and it will write to the user directory rather than to the session.

Continue reading

Can anyone help with BIRT reports that print work orders?


I need to know if there is any other documentation available to get an in-depth knowledge of BIRT? I’m trying to do something fairly simple. I want to write a report that prints out our work orders. I can’t get the associations (triResources) to show up in the report. I know I’m missing something fairly obvious, but I have been researching this for several days and I can’t get access to associated data. I have both queries listed as data sets but can’t get them to link together.

Has anyone had any success with any other programs, besides Crystal, to push reports to specific printers without creating a separate report for each printer?

Continue reading