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 »
  • Using Import (Moderator: Yashodha Chaku) »
  • How do I import check payments for existing members
Pages: [1]

Author Topic: How do I import check payments for existing members  (Read 658 times)

lewis451

  • I’m new here
  • *
  • Posts: 1
  • Karma: 0
  • CiviCRM version: 2.2.8
  • CMS version: Drupal 6
  • MySQL version: 5
  • PHP version: 5
How do I import check payments for existing members
May 16, 2011, 11:37:39 am
The scenario is: A number of members have paid by check and I need to have a spreadsheet that would include:
- amount paid
- date received
- new expiration date

Then import into CiviContribute/Import Contributions.

Any advice would be appreciated.

CiviTeacher.com

  • I live on this forum
  • *****
  • Posts: 1282
  • Karma: 118
    • CiviTeacher
  • CiviCRM version: 3.4 - 4.5
  • CMS version: Drupal 6&7, Wordpress
  • MySQL version: 5.1 - 5.5
  • PHP version: 5.2 - 5.4
Re: How do I import check payments for existing members
May 20, 2011, 01:30:56 pm
Your CSV file for import must include one of the following three things to "match" the contribution to the correct contact:

1. The email address of the contact
2. The 'internal id' or "contact id" number of the contact
3. The external id from your old database

If you can get a spreadsheet with email addresses of all the people that gave $, that is usually working fine.

PS. Are you really running that old of a version of CiviCRM?   :) ;)  Newer versions like 3.3.6 are excellent and have many new features.  Your server must be able to handle a newer version though, maybe that is your reasoning.

Try CiviTeacher: the online video tutorial CiviCRM learning library.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • How do I import check payments for existing members

This forum was archived on 2017-11-26.