How does the University of California plan to manage their property assets across 10 campuses? By implementing an impressive new program called ICAMP – the Integrated Capital Asset Management Program. We caught up with Rich Powers, of the University of California Office of the President (UCOP) to find out how ICAMP enables visibility and integration across campus systems, and promotes efficient asset lifecycle management, too…
Defining the key elements of ICAMP
The ICAMP solution contains three solutions, all of which come together to support better decision-making:
- IBM TRIRIGA Cloud
- FieldFLEX Mobile.
UCOP chose the TRIRIGA platform to bring together all of their asset data into one integrated system. TRIRIGA lets you create a building inventory and location hierarchy. It has the capabilities required to manage those buildings throughout their lifecycle. Crucially, it supports facility condition assessment, or FCA. This is how they access every building component, from floor to ceiling, for health and performance. By using TRIRIGA, Rich’s team can overlay their building inventory with the FCA data to see which assets are most at risk, or in need of maintenance.
By combining this information with industry data from RSMeans, the team is able to estimate potential repair costs, then kick off opportunities from within TRIRIGA. UCOP also built a mobile FCA application with FieldFLEX Mobile that makes TRIRIGA available to technicians in the field. This carries the advantage of a streamlined inspection and assessment process. It allows architectural, electrical, and mechanical inspectors to look at their respective inventory elements and access asset data with ease. The application supports storing floor plans, uploading photos and videos, geo-tagging buildings and assets, and cross-referencing lifecycle data to help inspectors make better real-time assessments across the portfolio…
[Admin: To see other related posts, use the Cloud tag, FCA tag, RSMeans tag, or FieldFLEX tag.]
We want to integrate IBM TRIRIGA with FileNet using CMIS 1.1, but we need to know what is all of the standard metadata that TRIRIGA sends to FileNet. For example, the file name, date creation, date modification, document type, document size, TRIRIGA user owner, etc. And if it is possible to send custom metadata when creating new custom fields in the Document business object? How can we do it?
The following properties are sent as part of the integration: Document Name, Document Type, Document Path. The Owner is going to be the CMIS username as defined in the TRIRIGAWEB.properties. Further custom metadata is not supported. The purpose of the CMIS integration is to have the binary content not stored in the TRIRIGA database as BLOBs.
[Admin: This post is related to the 07.26.17 post about CMIS FileNet integration issues, and the 12.02.16 post about integrating with CMIS and ECM solutions. To see other related posts, use the CMIS tag or ECM tag.]
Does anyone have experience in project integration (data transfer) from an external existing project through any IBM TRIRIGA integration module? Our templates and mapping have been identified, but the question is about reproducing the overall standard when a project is created. This seems hard. In order to have this project consistent in TRIRIGA, we think that we need to be consistent with the following:
- Project and direct associations with business objects in perimeter
- Associated purchase orders
- Budget and their associated cost codes
- Financial data and their associated computation
Any help and experience would be great, even if the answer is it’s too hard.
Without detailed knowledge on the user’s part, such as a fundamental knowledge of all of the application functionality, it would really be best to engage IBM Services to implement this integration. It’s not impossible, but it really would need a lot of care.
[Admin: To see other related posts, use the Integration tag.]
We have an issue where sometimes after applying a cost code template to a project, the hierarchy path will not be complete. It will be missing all of the parent path and only shows the name. This issue is only visible in the app by viewing the System Path field inside the form or by using a SQL query, because the system path in the T_TRICOSTCODE table is correct, but the object path field in the IBS_SPEC table is the one that’s not complete. The issue does not have much consequence unless you are using the rollup fields, in which case the corrupt cost code path will cause a posted transaction to fail.
If there are customers who use cost codes heavily, you can try running the following SQL, and if you get any results back, then that means the issue is present at some level in your environment. It is not necessary that you use the Apply Template to create your cost codes, as I have heard of others having the issue where their cost codes are created via an integration. This SQL is for Oracle and may need a tweak for SQL Server. If any customers can run this, and see if they have the issue, it may help us identify how it happens.
select tripathsy, triprojectnamesy, OBJECT_PATH from t_tricostcode T1, IBS_SPEC T2 where T1.spec_id in (select spec_id from ibs_Spec where type_name = ‘triCostCode’ and object_path not like ‘%\Cost Code%’) AND T1.spec_id = T2.spec_id and tripathsy like ‘%\Cost Code%’
[Admin: To see other related posts, use the Cost Code tag or Templates tag.]
Revit models constructed for the purposes of fabrication, coordination and as-built conditions are typically not going to function well in a facilities environment if they are used “as is.” It’s important for AEC service providers and consultants to understand their customer needs. Chuck Mies from Autodesk sums this up best by posing the following three questions that you should be asking a building owner if they intend to use a Revit model for facilities management:
- Who on the facilities team is going to use the data?
- What data is going to be collected during the AEC process for future FM purposes, and how?
- How will it be maintained once operations begin?
By asking these questions and engaging a building owner you can have greater confidence that a Revit model turned over for the purposes of FM will be more successful and actually used during operations. I also recommend that you ask your customer to really think about what data is critical and who in their facilities team will be responsible for maintaining the information once the model is turned over. This will ensure that you don’t over model or provide excessive detail in equipment families that are not critical and will be difficult for a facilities team to maintain…
[Admin: To see other related posts, use the BIM tag or Revit tag.]
I am uploading a tab-delimited file and writing the data into a staging table using TRIRIGA integration object. While uploading the file, I need to restrict the number of lines that can be uploaded into the staging table. I am using DataConnect and a custom task to read the file from the binary field. But I am not able to read the file. How can we read the file from the integration object?
[Admin: To see other related posts, use the Integration Object tag, Staging tag, or DataConnect tag.]
I’m using the TRIRIGA integration object (File method) to import data into the space BO. I created the Data Map properly, but my records are not importing because of the following error:
“Could not get recordId for smartSection[triCurrentSpaceClass] on row, column with value. Record was not saved.”
Even though I selected the Smart Section filter and mapped it to triNameTX, the integration object fails. Any thoughts?
[Admin: To see other related posts, use the Integration Object tag.]