MxLoader ChangeLog
8.5.2 (2026-05-26)
- Fixed bug using FileTxt tag
8.5.1 (2026-05-24)
- Cleanup path when downloading file using FileEnc tag
8.5 (2026-01-05)
-
Added error handling in Query progress dialog
-
Added support for uploading binary files through REST service using FileEnc tag
-
Added support for downloading binary files FileEnc tag
8.4.3 (2025-10-21)
- Object IDs are now returned correctly using REST APIs
8.4.2 (2024-06-06)
- Batch action ExportXml added
8.4.1 (2024-01-21)
-
API authentication support for OS service (API token moved to HTTP header)
-
Added ignorekeyref, ignorecollectionref, ignorers headers to cleanup response for REST service
-
Object IDs can be returned specifying them in square brakets ‘[]’
8.4 (2023-08-18)
-
Removed registration check
-
Fixed newline handling
-
Fixed timezone parsing error (type mismatch)
-
Excel file compacted
8.3.6 (2023-03-20)
-
Improved MXL_REPORT object structure
-
Fixed generic error message: Unexpected char in ParseObject
8.3.5 (2022-04-29)
-
Removed ‘rel.’ prefix for REST queries to use Object Structure names instead of database relationships
-
Improved performances of query parsing
-
Improved error message when API token is missing
8.3.4 (2022-04-03)
- Progress bar for query action
8.3.2 (2022-02-06)
-
Changed HTTP header User-Agent to “MxLoader/X.X”
-
Added ‘mxlaction’ URL parameter (requested by Mark Robbins - Vetasi)
-
Fixed logic to get an API token (apitoken/create)
8.3.1 (2022-01-31)
-
Improved Preview/Export dialog
-
Improved query performances
-
Automatic data sort for Query action (added setting)
-
Use UTF-8 charset when saving files using FILETXT: directive
-
Fixed data export when using OneDrive
-
New action ExportCsv available in RunBatch sheet
8.3 (2022-01-13)
-
Progress bar for long query operations
-
Progress dialog during sync operations
-
Added support for Sync action for OS service
-
Correctly escape double quotes in JSON
-
Refresh Data Dictionary action now works also with REST service
-
Better alignment of labels in dialogs
-
Run from row command now works also for batch sheets
-
API authentication throws an error if username is set and password is not set
-
Fixed wrong number of objects reported in RunBatch
-
Fixed wizard when child objects are present
-
Double click in wizard now add/remove attributes
-
Reduce screen refresh when querying data to increase performances
-
FillData fixed when source sheet is empty and clears results column
-
FillDataAll macro added
8.2 (2021-10-09)
-
Fixed time zone handling
-
Display error when failing to parse dates
-
Improved error handling when using OS service
-
Fixed error message for wrong REST where clause syntax
8.1 (2021-06-18)
-
MxSheet Wizard
-
Batch execution
-
Web Authentication is no longer supported (overseeded by API authentication)
-
Fixed logic generating complex JSON objects
-
Fixed sync totals calculations
-
Fixed date parsing in MxlPropFile
-
Correctly escaping where clause when using OS service
-
Fixed error when logging is enabled and MxLoader is stored in OneDrive
-
Preview button now displays preview of all data with correct JSON/XML format
-
Added setting ‘API Service Context Root’
-
Removed Config sheet cell names to facilitate upgrades
-
Use API service for sync action when authentication is API
7.5.2 (2021-03-06)
-
Fixed ‘object not set’ error when setting
NULLinto datetime fields -
Correctly handle
NULLvalues in REST service -
REST service now displays the error message as the OS service when batch size is 1
7.5.1 (2021-02-28)
-
Passwords and registration info are now stored globally in a cofiguration file
-
Added ‘Store Passwords’ configuration parameter
-
Added tip for error: BMXAA8744E - The OSLC query was not parsed.
-
Fixed password dialog appearing when opening the About dialog
7.5 (2021-02-27)
-
Fixed problem entering registration info in some versions of Excel
-
Added warning for Failure Hierarchy template
-
Fixed timezone adjustments for TIME data type
-
Using Value2 to retrieve cell content to avoid casting problems
-
Added OS: MXL_SHIFT, MXL_PERSONAVAIL
-
Modified Object Structure MXL_ASSETSP to use index SPAREPART_NDX2 to avoid creating duplicate records for the same Item
7.4 NextGen (2021-01-30)
-
Changed default Batch Size value to 1
-
Fixed restart from failed row when synching (Continue Sync setting)
-
Fixed Query Only setting
-
Minor fixes to INFO logging messages
-
Release updated manual
7.3.1 NextGen (2021-01-06)
-
Refresh Data Dictionary only works when service is REST
-
Fixed Insert Column action
-
Fixed YORN data type when synching using REST service
-
Return object ID now works as it was in MxLoader 6.2
-
Result column now works also with OS service
-
Fixed query data having sting starting with single quote character '
-
Changed default Batch Size value to 10
7.2 NextGen (2020-12-03)
- Fixed file upload/download
7.1 NextGen (2020-11-15)
-
Support for Maximo NextGen REST APIs
-
File download/upload capabilities
-
Detailed results dialog
-
New buttons: Run from current row, Run all, Copy Data
-
New setting Display Query Warning
-
Added PMSEQUENCE to MXL_PM custom object structures
-
Added object structure MXL_DOMAINCROSS
-
Added processing class MXL_LOCATION object structure
6.2 (2020-01-20)
-
Object Structure MXL_QUERY fixed
-
Object Structure MXL_ITEMAS added
-
Fixed DbIdx template
-
Added Item Assembly structure template
-
Updated logo in the About tab
-
Updated manual
6.1 (2019-08-22)
-
Use Unload method to destroy dialogs
-
Changed method to read cell value in ConvTableToMxNode.ParseTable method to avoid truncation of long strings
-
New setting Split child rows
-
Refreshed data dictionary on Maximo 7.6.1.1
-
New MXL object structures
-
New templates
New Object Structures
MXL_SRVADDR – Service Address (MxLoader)
MXL_CFGDBREL – Database Relationship (MxLoader)
MXL_CFGDBLM – Lookup Maps (MxLoader)
MXL_CFGDB – Database Configuration (MxLoader)
MXL_CONDITION – Conditional Expressions (MxLoader)
MXL_SECRESTRICT – Security Restrictions (MxLoader)
MXL_REPORT – Reports (MxLoader)
MXL_REPORTDESIGN – Reports Design (MxLoader)
MXL_MAXGROUP – Security Groups (MxLoader)
MXL_CTRLGROUP – Conditional UI (MxLoader)
MXL_ESCALATION – Escalations (MxLoader)
MXL_MAXMENU – Application Menu (MxLoader)
MXL_WORKZONE – Work Zones (MxLoader)
MXL_APPS – Application definition (MxLoader)
MXL_WF – Workflow process definition (MxLoader)
MXL_COMMTEMPLATE – Communication template (MxLoader)
MXL_ROLE – Roles (MxLoader)
MXL_QUERY – Application Queries (MxLoader)
MXL_SCTEMPLATE – Start Center Templates (MxLoader)
New Templates
WorkZone – Administration – Work Zones
CondExpr – Administration – Conditional Expression (custom)
Report – Administration – Reports (custom)
Report – Administration – Report Parameters (custom)
Report – Administration – Report Design (custom)
GrpAuth – Security – Group Authorizations (custom)
RestrObj – Security – Object Data Restriction (custom)
RestrAttr – Security – Attribute Data Restriction (custom)
DomNum – System – Domains (NUMERIC)
DomTbl – System – Domains (TABLE)
DomSyn – System – Domains (SYNONYM)
DbObj – System – Database Objects
DbAttr – System – Database Attributes
DbAttrLm – System – Database Attributes Lookup Map
DbRel – System – Database Relationships (custom)
DbIdx – System – Database Indexes (custom)
Script – System – Automation Scripts
ScriptLp – System – Automation Scripts Launch Points
AppSig – System – Application Signature Options (custom)
AppQuery – System – Application Queries (custom)
AppFolder – System – Application Folders (custom)
DocFolder – System – Attachment Folders (custom)
Actions – System – Actions
Roles – System – Roles (custom)
ItemsCM – ACM – Items (CM)
5.8 (2019-04-03)
-
Better handling of errors using the [ERROR] virtual attribute
-
Updated MxLoader User Guide 2.3
5.7.1 (2017-11-14)
- Added ‘Query only’ setting
5.7 (2017-06-13)
-
Load files as attachments
-
Fixed issue: MxLoader ‘0’ returned by external reference formula
5.6 (2016-12-27)
-
Web login logout button added
-
Fixed misspelled ‘Sync’ message
5.5.1 (2016-11-09)
- Fixed failure hierarchy load (bug injected in version 5.3)
5.5 (2016-11-03)
- Added a button to preview data in XML format
5.4 (2016-10-04)
- Added support for Web authentication (SAML/OAuth)
5.3 (2016-09-07)
- Renamed custom Object Structures for Maximo 7.6.0.5 (the ‘-‘ character is no longer valid)
5.2 (2016-08-31)
-
Added SR template
-
Fixed Failure Hierarchy sync (Compile Error in hidden module: FLL)
5.1.1 (2016-06-24)
- Fixed ‘Start row’ setting
5.1 (2016-05-03)
- Added Web Services support
4.8 (2016-03-04)
- Revised GL-types fields detection
4.7.6 (2016-02-26)
-
Order by can be specified in cell E1
-
Password input dialog now hides characters
-
Calendar and Work Periods template added
4.7.5 (2015-11-13)
-
Templates added for ACM
-
Custom levels of failure hierarchy can be loaded
-
Fixed problem when parsing content of cells containing very big mumbers
-
Removed warning notes in templates to use Sync-AddChange
4.7.4 (2015-04-29)
-
Increased maximum number of rows to 300000
-
Add warning when using Sync
4.7.3 (2015-02-16)
- Fixed GL Account field handling when querying data
4.7.2 (2015-01-23)
-
Small changes to allow running MxLoader from an external Excel file
-
Data dictionary refreshed on Maximo 7.6
4.7.1 (2014-11-29)
-
Setting ‘Stop on error’ added
-
Fixed ‘Continue sync’ logic
4.7 (2014-11-26)
- Continue on sync errors setting added
4.6 (2014-11-19)
-
Removed Sync-Update and Sync-Delete actions
-
Quick Search in templates dialog
-
New MXL Object Structures added
-
Templates are now categorized by module
-
New templates added
-
User Manual released
-
Log file is automatically recycled when its size reach 2GB
4.5.3 (2014-10-09)
- Reintroduced text formatting that was removed in version 4.1 because is causes wrong parsing of numbers or dates stored in text fields
4.5.2 (2014-10-01)
- Fixed ‘Create Custom Object Structures’
4.5.1 (2014-09-30)
- Fixed hierarchical tables parsing
4.5 (2014-09-29)
-
Batch updates feature added
-
Fixed failure hierarchy loading
4.3 (2014-09-16)
- Fixed failure codes loading when multiple organizations are involved
4.2.1 (2014-09-09)
-
Setting added to optionally display of the confirmation dialog at the end of each transaction
-
Small changes to the Config sheet
4.2 (2014-09-08)
-
Data dictionary refresh fixed
-
Unlimited objects fixed (cfgMaxCount=0)
-
Fixed date formatting (cfgDateFormat)
-
Fixed dataset truncation message for query operation
4.1 (2014-09-04)
-
Rewritten XML/TABLE conversion algorithm to support unlimited levels of nested objects
-
Many MxSheet templates added with object’s primary key fields underlined in header row
-
Object count limit now works also for sync action
-
For sync operation it is possible to specify the action (Add, Delete, Update, Change, Replace, AddChange)
-
New button to quickly create custom MxLoader Object Structures
-
MxLoader.xlsm file size reduced from 4 MB to 0.5 MB
-
Comments support in MxSheet templates
-
Removed text formatting for text fields because it was messing Excel formula automatic calculation
-
Performance optimization in attribute lookup algorithm (GetAttrType)
3.7.3 (2014-06-19)
- Fixed “Subscript out of range” error when child objects are more than 100
3.7.2 (2014-06-17)
- Added “XML namespace” configuration setting
3.7.1 (2014-06-16)
-
Fixed bug detecting data type
-
Improved logging
3.7 (2014-06-13)
- Improved error handling and troubleshooting messages
3.6 (2014-05-25)
-
HTTP Proxy fixed
-
Improved compliance with MSXML 6.0 library
3.5 (2014-05-20)
-
HTTP proxy setting added
-
Improved handling of HTTP 500 response
-
Configuration buttons in MxLoader ribbon added including a new ‘Test Connection’
-
Null values can now be specified using
NULLstring
3.4.1 (2014-05-13)
- MSXML 6.0 library required
3.4 (2014-05-04)
-
LDAP authentication support
-
Bug fixing
3.3 (2014-04-14)
-
First version published on ISM Library
-
GL Account handling
-
Bug fixing