What is the quickest way to import JOB PLANS and tasks into MAXIMO 7.6.0 ?  Tried MXloader i am getting the following error
"Error 500: nested exception is: psdi.util.MXSystemException: BMXAA4160E - A major exception has occurred. Check the system log to see if there are any companion errors logged. Report this error to your system administrator.
Error on line 9: An invalid XML character (Unicode: 0x1d) was found in the element content of the document."

Would really appreciate some  help to complete over the weekend. 


------------------------------
Stafford Allen
------------------------------

#Maximo
#AssetandFacilitiesManagement

Hi Stafford,

I think MXLoader is the easiest solution available in the market. It helps you to import data into Maximo without much understanding how it is happening.
The only caveat is you still need to understand little bit about maximo table and their relationship to each other.

MXLoader also extracts data from Maximo.
So, I would say try the following approach to see if it works for you:
1. Create a job plan manually in Maximo. In this way you will need to populate all the required data to create Job plan specific to your system.
2. extract the same job plan into MXLoader. This extract will contain all the required data.
3. Use that job plan data as a reference to populate other required job plan data. 

Couple of other options:
1. Bruno's web site explains MIF and you can use it to learn more about the framework. MIF allows you to use a file based error management while importing data which can help you understand what is wrong in your import file.
2. Consult with a Maximo Technical consultant who has access to your system and can create a template either in csv or mxloader for your use.

Hope this helps.

Thanks,
Biplab

------------------------------
Biplab Choudhury
Maximo Consultant
Tata Consultancy Services
Melbourne
------------------------------

I encountered errors like this a lot when I imported data, though I tended to just use Object Structures with flat files.  Anyways, these errors tended to come from when the Maximo record had been made by copy-and-pasting from somewhere else, such as Microsoft Word or Outlook.  In some applications like that, when the user types, the application changes the character from an actual keyboard character to "pretty" or "smart" characters.  This was very common with single and double quotes.  Yours seems to be complaining about opening and closing parenthesis.

So: check the file you're importing from.  The error says line 9, but I think that would be Row 10 in your file since the import wouldn't count Row 1 which has the column headers.  Check the description and long description fields for any special characters, especially parentheses in this case.  Delete those characters (and I usually deleted a few characters on either side of the offending character, just in case there was a hidden carriage return or something) and re-type what you deleted.  This way you'll be sure it's a standard ANSII character.

------------------------------
Travis Herron
------------------------------

Please take a look at your object structure and make sure you have it set to support flat files.  The error you note is oft associated with trying to process a flat file against an object structure that has not been set to support flat file.

------------------------------
Bradley K. Downing , MBA
Solutions Engineer
IBM
Bakersfield CA
------------------------------

I found these characters between the texts      also "extra hidden space" creating a double space.
After removing these I was able to upload the JobPlan and Tasks

Appreciate the help from the community @Travis Herron your suggestion helped.

Kind regards to community​

------------------------------
Stafford Allen
------------------------------

Original Message:
Sent: Tue August 31, 2021 11:23 AM
From: Bradley Downing
Subject: How to import Jobplan and Tasks into 7.6.0

Please take a look at your object structure and make sure you have it set to support flat files.  The error you note is oft associated with trying to process a flat file against an object structure that has not been set to support flat file.

------------------------------
Bradley K. Downing , MBA
Solutions Engineer
IBM
Bakersfield CA
------------------------------

Hi Stafford,

There seems to be a question not asked.  That is "what do you have in row 9?" 

You have been able to import rows 1-8, so what's different?  MX Loader is a great tool, but not the only tool.  Forget about the flat file support unless you are actually using that method.  It's not needed for the MX Loader.

Can you move row 9 to the last row and import the rest?

I do agree that as this seems to be data related, the most common issue is non-printable character.  Try adding a blank column next to the one you suspect that has the non-printable characters and use the function =CLEAN(A2) where A2 is the cell with the data, assuming this is MS-Excel.

Without the MX Loader file, it's really hard to judge what is the problem with your data.  I'm happy to connect and assist via Zoom or the like anytime that suits you.  Sometimes that is the quickest.

------------------------------
===============================
Craig Kokay,
Lead Senior Maximo/IoT Consultant
ISW
Sydney, NSW, Australia
Ph: 0411-682-040
=================================
#IBMChampion2021
------------------------------

Hi all,

Stafford let me know that the answer was to do with the non-printable characters.  These have been found and removed.  The upload now works.

------------------------------
===============================
Craig Kokay,
Lead Senior Maximo/IoT Consultant
ISW
Sydney, NSW, Australia
Ph: 0411-682-040
=================================
#IBMChampion2021
------------------------------