Softpedia >Windows >Office tools >Other Office Tools >XL-Connector >  Changelog

XL-Connector Changelog

What's new in XL-Connector 3.4.3.9

Jul 6, 2023
  • It is now possible to use Owner Change Options for certain standard objects like Account, Opportunity, etc.
  • Queries that are longer than 100,000 characters are now supported. For example dynamic queries like Select Name, Id from Account where Id in [A2:A100000] will now run successfully.
  • Plug-in features for the Team Player subscription users can be adjusted centrally by the company admin from the self serve customer portal.
  • Id lookup is now supported for standard objects that don’t have a Name field. Cases are looked up by the CaseNumber field, Tasks and Activities – by the Subject field.
  • Easy pick of a cell to be used as a dynamic constant value for mappings.
  • Moved to API v. 56
  • The history of the recently used mappings is now kept in the Mappings dialog box and can be reused
  • Various bug fixes and performance enhancements

New in XL-Connector 3.3.6.7 (Apr 14, 2021)

  • Users utilizing multiple Salesforce orgs will find this particularly useful, but even if you are logging in to the same org every day, logging in via SSO takes some time and it is very handy to be able to log in in one click. This is what the latest version of XL-Connector allows you to do.
  • Web and SSO Login dialog box now provides the various new options.
  • Once remembered, XL-Connector can log in to the org automatically when Excel starts or you can quickly log in to the required Salesforce instance in one click.
  • You can also quickly switch between orgs when logged in.

New in XL-Connector 3.3.2.8 (May 13, 2020)

  • Query Rows function can now be used on a filtered data set. Only visible rows will be considered for the operation.
  • You can now manage some of your picklist fields using a new function in XL-Connector Enterprise Admin:
  • Get Data using SOQL dialog box has been rearranged to allow for longer object names:

New in XL-Connector 3.3.2.4 (Mar 4, 2020)

  • New licensing system support Various bug fixes and stability improvements

New in XL-Connector 3.3.1.4 (Jan 15, 2020)

  • It is now possible to activate/deactivate Flows and Processes with a checkbox: An issue with running the plug-in on Excel 2007 and 2010 has been fixed.

New in XL-Connector 3.3.1.3 (Jan 14, 2020)

  • SOAP API updated to 47.0 Metadata API updated to 47.0 Tooling API updated to 47.0 Added initial support for Flows and Processes management Tooling API SOQL queries are now fully supported, including the query builder.

New in XL-Connector 3.3.1.2 (Dec 5, 2019)

  • Using XL-Connector Enterprise Admin, you can now mass activate/deactivate/create/edit/delete Workflow rules in your Salesforce organization from a single Excel spreadsheet!

New in XL-Connector 3.3.1.1 (Nov 5, 2019)

  • Using XL-Connector Enterprise Admin, you can now mass activate/deactivate/create/edit/delete validation rules for all objects in your Salesforce organization from a single Excel spreadsheet!

New in XL-Connector 3.2.9.5 (Jun 10, 2019)

  • Correct Date and DateTime column detection for reports grouped by Date or/and DateTime columns.

New in XL-Connector 3.2.9.4 (Jun 8, 2019)

  • Critical performance update! If you’ve been experiencing performance issues when doing Insert, Upsert, or Update – please update your version by clicking on Settings -> Update.
  • Convert Leads function will now let you map the Contact object fields to the data in your spreadsheet. This will allow to set such things as the Record Type Id for the Contact records as well as populate custom fields on the Contact object with data from the converted leads:
  • Select/Deselect All buttons have been added to the Get Data dialog letting you select all fields at once. To select all fields from a related object, select the relational field (e.g. OwnerId) and click Select All, this will add all owner (User) fields to the query.

New in XL-Connector 3.2.9.0 (May 20, 2019)

  • Have you been getting a “Use one of these records?;” error when trying to create a new Account, Contact, or Lead? This is the result of the Salesforce native duplicate checking rules.
  • Starting from version 3.2.9.0, XL-Connector has an option to bypass these rules:
  • The method parameters for Insert, Update, and Upsert VBA calls have also changed to include a new parameter. If you are using any of these methods, please review your VBA code and make sure you’re passing the new parameter:
  • Update records:
  • string[,] UpdateData(object[,] data, string objName, bool useAssgnRule, string assignmentRuleId, bool ignoreNativeDuplicateChecks, out string errorText)
  • Insert records:
  • string[,] InsertData(object[,] data, string objName, bool useAssgnRule, string assignmentRuleId, bool ignoreNativeDuplicateChecks, out string errorText)
  • Upsert records:
  • string[,] UpsertData(object[,] data, string objName, string extIdColumn, bool useAssgnRule,</b> <b>string assignmentRuleId, bool ignoreNativeDuplicateChecks, out string errorText)

New in XL-Connector 3.2.8.9 (May 1, 2019)

  • New VBA function to open the Web and SSO Login window:
  • ShowSSOLogin([optional] url)
  • If the optional url parameter is passed – the window will open and automatically go to that url. Use it to specify your custom SSO page address, for example https://myDomain.my.salesforce.com
  • Field Utilization tool will now not show any non-filterable fields.

