Results 1 to 2 of 2

Thread: Importing Contacts from CSV not showing all columns

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

    Default Importing Contacts from CSV not showing all columns

    Hi All,

    I have a fresh sugar install and I am trying to import contacts from CSV. I broke up my file into 50 record CSV files. The first 4 or 5 imported great. I used a saved import mapping and all was good. When I hit about the 5th file, sugar started only seeing about half of my columns in the CSV whether I used a saved import or not. Those initial 5 files still work fine when I get to the mapping screen. I have tried comparing working CSV's and not working CSV's in notepad to try and find a difference in anything, but the columns, delimiting, content, everything is the same. I hope someone here might be able to provide some guidance on where to look. With some files working, I'm not 100% convinced that the problem is sugar, however, I don't know where else to ask so this seemed like the best place. Thanks in advance for the help.

  2. #2
    Angel's Avatar
    Angel is offline Sugar Community Member
    Join Date
    Jul 2005
    Location
    Los Angeles
    Posts
    4,813

    Default Re: Importing Contacts from CSV not showing all columns

    This type of behavior usually indicates that one or more of the values in one or more records contains a comma.

    Can you post records 5 & 6?
    Regards,

    Angel Magaña
    Co-Author: Implementing SugarCRM 5.x (Packt Publishing -- Sept. 2010)
    Blog: http://cheleguanaco.blogspot.com.
    Twitter: @cheleguanaco.

    ________
    | Projects: |_____________________________________
    |
    | CandyWrapper (.NET Wrapper for SugarCRM SOAP API). Source now available on GitHub!
    | GoldMine to SugarCRM Express Conversion. Latest: 1.0.1.7 (Nov. 3, 2009)
    | CRM SkyDialer (Skype Integration). Latest: 1.0.2 (Feb. 17, 2010)
    | Round Robin Leads Assignment
    | Phone Number Formatter
    | CaseTwit (Twitter Integration)
    ______________________________________________

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 2007-04-30, 07:09 PM
  2. Replies: 3
    Last Post: 2006-04-05, 12:12 PM
  3. contacts Table and portal_*columns
    By StephaneZ in forum Developer Help
    Replies: 0
    Last Post: 2005-09-15, 10:38 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
  •