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:
- post author
- date of post
- time of post
- title of post
- whether the post has an attachment
- which place in a thread the post appears (eg ‘Test’ is in position 0, ‘Re: Test’ is in position 1, ‘Re (2) Test’ is in position 2 etc). This avoids a sort by title which ends up with all the Re’s clumped together
So far, so good. It’s time consuming, but it’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’m not good enough at Excel to find it. 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’ve lost the formatting – I don’t know which size the text was originally presented, but that doesn’t matter for my analysis and nobody appears to have used distinctive font sizes anyway.
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’t currently download the three SPSS attachments.
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’t be cut and pasted. I try the idea of entering it manually in abbreviated form, but that’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’s slow, but manageable.