Insert data from a CSV file into CiviCRM

This blog post explains how you could insert data from a CSV file into CiviCRM. We use Pentaho Data Integration to read the CSV file and to call a Form Processor in CiviCRM.

This blog post is an example and when you follow the steps described in this post you can run the same import as me.

Pentaho is a tool to extract and transform data.

The form processor is an extension to create end points for forms in CiviCRM. Those end points can then be called through the api.

Prerequisites:

My first CiviCamp (in Dutch)

Maandag 13 mei was het zover. Mijn eerste CiviCamp. Ik werk inmiddels al een paar jaar met CiviCRM en het leek me goed om wat meer betrokken te zijn bij de community. Ik vond het wel spannend. Ik heb immers geen verstand van ICT, ik heb een sociale opleiding gedaan. Ik ben coördinator van een maatjesproject en gebruik CiviCRM om vast te leggen wie maatje van wie is. We zijn een kleine organisatie met slechts twee parttime medewerkers, maar ik zou mijn werk niet kunnen doen zonder CiviCRM.

Using CiviCRM form processor extension to handle form submissions from an external website

In this blog post I want to show how you could use the new form processor extension to handle form submissions from an external website.

My (imaginary) organisation provides buddies for young people and the form on our website is submitted when somebody is interested in becoming a buddy for a teenager. We ask for the name, address, e-mail, telephone number, birth date and gender.

Prototype of form-processor and action-provider extension

I have finished a working prototype of the form-processor and action-provider extension. See my previous blog post for where the idea came from.

Below I will explain what you can do with this extension. Lets assume we have an external website where students can signup to volunteer in a summer program. When a student has signed up we want this data to be present in CiviCRM and the student added to the group student volunteers.

My experencies at the Sprint: Form Processor and Action Provider extension

Last week we had a Sprint in the wonderful city of Brussels. This blog post is a recap of what I have been up to.

Form Processor

I started the sprint to work on a new extension the form processor.  This idea came to my mind as I had a few clients at which I had to develop a custom api for data coming from their website (in those cases CiviCRM was separated from the website). And my idea was that I wanted to give system administrator and implementers a tool in which they could create those kind of API by themselves. So the form processor was born.