Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  How to import Jobplan and Tasks into 7.6.0

    Posted Mon August 30, 2021 10:52 AM
    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


  • 2.  RE: How to import Jobplan and Tasks into 7.6.0

    Posted Tue August 31, 2021 02:38 AM
    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
    ------------------------------

    Original Message


  • 3.  RE: How to import Jobplan and Tasks into 7.6.0

    Posted Tue August 31, 2021 09:25 AM
    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
    ------------------------------

    Original Message


  • 4.  RE: How to import Jobplan and Tasks into 7.6.0

    Posted Tue August 31, 2021 11:24 AM
    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
    ------------------------------

    Original Message


  • 5.  RE: How to import Jobplan and Tasks into 7.6.0

    Posted Tue August 31, 2021 11:42 AM
    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


  • 6.  RE: How to import Jobplan and Tasks into 7.6.0

    Posted Wed September 01, 2021 02:54 AM
    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
    ------------------------------

    Original Message


  • 7.  RE: How to import Jobplan and Tasks into 7.6.0

    Posted Thu September 02, 2021 01:59 AM
    Edited by System Admin Wed March 22, 2023 11:55 AM
    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
    ------------------------------

    Original Message


Related Content