ValuD: How do you attain freedom with a TRIRIGA mobility solution?

There has been a running debate on how to define a “real” mobility solution for IBM TRIRIGA – do we depend on a UI/UX framework or on commercially available solutions?

A UI/UX solution is a good platform solution that serves as an extension of the desktop TRIRIGA solution, but definitely has its limitations particularly for offline capabilities and keeping development costs in check. Mobility solutions need to operate offline and to leverage the native capabilities of the mobile device and platform. Based on our interaction with a variety of customers, we found some key challenges in evaluating the IBM mobility technology options…

How can we help?

Having executed multiple IBM TRIRIGA implementations, ValuD knows and anticipated the issues faced by customers. Given our in-depth expertise, ValuD designed a mobility solution solely for IBM TRIRIGA.

ValuD’s IBM TRIRIGA mobility solution – MobilD – was developed on true MADP (Mobile Application Development Platform) called Xamarin, an open source platform for developing MobilD. Microsoft acquired Xamarin recently and they made the entire development toolkit free to increase the market penetration. Xamarin, a widely known MADP, has thousands of application developer networks that can help organizations acquire the necessary skills for future development or management.

Another key factor is the choice of middleware solution; most current vendors use a “proprietary” middleware solution that needs a footprint on one of the TRIRIGA servers. MobilD’s middleware choice is Microsoft Azure which is a hosted solution and does not need any footprint on TRIRIGA servers and can also work with your SaaS solution or on-premise solutions…

[Admin: To see other related posts, use the ValuD tag or UX Framework tag.]

IV97245: Gantt section not keeping the associated report sort order

In a Gantt section, the section is not honoring the associated report sort order.

The issue was caused by the dynamic ordering that was implemented by the project tasks’ internal tree set. The BO query comparison was performed by using the string form of the columns. Moving forward, we resolved an issue where the default Gantt sort ordering, and the sort ordering immediately after importing an MPP project file, did not correctly order by the sequence ID based on the Gantt section query configuration.

[Admin: This post is related to the 06.14.17 post about task date issues when importing MS Project (MPP) files. To see other related posts, use the Gantt tag.]

Why does the Print Preview in IE11 print a blank page?

We are currently using TRIRIGA 10.5.1/3.5.1.1. In IE11, when a record is selected to print, the printer gives a blank page. Whereas before printing, selecting Print Preview shows the page correctly. This behavior was not observed with Google Chrome, where everything gets printed without any issues.

After further investigation, it looks like a Microsoft Windows Update broke this print functionality, and they have since reverted the change that broke it. If you are on the absolute latest IE11 patch, the Print Preview should be working again. Take a look at this blog link. Microsoft has released KB4032782 to address the issue.

[Admin: This post is related to the 11.07.16 post about the font in the Print Preview and printed hardcopy being too small. To see other related posts, use the Print tag or Print Preview tag.]

IV97206: Schedule task date issues when importing MS Project files

Logged into TRIRIGA 3.5.2/10.5.2. Set the project. Navigated to the Schedule tab. Imported MS Project (MPP) file. First thing noted was that the Start and End times were set to 9AM. A time zone was set, but no calendar. After fixing dependencies and saving that to the Gantt, we noted that the schedule task and work task times were an hour off, that is, the Gantt section times and the query section times (specifically, the End times).

After saving to the Gantt, but before saving the project, the dates and duration in the Gantt didn’t match. Also after saving, we noted that the Start and End times of the schedule task were updated from 9AM to some different, seemingly arbitrary, values. After the final save, the Duration values changed from Weeks/Days/Hours to Months/Weeks/Days. We also played around with changing the Planned Start Date of the project, and noted that any change that occurs prior to the original date, or any future date, will not recalculate at all.

There is a bug in the MPXJ library where in some instances, the working days needs to be set to 0. Moving forward, we resolved an issue where sometimes, Microsoft Project files (MPP) tasks are coming in with dependencies with an invalid lag time of 95.4733 days when the lag time should be 0 days.

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

How do you export a BIRT 4.5.0 report to SpudSoft Excel format?

I am designing a BIRT 4.5.0 report which has some images in it. While trying to export the report with the SpudSoft Excel Emitter, it results in an HTML page. My requirement is to export it into a multiple-sheet workbook. That’s why I went with SpudSoft. Any suggestions on how to get the Excel format via the SpudSoft option?

[Admin: To see other related posts, use the BIRT tag or Excel tag.]

IV96649: Carriage returns and line feeds appear twice when in Excel

When exporting TRIRIGA records that contain text fields with carriage returns and line feeds, these fields will have extra spacing between the rows when viewed in the Excel spreadsheet.

The issue is that Excel treats CR+LF (\r\n\) as two separate line feeds. Some operating systems such as Windows use \r\n to represent a carriage return. The fix is to detect the existence of \r\n in a text string, and treat it as single line feed (\n) that Excel recognizes.

Moving forward, we resolved a query export-to-Excel issue, where each carriage return in an exported text field value was appearing in the Excel cell value as two new lines. The fix ensures that Excel cell values display each carriage return in a text field value as a single new line.

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

Why is there an unknown command “TRGA_LOGIN” after CI install?

There may also be an issue where the menu does not load, unless you use the CUILOAD command directly to load the TrgaAcad_en.cuix directly from the install directory. Then, attempting to login results in a _TRGA_LOGIN Unknown command “TRGA_LOGIN” message. The cause of this issue is that the CAD Integrator/Publisher (CI) is not initializing correctly…

Main Issue

Assuming NETLOAD works, the main issue is that probably the CI installer does not have permission to update the registry. CI actually uses the JVM and the command line to update the registry, so on certain secure systems, it may not be allowed to update the registry as needed to tell AutoCAD to load CAD Integrator…

Root Cause

The main issue is a permission issue where the CI installer cannot update the Windows registry to enable automatic loading, which is outside the control of the CI installer. If the CI installer cannot update the registry, then see the workaround…

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