Introduction & Major Highlights

IMan Version 6 represents a major step-forward for IMan and will form the basis for our cloud native solution to be offered later this year.

The goals for V6 are to make IMan more intuitive and easier to use. We have achieved this by better information and feedback to integration designers (yourselves), enabling them to created integrations more quickly. The design of these features has used user-feedback and drawn inspiration for other products we use on a daily basis such as Postman, Visual Studio and text editors.

  • A major component of V6 is the new user interface for the Setup and Schedule screens. The Setup screens have had radical improvement to increase feedback with connection tracing and ability to preview the results of the particular record being edited.
  • New Tiered Lookup – Tiered lookups allow you to define cascading lists of data which can be queried through an accompanying TieredLookup function. Tiered Lookups can have differing rules attached to any one lookup. For example shipping rules can be maintained where rules are based on differing combinations of criteria i.e. weight, supplier, quantity, product type.
  • Authentication – New OpenIDDict compliant authentication and authorisation.
  • Preview Screen – A trace tab has been added to the Preview. This enables users to see the detailed requests and the corresponding responses.

Backend Changes & Performance Improvements

The improvements have been facilitated by a major upgrade of our backend services, made through a migration from .net framework to.net core.

  • The new backend services (meta-data, preview, logging, etc) have each added a raft of new features and performance improvements.
  • A performance improvement of between 20-40% of the main IMan processing runtime (IntManEng.exe).
  • Setup, DataService and Schedule screens now streamed results and traces immediately back.

Setup Screen New Features

The setup screens have been upgrade to our new UI.

  • Improved entry validation across each of the setup screens.
  • Database Connections – Can now test parameterised connection strings.
  • Counters – Live preview of sequence.
  • Custom Functions – Custom functions can now be tested.
  • (Database) Lookups – Ability to test lookups and see the results in a grid next to request.

  • Webservices Basic and OAuth Authentication – Each setup now has a live preview to show the exact request that will be made.
  • Webservices (General) – Improved request header setup, with defaults and better ‘Authorization’ header handling.
  • Webservice Lookup – Webservice lookups can now be tested with a trace of the request and response shown to the right of the setup.

  • Webservice Behaviour – Improved setup screen with ability to jump to specific section; ability to test the setup.
  • FTP/SSH, Smtp and Pop – Each form now has a connection trace to the right of the setup.

  • System Connectors – Ability to test (finally) system connectors.

Scheduler Setup and View

The scheduler setup and viewer page has also been upgraded to the new UI.

  • Improved responsiveness – schedule setup is improved and audit logs are streamed directly to the job viewer page.
  • Run now button eliminates the need
  • Improved schedule setup, removing the need to specify a description (it’s the schedule frequency and start time which does).
  • Ability to jump from the summary directly to any errors or warning in the detail section.

Authentication and Authorisation

  • New OpenIDConnect compliant authentication mechanism, bringing IMan inline with current security.
  • Ability to easily reset passwords.
  • New user setup screens.
  • (Near Future) Support for Entra and MFA will be added.

Designer Preview

  • A trace tab has been added to the Preview – displaying debug and trace data from the resource being consumed, the data being written or the transform being executed.

    For example, web requests will display the request and responses being made to the webservice. Where possible the trace will format any responses into an easily navigable form i.e. JSON and Xml type data adds ability to expand collapse each of their nodes.

  • Preview area is much more performant with results and traces being streamed, as soon as they are generated.

Tiered Lookup

Tiered lookups allow you to define cascading lists where the choices change based on the value selected on the previously selected values.

Tiered lookups can be used to capture and maintain sets of data exhibiting these characteristics. For example, an eCommerce integration may require shipping costs to be calculated based on differing sets of factor.

For example, an eCommerce integration for drop-ship orders may require shipping costs to be calculated based on differing sets of criteria. One set of products may use weight and quantity, whereas another uses a combination of destination postcode and product type.

