Results 1 to 2 of 2

Thread: Can't find field on import

  1. #1
    GeraldJP60 is offline Junior Member
    Join Date
    Jun 2008
    Posts
    1

    Default Can't find field on import

    I have hired a telemarketing firm to pre-qualify leads for us. They've done a great job and I now have several contacts that I want to import, send information to and track. I made a spreadsheet with all the necessary data and imported it. Everything worked great except that I can't seem to figure out how to import the name of the campaign. When I am in Admin, Leads, Edit Layout, Detail View, the field next to the campaign label is blank. On the Edit View layout, the field next to the label is a button for a pop-up and doesn't have any titles in it so I can't figure out what field to import the campaign name from the spreadsheet in to.

    Any help would be appreciated. I just edited, clicked, selected, saved, and clicked next on several hundred records. Way too much work. G.

  2. #2
    dpatech is offline Sugar Community Member
    Join Date
    Oct 2007
    Location
    NC
    Posts
    287

    Default Re: Can't find field on import

    The problem is because the "Campaign" field on the leads edit view is what is called a "relate" field. Sugar stores the unique identifier of the campaign with the Lead -- not the actual name of the Campaign. The Leads table has a field named "campaign_id" which stores this unique id value.

    Try adding the actual unique ID of the campaign in the spreadsheet and map that field to the "Campaign ID" column.
    - Sugar Team
    dpa Technology LLC
    e-mail: dpaDeveloper@dpatechnology.com
    web: http://www.dpatechnology.com

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. HELP - Act import (field mapping)
    By smelamed in forum Help
    Replies: 32
    Last Post: 2010-12-15, 05:39 PM
  2. Import a checkbox field
    By mtmendez in forum Help
    Replies: 1
    Last Post: 2008-10-17, 08:14 AM
  3. Import issues - email field and custom fields
    By catherinejt in forum Help
    Replies: 1
    Last Post: 2007-10-11, 08:41 AM
  4. Replies: 1
    Last Post: 2006-11-15, 05:57 PM
  5. Primary Key ID field duplicate entry upon import
    By andrewstuart in forum Help
    Replies: 1
    Last Post: 2005-04-04, 07:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •