MxLoader

I am trying to use MxLoader to add in an attachment via doclinks to a number for assets. I update the following fields and the update works 

DOCLINKS.DOCUMENT = TESTNAME

However every time I do it the document name always gets overridden with a sequential value. There are no duplicates in the doclinks table To cause Maximo to autogenerate a number for this field. Also if I use MXloader to update the doclinks table with the same info it actually works. Its only when I try the update via the asset table in MxLoader that this happens.

It also works without an issue if I do it in the Maximo UI.

I looked at the object structure and DB relationships and application designer but I cant find out why this is happening. Can anyone help or have you see this before.

Hi Andrew,

We do the same thing you do and do not have any issues. Attached is our template.

I am trying to use MxLoader to add in an attachment via doclinks to a number for assets. I update the following fields and the update works 

DOCLINKS.DOCUMENT = TESTNAME

However every time I do it the document name always gets overridden with a sequential value. There are no duplicates in the doclinks table To cause Maximo to autogenerate a number for this field. Also if I use MXloader to update the doclinks table with the same info it actually works. Its only when I try the update via the asset table in MxLoader that this happens.

It also works without an issue if I do it in the Maximo UI.

I looked at the object structure and DB relationships and application designer but I cant find out why this is happening. Can anyone help or have you see this before.

I am trying to use MxLoader to add in an attachment via doclinks to a number for assets. I update the following fields and the update works 

DOCLINKS.DOCUMENT = TESTNAME

However every time I do it the document name always gets overridden with a sequential value. There are no duplicates in the doclinks table To cause Maximo to autogenerate a number for this field. Also if I use MXloader to update the doclinks table with the same info it actually works. Its only when I try the update via the asset table in MxLoader that this happens.

It also works without an issue if I do it in the Maximo UI.

I looked at the object structure and DB relationships and application designer but I cant find out why this is happening. Can anyone help or have you see this before.

I used these fields for mine.

My object structure:

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

Original Message:
Sent: 09-27-2024 11:46
From: andrew brown
Subject: Unable to populate DOCLINKS.DOCUMENT field with the correct value

I am trying to use MxLoader to add in an attachment via doclinks to a number for assets. I update the following fields and the update works 

DOCLINKS.DOCUMENT = TESTNAME

However every time I do it the document name always gets overridden with a sequential value. There are no duplicates in the doclinks table To cause Maximo to autogenerate a number for this field. Also if I use MXloader to update the doclinks table with the same info it actually works. Its only when I try the update via the asset table in MxLoader that this happens.

It also works without an issue if I do it in the Maximo UI.

I looked at the object structure and DB relationships and application designer but I cant find out why this is happening. Can anyone help or have you see this before.

Hi Adam & Stevie,

Thank you for responding, Adam I cannot open you excel attachment so I couldn't see your data.

Stevie the Data that I have in my Object Structure 

 is the same and the fields that I am using are pretty much the same also. Just no matter what I put in it will always update the data but instead it will always auto generate a number and assign that.

Sample Input

View attachments on the UI

One other side note is that when I query the asset after the update I cant see the doclink info. 

Instead I need to query the doclinks table in MxLoader in order to view and verify the update.

I used these fields for mine.

My object structure:

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

Original Message:
Sent: 09-27-2024 11:46
From: andrew brown
Subject: Unable to populate DOCLINKS.DOCUMENT field with the correct value

I am trying to use MxLoader to add in an attachment via doclinks to a number for assets. I update the following fields and the update works 

DOCLINKS.DOCUMENT = TESTNAME

However every time I do it the document name always gets overridden with a sequential value. There are no duplicates in the doclinks table To cause Maximo to autogenerate a number for this field. Also if I use MXloader to update the doclinks table with the same info it actually works. Its only when I try the update via the asset table in MxLoader that this happens.

It also works without an issue if I do it in the Maximo UI.

I looked at the object structure and DB relationships and application designer but I cant find out why this is happening. Can anyone help or have you see this before.

I used these fields for mine.

My object structure:

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

Original Message:
Sent: 09-27-2024 11:46
From: andrew brown
Subject: Unable to populate DOCLINKS.DOCUMENT field with the correct value

I am trying to use MxLoader to add in an attachment via doclinks to a number for assets. I update the following fields and the update works 

DOCLINKS.DOCUMENT = TESTNAME

However every time I do it the document name always gets overridden with a sequential value. There are no duplicates in the doclinks table To cause Maximo to autogenerate a number for this field. Also if I use MXloader to update the doclinks table with the same info it actually works. Its only when I try the update via the asset table in MxLoader that this happens.

It also works without an issue if I do it in the Maximo UI.

I looked at the object structure and DB relationships and application designer but I cant find out why this is happening. Can anyone help or have you see this before.

I used these fields for mine.

