SQUIZZ.com
Loading interface, please wait...
Interface taking a long time to load?
Check your internet connection is up, and you're using the latest app/browser version.

Version History

See all the overall changes being made to the Connector software for each major version released.

1.28 Beta

Version: 1.28.0.0
Date: 28/11/2023
Time Released: 2:08am AEDT

New Features

  • For all adaptors there is the new ability to run any data exports once off and export the data to a file on the local file system, in a Ecommerce Standards Documents structured JSON file. This can be used for debugging, diagnostics, data analytics purposes, making it easier to the structure of the data that would otherwise be exported to the TOTECS and SQUIZZ.com Ecommerce platforms, or otherwise a Connector Data Set.
     
  • An Addon Connector has been developed for SAP Business One version 10 that is a self contained web service that supports importing sales orders into only SAP Business One version 10. It's runs as a 64bit web service and can receive sales orders from the Connector using a Ecommerce Standards Documents Generic adaptor data source type to push the sales order to the addon connector, then import into SAP Business One.
     
  • For any adaptor that supports running a Product Stock data export there is now the ability to import the product stock quantity data into a Data Set, This data import will create new product records or or update existing product records by matching on the Product Key field, and it will additionally update the product's stock quantity field if active within the adaptor's data export.

Improvements

  • Within the Connector adaptor, upon opening the settings window for any adaptor type, within the Data Exports tab, or the Data Imports tab, if the Save Settings or Save Settings And Reload button is pressed for data import or data export, the within the Data Fields tab the Reload Fields button is pressed, it will now only reload the selected data export/import for the adaptor, instead of the entire adaptor. This allows the reload process to occur much quicker within the Connector Host Service. For this change to come into affect both the Connector Application and the Connector Host Service must be on version 1.28.0.0 or higher.
     
  • Within the Attache adaptor it has been modified to work with latest version of Attache. Each of the Attache adaptor's existing data exports have been updated to support querying data from its updated database via ODBC. 3 new adaptor settings have been added to support providing User ID and Password in ODBC connections, and a new setting to put prefix text within data export SQL queries infront of each data table name. This can be done using a new data hook provided called {dataTableNamePrefix}
  • Within Connector application when any data export runs for a Generic adaptor, and the data export is assigned to a JSON/XML/CSV Webservice/File data source type that reads data from multiple files stored on the local computer, the JSON/XML/CSV Webservice/File data source type has been modified to only read and store in memory one file at a time, finding and processing the file's records. Once a file has had its records obtained then the file's data will be removed from memory and continue to load next file into memory for processing. This reduced the memory footprint of the Connector Host Service, allowing more data to be exported before Out-Of-Memory exception limits are reached. Within the JSON/XML/CSV Query Browser it too will now only read and load one local file into memory at a time, process its record data, then release the memory before loading the next file.

  • Within Data Sets, loading times across all types of data have been optimised when being loaded within the Connector Application's Data Sets window. It has been optimised by implementing table column indexes to improve load times across joined data. Additionally the data tables displayed for product attributes, model attributes, and maker/model mappings have been improved to not resize the table mid loads. This allow for less re-rendering and faster loading by 2-5 times.

  • Within the Connector adaptor, upon opening the settings window for any adaptor type, within the Data Exports tab, or the Data Imports tab, if the Save Settings or Save Settings And Reload button is pressed for data import or data export, the within the Data Fields tab the Reload Fields button is pressed, it will now only reload the selected data export/import for the adaptor, instead of the entire adaptor. This allows the reload process to occur much quicker within the Connector Host Service. For this change to come into affect both the Connector Application and the Connector Host Service must be on version 1.28.0.0 or higher.

  • Within the Generic Adaptor, in the Connector Application's Generic Adaptor Settings window, under the Data Exports tab, and Data Imports tab,an additional button has been added labelled "Save Settings Only" that allows the data export's or imports settings to be saved, but not reload the all the adaptor data exports/imports within the Connector Host Service. This will allow settings to be saved while still being worked on. The other save button labelled "Save Settings" has now been changed to "Save Settings and Reload" that does allow the data export to be saved and reloaded in the Connector Host Service. The "Save Settings Only" button can save time when an adaptor is in the middle of being configured and changes need to be made across multiple data imports or exports.

Bug Fixes

  • Within the Connector application's JSON/XML Query Browser, if the Data Type selected was either XML or CSV and the Data Location was set to File, then when the Run Query button was pressed on it would incorrectly display the error message "No row can be added to a DataGridView control that does not have columns. Columns must be added first." instead of display the parsed data from the file. This bug was introduced in Connector Application version 1.27.0.0 and subsequently fixed in 1.27.0.7
     
  • Within the Generic adaptor, if a data export ran that then required multiple combined data exports to obtain all of its data using the JSON/XML/CSV Web Service/File data source type, if a preceding data export had the Save HTTP Response Data To Folder setting configured and it saved the obtained data to the file system, then any subsequent data export in the chain tried to read from the saved file, it would fail due to a lock file still remaining in the file system directly. The lock file now correctly removed after all pages of a single data export have been obtained, and no longer after all combined data exports have been completed.
     
  • Within the MYOB Exo adaptor, when its Customer Account Record Invoice was called to retrieve the details of a single customer account invoice record, the Customer Account Record Invoice data export would throw an exception and fail to obtain the invoice record, due to a database query error, where the export is incorrectly trying to obtain a 6th Address column within MYOB Exo's table that stores customer accounts. This field is now ignored from the data export and be ignored from being included in the invoice billing address data.

1.27 Beta

Version: 1.27.0.0
Date: 18/08/2022
Time Released: 6:00am AEST

New Features

  • For all adaptors additional data fields have been added to Products data exports and Data Sets, to set the measurement unit codes for width, height, depth, and weight dimensions. This can be used to indicate the units used to measure a product's dimensions and allow systems to convert calculations to their preferred units of measure. Unit codes can be set based on standardised codes set within the Ecommerce Standards Documents standards, that defines both metric and imperial measurement types for length and mass.
  • For all adaptors additional data fields have been added to Products data exports to set Meta Description, Meta Keywords, and Meta Title fields and Data Sets. This can be used to provide additional information about products, that is typically used by search engines to index and rank products or associated webpages that they appear on.
  • The Generic adaptor's Product Sell Units data export now contains additional data fields to support setting dimension data for each sell unit, packaging dimension data, and order quantity data used to determine the minimum quantity that a sell unit can be purchased for product, and the amount the quantity can be incremented by. These additional fields can provide extra measurement information used to calculate volume, packaging sizing, as well as control how product quantities are purchased.
  • The Generic adaptor's Product Stock Quantities data export now contains additional data fields to support setting additional quantity information about product stock. This includes Stock On Hand, Stock Ordered, Stock Orderable, Stock Back Ordered, Stock Reserved and Stock Consigned. These additional data fields can indicate demand for stock, or how much is in each stage of the ordering/dispatch process.
  • The Generic adaptor's Customer Account Back Order Line data export contains a new data field called Quantity Available that can store the amount of stock that is now available against a line in the back order. This can be used to determine how much of the back order line have now been replenished and available to fulfill the back order.

Improvements

  • none

Bug Fixes

  • None

1.26 Beta

Version: 1.26.0.0
Date: 19/10/2021
Time Released: 5:00pm AEDT

New Features

  • Generic Adaptor routine to retrieve sales order freight data from Smartfreight and send delivery notices to customers in SQUIZZ.com
  • Category Image and Category Tree Images Generic adaptor data exports
  • Product Images and Category Images data exports to SQUIZZ.com Ecommerce platform
  • Manage Category Images and Category Tree Images within Data Sets
  • Generic adaptor routine to call TOTECS project to send out an Emedia Email
  • Netsuite ERP Generic Adaptor Preset
  • Send TOTECS Emedia Email Generic Adaptor Routine

Improvements

  • Sales Order data imports for MYOB Exo adaptor to customise how sales orders are imported into MYOB Exo
  • Cache product image data for incremental Product Images and Category Images adaptor data exports
  • Allow files with no file name and extension in the full file path URL to be downloaded within Generic adaptor Product Images and Product Attachments data exports
  • View raw standardised JSON data of a sales order within the Sales Order Detail window
  • Display additional empty column if the last category column contains a value within Category Products tab in Data Sets Window
  • Products data export to extract next available stock arrival date from only active purchase orders to in Micronet Distribution adaptor
  • Update coding certificate for Connector application

