Thursday, October 27, 2016

Checklist before leaving Canada back to your home country

5 Important things to be done while relocating back to India from Canada.

1.Backup all your proofs which show you visited and worked in Canada

   Below are the documents which i want you to take backup as these documents can be very useful for you if you are applying PR etc
    1. Company Payslips
    2. Bank Statements- Please get them from starting of your back accounts. Ideally get them from bank with a bank seal on it.It might be useful for applying loan in India
    3.Lease agreements
    4.Company offer letters

2. Zero stains on your credit history

    Below are the points to be taken to make sure you have no bad credit history. This will help in getting easier loans if you ever back in Canada.
    1.Pay all the credit card dues and close them
    2.Pay all your phone bills and cancel the connection.
    3.Pay your rents and get a no objection certificate if possible.
    4.Pay your driving tickets and other tickets.

3. Be careful with your bank

    As you may be filling taxes and you might get some refunds it is always advisable to have one bank account active. Most of the Canadian banks charge for checking's account if you don't have enough balance. My advise is to close your checking's account and have only savings bank account. Advantage of savings bank is it gives you money on the funds you have and generally deposits are not charged only withdrawals are charged. If you are closing down your checking account please make sure you update below websites just to make money gets deposited properly into your account
    1. Update CRA - Canada Revenue Agency
    2.Update your personal / medical/vehicle insurance company
    3.Update your Working company which pays your salary.
    4.Update your Rental company
    5. Update the websites from which you do money transfers

4.Update CRA
As you are relocating i would suggest you to update CRA - Canada revenue Agency about your departure from the country. This will help CRA to calculate your taxes properly and process returns.

5.Make proper contacts.

 As Canadian job market is very small and each every person is connect with other people it is always better to have proper contacts, so I request you to give your details and all the required people to LinkedIn , Facebook etc.

As you would be moving back to your country , try to do a break over journey in Toronto or Vancouver etc places and appreciate the Canadian lifestyle.

If you like this post or have some more points to be added please write in the comment.


----------------------------------------------------------------------------

All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Monday, September 26, 2016

IBM Maximo : Calling a report from a push button in Maximo

Idea here is to launch a report from a push button on any screen. In this way business can run a specific report by clicking a button in the screen itself.

1.       Find the report which you want to run (ex: woprint.rptdesign) and hit the database to find the report number and execute below query

select reportnum,reportname,appname from report where reportname='woprint.rptdesign' and APPNAME='WOTRACK';



2.       From Report Library file (REPLIBRARY) and search for reportnum="351" , note the id related to it (highlighted)






id="reportd351"
label="Request Page" mboname="WORKORDER" reportnum="351" reporttype="BIRT" width="550">

3.       Navigate to application designer, search for WOTRACK and a new button with details like
Event : reportd351 and save it



4.       From Work Order Tracking application , you can see a Print Report button, when you click it shows report page like below




And on Submit, it generates the report.




----------------------------------------------------------------------------
 All the messages
below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Tuesday, September 20, 2016

Maximo Environment refresh- Naming environments

-- Below are the scripts which can be executed after production refreshes to make sure every environment is named from login screen etc.
Below is a example where we are trying to set values in a system as Development Environment


------ Messages on the Login Screen -----

--Login Button ---
update maximo.maxmessages set value = 'Sign In to Development' where msgkey = 'loginbutton' and msggroup = 'login';

-- Welcome Message ---
update maximo.maxmessages set value = 'You are in Development' where msgkey = 'welcome' and msggroup = 'login';

update maximo.maxmessages set value = 'Welcome to Development' where msgkey = 'welcomemaximomessage' and msggroup = 'login';

update maximo.maxmessages set value = 'Welcome to Development, {0}' where msgkey = 'welcomeusername' and msggroup = 'login';

-- Maximo Log Out Messages ----
update maximo.maxmessages set value = 'All users will be logged out of Development Environment in {0} minutes. Save your work.' where msgkey = 'AdminLogoutSubject';

update maximo.maxmessages set value = 'Maximo configuration in progress on Development Environment' where msgkey = 'AdminLogoutMessage';

--- Maximo Application ----

update maximo.maxapps set description = 'DEV - ' || description;

commit;



----------------------------------------------------------------------------
 All the messages below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Saturday, September 17, 2016

World's oldest Mosques in India to which every Indian Muslim should visit

I feel every Indian Muslim should visit these 2 mosques which were bulit when Prophet Muhammad was alive and also request respective states to improve tourism facilities

Cheraman Juma Mosque


