Softpedia >Windows >Internet >Servers >Database Utils >Devart Excel Add-ins >  Changelog

Devart Excel Add-ins Changelog

What's new in Devart Excel Add-ins 2.6.791

Dec 20, 2021
  • Microsoft Excel 2021 is supported
  • Added modern encryption algorithms for MySQL and PostgreSQL
  • Excel Add-in for G Suite is renamed to Excel Add-in for Google Workspace
  • People API for Google Workspace is supported
  • The DealsStageHistory read-only table is added (Zoho CRM)
  • New App for Dynamics CRM signed by Microsoft
  • New BigCommerce table ProductCustomsInformation was added

New in Devart Excel Add-ins 2.5.704 (Aug 13, 2021)

  • Salesforce Web Services API version 52.0 is supported
  • ServerToServer Authentification Type was added to main Salesforce Marketing Cloud connection parameters
  • The field "NoteAttributes" of the "Orders" object and the field "Properties" of the "OrderDetails" object were added according to updates in Shopify API (version: 2021-04)

New in Devart Excel Add-ins 2.5.660 (Jun 10, 2021)

  • The ContactDetails object is added, it extends Contact with the additional columns Avatar, ViewAllTickets, Tags, OtherEmails, OtherCompanies (Freshdesk)
  • The Tags field is added to the Ticket object (Freshdesk)
  • The bug with multicolumn CONSTRAINT UNIQUE in PosgreSQL tables is fixed

New in Devart Excel Add-ins 2.5.609 (Apr 1, 2021)

  • The list of available domains in Connection Editor is supplemented with crm.zoho.com.au and crm.zoho.in (Zoho CRM)
  • The objects DynamicContentItem and DynamicContentItemVariant are added (Zendesk)
  • The bug with the "Unexpected SugarType 'call-recording'" error is fixed (SugarCRM)

New in Devart Excel Add-ins 2.5.609 (Apr 1, 2021)

  • The list of available domains in Connection Editor is supplemented with crm.zoho.com.au and crm.zoho.in (Zoho CRM)
  • The objects DynamicContentItem and DynamicContentItemVariant are added (Zendesk)
  • The bug with the "Unexpected SugarType 'call-recording'" error is fixed (SugarCRM)

New in Devart Excel Add-ins 2.5.572 (Feb 8, 2021)

  • Token server is supported for FreshBooks
  • New entity "current_total_price_set_presentment_money" is supported for Shopify Orders
  • New field "Tags" is added to Freshdesk Ticket
  • New option "Save line breaks in multi-line text cells as" is added to Options -> Edit
  • The behaviour is changed: currently line breaks are saved as CR LF
  • The bug with "Unexpected SugarType 'discount-amount'" error is fixed for SugarCRM
  • The bug with "Page cannot be passed" is fixed for Shopify
  • The bug with "QueryValidationError: Property PaymentMethodRef not found for Entity SalesReceipt" error is fixed for QuickBooks SalesReceipt
  • The bug with blank page for QuickBooks is fixed
  • The bug with "the module name given seems to be invalid" error is fixed for Zoho CRM
  • The bug with "Out of memory" error is fixed for all cloud providers
  • The bug with "'Type System.Collections.BitArray...' is not allowed here" error is fixed

New in Devart Excel Add-ins 2.5.502 (Oct 20, 2020)

  • Dynamics CRM objects 'relationship' and 'relationshipattribute' were removed from the list to fix the "The 'RetrieveMultiple' method does not support entities of type" error
  • The messages about subscription status in the Register Product dialog are supplemented with additional information
  • The bug with the "Unexpected SugarType 'widget'" error is fixed for SugarCRM
  • The bug with the "An item with the same key has already been added" error is fixed for SugarCRM
  • The bug with the "Oauth error missing_shopify_permission: read_all_orders" error was fixed for Shopify

New in Devart Excel Add-ins 2.5.441 (Jul 23, 2020)

  • SSH is supported in the Direct mode (Oracle)
  • SSL/TLS is supported in the Direct mode (Oracle)
  • License number is added to the Copy Info and About/Register windows
  • The ExchangeRate field is added to the Invoice object (QuickBooks)
  • The behavior is changed: now Import Data Wizard is opened and filters are restored in case the connection is not valid
  • The bug with the "Field 'Id' can not be sorted in a query call" error is fixed (Salesforce)

