Using Record Names Instead of Ids in ID and Lookup Fields

In a lot of cases our users face a situation when they don’t have a column of record Ids that must be used to update records or must be specified…

Using Record Names Instead of Ids in ID and Lookup Fields

In a lot of cases our users face a situation when they don’t have a column of record Ids that must be used to update records or must be specified…

In XL-Connector versions 3.4.0.0 through 3.4.1.1

A beta version of Merge operation that supports all objects (standard and custom) has been released. If you run into any issues with this function, please reach out to support@xappex.com…

Dealing with Picklist and Lookup fields

XL-Connector 365 has a built-in tool that will make your life easier when working with fields of type picklist, multiselect picklist, or reference. To use this tool, you’ll need to…

What is the difference between XL-Connector and XL-Connector 365?

Main differences between XL-Connector and XL-Connector 365: XL-Connector 365 works in any Excel (Excel for Windows, Excel for Mac, Excel Online), while XL-Connector only works on Windows XL-Connector 365 can…

Using Upsert to Update or Create Records in Salesforce

Users often ignore a very powerful feature when dealing with data in Salesforce.com: the Upsert operation. This word always gets underlined by my spell checker because it doesn’t exist, upsert…

Updating Existing Records in Salesforce

To update records in Salesforce in bulk, you will first need to pull them to your Excel spreadsheet. You can do it using either SOQL or Reports. You can retrieve your data with…

Creating New Records in Salesforce

To create new records in Salesforce you will only need a spreadsheet with your data. In this example we’ll load Contacts as this is probably the most common scenario in…

Scheduling Automatic Data Snapshots in G-Connector for Salesforce

Being able to have access to historical data is very important, and G-Connector will let you see any of the data points you can pull from Salesforce as they were…

In XL-Connector version 3.3.9.9

Use Constants in XL-Connector Mappings Ever found yourself in a position when you need to upload the same value for all rows of data? Now there’s no need to have…