Cheraman Juma Mosque which was bulit in 629 AD by Malik Deenar, an Arab propagator of Islam and a follower of Prophet Muhammad on the land given by
Cheraman Perumal, the Chera king of Kerala.


Many traders from Arab countries used to visit Malabar region of Kerala, in the process they also propogated Islam into this region.
As the legend goes, Cheraman Perumal (king) visited Arabia and converted himself to a true follower of Islam. He changed his name to Tajuddin.
Unfortunatly he couldnt visit Cheraman Juma Mosque as he died while coming back to his kingdom. He is now buried in Oman.

This mosque is located in NH 66, Kodungallur, Trichur Kerala 680664.
More details can be found on the mosque website :http://cheramanmosque.com


You can plan visit check Tripadvisor site : https://www.tripadvisor.ca/Attraction_Review-g2285465-d2709126-Reviews-Cheraman_Juma_Masjid_Mosque-Kodungallur_Kerala.html
FB Page : https://www.facebook.com/Cheraman-Juma-Masjid-The-First-Masjid-in-Hindustan-344554142298708/




Palaiya Jumma Palli


This mosque was bulit around 630 AD in Kilakarai, Tamil Nadu. Similar to Cherman Juma Mosque history it was also constructed in a port city by traders from Yeman.
This mosque looks like a temple from outside and mosque inside.This also shows how Islamic culture came to india much before Mughals came to India.


Website: I couldnt find if this mosque has any website.
You can plan visit :As i didnt find any good hotels near by, i would prefer to stay in Rameswaram or Madurai.

FB page : https://www.facebook.com/pages/Palaiya-Jumma-Palli/195504303966184

----------------------------------------------------------------------------
All the messages below/above are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Tuesday, September 13, 2016

Maximo Automation Script : To make field value to remove special characters and to make it in upper case

Below script is used to remove the special characters and make values in the field to uppercase

Script
------
Name : ASSET-DESCRIPTION-REMOVE-SPLCASE
Language : jython

Launch Points
-------------
Name : ATT-REMOVE-SPLCASE
Active : 1
Object : Asset
Attribute : DESCRIPTION

Autoscript
----------

from psdi.util.logging import MXLogger
from psdi.util.logging import MXLoggerFactory
from psdi.mbo import MboConstants
from psdi.util import MXApplicationException

logger = MXLoggerFactory.getLogger("maximo.script");
logger.debug("==================== ATT-REMOVE-SPLCASE." + launchPoint + ": START =====================")

#This script reformats the Description field to only have alphanumeric uppercase characters
#Characters A-Z and 0-9 inclusive are permitted.

description = mbo.getString("DESCRIPTION")
description = ''.join(i for i in description if i.isalnum())
description = description.upper()
mbo.setValue("DESCRIPTION", str(description), 2)

logger.debug("==================== ATT-REMOVE-SPLCASE." + launchPoint + ": END =====================")
----------------------------------------------------------------------------
All the messages
below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Discardable MBOSET / MBO in IBM Maximo

·         These can be used on MBOSETS which are used for traversing forward only ie looping in
·         They should not be used while doing edit/save etc operations
·         Mboset will not cache the MBOs as it fetches from directly from database. This will minimise the JVM memory usage.
·         Discardable Mbo Sets are always read only.

Example below to make a MBOset discardable

MboSetRemote personSet = getMboSet("PERSON");
personSet.setFlag(MboConstants.DISCARDABLE, true);




----------------------------------------------------------------------------
All the messages below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Wednesday, August 24, 2016

Lord Krishna ..Master Strategist

This is a small story which tells Lord Krishna is a natural leader and master strategist.

In Vrindavan there was a powerful raging bull named as Hastin. It was so big ,arrogant and always willing to fight. People kept him because he was the source of a whole breed of cows in Vrindavan but he was so violent and dangerous that no one dared to go near him. Balram, brother of Lord Krishna always said that he want to become so strong that he can kill Hastin in one punch. That was the strength of the Bull.

One day during a friendly conversation Krishna declared that he would ride on Hastin by next full moon day for which all his friends laughed including his brother thinking it was an impossible act  . Time passed by ,just 2 days before next full Moon day Balram asked Krishna if he would be riding on Hastin just to make fun of him. Krishna asked everyone to wait till full moon day.

On full moon day, Krishna along with Radha rode on Hastin making every one in the village surprised.



Below is the approach / strategy Lord Krishna followed to make things happen (Here riding the dangerous Bull Hastin)