Tiered lookups allow you to define the differing sets of rules (and values) whilst keeping them under the same lookup ‘entity’.

  • Values can be either a value, a range of values, a set list of values, or a value which has a different set of rules.
  • Each value defined as it’s own rule can define its own child sets of values (a value, a range, a list of values).

Other Enhancements

VBScript Enhancements and Functions

  • Enhancements to the Sum, Mininum, Maximum, Count and Distinct fields allow each function to include a criteria for evaluating the value. For example Minimum(“field”, “record”, “criteriaField”, %criteriaValue).
  • A new In function allows you to check for the existence of a value either in a list/array of child set of transactions.
  • First and Last functions allows you to get the first or last values from either a list/array of child set of transactions.

Connector and MetaData

  • Connectors now have a meta data refresh button, removing the need to stop/start services when a new field/optional field/analysis code/dimension is added.
  • The whole suite of connectors can now be refreshed – removing the need to stop/start services.

Breaking Changes

  • IMAN-2662 – Sage300 – Adds support for complex passwords introduced in 2023.

    The database update accompanying this release will capitalise the password for each Sage300 entry defined in the System Connectors.

    This behaviour is to provide consistency with earlier versions of Sage requiring the password to be uppercase.

    It is important that you review the passwords after the update.

Enhancements

  • IMAN-3349 – Form Url Writer – Improves User Interface and general handling of for multipart form requests (and Form Url setup in general).
  • IMAN-3351 – Sage300 – Adds ability to retry connection/session open to Sage300. This enhancement is an attempt to workaround in response to continuing sporadic ‘Session could not be opened’ errors.

Fixes

  • IMAN-3349 – HttpConnnection – Fixes an edge case setting the content-type for binary type requests.
  • IMAN-3348 – Multi-part FormUrl – Fixes/improves logging.
  • IMAN-3347 – HttpConnnection – Fixes a lifecycle issue when dealing with binary (vs. textual) type requests.

Breaking Changes

  • IMAN-2662 – Sage300 – Adds support for complex passwords introduced in 2023.

    The database update accompanying this release will capitalise the password for each Sage300 entry defined in the System Connectors.

    This behaviour is to provide consistency with earlier versions of Sage requiring the password to be uppercase.

    It is important that you review the passwords after the update.

Enhancements

Fixes

  • IMAN-3310 – Sage300 – Adds missing Discount Miscellaneous Charge field.
  • IMAN-3305 – Connector Readers – Add missing capability to allow parameterisation of connector readers with incoming transactions.
  • IMAN-3246 – Auditing – Logend was not being set.
  • IMAN-3245 – Sage300 – O/E Invoice Print – Fix issue causing printing to fail.
  • IMAN-3244 – TransactionIOController/XmlWriter – Fixes compatibility issue between a Transaction IO Controller as output to XmlWriter.
  • IMAN-3230 – Sage300 – Fixes error messaging.
  • IMAN-3227 – Sage300 – A/R Invoice – Resolves issue with Prepayment creation.
  • IMAN-3179 – TransactionSelector & TransformWrite – Fix issue with empty datasets.
  • IMAN-3168 – XmlWriter/XmlReader – Allow merging of nodes where the target document has a DTD (DocType) element.
  • IMAN-3148 – Email – Add better error handling for address fields.
  • IMAN-3146 – SageCRM – Key not found in dictionary errors when inserting case.

Breaking Changes

  • IMAN-2662 – Sage300 – Adds support for complex passwords introduced in 2023.

    The database update accompanying this release will capitalise the password for each Sage300 entry defined in the System Connectors.

    This behaviour is to provide consistency with earlier versions of Sage requiring the password to be uppercase.

    It is important that you review the passwords after the update.

