Release Notes 1.13.x

1.13.55 2016-08-30

Bug

  • [INTSYNC-173] - Time fields include date portion if "Convert submission times to local" option is selected
  • [INTSYNC-174] - Time calculation fields are converted to date/time if "Convert submission times to local" is selected
  • [INTSYNC-372] - Job with both data and attachment export to Box fails to refresh authentication token

New Feature

  • [INTSYNC-363] - Run job based on file saved into monitored folder

Improvement

  • [INTSYNC-373] - Add ability to specify number of times to check if a file exists before overwriting
  • [INTSYNC-374] - Add option to set format to parse calculated Date/Time fields

1.13.54 2016-08-16

1.13.53 2016-08-16

New Feature

Improvement

1.13.52 2016-08-12

Improvement

  • [INTSYNC-370] - Add BillAddressBlock and ShipAddressBlock fields to QB Customer lookup table

1.13.51 2016-08-11

Bug

  • [INTSYNC-368] - Box authentication lost during internal token refresh when multiple connections are active

Improvement

  • [INTSYNC-369] - Convert Quickbooks Online authorization to use default browser

1.13.50 2016-08-09

Bug

  • [INTSYNC-366] - Box connection times out with large files

1.13.49 2016-08-08

Bug

  • [INTSYNC-365] - Missing end brace in dispatch format field causes job to fail

1.13.48 2016-08-05

Bug

  • [INTSYNC-362] - Box authentication fails
  • [INTSYNC-364] - Can't authorize Google Drive because browser is not supported

New Feature

  • [INTSYNC-361] - Add SMS notification based on submission data

1.13.47 2016-07-29

Bug

1.13.46 2016-07-27

Bug

  • [INTSYNC-358] - Error: Invalid URI: The format of the URI could not be determined. when using IP address for proxy server

Improvement

  • [INTSYNC-359] - Improve display of windows service status.

1.13.45 2016-07-26

Bug

  • [INTSYNC-354] - NullReferenceException when using SaveBinaryDirect in SharePoint Library export

New Feature

Improvement

  • [INTSYNC-353] - Change discount percentage (Price) to numeric in QuickBooks Item lookup table

1.13.44 2016-07-15

Improvement

  • [INTSYNC-339] - Add option to make attachments not overwrite
  • [INTSYNC-344] - Populate Worksheet field of Excel connection if left blank
  • [INTSYNC-350] - Add option to set SharePoint auth

1.13.43 2016-07-12

Bug

  • [INTSYNC-351] - "Conversion from string "-" to type 'Double' is not valid" error in MySql connection

1.13.42 2016-07-11

Improvement

  • [INTSYNC-341] - Add option to use DAV to upload files to SharePoint

1.13.41 2016-07-08

Bug

1.13.40 2016-07-07

Bug

  • [INTSYNC-338] - Dispatch web service expects blank values for unpopulated table fields
  • [INTSYNC-346] - Request for Excel report waits 60 seconds each time.

Improvement

  • [INTSYNC-345] - Add option to use OLEDB 15 and 16
  • [INTSYNC-347] - Remove control characters from lookup table payload

1.13.39 2016-07-01

Bug

  • [INTSYNC-340] - Lookup table from SalesForce does not correctly parse sub query fields
  • [INTSYNC-343] - Error: "Cannot find column (local)" on new Excel lookup table job

1.13.38 2016-06-27

Bug

  • [INTSYNC-337] - Auto created insert statement fails in Access Automation

1.13.37 2016-06-21

Bug

  • [INTSYNC-335] - Dispatching from normalized data does not work for Access data source

New Feature

1.13.36 2016-06-17

Bug

1.13.35 2016-06-14

New Feature

  • [INTSYNC-319] - Add QuickBooks Receive Payment transaction
  • [INTSYNC-330] - Add QuickBooks Invoice List lookup table

Improvement

  • [INTSYNC-329] - Replace carriage return in lookup table data with <br> tag

1.13.34 2016-06-10

