Chris any help??
Hi, a few pointers to get you up and running...
While I am using WordPress and various plugins this is not necessary to get the Editgrid map into a webpage hosted by yourself.
You need to get it up and running in Editgrid first - take care to make sure you have published your spreadsheet (so that the data can then be pulled by your website for use), and that the data is in the correct format when you paste it in (the Kiva export format has changed quite a bit since I wrote all of the bits and pieces, and some of the names of entrepreneurs don't paste very well and can stop things working - if you see any strange characters in the excel spreadsheet delete them first before pasting).
When you have a working Editgrid spreadsheet you then need to work on a page to display it on your website.
It needs something like the following code in the head section (of course you need to change it to your Editgrid spreadsheet and the Google API Key needs to be for your site):
<link rel="exhibit/data" type="application/jsonp"
href="http://www.editgrid.com/user/cweddell/My_Kiva_Loans.exhibit.jsonp.xsl"
ex:jsonp-callback="editgridCallback" />
<script src="http://static.simile.mit.edu/exhibit/api-2.0/exhibit-api.js"
type="text/javascript"></script>
<script src="http://static.simile.mit.edu/exhibit/extensions-2.0/time/time-extension.js"
type="text/javascript"></script>
<script src="http://static.simile.mit.edu/exhibit/extensions-2.0/map/map-extension.js?gmapkey=ABQIAAAAFrXIFYaXR106t_pQnPLo1hQjFBJcbMRHtccPiXxL2U5Hp7ZBIBR9d1CjbfWhjjmqYnkMAA1-5qhUIQ"
type="text/javascript"></script>
Then something like the following needs to be in the body:
<div id="exhibit-loan">
<div ex:role="coder" ex:coderClass="Color" id="item-colors" style="display: none">
<span ex:color="#800517">Active</span>
<span ex:color="#437C17">Raised</span>
<span ex:color="#000000">PaidBack</span>
<span ex:color="#E8A317">Fundraising</span>
<span ex:color="white">Defaulted</span>
<span ex:color="white">Refunded</span>
</div>
<table width="100%">
<tr valign="top">
<td colspan="3"><h1>My Kiva Loans</h1></td>
<td><a href="javascript:unhide('hiderow');">Show filters</a> or Search: <div ex:role="facet" ex:facetClass="TextSearch"></div></td>
</tr>
</table>
<table width="100%" id="hiderow" class="hidden">
<tr valign="top">
<td width="25%"><div ex:role="facet" ex:expression=".Country" ex:facetLabel="Country" ex:showMissing="false"></div></td>
<td width="25%"><div ex:role="facet" ex:expression=".Status" ex:facetLabel="Status" ex:showMissing="false"></div></td>
<td width="25%"><div ex:role="facet" ex:expression=".Activity" ex:facetLabel="Activity" ex:showMissing="false"></div></td>
<td width="25%"><div ex:role="facet" ex:expression=".Due" ex:facetLabel="Due (Year-Month)" ex:showMissing="false"></div></td>
</tr>
</table>
<table width="100%">
<tr valign="top">
<td colspan="4" ex:role="viewPanel">
<table ex:role="lens" class="nobelist" style="display: none">
<tr>
<td>
<img width="100" height="100" ex:src-content=".imageURL" />
</td>
<td width="350px">
<a ex:href-subcontent="http://www.kiva.org/app.php?page=businesses&action=about&id={{.BusinessID}}" target="_blank"><span style="text-alight:left;" ex:content=".label"></span></a><br />
<span ex:content=".location"></span><br />
MFI: <span ex:content=".Partner"></span><br />
Status: <b ex:content=".Status"></b><br />
Loan amount: <span ex:content=".loan_amount"></span><br />
Percentage repaid: <span ex:content=".percent_paid_back"></span>
</td>
<td width="250px">
<br />
Start: <span ex:content=".start"></span> for <span ex:content=".Term"></span> months<br />
Activity: <span ex:content=".Activity"></span> - <span ex:content=".loan_use"></span><br />
<br />
</td>
</tr>
</table>
<!--map-->
<div ex:role="view"
ex:viewClass="Map"
ex:latlng=".latlng"
ex:showSummary="false"
ex:mapHeight="600"
ex:showFooter="false"
ex:color="#669933">
<table ex:role="lens" class="nobelist" style="display: none">
<tr>
<td>
<img width="100" height="100" ex:src-content=".imageURL" />
</td>
<td>
<a ex:href-subcontent="http://www.kiva.org/app.php?page=businesses&action=about&id={{.BusinessID}}" target="_blank"><span style="text-alight:left;" ex:content=".label"></span></a><br />
<span ex:content=".location"></span><br />
Status: <b ex:content=".Status"></b><br />
Activity: <span ex:content=".Activity"></span> - <span ex:content=".loan_use"></span><br />
</td>
</tr>
</table>
</div>
<!--tiles-->
<div ex:role="view"
ex:orders=".BusinessID"
ex:directions="descending"
ex:showAll="false"
ex:abbreviatedCount="10"
ex:possibleOrders=".Country, .Activity, .Partner, .Due, .Status, .Term, .BusinessID">
</div>
<!--timeline-->
<div ex:role="view"
ex:viewClass="Timeline"
ex:start=".start"
ex:end=".finish"
ex:showSummary="false"
ex:colorKey=".Status"
ex:timelineHeight="2000"
ex:topBandHeight="99"
ex:bottomBandHeight="1"
ex:bottomBandPixelsPerUnit="100"
ex:topBandUnit="year"
ex:colorCoder="item-colors">
<table ex:role="lens" class="timelist" style="display: none">
<tr>
<td>
<img width="100" height="100" ex:src-content=".imageURL" />
</td>
<td>
<a ex:href-subcontent="http://www.kiva.org/app.php?page=businesses&action=about&id={{.BusinessID}}" target="_blank"><span style="text-alight:left;" ex:content=".label"></span></a><br />
<span ex:content=".location"></span><br />
Status: <b ex:content=".Status"></b><br />
Start: <span ex:content=".start"></span> for <span ex:content=".Term"></span> months<br />
Activity: <span ex:content=".Activity"></span> - <span ex:content=".loan_use"></span><br />
</td>
</tr>
</table>
</div>
</td>
</tr>
</table>
</div>
This is only a quick cut and paste from the source of
http://cjw.me.uk/mykiva-loan-map/ so might not work out of the box and will probably need a bit of hacking around with - as I never updated it using the cleaner code.
Hope this helps
Christopher