eSalesTrack Help Menu
       Getting Started
          New User Guide
          Default Modules
          Contact Manager Template
          Business to Consumer Template
          Business to Business Template
          CRM Lite Template
          CRM Product Manager Template
          CRM Template
          My Information
             Personal Preferences
                Change Password
                Edit Information
          Home Page
             Creating Dashboards
                Creating Widgets
                   Links List
                Publish Dashboard
                Subscribing to Dashboards
             Quick Access
                My Documents
                   Upload Documents
                   Publish Documents
                   Subscribe to Documents
                My Email
                Recycle Bin
          Types of Modules
             Editing Records in eView
             Search eView A-Z
             Creating Reports
             Report Manager
             Edit a Report
             Copy a Report
             Clone a Report
             Publish a Report
             Subscribe to a Report
             Delete a Report
          Creating New Data
             Creating Records
                Primary Records
             Editing Records
             Cloning Records
             Collapse Sections
             What is a view
             Creating a View
             Searching for Records
             Creating Reports from a View
             Creating a View to Show all Records
             Manage Views
                Clone Views
                Copy Views
                Publish Views
                Subscribe to Views
             View Groups
                Editing View Groups
          Manage Data
             Deleting Records
             Recycle Bin
             Activate Records
             Inactive Records
                Activate Records from the Recycle Bin
                Activate Records from the Profile Page
                Inactive Records View
             Permanently Delete Records
                Formatting an Excel Spreadsheet for importing
                Import Troubleshooting
                Import Log
             Creating a Task
             Request Additional Calendars
             Sharing Calendar
             Creating Appointments
             Recurring Appointments
       Email and Marketing
             Creating Document Templates
             Using Document Templates
             Creating Email Tempaltes
             Using Email Templates
             Image Gallery
             Click-Through Links
             Word Plugin
             Add Notification
             Manage Notifications
             Email Settings
                Setting Up Your E-mail in Microsoft Outlook - POP 
                Setting Up Your E-mail in Microsoft Outlook - IMAP 
             Mass Email
                Mass Email Queue
             Sending Emails
             Creating Email Campaigns
             Outlook Plug-in
             Outlook Plug-in Troubleshooting
          Free Daily Training Webinars
          eSalesTrack Advanced Customer Services
          Additional Tabs
          Adding Tasks
          Editing Records
          Finding Records
          Adding Appointments
          Add Module
             Normal Module
             URL Module
             Delete Module
             Stacked View
                Sales Funnel
             View Only Module
          Field Creator
                Creating an eFormula Field
                Formula - Date
                Formula - Text
                Formula - Currency and Numeric
                Formula - Converting
             Creating Fields
                Picture Fields
             Editing Feilds
             Field Creator
          Unassigned Records
          Form Manager
                Creating New Layouts
                Assigning Layouts
                Multi-page Layouts
                   Multi-page Layouts
                   Linear Layout
             Putting Fields on Form
                Adding One to One Fields
                Adding Parent Fields
             Key Fields
             Form Objects
             Additional Tabs
                Activities Tab
                Content Tab
                Email Tab
                Notes Tab
                Team Member Tab
                Deleting Tabs
             Add Mapping
          Portal and Web Forms
             Create a Web Form
             Manage Web Fomrs
             Hidden Fields
             View Relationships
             Mobile Layouts
             Mobile Settings
       My Company Profile
          Company Profile
       Display and Themes
          Change Header
          Change Colors
       Company Information
             Manage Subscriptions
             Delete Subscription
             Creating Roles
             Sharing Records
             Assigning Roles
             Add User
             Reassigning Records
             Manage Users
             Inactivate User


Home > eSalesTrack Help Menu > User > Data > Manage Data > Importing

Manage Data

Import Data

Importing Problems? Check out the import troubleshooting page

The Import Data option allows you to import data from another source into your eSalesTrack account.

Before importing Data, you must have the data saved to your computer in a Microsoft Excel spreadsheet 97-3002 or a CSV file.

To Import Data:

1. If you are on a view for the module you want to import data into, hit the import button on the tool bar .

2. If you click on the import button you can now skip to step 7.

3. If you are not in the specific module to which you want to import data, click on the  icon in the upper right corner of the screen.

4. This opens the Toolbox landing page displaying the various options available to you. Select Manage Data Manage Data by clicking on it.  

5. This takes you to the Manage Data landing page which displays the various options available to you. Select Import Data Import Data by clicking on it. 

6. This takes you to the Import Data landing page which displays the modules for which you have the ability to import data. Select the module that you would like to import data into.

7.  This takes you to the Normal Import Page. On this page you have the option to select the Advanced Import Page. The only difference between the two is seen between steps 13 and 15.

8. For the normal import, click on the button. Then select the file you want to import from your hard drive and click on Open.

9. Next to the  button, the name of your spreadsheet will appear. To import that spreadsheet, click on Upload the selected file.

10. This will take you to the Normal Mapping page. You can choose to import records as unassigned, to a certain user, or select "Record Owner Column" if you have a column in your spreadsheet with record owner names or usernames.

11. You will see the column headers from the spreadsheet you uploaded. The drop downs on the right side will contain all of the fields from the module you have selected to import to. Line the columns up with the corresponding fields.

12. If you are doing an advanced import the two columns will be switched. The module fields will be listed on the left and the fields from the spreadsheet being imported will be in the drop down boxes. The mapping process only differs by the fact that the two columns are switched.

13. Once you finished mapping all the fields, go back to the top of the page, select New, enter the name you want to save the map as, and click Save to save that map. The save and load section allows you to either save the mapping that you do on that page or load a previously saved map if you are importing data similar to a previous import.

14. Once it is saved, click on .

15. You can check the status of your import by clicking on the  icon in the top right corner, then clicking on Manage Data manage data then clicking on Import Data Import Data and then clicking on the Import Log.

See also