MxLoader 8.5 has some improvements regarding the capability to upload and download files from Maximo. REST and OS services behavior is now aligned and upload/download is fully supported.
MxLoader provides two special tags to manage files:
- FileTxt – to be used to upload/download text content (long descriptions, automation scripts, report design, etc.)
- FileEnc – to be used to upload/download text content (item image, attachments/doclinks)
Downloading files
To download files you must specify the FileTxt/FileEnc tag in the header. MxLoader will recognize that you want to save the data in separate files instead of using the Excel sheet to store the data.
For text files Mxloader will create a folder with the name of the Excel sheet and save .txt files whose names are determined from the first column (ASSETNUM in the example above) .
For binary files Mxloader will create a folder with the name of the Excel sheet and save files whose names are determined from the IMAGENAME (for item images) or URLNAME (for doclinks) columns.
Uploading files
To upload files you must specify the FileTxt/FileEnc tag in the cell content. MxLoader will read the file and upload the data in UTF-8 for text files or Base64 encoding for binary files.
Thank you for releasing MxLoader and the continued updates. MxLoader has saved me personally hundreds, if not thousands of hours. This has become even more true after moving to hosted MAS with no direct update access to the DB.
Cheers!