• eOne SmartConnect Help
    • Privacy Statement
    • Copyright Notice
    • Common Terms
  • Introduction
    • Tabs and Toolbars
  • Installation/Upgrade
    • Installation
      • System Requirements
      • Pre-requisites
      • Compatibility
      • SmartConnect Installation
      • GP Add-In Installation
      • Excel Add-In Installation
      • Using Multiple Databases
    • Upgrade
      • Upgrading SmartConnect
      • Upgrading GP Add-In
    • Registration
    • Web Client Setup
      • Enabling SC Web Client
      • Setting up User Access to Web Client
      • Accessing the SC Web Client
      • Using the SC Web Client
        • Home Page
        • Maps Page
        • Run History Page
        • Error Processing Page
        • Notifications
        • User Account
  • Setting up the Connector
    • Setting up the GP Connector
      • GP Resource Cache
      • GP Connector Security
      • GP Service Based Architecture
      • Extender Resource Setup
      • eConnect Nodes
        • Node Groups
        • Node Types
        • Nodes
        • List Options
        • Copy Node
        • Remove Node
    • Setting up the NAV/365 Financials Connector
    • Setting up the CRM Connector
      • CRM Authentication Types
    • Setting up the Salesforce Connector
      • Salesforce User Remote Access
      • Salesforce User Security
      • Salesforce Real-time Data Source Access
      • Salesforce Connector Setup
      • Salesforce Real Time Data Source Service
      • Individual Salesforce Login Details
      • Salesforce External Entity ID's
      • Salesforce Connector Security
      • Additional Information
        • SOQL
        • Change Entities
        • Duplicate Entity Labels
    • Setting up the Web Service Connector
    • Setting up the XERO Connector
      • Xero Organization Setup
  • Maps
    • Map Setup
      • Map Setup Basics
      • Map Key Fields
      • Map Lines
      • Tenants
        • Update Tenants
      • Map Options
      • Map Tasks
      • Map Variables
      • Map Notes
    • Run a Map
      • Map Runs
      • Processing Errors
    • Duplicate a Map
    • Map Activity
    • Map Trace Log
    • Scheduling
      • Daily Schedules
      • Weekly Schedules
      • Monthly Schedules
      • Scheduling to Run Once
      • Schedule Security
      • Managing Scheduled Maps
      • Managing the SmartConnect Windows Service
    • Map Debugging
      • Setting Up Debugging
      • Viewing Debug Logs
      • Log Import / Export
      • Clearing Logs
  • Data Sources
    • Bulk Data Load Data Sources
      • Extender Bulk Data Source
      • Folder Data Source
        • Real Time Folder Data Source
      • InfoPath XSD Data Source
      • Microsoft Dynamics CRM Query Data Source
        • CRM Option Set Labels
      • Microsoft Dynamics GP Query Data Source
      • Microsoft Dynamics GP Service Data Source
      • Microsoft Dynamics NAV/365 Financials Data Source
      • SC Microsoft Excel 2003 Data Source
      • SC Microsoft Excel 2007 Data Source
      • Microsoft Excel 2010 Data Source
      • Microsoft Excel 2013 Data Source
      • Microsoft Excel 2016 Data Source
      • Multi Data Source
      • ODBC Data Source
      • OLEDB Data Source
      • Salesforce Query Data Source
      • SmartList Data Source
      • Text File Data Source
        • Schema Files
      • Web Service Query
        • Web Service Parameters
        • Web Service Data Source Setup
          • Web Service Derived Types
      • Xero Query Data Source
      • XML Data Source
      • XML Query Data Source
    • Changes Only Data Sources
      • Extender Change Data Source
      • Microsoft CRM Change Data Source
        • CRM Managed Change Tracking
      • Microsoft GP Change Data Source
      • MSSQL Table Change Data Source
      • Salesforce Change Data Source
        • Salesforce Change Data Source Objects
    • Real-Time Event Data Sources
      • Extender Real-Time Data Source
      • Microsoft CRM Real-Time Data Source
      • Microsoft GP Real-Time Data Source
        • Microsoft Dynamics GP Web Client Setup
      • MSSQL Table Real-Time Data Source
      • Salesforce.com Real-Time Data Souce
        • Salesforce Real Time Data Source Objects
          • Salesforce eOne_RTDS_Settings
          • Salesforce eOne_RTDS_Master
          • Salesforce Triggers
          • Salesforce eOne_SC_RTDS
    • Change Data Source Maintenance
      • Maintain Change Table Records
  • Destinations
    • Microsoft Dynamics GP Destinations
      • Microsoft Dynamics GP Destination
        • GP Tenants
          • GP Add a Tenant
          • GP Define a Tenant
          • GP Amend a Tenant
      • Microsoft Dynamics GP - File Destination
      • Microsoft Dynamics GP - Message Queue Destination
      • Microsoft Dynamics GP - Service Destination
      • Microsoft Dynamics GP Extender Destination
    • Microsoft Dynamics NAV/365 Financials Destination
      • Microsoft Dynamics NAV/365 Financials Destination
    • Dynamics CRM Destinations
      • Microsoft Dynamics CRM Destination
        • CRM Tenants
          • CRM Define a Tenant
          • CRM Amend a Tenant
        • CRM Entities to Process
        • CRM Advanced Messages
        • CRM Reference Data
        • CRM Define a new CRM server destination
      • Microsoft Dynamics CRM – File Destination
      • Microsoft Dynamics CRM Bulk Destination
    • Salesforce Web Service Destinations
      • SalesForce Destination
        • Checking for Existence
    • Web Service Destinations
      • Web Service Destination
        • Web Service Destination Setup
        • WS Return Types
        • WS Destination Exceptions
        • WS Cyclical References
        • WS Base / Abstract Types
    • Xero Destinations
      • Xero Destination
      • Xero - File Destination
    • Flat File / Folder Destination
      • Xml File Destination
        • Define XML Format
        • XML File Mapping Window
      • Export to File Destination
        • File Mapping Window
    • Microsoft SQL Destination
      • Microsoft SQL Stored Procedure Destination
      • Microsoft SQL Table Destination
        • MSSQL Database Tenants
          • MSSQL Tenant Definition
          • Add MSSQL Tenant
  • Columns
    • Generic Columns
      • Calculated Column
      • Custom Rolling Column
      • DataSource Column
      • Date Column
        • Date Formatting
      • Global Constant Column
      • Global Rolling Column
      • MSSQL Lookup Column
      • Local Constant Column
      • Translation Table Column
    • Microsoft Dynamics GP Columns
      • GP Rollilng Columns
    • Microsoft Dynamics CRM Columns
      • Activity Party Columns
      • List Option Lookup Column
      • Mapped Column Set Column
      • Column Set Column
        • CRM Determining Required Columns
      • Entity Lookup Column
      • Entity Reference Column
      • Label Column
      • Multi Lookup Column
      • Relationship Column
    • Microsoft Dynamics NAV/365 Financials Columns
      • Page Field Lookup
      • Page Key Lookup
    • Salesforce Columns
      • Salesforce Entity Lookup Column
    • Xero Columns
      • Xero Entity Lookup Column
  • Query Builder
    • Query Builder Screen
    • Query Builder Adding Objects
    • Query Builder Selecting Fields
    • Query Builder Adding Criteria
    • Query Builder Joins and Links
    • Query Builder Grouping and Sorting
    • Query Builder Sub Queries
    • Query Builder Unions
    • Query Builder Derived Tables
  • Processing Tasks
    • Task Events
    • Task Types
      • Copy Files Task
      • Delete Files Task
      • Move Files Task
      • Send Email Task
      • Run File Task
      • Run Script Task
      • Run Map Task
      • Run MSSQL Command Task
      • Run MSSQL Validation Task
    • Variables and Scripting
      • Map Variables
      • Script Functions
      • System Global Variables
      • User Global Variables
      • Data Variables
      • Variable Substitution in MSSQL Command Tasks
      • Scripting References
      • Scripting Validation
      • Default Connection Variables
      • Data Sources
  • Services
    • ASP.NET Web Service
      • IIS 8.0
      • IIS 7.0
      • IIS 6.0
    • Windows Service
    • WCF REST Service
      • Configure WCF REST Service
      • Available Processes
        • Get Map Methods
          • Get Map List
          • Get Extender Map List
          • Get SmartList Map List
          • Get Map Columns
        • Map Runs
          • Run Map
          • Run Map Data Table
          • Run Map XML
          • Run Map Info Path
          • XML Output Map Runs
            • XML Output Run Map
            • XML Output Run Map Data Table
            • XML Output Run Map XML
          • Save Process Errors
        • Get Data
        • Validation
          • Validate Connection
          • Validate Session
      • Web Service Logging
        • Security Log
        • Activity Log
        • Request Log
        • Define Logging Settings
      • Enumerated Types
      • Returned Classes
      • Service Users
      • WCF REST Security
        • WCF REST Request Security
        • WCF REST Config Security
        • WCF REST SmartConnect Security
        • WCF REST Security Process Flow
  • Excel Template
    • Config Sheet
    • GP Excel Template
    • CRM Excel Template
  • Security
    • User Setup
    • User Permissions
    • User Impersonation
    • Map Permissions
    • Connector Permissions
    • Administrator Password
    • GP Database Security
    • CRM User Security
      • CRM User Requirements
    • NAV User Security
  • Additional Features
    • System Maintenance
    • Client Configuration Changes
    • Importing and Exporting
      • Exports
      • Imports
      • Decrypt SmartConnect Exports
    • Templates
      • Selecting a Template
      • Email Templates
      • Script Templates
      • MSSQL Command Templates
      • Template Variables
    • Default Connections
      • GP Query Connections
      • MSSQL Connections
      • ODBC Connections
      • OLEDB Connections
    • Translation Tables
    • Integration Groups
    • Event Logs
    • About SmartConnect
    • Running Servers
  • Enhancements
    • 20.18.0.9
    • 20.18.0.23
    • 20.18.0.34
    • 20.18.1.11
    • 20.18.1.14
    • 20.18.1.48
    • 20.18.1.49
    • 20.18.1.56
    • 20.18.1.57