New in Devart Excel Add-ins 2.4.412 (Jun 12, 2020)

  • Web Login for Dynamics CRM is supported (Dynamics CRM)
  • A relation with Partitions through 'leadPartitionId' on Lead records is added for Marketo (Marketo)
  • The fields InventoryQuantity, OldInventoryQuantity and InventoryQuantityAdjustment from the object ProductVariants are made read-only according to updates in Shopify API (Shopify)
  • A bug with invisible 'UniqueExternalId' field in Freshdesk Contact object is fixed (Freshesk)

New in Devart Excel Add-ins 2.3.369 (Apr 13, 2020)

  • The new option "SQL Server command timeout" is added to Options -> Advanced
  • The bug with an error "Invalid column #0" for creating new columns manually for PostgreSQL is fixed (PostgreSQL)
  • The bug with reading the service_end_date column from the Products table is fixed (SugarCRM)
  • The bug with reading records with different values of ActivityTypeId from the Activities table is fixed (Marketo)
  • The bug with an error "Required fields are missing [ContactId]" that appeared for Salesforce Opportunity object during creation of a new entry is fixed (Salesforce)

New in Devart Excel Add-ins 2.3.314 (Jan 24, 2020)

  • QuickBooks OAuth 2.0 is supported
  • The parameter to select QuickBooks environment - Production or Sandbox - is added to the Connection Editor dialog box
  • A bug with disappearing row after update in Edit Mode for Zoho CRM is fixed

New in Devart Excel Add-ins 2.2.238 (Dec 11, 2019)

  • BigCommerce API v3 is supported
  • New Search API result limits implemented (Zendesk)

New in Devart Excel Add-ins 2.1.267 (Nov 19, 2019)

  • PostgreSQL 12 is supported
  • Web Login for HubSpot is supported
  • The Local SQL Engine advanced connection parameter, determining whether to run locally complex SQL statements that cannot be translated directly to corresponding cloud API calls or to display an error message, is added to Excel Add-ins for cloud applications
  • The Failover Retries advanced connection parameter, determining the number of attempts to re-run commands, failed because of a reason that may be temporary, before displaying an error message, is added to Excel Add-ins for cloud applications
  • The object LineItems is added (HubSpot)
  • The new authentication type ServerToServer is implemented (Salesforce Marketing Cloud)

New in Devart Excel Add-ins 2.0.62 (Jan 18, 2019)

  • Microsoft Excel 2019 is supported
  • Freshdesk API v2 is supported
  • PostgreSQL 11 is supported
  • The TicketDetails object with additional information about tickets is added for Freshdesk
  • The new option "Escape text values that start with '$' so Excel does not convert them" is added to Options -> Import -> Data -> Escaping
  • The possibility to edit data of user-defined SQL queries or views with a ROWID column is supported for Oracle database
  • The default value of the "API Version" connection parameter for FreshBooks is changed from Classic to Alpha

New in Devart Excel Add-ins 2.0.2 (Oct 24, 2018)

  • New FreshBooks API (alpha) is supported
  • The API v2 for Zoho CRM is supported
  • The PaymentPayouts object is added to Shopify
  • The default value for the "API Version" connection parameter for MailChimp is changed from v2 to v3

New in Devart Excel Add-ins 1.8.868 (Sep 18, 2018)

  • FreshBooks API (alpha) is supported
  • The API v2 for Zoho CRM is supported
  • The PaymentPayouts object is added to Shopify
  • The default value for the "API Version" connection parameter for MailChimp is changed from v2 to v3