·         Every day (from the day of promising to ride the bull), Lord Krishna would spend some good quality of time understanding about the Bulls behavior.
·         He observed that Bull was always fed by 2 people who were always servicing the bull from its childhood.
·         With their permission , he would sit near the bull every day and play the flute for the bull
·         After few days bull became little tame to Lord Krishna, slowly he started feeding the bull with jiggery and straw.
·         Within a month he became close to the bull
·         On the final day he got what he has to achieve.





Lord Krishna has understood the problem ,  developed a proper strategy and executed it successfully.

This story is little modified from the source to make sure it is more related to the context





----------------------------------------------------------------------------
 All the messages below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Thursday, August 18, 2016

Aditi Ashok ...Lady Golfer ..Quick Biodata and interesting facts



Name : Aditi Ashok
Father :Pandit Gudlamani Ashok
Mother : Maheshwari
Date of Birth : 29th March 1998
Age : 18 years
Birth Location : Banglore, India
Sport : Golf
Coach : Steven Giuliano (Golf) and Nicolas Cabaret (Fitness)
Favourite Golfer :SEVE BALLESTEROS
Favorite course :Old Course at St. Andrews
Aditi with her father
Interesting facts

1.Ashok Aditi is the youngest player in Rio Olympics Golf Team

2.Aditi started playing at the age 5 1/2 years 
3.Aditi played her first tournment at age of 7 years 
4.Aditi turned to a professional on Jan 1st 2016 and within 8 months she is representing India in Olympics.
5.Aditi always carry some lucky charms for every match
6.Aditi has a own website http://www.aditiashok.com/

7.Aditi watched her first professional ladies golf match in year 2008.

8.Aditi has her father a caddie




----------------------------------------------------------------------------
 All the messages above are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Wednesday, August 17, 2016

Sakshi makes Indians proud ..... Sakshi Quick Biodata



Name : Sakshi Malik
Father :Sukbhir Malik
Mother : Sudesh Malik
Date of Birth : 3rd Jan 1993
Age : 23 years
Birth Location : Rohtak, Haryana , India
Sport : Freestyle Wrestling
Coach : Ishwar Dahiya
Employee : Indian Railways
Major Wins

Bronze in Rio Olympics - 2016
Bronze in Doha Asian Champions -2015
Sliver in Glasgow Common wealth Games - 2014









---------------------------------------------------------------------------- All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Wednesday, July 20, 2016

Maximo : Populating ownergroup with a person group a user belongs to

 Below script is used to populate a field (Owner Group) in work order application with logged in users person group.

Launch point 
------------------
Name : KS_OBJ_OWNERGROUP
Desc : Launch Point for User
Intialize = Y
Condition : 
Object : WORKORDER

Autoscript :
Name : KS_OWNERGROUP
Desc : Load person group

from psdi.util.logging import MXLogger
from psdi.util.logging import MXLoggerFactory
from psdi.mbo import MboConstants
from psdi.server import MXServer


logger =  MXLoggerFactory.getLogger("maximo.script");
logger.debug("====================KS_OWNERGROUP." + launchPoint + ": START  =====================")
mboServer = mbo.getMboServer()
user1 = mbo.getUserInfo()
personGroupQuery = "persongroup in (select distinct a.persongroup from persongroup a, persongroupteam b  where b.RESPPARTYGROUP = '"+user+"' and rownum<2 div="">
personGroupMboSet = mboServer.getMboSet("persongroup",user1)
personGroupMboSet.setWhere(personGroupQuery)
personGroupMboSet.reset()
if not personGroupMboSet.isEmpty():
 personGroupMbo=personGroupMboSet.getMbo(0)
 mbo.setValue("OWNERGROUP",personGroupMbo.getString("persongroup"),MboConstants.NOACCESSCHECK|MboConstants.NOVALIDATION_AND_NOACTION)
logger.debug("====================YYZ_OBJ_USERGROUP." + launchPoint + ": END  =====================")




----------------------------------------------------------------------------
 All the messages below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Monday, July 11, 2016

Fetch PO's which have been receipts completed more than 90 days

Below query would fetch list of PO's record which have all the receipts closed before 90 days.

select ponum,REVISIONNUM,status from maximo.PO where
 status='APPR' and receipts='COMPLETE' and
 exists (select 1 from (select transdate from (
 select max(TRANSDATE) transdate from maximo.SERVRECTRANS
 where ponum=po.ponum group by ponum union select
 max(TRANSDATE) transdate from maximo.MATRECTRANS where
 ponum=po.ponum group by ponum ) order by transdate desc )
 where rownum <2 and="" p="" sysdate-transdate=""> >90)

using this query we can write an escalation which can change status of PO to COMPLETE or close etc

----------------------------------------------------------------------------
 All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Tuesday, April 26, 2016

