tag:blogger.com,1999:blog-15626356.post117118700048634436..comments2012-10-17T10:09:12.903-07:00Comments on ecmanaut: JSONP and SpreadsheetsJohan Sundströmhttp://www.blogger.com/profile/04076097346172610543noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-15626356.post-19183624495156267962010-07-09T10:25:05.689-07:002010-07-09T10:25:05.689-07:00oh thanks for the replyoh thanks for the replysteve whitehttp://twitter.com/lostexpectationnoreply@blogger.comtag:blogger.com,1999:blog-15626356.post-77349715384449890992010-07-05T15:56:35.288-07:002010-07-05T15:56:35.288-07:00Sure; I didn't notice when editgrid stopped pu...Sure; I didn't notice when editgrid stopped publishing the .xsl links in the chart above to non-logged-in users. Here are the top left two examples, for now (I'm just on the go, so I'll get back to the other later):<br /><br />json.xsl - http://gist.github.com/464789<br />data.jsonp.xsl - http://gist.github.com/464789Johan Sundströmnoreply@blogger.comtag:blogger.com,1999:blog-15626356.post-44475471547597627412010-07-03T04:41:05.594-07:002010-07-03T04:41:05.594-07:00can we get the actual stylesheets?can we get the actual stylesheets?steve whitehttp://twitter.com/lostexpectationnoreply@blogger.comtag:blogger.com,1999:blog-15626356.post-77890949682810497622007-12-18T13:19:00.000-08:002007-12-18T13:19:00.000-08:00Johan:Thank you for the help with the code. With ...Johan:<BR/><BR/>Thank you for the help with the code. With a few minor tweaks, it works great and I have finally connected an EditGrid page with multiple items in a cell with an Exhibit page.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15626356.post-78981956364932172282007-12-18T10:32:00.000-08:002007-12-18T10:32:00.000-08:00(Oops; the for loop body should have a line readin...(Oops; the for loop body should have a line reading <B>var item = items[i];</B> first.)Johan Sundströmhttps://www.blogger.com/profile/04076097346172610543noreply@blogger.comtag:blogger.com,1999:blog-15626356.post-17010426274800046402007-12-18T10:30:00.000-08:002007-12-18T10:30:00.000-08:00Try making your <link rel="exhibit/data"> re...Try making your <B><link rel="exhibit/data"></B> read <B><link rel="exhibit/data" ex:converter="convert"></B> and add a function<BR/><BR/><B>function convert( json ) {<BR/> var items = json.items;<BR/> for (var i = 0; i < items.length; i++) {<BR/> item.category = item.category.split("; ");<BR/> }<BR/> return { items:items };<BR/>}</B><BR/><BR/>somewhere in the page, and it'll probably work better.Johan Sundströmhttps://www.blogger.com/profile/04076097346172610543noreply@blogger.comtag:blogger.com,1999:blog-15626356.post-78015458714992850842007-12-18T09:43:00.000-08:002007-12-18T09:43:00.000-08:00Johan:Thank you for your help. I've tried numerou...Johan:<BR/><BR/>Thank you for your help. I've tried numerous times to do an ex:converter function without success. The multiple data items are separated in cells by a semicolon. The URL of my Exhibit is at http://www.swingingsammy.com/myerstimeline/myerstimeline20C.html. Everything is working but the lack of separator. I have items in the category and era facets that need separating. Any tweaking or guidance would be greatly appreciated.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15626356.post-48610836501464897682007-12-14T04:12:00.000-08:002007-12-14T04:12:00.000-08:00They actually even had the good judgment of runnin...They actually even had the good judgment of running it by me (just prior to releasing it), allowing me to help them catch a few flaws and a security hole they quickly patched up, so I'm aware of the, finally native, great feature.<BR/><BR/>Re: multiple data items in a single cell for Exhibit, I suggest using a convention of yours of some kind to separate values from one another -- semicolon, for instance, if that is a character that won't show up in items themselves, and craft an ex:converter function which splits the values of that cell on this separator, before returning it to Exhibit.<BR/><BR/>If you don't manage to work out how to do that on your own, feel free to give a URL to an exhibit where you have data on that format, and I can probably help you tweak it.Johan Sundströmhttps://www.blogger.com/profile/04076097346172610543noreply@blogger.comtag:blogger.com,1999:blog-15626356.post-1057475795320847812007-12-13T20:13:00.000-08:002007-12-13T20:13:00.000-08:00Johan: In case you do not know, JSONP is now avai...Johan: In case you do not know, JSONP is now available for EditGrid see <A HREF="https://wiki.editgrid.com/wiki/Advanced_Features/JSONP" REL="nofollow">https://wiki.editgrid.com/wiki/Advanced_Features/JSONP</A>. Also, is there a way to allow for multiple items in each cell (for example to have two items for two categories)? When I try to separate the multiple items in an EditGrid cell they are still treated as one item by Exhibit using JSONP. Otherwise the xsl stylesheets your provided are working great for use with Exhibit. Thanks for all your hard work and sharing your knowledge.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15626356.post-1171527760451761912007-02-15T00:22:00.000-08:002007-02-15T00:22:00.000-08:00They are, either by saving my live stylesheets poi...They are, either by saving my live stylesheets pointed to by the .xsl links above, or by picking them up from my <A HREF="http://svn.devjavu.com/ecmanaut/trunk/converters/editgrid/" REL="nofollow">subversion repository</A>.Johan Sundströmhttps://www.blogger.com/profile/04076097346172610543noreply@blogger.comtag:blogger.com,1999:blog-15626356.post-1171526375238686192007-02-14T23:59:00.000-08:002007-02-14T23:59:00.000-08:00Are those XSL available? If yes where?Are those XSL available? If yes where?Frank Mondorahttps://www.blogger.com/profile/12312911649522678625noreply@blogger.com