Enhancements

  • IMAN-3145 – Webservices – Adds a hint under the Query, Insert & Modfy URL fields to show the full URL compromising of the BaseURL of the Webbehaviour and the Url field.
  • IMAN-3141 – Email Task – Adds ability to use expando fields when sending Email on the From field.
  • IMAN-3135 – Webservices – Adds webservice request retry (outside of throttling).
  • IMAN-3133 – JSONWriter – Adds ability to specify empty array nodes.
  • IMAN-3122, IMAN-3130, IMAN-3132, IMAN-3140 – XmlReader – Brings equivalent ‘Steppable Reader’ as per JSON Reader.
  • IMAN-3110 – Webservices – Adds support for DELETE operations for Writers.
  • IMAN-3103 – Sage200 – POPInvoice– Add handling to be able to set the lines (per the PL Invoice).
  • IMAN-3102 – Sage200 – Add extender field support for PLInvoice and POPInvoice.

Fixes

  • IMAN-3194 – Webservices – Fix an issue where evaluated Urls with incoming data.
  • IMAN-3134 – VbScriptEvaluator – Fix issue where old formulas are re-appearing.
  • IMAN-3133 – VBScriptEvaluation – Fixes thread related issue on connectors where connectors are fetching from multiple sources.
  • IMAN-3099 – Sage200 – Stock Adjustments – Add allowable exception IdenticalCreditDebitCodesException.
  • IMAN-3095 – JSONWriter – Fixes several auditing issues.
  • IMAN-3094 – JSONWriter – Fixes IndexOutOfRangeException exception on an empty JPath.
  • IMAN-3090 – Data Handling – Fixes an issue where Overwrite not being applied on multival fields – most seen on Aggregate transforms.
  • IMAN-3057 – Webservices – Fixes issue where throttling setup not always respected.
  • IMAN-3027, IMAN-3059 – Reader/Connectors – Alter/fix/improves handling to allow incoming data to parameterise connectors.
  • IMAN-3025 – WebAPI – Log full error stack on unhandled exception.
  • IMAN-3018 – Salesforce – Fix issue where hierarchical data cannot be synced where there are more than 25 child items.
  • IMAN-3013, IMAN-3026 – WebAPI – Implement fixes needed to address concurrency issues for Sage200.
  • IMAN-2966, IMAN-3005 – Sage300 – O/E Orders – Fixes various issues when Update operation is set to Synchronise.
  • IMAN-2966 – Sage300 – Bank Reversal – Bank Reversal – Add ability to reverse invoice.
  • IMAN-2937 – Sage300 – A/R Invoice – Fixes issue where the incorrect field was being set on Prepayments.
  • IMAN-2912 – WebAPI – Adds password field toggle on WebUser.

The following fixes, enhancements and changes have been made in version 5.1 product update 8a.

Product update 8a includes the emergency resolving an issue with the Scheduler.

Check out the updates in the previous updates:

Breaking Changes

  • IMAN-2662 – Sage300 – Adds support for complex passwords introduced in 2023.

    The database update accompanying this release will capitalise the password for each Sage300 entry defined in the System Connectors.

    This behaviour is to provide consistency with earlier versions of Sage requiring the password to be uppercase.

    It is important that you review the passwords after the update.

Enhancements

Fixes

  • IMAN-2904 – Scheduler – Fixes an error ‘Session already garbage collected’ stopping the scheduler from initiating further schedules. THIS IS PART OF PRODUCT UPDATE 8a.
  • IMAN-2898 – WebAPI – OpenAPI – Adds resilience into OpenAPI to handle exceptions during document generation. The OpenAPI document will now create a schema based on the successfully parse API endpoints.
  • IMAN-2897 – Connector Handling – Fixes thread related issue on connectors where connectors are fetching from multiple sources.
  • IMAN-2894 – Core Processing – Fixes/improves internal looping and filtering of datasets needed on some connectors.
  • IMAN-2886 – Sage300 – Fixes/improves error messaging where a non-standard error is raised when connecting to Sage300.
  • IMAN-2885 – JSONWriter – Fix/changes error messaging when an insert into an array fails.
  • IMAN-2884 – Sage300 – O/E Order – Alter/improves/fixes internal logic for line matching to report error messages better.
  • IMAN-2877 – Email Task – BBC field not being handled correctly.
  • IMAN-2870 – Connector Handling – Catches up changes and fixes an issue for some Connectors needing to fetch data from multiple URL/endpoints.
  • IMAN-2856 – Salesforce – Removes SYS.DELETE field from Reader.
  • IMAN-2856 – XmlWriter – Fixes an InvalidOperationException issue caused when there is both an initial XPath and Transaction XPath.
  • IMAN-2836, IMAN-2858 – Salesforce – Fix an issue on document upload.

