Prosper.com makes all publicly available data accessible via a data export. They also provide tools for importing that data into Microsoft Sql Server 2005. What they don’t provide is a mechanisms for getting this data into other databases, specifically in my case Microsoft Sql Server 2000. I have succeeded in importing the data into a Sql Server 2000 database and I am sharing that information with the world.
One of the main problems with importing the data directly into Sql Server 2000 is the row size of the data in the export. Sql Server 2000 has a limit of 8060 bytes per row. At least one row in the export is larger, but I expect there are quite a few. While I was examining the data model I noticed 2 columns in several tables that I really don’t care about: description and images. I say I don’t care about them because for my purposes I just care about credit and interest rate (I expect that most people are the same) and if I care that information is available by looking on Prosper.com since I have the primary key. So that being said, my technique requires removing those columns from the import. I have provided all the needed files so for others this wont be very difficult.
Step 1: Download the data from Prosper.com here ProsperDataExport_xml.zip and unzip to a new directory
Step 2: Download the following zip archive and unzip into a new directory: Files required to import Prosper.com data into Sql Server 2000
Step 3: Create a Database (I named mine Propser). Run the sql script ProsperDataExport_CreateTables.sql from the RateLadder.com download.
Step 4: If you don’t already have SqlXml 3.0 by Microsoft click the link to download and install.
Step 5: Replace ProsperDataExport.xsd with the RateLadder.com version.
Step 6: In Enterprise Manager create a DTS package. Add an ActiveX Task. Use the code in the file ActiveXTask.txt as the code for the new task. Please be sure to replace the file locations and database name in the code with your file locations and database name.
Step 7: Execute the Task.
Viola!
If you found this helpful and you would like to donate to show your appreciation please feel free to do so. Thanks, RateLadder.com
Related Posts -
Prosper's People-to-People Lending Market Survey SAN FRANCISCO--(BUSINESS WIRE)--Prosper (www.prosper.com), America's largest people-to-people lending marketplace, today introduced its first monthly People-to-People Lending Market Survey. Prosper's People-to-People Lending Market Survey will survey the marketplace each month to provide key statistics including: membership and loan volume statistics; marketplace returns; borrower rates; mix of prime, near prime and sub-prime...... - Prosper in May Set a New Monthly Loan Origination Volume High Water Mark (sql to produce statistics at the end of post) In May, Prosper originated more loan volume than in any previous month roughly 9.6M loans the vast majority were credit grades AA-C. This is great news for Prosper on 2 fronts: total volume and loan quality. Here is the breakdown... May......
- Prosper API Now Has ListingKey On Loan Table A nugget that I missed from the Mid August Prosper Upgrade is that the loan and listing objects in the API are now tied together with a Prosper provided listing key on the loan object. While I had achieved 99.8% loan to listing matching, I was still missing a few. Leporello......
-
1 Month Late or Worse Curves by Credit Grade I have pulled the public data on the performance tab by hand in order to produce a spreadsheet of loan performance. This spreadsheet was then pivoted and aggregated in order to produce 1 month late curves by credit grade and Markov Chains which can be used (when 42 months of data is...... -
54 Segments of Prosper Data = Thin Data One of Prosper's most recent changes was to add bidding guidance on the manual bid page. See the picture below. I think this is a great feature in theory. It makes the estimated return obvious using Prosper's own roll rates. I am sure this will be an incredibly valuable feature......
Related Websites - Optimizing Flash Files For The Search Engines What is a Flash Movie? A flash movie, or shock wave file (SWF), is the file format published when a Flash movie is exported. A SWF file can also be exported by several other Macromedia or Adobe Products. The SWF is usually an animation, dynamic menu, or highly interactive web-based......
- 3 Easy Steps to Start Succeeding With Affiliate Marketing Affiliate internet marketing is basically described as an agreement between an online merchant or product seller and an affiliate or publisher. An affiliate gets paid or earns a commission for producing sales, leads or in certain arrangement clicks to a merchant’s website. This arrangement works out great for both parties......
- Dot Net Development: LINQ improves the productivity of a developer Microsoft Language Integrated Query (LINQ) offers developers a latest way to query data using strongly-typed queries and strongly-typed results, frequent across a number of dissimilar data types including relational databases, .NET objects, and XML. With the help of strongly-typed queries and results, LINQ improves the productivity of a developer with......
-
How I Love Thee ING Direct, Let Me Count The Ways I've had a savings account with ING Direct going back to 2003. I was at my parent's house doing my taxes on their computer with Turbo Tax. At the end of the session an ad popped up with an offer to sign up to ING Direct and get what I......
-
Save Time, Money and Space in Over 80 Ways If you're looking for handy gadgets, tools and various items that can save you time, money or space (or all three!) this list of more than 80 top products is just what you need. Everyone's got saving money on their minds these days. Some of us are always looking to......
Categories:
Prosper.com, Tools
Tags:
0 comments ↓
There are no comments yet...Kick things off by filling out the form below.
Leave a Comment