Maximo Open Forum

Enock Onsase posted 01-09-2023 09:25

Yes, this is possible using migration manager, similar to other objects in Maximo.

An alternatively you could customize and use application import/export feature. See technote below for details. If your client if open for this customization, this should work for you.
How to import Inspection forms into Maximo (ibm.com)

Enock Onsase,
Genesis Solutions.

Henrik Söder posted 01-09-2023 11:47

I manage to create an objectstructure and load inspectionforms using MXLoader.

But have problem to export, had to do it in 3 stages and combine in excel.

Henrik Söder posted 01-26-2023 10:28

Hi!

Seems we got MXLoader to work for both Read and load now.

You need an objectstructure with Inspectionform, Inspquestion, Inspfield, Inspfieldoptions .......

And then columnheaders like:

INSPFORMNUM

NAME

DESCRIPTION_LONGDESCRIPTION

STATUS

REVISION

SITEID

ORGID

TYPE

INSPQUESTION.INSPQUESTIONNUM

INSPQUESTION.SEQUENCE

INSPQUESTION.GROUPSEQ

INSPQUESTION.DESCRIPTION

INSPFIELD.INSPFIELDNUM

INSPFIELD.REQUIRED

INSPFIELD.SEQUENCE

INSPFIELD.METERNAME

INSPFIELD.METERTYPE

INSPFIELD.FIELDTYPE

INSPFIELD.DOCTYPE

INSPFIELD.DESCRIPTION

INSPFIELD.INSPFIELDOPTION.DESCRIPTION.......

Good luck!

Venkataraman Guruswamy posted 02-05-2023 08:09

You can export from backend and import using insert scripts

Matis Dovydas posted 08-03-2023 07:59

@HENRIK SÖDER Well, ok, you can make simple questions inside that inspection form with MxLoader (created similar loader), but I can't figure out how to make sub-questions, how to load that with loader? Found out that there is possible to get information from already imported forms. Columnheaders like:

INSPQUESTION.INSPFIELD.INSPFIELDOPTION.COLOR,

INSPQUESTION.INSPFIELD.INSPFIELDOPTION.DESCRIPTION,

INSPQUESTION.INSPFIELD.INSPFIELDOPTION.HASLD,

INSPQUESTION.INSPFIELD.INSPFIELDOPTION.ICON,

INSPQUESTION.INSPFIELD.INSPFIELDOPTION.LANGCODE,

INSPQUESTION.INSPFIELD.INSPFIELDOPTION.REQUIREACTION,

INSPQUESTION.INSPFIELD.INSPFIELDOPTION.SEQUENCE,

INSPQUESTION.INSPFIELD.DESCRIPTION,

INSPQUESTION.INSPFIELD.FIELDTYPE,

INSPQUESTION.INSPFIELD.LANGCODE,

INSPQUESTION.INSPFIELD.REQUIRED,

INSPQUESTION.INSPFIELD.SEQUENCE,

INSPQUESTION.INSPFIELD.VISIBLE,

INSPQUESTION.GROUPID,

INSPQUESTION.LANGCODE

I dont know how to make or update those fields. Does anyone has MxLoader object structure for this? 

HENRIK SÖDER posted 08-20-2023 06:42

@Matis Dovydas I attached some info!
You should't update inspform if you already used them and have inspformresults, you should revise!
But if you don't have used them you can just delete using mxloader and reload with updated info.

Quite tricky with cascadeoptions due to numbers in TGT and SRC columns.

I hope this helps.
Good luck!

Jason VenHuizen posted 08-21-2023 09:48

Our VS Code extension handles exporting and importing inspection forms, including revisioning.  It is open so if you want to look into the scripts that perform these actions you can.

https://marketplace.visualstudio.com/items?itemName=sharptree.maximo-script-deploy

Matis Dovydas posted 08-22-2023 03:30

@HENRIK SÖDER Well thank you for some tips. I will try them. 

I would like to say, that I made some kind of loader, but It's too big and importing/uploading takes times. Actually there is three sheets which you need to go through step by step. There is also sub questions and when you try to load all questions at once, in user interface those questions is not sorting like in groups. Than you need to go in UI and manually sort/group those questions which makes that importing annoying. Image if you have 50+ questions in one inspection form. 

All the mess started when we tried to digitize thoes inspection forms from paper into IBM. 

Matis Dovydas posted 08-22-2023 03:32

Jason VenHuizen looks really advanced. I will take a look at this one too. Thank you for reply. 👀

Jason VenHuizen posted 08-22-2023 11:44

I should also add that there is a companion command line tool for the VS Code extension that can be used in a code pipeline to automated deployments.  Hope that is helpful.

https://www.npmjs.com/package/maximo-dev-tools