Kiva's Export - on steroids

History

The first step to use Kiva's Export was to use offline programmes such as Microsoft Excel and OpenOffice.org Calc - Analysis Spreadsheets for both can be found here - to better analyse your portfolio of loans.

The next logical step was to find an online solution where the data in Kiva's Export could be displayed on an interactive sortable, filterable web page. My first thought was just to replicate the functions within the Analysis Spreadsheets, but using Exhibit 2.0 ajax / javascript from MIT it was going to be much more useful as a way to publicly display a collection of Kiva loans.

Description

As before, all you have to do is cut and paste the data from Kiva's export into your specially published Google Docs Spreadsheet (this is mine), and have a special page on your website to display the data (this is a basic example). Here is the Kiva Shopping Club version.
There are a few steps that are needed to setup this system, but once completed any updates of export data can easily be cut and pasted into the Google Docs Spreadsheet - and change are reflected on the web page almost instantly.
If you have any suggestions for modifications or additions please let me know via Kivafriends.org and I will try an incorporate them.

Requirements

You will need the following:

A Google account to create and store the spreadsheet
A Google Maps API key (if you want to display a map of your loans)
Somewhere to host your public page
If you want pictures to appear in the web page you need to save a collection of your own, using the Business ID as the filename - and store them in a known location on your web server. I recommend having pictures around 100px by 100px and saved as .jpg
If you want to use the map feature coordinates are needed for all your loan locations (eg 25.502785,-99.470215)

Setup stage 1 (with test data)

Goto Google Docs and create a new spreadsheet by uploading the specially prepared OpenOffice.org Calc Spreadsheet - by either:

downloading the file to your computer and uploading it again to Google Docs
entering the URL of the file (http://cjw.me.uk/kiva/spreadsheets/gexport/my_kiva_loans.ods) into Google Docs and allowing it to do the work.

Next we need to publish the Details sheet using the Publish tab in the top right corner and selecting 'Publish now'
I suggest you then select the 'Automatically re-publish when changes are made' checkbox - and select 'Sheet "Details" only' from the dropdown
Select the 'More publishing options' link at the section so we can generate the feed url needed:

Choose 'Atom' as the file format
Select 'Sheet "Details" only' from the next dropdown
Keep 'List' selected from the feed format
Generate and save the URL which should look something like this:
'http://spreadsheets.google.com/feeds/list/o09144385628784991970.2945961745728943451/od6/public/basic'

Download this zip file, and extract the 2 html files (loanlist.html and __history__.html)
Open loanlist.html in your favourite html editor and insert the following over the test data settings:

Your Google Docs Spreadsheet feed link appended with '?alt=json-in-script' into line 7 so it looks something like:
http://spreadsheets.google.com/feeds/list/o09144385628784991970.2945961745728943451/od6/public/basic?alt=json-in-script
Your Google Maps API key into line 14, which looks something like:
ABQIAAAAFrXIFYaXR106t_pQnPLo1hQjFBJcbMRHtccPiXxL2U5Hp7ZBIBR9d1CjbfWhjjmqYnkMAA1-5qhUIQ

__history__.html does not need any attention (it is used by the ajax scripts to ensure the browser back and next fuctions work)
Upload the 2 html files to your server and view loanlist.html in your favourite browser - you should hopefully see a working page with some of my loans

Setup stage 2 (with your data)

Open a copy of your data using Kiva's export button: http://www.kiva.org/app.php?page=account&action=loans&export_excel=1 (will open in your web browser and ask you to log in to Kiva.org if you are not already)
Copy the entire 'My loans' sheet and paste over the data in the 'My loans' tab within your Google Docs Spreadsheet
Ensure that the 'Details' tab matches the number of rows within the 'My loans' tab:

Delete any excess rows, or
Add more rows and copy the formulas down so that the new data appears

Edit the formula is cell C2 so that it points to a directory of your images eg:
=CONCATENATE("http://path_to_your_image_directory", B2, ".jpg")
copy the formula down the column.
If you don't want to have images delete column C
If you want to have a map of your loans enter the latitude and longitude values in column Q {latlng}
they must be in the format 'latitude,longitude' with no spaces eg 25.502785,-99.470215
otherwise delete column Q
If you are using images and want a map you have finished, refresh and review your loanlist.html web page - you should see your loans.

Setup stage 3 (customising listloans.html)

If you have deleted column C or Q, or wish to change how the page looks you need to open up listloans.html and tinker around
To remove the images eradicate all references to: <img ex:src-content=".imageURL"/>
and delete the section marked:  (as this will be pretty much useless to you without images)
To remove the map delete the section marked:

The layout and format of loanlist.html is entirely changeable and can be easily modified. Check out the full references into how Exhibit 2.0 works on its website.

Setup too much?

Contact me via my Kivafriends.org profile and I can try to assist you.

Credits

to copy, distribute, display, and perform the work
to make derivative works

Under the following conditions:

Attribution. You must give the original author credit.
Non-Commercial. You may not use this work for commercial purposes.
Share Alike. If you alter, transform, or build upon this work, you may distribute the resulting work only under a licence identical to this one.

For any reuse or distribution, you must make clear to others the licence terms of this work.
Any of these conditions can be waived if you get permission from the copyright holder.
Nothing in this license impairs or restricts the author's moral rights.
http://creativecommons.org/licenses/by-nc-sa/2.0/uk/