Maximo

 View Only

 Inspection form results export?

Ryan Nielsen's profile image
Ryan Nielsen posted Thu March 06, 2025 11:24 AM

Can you export the Inspection form results? For example, I need to collect field data on a Maximo inspection form and then export it as a .csv to import it into another database program.  If this is possible, I'm curious how the .csv file is structured (columns and headers).  This may dictate how the inspection form is set up since I will need to reference the specific collection point and result to define parameters in my other database for bulk import of that collected data.

Additionally, is it possible to export photos that are part of inspection results?

Amy Tatum's profile image
Amy Tatum IBM Champion posted Fri March 07, 2025 08:33 AM

Hi Ryan,

You can export the inspection form results.  They are stored in the INSPECTIONRESULT and INSPFIELDRESULT tables.  I found the image below which helps explain the relationships between the inspection tables and the results tables.  This is a little outdated as I don't see the INSPFIELDRESULTSELECTION table listed, which is used to store the multi select responses if you have any of those.  The primary keys and links are all IDs, so it takes a few hops to get back to the actual question if you need that in your export.  Also be careful of form revisions or when moving between environments as those numbers can change.  

Good luck!

Amy

Related Content