Bug Fixes

  • Product Account Pricing data export no longer failing to use cache when a Data Transfer Mode is set to Incremental
  • Categories adaptor data export into a Data Set now correctly reactivate existing category product records
  • Product Stock data export no longer fails to return stock data for a single product when called with modified Custom Conditions in the Datapel WMS adaptor
  • Error dialog correctly not displaying anymore when the Connector Host Service sends communication to the Connector application that contains a large amount of data exceeding 65536 bytes
  • Angled brackets no longer incorrectly xml escaped within the Customer Account Contracts data export when a new Datapel WMS adaptor is created
  • Locations Generic adaptor data export now correctly runs if it's assigned to an ODBC data source and the Location Products data export isn't assigned to a data source
  • Channel Advisor Generic adaptor preset no longer allows duplicate sales order records to be exported from Channel Advisor when more than 20 orders retrieved in a single request
  • Product Account Pricing data export in MYOB Exo adaptor now correctly does not include prices for products that have Discountable Flag un-selected in MYOB Exo
  • Categories Generic adaptor data export now correctly is able to run successfully when it is assigned to a HTTP - Ecommerce Standards Documents data source type
  • Generic adaptor data exports no longer reports an unexpected error when a data export is assigned to a HTTP - Ecommerce Standards Document that returns null data records
  • Customer Account Record data exports no longer failing to find customer account to return record data with MYOB Exo adaptor
  • Recalculate Sales Order Pricing setting now doesn't ignore the setting when the Datapel WMS adaptor imports a sales order
  • RECORD_SET_INDEX JSON/XML/CSV data field function no longer incorrectly always returning 0 if used within a decimal data field within Generic adaptor's data exports and JSON/XML/CSV Query Browser

1.25 Beta

Version: 1.25.0.1
Date: 12/10/2020
Time Released: 5:00pm AEDT

New Features

  • The Generic adaptor now contains sales order data exports that allow sales orders to be retrieved from a web service, file, or database. The Generic adaptor now contains the Sales Orders, Sales Order, Sales Order Lines, Sales Order Line Taxes, Sales Order Line Attribute Profiles, Sales Order Line Attributes, Sales Order Surcharges, Sales Order Surcharge Taxes, Sales Order Payments data exports. The Sales Orders data import is used to obtain a list of sales order that need exporting, then the other exports are used to get the different details of each individual sales order.
  • The Connector now contains a Sales Orders data export for adaptors, that allows sales orders to be exported from the Connector and imported into SQUIZZ.com against the organisation set up for the adaptor. An setting has been added labelled "Reprice Exported Sales Order" controls if SQUIZZ.com should reprice an order or not when being imported into its system.
  • The Data Sets feature now supports attributes being set against locations. This allows any additional data or custom fields to be set against locations. Location Attribute Value data export has been added to the Generic adaptor to allow location attribute data to be exported from a web service, file or database, and imported into a data set.
  • The Generic adaptor now contains a routine called "Run Batch Script File"  that can call for a batch script file stored of the file sytem to be executed. This allows the Connector to be used to trigger batch script files to be run by a user, or on a scheduled basis using an adaptor's scheduler. The routine also supports arguments being passed to the batch script file.
  • The Data Sets feature now supports generating a CSV spreadsheet file that contains a report of the data that is missing for products that exist within a Data Set. The report's spreadsheet file can be configured to only look at certain data fields for products, or have customised queries written to target other data tables in the Data Set's SQLite database file that products may not contain data for. A Generic adaptor routine called "Generate Data Set Missing Product Data Report" has also been added that allows the report to be generated and saved to the file system, as well as emailed, on a once off or scheduled basis.
  • The Generic adaptor now contains a preset called "Micronet Distribution Sales Order CSV File" that can be used to generate a sales order CSV spreadsheet file that's used to import a sales order into the Micronet Distribution system. The preset can be used instead of the Micronet Distribution adaptor to import sales orders, specifically when more customised control needs to occur on the data that included with the sales order file.
  • The Generic adaptor now contains a data export called "Category Trees". This export obtains records that represent an overall category tree, and added as a list to the Categories data export. This allows both a list of categories, and the category trees to be exported from the Connector.

Improvements

  • The timeout for running the Products data export for all adaptors to the Ecommerce systems has increased to 15 minutes.
  • The MYOB AccountRight Premier adaptor now contains data exports that allow the customer account invoice records and sales order records to be customised. This allows for more control over what record data is exported out using the adaptor.
  • The Micronet Distribution adaptor's Product Account Pricing data export now factors in quantity price break pricing for category matrix discounts, when exporting out product pricing.
  • The Micronet Distribution adaptor's Customer Account Record Invoice, Sales Order and Quote data exports now support including text lines for records exported out from the adaptors connected system.
  • Within the Connector application's Adaptor Settings window, upon saving the adaptor settings, all settings now get reloaded within the Host Windows Service, avoiding a service restart needing to occur.

Bug Fixes

  • Generic adaptor data exports assigned to JSON/XML/CSV data source type correctly not replacing special characters set with question marks obtained from CSV file data
  • Product image data export correctly exports the image ordering field when uploading an image to the TOTECS Ecommerce platform
  • dataSourceSessionID data hook now correctly not placing empty value in Generic adaptor Data Source Session Destroy data export fields
  • Categories data export in Generic adaptor now correctly assigning products to category records again when keyCategoryID contains lower case letters for JSON/XML/CSV Web Service/File data source

1.24 Beta

Version: 1.24.0.0
Date: 15/03/2020
Time Released: 8:15pm AEST

New Features

  • The Data Sets feature now supports Make/Model data structures. This allows maker/manufacturer data to be managed, as well as models, model attributes, and assigning/mapping products to models. All of this allows an organisation to set up data required for make/model catalogue searching.
  • The Generic adaptor now contains a preset for integrating with the Readysell ERP system. The preset makes it easy to configure the Connector with Readysell, enabling an organisation to push data from Readysell into SQUIZZ.com or TOTECS for selling. The preset supports importing sales orders back into Readysell, as well as live account enquiry.
  • The Generic adaptor now contains a preset for integrating with the PARtsDB platform, via SQUIZZ.com's PARtsDB Addon Connector software. The preset makes it easy to configure the Connector to obtain make/model, category and product data retrieved from PARtsDB, that has been obtained via the addon connector. This allows organisations to leverage the make/model data that PARtsDB manages across the automotive industry, with data that is linked to an organisation's own inventory list for selling.
  • ROUND JSON/XML/CSV field function has been created to be able to round numbers to configurable number of decimal places. The function supports rounding up or down numbers.

Improvements

  • The Data Sets feature gets a ribbon menu, making it easier to navigate between the different types of data that can be managed within each Data Set.
  • The Data Sets feature now allows the Product data to be opened up in its own window. This can make it easier to see and manage product data in side-by-side windows, such as when copying and pasting product data, or having multiple product searches occurring across several windows.
  • The Maker Model data export timeout has been increased to 20 minutes to allow more time to upload make/model data to SQUIZZ.com and TOTECS platforms.
  • The REPLACE JSON/XML/CSV field function now being able to match and replace characters within text based on using regular expression patterns.
  • All of the Generic Adaptor's JSON/XML/CSV Web Service/File data exports have been refactored to more efficiently handle obtaining and processing records requested from web services or files.

1.23 Beta

Version: 1.23.0.0
Date: 13/12/2019
Time Released: 7:15pm AEST

New Features

  • A new Generic adaptor routine called "Import Un-imported Sales Orders" has been added to the that allows any un-imported sales orders sitting in the Connector to be imported into the connected system. The routine can be scheduled to run on a regular basis. This can mitigate problems with systems slow to import orders, or have unreliable connections, or require a store and forward mechanism.
  • Data Sets gets the new capability to view, manage and import location data, as well as assign products to locations and set the stock quantities at each location.
  • TEXT_CASE JSON/XML/CSV function to change text characters within the Generic adaptor amd JSON/XML/CSV Query Browser

Improvements

  • Micronet Harmoniq Generic adaptor preset's Product Customer Account Pricing changed to now ignores exporting expired contract prices.
  • Micronet Harmoniq Generic adaptor preset's Customer Account Addresses data export improved to now export multiple delivery addresses when assigned to each customer account
  • Setting "First Row Contains Headers" added to Generic adaptor's JSON/XML/CSV Web Service/File data source to read CSV files that contain no header row, as well as within the JSON/XML/CSV Query Browser.
  • Setting "Next Page Identifier Path" added Generic adaptor's JSON/XML/CSV Web Service/File data exports to find paginator value in response data to pass to the next web request to obtain data.
  • Data imports for Generic adaptor JSON/XML/CSV Web Service/File data source types change to now not re-format date times in outputted XML data.
  • Purchase Order and Sales Order Detail windows within the Connector application now display the stored keyPaymentID order field
  • Is Primary and Ordering fields for Product Images within Data Sets and Product Images adaptor data exports now exist to control how images are sorted when assigned to a single product, as well as identifying which image of a product should be the main image displayed for it.