My object structure:

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

Original Message:
Sent: 09-27-2024 11:46
From: andrew brown
Subject: Unable to populate DOCLINKS.DOCUMENT field with the correct value

I am trying to use MxLoader to add in an attachment via doclinks to a number for assets. I update the following fields and the update works 

DOCLINKS.DOCUMENT = TESTNAME

However every time I do it the document name always gets overridden with a sequential value. There are no duplicates in the doclinks table To cause Maximo to autogenerate a number for this field. Also if I use MXloader to update the doclinks table with the same info it actually works. Its only when I try the update via the asset table in MxLoader that this happens.

It also works without an issue if I do it in the Maximo UI.

I looked at the object structure and DB relationships and application designer but I cant find out why this is happening. Can anyone help or have you see this before.

I used these fields for mine.

My object structure:

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

Original Message:
Sent: 09-27-2024 11:46
From: andrew brown
Subject: Unable to populate DOCLINKS.DOCUMENT field with the correct value

I am trying to use MxLoader to add in an attachment via doclinks to a number for assets. I update the following fields and the update works 

DOCLINKS.DOCUMENT = TESTNAME

However every time I do it the document name always gets overridden with a sequential value. There are no duplicates in the doclinks table To cause Maximo to autogenerate a number for this field. Also if I use MXloader to update the doclinks table with the same info it actually works. Its only when I try the update via the asset table in MxLoader that this happens.

It also works without an issue if I do it in the Maximo UI.

I looked at the object structure and DB relationships and application designer but I cant find out why this is happening. Can anyone help or have you see this before.

I used these fields for mine.

My object structure:

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

Original Message:
Sent: 09-27-2024 11:46
From: andrew brown
Subject: Unable to populate DOCLINKS.DOCUMENT field with the correct value

I am trying to use MxLoader to add in an attachment via doclinks to a number for assets. I update the following fields and the update works 

DOCLINKS.DOCUMENT = TESTNAME

However every time I do it the document name always gets overridden with a sequential value. There are no duplicates in the doclinks table To cause Maximo to autogenerate a number for this field. Also if I use MXloader to update the doclinks table with the same info it actually works. Its only when I try the update via the asset table in MxLoader that this happens.

It also works without an issue if I do it in the Maximo UI.

I looked at the object structure and DB relationships and application designer but I cant find out why this is happening. Can anyone help or have you see this before.

Hi Andrew,

I think your doclinks.description and doclinks.urlname was need to be the same.

From my example: doclinks.description = Montana Open Road

                               doclinks.urlname = Montana Open Road.jpg

I used these fields for mine.

My object structure:

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

Original Message:
Sent: 09-27-2024 11:46
From: andrew brown
Subject: Unable to populate DOCLINKS.DOCUMENT field with the correct value

I am trying to use MxLoader to add in an attachment via doclinks to a number for assets. I update the following fields and the update works 

DOCLINKS.DOCUMENT = TESTNAME

However every time I do it the document name always gets overridden with a sequential value. There are no duplicates in the doclinks table To cause Maximo to autogenerate a number for this field. Also if I use MXloader to update the doclinks table with the same info it actually works. Its only when I try the update via the asset table in MxLoader that this happens.

It also works without an issue if I do it in the Maximo UI.

I looked at the object structure and DB relationships and application designer but I cant find out why this is happening. Can anyone help or have you see this before.

I am trying to use MxLoader to add in an attachment via doclinks to a number for assets. I update the following fields and the update works 

DOCLINKS.DOCUMENT = TESTNAME

However every time I do it the document name always gets overridden with a sequential value. There are no duplicates in the doclinks table To cause Maximo to autogenerate a number for this field. Also if I use MXloader to update the doclinks table with the same info it actually works. Its only when I try the update via the asset table in MxLoader that this happens.

It also works without an issue if I do it in the Maximo UI.

I looked at the object structure and DB relationships and application designer but I cant find out why this is happening. Can anyone help or have you see this before.

Hi Andrew!

Can you share an image of the object structure like this below? Do you use the classes defined as seen there (psdi.iface.app.asset.MoutAssetProcess). Or did you create your structure from scratch using docinfo as well? Can you show me please?

Regards!

I am trying to use MxLoader to add in an attachment via doclinks to a number for assets. I update the following fields and the update works 

DOCLINKS.DOCUMENT = TESTNAME

However every time I do it the document name always gets overridden with a sequential value. There are no duplicates in the doclinks table To cause Maximo to autogenerate a number for this field. Also if I use MXloader to update the doclinks table with the same info it actually works. Its only when I try the update via the asset table in MxLoader that this happens.

It also works without an issue if I do it in the Maximo UI.

I looked at the object structure and DB relationships and application designer but I cant find out why this is happening. Can anyone help or have you see this before.