Thanks so much for the clear instructions. I made a rookie mistake and forgot to first select classstructure before looking for the non persistent fields.
With your screen shot, I was able to see and select them, and they now come down to my mxloader sheet.
Thanks so much for the assistance!
------------------------------
Kimberly Garcia
Caesars Entertainment
------------------------------
Original Message:
Sent: 11-16-2021 17:37
From: Stevie Holloway
Subject: Job Plan, CLASSSTRUCTURE.HIERARCHYPATH
Hi,
I think you will need to add CLASSSTRUCTURE under the Source Objects for MXL_JOBPLAN, first.
Then, you should be able to see the HIERARCHYPATH
Stevie
------------------------------
Stevie Holloway
Tufts University
Original Message:
Sent: 11-16-2021 17:09
From: Kimberly Garcia
Subject: Job Plan, CLASSSTRUCTURE.HIERARCHYPATH
Hello,
I dont have the that option in the non persistent fields.
I only have the six below.
Is there a process to add them?
------------------------------
Kimberly Garcia
Caesars Entertainment
Original Message:
Sent: 11-15-2021 13:01
From: Matt McGuire
Subject: Job Plan, CLASSSTRUCTURE.HIERARCHYPATH
Hey Kimberly,
Looks like you may need to check the "Include" box on the MXL_JOBPLAN object structure. Please see the attached image.
Thanks,
------------------------------
Matt McGuire
Aquitas Solutions
Original Message:
Sent: 11-15-2021 12:51
From: Kimberly Garcia
Subject: Job Plan, CLASSSTRUCTURE.HIERARCHYPATH
Thanks so much, this worked as far as brining the Class ID into MXloader. But not the Hierarchy path.
Mxloader fields are:
JPNUM | ORGID | SITEID | PLUSCREVNUM | STATUS | JPDURATION | DESCRIPTION | CLASSSTRUCTURE.CLASSSTRUCTUREID | CLASSSTRUCTURE. HIERARCHYPATH |
COTW-01M-JOL | CET | JOL | 2 | ACTIVE | 1.0 | Monthly, Condensing Water Strainers | 1622 | |
------------------------------
Kimberly Garcia
Caesars Entertainment
Original Message:
Sent: 11-15-2021 02:15
From: Manuel Guyot
Subject: Job Plan, CLASSSTRUCTURE.HIERARCHYPATH
Hi,
If I understand well you want to add "DEFAULTWOCLASS" in the Object Structure for JOBPLAN, this is a Non-persistent field and you have to include it to the Object Structure. To do so, in your Object Structure, you have to open Select Action and choose Exclude/Include Fields, then open the Non-Persistent Fields and tick the "DEFAULTWOCLASS" to include it.
------------------------------
Manuel Guyot
Husqvarna AB
Original Message:
Sent: 11-12-2021 14:42
From: Kimberly Garcia
Subject: Job Plan, CLASSSTRUCTURE.HIERARCHYPATH
MXLoader - I want to be able to add the Classification to the Job Plan as I load and update job plans. I cant get the field do either come down in a query or upload to the field.
I have the following relationships in the obj stucture.
Object | Parent Object | Object Location Path | Relationship | Object Order | User Defined | Exclude Attributes Mode |
JOBPLAN | | JOBPLAN | | 1 | Y | N |
CLASSSTRUCTURE | JOBPLAN | JOBPLAN/CLASSSTRUCTURE | CLASSSTRUCTURE | 1 | Y | N |
JOBTASK | JOBPLAN | JOBPLAN/JOBTASK | JOBTASK | 2 | Y | N |
JOBLABOR | JOBPLAN | JOBPLAN/JOBLABOR | JOBLABOR | 3 | Y | N |
JOBMATERIAL | JOBPLAN | JOBPLAN/JOBMATERIAL | JOBMATERIAL | 4 | Y | N |
------------------------------
Kimberly Garcia
Caesars Entertainment
------------------------------