using array in Maximo Automation script


from psdi.util.logging import MXLogger
from psdi.util.logging import MXLoggerFactory
from psdi.mbo import MboConstants
from jarray import array

logger = MXLoggerFactory.getLogger("maximo.script");
logger.debug("==================== ATT_WO_WOPRIORITY." + launchPoint + ": START =====================")

# declaring as a set of double values
arrSubDiv = array([1,2,3,4,5,6],'d')

woPriority = mbo.getDouble("WOPRIORITY")

for i in arrSubDiv:
 if (i==woPriority):
   mbo.setFieldFlag("JUSTIFYPRIORITY",MboConstants.REQUIRED, True)
else:
   mbo.setFieldFlag("JUSTIFYPRIORITY",MboConstants.REQUIRED, False)


logger.debug("==================== ATT_WO_WOPRIORITY." + launchPoint + ": END =====================")





----------------------------------------------------------------------------
 All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Tuesday, April 19, 2016

Get a list of included/excluded/Non Persistent/Persistent fields used in a Integration Object in Maximo.

Below query fetches list of records which have been used in integration object in Maximo .Here i took the example of Integration Object = MXASSET

select * from (
select distinct i.intobjectname,m.objectname,m.attributename,   'INCLUDE' as intobjfldtype from maximo.maxattribute m,maximo.MAXINTOBJCOLS i, maximo.MAXINTOBJDETAIL intobjdtl  where i.INTOBJECTNAME in ('MXASSET')
and intobjdtl.INTOBJECTNAME in ('MXASSET') and m.objectname=intobjdtl.objectname and m.attributename not in (select b.name from maximo.MAXINTOBJCOLS b where b.INTOBJECTNAME in ('MXASSET')) and m.persistent != 0
union
select distinct i.intobjectname, m.objectname,m.attributename, i.intobjfldtype from maximo.maxattribute m,maximo.MAXINTOBJCOLS i where i.INTOBJECTNAME in ('MXASSET') and i.intobjfldtype='EXCLUDE'
and m.objectname=i.objectname and m.attributename in (select  b.name from maximo.MAXINTOBJCOLS b where b.INTOBJECTNAME in ('MXASSET')  and intobjfldtype in ('EXCLUDE')) and m.persistent != 0
union
select distinct i.intobjectname, m.objectname,m.attributename, i.intobjfldtype from maximo.maxattribute m,maximo.MAXINTOBJCOLS i where i.INTOBJECTNAME in ('MXASSET') and i.intobjfldtype='NONPERSISTENT'
and m.objectname=i.objectname and m.attributename in (select  b.name from maximo.MAXINTOBJCOLS b where b.INTOBJECTNAME in ('MXASSET')  and intobjfldtype='NONPERSISTENT')) order by objectname,attributename



----------------------------------------------------------------------------
 All the messages below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Monday, April 18, 2016

Fixing LocAncestor Data integrity In Maximo


·         Take a backup of existing database table using below query
o   create table locancestor_bkp as (select * from locancestor);

·         Create a new procedure like this below and execute it.
*******************************************************************
create or replace procedure BUILD_LOCANCESTOR as

  MODULE_NAME varchar2(50) := 'LOCATIONS';
  SCRIPT_NAME varchar2(50) := 'BUILD_LOCANCESTOR.sql';
  TABLE_NAME  varchar2(50) := 'LOCANCESTOR';
  ERROR_COUNT number := 0; --Track no of errors
  REC_COUNTER number := 0; --Track no of loaded records
  R           number := 200; --Number of records to commit

  V_MAX_ID number;

  cursor LOCATIONS_CUR is
    select L.LOCATION, L.ORGID, L.SITEID, L.SYSTEMID from LOCHIERARCHY L;

  FIX_LOCATION LOCATIONS.LOCATION%type;
  FIX_SITEID   LOCATIONS.SITEID%type;
  /*These two variables are to hold the LOCATION and SITEID of the location
  for which we are building the hierarchy (the entries in LOCANCESTOR table)*/

  X_LOCATION LOCATIONS.LOCATION%type;
  X_SITEID   LOCATIONS.SITEID%type;
  /*These two variables are to hold the LOCATION and SITEID of the current location in the loop*/

  X_ANCESTOR_LOCATION LOCATIONS.LOCATION%type;
  X_ANCESTOR_SITEID   LOCATIONS.SITEID%type;
  /*These two variables are to hold the LOCATION and SITEID of the ancestor
  of the current location in the loop*/

