MxLoader

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
------------------------------

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.

------------------------------
MG
------------------------------

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
------------------------------

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

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

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

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

Hi,

I'm happy to help.

Stevie

------------------------------
Stevie Holloway
Tufts University
------------------------------

Original Message:
Sent: 11-17-2021 11:23
From: Kimberly Garcia
Subject: Job Plan, CLASSSTRUCTURE.HIERARCHYPATH

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

------------------------------
Sunnyle Khan
google
------------------------------

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
------------------------------

Hi Kimberly,

Similar to what Manuel stated, you'll want to open your object structure, open the Exclude/Include dialog, navigate to the Non-persistent tab and select "Include" next to HIERARCHYPATH. On your load sheet I recommend adding CLASSSTRUCTURE.HIERARCHYPATH and CLASSSTRUCTURE.CLASSIFICATIONID.

Thanks,

------------------------------
Matt McGuire
Aquitas Solutions
------------------------------

Hi,

What does your MxLoader sheet look like? I don't think you can go down too many levels with MxLoader. You might have to do separate queries with separate loads?

Stevie

------------------------------
Stevie Holloway
Tufts University
------------------------------

Hi Stevie, "DEFAULTWOCLASS" is at the same level as JOBPLAN, it is just a Non-Persistent field that is not included.

------------------------------
MG
------------------------------

Original Message:
Sent: 11-15-2021 10:42
From: Stevie Holloway
Subject: Job Plan, CLASSSTRUCTURE.HIERARCHYPATH

Hi,

What does your MxLoader sheet look like? I don't think you can go down too many levels with MxLoader. You might have to do separate queries with separate loads?

Stevie

------------------------------
Stevie Holloway
Tufts University
------------------------------

Hey Manuel,

DEFAULTWOCLASS refers to the WOCLASS (ie activity, release, change, or workorder). I believe Kimberly will need to use attributes from the CLASSSTRUCTURE object she's added to her OS.

------------------------------
Matt McGuire
Aquitas Solutions
------------------------------

Original Message:
Sent: 11-15-2021 11:47
From: Manuel Guyot
Subject: Job Plan, CLASSSTRUCTURE.HIERARCHYPATH

Hi Stevie, "DEFAULTWOCLASS" is at the same level as JOBPLAN, it is just a Non-Persistent field that is not included.

------------------------------
Manuel Guyot
Husqvarna AB
------------------------------


Original Message:
Sent: 11-15-2021 10:42
From: Stevie Holloway
Subject: Job Plan, CLASSSTRUCTURE.HIERARCHYPATH

Hi,

What does your MxLoader sheet look like? I don't think you can go down too many levels with MxLoader. You might have to do separate queries with separate loads?

Stevie

------------------------------
Stevie Holloway
Tufts University