MxLoader

 View Only

  • 1.  Upload Format Date/Time

    Posted 02-09-2022 05:10

    Hi,

    I have some problem about Date/Time format I have used upload data from master Microsoft Access Database to Maximo App.

    But What is correct Date/Time format in Maximo DB? Any one help me?

    thanks



    ------------------------------
    Abdelrahman Elwakeel
    smartsystemeg.com
    ------------------------------



  • 2.  RE: Upload Format Date/Time

    Posted 03-01-2022 09:22
    Hi Abdelrahman,

    What is the field you're trying to populate?

    The easiest way to determine what format the date field needs is by querying a record. Some fields can take mm/dd/yy others take yyyy-dd-mmThh:mm:ss:mm

    Thanks,

    ------------------------------
    Matt McGuire
    Aquitas Solutions
    https://www.aquitas-solutions.com/
    ------------------------------

    Original Message


  • 3.  RE: Upload Format Date/Time

    Posted 03-08-2022 06:51

    Hi Matt,

    Thank you reply me,

    I tried add values in (SCHEDSTART,SCHEDFINISH,ACTSTART,ACTFINISH,HANDOVERDATE and CLOSEDDATE) fields at WORKORDER application.

    I used format date mm/dd/yy and yyyy-dd-mmThh:mm:ss:mm, But Still are not valid

    Any idea solve of the problem? 

    thanks



    ------------------------------
    Abdelrahman Elwakeel
    smartsystemeg.com
    ------------------------------

    Original Message


  • 4.  RE: Upload Format Date/Time

    Posted 03-09-2022 09:52
    Hi Abdelrahman,

    Have tried to changing the datetime formatting on the Config tab in MxLoader? You should be able to set it to match whatever you need and then set Excel to match it.

    ------------------------------
    Troy Brannon
    Alcon
    ------------------------------

    Original Message


  • 5.  RE: Upload Format Date/Time

    Posted 03-10-2022 09:52
    Hi Abdelrahman,

    I just queried a workorder with SCHEDSTART and received the following format: YYYY-MM-DD HH:MM

    I changed the SCHEDFINISH and loaded into Maximo and it took successfully.

    Please let me know if that works. 

    Thanks,

    ------------------------------
    Matt McGuire
    Aquitas Solutions
    https://www.aquitas-solutions.com/
    ------------------------------

    Original Message


  • 6.  RE: Upload Format Date/Time

    Posted 06-09-2022 07:07
    I'm having the same problem. It looks as though MxLoader is converting 'some' of the data into SQL date format. The debug file is showing where the filed has been set to DATETIME:

    2022-06-09 11:13:59 [INFO] Sheet name : Work Order
    2022-06-09 11:13:59 [INFO] Object service : MXAPIWO
    2022-06-09 11:13:59 [INFO] Object name : WORKORDER
    2022-06-09 11:13:59 [INFO] Action : AddChange
    2022-06-09 11:13:59 [INFO] Where :
    2022-06-09 11:13:59 [DEBUG] Order By :
    2022-06-09 11:13:59 [DEBUG] OSLC Directives :
    2022-06-09 11:14:00 [DEBUG] Attr(1) : WONUM ()
    2022-06-09 11:14:00 [DEBUG] Attr(2) : SITEID ()
    2022-06-09 11:14:00 [DEBUG] Attr(3) : STATUS ()
    ...
    2022-06-09 11:14:00 [DEBUG] Attr(6) : LEAD ()
    2022-06-09 11:14:00 [DEBUG] Attr(7) : ACTSTART (DATETIME)
    2022-06-09 11:14:00 [DEBUG] Attr(8) : ACTTEMPFIX ()
    2022-06-09 11:14:00 [DEBUG] Attr(9) : ACTFINISH (DATETIME)

    So ACTSTART and ACTFINISH are being converted correctly but ACTTEMPFIX is taking the Excel date:

    <ACTSTART>2022-06-08T14:10:00</ACTSTART>
    <ACTTEMPFIX>44720.6041666667</ACTTEMPFIX>

    Is there some way to tell MxLoader to convert the field to DATETIME? e.g. ACTTEMPFIX (DATETIME)

    ------------------------------
    Ian Turner
    Mitie
    ------------------------------

    Original Message


  • 7.  RE: Upload Format Date/Time

    Posted 06-10-2022 02:55
    Hi,
    Try to put the DateTime Format in "yyyy-mm-ddThh:mm:ss" in Mxloader Config Sheet and try again. 
    If not then you need to do the format Cell  in Custom and add "yyyy-mm-ddThh:mm:ss"


    ------------------------------
    PAVAN KUMAR
    Maximo Consultant
    ------------------------------

    Original Message


  • 8.  RE: Upload Format Date/Time

    Posted 06-10-2022 03:29
    Thanks Pavan, yes, that does work but I'm curious why ACTTEMPFIX isn't converted by MXLoader but ACTSTART and ACTFINISH are? How/where does MxLoader know that these fields are DATETIME?

    ------------------------------
    Ian Turner
    Mitie
    ------------------------------

    Original Message


  • 9.  RE: Upload Format Date/Time

    Posted 06-14-2022 04:45
    MxLoader automatically convert dates to the correct format when setting/getting data to/from Maximo. To accomplish this conversion it must be aware of the data types.
    MxLoader has an internal data dictionary preloaded from a standard Maximo 7.6.1 database. When adding custom fields or to handle add-ons it is advisable to refresh the data dictionary using the 'Refresh Data Dictionary' button on the MxLoader ribbon.
    After that, MxLoader will be aware that the custom ACTTEMPFIX attribute is a datetime and will perform the appropriate conversions.
    Hope this clarifies how it works.



    ------------------------------
    Regards
    Bruno Portaluri (MaximoDev)
    ------------------------------

    Original Message


  • 10.  RE: Upload Format Date/Time

    Posted 06-16-2022 09:50
    Thank you @Bruno Portaluri. I don't have full access to the servers and our IT people are quite twitchy about the use of MxLoader so I do need to be careful I don't make changes to anything I shouldn't as I am allowed reasonable access. I did run this on our test server and it has updated the data dictionary. All seems good :-)​

    ------------------------------
    Ian Turner
    Mitie
    ------------------------------

    Original Message


Related Content