Results 1 to 2 of 2

Thread: Importing CSV from Excel Mac-->formatting issues

  1. #1
    abarrett is offline Junior Member
    Join Date
    Oct 2011
    Posts
    1

    Default Importing CSV from Excel Mac-->formatting issues

    Hey guys,
    I have been trying to import a small number of records in CSV as a test. I have attached image of screen shot to display my problem. These characters are not present in the excel/csv file before import but then once contacts migrate they suddenly appear. If i were to import hundreds of records like I will be doing it would be a huge pain in my a## to manually remove symbols. Is there something I can do going forward to prevent/correct this? I had this same importing problem with Salesforce before I made the switch. Would greatly appreciate your help
    Attached Images Attached Images  

  2. #2
    sts's Avatar
    sts
    sts is offline Sugar Community Member
    Join Date
    Aug 2010
    Posts
    978

    Default Re: Importing CSV from Excel Mac-->formatting issues

    There are "advanced options" in the import process. You could try out different settings for "File Encoding" (or check if you can set file encoding during the export on Mac).
    Stefan Ulrich Sauer
    System Analyst

    Devoteam Danet GmbH
    Gutenbergstraße 10
    D-64331 Weiterstadt
    Germany
    email: Stefan-Ulrich.Sauer@devoteam.com
    http://www.devoteam.de

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: 2008-09-12, 04:09 PM
  2. Importing excel files for vs 4.2.0
    By phoyt in forum Help
    Replies: 0
    Last Post: 2008-05-16, 03:38 PM
  3. Importing Opportunities from excel
    By weffner in forum Help
    Replies: 4
    Last Post: 2007-08-22, 01:02 PM
  4. Importing from MS EXCEL
    By vignesh in forum Help
    Replies: 1
    Last Post: 2005-09-06, 05:27 AM

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
  •