New in XL-Connector 3.2.8.7 (Apr 18, 2019)

  • A couple limitations with scheduling of automatic operations in XL-Connector to keep in mind:
  • Since the app is running only when Excel is running, you need to have Excel running and the workbook, in which the flow is located, open to be able to use this functionality.
  • You need to be logged in to Salesforce with the Security Token method with the ‘Remember Password’ box checked, so that we could log you back in in case your login session expires before the scheduled run.

New in XL-Connector 3.2.8.2 (Mar 8, 2019)

  • A new Data Sources dialog is now available for XL-Connector Personal Edition and Team Player users making it easier to see and manage connections to Salesforce within a single workbook
  • Total Rows option is now supported in Data Tables. Starting from this version, if you have a Totals row in your data table – it will not be wiped out on refresh even if the number of rows in the table changes
  • You can now disconnect a data source from a Flow Step if you are using XL-Connector Enterprise Admin
  • You can now execute anonymous Apex code from inside of a Flow Step
  • You can now execute anonymous Apex code from VBA too
  • You can now run specific flow steps (not the whole flow) from VBA:

New in XL-Connector 3.2.7.3 (Jan 30, 2019)

  • Administrator installation flow will not ask the users to register if a license is built in to the installation.

New in XL-Connector 3.2.7.1 (Jan 29, 2019)

  • Various issues fixed

New in XL-Connector 3.2.5.6 (Nov 11, 2018)

  • Refresh button will now produce a progress dialog box. Several issues fixed across the plug-in

New in XL-Connector 3.2.5.4 (Oct 27, 2018)

  • Running all Flows in the entire workbook is now available. Click on Run All Flows button to start them. XL-Connector will go through every worksheet and if there’s a flow with active flow steps there – they will get run.
  • You can now use VBA to run your Flows. The following VBA functions are available:
  • Run the Flow in a given worksheet
  • bool RunFlow(Worksheet ws, out error)
  • This function will run all active Flow steps in a given worksheet. If there’s an error, the function will return False and the error text will be in the ‘error’ output variable.
  • Run all Flows in the active workbook
  • bool RunAllFlows(out error)
  • This function will run all Flows in your document. If there’s an error, the function will return False and the error text will be in the ‘error’ output variable.
  • More information about using VBA can be found here.
  • Various usability and stability enhancements.

New in XL-Connector 3.2.4.9 (Oct 18, 2018)

  • New Query Rows function is now available.
  • This function will query Salesforce for each row of data filling in blank cells with values from Salesforce. You’ll need to map your columns before you can run this function:
  • It will use the values that are filled in to create a query to pull values that are empty. Clear the corresponding mapping to not use values from a specific column.
  • This functionality can also be used in a Flow Step to let your users query rows by simply clicking on the Run Flow button. The admin needs to first set up the Flow Step mappings correctly.
  • Refresh All function will now produce a user-friendly progress dialog box showing the Refresh All operation progress:
  • It is now possible to set up your workbook to refresh all sheets automatically when it is opened. If the user is not automatically logged in – the refresh will happen after the first login

New in XL-Connector 3.2.4.4 (Oct 3, 2018)

  • Autofit columns will now be applied automatically as you pull data from a Salesforce report or SOQL query. This will automatically adjust your columns width based on their contents. You can turn this off under Settings -> General
  • Ignore blank values setting is now available for each worksheet separately from the Edit Flow dialog box
  • You can also set up the default setting for this from Settings -> DML
  • Your last selection of the Create Data Table option when running a report or SOQL query is now remembered and used on the subsequent data pulls.
  • You can now export all your saved queries to a file by clicking on the Export All button in the Save Query dialog box

New in XL-Connector 3.2.3.6 (Jul 27, 2018)

  • You can now change your data starting cell directly from the Update, Insert, and Upsert dialog box:

New in XL-Connector 3.2.2.9 (Jul 18, 2018)

  • Another XL-Connector release with more exiting features! We’ve streamlined the data push operations reducing the number of clicks you need to make to get the job done. Now, if you click on the Update, Insert, or Upsert button in the … Continue Reading

New in XL-Connector 3.2.2.5 (Jul 6, 2018)

  • You can now transpose rows to columns when pulling or refreshing reports and SOQL queries. To enable this, check the Transpose columns to rows checkbox under Options
  • You can now define a cell in your workbook that will be updated with the last refresh date for reports and SOQL queries. You can use a cell address on the same worksheet (e.g. A10), a cell address on a different worksheet (e.g. Sheet1!A10), or a named range here

New in XL-Connector 3.2.2.0 (May 23, 2018)

  • You can now force all values to be treated as text by Excel when running a report. This will not let Excel automatically convert values to numbers or dates.

New in XL-Connector 3.2.1.5 (May 5, 2018)

  • File Upload tool can now upload files to user-defined libraries. Numerous bug fixes, performance and UI enhancements.

