Answers.Body: <p>The <a href="https://civicrm.org/extensions/api-csv-import-gui" rel="nofollow">API csv Import GUI extension</a> will allow you to import pledges. You can import the pledges and then separately, the contributions marked as pledge payments that correspond to the needed pledges.</p>
  
  <p>Note: When you import the contributions, you will need a column for "pledge payment" that is marked Y for each row.  Also, you will need a column with the corresponding pledge number for each row so the import knows which pledge the contribution goes to.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-13T23:11:04.190Z
Answers.Text: Allen. This looks promising but I am unable to import the pledge payments. 
  I tried to do it from the contribution importer (I inlcuded the pledge payment columns with y for each row along with the pledge ID) I get a very vague error that isn't helpful. I also tried to import as pledge payments from API csv but no luck. I get an error there as well. Any ideas or insights you can share?
Answers.UserDisplayName: Yossi
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-16T00:18:29.833Z
Answers.Text: Oh boy, the last time I used that extension was two years ago.  I know you said the error was vague, but what was the text of it?
Answers.UserDisplayName: Allen Hutchison
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-12T15:26:23.997Z
Answers.LastActivityDate: 2015-09-12T16:01:57.360Z
Answers.LastEditDate: 2015-09-12T16:01:57.360Z
Answers.UserDisplayName: Allen Hutchison
Answers.Body: <p>We solved the current problem using a tool called Selenium. It is basically a testing tool, but you can record a script and create an XML file with each line having the data for one transaction. The tool simulates a user at a browser.  Took about 5 hours time from an experienced programmer to setup.  For 300 transactions we probably broke even on time but being a nonprofit the labor was volunteer. If we had to pay for the developer it would have been less expensive to hire a temp. </p>
  
  <p>Our plan for next year is to code a module so our office staff can easily import a CSV file.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-22T21:12:23.427Z
Answers.LastActivityDate: 2015-09-22T21:12:23.427Z
Answers.UserDisplayName: user469
Body: <p>I am doing a billing. We enter items as pledges. I need a way to import the pledges from a spreadsheet. Last year I imported directly into the pledge table and did not realize I needed to also load the pledge_payment table. The pledge_payment is more complicated as you need the pledge number. Looking for an easy way to load both.</p>
  
Tags: <pledges>
Title: Importing Pledges
ThreadText: # Importing Pledges
  
  (Asked by: username_0 on 2015-09-12)
  
  I am doing a billing. We enter items as pledges. I need a way to import the pledges from a spreadsheet. Last year I imported directly into the pledge table and did not realize I needed to also load the pledge\_payment table. The pledge\_payment is more complicated as you need the pledge number. Looking for an easy way to load both.
  
  **Tags:** pledges
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2015-09-12. Score: 4
  
  The [API csv Import GUI extension](https://civicrm.org/extensions/api-csv-import-gui) will allow you to import pledges. You can import the pledges and then separately, the contributions marked as pledge payments that correspond to the needed pledges.
  
  Note: When you import the contributions, you will need a column for "pledge payment" that is marked Y for each row. Also, you will need a column with the corresponding pledge number for each row so the import knows which pledge the contribution goes to.
  
  > **Comments:**
  > **username_2**: username_1. This looks promising but I am unable to import the pledge payments.  I tried to do it from the contribution importer (I inlcuded the pledge payment columns with y for each row along with the pledge ID) I get a very vague error that isn't helpful. I also tried to import as pledge payments from API csv but no luck. I get an error there as well. Any ideas or insights you can share?  
  > **username_1**: Oh boy, the last time I used that extension was two years ago.  I know you said the error was vague, but what was the text of it?  
  
  ---
  
  ### Answer by username_0 on 2015-09-22. Score: 0
  
  We solved the current problem using a tool called Selenium. It is basically a testing tool, but you can record a script and create an XML file with each line having the data for one transaction. The tool simulates a user at a browser. Took about 5 hours time from an experienced programmer to setup. For 300 transactions we probably broke even on time but being a nonprofit the labor was volunteer. If we had to pay for the developer it would have been less expensive to hire a temp.
  
  Our plan for next year is to code a module so our office staff can easily import a CSV file.
  
  
  ---
  
  