Help Centre Forum

TOTECS Forums

Connector 1.7 Beta Released
Author
Thread

Author moderator
13th December 2016

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.