MxLoader

Hi John.

I've created a MxLoader for the fields I want to update, including status. I then query for the records I want to change. From there, I change the statuses to DRAFT, use the CHANGE option and execute. Then, I update the desired fields, the use the CHANGE option again. On the last run, I changed the statuses to ACTIVE, the use the CHANGE option again.

Note: AddChange will create a mess

Please let me know if this helps.

Hi Stevie,

Thanks for the reply, but unfortunately after following your steps the Supervisor field did not change to NULL. My steps

1. I changed the status on Revision 1 & 2 to REVISED (they were both 'ACTIVE') one at a time but when I changed Revision 2 to REVISED it created Revision 3 at status 'ACTIVE' using MXLOADER 'Change'
2. I then changed the status on Revision 3 to 'DRAFT' using MXLOADER 'Change'
3. I then made the Supervisor field ~NULL~  but after running MAXLOADER 'Change' the field never changed

Screen shots attached in the order I made the steps above.

I only made this change to 1 Job Plan record, JP10000. I may have missed a step in my changes, thoughts...

Cheers

JB

Hi John.

I've created a MxLoader for the fields I want to update, including status. I then query for the records I want to change. From there, I change the statuses to DRAFT, use the CHANGE option and execute. Then, I update the desired fields, the use the CHANGE option again. On the last run, I changed the statuses to ACTIVE, the use the CHANGE option again.

Note: AddChange will create a mess

Please let me know if this helps.

Hi John,

I was still able to get mine to work in my environment.

Try these steps and let me know the results.

1. Query just for the newest record, i.e., jpnum='xxxx' and status = 'ACTIVE'
   1. Update the STATUS column to DRAFT, then execute the CHANGE action
   2. Update the SUPERVISOR column to ~NULL~, then execute the CHANGE action
   3. Execute the QUERY action to confirm the SUPERVISOR column is NULL
   4. Update the STATUS column to ACTIVE, then execute the CHANGE action

Hi Stevie,

Thanks for the reply, but unfortunately after following your steps the Supervisor field did not change to NULL. My steps

1. I changed the status on Revision 1 & 2 to REVISED (they were both 'ACTIVE') one at a time but when I changed Revision 2 to REVISED it created Revision 3 at status 'ACTIVE' using MXLOADER 'Change'
2. I then changed the status on Revision 3 to 'DRAFT' using MXLOADER 'Change'
3. I then made the Supervisor field ~NULL~  but after running MAXLOADER 'Change' the field never changed

Screen shots attached in the order I made the steps above.

I only made this change to 1 Job Plan record, JP10000. I may have missed a step in my changes, thoughts...

Cheers

JB

Hi John.

I've created a MxLoader for the fields I want to update, including status. I then query for the records I want to change. From there, I change the statuses to DRAFT, use the CHANGE option and execute. Then, I update the desired fields, the use the CHANGE option again. On the last run, I changed the statuses to ACTIVE, the use the CHANGE option again.

Note: AddChange will create a mess

Please let me know if this helps.

Thanks Stevie, found the issue, it was the OS I was using. I created a duplicate of MXJOBPLAN and excluded the fields I didn't need and just used CHANGE and no revision Job Plans created.

Thanks for all your help.

JB

Hi John,

I was still able to get mine to work in my environment.

Try these steps and let me know the results.

1. Query just for the newest record, i.e., jpnum='xxxx' and status = 'ACTIVE'
   1. Update the STATUS column to DRAFT, then execute the CHANGE action
   2. Update the SUPERVISOR column to ~NULL~, then execute the CHANGE action
   3. Execute the QUERY action to confirm the SUPERVISOR column is NULL
   4. Update the STATUS column to ACTIVE, then execute the CHANGE action

Hi Stevie,

Thanks for the reply, but unfortunately after following your steps the Supervisor field did not change to NULL. My steps

1. I changed the status on Revision 1 & 2 to REVISED (they were both 'ACTIVE') one at a time but when I changed Revision 2 to REVISED it created Revision 3 at status 'ACTIVE' using MXLOADER 'Change'
2. I then changed the status on Revision 3 to 'DRAFT' using MXLOADER 'Change'
3. I then made the Supervisor field ~NULL~  but after running MAXLOADER 'Change' the field never changed

Screen shots attached in the order I made the steps above.

I only made this change to 1 Job Plan record, JP10000. I may have missed a step in my changes, thoughts...

Cheers

JB

Hi John.

I've created a MxLoader for the fields I want to update, including status. I then query for the records I want to change. From there, I change the statuses to DRAFT, use the CHANGE option and execute. Then, I update the desired fields, the use the CHANGE option again. On the last run, I changed the statuses to ACTIVE, the use the CHANGE option again.

Note: AddChange will create a mess

Please let me know if this helps.