New in Devart Excel Add-ins 1.7.797 (May 30, 2018)

  • Data refresh is significantly improved:
  • Refresh now preserves user's data on the same worksheet outside of the table with imported data
  • Data sorting in the table with imported data is now preserved if Keep table if exists and Keep table sorting check boxes are selected in Refresh Options
  • Table style the table with imported data is now preserved if Keep table if exists check box is selected in Refresh Options
  • Excel Add-ins now display the progress of Refresh and Refresh All operations and allow canceling them
  • Refresh Options are added:
  • Confirm 'Refresh' action - determines whether to display the confirmation dialog box when refreshing data on the current worksheet
  • Confirm 'Refresh All' action - determines whether to display the confirmation dialog box when refreshing data on all the worksheets
  • Keep table if exists - determines whether to re-create an Excel table with imported data or to keep an existing one when refreshing data
  • Keep table sorting - Determines whether to keep sorting settings in an Excel table with imported data when refreshing data
  • Refresh now preserves references to imported table cells in Excel formulas if there is no user data under the table with imported data
  • The behaviour is changed: now Refresh is not allowed if there is a user's table below the table with imported data
  • The behaviour is changed: now Refresh preserves the number of empty rows between the table with imported data and user's data below it
  • Edit Mode is greatly improved:
  • Edit Mode now allows using AutoFill using the fill handle
  • Edit Mode now allows using formulas, scripts, comments, etc.
  • Edit Mode now allows editing data on the same worksheet outside of the table with imported data
  • Edit Mode now allows copying/pasting data from the same workbook with the table with imported data
  • Edit Mode now allows copying/pasting of multiple rows
  • Edit Mode now allows and preserves sorting and filtering (AutoFilter) of the table with imported data
  • Edit Mode now preserves comments for the cells of the table with imported data
  • Edit Mode now allows and preserves hiding and unhiding columns
  • For cloud sources, if a field accepts only a value from a fixed list of allowed values, Devart Excel Add-ins support selecting a value from a drop-down list of allowed values both when editing a cell and in table filters
  • Optional underlining is now used instead of the popup comments when inserting a new row and moving focus out of it without filling all the required columns
  • The Advanced edit mode check box (selected by default) is added to the Edit - General options for reverting back to pre-1.7 Edit Mode
  • Options for selecting underlining color for cells of a new row are added
  • Excel Add-ins now check if a value is set for relational database columns that are declared as NOT NULL in the database and have no default value when the "Validate required (not null without default value) columns for RDBMS" check box is selected in the Edit - General options
  • Excel Add-ins now display the progress of committing changes to the data source
  • The table with the imported data now can be moved to any place on the worksheet, and after this can be correctly refreshed or edited in the Edit Mode
  • Windows scaling for high-DPI devices is supported
  • The RegionId field is added to CustomerAddresses for Magento 2 (Magento)
  • The Magento connection editor is improved for Ver2 servers (Magento)
  • The "Use Custom Fields" parameter is added to Zendesk connections to determine whether to read custom fields for Ticket, Request, View, User, Organization objects (Zendesk)
  • The possibility to connect to Salesforce Sandbox is implemented (Salesforce)
  • INSERT and UPDATE operations support for AccountUser in Salesforce Marketing Cloud is added (Salesforce Marketing Cloud)
  • The behaviour is changed: now date values for filters are generated with the time 00:00 by default. This behaviour can be changed with the Options > Import > Filter > "DateTime picker editor default value" option
  • Now Excel Add-ins do not try to load more then 65536 records for the Excel 97-2003 file format and more than 16384 records for the Excel 5.0 and Excel 95 file format and display the corresponding warning message

New in Devart Excel Add-ins 1.7.748 (Mar 20, 2018)

  • Data refresh is significantly improved:
  • Refresh now preserves user's data on the same worksheet outside of the table with imported data
  • Data sorting in the table with imported data is now preserved if Keep table if eists and Keep table sorting check boes are selected in Refresh Options
  • Table style the table with imported data is now preserved if Keep table if eists check bo is selected in Refresh Options
  • Ecel Add-ins now display the progress of Refresh and Refresh All operations and allow canceling them
  • Refresh Options are added:
  • Confirm 'Refresh' action - determines whether to display the confirmation dialog bo when refreshing data on the current worksheet
  • Confirm 'Refresh All' action - determines whether to display the confirmation dialog bo when refreshing data on all the worksheets
  • Keep table if eists - determines whether to re-create an Ecel table with imported data or to keep an eisting one when refreshing data
  • Keep table sorting - Determines whether to keep sorting settings in an Ecel table with imported data when refreshing data
  • Refresh now preserves references to imported table cells in Ecel formulas if there is no user data under the table with imported data
  • The behaviour is changed: now Refresh is not allowed if there is a user's table below the table with imported data
  • The behaviour is changed: now Refresh preserves the number of empty rows between the table with imported data and user's data below it
  • Edit Mode is greatly improved:
  • Edit Mode now allows using AutoFill using the fill handle
  • Edit Mode now allows using formulas, scripts, comments, etc.
  • Edit Mode now allows editing data on the same worksheet outside of the table with imported data
  • Edit Mode now allows copying/pasting data from the same workbook with the table with imported data
  • Edit Mode now allows copying/pasting of multiple rows
  • Edit Mode now allows and preserves sorting and filtering (AutoFilter) of the table with imported data
  • Edit Mode now preserves comments for the cells of the table with imported data
  • Edit Mode now allows and preserves hiding and unhiding columns
  • For cloud sources, if a field accepts only a value from a fied list of allowed values, Devart Ecel Add-ins support selecting a value from a drop-down list of allowed values both when editing a cell and in table filters
  • Optional underlining is now used instead of the popup comments when inserting a new row and moving focus out of it without filling all the required columns
  • The Advanced edit mode check bo (selected by default) is added to the Edit - General options for reverting back to pre-1.7 Edit Mode
  • Options for selecting underlining color for cells of a new row are added
  • Ecel Add-ins now check if a value is set for relational database columns that are declared as NOT NULL in the database and have no default value when the "Validate required (not null without default value) columns for RDBMS" check bo is selected in the Edit - General options
  • Ecel Add-ins now display the progress of committing changes to the data source
  • The table with the imported data now can be moved to any place on the worksheet, and after this can be correctly refreshed or edited in the Edit Mode
  • Windows scaling for high-DPI devices is supported
  • The RegionId field is added to CustomerAddresses for Magento 2 (Magento)
  • The Magento connection editor is improved for Ver2 servers (Magento)
  • The "Use Custom Fields" parameter is added to Zendesk connections to determine whether to read custom fields for Ticket, Request, View, User, Organization objects (Zendesk)
  • The possibility to connect to Salesforce Sandbo is implemented (Salesforce)
  • INSERT and UPDATE operations support for AccountUser in Salesforce Marketing Cloud is added (Salesforce Marketing Cloud)
  • The behaviour is changed: now date values for filters are generated with the time 00:00 by default. This behaviour can be changed with the Options > Import > Filter > "DateTime picker editor default value" option
  • Now Ecel Add-ins do not try to load more then 65536 records for the Ecel 97-2003 file format and more than 16384 records for the Ecel 5.0 and Ecel 95 file format and display the corresponding warning message

