2

We need to daily export all donation data from CommitChange and import the data to civicrm using the data import wizard. So the process is:

Map the appropriate donation fields to civicrm fields and then import donation information from the CSV file. In each case the name of the donation field is "Total Amount."

According to CiviCRM the donation data is successfully imported. However, in every record, the amount of the donation is stored in CiviCRM as "$0". I do not have the coding skills needed to fix the bug or to write a custom script to import the data, so any help is appreciated.

Drupal 7.53 with CiviCRM 4.7.14 also tested on CiviCRM 4.7.13 on a different Drupal site

Improve this question
5
  • 1
    it will be nice to add here the CiviCRM versions you have tested on and indicated if you are using Drupal, Joomla or Wordpress
    – Kboy
    Dec 18, 2016 at 10:23
  • 1
    quick thoughts. can you set up a simplified version of this on demo to confirm the same problem there? also have you verified the 'format' of that field in your csv? also have you tried doing an export of the data from civi for the same fields just to verify you are feeding it the expected data formats?
    – petednz - fuzion ♦
    Dec 18, 2016 at 21:13
  • 1
    That was exactly the hint I needed. The problem is that CiviCRM exports (and imports) data in a CSV file in which every cell is formatted "general," while CommitChange exports donation amount as formatted "currency." Problem solved. Now, I wonder if the CiviCRM import wizard could be improved to give me a signal that it expects all CSV data to be formatted "general"?
    – Andrew Himes
    Dec 18, 2016 at 23:20
  • 1
    @AndrewHimes I'm glad that you solved this. Could you please add this as an answer to help other people that may have the same problem in future.
    – William Mortada
    Dec 19, 2016 at 9:13
  • while it was more of a Hint than an Answer, I popped mine out as an answer as it sounds useful. Andrew can do the same with his finding. glad it was a useful hint
    – petednz - fuzion ♦
    Dec 20, 2016 at 18:11

2 Answers 2

Reset to default
1

Try doing an export of the data from civi of the fields you want to import just to verify you have the data in the expected data formats

EDIT (from Andrew's comment above)

The problem is that CiviCRM exports (and imports) data in a CSV file in which every cell is formatted "general," while CommitChange exports donation amount as formatted "currency." Problem solved.

Improve this answer
0

Quick thought: Total Amount should just be an integer - so don't import $8 but 8.

Doing this daily is a real chore - CiviCRM has was to help automate such tasks - like civicrm rest API.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.