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

Advertisements

IV97614: Cannot revise project in Schedule tab with Gantt section


If you attempt to revise a project from the Schedule tab, where the Gantt chart is visible, your session is expired and you receive an invalid session error. The issue was observed in Internet Explorer and Chrome, but not in Firefox.

An analysis from a Fiddler trace shows that when revising the project in Chrome, this POST to GanttDataUpload.jsp seems to kill the session. In Firefox, for whatever reason, this POST doesn’t occur, and the state transition is successful. To confirm that this is the scenario you are experiencing, use the following technote to run a Fiddler trace and check for the same GanttDataUpload.jsp call: IBM TRIRIGA using Fiddler for tracing web browser traffic.

As a temporary fix, use Firefox. When the record is in a read-only state, no Save action should be called on the Gantt. Moving forward, we resolved the session-kill issue when the user performs a Revise action on a project in the Schedule tab.

[Admin: This post is related to the 08.18.15 post about using Fiddler to trace TRIRIGA web traffic. To see other related posts, use the Gantt tag or Fiddler tag.]

Continue reading

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.]

Continue reading

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.]

Continue reading

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.]

Continue reading

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.]

Continue reading

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.]

Continue reading