begin
 

  execute immediate ('TRUNCATE TABLE ' || TABLE_NAME);
  execute immediate ('ALTER TABLE ' || TABLE_NAME || ' NOLOGGING');

  --RESET_SEQUENCE(TABLE_NAME);

  for LC in LOCATIONS_CUR loop
    declare
      FIX_SYSTEMID LOCHIERARCHY.SYSTEMID%type;

    begin
      FIX_LOCATION := LC.LOCATION;
      FIX_SITEID   := LC.SITEID;
      --These two variables will be fixed all the inner loop

     

      FIX_SYSTEMID := LC.SYSTEMID;

      X_LOCATION := LC.LOCATION;
      X_SITEID   := LC.SITEID;
      --These two variables will be changed for each iteration of the inner loop

      loop
        --Inner loop to build all LOCANCESTOR entries for the current location (FIX_LOCATION, FIX_SITEID)
        REC_COUNTER := REC_COUNTER + 1;

    

        insert /*+ APPEND */
        into LOCANCESTOR
          (LOCATION, ANCESTOR, SYSTEMID, SITEID, ORGID, LOCANCESTORID)
        values
          (FIX_LOCATION, --LOCATION
           X_LOCATION, --ANCESTOR
           FIX_SYSTEMID, --SYSTEMID
           LC.SITEID, --SITEID
           LC.ORGID, --ORGID
           LOCANCESTORSEQ.NEXTVAL --LOCANCESTORID
           );

        select max(H.PARENT), max(H.SITEID)
          into X_ANCESTOR_LOCATION, X_ANCESTOR_SITEID
          from LOCHIERARCHY H
         where H.LOCATION = X_LOCATION
           and H.SITEID = X_SITEID
           and H.SYSTEMID = FIX_SYSTEMID;

        if (X_ANCESTOR_LOCATION is null) then
          /*If there is no parent of the current location,
          so it's the top level one and we have to exit the inner loop*/
          exit;
        else
          X_LOCATION := X_ANCESTOR_LOCATION;
          X_SITEID   := X_ANCESTOR_SITEID;
        end if;
      end loop; --End the inner loop

    exception
      WHEN DUP_VAL_ON_INDEX THEN
        null;
      when others then
        ERROR_COUNT := ERROR_COUNT + 1;
       
    end;

    commit;
  end loop;

  commit;

  execute immediate ('ANALYZE TABLE ' || TABLE_NAME ||
                    ' COMPUTE STATISTICS');
  execute immediate ('ALTER TABLE ' || TABLE_NAME || ' LOGGING');

  DBMS_OUTPUT.PUT_LINE(TABLE_NAME || ' errors = ' || ERROR_COUNT);

 
end BUILD_LOCANCESTOR;
/
************************************************************
---------------------------------------------------------------------------- 
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Friday, April 15, 2016

Never Give Up.. For those who don't want to give up

Once upon a time a father was very frustrated with his son because he did not seem very manly though he was already sixteen years old. The father went to see a Zen master and asked the master to help his son become a real man. The master said: "I can help you; however, you will have to leave your son at my place for three months. For the whole period, you are not allowed to come to see him. I will assure your satisfaction after the three months." As promised, the father did not come back until three month later. The master arranged a karate match to show the father the training result. When the competition was starting, the father found out that the opponent was a karate trainer. The trainer certainly made sure that he was fully prepared to win before he started to attack. On the other side, the son fell on the floor as soon as he was attacked without any resistance. However, the boy did not surrender and got up immediately after he fell. It went on like this for no fewer than twenty times. His father was embarrassed and felt pain but dared not say anything. The boy lost badly when the match was over. The master asked the father: "Don't you think your son was showing manliness?" "I felt ashamed of him! After three months' training, what kind of result is this?! He is so weak and falls to the floor as soon as he is attacked. I don't think he is manly at all." The father was very disappointed. The master said: "I am sorry that you only look at the superficial forms of failure and success. Didn't you notice that your son had courage and bravery for standing up after his falls? It is a success if the standing-ups are more than falls, which is what a real man should possesses." The father had a sudden enlightenment and thanked the master deeply, and then he took his son home. 

Enlightenment from the Story: We should not just focus on instant results when we do something. The experiences gained and the effort given are the most precious. If one's life is always smooth, he/she will not taste the final sweetness of success after many tries without giving up. The really important virtue is to remember experiences and lessons from failures and bravely move forward to the road of success after planning a new.


----------------------------------------------------------------------------

All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Monday, April 11, 2016

Maximo automation script... Jython code similar to string Starts with


from psdi.util.logging import MXLogger
from psdi.util.logging import MXLoggerFactory
from psdi.mbo import MboConstants

