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 trying to perform a data load from .csv file into Maximo using the MIF but the special characters are loaded as '?'... any suggestions
Maximo 7.5.03 and 7.5.05
SQL 10.0
Websphere
Roy
try to enter the same data through the front end with mxintadm
what is the encoding of the sql db and what is the language that you are
entering ?
On Thu, Oct 24, 2013 at 9:25 PM, <roy.cline@covidien.com> wrote:
> **
>
>
> I am trying to perform a data load from .csv file into Maximo using the
> MIF but the special characters are loaded as '?'... any suggestions
>
>
>
> Maximo 7.5.03 and 7.5.05
>
> SQL 10.0
>
> Websphere
>
>
>
> Roy
>
>
>
--
Mohamed Skandaji, MBA, PMP
You can only load UTF-8 char set
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of roy.cline@covidien.com
Sent: 24 October 2013 21:25
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Loading Foreign Language characters through the MIF
I am trying to perform a data load from .csv file into Maximo using the MIF but the special characters are loaded as '?'... any suggestions
Maximo 7.5.03 and 7.5.05
SQL 10.0
Websphere
Roy
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************
Unless the characters are supported by UTF-8 character set I don’t think its possible
Probably worth trying MIF with data tables then you can insert your data using sql insert statements – I can’t remember if the framework tries to convert to XML if it does then you may have the same issue
If the fields are just description fields then as longs you have a unique identity i.e. wonum siteid you could do the upload through mif without the fields the use sql to update your database thus maintaining all the other validation of assets locations etc
Rgds Ian
BPD Zenith
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of roy.cline@covidien.com
Sent: 24 October 2013 21:25
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Loading Foreign Language characters through the MIF
I am trying to perform a data load from .csv file into Maximo using the MIF but the special characters are loaded as '?'... any suggestions
Maximo 7.5.03 and 7.5.05
SQL 10.0
Websphere
Roy
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************