Release V5 | EAM Software

  • Home / EAM Tools / Data Management / Release V5

    New functions in Data Manager V5 - Release April 2018

    The EAM Data Manager for IBM Maximo and IBM Control Desk is being steadily developed.
    The version 5 was released in April 2018. From now on it is availiable for all our customers.
    Below you find the explanation of the most important tool fuctions.

    • Extended DataDictionary worksheet:
    The worksheet DataDictionary is created for search result download and template generation and now contains detailed information for all related Maximo objects/attributes, classifications and domains. See chapter DataValidation and the DataDictionary on page 83 for more information.

    • Data validation with drop-down lists for cells with domains:
    For attributes with ALN, SYNONYM or NUMERIC domain the corresponding columns now have excel data validation configured and you get a drop-down list with the valid domain values in the cells. Further information is available starting at page 86 in chapter Data validation inExcel.

    • Periodic Data Export in Templates:
    A new Crontask allows the automatic periodic export of data from Maximo to Excel documents. With crontask parameters you define from which Maximo application which data (via a saved query in the app) should be exported in which download template. The result can either be saved in the file system and/or sent via email. See chapter Periodic Export of Data with a Crontask on page 118 for more information.

    • Limit the memory consumption during export:
    The download of large search results can lead to an excessive use of memory and to out of memory situations. Maximo need a lot of memory for the objects and the created excel file needs memory as well. With a new system property you can define how much percent of the Java heap memory has to remain free. If the system falls below this limit the export is aborted. See chapter Configuration Options for the EAM Importer starting at page 73.

    • Limit the number of records to export:
    With new system properties it is now possible to limit the number of records which can be downloaded from a search result. This can be specified globally (“EAM.Export.MaxRows”) or for each object individually (“EAM.Export.MaxRows.”). If the current searchresult is larger than a configured limit the export is aborted with an error message. See chapter ConfigurationOptions for the EAM Importer starting at page 73.

    • Extended Searchresult download. Main object data in every row:
    When downloading extended search results in a Excel document you can now specify if the data for the main object (left of the separating column) should be inserted in every row. This could make it easier to process the data in the excel file (e.g. for pivot reports or when importing the data into other systems).

    • Detailed logging during data import:
    With the system property “EAM.Importer.DebugLog” you can enable a very detailed logging during the data import. The logfile shows which data is read from which excel cell and how the data is processed. This might be useful to track down problems with formulas in Excel documents. The created log file can be downloaded from the import history dialog.

    Markdorf, April 2018
    Your EAM Team