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

Walkthrough

  1. Introduction
  2. System Requirements
  3. Main Screen
  4. Submissions: Adding A New Job
  5. Submissions: Configuring the Export Settings
  6. Submissions: Setting Up the Export Format
  7. Submissions: Using The Submissions Tab
  8. Submissions: Dealing With Errors
  9. Submissions: Handling Repeating Data
  10. Submissions: Exporting To Text Files
  11. Submissions: Exporting To Sql Server, MySQL, Oracle, Access, Sybase ASE, or ODBC
  12. Submissions: Exporting To Excel
  13. Submissions: Exporting To PowerPivot For Excel
  14. Submissions: Exporting to Word
  15. Submissions: Exporting To QuickBooks
  16. Submissions: Exporting To QuickBooks Customer
  17. Submissions: Exporting To QuickBooks Estimate, Sales Order, Invoice, Sales Receipt
  18. Submissions: Exporting To QuickBooks Vendor
  19. Submissions: Exporting To QuickBooks Purchase Order
  20. Submissions: Exporting To QuickBooks Item Receipt
  21. Submissions: Exporting To QuickBooks Bill
  22. Submissions: Exporting to QuickBooks Receive Payment
  23. Submissions: Exporting To QuickBooks Time Entry
  24. Submissions: Exporting To QuickBooks Online
  25. Submissions: Exporting To QuickBooks Online Customer
  26. Submissions: Exporting To QuickBooks Online Estimate, Invoice, Sales Receipt
  27. Submissions: Exporting To QuickBooks Online Vendor
  28. Submissions: Exporting To QuickBooks Online Purchase Order
  29. Submissions: Exporting To QuickBooks Online Bill
  30. Submissions: Exporting to QuickBooks Online Time Activity
  31. Submissions: Exporting To Sage 50 (Peachtree)
  32. Submissions: Exporting To Sage 50 Quote, Sales Order, Sales Invoice
  33. Submissions: Exporting To Sage 50 Customer
  34. Submissions: Exporting To Sage 100 (MAS 90 / MAS200)
  35. Submissions: Exporting To Sage 100 Sales Order, SO Invoice, AR Invoice
  36. Submissions: Exporting To SharePoint
  37. Submissions: Exporting To Salesforce.com
  38. Submissions: Exporting To Evernote
  39. Submissions: Exporting Attachments
  40. Submissions: Exporting PDF Report
  41. Submissions: Exporting A Specific Date Range
  42. Submissions: Filtering Submissions
  43. Submissions: Archive
  44. Submissions: Approve Before Exporting
  45. Submissions: Working With Date And Time Values
  46. Submissions: Working With Select One and Select Multiple fields
  47. Submissions: System Fields
  48. Submissions: Handling New Versions Of A Form
  49. Submissions: Networkfleet
  50. Submissions: Fleetmatics
  51. Lookup Table: Adding A New Job
  52. Lookup Table: Settings
  53. Lookup Table: From A Sql Source
  54. Lookup Table: From A File Source
  55. Lookup Table: From QuickBooks
  56. Lookup Table: From QuickBooks Online
  57. Lookup Table: From Sage 50
  58. Lookup Table: From SalesForce.com
  59. Lookup Table: From A SharePoint List
  60. Lookup Table: From NetworkFleet
  61. Lookup Table: From Fleetmatics
  62. Lookup Table: Filtering Records
  63. Dispatch: Adding A New Job
  64. Dispatch: Settings
  65. Dispatch: Format
  66. Dispatch: From An SQL Source
  67. Dispatch: From QuickBooks
  68. Dispatch: Tables And Repeating Sections From An SQL Source
  69. Dispatch: From A File Source
  70. Dispatch: Tables And Repeating Sections From An XML Source
  71. Dispatch: From Salesforce.com
  72. GPS: Adding A New Job
  73. GPS: Configuration
  74. Options: Calculations
  75. Options: Encryption
  76. Options: Proxy Server
  77. Options: Email Notifications
  78. Connecting to Sharepoint.com
  79. Connecting to Sharepoint
  80. Connecting To Cloud File Systems
  81. Connecting To SFTP
  82. Connecting To QuickBooks
  83. Connecting To QuickBooks: User Account
  84. Calculating tax on a form for QuickBooks
  85. Scheduling Jobs
  86. Job Log
  87. Run Jobs From An External Application
  88. Sending Information To Support
  89. Sending Job Configuration to Support
  90. Licensing
  91. Upgrading
  92. Backing Up And Restoring
  93. Webservice Quota
  94. Release Notes
  95. Release Notes 1.15.x
  96. Release Notes 1.14.x
  97. Release Notes 1.13.x
  98. Release Notes 1.12.x
  99. Release Notes 1.11.x
  100. Third Party Software

Feedback and Knowledge Base