New in XL-Connector 3.2.0.1 (Mar 28, 2018)

  • You can now mass upload Files to Salesforce effortlessly using the new Upload Files feature. Please, check out our documentation for more details.

New in XL-Connector 3.1.9.5 (Feb 10, 2018)

  • We’ve simplified the way our users work changed values in XL-Connector Team Player and Enterprise Admin.
  • Now when at least one Flow Step in a worksheet is set up to upload Changed rows – the Track Changes mode will be activated automatically on worksheet activation.

New in XL-Connector 3.1.8.2 (Dec 9, 2017)

  • Starting from version 3.1.8.2, XL-Connector gives you the ability to download and upload custom metadata records.

New in XL-Connector 3.1.8.1 (Dec 6, 2017)

  • Starting from version 3.1.8.0 XL-Connector supports exporting Flows and Flow Steps to Salesforce and importing them back into your Excel document. Read more…

New in XL-Connector 2.0.1.4 (May 3, 2016)

  • Excessive usage of API calls when using Bulk API has been fixed.

New in XL-Connector 2.0.1.3 (May 3, 2016)

  • Refresh now deletes all data if the report or SOQL query returns no results.

New in XL-Connector 2.0.1.2 (Mar 28, 2016)

  • If you pulled data from Salesforce using a SOQL query, double-clicking on a column containing a reference field will automatically bring up the Id lookup dialog.

New in XL-Connector 2.0.1.1 (Mar 25, 2016)

  • Dynamic ranges and Grab Values from Spreadsheet tool now correctly observe filtering and hidden rows.

New in XL-Connector 2.0.0.9 (Mar 9, 2016)

  • It is now possible to refresh the schema information from Salesforce.com in one click. The Refresh Schema operation effectively logs out of Salesforce and then logs back in.

New in XL-Connector 2.0.0.8 (Mar 9, 2016)

  • Query box in the Get Data dialog is now resized correctly.
  • Use Names to Identify Records function will now correctly work with record names containing apostrophes, quotes, and back slashes.

New in XL-Connector 2.0.0.7 (Mar 9, 2016)

  • GetMetadata VBA call was changed to support multiple types:
  • string[] GetMetadata(object [] types, string folderName, out string error, object[] additionalTypes)

New in XL-Connector 2.0.0.6 (Feb 25, 2016)

  • TLS 1.1 and 1.2 protocols are enabled by default.

New in XL-Connector 2.0.0.5 (Feb 19, 2016)

  • Specifying of dynamic ranges in SOQL is now available. For example it is possilbe use the following query:
  • SELECT Id, Name FROM Opportunity WHERE Id IN [Sheet1!C1:C20]
  • Passwords are now encrypted when stored in the Settings file.
  • Aliases in the Log In dialog are now sorted alphabetically.
  • Error on opening the Log In dialog after the Salesforce session has expired has been fixed.
  • The installation files are now signed with a SHA-256 certificate to prevent certificate errors when downloading using IE from Windows 10.

New in XL-Connector 2.0.0.4 (Feb 12, 2016)

  • Merge Accounts, Contacts, and Leads in bulk.

New in XL-Connector 2.0.0.2 (Feb 9, 2016)

  • Merge any two Accounts, Contacts, or Leads directly form Excel.

New in XL-Connector 2.0.0.0 (Feb 4, 2016)

  • The query originally pulled for the sheet is displayed when the user clicks Get Data.
  • All read-only fields are automatically unchecked during auto-mapping.

New in XL-Connector 1.9.9.9 (Jan 29, 2016)

  • Get Data dialog now automatically populates the last pulled object and its fields.

New in XL-Connector 1.9.9.4 (Dec 15, 2015)

  • It is now possible to look up record Ids without leaving Excel.
  • Will come in handy when updating reference fields.

New in XL-Connector 1.9.9.3 (Dec 3, 2015)

  • Selection of ActivityType pick list values for ActivityHistory object in the Get Data dialog now works correctly.
  • When picklists were enforced, and a picklist had a lot of long values, sometimes such file failed on opening in Excel which resulted in clearing of all validations from the worksheet. This is fixed now.

New in XL-Connector 1.9.9.2 (Dec 1, 2015)

  • In Enabler4Excel Team Player, Excel now allows multiple Undo operations if 'Highlight changed cells' setting is not set.

New in XL-Connector 1.9.9.0 (Nov 19, 2015)

  • Using of the system authenticated proxy is now supported in the Web and SSO Login dialog and in the auto-update utility.

New in XL-Connector 1.9.8.9 (Nov 19, 2015)

  • New "Auto-map columns" button in the Map Columns dialog will let you re-run the automatic mapping procedure. This will help if you loaded wrong mappings or rearranged columns after pulling them using SOQL.

New in XL-Connector 1.9.8.8 (Nov 14, 2015)

  • A bug with always pulling empty Phone fields using SOQL has been fixed.
  • RunReports VBA call will now return a relevant error if the call is made without logging in first.

