Tuesday, December 29, 2015

Workflow Tip - How to create role as dynamic persongroup in task node.

بسم الله الرحمن الرحيم


Hello Every body as you  know you are able to assign assignee  to the task node by use roles, unfortunately assigning group is fixed which mean you have create a role for each group which mean complected work in your WF design.  
In this tip, you will us one dynamic role for all groups.


My Scenario. in work order before begin work it must approved from responsible group for each location in the following steps I will create one dynamic role for all the responsible groups.

1   - Create a new attribute in locations Object as following
1.1 -  open Database Configuration APP goto-->System Configuration --> platform configuration-->DataBas Configuration.

1.2 - filter on Locations object,in attributes tab add new attribute as following:



Property Value
Attribute name ownergroup
same as object persongroups
same as attribute person group


1.3 - set admin mod on.
1.4 - apply configuration
1.5 - set admin mod of



2 - add new relation between locations object and persongroupteam object
2.1 - in relationship tap create new relationship as following


Property Value
Relationship LOCOWNERGROUP
Child Object PERSONGROUPTEAM
Where Clause PERSONGROUP = :ownergroup



2.2- save 

3- on application designer add the new attribute  to locations layout



4- Create new role as following


Property Value
Role LocOwnergr
description Location Owner group
type a set of data related to the record
Object workorder
value :LOCATION.LOCOWNERGROUP.RESPPARTYGROUP_PERSONS.personid


4.1- Save

5- Open Workflow designer .then yours process
5.1 - drag and drop task node ,then add the role in previews step
6.1 in Location application add the responsible group in the new attrubite which created in step 1.2.
that's all.
bye.

Sunday, December 6, 2015

Upgrade maximo 7.1 to 7.6 (new approach)

بسم الله الرحمن الرحيم
In previews incomplete post (here) I spoke about upgrade from 7.1 to 7.6, in this Post I'll upgrade with another approach, it's seems to me more fixable to do that we need 3 separated machine .

- Prepare the Requirements for upgrade process

1-   Install Maximo Asset Management 7.1. then install Fix Pack 7.1.1.12 (here) .
2-   Install Maximo Asset Management 7.5. then install Fix Pack 7.5.6 (here).
3-   Install Maximo Asset Management 7.1. then install Fix Pack 7.1.1.12 (here).

Not that : it is important the Database Engines in the previews 3 Installations  to be same like  the original .

- Upgrade Process 

1.1        Take Some System statistics

select count(*) from WORKORDER
select count(*) from PM
select count(*) from PR
select count(*) from PRline
select count(*) from Po
select count(*) from Poline
select count(*) from sr
select count(*) from JOBPLAN
select count(*) from JOBTASK

1.2        Upgrade Maximo from V7.1.X to V7.1.1.12

     1-   Form the previews installation of Maximo V7.1.1.12
Go to maximo.properts in C: /ibm/smp/maximo/applications/maximo/properties
And change the following properties
Properties
Value
mxe.db.user=
The username of Maximo DB which need to be upgrade to V7.1.1.12
mxe.db.password=
The Password of Maximo DB which need to be upgrade to V7.1.1.12
mxe.encrypted
false
mxe.db.url
The URL of Maximo DB which need to be upgrade to V7.1.1.12

  2-     Run Updatedb.bat  in windows Command line (CMD),which located in C: /ibm/smp/maximo/tools/maximo
        3 -      Wait until the script complete depend on your database  size it’s may be tack 0.5 day
  4 -      After Complete this step your Maximo DB will be compatible with Maximo V7.1.1.12
 

1.3        Upgrade Maximo from V7.1.1.12 to V7.5.0.6

                        Form the previews installation of Maximo V7.5.0.6
Go to maximo.properts in C: /ibm/smp/maximo/applications/maximo/properties
And change the following properties
Properties
Value
mxe.db.user=
The username of Maximo DB which need to be upgrade from V7.1.1.12
mxe.db.password=
The Password of Maximo DB which need to be upgrade from V7.1.1.12
mxe.encrypted
false
mxe.db.url
The URL of Maximo DB which need to be upgrade from V7.1.1.12

  2-     Run Updatedb.bat  in windows Command line (CMD),which located in C: /ibm/smp/maximo/tools/maximo
        3 -      Wait until the script complete depend on your database  size it’s may be tack some times
  4 -      After Complete this step your Maximo DB will be compatible with Maximo V7.5.0.6

1.4        Upgrade Maximo from V7.5.0.6 to V7.6

Form the previews installation of Maximo V7.6
Go to maximo.properts in C: /ibm/smp/maximo/applications/maximo/properties
And change the following properties
Properties
Value
mxe.db.user=
The username of Maximo DB which need to be upgrade from V7.5.0.6
mxe.db. password =
The Password of Maximo DB which need to be upgrade from V7.5.0.6
mxe.encrypted
false
mxe.db.url
The URL of Maximo DB which need to be upgrade from V7.5.0.6

   2-     Run Updatedb.bat  in windows Command line (CMD),which located in C: /ibm/smp/maximo/tools/maximo
        3 -      Wait until the script complete depend on your database  size it’s may be tack 0.5 day
  4 -      After Complete this step your Maximo DB will be compatible with Maximo V7.6


Kindly . Don't Publish this post without referring to My Blog as source
Best Regards
-------------------
Mahmoud Gaber