Bug Fixes

  • Customer Account Record Quotes data export now correctly filtering records based on date range within Micronet Distribution adaptor
  • Value in Data Export URL setting now being saved when HTTP - ESD data source is assigned to a data export within the Generic Adaptor
  • Product Attributes Values Data Set record sincorrectly now displaying correctly when the Show Records drop down is to a non Show All Records option
  • Product Account Pricing adaptor data export now correctly joining price groups when routed to another adaptor
  • Within Data Sets window pressing the insert key on last product record table row no longer causes an unhandled exception when trying to duplicate a row

1.22 Beta

Version: 1.22.0.0
Date: 10/05/2019
Time Released: 8:00pm AEST

New Features

  • New Generic Adaptor routine called "SQUIZZ.com Reconcile And Send Customer Invoices" added to be able to send customer invoices from business systems to customer systems through SQUIZZ.com
  • Currency Exchange Rates data export added to Generic adaptor to export and update currency rates into connected Ecommerce platforms.
  • Generic adaptor preset added to obtain currency exchange rates for free from ExchangeRatesAPI.io
  • Generic adaptor preset added import and export data from Micronet Harmoniq business system.
  • ENCRYPT JSON/XML/CSV function to encrypt and sign data with Generic adaptor and JSON/XML/CSV Query Browser, using RSA SHA and MD5 ciphers.

Improvements

  • Data export setting "Save HTTP Response Data To Folder" added to save web service response data to file when using JSON/XML/CSV Web Service/File data source within the Generic Adaptor
  • Ribbon menu added to Sales Order Detail window
  • Ability to add and remove lines, surcharges and taxes to sales orders within the Sales Order Detail window
  • Ribbon menu added to the JSON/XML/CSV Query Browser window
  • Ability to query data from multiple files into one result set within the JSON/XML/CSV Query Browser window
  • Ability to export Makers, Maker Models, Maker Model Mappings, Categories, and Product Attributes to the SQUIZZ.com platform
  • "phone" data field added to Customer Accounts data export for all adaptors.
  • Within the Connector application there's now the ability to reassign sales orders, purchase orders, customer account payments, and supplier invoices to different adaptors.
  • Setting added to the Connector and adaptors to control the amount of time before the Connector gives up on sending out an email notification.
  • Timeout exporting data in Customer Accounts adaptor data exports to Ecommerce platforms increased to 15 minutes.
  • Special characters in the purchase order number field removed when the Datapel WMS adaptor's sales order import sends a sales order to Datapel WMS
  • Delivery address fields limited to 100 characters when Sales Order data import in Datepel WMS adaptor sends a sales order to Datapel WMS
  • Customer Account Credit record line items in Micronet Distribution adaptor's Customer Account Record Credits data export now returned when credit record belongs to a sub-debtor
  • Customer Account Record Credit data export now returns "unit price excluding tax" data field for each record within the Micronet Distribution adaptor
  • JSON/XML/CSV data source type within Generic adaptor now able to read JSON data that begins with an array object
  • Setting "Payment Deposit GL Account Type" added to control the type of general ledger account payments are deposited into in MYOB AccountRight adaptor
  • Combination Field Value drop down options now sorted alpha-numerically within Product Combinations tab in Data Sets window

Bug Fixes

  • Customer Account Record Invoice data export now correctly obtains invoice record in MYOB AccountRight Premier adaptor
  • Contact and organisation name now correctly displaying within delivery address when sales orders when imported by MYOB AccountRight adaptor into MYOB AccountRight Cloud, 2013+ desktop versions

1.21 Beta

Version: 1.21.0.0
Date: 14/02/2019
Time Released: 2:22pm AEDT

New Features

  • New ribbon menu bar added to the Connector application's main window, making it easier to navigate and use the application.

Improvements

  • Loading of adaptor data exports and imports within the Connector Windows Service has been rebuilt to be 5-10x faster when initially loading and being updated.
  • Customer Account Payments imported into the Connector now support importing surcharge data with each payment. 2 new data imports have been added to the Generic adaptor labelled "Customer Account Payment Surcharges" and "Customer Account Payment Surcharge Taxes" to support importing surcharge into systems with the other payment data.
  • Setting "Page Record Count Path"" added to Generic adaptor data exports assigned to JSON/XML/CSV Web Service/File data source type to specify the path to the object in the JSON data that is used to determine if more pages of data need to be requested, based on the number of records that are children of the located object.
  • Within Generic adaptor and JSON/XML/CSV Query Browser a new ability has been added to pre-parse URL path, file path, request headers, recordSet path and request body content as a JSON field function, allowing request data to be dynamically generated using JSON/XML/CSV field functions. Enables requests to Oauth type web services to be made possible with dynamic generation of request data, such as including timestamps, nonces (random identifier), and hashing/encryption.
  • Within the Connector application there's now the ability to reassign sales orders, purchase orders, customer account payments, and supplier invoices to different adaptors.
  • Setting added to the Connector and adaptors to control the amount of time before the Connector gives up on sending out an email notification.
  • In Micronet Distribution adaptor the "Rounding Decimal Places" setting now controls rounding of pricing set type 3 and type 4 sales order files.

Bug Fixes

  • 2 bug fixes

1.20.3 Beta

Version: 1.20.3.0
Date: 22/12/2018
Time Released: 5:00pm ADST

New Features

  • RAND JSON/XML/CSV field function - Generates a random number, within a specified range, rounded to a specified number of decimals.
  • LENGTH JSON/XML/CSV field function - returns the number of characters in text given to it.
  • CONTROL_CHAR JSON/XML/CSV field function - places tabs, new line, and carriage return characters into text where t r or n text appears within literal text or text queried from JSON/XML/CSV data.

Improvements

  • ENCODE JSON/XML/CSV field function now supports "hashing" text using the SHA1 and SHA256 cryptography algorithms.
  • Product Sell Units Generic adaptor data export contains 2 fields for setting the sell unit label and parent sell unit that a product is assigned to..

Bug Fixes

  • 2 bug fixes

1.20 Beta

Version: 1.20.0.0
Date: 7/12/2018
Time Released: 10:00pm ADST

New Features

  • Generic adaptor's JSON/XML data source now supports reading and converting CSV text file data retrieved from HTTP requests and files into JSON. The data source has been renamed to "JSON/XML/CSV Web Service/File".
  • The JSON/XML Query Browser now supports reading and converting CSV text data into JSON from HTTP requests, files, raw data, and request body tab. The query browser has been renamed to the "JSON/XML/CSV Query Browser"
  • 2 new JSON field functions SUBSTRING and INDEXOF added to Generic adaptor and JSON/XML/CSV Query browser to be able to to find the position of a search string in JSON text, as well as cut down text based on setting a starting and ending position of characters in a text value.
  • Generic adaptor now has a "General Ledger Accounts" data export to be able to export out GL Account data from accounting systems, which may be required for invoicing processes in SQUIZZ.com
  • New routine called "Generic HTTP GET Request" added to Generic adaptor to be able to fire off a HTTP request to any configurable server at a scheduled time period. Useful for triggering events, actions or polling on remote web servers when required.

