CiviCRM Community Forums (archive)

Kintera!  Sweet mercy...I have worked with this software too much for one lifetime.  But anyway, to your question.

Yes you can import data from Kintera.  You can import anything from Kintera so long as you can EXPORT it from Kintera in a CSV file with column headers that make sense.

Generally speaking, I prefer to import in the following method:

1. Contact data first: name, email, address, phone, etc
2. Contact groups
3. Contributions

I try to import in batches of less than 2500 rows at a time, as the chance of an error, connection problem, or glitch is lessened, IMHO.

Good luck!

Heh There's a Kintera API?

I've pulled the CSV files into a mysql database manually.  If you'd like to know how I did that, let me know (and it's something I'll eventually write up in a case study...)

It's all pretty hackish, but it got the job done.

First, I needed to get all the dates into a format mysql could easily understand, so I created and ran dateFormat.pl (as I like to say, Perl is the duct tape of the Internet) on each:
dateFormat.pl Activities_19000101_to_20110102.csv > activities.csv

Then by looking at the data I decided what fields were INT, DATE or VARCHAR(32) and manually (ugh!) created the KinteraCreateTables.sql file.  (Well, I'm an Emacs guy, so with macros, it wasn't that bad.)  I also lower-cased all the field names (I like it that way) and normalized some of them (changing e.g. addressid to address_id and supporterid to supporter_id).

As VARCHAR(32) would be too small for some text fields so I created and ran another mini-script, columnLength.pl on each .csv file:
columnLength.pl activities.csv
...increasing the '32' where reasonable and changing some big text fields into TEXT.  You'll want to check your column lengths and adjust where necessary.

---

Then (with another Emacs macro) I created KinteraLoadTables.sql and ran those two sql files:
mysql -e "create database kintera"
mysql kintera < KinteraCreateTables.sql
mysql kintera < KinteraLoadTables.sql

The scripts can all be found at https://svn.civicactions.net/repos/civicrm/scripts/loadcsv/

I'll contact you via PM, though probably not today.