The following fixes, enhancements and changes have been made in version 5.1 product update 7.

Check out the updates in the previous updates:

Breaking Changes

  • IMAN-2662 – Sage300 – Adds support for complex passwords introduced in 2023.

    The database update accompanying this release will capitalise the password for each Sage300 entry defined in the System Connectors.

    This behaviour is to provide consistency with earlier versions of Sage requiring the password to be uppercase.

    It is important that you review the passwords after the update.

Enhancements

  • IMAN-2828 – SQL Compatibility – Adds support for SQL 2022.
  • IMAN-2826 – Sage300 – AutoSimply – Issues & Receipts – Adds ability to map Item Line field on detail for line matching.delete records[/link] from Salesforce.
  • IMAN-2797 – Salesforce – Add ability to delete records from Salesforce.

Fixes

  • IMAN-2824 – Sage200 – POP Order – Add missing fields for delivery address (when there are no Warehouse Locations defined in Sage200).
  • IMAN-2800 – Auditing – Improve resilience when generating auditing – prevent errors.
  • IMAN-2799 – Map Transform – Fix issue where Map Transform would add empty attributes to definition (causing error).
  • IMAN-2795 – Sage300 – A/R Invoice – Add missing Tax Included fields.

The following fixes, enhancements and changes have been made in version 5.1 product update 6.

Check out the updates in the previous updates:

Breaking Changes

  • IMAN-2662 – Sage300 – Adds support for complex passwords introduced in 2023.

    The database update accompanying this release will capitalise the password for each Sage300 entry defined in the System Connectors.

    This behaviour is to provide consistency with earlier versions of Sage requiring the password to be uppercase.

    It is important that you review the passwords after the update.

Enhancements

Fixes

  • IMAN-2772 – Resolves serialisation error on Webservices exceptions causing underlying error to not be reported.
  • IMAN-2771 – Fixes an issue where the controller fields e.g. SYS.INPUTFILE could cause an issue on where they are present on Readers with incoming fields.
  • IMAN-2770 – Xml Reader – Resolves the issue where an XmlReader with incoming fields would raise a NotImplementedException.
  • IMAN-2768 – Job Configuration Upload – Resolves an issue preventing integrations being imported.

    Fix also improves error messaging on failed imports.

    Fix also resolves issue where the browser needed refreshing after upload to see the imported integrations.

  • IMAN-2764 – FixWidth Reader – Fixes an issue when adding fields to the Fix Width Reader.
  • IMAN-2762 – Realisable Mail Proxy – Improves/fixes errors incurred when sending mail through the Realisable mail proxy.
  • IMAN-2761 – Sage300 – AutoSimply Manufacturing Orders – Fixes issue where Tools and Resources would not update correctly when Synchronise set as update operation.
  • IMAN-2754 – Xml Writer – Fixes issue/improves handling on nesting child records and the nesting of child nodes.

The following fixes, enhancements and changes have been made in version 5.1 product update 5.

Check out the updates in the previous updates:

Breaking Changes

  • IMAN-2662 – Sage300 – Adds support for complex passwords introduced in 2023.

    The database update accompanying this release will capitalise the password for each Sage300 entry defined in the System Connectors.

    This behaviour is to provide consistency with earlier versions of Sage requiring the password to be uppercase.

    It is important that you review the passwords after the update.

Enhancements

  • IMAN-2753 – Webservices – Improves usability and UI handling for Read requests sending a request body.
  • IMAN-2752 – Webservices – Adds ability to parameterise the request body for Read fetch requests.

