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.
Hello,
After having loaded data into the Person table using csv files via the MIF, the users decided that they did want their personal information in Maximo since it already resides in our HR system. Hence, I was instructed to clear certain fields like address, birth date, primary phone. I tried doing so by clearing the appropriate values in the original MIF file that was used for the data load and changed the action to Replace. I have even tried the AddChange. The fields are not being cleared however in Maximo. My only explanation is that the MIF doesn't see these blank field values as fields to update. Does anyone know how to get the MIF to clear values if the data is blank in the csv?
I have found a way to achieve what we want by setting up actions on the enterprise service that sets the fields to the empty string.
I still would like to find a way to get the MIF to recognize that I want to clear certain values if the field value is blank.
Any assistance would be greatly appreciated. Thank you.
Sonia.
Sonia,
If you are on Maximo 7.1.1.6 or later, you can change the values in your CSV
file to *~NULL~ *and Maximo will null those fields when it updates the
records.
Thanks,
Adam Davis
Hi..Do you mean NULL alone? Or exactly the way you specified (asterisks and all ) *~NULL~* ? I had tried NULL but it didn't work. I guess I'll try the various versions again.
Sonia Alkhal
Systems Analyst III
Information Systems Department
Trinidad and Tobago Electricity Commission
Tel: 868-623-2611 ext 2675
Email: salkhal@ttec.co.tt
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Adam Davis
Sent: Wednesday, October 19, 2011 10:49 AM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Problem Clearing field values using MIF
Sonia,
If you are on Maximo 7.1.1.6 or later, you can change the values in your CSV
file to *~NULL~ *and Maximo will null those fields when it updates the
records.
Thanks,
Adam Davis
Sonia,
It needs to be ~NULL~ (the word NULL with a tilde on each side). It looks
like my earlier email had some formatting that added asterisks, which was
wrong. But you do need the tildes.
Also, make sure of your Maximo version because this doesn't work before
7.1.1.6.
Thanks,
Adam Davis
Hi Adam,
Thanks a million! It worked for the ALN fields! It didn't work for the numeric fields, though. If we don't want to default 0 in the numeric field but put NULL, how do we do this?
Sonia Alkhal
Systems Analyst III
Information Systems Department
Trinidad and Tobago Electricity Commission
Tel: 868-623-2611 ext 2675
Email: salkhal@ttec.co.tt
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Adam Davis
Sent: Wednesday, October 19, 2011 1:59 PM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Problem Clearing field values using MIF
Sonia,
It needs to be ~NULL~ (the word NULL with a tilde on each side). It looks
like my earlier email had some formatting that added asterisks, which was
wrong. But you do need the tildes.
Also, make sure of your Maximo version because this doesn't work before
7.1.1.6.
Thanks,
Adam Davis
Export your current data including the fields you want clear and then delete the fields in the csv, usually via excel, then import back in - you don't need to specify replace or addchange
Brian Scott
Service Management Connect
Sent from my iPad
On 19 Oct 2011, at 05:27, "Sonia" <salkhal@ttec.co.tt> wrote:
> Hello,
>
> After having loaded data into the Person table using csv files via the MIF, the users decided that they did want their personal information in Maximo since it already resides in our HR system. Hence, I was instructed to clear certain fields like address, birth date, primary phone. I tried doing so by clearing the appropriate values in the original MIF file that was used for the data load and changed the action to Replace. I have even tried the AddChange. The fields are not being cleared however in Maximo. My only explanation is that the MIF doesn't see these blank field values as fields to update. Does anyone know how to get the MIF to clear values if the data is blank in the csv?
>
> I have found a way to achieve what we want by setting up actions on the enterprise service that sets the fields to the empty string.
>
> I still would like to find a way to get the MIF to recognize that I want to clear certain values if the field value is blank.
>
> Any assistance would be greatly appreciated. Thank you.
>
> Sonia.
>
>