MxLoader

 View Only
  • 1.  PMSEQUENCE

    Posted 01-28-2022 12:09
    I know it's possible to update entries in the PMSEQUENCE table given the pmsequence.interval value from the PM itself but is there any way to delete redundant entries from the PM sheet?

    ------------------------------
    Ian Turner
    Mitie
    ------------------------------


  • 2.  RE: PMSEQUENCE

    Posted 01-31-2022 09:20
    Hi Ian,

    Try creating an object structure for the PMSEQUENCE object. Then query the records and delete the records that need to be deleted. You may need to add the PMSEQUENCEID field to your load sheet so you can identify and delete the correct record. 

    Thanks,

    ------------------------------
    Matt McGuire
    Aquitas Solutions
    https://www.aquitas-solutions.com/
    ------------------------------



  • 3.  RE: PMSEQUENCE

    Posted 02-02-2022 03:01
    Thanks @Matt McGuire, I thought we had one but it appears it is still hanging off a PM! I'll give it a try.​

    ------------------------------
    Ian Turner
    Mitie
    ------------------------------



  • 4.  RE: PMSEQUENCE

    Posted 06-09-2022 07:13
    Just in case anyone is reading this thread and trying to find a useful way to handle pmsequence changes... I've resorted to using a masterpm to reset the PM to a single pmsequence. Once there is only one entry in the pmsequence, you can update the pm with MxLoader.

    ------------------------------
    Ian Turner
    Mitie
    ------------------------------