New in XL-Connector 1.9.8.7 (Nov 12, 2015)

  • Enabler4Excel now works over Winter '16 API (version 35)
  • Stability enhancements

New in XL-Connector 1.9.8.4 (Nov 2, 2015)

  • $User, $Profile, and $UserRole merge tags are now supported in the SOQL query editor to access the currently logged in user information. These tags can be used to access all fields of the User, Profile, and UserRole objects. E.g. "SELECT Id, Name FROM Opportunity WHERE Owner.Name = $User.Name"
  • You can now use "as" keyword in SOQL queries to specify column names for the fields that are pulled from Salesforce.com, for example: "SELECT Id as My Record Id, Name as My Record Name FROM Opportunity"
  • If there's an Id or Name column in your data, you can now open the corresponding records in Salesforce.com. Up to 10 records at once. Select the rows(s) you want to open and click Tools -> Open in Salesforce.
  • A dialog box for multiselect picklists is now only shown if you enter Edit mode for the corresponding cell.

New in XL-Connector 1.9.7.6 (Sep 25, 2015)

  • A search box is now available in the Get Data dialog to filter down the list of fields in the query builder. This will make your life a lot easier if you often deal with objects that have a lot of fields.
  • You can now have aliases for your the stored Salesforce credentials. The Log In dialog also supports selecting a credential by it's alias.
  • The dependent pick list behavior is now preserved even if you close and then reopen a spreadsheet containing columns tied to a controlling and dependent picklists.

New in XL-Connector 1.9.7.5 (Sep 25, 2015)

  • A problem with Excel randomly crashing when multiple workbooks are open at the same time has been fixed. Please upgrade if you have experienced any unexpected Excel crashes. If you haven't - upgrade too.

New in XL-Connector 1.9.6.7 (Aug 11, 2015)

  • You can now use record names instead of Salesforce Ids in the Id field or any relational (lookup or master-detail) field. Make sure you check the "Use Names to Identify Records" option in the settings. Please be careful with duplicates in the system, if records with duplicate names exist - reference to only one of the duplicates will be used.
  • It is now possible to update multiple objects from the same row in Excel. This is possible due to a new ability to map Excel columns to fields belonging to different objects. Use the Object drop-down list to select the objects and populate it's fields in the Available Fields table of the Mappings dialog. Only available for the Update operation.
  • The header row is now automatically frozen when pulling data using SOQL or Get Reports dialog. Can be disabled in Settings.
  • Minor enhancements and bug fixes.

New in XL-Connector 1.9.6.5 (Aug 11, 2015)

  • 'Enforce Picklist Values' checkbox in the Get Data dialog now will also set up dependent and controlling pick lists in your spreadsheet so that values available for selection in the dependent column are limited by what's selected in the same row of the controlling pick list columns. ATTENTION: THIS FEATURE IS NOT YET COMPATIBLE WITH COUNTRY AND STATE PICKLISTS, IF YOU HAVE THEM ENABLED IN YOUR ORG.
  • Enterprise Admin edition of Enabler4Excel now has an additional tool called Validate Picklists that will go through the selected Controlling and Dependent picklist columns in your spreadsheet, and mark cells with invalid values in red color.

New in XL-Connector 1.9.6.2 (Jul 14, 2015)

  • Merge fields support in the Get Data dialog query editor. You can now dynamically replace strings like [B2] or [Sheet1!C3] with the contents of the B2 cell of the active sheet or C3 cell of Sheet1 respectively. Simply wrap the cell address in square brackets when editing the query to do that.

New in XL-Connector 1.9.6.1 (Jun 30, 2015)

  • Easier cancelling out of a long running DML operation (Update/Insert/Upsert).
  • Stability enhancements.

New in XL-Connector 1.9.6.0 (Jun 30, 2015)

  • To comply with the announced Salesforce.com disabling TLS 1.0 security protocol at the beginning of next year, we are rolling out a new version of Enabler4Excel built against .NET Framework version 4.5 that supports TLS 1.1 and TLS 1.2 protocols. If you update your version of Enabler4Excel using the Update button in the Settings dialog, your app may stop working in case your system doesn't have .NET Framework 4.5 installed. If this happens, you can either uninstall Enabler4Excel, download and install a new copy of it from this web site, or simply install .NET Framework 4.5 form here.

New in XL-Connector 1.9.5.8 (Jun 13, 2015)

  • UI and usability improvements.
  • Better error handling.
  • Bug fixes.

New in XL-Connector 1.9.5.1 (Jun 13, 2015)

  • We have added the ability to access Salesforce.com reports from Enabler4Excel Team Player.
  • We have moved admin-specific functions (Analyze Layouts, Field Utilization, and Convert Layouts to VF Pages) from Enabler4Excel Personal to Enabler4Excel Enterprise Admin. If you were using these features and don't want to install Enabler4Excel Enterprise Admin, please do not upgrade your copy of the tool beyond version 1.9.5.0. You can always download version 1.9.5.0 here. Also all users of Enabler4Excel Personal Edition who purchased a license before June 30th, 2015 are eligible for free upgrade to Enabler4Excel Enterprise Admin.
  • We have fixed several minor problems throughout all editions.