Improvements

  • Description fields in Products and Categories Data Sets tabs now support being edited using an multi-line text editor. Makes it easier to view and write multi-line descriptions.
  • Data hooks added to all Generic adaptor data exports when running JSON/XML/CSV data sources to be able to set the key ID of the last record previously obtained in URLs and request settings. Useful for setting up pagination in URLs using IDs of records to determine the ID of the next page to be retrieved from external web services (such as ABT's Pronto XI Web Service).Connector email setting to specifiy if emails should be sent securely over a network or not.

Bug Fixes

  • 6 bug fixes

1.19 Beta

Version: 1.19.0.0
Date: 20/09/2018
Time Released: 10:00pm AEST

New Features

  • Micronet Harmoniq preset for the Generic adaptor. Allows the Generic adaptor to be configured to integrate with Micronet Harmoniq' s system through its SOAP based web service.
  • Generic Adaptor Documentation Generator. Allows a web page containing documentation of how a Generic adaptor has been configured to be generated, allowing data sources, data exports and data imports to be understood more easily.
  • Supplier Invoice importing into Connector. The Connector now supports importing Supplier Invoices into the Connector. The Generic adaptor now supports being able to import supplier invoices into JSON/XML web services/files, ODBC databases, MS SQL Server databases, SQLite databases, and CSV files.
  • ARRAY_LENGTH JSON/XML field function. Gets the length of an array within JSON/XML data.
  • ARRAY_VALUE_JOIN JSON/XML field function. Joins values together that stored within an array in JSON/XML data.
  • DECODE JSON/XML field function. Decodes text data back into plain text form.
  • ENCODE JSON/XML field function. Encodes text data into a form that is safe to use with XML, JSON, URL, BASE64, SQL data.
  • PAGE_NUMBER JSON/XML field function. Obtains the number of the page of records that are being processed within a data export request.
  • PARENT_ARRAY_INDEX JSON/XML field function. Gets the position/index number of a record being processed within its position of a parent index in JSON/XML data.
  • RECORD_SET_INDEX JSON/XML field function. Gets the position/index number of the record set currently processing JSON/XML data.
  • RECORD_INDEX JSON/XML field function. Gets the position/index number of the record currently being processed from XML/JSON data.
  • TRIM JSON/XML field function. Removes white space on the left, right, or both sides of text found in JSON/XML data.

Improvements

  • MYOB Retail Manager adaptor now supports placing the organisation name in the delivery address of a sales order into the address field of a MYOB Retail Manager sales order.
  • New setting in Generic adaptor's JSON/XML data export/import settings to set the HTTP request headers for each data export/import.
  • Data fields for Generic adaptor customer account record data exports to allow filtering and data hooks to be placed within JSON/XML data export/import setting fields.
  • Connector email setting to specifiy if emails should be sent securely over a network or not.

Bug Fixes

  • No bug fixes

1.18 Beta

Version: 1.18.0.0
Date: 19/06/2018
Time Released: 10:15pm AEST

New Features

  • Sales Order, Purchase Order, Customer Account Payments Data imports for JSON/XML Web Service/File Generic Adaptor data source. This allows sales orders, purchase orders, and customer account payments to be imported into systems via generating JSON or XML data, and saving that data to a file or passed to a web service via HTTP that accepts importing this data.
  • Customer Account Enquiry Invoices and Customer Account Enquiry Invoice Lines data exports for MYOB Retail Manager adaptor. This allows invoices to be queried from connected MYOB Retail Manager installations.
  • Additional data exports for JSON/XML Web Service/File Generic Adaptor data sources allowing contracts, attributes, product combinations, customer account records (invoices, sales orders, payments, credits, transactions, invoice line reports), to be retrieved when stored in JSON and XML files, or returned from web services via HTTP.

Improvements

  • Setting to control the field used to match customers to sales orders when importing sales orders with the MYOB AccountRight Premier adaptor
  • Output CustomerReference record field data for Customer Account Record Backorders/Credits/Payments/Quotes data exports for Generic adaptor, Micronet Distribution adaptor, MYOB AccountRight Premier/Enterprise adaptor, and MYOB AccountRight Cloud/2013+ adaptor.
  • Datapel WMS Adaptor's Product Account Pricing data export supports calculating pricing for accounts that are assigned to many price groups based on multiple account indentifiers assigned to each account.

Bug Fixes

  • Bug fixed to ensure data can be copied and pasted from one field to another under Category Product tab within Data Set window.
  • Supplier Account Enquiry Purchase Order data export from the Generic adaptor now able to export data when line type field is not active.

1.17 Beta

Version: 1.17.0.0
Date: 18/05/2018
Time Released: 11:00pm AEST

New Features

  • Adaptor Presets for the Generic adaptor. Save cofigurations of the Generic adaptor as preset files that can be exported, transferred between Connectors, and loaded back into Generic adaptors.

Improvements

  • Datapel WMS adaptor setting to control if kit components are displayed in sales orders when imported into the Datapel WMS system.

Bug Fixes

  • Locations data export within Generic adaptor now correctly sets the data fields attribute with the exported document, ensure location data can be imported into other systems.
  • Product Combination records in Data Sets now ensure keyComboProfileIDs, keyComboProfileIDs, keyComboProfileFieldValueIDs get updated across all Data Set tables, ensuring combination data stays linked.

1.16 Beta

Version: 1.16.0.0
Date: 23/04/2018
Time Released: 9:00pm AEST

New Features

  • Ability to manage and import Product Alternate Code data into Data Sets.
  • Ability to manage and import Product Kit data into Data Sets.
  • Ability to manage and import Product Flag data into Data Sets.
  • Generic adaptor data exports for creating, using and destroying sessions when connecting to JSON/XML web service data source types

Improvements

  • Locations adaptor data exports to support obtaining Email, Website, Is Geographic, Location Type record fields when exporting out location data..

1.15 Beta

Version: 1.15.0.0
Date: 19/03/2018
Time Released: 9:00pm AEST

New Features

  • Ability to manage and import Product Image data into Data Sets.
  • Ability to manage and import Product Attachment data into Data Sets.
  • Ability to manage and import Item Relations data into Data Sets.

Improvements

  • Ability to import and export data from MYOB AccountRight company files stored in the MYOB Cloud.
  • Datapel WMS adaptor now sets the product name in the WMS system's order line description field.
  • Generic adaptor's Categories Data Export no longer requires the Category Products data export to be configured to be able to export out category data.

Bug Fixes

  • When setting data within Data Sets you can now correctly set single quote characters within record fields.
  • Datapel WMS adaptor correctly now exports price-level quantity break prices for quantities set to 1 in its Product Quantity Pricing data export.

1.14 Beta

Version: 1.14.0.0
Date: 12/02/2018
Time Released: 10:00pm ADST

Improvements

  • Ability to group category discount pricing when running Account Product Pricing data export within Micronet Distribution adaptor, reducing pricing records exported.
  • MYOB Exo adaptor now can set external location data when sales orders are imported into MYOB Exo.
  • Generic adaptor can now to set external location data with sales order data when imported into configured data source.
  • New "keyCategoryTreeID" record field in Categories data exports for adaptors and Data Sets to set the category tree that each category record can be assigned to.
  • Data Exports timeout periods extended up to 200 seconds when exporting data to Ecommerce platforms. Maker/Models data export timeout increased to 10 minutes. Maker/Model Mappings data export timeout increased to 35 minutes.

Bug Fixes

  • Fix to allow data exports for product Iiages and attachments from the Datapel WMS adaptor to work again.

1.13 Beta

Version: 1.13.0.0
Date: 14/12/2017
Time Released: 10:00pm ADST

New Features

  • Ability to export Make/Model data from the Connector. 5 new data exports can be configured to export Makers, Maker Models, Maker Model Attributes, Maker Model Mappings, Maker Model Mapping Attributes.
  • Ability to export Customer Account Quote records from the Connector. 2 new data exports can be configured to export Customer Account Record Quotes, and Customer Account Record Quote Lines. Micronet Distribution adaptor also has a new data export for exporting the details of a quote record from its system.

Improvements

  • In Data Sets you can find now records for all types by using the record matching operators "equals", "not equal to", "starting with", "ending with". This provides more ways to search and find records across a large sets of records.
  • In Data Sets there's now a setting in the Product Attribute Values table to lock product columns. This allows the product columns to stay visible when you scroll horizontally across attribute columns, helping to easily see the products that attribute values are assigned against.
  • For adaptor data exports you can now paste multiple values into Custom Field Definition column cells. This allows multiple cell values to be copied and pasted from spreadsheet applications or other columns in the data exports table, making it quicker and easier to configure data exports.

1.12 Beta

Version: 1.12.0.0
Date: 08/12/2017
Time Released: 9:30pm ADST

New Features

  • Ability to view and manage product combination data within Data Sets.

Improvements

  • Ability to see Product Name column within Category Products, Product Sell Units and Product Attribute Values data types within the Data Sets window.

Bug Fixes

  • Bug fix for the Product Account Pricing data export within the Micronet Distribution adaptor to correctly export data when a category contract discount pricing rule is set up within the Micronet Distribution system
  • Bug within Product Attribute Values tab of the Data Sets window to correct display product rows after the sorting of a column has changed an the column pagination button has been clicked on.

1.11 Beta

Version: 1.11.0.0
Date: 26/10/2017
Time Released: 8:30pm ADST

New Features

  • Ability to view and manage product attribute data within Data Sets.
  • Ability to import and export attribute data from data sets as well. See Data Sets documentation below for more details.

Improvements

  • A new "Ordering" field has been added to Product data exports for all adaptors. This may be used to control the sorting of product data in connected systems.
  • Ability to import text lines with sales order and purchase order data coming into the Connector. Sales order text lines are also supported in being inserted into orders by the MYOB AccountRight Premier, MYOB AccountRIght 2013+, Datapel WMS, Generic, and Micronet adaptors.
  • New "Ordering" field has been added to Product data exports for all adaptors. This may be used to control the sorting of product data in connected systems.

Bug Fixes

  • Bug fix in Data Sets when clearing keyCategoryID value in Category Products records now correctly deletes the category_product record from the dataset's database.

1.10 Beta

Version: 1.10.0.0
Date: 15/09/2017
Time Released: 8:30pm AEST

New Features

  • Data Sets. Store, manage and merge data within the Connector itself.
  • SQLite Database Query Browser. Test and query data from SQLite databases (version 3).
  • "SQLite Database"  data source type within the Generic adaptor. Configure the Generic adaptor to read and write data to SQLite databases (version 3).
  • The Generic adaptor's "JSON/XML Web Service/File" data source type now supports Product Customer Account Pricing data exports.

Improvements

  • Setting in Generic adaptor to allow supplier account enquiry purchase order text lines to be placed within comments field.
  • Field "supplierItemCode" added  to store item code of supplier within purchase order line records and supplier account enquiry purchase order record line data exports of Generic adaptor, Attache adaptor, and MYOB AccountRight 2013+ adaptor.

1.9 Beta

Version: 1.9.0.0
Date: 25/08/2017
Time Released: 8:30pm AEST

New Features

  • Supplier Account Enquiry added within the Connector application to search and view purchase orders from systems and data sources linked to adaptors.
  • Ability to upload and send purchsae orders to supplier organisations on SQUIZZ.com to have orders procured and converted into supplier sales orders.
  • Witin the Generic adaptor the "JSON/XML Web Service/File" data source type now supports Supplier Account Enquiry Purchase Orders and Purchase Order Record data exports. This allows purchase orders to be queried and retrieved from XML or JSON files and webservices that support the data types.

Improvements

  • Ability to set to delivered and back orders quantities for customer account enquiry back order record data exports in Micronet Distribution adaptor.
  • Increased timeout of Customer Accounts data exports to 10 minutes.
  • Ability to now customise invoice, back order, sales order and credit records within Customer Account Enquiry Record data exports within the Micronet Distribution adaptor.
  • Ability to read through and retrieve records from multiple JSON or XML files for data exports when using the JSON/XML Web Service/File data source in the Generic Adaptor.
  • Modified Connector database upgrader to provide more technical error message if it fails.
  • When running an scheduled data export once off from the Connector application the Timeout error log is now raised as a warning log

Bug Fixes

  • Fixed bug that was stopping Product Images and Attachment files from being uploaded when using Micronet Distribution adaptor.
  • Fixed bug that was setting incorrect sell unit quantity for packs in Products data export within Micronet Distribution adaptor..
  • Fixed bug so that Taxcodes data export within MYOB Retail Manager adaptor sets the correct field names in the exported document.
  • Fixed bug stopping Customer Account Enquiry Back Orders data export in MYOB AccountRightPremier adaptor from successfully completed.

1.8 Beta

Version: 1.8.0.0
Date: 15/03/2017
Time Released: 7:40pm ADST

New Features

  • Witin the Generic adaptor that allows JSON or XML data to be obtained from a webservice over HTTP, or from a file stored locally on a file system.
    The "JSON/XML Web Service/File" data source type now supports the following data exports within the Generic adaptor:
    • Categories
    • Alternate Codes
    • Product Images
    • Product Attachments
    • Item Relations
    • Surcharges
    • Payment Types
    • Purchasers
    • Supplier Accounts
    • Supplier Account Addresses
    • Sell Units
    • Adaptor Status
    • Flags
    • Kits
    • Item Groups
    • Locations

Improvements

  • Added ability tp pagination through Scheduled History Logs within the Adaptor Export/Routine Scheduler Window
  • Increased timeout of Product Pricing data exports to 10 minutes.
  • Added ability to show surcharge label, description and keySurchargeID fields within Sales Order and Purchase Order Detail windows
  • Modified Type3, and Type4 sales order files generated by Micronet Distribution adaptor to support setting delivery region name if delivery address 3 field is empty
  • Modified Connector database upgrader to provide more technical error message if it fails.
  • Added setting to Attache adaptor to allow supplier account enquiry purchase order records to text line descriptions within the comments of the order instead.
  • Modified MYOB AccountRight Premier/Enterprise adaptor to support placing space between user name and intructions data within sales orders set to its system.

Bug Fixes

  • Fixed bug in Product Account Pricing data export within Datapel WMS adaptor to not cluding pricing when quantity is set to 0.
  • Fixed bug in Product Account Pricing data export within Micronet Distribution adapter to not factor in contract quantity break discounts on price levels not associated to an account's price group.
  • Fixed bug in Product Combination data export within Generic adaptor if the first child product in a combination is the default, then to allow the default product mapping to be exported.

1.7 Beta

Version: 1.7.0.0
Date: 13/12/2016
Time Released: 2:45pm ADST

New Features

  • A new data source type witin the Generic adaptor that allows JSON or XML data to be obtained from a webservice over HTTP, or from a file stored locally on a file system.
    The "JSON/XML Web Service/File" data source type supports the following data exports within the Generic adaptor:
    • Taxcodes
    • Customer Accounts
    • Customer Account Addresses
    • Customer Account Status
    • Products
    • Product Pricing
    • Product Price Level Pricing
    • Product Stock Quantities
    • Sales Reps
  • JSON/XML Query Browser added to Connector application that allows querying of JSON or XML data stored in files, requested from a web service using HTTP, or placed directly into the query browser.
  • Base 64 Text Encoder/Decoder added to Connector application to make it easy to encode text into base64 text, or decode base64 text back into plaintext.
  • Attache adaptor now supports data exports for Supplier Accounts, Supplier Account Addresses, Supplier Account Purchase Order Records.

Improvements

  • Locations data exports ran from the Connector application timeout increased from 2 minutes to 10 minutes.
  • Adaptors and Messages tab within the Connector application now allows the connector messages to be viewed in its own window.
  • Data exports that were scheduled and missed in the Connector are now rescheduled based on the number of days in the future from the last date that the data export was scheduled to run.
  • Generic adaptor's ODBC data source type now supports generating SQL queries that match data records numerically for customer account record data exports, supplier account data exports, and customer account status data exports. Key record IDs fields must have the DB Field Type set to Integer to allow numeric comparisons to take place.
  • MYOB AccountRight Premier adaptor's Supplier Account Purchase Orders data export now supports searching for  orders based purchase order code.
  • MYOB AccountRight Premier adaptor's Taxcodes data export now enables the taxcode and taxcode label fields by default.
  • MYOB AccountRight Premier adaptor contains setting that allows a contact name to be found within purchase order delivery addresses.
  • Micronet Distribution adaptor's xCBL3.0 Reconcilliation Invoice Export routine to remove special characters in invoce line descriptions when sending out invoice data.
  • Micronet Distribution adaptor's xCBL3.0 Reconcilliation Invoice Export routine to set the tax rate in invoice lines based on the taxcode tax rate assigned to the invoice line.
  • Connector application now signed with a coding certificate to ensure that Windows trusts the application being downloaded and installed.

Bug Fixes

  • Fixed bug stopping invoice data from being exported with SAP Business One adaptor.
  • Fixed bug in Micronet Distribution adapter that was stopping customer account back order records from being exported.
  • Fixed bug in Micronet Distribution adaptor that was stopping category records from being exported out in Categories data export.
  • Fixed bug in Micronet Distribution adaptor where it was not setting the correct transaction type in a generated CSV sales order file when the payment method of a sales order was set to Quote.
  • Fixed bug in Micronet Distribution adaptor where customer acocunt enquiry invoice record data was returning incorrect unit pricing for lines containing back-ordered quantities.
  • Fixed bug in MYOB AccountRight Premier adaptor to ensure that product records were not being incorrectly set as being kitted products when they were not.

1.6 Beta

Version: 1.6.0.0
Date: 14/09/2016
Time Released: 7:50pm AEST

New Features

  • Adaptor to import and export data from MYOB AccountRight versions 2013 to 2016 and later. Also can be used to transfer data from MYOB AccountRight Live.
  • Added ability to paginate through sales orders, purchase orders, and customer account payments displayed within the Connector application.
  • MYOB AccountRight Premier adaptor now supported exporting out back order customer account records.

Improvements

  • Micronet Distribution adaptor is able to calculate pricing for contract lines that contain category discount percent break rules.
  • Micronet Distribution adaptor now limits the characters in the product descriptions set in generated CSV files to 75 characters to ensure that DataConnect does not crash when importing sales orders.
  • MYOB AccountRight Premier adaptor now has settings that allow organisation names to be exported out within invoices, sales orders, back orders, purchase orders records for both delivery and billing addresses.
  • MYOB AccountRight Premier now can detect text lines when exporting invoices, sales orders, back orders, and purchase order records based on matching on a designated item number.

Bug Fixes

  • Fixed bug stopping product image and attachments data exports from routing correctly.
  • Fixed bug where a sales rep may not have been assigned to a sales order imported into Datapel's Warehouse Management System.
  • Fixed bug where if a data export failed that the error message returned from an Ecommerce System was not being shown.

1.5 Beta

Version: 1.5.0.0
Date: 5/07/2016
Time Released: 7:30pm AEST

New Features

  • Ability to search for sales orders, purchase orders, and customer account payments within the Connector application
  • Ability to export Supplier Accounts, Supplier Account Addresses, Payment Types data from MYOB Exo, AccountRight Premier, Retail Manager, SAP Business One and Datapel WMS adaptors

Improvements

  • Setting in Datapel WMS adaptor for sales orders to be re-priced when imported into its system
  • Export comments, shipping and promise date data on customer account invoices from MYOB AccountRight Premier adaptor
  • Link customer/supplier accounts to codes in the Generic adaptor alternate code export
  • Export additional delivery, billing, and freight fields with account enquiry record data from the Generic adaptor
  • Adaptor setting to control sales orders being imported as invoices or sales orders into MYOB AccountRight Premier

Bug Fixes

  • MYOB AccountRight Permier adaptor able to retrieve customer account data again
  • Ability to import purchase orders into Connector again
  • Ability to obtain details of a purchase order from a supplier account enquiry data export again
  • MYOB AccountRight Premier adaptor able to return balance data in customer account enquiry invoice record export again
  • Connector application loading customer/supplier account name in Sales Order Detail and Purchase Order Detail windows

1.4 Beta

Version: 1.4.0.0
Date: 13/04/2016
Time Released: 5:30pm AEST

New Features

  • Ability to accept incoming Connector requests directly over HTTPS, using TLS/SSL certificates to secure the incoming connections.
  • Ability to export Item Relation data from all data source types in the Generic adaptor.
  • Ability to export Item Group data from all data source types in the Generic adaptor.
  • Ability to export Surcharge data from all data source types in the Generic adaptor.
  • Ability to export Payment Type data from all data source types in the Generic adaptor.
  • Ability to export Purchaser data from all data source types in the Generic adaptor.
  • Ability to export Supplier Account data from all data source types in the Generic adaptor.
  • Ability to export Supplier Account Address data from all data source types in the Generic adaptor.
  • Ability to export Sell Unit data from all data source types in the Generic adaptor.
  • Ability to validate Squizz.com security certificates created for an organisation in the platform.
  • Ability to export out Purchase Order data associated to a supplier account from all data source types in the Generic adaptor

Bug Fixes

  • Fixed bug where the generic adaptor's Taxcodes data exports would fail to export data if the "Taxcode ID" data field was enabled for ODBC, CSV, or MS SQLServer data source types.

1.3.1 Beta

Version: 1.3.1.0
Date: 13/04/2016
Time Released: 9:12pm ADST

New Features

  • Ability to import purchase orders into ODBC accessible databases using the Generic adaptor
  • Ability to import purchase orders into Microsoft SQL Server databases using the Generic adaptor
  • Ability to route adaptor data imports to other adaptors.

Improvements

  • Added settings to the Generic adaptor's ODBC and MS SQL Server data sources to be able to use transactions and prepared database statements to write adaptor sales orders, purchase orders, and customer account payments data.

Bug Fixes

  • Fixed bug where adaptor Product Account Pricing data exports would fail to export data if the data transfer mode was set to be incremental.

1.2.1 Beta

Version: 1.2.1.0
Date: 07/03/2016
Time Released: 9:30pm ADST

New Features

  • Ability to import sales orders into ODBC accessible databases using the Generic adaptor
  • Ability to import sales orders into Microsoft SQL Server databases using the Generic adaptor
  • Added routine to Micronet Distribution adaptor that can reconcilled orders imported through the Connector, with invoices in the distribution system, then sent out invoices to a web service in the xCBL3.0 data format.

Improvements

  • Added setting to Datapel WMS adaptor to restrict the number of next-arrival-dates that can be set for each product if the adaptor is configured to obtain data from purchase orders.
  • Generic adaptor's settings window in the Connector application modified to have bigger fields for modifying data import and data export settings.

Bug Fixes

  • Fixed bug where the "Is Tax Inclusive" data was not being exported out from any adaptor Products data export.
  • Fixed bug where sales order or purchase order detail window would not load in the Connector application if the order contained any product delivery records for a line.

1.1.1.0 Beta

Version: 1.1.1.0
Date: 22/03/2016
Time Released: 8:43pm AEDST

New Features

  • Adaptor Data Export Routing
  • Customer Account Enquiry Invoice Lines Report adaptor data export
  • Generic adaptor MS SQL Server data source data exports
  • Generic adaptor ODBC data source data exports

Improvements

  • Set purchase order next stock arrival dates for products when exporting from Datapel WMS adaptor

1.0.0.4 Beta

Version: 1.0.0.4
Date: 24/02/2016
Time Released: 5:00pm AEDST

New Features

  • "Xsquizzit Accounting Connector" rebranded to the "Squizz.com Connector".
  • Connector Host Service renamed from "Accounting Connector" to "Squizz.com Connector"
  • Generic adaptor's CSV data source can now import sales orders, purchase orders and customer account payments to CSV files.
  • Generic adaptor's HTTP-Ecommerce Standards Document data source now has the ability to export all data from a compatible webservice, as well import sales order, purchase order, and customer account payment data.
  • Data exported from the Connector service now supports and implements version 1 of the Ecommerce Standards Documents standard.
  • Adaptor Password field added to boost security of incoming requests for given adaptors.
  • Implrmentation of basic HTTP authentication of incoming adaptor data requests.

Improvements

  • Refactoring of all classes within the Connector software.
  • Connector Application now shows version numbers of the application, the windows host service, and the database within the Settings tab.
  • Additional fields added to Sales Order Details and Purchase Order Details windows within the Connector application.
  • Connector Application and Connector Host Service now place application launchers into a "Squizz.com Connector" start menu folder.
  • Sales order and purchase orders imports into the Connector now support importing multiple orders in one request.

0.29.1 Beta

Version: 0.29.1
Date: 24/02/2016
Time Released: 5:30pm AEDST

New Features

  • Wizard in Connector application to migrate the connector's 0.x database to version 1.0.

Improvements

  • Micronet Distribution adaptor to remove asterisks characters from sales order instructions when generating sales order files for Micronet's DataConnect software. This is done to mitigate DataConnect not being able to handle such characters.

Bug Fixes

  • Datapel WMS adaptor's product data export modified to correctly obtain data mapped to the barcode field.

0.28.1 Beta

Version: 0.28.1
Date: 30/11/2015
Time Released: 5:30pm AEDST

New Features

  • Generic adaptor to read and export data from CSV spreadsheet files.

Improvements

  • Divide down sales unit pricing when exporting pricing data from Micronet Distribution system
  • SAP Business One adaptor to export product kits data out of SAP Business One
  • Settings to allow the Login ID and sales representative to display in sales submitted by the MYOB AccountRight Premier adaptor

Bug Fixes

  • CSV sales order files generated by Micronet Distribution adaptor cause DataConnect to crash when instructions contain double quote characters.
  • Products data export for the SAP Business One adaptor is incorrectly not returning depth product data
  • MYOB Retail Manager adaptor not able to import a sales order when its instructions field contains too much data
  • Incorrect payments terms returned for customer account enquiry data when obtained from MYOB AccountRight Premier adaptor
  • MYOB AccountRight Premier adaptor incorrectly obtaining quotes with account enquiry invoice records

0.27.1 Beta

Version: 0.27.1
Date: 06/08/2015
Time Released: 7:51pm AEST

New Features

  • Product Account Price data export for Datapel WMS adaptor to export out special pricing from the WMS system.

Improvements

  • Micronet Distribution adapter to calculate contract line discount pricing when Product Account Pricing data export is run.
  • Product Quantity Pricing data export to timeout after 10 minutes when uploading pricing data to Ecommerce systems.
  • Setting in Micronet Distribution adaptor to decide if surcharge lines are added with order lines when the adaptor generates DataConnect order files to import orders in the distribution system.
  • Micronet Distribution adaptor to have settings to decide to recalculate the sales order being imported and set price difference in the header field of the CSV Data.Connect order file.
  • Setting in MYOB AccountRight Premier adaptor to configure the prefix text set in account enquiry invoice record descriptions.

Bug Fixes

  • Datapel WMS adaptor modified to correctly ignore retreiving account enquiry invoices for a customer account when the invoice is a template based on the invoice number containing SPS in the code.

0.26.1 Beta

Version: 0.26.1
Date: 01/07/2015
Time Released: 9:30pm AEST

New Features

  • Generic Adaptor

Improvements

  • Address 4 and Organisation Name address fields added to address data exports for all adaptors.
  • Address 4 and Organisation Name address field data able to be imported with sales orders into all adaptors business systems.
  • SAP Business One adaptor supported for SAP Business One system version 9.1.
  • Micronet Distribution adaptor to place freight, minimum order, and credit card surcharge column data in the heade row of the generated order CSV file.
  • Micronet Distribution adaptor to set payment method code in a header row of generated order CSV file.
  • Micronet Distribution adaptor when running a Product Account Pricing data export now allows discount matrix pricing to be grouped based on each discount category to reduce the amount of pricing records that are calculated and exported.

Bug Fixes

  • Invoice records obtained from Micronet Distribution adaptor correctly calculate the quantity ordered and quantity delivered for each line in the record when obtained From Micronet Distribution system.
  • Sales orders are now able to be imported when using the MYOB Exo adaptor when a product's description in the order contains more than 40 characters.
  • Invoice records now can be obtained from Micronet Distribution adaptor when an invoice contains a line that contains 0 delivered quantity.
  • Alternate Products data export from Micronet Distribution adaptor now correctly obtains all alternate product code data.
  • Sales Order invoice records now contain be correctly obtained from the Micronet Distriubtion adaptor.
  • When an error occurs when calling the Micronet Distribution adaptor to obtain Product Stock levels, the error message log now correctly refers to the Micronet Distribution adaptor.
  • Make a requesting through any adaptor to filter the list of customer account records now correctly filters records based on the date range being set to 30-60 days, and 60-90 days.
  • The timeout period of the Customer Account Address data exports being imported into an Ecommerce system has now been increased to 5 minutes to allow enough time for the data to be exported.

0.25.1 Beta

Version: 0.25.1
Date: 09/04/2015
Time Released: 7:00pm AEST

New Features

  • Importing of purchase orders into the Connector.

Improvements

  • Obtain next stock delivery date with product data export from Micronet Distribution adaptor.
  • Place billing and delivery address description fields into sales order CSV file generated by the Micronet Distribution adaptor
  • Place dash characters into empty fields of the sales order CSV file generated by the Micronet Distribution adaptor.
  • Remove empty instruction lines from the sales order CSV file generated by the Micronet Distribution adaptor
  • Setting to exclude payment comment lines from sales order CSV file, and Type3, Type4 text files generated by the Micronet Distribution adaptor.

Bug Fixes

  • Better error handling of scheduled data export Email notifications when the Email address has not been set against an adaptor.

0.24.1 Beta

Version: 0.24.1
Date: 28/01/2015
Time Released: 9:15pm ADST

New Features

  • Export account product pricing with pricing groups.

Improvements

  • Customer Account Product Contracts data exports no longer export out pricing.
  • Settings to exclude contract product pricing and category discount pricing being exported in Micronet Distribution adaptor's product account pricing data export.
  • Micronet Distribution adaptor to export contract product pricing and category discount pricing using pricing groups within the product account pricing data export.
  • Adaptor data exports labelled from User Accounts to Customer Accounts.

Bug Fixes

  • Micronet adaptor able to generate DataConnect CSV file when importing a sales orders with an arrival date set after 12pm.
  • Account product pricing not exported with Attache adaptor when account quantity break pricing matches price-level price.

0.23.1 Beta

Version: 0.23.1
Date: 15/12/2014
Time Released: 5:30pm ADST

New Features

  • Integration with the Datapel’s Warehouse Management System. Including data exports, account enquiry, and sales order imports.

Bug Fixes

  • Customer account balances correctly being exported in account enquiry requests from MYOB AccountRIght adaptor.
  • Customer account product pricing correctly being generated from category discount matrices in the Micronet Distribution adaptor.

0.22.1 Beta

Version: 0.22.1
Date: 25/11/2014
Time Released: 6:02pm

New Features

  • Integration with the Squizz.com Ecommerce System's API.
  • Import invoice payments into Micronet Distribution system with the Micronet adaptor.

Improvements

  • Export customer account pricing associated with contracts through the Customer Accounts data export.
  • Option to export Micronet contract product pricing data through the Account Product Pricing or Contract data exports for the Micronet adaptor.
  • Customer Account Contract data exported out to Ecommerce Standards Document (ESD) version 0.3.

Bug Fixes

  • Scheduled data export logs now correctly specify if the data export had run incrementally or in full.

0.21.1 Beta

Version: 0.21.1
Date: 27/10/2014
Time Released: 8:01pm

New Features

  • Configure and export Product Combination data using the Micronet adaptor.
  • All adaptors to cache exported product price-level pricing data when running a Product Pricing data export.

Improvements

  • Account Enquiry records exported from adaptors using the Ecommerce Standards Documents version 0.2.
  • Button in Adaptor Settings window to test the credentials of the TOTECS Ecommerce system settings.

Bug Fixes

  • Micronet adaptor to correctly handle duplicate product pricing records when generating data for a Product Account Pricing data export.

0.20.1 Beta

Version: 0.20.1
Date: 11/09/2014
Time Released: 7:30pm

New Features

  • Import Customer Account Payments into the connector.
  • View, modify and delete Customer Account Payments.
  • Export Product Combination data out of the connector.

Improvements

  • SAP Business One adaptor to being able to connect to MS SQL Server 2012 data source.

Bug Fixes

  • Micronet adaptor to correctly handle customer accounts assigned to invalid price levels when generating data for Product Account Pricing data export.

0.19.2 Beta

Version: 0.18.2
Date: 28/08/2014
Time Released: 4:04pm

New Features

  • Adaptor caching database for data exports.
  • Sending of incremental Product Account Pricing adaptor data export with only changes between the previous data sent.
  • Microsoft SQL Server Query Browser

Improvements

  • ODBC Connection Tester renamed to ODBC Query Browser.
  • Ability to load, test and query adaptor data exports using the SQL Server Query Browser or ODBC Query Browsers.
  • Display details of adaptor data exports/routine history records in its own window,
  • Adaptor data exports record the amount of rows added, updated, and deleted between incremental data exports.

Bug Fixes

  • MYOB EXO adaptor to correctly set the committed stock quantity when importing sales order products.
  • Brand field data correctly mapped to Product data export within MYOB Retail Manager adaptor.
  • Error message logs within Connector application correctly being highlighted in yellow again.

0.18.1 Beta

Version: 0.18.1
Date: 15/07/2014
Time Released: 5:12pm

New Features

  • Connector gets its own distinct logo.

Improvements

  • Micronet Order Product Delivery routine to no longer duplicate datetime suffix in product delivery filename.
  • MYOB EXO adaptor has the option to calculate product discount field when inserting sales order product lines into MYOB Exo.
  • Product Accounting Pricing data export timeout increased to 5 minutes.
  • User Accounts data export allows account limit, balance and terms data to be exported for all adaptors.
  • Sales Order table within the Connector application allows users to manually change the import and delivery status of orders.
  • Service Status table within the Connector application renamed to Adaptors and Messages.
  • Messages table within the Connector application loads only 400 messages at a time to increase application startup speed.
  • Minor styling improvements within Connector application’s information bars.

Bug Fixes

  • Micronet adaptor to have Products data successfully exported when products are marked as kitted.
  • Micronet adaptor to correctly export Product Account Pricing data when using the 64bit Micronet ODBC driver.
  • MYOB Retail Manager accounting adaptor to correctly reduce product stock levels when importing sales orders.
  • Adaptors able to correctly run scheduled Product Attribute exports for any adaptor.
  • MYOB EXO adaptor to correctly apply product category discounts when exporting Product Accounting Pricing data.
  • MYOB EXO adaptor to set the carrier field in the narrative when an sales order is imported into MYOB EXO adaptor.
  • Connector able to handle and export out large amounts of data without throwing memory exceptions, by using the disc to help compress large data sets for export.

0.17.1 Beta

Version: 0.17.1
Date: 07/04/2014
Time Released: 6:33pm

New Features

  • Micronet accounting adaptor to export out Product Flags, Warehouses and Stock Levels, Product Stock, Account Enquiry Invoices, Sales Orders, Backorders, Payments, Credits.
  • Product attribute data now imported with sales order data.
  • Micronet accounting adaptor to set product attribute order data as comment lines, when importing sales orders into Micronet.

Improvements

  • MYOB AccountRight adaptor to contain a setting that allows sales order data to be imported into AccountRight Plus 19 excluding the Location field.

Bug Fixes

  • None.

0.16.1 Beta

Version: 0.16.1
Date: 26/02/2014
Time Released: 6:00pm

New Features

  • Micronet accounting adaptor to export out Contracts, Product Quantity Pricing, Product Account Pricing, Product Alternate Codes.
  • SAP Business One adaptor to export product stock levels.
  • Setting a name against each accounting adaptor.
  • Email notifications for scheduled data exports or routines.

Improvements

  • Scheduled data exports routines that were missed now able to rescheduled on minute and hour intervals.
  • Ordering sales orders on the imported and delivered columns.
  • Attache accounting adaptor setting the carrier as a text line within the order submitted to Attache.

Bug Fixes

  • None.

0.15.1 Beta

Version: 0.15.1
Date: 16/01/2014
Time Released: 4:48pm

New Features

  • Micronet adaptor generating DataConnect order files in text file format.
  • Locking orders from being modified or deleted.
  • Setting delivered quantities against ordered products.
  • Scheduling data exports for all TOTECS data imports.
  • Micronet adaptor to export out Categories, Price Levels, Product Kits, Product Pricing, Products, Salesreps, Taxcodes, User Accounts, User Account Addresses
  • Micronet adaptor routine to generate product delivery text files.

Improvements

  • Exported data to set the total amount of records  contained in the header of the JSON data format.
  • Confirmation dialogs when users try to delete adaptors or orders.
  • Ordering scheduled data export/routine logs by the last run first.

Bug Fixes

  • xCBL invoices able to be sent from Micronet adaptor when more than one invoice file is generated.

0.14.2 Beta

Version: 0.14.2
Date
: 17/12/2013
Time Released: 5:15pm

New Features

  • All accounting adaptors to run and schedule “routines” developed for each adaptor.
  • Micronet adaptor to have a routine to import orders using text files.
  • Micronet adaptor to have a routine to export invoices to text files based on imported order text files.

Bug Fixes

  • Attache adaptor to ensure an ordering user account’s terms limit is being checked correctly when importing an order.
  • Attache adaptor to ensure that Product Pricing Account export returns pricing for products, when products are marked for the web using a user defined product field.
  • Attache adaptor to ensure products are not marked as backordered, when an order imports and the product stock has been marked as reserved.

0.13.1 Beta

Version: 0.13.1
Date: 12/11/2013
Time Released: 8:13pm

New Features

  • New adaptor that integrates into MYOB EXO. Includes all data imports/exports except for: product attributes, alternate codes, kits, live pricing
  • MYOB AccountRight Premier adaptor to allow products to have the next available stock date set in a description field, based on the date set from existing purchase orders.

Improvements

  • Date of the message logs display based on the date the message was logged at.
  • SAP Business One adaptor generated orders display the account’s company name in the billing address, and address description in the delivery address.

Bug Fixes

  • Accounting Connector to stop crashing when orders are being imported into SAP Business One.
  • Allow custom fields to be defined for Micronet data exports.

0.12.1 Beta

Version: 0.12.1
Date: 20/09/2013
Time Released: 12:18pm

New Features

  • Allow orders to imported into Micronet, both via the online ordering system or XML files in the xCBL3.0 data format.
  • Allow invoices to be exported from Micronet, based on the XML file xCBL3.0 data format.

Improvements

  • Configure the order field that stores the instructions in a SAP Business One adaptor generated order, as well as allow the purchase order number to have a prefix.

Bug Fixes

  • Have delivery address correctly set in SAP Business One adaptor generated orders.
  • Attache adaptor generated orders import when the instructions contain double characters.
  • Correctly check the status of a user account in Attache when the Attache adaptor is generating an order.

0.11.1 Beta

Version: 0.11.1
Date: 28/08/2013
Time Released: 8:19pm

New Features

  • Ability to import standardised web orders into Micronet
  • Order file conversion from xCBL XML documents into Micronet DataConnect order files.

Bug Fixes

  • Extra error handling when using SAP Business One’s comm. Object to check connections and import orders.
  • Ensure that Attache special pricing is exported when whitespaces are placed in special price fields.
  • Auto-deployment process to ensure files can be unzipped before being copied into Accounting Connector program files directory.

0.10.1 Beta

Version: 0.10.1
Date: 05/08/2013
Time Released: 8:19pm

New Features

  • Ability to import warehouses and warehouse product stock levels from MYOB AccountRight Premier/Enterprise
  • Sales Representatives able to be exported from SAP Business One
  • User Account Addresses able to be exported from SAP Business One

Improvements

  • More order data added into SAP Business One orders
  • MYOB AccountRight Premier orders now can have custom prefix text set for the comment field, as well as displaying a contact name in the delivery address field.

Bug Fixes

  • Date and product total fields correctly set when importing orders into MYOB AccountRight Premier/Enterprise

0.8.2 Beta

Version: 0.8.2
Date: 29/04/2013
Time Released: 8:45pm

Bug Fixes

  • Orders submitted into MYOB Premier round line item totals to ensure they import correctly.
  • Spelling error fixed within comment lines when orders are imported into Attache.

0.8.1 Beta

Version: 0.8.1
Date: 2/04/2013
Time Released: 6:22pm

Improvements

  • Orders submitted into MYOB Premier to have the terms of the order based off the account’s terms, or defined within the adaptor’s settings window.
  • Export products from Attache when products are flagged as web enabled using an Attache custom boolean product field.

Bug Fixes

  • Be able to select the KFI order folder directory using the Browse button in the Attache adaptor settings form.

0.7.1 Beta

Version: 0.7.1
Date: 12/02/2013
Time Released: 11:54am

New Features

  • Connector to send out fail/success order submission notifications when submitting orders into Attache or MYOB Retail Manager.

Bug Fixes

  • Bug fix to have individual sales rep users recorded against a MYOB Account Right Premier/Enterprise order.
  • MYOB Account Right adaptor to not use prepared statements to insert orders, which previously may have caused miscellaneous errors to occur.
  • Minor bug fixes.

0.6 Beta

Version: 0.6
Date: 29/01/2013
Time Released: 7:00pm

New Features

  • Connector to return Account Enquiry records from MYOB Premier adaptor.
  • Connector to return Account Status records from MYOB Premier and MYOB Retail Manager adaptors.
  • Configure and send out email notifications when orders are attempted to be imported in MYOB Premier.
  • Configure a separate ODBC DSN in MYOB Premier adaptor to write data (specifically orders) into MYOB Premier.
  • Connector to return product stock level data from MYOB Premier and MYOB Retail Manager adaptors.

Bug Fixes

  • Minor bug fixes.

0.5 Beta

Version: 0.5
Date: 19/12/2012
Time Released: 4:50pm

New Features

  • ODBC connection tester and SQL query tool built into the connector
  • MYOB Lock File Removal tool built into the connector

Improvements

  • Order list to automatically refresh every 1 minute
  • Data Export field restrictions to stop users being able to modify critical mappings within each accounting system adaptor
  • Allow the connector user interface application to always maintain connection to the host windows service

Bug Fixes

  • MYOB adaptor generated orders containing new line characters are removed, which were causing in the data to not import orders,
  • Minor bug fixes.

0.4 Beta

Version: 0.4
Date: 27/11/2012
Time Released: 6:18pm

New Features

  • Connector allows multiple accounting systems to be configured and connected simultaneously.

Bug Fixes

  • Minor bug fixes.

0.3 Beta

Version: 0.3
Date: 23/11/2012
Time Released: 4:09pm

New Features

  • MYOB Premier 18.5 accounting adaptor.
  • MYOB Retail Manager accounting adaptor.
  • Adaptors able to return the state of their database connectivity back to TOTECS projects.

Improvements

  • Attache optimisation of database queries.
  • Accounting Connector windows service automatically starts immediately after installation.
  • Changes made to the connector properties get automatically pushed to the connector’s windows service.

Bug Fixes

  • Minor bug fixes.

0.2 Alpha

Version: 0.02
Date: 18/10/2012
Time Released: 10:00pm

New Features

  • Attache 7 accounting connector.
  • SAP Business One 8.5 accounting adaptor returning user account invoice records for web Account Enquiry.
  • GZIP compression of all data coming from the connector.
  • Ability to configure and send out email notifications.

Improvements

  • User Interface automatically reconnects to the Windows Service using the inbuilt controls.

Bug Fixes

  • Other minor bug fixes.