logger = MXLoggerFactory.getLogger("maximo.script");
siteVar=str(mbo.getMboValue("SITEID"))
## Below line does action similar to starts with in string. It compares if site variable starts with KSK or not, if it doesnt start it alerts the user
if(siteVar[:len("KSK")] <> "KSK"):
 logger.debug("Site validation")
 errorgroup = "Site"
 errorkey ="Checksite"


ref : Reference Link


----------------------------------------------------------------------------
 All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Monday, March 28, 2016

Dont mess with wives





After 37 years of marriage. Jake dumped his wife for his Young secretary. His new girlfriend demanded that they live in Jake and Edith’s multi million dollar home and since the man’s lawyers were a little better he prevailed. He gave Edith his now ex-wife just 3 days to move out. She spent the 1st day packing her belongings into boxes crates and suitcases. On the 2nd day she had to movers come and collect her things. On the 3rd day she sat down for the last time at their beautiful dining room table by candlelight put on some soft background music and feasted on a pound of shrimp a jar of caviar and a bottle of Chardonnay. When she had finished she went into each and every room and stuffed half-eaten shrimp shells dipped in caviar into the hollow of all of the curtain rods. She then cleaned up the kitchen and left. When the husband returned with his new girlfriend all was bliss for the first few days. Then slowly the house began to smell. They tried everything cleaning mopping and airing the place out. Vents were checked for dead rodents and carpets were cleaned. Air fresheners were hung everywhere. Exterminators were brought in to set off gas canisters during which they had to move out for a few days and in the end they even replaced the expensive wool carpeting. NOTHING WORKED. People stopped coming over to visit. Repairman refused to work in the house. The Maid quit. Finally, they could not take the stench any longer and decided to move. A month later even through they had cut their price in half they could not find a buyer for their stinky house. Word got out and eventually even the local realtors refused to return their calls. Finally they had to borrow a huge sum of money from the bank to purchase a new place. The ex-wife called the man and asked how things were going. He told her the saga of the rotting house. She listened politely and said that she missed her old home terribly and would be willing to reduce her divorce settlement in exchange for getting the house back. Knowing his ex-wife had no idea how bad the smell was… he agreed on a price that was about 1/10th of what the house ha been worth, but only if she were to sign the papers that very day. She agreed and within the hour his lawyers delivered the paperwork. A week later the man and his girlfriend stood smiling as they watched the moving company pack everything to take to their new home. INCLUDING THE CURTAIN RODS. :) -
















----------------------------------------------------------------------------
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Friday, March 11, 2016

Hameed and his teacher

A small boy named Hameed lived in a village in Morocco. None of his classmates liked him because of his stupidity, especially his teacher, who was always yelling at him "You are driving me crazy Hameed!!!!!"


One day hameed's mother came into school to check on how he was doing. The teacher told his mother honestly, that her son is simply a disaster, getting very low marks and even she had never seen such a dumb boy in her entire teaching career!!!! The mother was shocked at the feedback and withdrew her son from the school & even moved to another town!!!!!




25 years later, the teacher was diagnosed with an incurable cardio disease! All the doctors strongly advised her to have an open heart operation, which only one surgeon could perform.......




Left with no other options, the teacher decided to have the operation, which was successful...... When she opened her eyes after the surgery she saw a handsome doctor smiling down at her! She wanted to thank him, but could not talk. Her face started to turn blue, she raised her hand, trying to tell him something but eventually died!


The doctor was shocked and was trying to work out what went wrong, when he turned around he saw our friend Hameed, working as a cleaner in the clinic, who had unplugged the oxygen equipment to connect his Mobile Charger !!!!!






Don't tell me you thought that Hameed became a doctor???? :D :D

Good Day..Have a great Week ahead :) collapse


----------------------------------------------------------------------------
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Wednesday, February 24, 2016

Adding messages in processing rules of Enterprise services in Maximo

Below are the steps which are to be followed to make sure messages can be properly added in enterprise services à processing rules.

·         Create an entry in Messages from database configuration making sure that messagegroup value is ‘iface’  example below
o   Message Group :iface
o   Message Key : VALIDATIONALERT
o   Display Method : MSGBOX
o   Value : Alerting user

·         Now navigate to Enterprise services à Processing rules and select this value from lookup attached to Message Key.


----------------------------------------------------------------------------
 All the messages below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Friday, February 19, 2016

Fetching last 6 months data in Maximo using SQL Server with output in a specific language

Below is one of the best ways to find number of tickets created in last 6 months in Maximo using SQL Server database in a specific language.
here i am using Portugese as lanuage in which my output should be

