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,
I was wondering if anyone had loaded new classifications and
attributes using the Maximo dataload tool (out of the box).We’ve successfully loaded some updates to attributes, but am
having trouble loading new and the order that the tables need to be populated.
I was loading the Classstructure and ClassSpec tables together first, but that
seems to be giving me an error “an unknown error has occurred… null”
Thanks,Denise Hubbard
Mallinckrodt Pharmaceuticals
T: 314.654.3613
denise.hubbard@mallinckrodt.com l http://www.mallinckrodt.com/
Use the MXOPERLOC object structure to load your data
Each attribute needs a line in your flat file if that’s what you are using
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: 23 July 2014 17:09
To: maximo@yahoogroups.com
Subject: [MAXIMO List] Maximo 7.5 Loading Classifications
Hello,
I was wondering if anyone had loaded new classifications and
attributes using the Maximo dataload tool (out of the box).We’ve successfully loaded some updates to attributes, but am
having trouble loading new and the order that the tables need to be populated.
I was loading the Classstructure and ClassSpec tables together first, but that
seems to be giving me an error “an unknown error has occurred… null”
Thanks,Denise Hubbard
Mallinckrodt Pharmaceuticals
T: 314.654.3613
denise.hubbard@mallinckrodt.com l http://www.mallinckrodt.com/
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.
**************************************************************************************************************
When I look at the MAXOPERLOC object structure- that is populating location tables. Not the classification tables- again, I am looking to load new classifications into the classifications application and add new attributes to those classifications.
On Wednesday, July 23, 2014 11:24 AM, "Ian Wright ian.wright@gdfsuezep.co.uk [MAXIMO]" <MAXIMO@yahoogroups.com> wrote:
Use the MXOPERLOC object structure to load your data
Each attribute needs a line in your flat file if that’s what you are using
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: 23 July 2014 17:09
To: maximo@yahoogroups.com
Subject: [MAXIMO List] Maximo 7.5 Loading Classifications
Hello,
I was wondering if anyone had loaded new classifications and
attributes using the Maximo dataload tool (out of the box).We’ve successfully loaded some updates to attributes, but am
having trouble loading new and the order that the tables need to be populated.
I was loading the Classstructure and ClassSpec tables together first, but that
seems to be giving me an error “an unknown error has occurred… null”
Thanks,Denise Hubbard
Mallinckrodt Pharmaceuticals
T: 314.654.3613
denise.hubbard@mallinckrodt.com l http://www.mallinckrodt.com/
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.
**************************************************************************************************************
OK sorry should read twice answer once
This is what I’d do
Export your existing classifications or a subset using the filter
EXTSYS1,MXCLASSInterface
You can then see the structure of the records
Remove the Unique key fields as the interface should create those for you, chop out the fields that don’t have any data to make it more readable and you have the basis for a load file
Rgds Ian
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: 23 July 2014 17:29
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Maximo 7.5 Loading Classifications
When I look at the MAXOPERLOC object structure- that is populating location tables. Not the classification tables- again, I am looking to load new classifications into the classifications application and add new attributes to those classifications.
On Wednesday, July 23, 2014 11:24 AM, "Ian Wright ian.wright@gdfsuezep.co.uk<mailto:ian.wright@gdfsuezep.co.uk> [MAXIMO]" <MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>> wrote:
Use the MXOPERLOC object structure to load your data
Each attribute needs a line in your flat file if that’s what you are using
From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:MAXIMO@yahoogroups.com]
Sent: 23 July 2014 17:09
To: maximo@yahoogroups.com<mailto:maximo@yahoogroups.com>
Subject: [MAXIMO List] Maximo 7.5 Loading Classifications
Hello,
I was wondering if anyone had loaded new classifications and
attributes using the Maximo dataload tool (out of the box).We’ve successfully loaded some updates to attributes, but am
having trouble loading new and the order that the tables need to be populated.
I was loading the Classstructure and ClassSpec tables together first, but that
seems to be giving me an error “an unknown error has occurred… null”
Thanks,Denise Hubbard
Mallinckrodt Pharmaceuticals
T: 314.654.3613
denise.hubbard@mallinckrodt.com<mailto:denise.hubbard@mallinckrodt.com> l http://www.mallinckrodt.com/
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.
**************************************************************************************************************
Are you using flat CSV file for data load?
If yes:
Please try to open your data file with notepad++ or some flat file editor and try to look for some characters which you will find are not normal. A similar problem I faced there was 1/2, 1/4 which were getting transformed into weird characters and were causing maximo to fail on import. Exact the same error I received “an unknown error has occurred… null”
Other problem will be if some of your data has extra separator which is causing a mismatch between your data and header.
I tried to reply earlier, I think my message did not get through.
Thanks
---In MAXIMO@yahoogroups.com, <hubbard_denise@...> wrote :
When I look at the MAXOPERLOC object structure- that is populating location tables. Not the classification tables- again, I am looking to load new classifications into the classifications application and add new attributes to those classifications.
On Wednesday, July 23, 2014 11:24 AM, "Ian Wright ian.wright@... mailto:ian.wright@... [MAXIMO]" <MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com> wrote:
Use the MXOPERLOC object structure to load your data
Each attribute needs a line in your flat file if that’s what you are using
From: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com]
Sent: 23 July 2014 17:09
To: maximo@yahoogroups.com mailto:maximo@yahoogroups.com
Subject: [MAXIMO List] Maximo 7.5 Loading Classifications
Hello,
I was wondering if anyone had loaded new classifications and
attributes using the Maximo dataload tool (out of the box).We’ve successfully loaded some updates to attributes, but am
having trouble loading new and the order that the tables need to be populated.
I was loading the Classstructure and ClassSpec tables together first, but that
seems to be giving me an error “an unknown error has occurred… null”
Thanks,Denise Hubbard
Mallinckrodt Pharmaceuticals
T: 314.654.3613
denise.hubbard@... mailto:denise.hubbard@... l http://www.mallinckrodt.com/ http://www.mallinckrodt.com/
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.
**************************************************************************************************************