- Open the relevant FirstClass conference. Right-clicking on the column names in grey allows you to choose which columns will be displayed. Choose Attachments, Name, Last Modified, Kind, Subject. (Kind is just in there to aid the sorting process). Sort by Name by left-clicking on the grey Name column heading. Drag the columns into order.
- In the main Snag-It window, set up a profile with the settings Input=Auto scroll window, Output=File, Effects = Space Formatted. (To do this, change the profile settings at the bottom of the screen, then press the big plus sign near the top right of the screen.)
- Click Capture, and Snag-It will scroll down and pickup the entire window. This takes a couple of minutes. Then save it as a text file.
- Copy all and paste into a Word document. Find and replace the double line spaces and the thousands of double spaces.
- Now set it up to be converted to a table using commas to separate the columns. First, remove all the commas which are already there. Find and replace them with an obvious string such as %%%.
- Take each author’s name. Find and replace the name with a comma after it. Use their full name rather than just their first name, otherwise you’ll run into problems when a name has been included in a subject line.
- Convert the year of posting to the year followed by a comma. Replace the word in the Kind column with a comma, thus putting a division after all the times.
- Go to the Table tab, and convert text to table, choosing the comma to sort the columns.
- Replace the commas which were in the text originally, by replacing all the %%% with commas.
- Paste into Excel, sort by the title column. Replace the numbered Re’s eg Re(2) becomes 2. Replace the remaining Re’s with 1 and put 0 by all other entries. Delete bracketed numbers (1) and then Re:
- Add a column and manually note which postings have attachments.
- Now for the laborious bit. Put it all back into Word ,on a landschape page in a small font. Add two columns and manually paste in all entries and the posting history.
How to archive FirstClass conferences
Leave a reply