New in Devart Excel Add-ins 1.6.469 (Jan 27, 2017)

  • New features in Devart Excel Add-ins 1.6:
  • Freshdesk is now supported
  • G Suite is now supported
  • HubSpot is now supported
  • Marketo is now supported
  • NetSuite is now supported
  • Shopify is now supported
  • Zendesk is now supported
  • The new option "Read-only primary key columns for the existing (committed) records" is added to Options > Edit > General

New in Devart Excel Add-ins 1.5.319 (Jun 28, 2016)

  • TLS 1.1 is supported
  • Field validation for cases when values must be unique or NULL is implemented
  • The new option "Escape text values that end with '%' so Excel does not treat them as percentage" is added to Options -> Import -> Data -> Escaping
  • The new option "Escape text values that contain special chars so Excel does not treat them as datetime" is added to Options -> Import -> Data -> Escaping
  • A new required column "Item" is added to the OrderShipments table for BigCommerce (BigCommerce)
  • The "is null" and "is not null" filter operators for mandatory fields in Zoho CRM is added (Zoho CRM)
  • The speed of processing of modifying a large number of cells at once when the edit mode is on is greatly improved
  • The behaviour is changed: now the default value for the 'Unicode' parameter of the connection to a PostgreSQL database is True (PostgreSQL)

New in Devart Excel Add-ins 1.5.234 (Feb 12, 2016)

  • Excel 2016 is supported
  • Magento is now supported
  • ExactTarget is now supported
  • Web Login for Salesforce is supported
  • The ABTestingCampaigns table for getting Campaigns with the A/B testing type is added for MailChimp (MailChimp)
  • A progress indicator for execution of a query for data preview in Import Data Wizard with the possibility to cancel the operation has been added
  • The implementation of refresh is improved: now data in Excel worksheet columns not belonging to an imported table is not deleted after refreshing

New in Devart Excel Add-ins 1.2.130 (Sep 3, 2015)

  • The MergeFieldsDetectionBehavior connection string parameter is implemented for MailChimp to determine which merge tags to add to the ListMembers table
  • Validation of entered unsigned number values is implemented
  • Validation of entered enum field values for all supported cloud sources is implemented

New in Devart Excel Add-ins 1.2.126 (Aug 27, 2015)

  • FreshBooks and Bigcommerce support is added
  • The new option "Refresh all columns after commit" with default value true for refreshing data after commit is added to Options -> Edit -> General
  • The new option "Read-only cells of new row" for changing color for read-only cells in a new row is added to Options -> Edit -> Appearance
  • The new option "Show commit error message" is added to Options -> Edit -> Error Handling
  • The performance of importing data to Excel was significantly improved with memory use optimizations

New in Devart Excel Add-ins 1.1.83.0 (Jul 21, 2015)

  • QuickBooks and MailChimp support is added