Answers.Body: <p>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</p>
  
  <p>EDIT (from Andrew's comment above)</p>
  
  <p>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.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-20T18:09:53.997Z
Answers.LastActivityDate: 2017-04-20T00:41:27.197Z
Answers.LastEditDate: 2017-04-20T00:41:27.197Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>Quick thought:
  Total Amount should just be an integer - so don't import $8 but 8.</p>
  
  <p>Doing this daily is a real chore - CiviCRM has was to help automate such tasks - like civicrm rest API.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-18T20:15:17.973Z
Answers.LastActivityDate: 2017-02-18T20:15:17.973Z
Answers.UserDisplayName: KarinG - Semper IT
Body: <p>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:</p>
  
  <p>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."</p>
  
  <p>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.</p>
  
  <p>Drupal 7.53 with CiviCRM 4.7.14
  also tested on CiviCRM 4.7.13 on a different Drupal site</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-12-18T10:23:58.947Z
Comments.Text: it will be nice to add here the CiviCRM versions you have tested on and indicated if you are using Drupal, Joomla or Wordpress
Comments.UserDisplayName: Kboy
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-12-18T21:13:50.137Z
Comments.Text: 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?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-12-18T23:20:40.527Z
Comments.Text: 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"?
Comments.UserDisplayName: Andrew Himes
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-12-19T09:13:10.310Z
Comments.Text: @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.
Comments.UserDisplayName: William Mortada
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-12-20T18:11:06.517Z
Comments.Text: 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
Comments.UserDisplayName: petednz - fuzion
Tags: <civicontribute><import>
Title: Bug in the data import wizard
ThreadText: # Bug in the data import wizard
  
  (Asked by: username_0 on 2016-12-18)
  
  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
  
  **Tags:** civicontribute, import
  
  > **Comments:**
  > **username_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  
  > **username_2**: 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?  
  > **username_0**: 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"?  
  > **username_3**: @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.  
  > **username_2**: 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  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2016-12-20. Score: 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.
  
  
  ---
  
  ### Answer by username_4 on 2017-02-18. Score: 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.
  
  
  ---
  
  