New in XL-Connector 1.9.4.9 (May 12, 2015)

  • "Use" boxes for unmapped columns are now correctly saved by the Mapping dialog box.

New in XL-Connector 1.9.4.8 (May 11, 2015)

  • You can now cancel your Refresh and Refresh All operations.
  • Current Refresh status is available as a tooltip over the Refresh button in the ribbon.
  • Enforce Picklist Values option now works even if there's not a single value in the incoming data.
  • Enforce Picklist Values option optimized for better performance.

New in XL-Connector 1.9.4.7 (May 2, 2015)

  • Holding down Shift key will allow to select spans of fields in Get Data dialog box.

New in XL-Connector 1.9.4.6 (Apr 23, 2015)

  • The actual formula for calculated fields is shown.
  • The resulting sheet shows if each field is updateable and insertable.
  • If a field is a reference, the name of the object(s) it refers to is displayed.
  • Description column was renamed to Help Text to reflect the actual data that is displayed there.

New in XL-Connector 1.9.4.3 (Apr 23, 2015)

  • A problem with Upserting records has been fixed. Previously Upsert would only work if the column name in the spreadsheet is the same as the field API name.
  • Get data dialog now correctly auto-builds query if there is an IN or NOT IN condition on a text field in the WHERE clause.
  • Ctrl+A not only selects/unselects all fields in the Get Data dialog, but also correctly rebuilds the query if 'Auto-refresh query' is on.

New in XL-Connector 1.9.4.2 (Apr 16, 2015)

  • You can now use Ctrl+A keys combination to select/deselect all fields in the Get Data dialog.

New in XL-Connector 1.9.4.1 (Apr 16, 2015)

  • When selecting multiple fields in the Get Data dialog - there is no need to hold down the Control key any more.

New in XL-Connector 1.9.4.0 (Apr 8, 2015)

  • 'Ignore blank values' option is now available in the Settings dialog. If checked - values in Salesforce will not be nulled in case of a blank value in Excel.

New in XL-Connector 1.9.3.9 (Apr 1, 2015)

  • In the Upsert dialog, you can now select the External Id field that will be mapped to your External Id column. This will let you choose only from the list of Ext. Id fields and facilitate in finding the right field to map the Ext. Id column to.

New in XL-Connector 1.9.3.8 (Mar 31, 2015)

  • Fields are now sorted alphabetically in the Get Data dialog.

New in XL-Connector 1.9.3.7 (Mar 31, 2015)

  • You can now choose from the available picklist values for all pick lists directly in the Excel spreadsheet. This is only available if you use the Get Data dialog to pull data, and if the 'Enforce pick list values' box is checked.
  • GetServerURL() VBA call has been added to the VBA interface and will return the URL of the server you're currently logged in to.

New in XL-Connector 1.9.3.6 (Mar 31, 2015)

  • Field Utilization tool now works correctly.

New in XL-Connector 1.9.3.5 (Mar 24, 2015)

  • When putting data into an existing worksheet, the worksheet retains it's original name.

New in XL-Connector 1.9.3.4 (Mar 24, 2015)

  • If you were experiencing problems when updating records with empty values, please upgrade to this version, nulling of fields now works correctly for Update and Upsert operations.

New in XL-Connector 1.9.3.3 (Mar 7, 2015)

  • A newly introduced problem with being unable to update values of Date and DateTime types has been fixed.

New in XL-Connector 1.9.3.2 (Mar 6, 2015)

  • It is now possible to specify Contact and Account Ids for the Convert Leads operation.

New in XL-Connector 1.9.3.1 (Mar 6, 2015)

  • Convert Leads dialog now allows to have a column with convert statuses to be able to specify custom convert statuses.
  • When importing/exporting login information, the data is now html-encoded/decoded

New in XL-Connector 1.9.3.0 (Mar 4, 2015)

  • Mass Update Leads is now available along with the rest of the mass DML operations
  • Download data into any spot on your spreadsheet, not necessary starting from column 1 row 1
  • Each tab in your spreadsheet now remembers the object name, mappings, and all other selections after you set them up once. And these settings travel with your spreadsheet.
  • It is now possible to import and export login information to/from an xml file (compatible with the Force.com LOGINS Chrome Add-on)
  • Sandbox Loader tool has been moved out of the tool to be enhanced and will be available as a stand-alone tool soon.

New in XL-Connector 1.9.2.7 (Feb 18, 2015)

  • The tool now supports API version 33.0.
  • It is now possible to save mappings to an sdl file from the Mapping dialog.

New in XL-Connector 1.9.2.6 (Jan 30, 2015)

  • You can now keep an audit log of your operations in a separate spreadsheet. To enable oprations logging to a spreadsheet check the corresponding box in the Logging tab of the tool Settings.

New in XL-Connector 1.9.2.5 (Jan 3, 2015)

  • The bug when date values where sometimes pulled incorrectly over SOQL (-1 day) has been fixed.