Query is self explanatory


select CASE month
WHEN  'January' THEN 'Janeiro de'
WHEN  'February' THEN 'Fevereiro'
WHEN  'March' THEN 'Março de'
WHEN  'April' THEN 'Abril'
WHEN  'May' THEN 'Maio'
WHEN  'June' THEN 'Junho de'
WHEN  'July' THEN 'Julho'
WHEN  'August' THEN 'Agosto'
WHEN  'September' THEN 'Setembro de'
WHEN  'October' THEN 'Outubro'
WHEN  'November' THEN 'Novembro de'
  ELSE 'Dezembro de'
END month,countoftickets from ( SELECT DATENAME(MONTH,DATEADD(month, -5, GETDATE())) month,COUNT(*) AS countoftickets , 1 as fs FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -5, GETDATE())) union  SELECT DATENAME(MONTH,DATEADD(month, -4, GETDATE())) month,COUNT(*) AS countoftickets , 2 as fs FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -4, GETDATE())) union  SELECT DATENAME(MONTH,DATEADD(month, -3, GETDATE())) month,COUNT(*) AS countoftickets , 3 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -3, GETDATE())) union  SELECT DATENAME(MONTH,DATEADD(month, -2, GETDATE())) month,COUNT(*) AS countoftickets , 4 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -2, GETDATE())) union  SELECT DATENAME(MONTH,DATEADD(month, -1, GETDATE())) month,COUNT(*) AS countoftickets , 5 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -1, GETDATE())) union  SELECT DATENAME(MONTH,DATEADD(month, 0, GETDATE())) month,COUNT(*) AS countoftickets , 6 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, 0, GETDATE()))  ) a1  order by fs

output:

month countoftickets
Setembro de 0
Outubro 0
Novembro de 0
Dezembro de 22
Janeiro de 57
Fevereiro 34






----------------------------------------------------------------------------
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Thursday, February 18, 2016

Displaying data ticket count with in SLA by priority in MAXIMO using SQL Server.

Below query can be used for displaying data ticket count with in SLA by priority in MAXIMO using SQL Server.

Data would be displayed like below

Priority          Count Status
1                 1        SLA OK
1                   2        SLA NOT OK
3                  15      SLA OK


Query :

select internalpriority,count(*) count, 'SLA NOT OK'  status  from TICKET where targetcontactdate is not null and actualcontactdate is not null and targetcontactdate - actualcontactdate <0 -="" actualcontactdate="" and="" by="" count="" from="" group="" internalpriority="" is="" nbsp="" not="" null="" ok="" select="" status="" targetcontactdate="" ticket="" union="" where="">=0 group by internalpriority










----------------------------------------------------------------------------
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Display Number of tickets solved with in SLA by person in Maximo .. SQL Server

Below query can be used for displaying data solved with in SLA by person in MAXIMO using SQL Server.

Data would be displayed like below

AffectedPerson Count Status
ABC                   1        SLA OK
ABC                   2        SLA NOT OK
XYZ                   15      SLA OK


Query :

select affectedperson,count(*) count, 'SLA NOT OK'  status  from TICKET where targetcontactdate is not null and actualcontactdate is not null and targetcontactdate - actualcontactdate <0 -="" actualcontactdate="" affectedperson="" and="" by="" count="" from="" group="" is="" nbsp="" not="" null="" ok="" select="" status="" targetcontactdate="" ticket="" union="" where="">=0 group by affectedperson







----------------------------------------------------------------------------
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Tuesday, February 16, 2016

Displaying tickets created from different sources in Maximo using Sql Server

Below query can be used to display number of tickets which are created from different sources(here external systems) as per months.

Output would be like below

Source  Month count
Email    Dec       10
Email     Jan        14
Phone    Jan         15
self Serv  Dec      05

Query:

select externalsystem,DATENAME(MONTH,DATEADD(month, 0, creationdate)) month ,count(*) count  from TICKET  group by externalsystem , DATENAME(MONTH,DATEADD(month, 0, creationdate))








---------------------------------------------------------------------------- All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Sunday, February 7, 2016

Fetching Last 6 months data in SQL Server for Maximo

Below is one of the best ways to find number of tickets created in last 6 months in Maximo using SQL Server database.

Query is self explanatory

