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 > Import Troubleshooting


Import Troubleshooting

Issue: You have uploaded your spreadsheet but no fields show up below the import screen.

Answer: Your spreadsheet is not saved as the correct file.  You can only upload and import Microsoft Excel 97-2003 workbook (.xls) or a CSV (comma delimited) file.

Issue: You have uploaded your spreadsheet but do not see all of the fields that you need to map to.

Answer #1: You are importing to the wrong module.  If you have selected the wrong module to import to you will not see the fields you are trying to map to.  On the left menu under the import data option you will see all of your normal modules that you can import to.  Click on the module you would like to import to.

Answer #2: If you need to import into two modules at once, you will need to use the advanced import function. 

This feature can make each line item in a spreadsheet two separate records.  For example, if you have a company module related to a contact module then you could import the information at the same time.  There has to be a one-to-one relationship between the modules.  If you import a spreadsheet with both company and contact information to the company module with the advanced option you will also be able to map contact fields.

Issue: You imported an Excel 97-2003 or CSV file the log says completed but you do not see the records in your module/views.

Answer #1: If you did not map any fields on the import screen the file will not be imported.  You will see a Rejected Records link on the import Data Log screen.  Re-upload your spreadsheet and map the respective fields to import the information.

Answer #2: Your spreadsheet is not formatted correctly.  You must have the first row in your spreadsheet contain column headers that have corresponding fields in your eSalesTrack account.  If you are doing an advanced import you cannot have any blank rows.

Answer #3: You may need to adjust your views to see the imported records, they may be owned by another user or unassigned.  You can create a simple view with only the main module table and the key field.  If you select the entire scope by highlighting myself then holding down Shift and clicking the very last option.  This will show every record that you have access to, you should now see the records you imported.

Answer #4: You may need to set up sharing to see all records in your account.  If you import a list of records and assign them to a user that does not report to you or is not sharing records with you then you will not see those records in your views.   You can set up sharing or log in as the user who owns the records to see them.  If you log in as the user and still do not see the records then you may need to adjust the view (see answer #2).

Answer #5: You did an advanced import and did not map the key field.  You must must the key field for the main module in an advanced import.  The key field's system name will appear red in the advanced import screen.  

Answer #6: You

Issue: You imported a spreadsheet with records but the import log says 0 records and no records show up in the module/views.

Answer: You have mapped the wrong type of fields.  You must map text excel columns to text fields, numeric excel columns to numeric fields, and date excel columns to date fields.

Issue: You have mapped the fields and clicked import file and got the eSalesTrack error screen.

Answer: The import screen timed out.  If you spend too much time on the import screen it may time out.  In this case you need to re-upload the spreadsheet.  You can save the import mapping so you do not need to re-map the fields.  This will make the mapping process much faster and timing out will be less likely.

Issue: You imported a file of records the log says completed but you do not see all of the records in your module/views.

Answer #1: Your view is limited to only show certain records.  You can adjust your view to show more records.  There are two sections in the view creator that can limit records.  If some of the records are owned by other users you may need to adjust the scope.  If you have any filters on the view you may want to take the filter off of the view or create a new filter that does not have the filter.


Answer#2: You did an advanced import and eSalesTrack consolidated records.  eSalesTrack is designed to de-duplicate records when you use the advanced import function.  If there are two records with the same exact value in the key field for the main module then eSalesTrack will create one record with two (or more) sub records that are related.  For example if you have two records  in a spread sheet that have the same company name and two different contact names, it will be imported as one company record with two related contact records.

Answer #3: You do not have access to the user who owns some of the records.  If there is a user who owns some of the records imported and they and they do not report to you or are not sharing views with you then you will not be able to view those records in your module/views.  Log in as the user or set up sharing to view the records.

Issue: You imported spreadsheet but the values in a field do not stick when you edit the form.

Answer: If you import a value to a drop down field but the value is not in the drop down list the drop down will revert back to the default value when you edit the record.  You will need to re-upload the spreadsheet with the correct values or do a mass update.

Still having issues? Open a support ticket.

See also