CiviCRM Community Forums (archive)

I tried to import a 19k row, 4 column csv file which was supposed to take ~30 minutes according to the little box.

After 8 or the import went away and it brought me to a 404 at mysite.com/civicrm/import/contact.


I tried cutting the file to 7k lines and had the same experience (is this too big?).  Some of the information was imported, but not all of it.

Any ideas?

Brand new install (imported ~2k rows of 8 columns before) of civicrm 3.0 on drupal 6.15.  Default php settings for hotdrupal

Thanks.

(btw this is my first time using this software, and other than this hiccup it's been truly a pleasure to work with)

i ended up cutting the file size down to ~1k lines and they are importing fine.

#!/bin/bash

# check if an input filename was passed as a command
# line argument:
if [ ! $# == 1 ]; then
  echo "Please specify the name of a file to split!"
  exit
fi

# create a directory to store the output:
mkdir output

# create a temporary file containing the header without
# the content:
head -n 1 $1 > header.csv

# create a temporary file containing the content without
# the header:
tail -n +2 $1 > content.csv

# split the content file into multiple files of 5 lines each:
split -l 1000 content.csv output/$1_

# loop through the new split files, adding the header
# and a '.csv' extension:
for f in output/*; do cat header.csv $f > $f.csv; rm $f; done;

# remove the temporary files:
rm header.csv
rm content.csv