{"id":1741,"date":"2015-02-05T01:35:43","date_gmt":"2015-02-05T05:35:43","guid":{"rendered":"http:\/\/www.bonesnap.com\/blog\/?p=1741"},"modified":"2015-02-05T01:35:43","modified_gmt":"2015-02-05T05:35:43","slug":"holy-crap","status":"publish","type":"post","link":"https:\/\/www.bonesnap.com\/blog\/2015\/02\/05\/holy-crap\/","title":{"rendered":"Holy Crap!"},"content":{"rendered":"<p>Holy crap on a cracker! I haven\u2019t posted anything on my blog in over a year!<\/p>\n<p>Let\u2019s see if I can change that this year.<\/p>\n<p>In summary, I needed some data from the 911 telecommunicator field for a research project. I posted two surveys on various websites and Facebook to help me collect that data. Between both surveys I received several thousand responses. Once the surveys closed, I started the long and laborious process of aggregating that data.<\/p>\n<p>It didn\u2019t take me long to realize that I had long road ahead of me. I used PINNION to host my survey forms. Its awesome site that it supports just about any interface you can think of to view and take a survey. However, it lacks in getting those results back out in a usable form. I couldn\u2019t export to csv or excel which meant I had to manually copy out the results.<\/p>\n<p>Uggggggggg.<\/p>\n<p>Due to work and frustration, I decided to take a break from all my website and writing projects. During Christmas break, I started back with renew vigor. I tackled the salary survey first since it is the smallest set of a questions and answers. I managed to figure out a way to get the data loaded in to a database that actually made logical sense.<\/p>\n<p>Where I\u2019m at today<\/p>\n<p>Trying to figure out how to host\/display this data while not cluttering up my blog is my number one priority. Most likely have a page and nice little graphics and stuff. Who the hell knows?<\/p>\n<p>To the future!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Holy crap on a cracker! I haven\u2019t posted anything on my blog in over a year! Let\u2019s see if I can change that this year. In summary, I needed some data from the 911 telecommunicator field for a research project. I posted two surveys on various websites and Facebook to help me collect that data. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1522,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[38],"tags":[],"class_list":["post-1741","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.bonesnap.com\/blog\/wp-json\/wp\/v2\/posts\/1741","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bonesnap.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bonesnap.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bonesnap.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bonesnap.com\/blog\/wp-json\/wp\/v2\/comments?post=1741"}],"version-history":[{"count":1,"href":"https:\/\/www.bonesnap.com\/blog\/wp-json\/wp\/v2\/posts\/1741\/revisions"}],"predecessor-version":[{"id":1742,"href":"https:\/\/www.bonesnap.com\/blog\/wp-json\/wp\/v2\/posts\/1741\/revisions\/1742"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bonesnap.com\/blog\/wp-json\/wp\/v2\/media\/1522"}],"wp:attachment":[{"href":"https:\/\/www.bonesnap.com\/blog\/wp-json\/wp\/v2\/media?parent=1741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bonesnap.com\/blog\/wp-json\/wp\/v2\/categories?post=1741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bonesnap.com\/blog\/wp-json\/wp\/v2\/tags?post=1741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}