Thanks David, In the clear light of day (this morning) I see the error I was getting seems to be related to cross-domain scripting issues, it was confusing me that I was only getting an issue with Firefox but a Google search suggests that is par for the course and also says a way round it is JSONP
I fear this is all too advanced for me and I will be a lost cause - I suspect I might just have to resort to saving the output from editgrid into a local file on the sever for exhibit to pick up. I can't manage to get just the Exhibit JSON using http://www.editgrid.com/user/cweddell/My_Kiva_Loans.json?callback=foo I get the complete workbook with all the other spreadsheet data. Looking at your example I don't stand a chance in creating a converter for editgrid - way beyond me. I did manage to use this <link href="http://www.editgrid.com/user/cweddell/My_Kiva_Loans.js" type="application/jsonp" rel="exhibit/data" /> but it throws up invalid label error which I presume relates to a converter - but at least the data is being read and not caught up with cross-domain scripting issues. I wish I could contribute but as I say it is beyond me, I hope in the future editgrid might be supported - it is much more powerful than googlespreadsheet particularly with its xml stylesheets... from the same spreadsheet data using different XML stylesheets like http://www.editgrid.com/user/cweddell/My_Kiva_Loans.ics.xsl all sorts of feeds can be created. I have an iCal feed ( http://www.editgrid.com/user/cweddell/My_Kiva_Loans.ics) and KML (http://www.editgrid.com/user/cweddell/My_Kiva_Loans.points.kml ) as well as the exhibit data ( http://www.editgrid.com/user/cweddell/My_Kiva_Loans.js) all from the same spreadsheet / xml. David Huynh wrote: > Hi Christopher, > > For your exhibit on cjw.me.uk to be able to access the data from > www.editgrid.com , you have to get the data in JSONP format, not just > JSON. JSONP is basically JSON with a callback. EditGrid already supports > JSONP. Your data can be seen in JSONP like this > > http://www.editgrid.com/user/cweddell/My_Kiva_Loans.json?callback=foo > > But accessing it this way does not yield Exhibit JSON format. I'm not > sure what you have done to get Exhibit JSON for this URL > > http://www.editgrid.com/user/cweddell/My_Kiva_Loans.js > > but see if you can do similar things to get the Exhibit JSON for this URL > > http://www.editgrid.com/user/cweddell/My_Kiva_Loans.json?callback=foo > > Then you can just plug in that URL, and change "application/json" to > "application/jsonp". > > If you can't get that to work, then change your link to this > > <link href=" http://www.editgrid.com/user/cweddell/My_Kiva_Loans.json" > type="application/jsonp" > rel="exhibit/data" > ex:converter="editGridConverter" /> > > and add your own EditGrid converter > > <script> > var editGridConverter = function(json, url) { > ... > }; > </script> > > There is the Google Spreadsheet converter here to serve as an example: > > > http://static.simile.mit.edu/exhibit/api-2.0/scripts/data/importers/jsonp-importer.js > > Cheers, > > David
_______________________________________________ General mailing list [email protected] http://simile.mit.edu/mailman/listinfo/general
