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.
All, I have been attempting to use the MIF to import asset meter readings using interface tables. It works but there are two user-defined fields that I'm specifying in the IFACEMETERDATA table that I'm trying to get to flow through to the METERREADING table. I see the data in the message XML on the queue but the data for these two fields DEPTID and FUELSITE don't get copied to METERREADING. Is there something that I'm failing to do? Do I need to use a crossover from IFACEMETERDATA to METERDATA or something else?
Hello Everyone Please help me on this issue.
When Stores creates a PO and changes the status of the PO to approved and if the PO is attached to a workorder it changes the status of the work order from waiting material to approved. please let me know if we can fix this.
thanks
I assume that the fields in question have been added to the METERREADING
table. Are they also present in the IFACEMETERDATA table? If not, you will
have to re-create the table (you'll need to take a backup of existing data
first if you want to keep it).
If they are, I would check the Inbound Setting Restrictions in the Object
Structures application, and maybe the Add/Modify Alias data, to see what's
happening there.
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
ahohnstein@gmail.com
Sent: February-14-12 7:33 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Import user defined fields for METERDATA using MIF
All, I have been attempting to use the MIF to import asset meter readings
using interface tables. It works but there are two user-defined fields that
I'm specifying in the IFACEMETERDATA table that I'm trying to get to flow
through to the METERREADING table. I see the data in the message XML on the
queue but the data for these two fields DEPTID and FUELSITE don't get copied
to METERREADING. Is there something that I'm failing to do? Do I need to use
a crossover from IFACEMETERDATA to METERDATA or something else?
Correction: You can do a "rename existing" to back up the current data.
Not sure what I was thinking a moment ago .
Chalk it up to old age or something!
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
Shannon Rotz
Sent: February-14-12 4:57 PM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Import user defined fields for METERDATA using
MIF
I assume that the fields in question have been added to the METERREADING
table. Are they also present in the IFACEMETERDATA table? If not, you will
have to re-create the table (you'll need to take a backup of existing data
first if you want to keep it).
If they are, I would check the Inbound Setting Restrictions in the Object
Structures application, and maybe the Add/Modify Alias data, to see what's
happening there.
Shannon
From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
[mailto:MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ] On Behalf
Of
ahohnstein@gmail.com <mailto:ahohnstein%40gmail.com>
Sent: February-14-12 7:33 AM
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
Subject: [MAXIMO List] Import user defined fields for METERDATA using MIF
All, I have been attempting to use the MIF to import asset meter readings
using interface tables. It works but there are two user-defined fields that
I'm specifying in the IFACEMETERDATA table that I'm trying to get to flow
through to the METERREADING table. I see the data in the message XML on the
queue but the data for these two fields DEPTID and FUELSITE don't get copied
to METERREADING. Is there something that I'm failing to do? Do I need to use
a crossover from IFACEMETERDATA to METERDATA or something else?
Shannon,
Thanks for the reply. Yes and Yes. I've added the fields to METERREADING and IFACEMETERDATA. Per your suggestion, I did check the inbound restrictions on both the METERDATA object (in DBCONFIG) and the MXMETERDATA object structure and, in both, those two fields were not restricted. Add/Modify Alias also did not turn up any clues; no conflicts there. Following is a more descriptive synopsis of the issue that I posed to IBM...
Problem description:
We're trying to import meter reading data using the MIF and an
interface table. Specifically, we're trying to import two user-defined
fiellds, DEPTID and FUELSITE (both ALN values) by specifying them in
the interface table and have the values carry through to the
destination METERREADING table. We're using the Enterprise Service
MXMETERInterface where the interface table is set to IFACEMETERDATA.
The object structure MXMETERDATA, used in the MXMETERInteface, is based
on the source object METERDATA. We have created the two user-defined
filelds in the IFACMETERDATA object (used for the integration table),
the METERDATA integration object and the METERREADING object (the
destination object). The two fields have been included on the
MXMETERDATA object structure (using Select Action > Exclude/Include
Fields and selecting the two fields on the Non-Persistent Fields tab).
When we add valid meter reading records to the interface table and
specify values in the two user-defined fields, the meter readings get
imported successfully into METERREADING, however, the values for DEPTID
and FUELSITE are null.
Is there something special that I need to do to get those fields to
carry through?
--- In MAXIMO@yahoogroups.com, "Shannon Rotz" <shannonrotz@...> wrote:
>
> I assume that the fields in question have been added to the METERREADING
> table. Are they also present in the IFACEMETERDATA table? If not, you will
> have to re-create the table (you'll need to take a backup of existing data
> first if you want to keep it).
>
>
>
> If they are, I would check the Inbound Setting Restrictions in the Object
> Structures application, and maybe the Add/Modify Alias data, to see what's
> happening there.
>
>
>
>
>
>
>
> Shannon
>
>
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
> ahohnstein@...
> Sent: February-14-12 7:33 AM
> To: MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] Import user defined fields for METERDATA using MIF
>
>
>
>
>
> All, I have been attempting to use the MIF to import asset meter readings
> using interface tables. It works but there are two user-defined fields that
> I'm specifying in the IFACEMETERDATA table that I'm trying to get to flow
> through to the METERREADING table. I see the data in the message XML on the
> queue but the data for these two fields DEPTID and FUELSITE don't get copied
> to METERREADING. Is there something that I'm failing to do? Do I need to use
> a crossover from IFACEMETERDATA to METERDATA or something else?
>
>
>
>
>
>
>
Hello Everyone Please help me on this issue.
When Stores creates a PO and changes the status of the PO to approved and if the PO is attached to a workorder it changes the status of the work order from waiting material to approved. please let me know if we can fix this.
thanks