This documentation relates to CiviCRM version 3.1. It's not maintained anymore.
Current version of documentation.

Import Mac Files

Skip to end of metadata
Go to start of metadata

This page refers to outdated version of CiviCRM. Check current version of documentation.


Documentation Search


CiviCRM 3.1 Documentation

Support and Participation

Developer Resources


CiviCRM book!

Make sure to check out Understanding CiviCRM as well! You can also support this project by ordering a hard copy.

How do I import files created on a Macintosh?

Macintosh created files have line endings that may cause a problem with CiviCRM importing. Symptoms are:

  • CiviCRM Map Fields page does not recognize the rows in your data file, but sees the file as one huge record.
  • CiviCRM may throw a fatal error after upload.

One solution, suggested by Noel Hidalgo, is:

A second solution will allow folks to upload Mac files without the above steps, but requires shell access to your server:

  • Open /opt/local/etc/php.ini in your favorite editor (you may need root privileges to do this).
  • Look for the following setting in the Fopen wrappers section (near line 525):
    auto_detect_line_endings = On
  • If this line is commented out, or set to Off, change the value to On as shown above.
  • Stop and start your local instance of Apache
    $ sudo /opt/local/etc/rc.d/apache2.sh stop
    $ sudo /opt/local/etc/rc.d/apache2.sh start
    

A third option is to use OpenOffice.org which supports utf-8 encoding of CSV files.

Labels
  • None

Creative Commons License
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-Share Alike 3.0 United States Licence.