Bug

  • [INTSYNC-328] - QB Amount field incorrectly set for Subtotal type items

Improvement

1.13.33 2016-06-06

Bug

  • [INTSYNC-326] - QuickBooks subtotal item should not have quantity applied

Improvement

  • [INTSYNC-324] - Add Record Name field to Submissions tab
  • [INTSYNC-325] - Add deactivate option to license screen

1.13.32 2016-06-01

Bug

  • [INTSYNC-323] - Score categories with spaces in the name don't display

Improvement

  • [INTSYNC-285] - Create multiple QB transactions from single submission, one for each unique Customer
  • [INTSYNC-321] - Add support for SharePoint Lookup field
  • [INTSYNC-322] - Add Subtotal items to Item lookup table

1.13.31 2016-05-27

Improvement

1.13.30 2016-05-26

Improvement

1.13.29 2016-05-25

Bug

  • [INTSYNC-315] - QB SalesOrder Dispatch does not find recent Sales Orders

1.13.28 2016-05-24

Bug

  • [INTSYNC-313] - Microsoft.Win32.TaskScheduler.NotV1SupportedException: TaskSchedulerHelper.RunTask is not supported on Task Scheduler 1.0

1.13.27 2016-05-23

Bug

1.13.26 2016-05-18

Bug

  • [INTSYNC-310] - QB SalesOrder Dispatch query fails if line is a link

Improvement

  • [INTSYNC-308] - Connect Networkfleet data to submission detail records
  • [INTSYNC-309] - Add ROUND function to Excel type calculation engine

1.13.25 2016-05-16

Bug

  • [INTSYNC-311] - Networkfleet fails if date range is not correct

1.13.24 2016-05-16

1.13.23 2016-05-16

New Feature

  • [INTSYNC-307] - Add Networkfleet vehicle query types: Label, Serial Number

1.13.22 2016-05-13

New Feature

  • [INTSYNC-305] - Add lookup table of NetworkFleet vehicles
  • [INTSYNC-306] - Add lookup table of NetworkFleet drivers

1.13.21 2016-05-13

Bug

  • [INTSYNC-303] - Edited submissions don't export to SharePoint
  • [INTSYNC-304] - QB Sales Order Dispatch doesn't recognize Group items

1.13.20 2016-05-11

Bug

  • [INTSYNC-295] - Installer reports insufficient rights to install service
  • [INTSYNC-299] - QB SalesOrder Dispatch query fails if Class not configured in QB
  • [INTSYNC-300] - UnauthorizedAccessException when running task under administrator account

New Feature

  • [INTSYNC-302] - Add Run On Startup option to Tools menu

Improvement

  • [INTSYNC-296] - Improve error message if specified worksheet not found in GSheet file
  • [INTSYNC-297] - Replace incompatible path characters with underscore in merged paths
  • [INTSYNC-298] - Log MB downloaded and uploaded by account
  • [INTSYNC-301] - Store mapped drive paths as UNC paths

1.13.19 2016-05-06

Bug

  • [INTSYNC-293] - Attachments not added to repeating section in Word export
  • [INTSYNC-294] - Error when creating new QB Sales Order Dispatch job

1.13.18 2016-05-04

Bug

  • [INTSYNC-288] - Word export adds extra line to tables

New Feature

  • [INTSYNC-82] - Use submission data to define resulting path for file type exports

Improvement

  • [INTSYNC-238] - Refresh Submissions tab when webservice changes
  • [INTSYNC-291] - Add Email field to QB Vendor list

1.13.17 2016-04-28

Bug

Improvement

  • [INTSYNC-189] - Remove account code from calls to update lookup tables

1.13.16 2016-04-28

1.13.15 2016-04-27

Bug

  • [INTSYNC-284] - Settings not saved when upgraded by Service

New Feature

1.13.14 2016-04-20

