{"id":205,"date":"2007-04-17T09:48:14","date_gmt":"2007-04-17T09:48:14","guid":{"rendered":"http:\/\/conclave.open.ac.uk\/r.m.ferguson\/?p=205"},"modified":"2007-04-17T09:53:39","modified_gmt":"2007-04-17T09:53:39","slug":"more-data-archiving","status":"publish","type":"post","link":"https:\/\/www.open.ac.uk\/blogs\/r.m.ferguson\/?p=205","title":{"rendered":"More data archiving"},"content":{"rendered":"<p><span style=\"font-size: 11pt; color: windowtext; font-family: Verdana; mso-fareast-language: EN-GB\">I decided to put all the data into an Excel file, so that it would be easily sortable. Although FirstClass conferences can be copied and pasted, the contents pages cannot be, so I had to type in all these details. I have columns for:\u00a0<\/span><span style=\"font-size: 11pt; color: windowtext; font-family: Verdana; mso-fareast-language: EN-GB\"><\/p>\n<p \/><\/span><\/p>\n<ul type=\"disc\">\n<li class=\"MsoNormal\" style=\"margin: 0cm 0cm 5pt; color: windowtext; line-height: 14.4pt; text-align: left; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt\"><span style=\"font-size: 11pt; font-family: Verdana; mso-fareast-language: EN-GB\">post author\u00a0\n<p \/><\/span><\/li>\n<li class=\"MsoNormal\" style=\"margin: 0cm 0cm 5pt; color: windowtext; line-height: 14.4pt; text-align: left; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt\"><span style=\"font-size: 11pt; font-family: Verdana; mso-fareast-language: EN-GB\">date of post\u00a0\n<p \/><\/span><\/li>\n<li class=\"MsoNormal\" style=\"margin: 0cm 0cm 5pt; color: windowtext; line-height: 14.4pt; text-align: left; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt\"><span style=\"font-size: 11pt; font-family: Verdana; mso-fareast-language: EN-GB\">time of post\u00a0\n<p \/><\/span><\/li>\n<li class=\"MsoNormal\" style=\"margin: 0cm 0cm 5pt; color: windowtext; line-height: 14.4pt; text-align: left; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt\"><span style=\"font-size: 11pt; font-family: Verdana; mso-fareast-language: EN-GB\">title of post\u00a0\n<p \/><\/span><\/li>\n<li class=\"MsoNormal\" style=\"margin: 0cm 0cm 5pt; color: windowtext; line-height: 14.4pt; text-align: left; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt\"><span style=\"font-size: 11pt; font-family: Verdana; mso-fareast-language: EN-GB\">whether the post has an attachment\u00a0\n<p \/><\/span><\/li>\n<li class=\"MsoNormal\" style=\"margin: 0cm 0cm 5pt; color: windowtext; line-height: 14.4pt; text-align: left; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt\"><span style=\"font-size: 11pt; font-family: Verdana; mso-fareast-language: EN-GB\">which place in a thread the post appears (eg &#8216;Test&#8217; is in position 0, &#8216;Re: Test&#8217; is in position 1, &#8216;Re (2) Test&#8217; is in position 2 etc). This avoids a sort by title which ends up with all the Re&#8217;s clumped together\u00a0\n<p \/><\/span><\/li>\n<\/ul>\n<p><span style=\"font-size: 11pt; color: windowtext; font-family: Verdana; mso-fareast-language: EN-GB\">So far, so good. It&#8217;s time consuming, but it&#8217;s doable. However, I run into a problem when I come to paste in the text from each post. Excel interprets each return as a signal to move to a new cell. My organised table quickly becomes a terrible mess. There may be a way to get round this, but I&#8217;m not good enough at Excel to find it.\u00a0<\/span><span style=\"font-size: 11pt; color: windowtext; font-family: Verdana; mso-fareast-language: EN-GB\"> <\/span><span style=\"font-size: 11pt; color: windowtext; font-family: Verdana; mso-fareast-language: EN-GB\">I therefore paste it all into a Word table. It remains sortable and, if I work out a way to do it in Excel, it can all be pasted back in there. I shrink the other columns as far as possible, change all the text to 8pt, and view at 75%. I end up with 76 pages of very small type. By doing this I&#8217;ve lost the formatting &#8211; I don&#8217;t know which size the text was originally presented, but that doesn&#8217;t matter for my analysis and nobody appears to have used distinctive font sizes anyway.\u00a0<\/span><span style=\"font-size: 11pt; color: windowtext; font-family: Verdana; mso-fareast-language: EN-GB\"><\/p>\n<p \/><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 5pt; line-height: 14.4pt; text-align: left; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto\" align=\"left\"><span style=\"font-size: 11pt; color: windowtext; font-family: Verdana; mso-fareast-language: EN-GB\">There are more attachments than I expected. I download the Excel, Powerpoint and Word attachments into a folder and note at the bottom of the text field of my Word table which attachment goes with which post. My licence for SPSS has expired so I can&#8217;t currently download the three SPSS attachments.<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 5pt; line-height: 14.4pt; text-align: left; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto\" align=\"left\"><span style=\"font-size: 11pt; color: windowtext; font-family: Verdana; mso-fareast-language: EN-GB\">Now, how do I pick up the History information which tells me who has read or downloaded a posting and when they did that? Again, this can&#8217;t be cut and pasted. I try the idea of entering it manually in abbreviated form, but that&#8217;s a lot of work for very little return. I settle on opening the History of nine postings at a time, arranging them on my screen and taking a screen dump. It&#8217;s slow, but manageable.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I decided to put all the data into an Excel file, so that it would be easily sortable. Although FirstClass conferences can be copied and pasted, the contents pages cannot be, so I had to type in all these details. I have columns for:\u00a0 post author\u00a0 date of post\u00a0 time of post\u00a0 title of post\u00a0 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31,25],"tags":[],"class_list":["post-205","post","type-post","status-publish","format-standard","hentry","category-research-progress","category-things-to-remember"],"_links":{"self":[{"href":"https:\/\/www.open.ac.uk\/blogs\/r.m.ferguson\/index.php?rest_route=\/wp\/v2\/posts\/205","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.open.ac.uk\/blogs\/r.m.ferguson\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.open.ac.uk\/blogs\/r.m.ferguson\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.open.ac.uk\/blogs\/r.m.ferguson\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.open.ac.uk\/blogs\/r.m.ferguson\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=205"}],"version-history":[{"count":0,"href":"https:\/\/www.open.ac.uk\/blogs\/r.m.ferguson\/index.php?rest_route=\/wp\/v2\/posts\/205\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.open.ac.uk\/blogs\/r.m.ferguson\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.open.ac.uk\/blogs\/r.m.ferguson\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=205"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.open.ac.uk\/blogs\/r.m.ferguson\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}