New in XL-Connector 1.9.2.4 (Dec 9, 2014)

  • This version contains a fix to the problem when pulling reports in the recently released version. If you downloaded or upgraded Enabler for Excel during the last two weeks, please upgrade to this version, your reports will be fixed. We apologize for the inconvenience.

New in XL-Connector 1.9.2.3 (Dec 9, 2014)

  • Sandbox Loader tool is now available for quick and easy loading of data to Developer orgs. The feature is still in Beta, please send all your comments and suggestions to [email protected]
  • Log in names management page has been added to the Settings dialog

New in XL-Connector 1.9.2.2 (Dec 9, 2014)

  • The remaining amount of days for both trial and commercial licenses is now displayed in the About box.
  • A bug where in DateTime values time was shown incorrectly (e.g. 02:00 instead of 14:00) for european orgs when running reports has been fixed.
  • Other stability enhancements.

New in XL-Connector 1.9.2.0 (Dec 9, 2014)

  • It is now possible to specify batch sizes for Bulk API operations in the tool's Settings.
  • Problem with Bulk operations of more than 10,000 rows has been fixed.

New in XL-Connector 1.9.1.9 (Dec 9, 2014)

  • You can now set up your time zone offset in the Settings dialog. By default the value is set to your current GMT offset.

New in XL-Connector 1.9.1.8 (Dec 9, 2014)

  • Site-wide licensing is now supported. Receive your single site license number and use it accross your organization. We'll only bill you for the copies you use
  • Refresh information is now saved inside the spreadsheet so that it's possible to refresh data even if the spreadsheet is opened on a different computer than the data was pulled at.
  • When pulling reports, footers will not appear in the spreadsheet
  • Report refreshing has been enhanced, no messages suggesting to clear the spreadsheet anymore, only the data part of the report is refreshed, cells outside of the data remain intact
  • New Setting in the Settings Dialog: Clear Worksheet Before Refresh
  • Minor bug fixes

New in XL-Connector 1.9.1.7 (Dec 9, 2014)

  • On some systems the active workbook was not initialized when creating a new worksheet due to timing issues resulting in loss of functionality. This is fixed now.
  • The Auto-refresh query box is on by default now to avoid confusion that led people to believe query builder was not working.

New in XL-Connector 1.9.1.6 (Dec 9, 2014)

  • Problems some users were having with cells selection have been fixed

New in XL-Connector 1.9.1.5 (Dec 9, 2014)

  • Bulk DML operations are now supported
  • Delete/Insert/Update/Upsert All actually selects the range that will be dealt with
  • Delete dialog optimized for better performance with large data sets

New in XL-Connector 1.9.1.4 (Dec 9, 2014)

  • The number of errors occured during a DML operation will now be reported

New in XL-Connector 1.9.0.6 (Aug 13, 2014)

  • In rare cases Excel could crash if Refresh was clicked immediately after running a report

New in XL-Connector 1.9.0.5 (Aug 12, 2014)

  • Upsert by parent foreign ID is now working correctly
  • Faster processing of query results containing a lot of empty datetime and number values.

New in XL-Connector 1.9.0.4 (Aug 6, 2014)

  • Queries like "Select Id, (Select Id,Name From Opportunities) From Account" are now working correctly.

New in XL-Connector 1.9.0.3 (Aug 6, 2014)

  • API version 31.0 is now supported
  • We have made a decision to make the tool commercial starting from this version. All customers that downloaded the tool before July 29th 2014 will be grand-fathered in and will be able to use the tool for free for 6 months. DO NOT DOWNLOAD AND INSTALL ANY VERSION GREATER THAN 1.9.0.2 IF YOU WISH TO ENJOY THE FREE VERSION OF ENABLER FOR EXCEL

New in XL-Connector 1.9.0.2 (Jun 24, 2014)

  • New VBA function SetReadOnly(bool readOnly) makes it possible for admins to disable Delete/Insert/Update/Upsert operations before rolling out the tool to users.

New in XL-Connector 1.9.0.1 (Jun 11, 2014)

  • Get Reports dialog shows new report info like Report Owner and Last Run Date
  • Get Reports dialog allows to pull reports from Salesforce.com in "Printable View", essentially in the same way as if you'd click the Printable View button after running a report in SFDC
  • Field utilization tool shows the number of non-empty fields next to the percentage

New in XL-Connector 1.9.0.0 (Jun 9, 2014)

  • BREAKING CHANGE! The login names and passwords are now associated separately with every server name, i.e. you will have a separate set of logins in the drop down when you select each server. You will need to re-enter all your saved credentials.
  • BREAKING CHANGE! The Save Column Selections functionality has been reworked. Unfortunately you will lose all your saved selections. We appologize for the inconvenience, but there was no other way to fix problems in that module.
  • Login dialog box is now resizable and allows to see complete login names, no matter how long they are.

New in XL-Connector 1.8.9.9 (Jun 5, 2014)

  • It is now possible to bulk delete reports from the Reports dialog of the tool. You need Modify All Data permission to do that though.
  • The Reports dialog now shows folder names where reports are located.

