CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • How do you handle payment intake ? Help us understand
Pages: [1]

Author Topic: How do you handle payment intake ? Help us understand  (Read 839 times)

pdelbar

  • I post occasionally
  • **
  • Posts: 51
  • Karma: 3
  • Web integrator, Joomla freak, CiviFan
    • delius.be
  • CiviCRM version: 4.2.6/7
  • CMS version: Joomla 2.5.7 / 3.0
  • MySQL version: 5.1
  • PHP version: 5.3
How do you handle payment intake ? Help us understand
February 09, 2013, 11:39:48 am
It's common to have some form of outside-of-CiviCRM preprocessing that makes directly importing contributions possible. Often, that requires decoding bank statements of manually inputting data, filtering of certain types of transactions from the input stream, and completing the data until it fits the needs of CiviCRM. Alternative approaches use the API to directly feed Contributions into CiviCRM.

I'm trying to get as much feedback as possible on this specific part of how you use CiviCRM. I think we usually start from payments, and do a sort of interpretation prior to inputting it into CiviCRM, which I would like to do INSIDE Civi and automate or support, so the human user would have an easier job.
You can help out by answering these questions :

1. where does your input to create contributions come from : bank statements, accounting system exports, manual input, other ?
2. do you need to filter the incoming data, and in what way ?
3. do you do some form of interpretation of the data, or do you feed it directly into CiviCRM as Contributions ?
4. how do you feed this data into CiviCRM : manually, by importing it, by code using the API ?
5. how much time do your users spend on getting this data into CiviCRM ? Please include the preprocessing, and express the time as in 'three hours a day'
6. how much of the interpretation is nontrivial, ie. requires a trained user to detect certains patterns in the payments which help define what type of contribution is involved ?

Thanks in advance !

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: How do you handle payment intake ? Help us understand
February 12, 2013, 04:13:46 am
Hi,

Recently we imported a big history of payments. We used the api and a custom script that parsed the csv file.

Among the various problems importing excel:
- if you have a cell that has a fixed list of possible values (eg. "donation" and "membership") assume some will be empty, some will have weird spelling of a possible value, some will be a concatenation, some will be plain weird. Then think about the weirdest value you can think of, and assume you will get weirder.
- if you have a non ascii char, you will have problems at one point or another
- if you have numbers (eg amounts ;) assume that the decimal separator is different than the one you expect. the thousand separator too. For extra fun, assume that what you expect for the thousand will be used for the decimal, or vice versa. Assume it will be different in different rows in the same file.

The whole process was not fun, and even with all the problems, we had a lot of manual fixing at the end.

-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • How do you handle payment intake ? Help us understand

This forum was archived on 2017-11-26.