So my company wants to change it's geographic org structure which means, for example, people in site 1 might now report to either site 2 or site 3, with site 1 going away.  Since it seems I can't change the location assignments in site 1 to either 2 or three, I am wondering how others may have handled this.  I could use an empty field in locations to put the new site assignments for a start and that have data copy over to all work orders (and assets, service addresses etc.). Just brainstorming at this point.

Hi Brian

So, you're retiring Site 1 and have created Site 2 and Site 3. You want to migrate data into Site 2 or Site 3 from Site 1.  I've done this using SQL.  Recently splitting one site into six and retiring the old site.  It's not just about the location, there are other records that need to be considered in this.

So my company wants to change it's geographic org structure which means, for example, people in site 1 might now report to either site 2 or site 3, with site 1 going away.  Since it seems I can't change the location assignments in site 1 to either 2 or three, I am wondering how others may have handled this.  I could use an empty field in locations to put the new site assignments for a start and that have data copy over to all work orders (and assets, service addresses etc.). Just brainstorming at this point.

So my company wants to change it's geographic org structure which means, for example, people in site 1 might now report to either site 2 or site 3, with site 1 going away.  Since it seems I can't change the location assignments in site 1 to either 2 or three, I am wondering how others may have handled this.  I could use an empty field in locations to put the new site assignments for a start and that have data copy over to all work orders (and assets, service addresses etc.). Just brainstorming at this point.

Hi Brian

I've been thinking more about this, and I would like some clarification.  What do you mean by "location assignments?"  This exists as part of the Maximo for Transportation solution, and has nothing to do with people.  Our assumption has been about splitting what was in Site 1 into Site 2 or 3.  An example:

Location hierarchy for Site 1:

• A
  • B
    • C
    • D
    • E
  • F
    • G
    • H

New location hierarchy for Site 2"

• B
  • C
  • D
  • E

New location hierarchy for Site 3"

• F
  • G
  • H

If this is the plan, then you need to understand all of the connected data, including historical data, that needs to be moved.  SQL is the most efficient, as you cannot do this through the frontend of Maximo.

If not, please help us correct our understanding again.

So my company wants to change it's geographic org structure which means, for example, people in site 1 might now report to either site 2 or site 3, with site 1 going away.  Since it seems I can't change the location assignments in site 1 to either 2 or three, I am wondering how others may have handled this.  I could use an empty field in locations to put the new site assignments for a start and that have data copy over to all work orders (and assets, service addresses etc.). Just brainstorming at this point.