{"id":1356,"date":"2012-10-11T19:07:40","date_gmt":"2012-10-11T23:07:40","guid":{"rendered":"http:\/\/mossiso.com\/?p=1356"},"modified":"2012-10-11T19:07:54","modified_gmt":"2012-10-11T23:07:54","slug":"if-at-first-you-dont-succeed","status":"publish","type":"post","link":"https:\/\/mossiso.com\/2012\/10\/11\/if-at-first-you-dont-succeed\/","title":{"rendered":"If at first you don’t succeed"},"content":{"rendered":"

…copy somebody’s code. Or at least your own from the past that works.<\/p>\n

I finally got the map to work for my Exhibit exhibit. See<\/a>.<\/p>\n

 <\/p>\n

First I copied the tutorial here<\/a>. When that was working, I carefully copied it to the file I wanted it to be in and… nothing. Still broken.<\/p>\n

So next I commented out all extraneous stuff, and finally got it to work. Now came the fun part of tracking down what code was making my awesome map look like nothing. I narrowed it down to something within the <header> tag. So line by line I uncommented and tested until I tracked the issue down to the bootstrap.css file I was using.<\/p>\n

Then came the same process within the bootstrap.css file. It was easily 1000 lines long, so a line by line process wasn’t going to work. Instead I commented out the first have of the file. Bing, the map displayed, so it was somewhere within that first 500 lines. Then I commented out the first 250 lines. Bing again. I kept dividing the culprits in half until I narrowed it down to styles for the img tag. Commented those out and I was in business.<\/p>\n

Through that grueling process I lost the images of the documents on the first page. Now I have to figure out how to get those back, apply some styling and we’re all set.<\/p>\n

Unfortunately I wasn’t ever able to get it to pull in the data from a spreadsheet, so the JSON file will have to do. The process for making a JSON file from a spreadsheet is simple:<\/p>\n

1. Make the spreadsheet file so that the headers are encapsulated with curly braces ‘{ }’<\/p>\n

\"\"<\/a><\/p>\n

2. If you’re using Google spreadsheets, export it as an Excel file. You’ll have to open it in Excel and save it as an older file format, because the next step doesn’t like .xlsx.<\/p>\n

3. Next, use Similie’s Babel tool<\/a> to convert the spreadsheet to JSON.<\/p>\n

4. Select “Excel” as the “from format” and “Exhibit JSON” as the “to format” and then browse to find the xls file you just made.<\/p>\n

5. Click the “Upload and Convert” button.<\/p>\n

\"\"<\/a><\/p>\n

6. The next screen is all of your spreadsheet data output into a nice JSON format.<\/p>\n

\"\"<\/a><\/p>\n

7. Now you can use this JSON file for any number of things. But it’s especially nice to use it in an Exhibit to display your data.<\/p>\n

\"\"<\/a><\/p>\n

This is cross posted at the class blog http:\/\/www.fredgibbs.net\/clio3workspace\/blog\/if-at-first-you-dont-succeed\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

…copy somebody’s code. Or at least your own from the past that works. I finally got the map to work for my Exhibit exhibit. See.   First I copied the tutorial here. When that was working, I carefully copied it to the file I wanted it to be in and… nothing. Still broken. So next … Continue reading If at first you don’t succeed<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":1358,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[166,3,15,243,8,167],"tags":[87,245,246,60,247],"class_list":["post-1356","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-academic","category-coding","category-dissertation","category-howto","category-school-work","category-technical","tag-digital-maps","tag-exhibit","tag-json","tag-maps","tag-spreadsheets"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/mossiso.com\/wp-content\/uploads\/2012\/10\/Screen-Shot-2012-10-11-at-6.52.09-PM.png","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9wosP-lS","_links":{"self":[{"href":"https:\/\/mossiso.com\/wp-json\/wp\/v2\/posts\/1356"}],"collection":[{"href":"https:\/\/mossiso.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mossiso.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mossiso.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mossiso.com\/wp-json\/wp\/v2\/comments?post=1356"}],"version-history":[{"count":4,"href":"https:\/\/mossiso.com\/wp-json\/wp\/v2\/posts\/1356\/revisions"}],"predecessor-version":[{"id":1364,"href":"https:\/\/mossiso.com\/wp-json\/wp\/v2\/posts\/1356\/revisions\/1364"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mossiso.com\/wp-json\/wp\/v2\/media\/1358"}],"wp:attachment":[{"href":"https:\/\/mossiso.com\/wp-json\/wp\/v2\/media?parent=1356"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mossiso.com\/wp-json\/wp\/v2\/categories?post=1356"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mossiso.com\/wp-json\/wp\/v2\/tags?post=1356"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}