MxLoader ChangeLog

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 ~NULL~ into datetime fields
• Correctly handle ~NULL~ values 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 ~NULL~ string

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