Bug

  • [INTSYNC-264] - Post Dispatch sql step incorrectly determines data type of parameters for MySQL
  • [INTSYNC-272] - Currency symbol not removed from QB Invoice Line:Rate field
  • [INTSYNC-274] - Access connection does not bracket table name in DROP command

Improvement

1.13.13 2016-04-12

Bug

New Feature

  • [INTSYNC-251] - Add Filter to QB, QBO, Xls, Csv, and Xml lookup table jobs

Improvement

  • [INTSYNC-161] - Handle error Receive Data Error Intuit.Ipp.Exception.InvalidTokenException: Intuit.Ipp.Exception.InvalidTokenException: Unauthorized-401 as a disconnect from QBO
  • [INTSYNC-267] - If Sales Order field is populated in QuickBooks Invoice, create Invoice from Sales Order
  • [INTSYNC-268] - Add additional fields to QBO lookup tables
  • [INTSYNC-270] - Add option to view template only preview on Format tab

1.13.12 2016-04-06

New Feature

Improvement

1.13.11 2016-03-22

Improvement

  • [INTSYNC-260] - Add ability to choose between NCalc and CalcEngine calculation engines

1.13.10 2016-03-14

Bug

  • [INTSYNC-257] - Unhandled exception : Screen-compatible bitmap cannot be created.

Improvement

  • [INTSYNC-259] - Add ability for TEXT function to format Date/Time values

1.13.9 2016-03-10

Bug

  • [INTSYNC-256] - Unhandled exception when entering incorrectly formatted webservice ID

1.13.8 2016-03-04

Bug

  • [INTSYNC-255] - Salesforce attaches document to incorrect record if more than one submission is exported at a time

New Feature

Improvement

  • [INTSYNC-170] - Switch to expression engine that includes basic text formatting and if logic

1.13.7 2016-03-03

Bug

  • [INTSYNC-187] - Email notification test becomes unresponsive if timeout happens in test

New Feature

Improvement

  • [INTSYNC-253] - Detect html formatting in submission email message

1.13.6 2016-03-01

New Feature

  • [INTSYNC-243] - Email attachment or merged document(s) from submission

Improvement

  • [INTSYNC-252] - Add additional $$# to PDF file names from aspose web service

1.13.5 2016-02-19

Bug

  • [INTSYNC-249] - Unhandled exception can cause job scheduler to stop

Improvement

  • [INTSYNC-248] - Add drag and drop from Available Parameters

1.13.4 2016-02-18

Bug

  • [INTSYNC-242] - Scheduled job doesn't run if previous group of jobs takes too long
  • [INTSYNC-246] - Xls export will not overwrite existing worksheet

Improvement

  • [INTSYNC-203] - Segregate log files by process instance

1.13.3 2016-02-15

Improvement

  • [INTSYNC-63] - Store authentication settings by account
  • [INTSYNC-150] - Track metrics: Jobs, runs, records, errors, devices.
  • [INTSYNC-240] - Convert licensing to seat based approach (prep for SalesForce)

1.13.2 2016-01-26

Bug

  • [INTSYNC-237] - Treat repeat one as repeat includes layout grids

1.13.1 2016-01-22

Bug

  • [INTSYNC-232] - QuickBooks lookup table jobs fail until they are saved
  • [INTSYNC-233] - Postal Code not included in QuickBooks Ship To address list

New Feature

  • [INTSYNC-234] - Add Current on hand values to QuickBooks Item list lookup table
  • [INTSYNC-235] - Add option to treat repeating sections with 1 repeat as repeats
  • [INTSYNC-236] - Add ability to hold CTRL + double click to append field to current field

1.13.0 2016-01-14

Bug

  • [INTSYNC-226] - Check for updates happens too frequently
  • [INTSYNC-229] - System.Data.StrongTypingException: The value for column 'DispatchStatusName' in table 'Dispatch' is DBNull.
  • [INTSYNC-230] - Column headers are not created in xlsx export if worksheet already exists
  • [INTSYNC-231] - Export to new xlsm produces file that can only be opened as xlsx

Improvement

Feedback and Knowledge Base