Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



Setting up another new Organization & How link with existing user data

From: shah faisal (2013-10-30 07:09)

Hi All,
Environment: Maximo 7.1 for service provider, MS Windows Server 2003, Web Sphere 6.1, Database (DB2 9.5)
Changes took place:
--------------------------
Our company name has been changed from 'Paul Brothers' to 'Paul International'. Even our Domain controllers(Windows 2003) and email server host name have also been changed.
In Maximo currently our company(Paul Brothers) is setup as an organization with 'PB(organization ID).
Planning:.
-------------
As we finished first phase finalized company logo, visiting cards and all related stationary. 
Now we are planning in Maximo, set up a new organization(Paul International - PI) and apply and link this new organization name(Paul International - PI) on existing  user data which is currently configured with existing organization (Paul Brothers - PB).
 
Question:
-------------:
1) Kindly help me how to do it. I want a road map?
2) I do not know all tables relationships, Can I know ? but How? to replace new organization id(PI) with existing one(PB).
3) What steps should I follow to apply new organization on existing user data after creating a new organization 
(Paul International - PI)
4) Is there any option in Maximo that automatically change organization with new one?
5) What are further changes are required to perform in Maximo system, database, web sphere?
I'll appreciate your cooperation and thanks in advance.
Regards
Shah


From: Ian Wright (2013-10-30 16:34)

First of all why change the orgid just change the description in the organisation application and leave the old code but if you absolutly have to change the value from PB___ to PI___
I don't think you have a lot of options other than to change the data in the database
I don't know the syntax for DB2 but here is a sql server version oracle uses || to concat I presume DB2 has something similar
select 'UPDATE '+objectname+' set '+attributename+' = '''+'NEW-ORGID'+''' where '+attributename+' = '''+'OLD-ORGID'+''';'
from maxattribute where (attributename = 'ORGID' or sameasattribute = 'ORGID') and persistent = 1
output like this
UPDATE ACCOUNTDEFAULTS set ORGID = 'NEW-ORGID' where ORGID = 'OLD-ORGID'
UPDATE ADDRESS set ORGID = 'NEW-ORGID' where ORGID = 'OLD-ORGID'
take a copy of your database and do lots of testing
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of shah faisal
Sent: 30 October 2013 14:10
To: Maximo Group
Subject: [MAXIMO List] Setting up another new Organization & How link with existing user data
Hi All,
Environment: Maximo 7.1 for service provider, MS Windows Server 2003, Web Sphere 6.1, Database (DB2 9.5)
Changes took place:
--------------------------
Our company name has been changed from 'Paul Brothers' to 'Paul International'. Even our Domain controllers(Windows 2003) and email server host name have also been changed.
In! Maximo currently our company(Paul Brothers) is setup as an organization with 'PB(organization ID).
Planning:.
-------------
As we finished first phase finalized company logo, visiting card! s and all related stationary.
Now we are planning in Maximo, set up a new organization(Paul International - PI) and apply and link this new organization name(Paul International - PI) on existing user data which is currently configured with existing organization (Paul Brothers - PB).
Question:
-------------:
1) Kindly help me how to do it. I want a road map?
2) I do not know all ! tables relationships, Can I know ? but How? to replace new organization id(PI) with existing one(PB).
3) What steps should I follow to apply new organization on existing user data after creating a new organization
(Paul International - PI)
4) Is there any option in Maximo that automatically change organization with new one?
5) What are further changes are required to perform in Maximo system, database, web sphere?
I'll appreciate your cooperation and thanks in advance.
Regards
Shah
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************