New in XL-Connector 1.8.9.8 (May 30, 2014)

  • You can now clear the Usernames list by selecting Clear All from the drop-down
  • You can now specify the path were you want the report to be put in the RunReport VBA call
  • Other minor fixes

New in XL-Connector 1.8.9.7 (May 27, 2014)

  • Select/Deselect All option is now available in the Mapping dialog
  • Cancel button behavior is synchronized across all dialogs
  • Other minor fixes

New in XL-Connector 1.8.9.6 (May 15, 2014)

  • Automatic log in to Salesforce.com on Excel start is now available

New in XL-Connector 1.8.9.5 (May 14, 2014)

  • It's now possible to specify external Ids on foreign key relationships during upsert operation
  • Ability to put a report into existing worksheet

New in XL-Connector 1.8.9.4 (May 12, 2014)

  • UI and usability enhancements

New in XL-Connector 1.8.9.3 (May 9, 2014)

  • Update command is available from VBA. Syntax:
  • string Update([bool all])
  • Updates the active worksheet if no parameters are specified, or all worksheets if you pass True to the function
  • Returns null if completed successfully, or errors as a string in case of a failure.

New in XL-Connector 1.8.9.2 (May 6, 2014)

  • All ribbon buttons are now automatically disabled when you enter Edit mode.
  • This is to bring the usability in line with other Excel ribbons.

New in XL-Connector 1.8.9.1 (May 6, 2014)

  • SSO login is now correctly supported via Web Login

New in XL-Connector 1.8.9.0 (May 6, 2014)

  • Cosmetic enhancements in some dialg boxes
  • Enhancements in handling of queries with multiple layers of relationship fields
  • Switching between label and API name does not change the selected object in Get Data dialog any more

New in XL-Connector 1.8.8.9 (May 6, 2014)

  • Salesforce.com Professional and Group Editions are now supported!
  • European-formatted dates are now coming through correctly when pulling reports.

New in XL-Connector 1.8.8.8 (May 6, 2014)

  • Alpha version of VBA access to the tool is available

New in XL-Connector 1.8.8.7 (Mar 29, 2014)

  • Refresh All functionality is now available
  • Aggregate queries are now supported

New in XL-Connector 1.8.8.6 (Mar 29, 2014)

  • The problem with Excel locking if you perform a query and then select the whole row has been fixed
  • Inability to insert/update/upsert values containing XML markup has been fixed
  • Incorrect pulling of reports when values contained CSV escape characters has been fixed

New in XL-Connector 1.8.8.5 (Mar 29, 2014)

  • Updating of Salesforce.com data in a spreadsheet can now be initiated directly from the Excel ribbon.

New in XL-Connector 1.8.8.4 (Mar 10, 2014)

  • It is now possible to update an existing spreadsheet with new data (Get Data dialog)
  • Get Data dialog returns values of their specific types (does not populate all cells as strings as before)

New in XL-Connector 1.8.8.3 (Mar 10, 2014)

  • Relationship fields specified in a query (e.g. Opportunity__r.Account.Name, etc.) are now processed correctly and put into separate columns

New in XL-Connector 1.8.8.2 (Mar 10, 2014)

  • SOQL syntax highlighting
  • Query formatting with tabs and new lines
  • Access to reports is now supported if you use Web Login

New in XL-Connector 1.8.8.0 (Mar 10, 2014)

  • It is now possible to choose between automatic and manual query update
  • It is possible to append query from the Builder to the existing one thus enabling the user to build complex nested queries
  • It is now possible to grab a list of values (e.g. IDs) directly from the spreadsheet you're working with

New in XL-Connector 1.8.7.9 (Mar 10, 2014)

  • Identical reports and queries pulled from Salesforce.com do not overwrite the previous tab, but are put to a new tab instead
  • Bigger contols in the Get Data dialog to allow for longer field and object names
  • Several defects have been fixed

New in XL-Connector 1.8.7.8 (Mar 10, 2014)

  • 2000-record limit on pulling reports has been removed

New in XL-Connector 1.8.7.7 (Mar 10, 2014)

  • Logging out of a session initiated by Web Login now works correctly
  • A problem with retrieving fields API names of which contain a 'from' word has been fixed

New in XL-Connector 1.8.7.6 (Mar 10, 2014)

  • You can now hide/show read-only fields in the Mapping dialog
  • Insert, Update, and Upsert dialogs now have a box to enter the Assignment Rule Id. This is only used with Leads, Contacts, and Accounts and lets you specify a custom assignment rule for mass inserts/updates/upserts

New in XL-Connector 1.8.7.5 (Jan 17, 2014)

  • Read-only fields are now marked red and italic in the Mapping dialog
  • Stability enhancements
  • Installation now correctly installs pre-requisites on some x64 systems
  • Cosmetics

New in XL-Connector 1.8.7.4 (Jan 9, 2014)

  • Saving and loading of queries in the Get Data dialog is now supported.
  • You can now pull deleted and archived records using Get Data dialog. Just select the Queary All option before running the query

