On Sun, 2002-06-09 at 05:44, Matt McLeod wrote:
> I figure it's probably going to be a case of extracting the data
> from Squish (which can apparently export to XML, at least according
> to my friends), and then writing something in perl to parse that,
> then using the Slash modules to insert the content into the database.
Yes, that's exactly what I did for a site moving from plain HTML files
to Slash. Ofcourse, it was someway simpler because the stories had no
I first wrote a perl parser to select important info from the HTML files
and put them in a simple XML style (I took the date from file's
modification time, separated first paragraph to be used as intro, etc.)
and then another script to use Slash's APIs to put those files into the
database. In the meantime, it also created users as authors from
articles' authors. It was not perfect, but good enough to kickstart the
> Either way, does anyone have any pointers on where in Slash
> to start looking? Or would I be better off getting my head
> around the schema and just pumping data directly into mysql?
I recommend you to use the Slash APIs: they are described in the book,
or you can have a look at admin.pl and comments.pl to see how a new
story/comment gets into the db - there are some details you are likely
to oversee if you pump info into the database.
I can forward you my (ugly!) scripts if you feel you need them.
Alessio F. Bragadini alessio@...
APL Financial Services http://village.albourne.com
Nicosia, Cyprus phone: +357-22-755750
"It is more complicated than you think"
-- The Eighth Networking Truth from RFC 1925