Many, Many people have asked me if there was an easy way to get the Prosper XML files as CSV (comma separated values). In response, I have build a utility that does just that. I contributed the utility to the Prosper API Open Source Project on SourceForge.
With CSV files you can easily import the files into older versions of MS Access (with access 2007 you can import the xml directly) and various statistics packages (SASS, MatLab). I tried to make the utility extremely easy to use. In that spirit I have also built a single JAR file, which you can download here: ProsperXMLtoCSV.jar. By using the single JAR you do not need to worry about your class path and various other java idiosyncrasies.
Please note that these CSV files are larger than can be opened in Excel. If you do open with excel some rows will be missing.
There are 2 ways to run the jar; however, only one way provides you with feedback during the long process of parsing the XML files and producing the CSV files. So I will only tell you how to run the jar with feedback.
With java 5 or better installed and in your path use the following command line from the directory containing the ProsperXMLtoCSV.jar file…
java -jar ProsperXMLtoCSV.jar ProsperXMLFileLocation CSVDestinationDirectory
- Prosper XML File Location: this is either the relative or fully qualified path to the Prosper XML file you are trying to parse
- CSV Destination Directory: optional (if left off the current directory will be used) this is either the relative or fully qualified path to the destination directory for the CSV files
When you run this file you are given an output similar to this (this output was for the private data file)…
C:\prosperapi\trunk\data>java -jar ProsperXMLtoCSV.jar ProsperDataPrivateExpor
xml .
Starting conversion of CreditProfiles
CreditProfiles rows converted: 10000
CreditProfiles rows converted: 20000
CreditProfiles rows converted: 30000
CreditProfiles rows converted: 40000
CreditProfiles rows converted: 50000
CreditProfiles rows converted: 60000
CreditProfiles rows converted: 70000
CreditProfiles rows converted: 80000
CreditProfiles rows converted: 90000
CreditProfiles rows converted: 100000
CreditProfiles rows converted: 110000
CreditProfiles rows converted: 120000
CreditProfiles rows converted: 130000
CreditProfiles rows converted: 140000
CreditProfiles rows converted: 150000
CreditProfiles rows converted: 160000
CreditProfiles rows converted: 170000
CreditProfiles rows converted: 180000
CreditProfiles rows converted: 190000
CreditProfiles rows converted: 200000
CreditProfiles rows converted: 210000
CreditProfiles rows converted: 220000
ProsperDataExport rows converted: 221166
Starting conversion of LoanPerformances
LoanPerformances rows converted: 10000
LoanPerformances rows converted: 20000
LoanPerformances rows converted: 30000
LoanPerformances rows converted: 40000
LoanPerformances rows converted: 50000
LoanPerformances rows converted: 60000
LoanPerformances rows converted: 70000
LoanPerformances rows converted: 80000
LoanPerformances rows converted: 90000
LoanPerformances rows converted: 100000
LoanPerformances rows converted: 110000
LoanPerformances rows converted: 120000
LoanPerformances rows converted: 130000
LoanPerformances rows converted: 140000
LoanPerformances rows converted: 150000
LoanPerformances rows converted: 160000
LoanPerformances rows converted: 170000
LoanPerformances rows converted: 180000
LoanPerformances rows converted: 190000
LoanPerformances rows converted: 200000
LoanPerformances rows converted: 210000
LoanPerformances rows converted: 220000
LoanPerformances rows converted: 230000
LoanPerformances rows converted: 240000
LoanPerformances rows converted: 250000
ProsperDataExport rows converted: 257224
If you like this utility consider supporting future open source development with a donation via paypal:
Related Posts -
Prosper Debt Sale Offer Roughly 0.93%-4.83% On Friday, Doug Fuller gave an update on the debt sale. Synopsis:Â Prosper put the bid file on an auction site, 8 bids received, all the bids were very disappointing, Prosper has not accepted a bid yet, and is exploring options for getting a better deal. When asked how disappointing...... - Prosper Debt Sale In Progress As I mentioned several days ago a debt sale is about to be completed. I have had 3 loans sold so far (I will update this page if more are sold)... B Credit @15.16% interest rate, non-homeowner, sold for 9.54% of principal (borrower had not made a single payment). C......
- Original Pre-Launch Group Leaders Compensated with Stock On a thread in the forum it was revealed for the first time that I am aware of that the earliest pre launch special invite group leaders were compensated with stock (see here). I used ProProsper to identify these groups. I am unsure of the exact cutoff date so I......
- The WealthBoy Strict ROI for Prosper Lenders WealthBoy, whom I met at Prosper Days, has just released The WealthBoy Strict ROI for Prosper Lenders -- an open source, sql based ROI calculation for Prosper Lenders. His calculation makes use of the public and private data files from Prosper. He was inspired by his Prosper Blog post: The Rule......
- Another Developer List Email From Prosper: Thank you for your patience while we have been working through the recent API and XML issues. The web service API has been re-enabled and we are monitoring it closely. You may notice that the Prosper calculated ROI numbers are temporarily unavailable. We apologize for any inconvenience this......
Related Websites -
Powerball Australia Results file Powerball Results Australia - latest and all historical results can be viewed here: POWERBALL Results Powerball has a guaranteed minimum jackpot of $3million, but can go as high as $100million+. The draw is composed of 5 balls chosen from a barrel of 45 balls, and 1 Powerball taken from another barrel...... -
Target Retirement Funds Portfolio Composition And Expenses: Vanguard vs Fidelity vs T Rowe Price This is the first post in a series comparing and contrasting target retirement funds from three competing companies: Vanguard, Fidelity, and T Rowe Price. Today, I will be comparing the portfolio composition and expense characteristics of both the 2030 and 2005 funds from each company to get a good overview......
- More Roth Magic For this, you must do a bit of homework to see if this advice can apply to you. Go to Fairmark and look at the tax rate schedule that applies to your filing status. You must also have a good idea what your taxable income will be, at least as......
-
Yankee Candle Home For The Holidays 22 Oz. Jar User Reviews Send this to a friend Yankee Candle Home For The Holidays 22 Oz. Jar Manufacturer: Yankee Candle Customer Rating: List Price: $22.99 Sale Price: $21.49 Availibility: Usually ships in 1-2 business days Buy Now Product Description Yankee Candle's Home For The Holidays jar candle brings an inviting...... -
IRS Releases 2009 Federal Income Tax Rates & Brackets Although most of us are still working on our 2009 federal income taxes, the tax rates for 2008 taxes are already available from the IRS. Remember that the total amount of income you will be taxed on will be decreased by your personal deduction, the standard deduction or your itemized......
- Open Pit BBQ Sauces Outdoor Cooking & Eating Yard, Garden & Outdoor Living
- Midi Files Piano Acoustic Musical Instruments
- Open Back Banjo String Acoustic Musical Instruments
- Java Plants Aquatic Plants Plants, Seeds & Bulbs Gardening & Plants Yard, Garden & Outdoor Living Nursery
- Files & Chisels Hand Tools Tools Home Improvement
Categories:
9 comments ↓
Thanks for the contribution Kevin!
[...] RateLadder built a tool to Convert Prosper XML to CSV [...]
This is fantastic, thanks!
I am glad you like it.
I clicked on the link above for the “single jar file” and it downloads a zip archive. There are no files in the archive called ProsperXMLtoCSV.jar
There is something called main.jar, but I get errors when I run that.
I don’t speak java, and I just want to get either CSV files, or this loaded into SQL Server without me having to write any java or VB. Please help.
The jar file itself is runnable… Assuming you have java installed. Jar is just a special zip file. Meaning that a jar is a file in the zip format, but the a java enabled environment jars can be run. This particular jar is special in that I compiled everything needed to run it into a single file eliminating possible class path issues.
Like Jeff, I am also confused as to how to follow the instructions above. Can someone please assist?
You write:
“With java 5 or better installed…”
- I am running Java 6.7
“…and in your path…”
- I don’t know what is meant by this exactly
“…use the following command line from the directory containing the ProsperXMLtoCSV.jar file…”
- As Jeff notes above, there are no files in the zipped archive by that file name
“…java -jar ProsperXMLtoCSV.jar ProsperXMLFileLocation CSVDestinationDirectory”
- I’m not clear about where to enter this command
This would be an incredibly helpful utility if I can get it working. Thanks in advance for your assistance.
the link in the post to to a file name “ProsperXMLtoCSV.jar” that file is whole and does not need to be unzipped. It will run from a command line if everything is properly configured as stated in this post.
Ok, for those of you still having trouble, here are some additional instructions for how to run this conversion:
1. You must save the above ProsperXMLtoCSV.jar link to your computer as a *.jar file, NOT as a *.zip file. Right-click on the link and select “Save target as…” to accomplish this.
2. You must start with an open Command Prompt. From Windows, go to Start\Programs\Accessories and select Command Prompt. The user interface should look like MS DOS.
3. You must run the above Java command as indicated from the directory into which you have saved the *.jar file. It is helpful to save the *.jar file in the same directory as your Prosper *.xml file(s).
4. Within the Java command, “ProsperXMLFileLocation” is the actual name of your *.xml file that you want to convert. If you are running the command from the same directory that your file is located in, you can just type the name of the file with the *.xml extension included.
Hope this helps.
Leave a Comment