New in XL-Connector 1.8.7.3 (Jan 8, 2014)

  • You can now alternatively log in using Salesforce.com Web Interface

New in XL-Connector 1.8.7.2 (Jan 8, 2014)

  • You can now pull reports directly from Salesforce.com

New in XL-Connector 1.8.7.1 (Jan 8, 2014)

  • Field Utilization procedure has been optimized
  • VisualForce from Layout function can now generate both read-only and edit pages

New in XL-Connector 1.8.7.0 (Dec 16, 2013)

  • You can now save the current selection of the Use checkboxes in the Mapping dialog, as well as load them back in
  • The last run query is now remembered separately for each worksheet. So if you want to refresh data in one of the worksheets, just click Get Data, the query will be pre-populated and you can run it immediately by clicking Execute
  • Insert, Upsert, and Update operations are now returning not only operation result, but also the ID of the inserted/upserted/updated record
  • Join dialog box allows to join two tables on the specified columns
  • A function for converting of 15-character Salesforce.com IDs to 18-character ones is now available
  • The currently logged-in user name is now displayed in the ribbon

New in XL-Connector 1.8.6.3 (Nov 6, 2013)

  • "Convert Layout to VisualForce Page"; button added

New in XL-Connector 1.8.6.2 (Oct 7, 2013)

  • Proxy can now be set in the add-on Settings.
  • Fixed Metadata API for pulling Layouts directly from Salesforce.

New in XL-Connector 1.8.6.0 (Oct 2, 2013)

  • UPSERT button introduced to support the SFDC 'upsert' operation.
  • Tokens and passwords (optional) are now associated with login names and automatically filled out when login name is selected.
  • Analyze Layouts dialog now supports pulling layouts directly from Salesforce.

New in XL-Connector 1.8.5.7 (Sep 27, 2013)

  • Enhanced visual query editor in the GET dialog.
  • Ability to select multiple picklist values when building an IN or NOT IN condition of a WHERE filter in the GET dialog.
  • Correct building of date values in the WHERE filter of the GET dialog.

New in XL-Connector 1.8.5.6 (Sep 17, 2013)

  • Multiple files can be selected in the Analyze Layouts dialog.
  • Errors are now populated against the correct rows in case of validation rules
  • prohibit an insert/update/delete

New in XL-Connector 1.8.5.5 (Sep 5, 2013)

  • Settings dialog introduced to control the log location and batch sizes for Insert,
  • Update, and Delete.

New in XL-Connector 1.8.5.4 (Sep 3, 2013)

  • The installation is now signed with a valid code signing certificate.

New in XL-Connector 1.8.5.3 (Aug 29, 2013)

  • Ability to ignore columns on update and insert.

New in XL-Connector 1.8.5.1 (Aug 21, 2013)

  • UI and usability enhancements

New in XL-Connector 1.8.5.0 (Aug 19, 2013)

  • Huge performance improvements across application
  • User interface is not locked in case of lengthy network operations.

New in XL-Connector 1.8.0.0 (Jul 24, 2013)

  • Get, Insert, and Update of date/time values correctly uses the local UTC offset
  • Automatic mapping of columns has been enhanced with caching of already mapped ones

New in XL-Connector 1.7.2.5 (Jun 18, 2013)

  • All prerequisites are now correctly installed by the installer.

New in XL-Connector 1.7.2.0 (Jun 17, 2013)

  • Support button introduced.
  • Ability to select the id column when deleting.
  • Hidden rows are now not deleted.

New in XL-Connector 1.7.1.0 (Jun 13, 2013)

  • Delete/Insert/Update Selected or All choice is now available.
  • The results of each operation are now populated for all rows.
  • Other stability and usability enhancements.

New in XL-Connector 1.7.0.3 (Jun 11, 2013)

  • Switching between label and name displays does not reset the current selection.
  • Cosmetic changes.

New in XL-Connector 1.7.0.2 (May 27, 2013)

  • Stability and usability of the Get Data dialog enhanced.

New in XL-Connector 1.7.0.0 (May 1, 2013)

  • Inserting/Updating of time and datetime values is now fixed and automatically converts from any time format to the one Salesforce understands.
  • Mapping of columns is now provided for Insert and Update operations so that it is possible to use any column names in the spreadsheet, not just correct API field names as before.
  • All columns are automatically mapped so in most cases the user doesn't have to care about the mappings.
  • Updating of empty values is now possible.
  • When inserting/updating datetime, the current timezone of the PC is used automatically.

New in XL-Connector 1.6.3.5 (Apr 29, 2013)

  • Deleted records can now be automatically removed from the spreadsheet.
  • Version is displayed correctly.
  • Stability improvements.

New in XL-Connector 1.6.3.2 (Apr 23, 2013)

  • Critical 1.6.3.1 login issue fixed.

New in XL-Connector 1.6.3.1 (Apr 22, 2013)

  • The problem when Excel disabled the add-on on start has been fixed.