Hi Maximo Experts,
We are loading data from an external platform into MAS 9, where files are dropped into an AWS S3 folder. A Maximo cron task picks up the file, processes it through MIF, and loads the data into Maximo.
As part of a client audit requirement, we need to generate a load report containing details such as:
- Release Name
- Run Name
- Object
- Total Records
- Imported Records
- Skipped Records
- Error Records
- Total Duration
Our current design is to create a custom table (e.g., DATALOADAUDIT) to store these metrics. We also plan to name the source files using a convention such as:
RELEASEID-RUNNAME-OBJECT
so that these values can be captured automatically during processing.
The challenge we are facing is retrieving the source file name that the cron task picks up from S3. We are looking for guidance on the following:
- Is there any Maximo object/MBO/table that stores the processed file name?
- Is there any implicit API/function available in MIF or Automation Scripts to retrieve the source file name?
- Are there any sample Integration Script approaches for accessing this information?
Any suggestions or recommended approaches would be greatly appreciated.
Thanks in advance.