How do you reduce the PDF file size of an exported drawing?

We are currently using TRIRIGA 10.5.1/ One of our user requests is to try and reduce the PDF size for an exported drawing from the Graphics tab. Of course, one way might be to hide a few of the layers before exporting. Apart from this, is there any other way to compress the file that is exported from the Graphics tab?

What would be the purpose of reducing the file size? (1) If you were expecting the export to run faster, that would not be possible except by turning off layers. TRIRIGA will process all the displayed graphic entities when generating the PDF. (2) If you want a smaller file size to make storage and transfer easy, then you can try using any third-party tool on the PDF file export after the fact. Note that I have no idea how compressible the graphic export is right now.

[Admin: To see other related posts, search “PDF Drawing“.]

Continue reading

How do you find the database field names used by a report?

The following question came my way recently: “I would like to write a Risks report that can be output through an external report server using the TRIRIGA data tables, but I am unable to find any of the text fields in the T_TRIRISKITEM table being used by the canned TRIRIGA All Risk Items report.”

In case it is useful for others (I am sure this has come up for others when writing external reports as well), I have posted this question and will be following up with an answer. What’s challenging here is that no public-facing TRIRIGA entity relationship diagrams exist and database table names are not published in TRIRIGA client-facing documentation. Even if you can determine the table name to look at (here, T_TRIRISKITEM), how do you find the specific fields you need? Is there a trick to finding what database field or column names are used when a TRIRIGA report or query is run?

Continue reading

Are there any public IBM TRIRIGA entity relationship diagrams?

Do any entity relationship diagrams (ERDs) or technical documents that would help an IBM client understand what TRIRIGA database tables exist and how they are associated to one another?

Unfortunately, the short answer is no. This information is all proprietary. No public-facing entity relationship diagrams or similar technical documents exist that explain TRIRIGA workings from a low-level, database perspective.

[Admin: A similar article is also posted in the IBM Support Portal.]

Continue reading

How do you upload spaces with “holes” using CAD Integrator?

In a related wiki: Only one gross area allowed per drawing.

In order to support multiple gross boundaries in a “single” boundary, you would create a single polyline, but join the two areas by connecting with a single line.  Similarly, you can use this idea to create a polyline with a “hole” in it (in order to subtract the areas).  However, you may find that the resulting figure is not detected on upload… Here, the Room 801 is not being detected… what happened?

Due to technical reasons, CAD Integrator uses a ray casting algorithm in order to determine that “Room 801” lies within the polyline.  In most cases, this involves shooting a ray directly to the right from the insertion point of the text entity.  Normally, the ray casting will determine that there is an odd number of lines intersecting (e.g. if shooting the ray up from 801, 3, down, 1, left 1).  However, since we have the “extra” line segment to the right of the text, we fail to determine that this text entity is within the polyline.  In general, the easiest way to fix this is to move the text entity…

Note that on some drawings, the ray will not be sent to the right. But in general, moving the text entity to the other side of the extra line will resolve this issue.

[Admin: This post is related to the 02.22.17 post in the IBM TRIRIGA forum about regions and gross areas with “holes”.]

Continue reading

Failing to see layers in TRIRIGA after publishing the drawing

We are using AutoCAD 2012 and CAD Integrator 10.2 and published a drawing. It doesn’t show the layers in TRIRIGA. However, layers are set to be visible in AutoCAD level. Any help in this regard is appreciated.

[Updated 02.02.17]

I know this is an old post, but I have the same problem. Has anyone found the solution? The problem seems random. In the DWG files, I have 6 layers “on” (a-wall, a-furn, a-pocc-zone-note, a-pocc-zone, a-pocc gros-ext, and a-pocc-gros-intr). All other layers are “off”. For some reason, on a drawing, after a publication in TRIRIGA, graphic location, the a-wall layer is “off”. I can manually activate it in the Layer Manager, but it will not stay “on”. I can verify in the drawing that the layer is “on”.

It might be due to a layer configuration turning it off. For example, we ship with a layer configuration filter that turns off any layer with more than 1000 entities on it. If you are on 3.4.2 or later, there is a logging option to turn on the layer configuration filtering logic in the Admin Console > Platform Logging > Graphics Section > Drawing Objects > Layer Filters. The logging should indicate if a layer is being turned off by some layer configuration filter “rule”. At the very least, it should determine if it is a layer filter turning it off, or some other issue.

Continue reading