[Coco] CoCo Forums up to 2007

Lothan lothan at newsguy.com
Mon Sep 7 14:50:08 EDT 2009


If you send me the SQL file, I'll see what I can do with it and may even be 
able to get SQL to generate an XML schema on its own.

--------------------------------------------------
From: "Roger Taylor" <operator at coco3.com>
Sent: Monday, September 07, 2009 12:33 AM
To: "CoCoList for Color Computer Enthusiasts" <coco at maltedmedia.com>
Subject: [Coco] CoCo Forums up to 2007

> Sort of good news, I've recovered the content of the original coco3.com 
> forums just before it was taken offline.  Not the current forums, but the 
> first system that gathered thousands of valuable messages over the years.
>
> I've trimmed down the SQL file to just the Forum names, Topics, and Posts. 
> These are relational entries where posts contain their Topic ID, author, 
> etc. and Topics contain their Forum ID, author, etc.  So it's impossible 
> to sort it by naked eye.  Instead, I'm hoping to write a Visual Basic .NET 
> program that crunches the data into maybe an XML type file that can 
> further be used to import the content into the new coco3.com blog system 
> as Posts/Comments retaining the author references only, but not physically 
> linked to any certain members of coco3.com at this time.  Somewhere in the 
> posts will probably be a line mentioning the author's nickname at the time 
> of the preserved text, or perhaps their real name.
>
> I can e-mail anyone the SQL file if they think they can process it quicker 
> or better than I can into some text file format that's decently sorted 
> into Forum->Topic->Posts order:
>
> The 2nd project will be to of course convert the current forums into blog 
> posts/comments so everything comes together into one new system and 
> format, to be preserved for much longer.....
>
> -- 
> Roger Taylor
>
> http://www.americafedup.com
>
>
> --
> Coco mailing list
> Coco at maltedmedia.com
> http://five.pairlist.net/mailman/listinfo/coco
> 



More information about the Coco mailing list