select month,countoftickets from (
SELECT DATENAME(MONTH,DATEADD(month, -5, GETDATE())) month,COUNT(*) AS countoftickets , 1 as fs FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -5, GETDATE())) union
SELECT DATENAME(MONTH,DATEADD(month, -4, GETDATE())) month,COUNT(*) AS countoftickets , 2 as fs FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -4, GETDATE())) union
SELECT DATENAME(MONTH,DATEADD(month, -3, GETDATE())) month,COUNT(*) AS countoftickets , 3 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -3, GETDATE())) union
SELECT DATENAME(MONTH,DATEADD(month, -2, GETDATE())) month,COUNT(*) AS countoftickets , 4 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -2, GETDATE())) union
SELECT DATENAME(MONTH,DATEADD(month, -1, GETDATE())) month,COUNT(*) AS countoftickets , 5 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -1, GETDATE())) union
SELECT DATENAME(MONTH,DATEADD(month, 0, GETDATE())) month,COUNT(*) AS countoftickets , 6 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, 0, GETDATE()))  ) a1
order by fs

output:

Month   Countoftickets
October 10
November 12
December   5
January   17
February 20
March 15











---------------------------------------------------------------------------- All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Monday, January 18, 2016

Enable Workflow reassignments in Maximo based on security groups

1.       Simple way to enable workflow reassignments in application is through Signature options and security group.
2.       Navigate to any application in which you need Workflow reassignment option thorough application designer. In this case I am taking Requests and Defects (Oil) -- PLUSGDEF
3.       From select action add a sig option called ‘MAXWFRA’ with a  simple desc and save the record.



4.       Now navigate to the security group for which this access  has to be enabled and check the sigoption under the application (PLUSGDEF).

5.       After signing out and signing in as a user from that security group ,When you navigate to Requests and Defects (Oil) application and select a record with an active workflow . Observe that Reassignments icon is visible.









----------------------------------------------------------------------------
 All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Wednesday, January 6, 2016

How to wrap attributes in Birt based on space.


In the attribute which you want to wrap add the following code which wraps after every space to next line

if(dataSetRow["description"]!=null){
  dataSetRow["description "].replace(/ /g,"\n")
 }


/ /g à means white space anywhere in the string

----------------------------------------------------------------------------

All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Saturday, October 24, 2015

How to wrap data attributes in Birt Report

Below function would be useful for wrapping the data present in a field.

if(dataSetRow["description"]!=null){
function wrap(longStr,width){ length = longStr.length; if(length <= width) return longStr; return (longStr.substring(0, width) + "\n" + wrap(longStr.substring(width, length), width)); }wrap( dataSetRow["description"], 15 );
}

in the above function, i am trying to wrap description field to a size of 15.

Only disadvantage of this is that it includes hard stops so after every 15 characters which can be frustrating to a user who uses the report in a excel sheet.

----------------------------------------------------------------------------
All the messages below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Wednesday, August 26, 2015

Maximo .. Update database using Birt report

Sometimes database has to be updated after each report run showing that a report  has been run(example like last run date).

In Birt simple way to achieve this is to execute update query in the 'beforeClose' method of dataset.



var myTxn = MXReportTxnProvider.create("maximoDataSource");


var updateSqlText = new String();

updateSqlText = " update poline set enterdate=SYSDATE  where enterdate is null'";

var apextractStmt = myTxn.createStatement();
apextractStmt.setQuery(updateSqlText);

myTxn.save();





---------------------------------------------------------------------------- All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

SQL Server & Maximo .. How to split GL account in SQL Server

Below query can be used in sql server to split a GL account which has 3 components in to individual components divided by '-' (ex : 100010123-abcd-1234 will be divided into gl1- 100010123, gl2- abcd , gl3 - 1234) .

select gldebitacc,

substring(gldebitacc,0,CHARINDEX('-',gldebitacc)) as gl1,

substring(gldebitacc,CHARINDEX('-',gldebitacc)+1,len(gldebitacc)-(CHARINDEX('-',gldebitacc)+charindex('-', reverse(gldebitacc)))), as gl2,

REVERSE(substring(reverse(gldebitacc),0, charindex('-', reverse(gldebitacc)) )) as gl3

 from

poline


----------------------------------------------------------------------------
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Maximo Automation script .. How to find the parent Mbo and set value

Below is the sample code which can be used for finding the parent Mbo (ex invoiceline is parent for invoicecost) and setting values.I am using a attribute launchpoint on child mbo (ex invoicecost) which is called from invoiceline when filling gldebitaccout

from psdi.util.logging import MXLogger
from psdi.util.logging import MXLoggerFactory
from psdi.mbo import MboConstants


parentMbo=mbo.getOwner()
parentMbo.setValue("description","test", MboConstants.NOACCESSCHECK|MboConstants.NOVALIDATION_AND_NOACTION)



----------------------------------------------------------------------------

 All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.