MxLoader

We want to Associate a new System to existing locations in MAM 7.6.1.2, but I can't figure out which MxSheet template to use (if there is one). 

I can create a new location and set it to the new system using the "Assets - Location hierarchy" template, but I can't associate the new system with an existing location. 

I would rather use MxLoader to build it than build it all by hand. 

Any suggestions?

------------------------------
Peter Zimmer
Buffalo Sewer Authority
------------------------------

I would like to do the same but I can't find a way.

Let me know if you (or someone else) found a solution.

Greetings

------------------------------
Francesco Oliarca
GEST S.p.A.
------------------------------

I did find the solution...

I wanted to add some locations to a new system while those locations already exist in the main system.

The solution was using the MXOPERLOC or the MHOPERLOC.

Just use the column "SITEID",  "LOCATION",  "LOCHIERARCHY.SYSTEMID" and  "LOCHIERARCHY.PARENT"

I write this procedure because I spended so much time looking for this "simple" solution and I just found it now.

Cheers

------------------------------
Francesco Oliarca
GEST S.p.A.
------------------------------

Original Message:
Sent: 03-15-2024 12:34
From: Francesco Oliarca
Subject: Add existing Locations to new System in MAM 7.6.1.2 using MxLoader 8.3.5

I would like to do the same but I can't find a way.

Let me know if you (or someone else) found a solution.

Greetings

------------------------------
Francesco Oliarca
GEST S.p.A.
------------------------------

Hi Peter! In Maximo I have that Object Structure. How you can see it's very simply: 

Main Object: LOCATIONS

Referenced object: LOCHIERARCHY with the relationship LOCHIERARCHY

Then you must resolve alias conflict (in my case, to all the fields with conflict in the LOCHIERARCHY table, I added the LOC prefix)

Attached I send you the csv used to import locations with their hierarchy and associated with the system.

In the same way you can import it using the "Import" in the "Location" application menu (I use it like this) as with MxLoader.

If it doesn't work to replicate it through MxLoader (you only have to add the header), I will try and send you a working one.

Regards!

------------------------------
Martin Fabra
ARSAT S.A.
------------------------------

Thanks Martin.  I will try it and let you know what happens.

------------------------------
Peter Zimmer
Buffalo Sewer Authority
------------------------------

Original Message:
Sent: 03-24-2024 10:55
From: Martin Fabra
Subject: Add existing Locations to new System in MAM 7.6.1.2 using MxLoader 8.3.5

Hi Peter! In Maximo I have that Object Structure. How you can see it's very simply: 

Main Object: LOCATIONS

Referenced object: LOCHIERARCHY with the relationship LOCHIERARCHY

Then you must resolve alias conflict (in my case, to all the fields with conflict in the LOCHIERARCHY table, I added the LOC prefix)

Attached I send you the csv used to import locations with their hierarchy and associated with the system.

In the same way you can import it using the "Import" in the "Location" application menu (I use it like this) as with MxLoader.

If it doesn't work to replicate it through MxLoader (you only have to add the header), I will try and send you a working one.

Regards!

------------------------------
Martin Fabra
ARSAT S.A.
------------------------------

Hi @Peter Zimmer! 

Here is the MxLoader file. I tried it and it works. My object structure is called ARS_LOCAT_P and the parent object is LOCATIONS.

Regards!

------------------------------
Martin Fabra
ARSAT S.A. - Actively seeking employment
------------------------------

Original Message:
Sent: 03-25-2024 10:11
From: Peter Zimmer
Subject: Add existing Locations to new System in MAM 7.6.1.2 using MxLoader 8.3.5

Thanks Martin.  I will try it and let you know what happens.

------------------------------
Peter Zimmer
Buffalo Sewer Authority
------------------------------


Original Message:
Sent: 03-24-2024 10:55
From: Martin Fabra
Subject: Add existing Locations to new System in MAM 7.6.1.2 using MxLoader 8.3.5

Hi Peter! In Maximo I have that Object Structure. How you can see it's very simply: 

Main Object: LOCATIONS

Referenced object: LOCHIERARCHY with the relationship LOCHIERARCHY

Then you must resolve alias conflict (in my case, to all the fields with conflict in the LOCHIERARCHY table, I added the LOC prefix)

Attached I send you the csv used to import locations with their hierarchy and associated with the system.

In the same way you can import it using the "Import" in the "Location" application menu (I use it like this) as with MxLoader.

If it doesn't work to replicate it through MxLoader (you only have to add the header), I will try and send you a working one.

Regards!

------------------------------
Martin Fabra
ARSAT S.A.