Fixes

  • IMAN-2750 – Sage300 – Reinstates trace capability lost in 5.0 conversion.
  • IMAN-2749 – Sage300 – Fixes/improves error logging and handling of view warnings.
  • IMAN-2748 – Sage300 – P/O Receipt – Fixes an error when receipting multiple orders.
  • IMAN-2690 – Connectors – Fixes an where field attributes would be lost on first save.

LastPass Breach

You may have/may not have been aware that Lastpass have had a major security breach. The extent of the breach has been slowly getting worse as they release more details. The full details of the breach can be found on the LastPass incident blog.

Notice of Recent Security Incident – The LastPass Blog

How is Realisable affected? What details have been leaked?

Realisable Software use LastPass to store personal, work related and customer access details. This means we at Realisable are at risk and in turn some of you will be affected by this.

As of now, it appears that some, if not all, customer password vaults have been obtained. To best knowledge LastPass have not confirmed the extent; let’s assume the worst.

This means point in time copies of the password vaults will have been taken by the attackers and for all intents will be available on the dark web for perpetuity.

The vaults themselves are encrypted so this does not mean the attackers have access to the passwords and details stored within the vault’s but just the encrypted vault files.

Realisable use hardware based two factor authentication for access to Lastpass. This however only protects (front-door) access to the Lastpass Password Vault’s; it is not used as a factor in the vault’s encryption.

Realisable store all sensitive data in Lastpass’s secure fields but some usernames, IP addresses, service names and URLs are stored in clear text (per LastPass’ proprietary storage format over which we have no control over).

Realisable’s Response

We have naturally taken this incident seriously and in response Realisable have undertaken a review of our LastPass master passwords and found the weakest was over 10 characters.

Even with the fastest hardware the time to break this would take several years and would incur substantial power costs.

This is not to say we or yourselves are safe, but it does mean a breach from a brute force attempt is presently unlikely.

However we have taken the following steps:

  • A mass change of own passwords and internal system’s passwords – a majority of which is complete.
  • Increasing password complexity and tightening of security policies where permitted.
  • For customer’s we deal directly and those we have direct access, we have begun to change passwords and keys where possible.

Our Storage of Access Details

We will also be reaching out to those customers we deal directly to inform them of the breach and suggest a course of action and/or working with them to change details.

You may contact us to request what details we store through our support lines.

Please allow some time for us to respond.

Changing Passwords and Security Access

Please note, if you decide to change access and passwords, ultimately you will be responsible for the change – system outages may occur with mis-configuration.

We will endeavour to assist, but we are not responsible for resolving security issues.

Please find below several links to security related articles in our help:

Are you using LastPass? Perhaps it’s time for you to review your own security?

The following fixes, enhancements and changes have been made in version 5.1 product update 4.

Check out the updates in the previous updates:

Breaking Changes

Enhancements

  • IMAN-2662 – Sage300 – Adds support for complex passwords introduced in 2023.

    The database update accompanying this release will capitalise the password for each Sage300 entry defined in the System Connectors.

    This behaviour is to provide consistency with earlier versions of Sage requiring the password to be uppercase.

    It is important that you review the passwords after the update.

Fixes

  • IMAN-2741 – Sage300 – AutoSimply – Adds (back) compatibility for versions v6.7 and prior.
  • IMAN-2714 – Sage200 – BOM Build – Fixes issue where only a single unit is building.
  • IMAN-2711 – Functions – Reinstates FindReplace function.
  • IMAN-2711 – Functions – Fixes issue with SubPushDown.
  • IMAN-2681 – Sage200 – POP Order – Add ability to set Address fields (for when there are no locations defined).
  • IMAN-2679 – Sage200 – POP Order Print – Now flags print status after printing.
  • IMAN-2675 – Sage300 – Autosimply – Fixes several issues with Receipts and Issues for versions 6.8 and above.
  • IMAN-2671 – Sage300 – Fixes an issue where forms printing was not respecting complex password change.

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close