This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
I am setting up a MIF Object Structure for PO/POLINE and plan to try to load data (INBOUND). I have the structure created and I am able to export data into the iface table just fine.
Since this has a header-detail structure what do I do to my source data to link the data if I am letting maximo Autonumber the PONUM so I can not polulate the PONUM field down the list as it is not determined until the data goes into Maximo?
POID is auto calculated but was thinking about that or do I play games with the transid and transseq to link these rows together in a header-detail manner?
I assume this is same issue for PO/POLINE, PR/PRLINE and INVOICE/INVOICELINE so there must be a solution. Unless the autonumber for me is creating the issue?
Any help greatly appreciated. My last resort will be to break this up in 2 seperate Object Structures and do the PO first then do POLINE but seems like I should not have to do that.
Thanks,
Miller
Assuming you're using an XML Structure? Typically the lines are embedded in the main XML Structure (this isn't exact, merely pseudo).
<PO>
<DESCRIPTION>Some Description</DESCRIPTION>
<POLINE>
<POLINENUM>1</POLINENUM>
<LINETYPE>MATERIAL</LINETYPE>
</POLINE>
<POLINE>
<POLINENUM>2 </POLINENUM>
<LINETYPE>MATERIAL</LINETYPE>
</POLINE>
</PO>
If you're using a CSV / Flat Structure, you typically use the alias of the column in the Header. In most cases, it's basically just the same as the column name, but you can change the alias to make it clearer like prefacing the table name if you wanted. In a flat structure, you'd have to repeat the header line for every subsequent line. Here's another sample:
DESCRIPTION,POLINENUM,LINETYPE
Some Description,1,MATERIAL
Some Description,2,MATERIAL
-- Sean Clark-McCarthy
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of David M
Sent: Wednesday, November 23, 2011 1:46 PM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] MIF Inbound Auto Number Header Detail type Object Structure (i.e. PO/POLINE etc)
I am setting up a MIF Object Structure for PO/POLINE and plan to try to load data (INBOUND). I have the structure created and I am able to export data into the iface table just fine.
Since this has a header-detail structure what do I do to my source data to link the data if I am letting maximo Autonumber the PONUM so I can not polulate the PONUM field down the list as it is not determined until the data goes into Maximo?
POID is auto calculated but was thinking about that or do I play games with the transid and transseq to link these rows together in a header-detail manner?
I assume this is same issue for PO/POLINE, PR/PRLINE and INVOICE/INVOICELINE so there must be a solution. Unless the autonumber for me is creating the issue?
Any help greatly appreciated. My last resort will be to break this up in 2 seperate Object Structures and do the PO first then do POLINE but seems like I should not have to do that.
Thanks,
Miller
I am actually using an IFACE table to load this data. And I am now finding the same issue exists for JOBPLAN/JOBLABOR.
So I autonumber the PONUM and/or the JPNUM and if I have the additional objects linked in my Object Structure I can not get the values passed from the top level that autogenerates to the child records.
Currently I recieve the following error in the mxin_inter_tran table:
psdi.util.MXApplicationException: BMXAA5861E - Mandatory keys are missing - unable to create xml from flat structure. at psdi.iface.intertables.FlatToXMLConverter.prepareObjectXML(FlatToXMLConverter.java:297) at psdi.iface.intertables.FlatToXMLConverter.convert(FlatToXMLConverter.java:160) at psdi.iface.intertables.IfaceTbCronTask.createIfaceRowList
....
I am thinking I need an Object Structure Processing Rule to SET the values into the child records but I am having bear of a time figuring this out and I find very little guidance on internet on how to do such a task.
Anyones help would be greatly appreciated.
My current workaround is to do each step as its own migration as I can populate the auto generated values in the next step with SQL but I know I should be able to do it in one step like you can from front end of application when enetering any of these things.
Miller
--- In MAXIMO@yahoogroups.com, Sean Clark-McCarthy <smccarthy@...> wrote:
>
> Assuming you're using an XML Structure? Typically the lines are embedded in the main XML Structure (this isn't exact, merely pseudo).
>
> <PO>
> <DESCRIPTION>Some Description</DESCRIPTION>
> <POLINE>
> <POLINENUM>1</POLINENUM>
> <LINETYPE>MATERIAL</LINETYPE>
> </POLINE>
> <POLINE>
> <POLINENUM>2 </POLINENUM>
> <LINETYPE>MATERIAL</LINETYPE>
> </POLINE>
> </PO>
>
> If you're using a CSV / Flat Structure, you typically use the alias of the column in the Header. In most cases, it's basically just the same as the column name, but you can change the alias to make it clearer like prefacing the table name if you wanted. In a flat structure, you'd have to repeat the header line for every subsequent line. Here's another sample:
>
> DESCRIPTION,POLINENUM,LINETYPE
> Some Description,1,MATERIAL
> Some Description,2,MATERIAL
>
>
> -- Sean Clark-McCarthy
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of David M
> Sent: Wednesday, November 23, 2011 1:46 PM
> To: MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] MIF Inbound Auto Number Header Detail type Object Structure (i.e. PO/POLINE etc)
>
>
>
> I am setting up a MIF Object Structure for PO/POLINE and plan to try to load data (INBOUND). I have the structure created and I am able to export data into the iface table just fine.
>
> Since this has a header-detail structure what do I do to my source data to link the data if I am letting maximo Autonumber the PONUM so I can not polulate the PONUM field down the list as it is not determined until the data goes into Maximo?
>
> POID is auto calculated but was thinking about that or do I play games with the transid and transseq to link these rows together in a header-detail manner?
>
> I assume this is same issue for PO/POLINE, PR/PRLINE and INVOICE/INVOICELINE so there must be a solution. Unless the autonumber for me is creating the issue?
>
> Any help greatly appreciated. My last resort will be to break this up in 2 seperate Object Structures and do the PO first then do POLINE but seems like I should not have to do that.
>
> Thanks,
> Miller
>
>
>
>
>
I think you need to have multiple entries in the interface table, i.e. one
for each POLINE, then set the TRANSID to be the same for each entry of the
same PO, and the TRANSSEQ to be numbered. So for a PO with 2 lines, the
TRANSID should be the same for both, and the TRANSSEQ values should be 1 and
2.
You also need to go into Object Structures and specify the inbound setting
restrictions, so the interface doesn't expect the PO to come with a number.
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
David M
Sent: November-26-11 11:35 AM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] MIF Inbound Auto Number Header Detail type Object
Structure (i.e. PO/POLINE etc)
I am actually using an IFACE table to load this data. And I am now finding
the same issue exists for JOBPLAN/JOBLABOR.
So I autonumber the PONUM and/or the JPNUM and if I have the additional
objects linked in my Object Structure I can not get the values passed from
the top level that autogenerates to the child records.
Currently I recieve the following error in the mxin_inter_tran table:
psdi.util.MXApplicationException: BMXAA5861E - Mandatory keys are missing -
unable to create xml from flat structure. at
psdi.iface.intertables.FlatToXMLConverter.prepareObjectXML(FlatToXMLConverte
r.java:297) at
psdi.iface.intertables.FlatToXMLConverter.convert(FlatToXMLConverter.java:16
0) at psdi.iface.intertables.IfaceTbCronTask.createIfaceRowList
....
I am thinking I need an Object Structure Processing Rule to SET the values
into the child records but I am having bear of a time figuring this out and
I find very little guidance on internet on how to do such a task.
Anyones help would be greatly appreciated.
My current workaround is to do each step as its own migration as I can
populate the auto generated values in the next step with SQL but I know I
should be able to do it in one step like you can from front end of
application when enetering any of these things.
Miller
--- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> , Sean
Clark-McCarthy <smccarthy@...> wrote:
>
> Assuming you're using an XML Structure? Typically the lines are embedded
in the main XML Structure (this isn't exact, merely pseudo).
>
> <PO>
> <DESCRIPTION>Some Description</DESCRIPTION>
> <POLINE>
> <POLINENUM>1</POLINENUM>
> <LINETYPE>MATERIAL</LINETYPE>
> </POLINE>
> <POLINE>
> <POLINENUM>2 </POLINENUM>
> <LINETYPE>MATERIAL</LINETYPE>
> </POLINE>
> </PO>
>
> If you're using a CSV / Flat Structure, you typically use the alias of the
column in the Header. In most cases, it's basically just the same as the
column name, but you can change the alias to make it clearer like prefacing
the table name if you wanted. In a flat structure, you'd have to repeat the
header line for every subsequent line. Here's another sample:
>
> DESCRIPTION,POLINENUM,LINETYPE
> Some Description,1,MATERIAL
> Some Description,2,MATERIAL
>
>
> -- Sean Clark-McCarthy
>
> From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
[mailto:MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ] On Behalf
Of David M
> Sent: Wednesday, November 23, 2011 1:46 PM
> To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
> Subject: [MAXIMO List] MIF Inbound Auto Number Header Detail type Object
Structure (i.e. PO/POLINE etc)
>
>
>
> I am setting up a MIF Object Structure for PO/POLINE and plan to try to
load data (INBOUND). I have the structure created and I am able to export
data into the iface table just fine.
>
> Since this has a header-detail structure what do I do to my source data to
link the data if I am letting maximo Autonumber the PONUM so I can not
polulate the PONUM field down the list as it is not determined until the
data goes into Maximo?
>
> POID is auto calculated but was thinking about that or do I play games
with the transid and transseq to link these rows together in a header-detail
manner?
>
> I assume this is same issue for PO/POLINE, PR/PRLINE and
INVOICE/INVOICELINE so there must be a solution. Unless the autonumber for
me is creating the issue?
>
> Any help greatly appreciated. My last resort will be to break this up in 2
seperate Object Structures and do the PO first then do POLINE but seems like
I should not have to do that.
>
> Thanks,
> Miller
>
>
>
>
>