Gossamer Forum
Home : Products : Gossamer Forum : Pre Sales :

importing/converting

Quote Reply
importing/converting
I am currently running a SNITZ forum on a access database. How do i import/convert the information for use with gossamer forum?

Convert access to sql? Then what?



Thanks,

bob
Quote Reply
Re: [bob c3] importing/converting In reply to
Hi,

It would have to be a custom project. Currently we support imports directly from Ikonboard, UBB5/6, WWWBoard and WWWThreads. If you can get your forum into one of those formats, we can import, otherwise we'll need to do it as a custom project.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] importing/converting In reply to
Thanks Alex, i will look into converting to a version you support.

The forum does not have that many posts to deal with. It is new. I could probably recreate post by post in a couple hours, but what about the user data? If i convert the database to MySql would it be a fairly small job to do the rest?



Bob
Quote Reply
Re: [Alex] importing/converting In reply to
I apologize for dredging up an old thread, but do you have a pointer to the wwwBoard import script? I can't find it anywhere.

thanks!
Quote Reply
Re: [tfinney] importing/converting In reply to
Hi,

If you run import.pl in the admin/tools/ directory, it will tell you how to import from WWWBoard into Gossamer Forum.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] importing/converting In reply to
Thanks, Alex.

I've run the script, and it's failing silently.

[tfinney tools]$ ./import.pl --append-data --add-bad-email --forum-id=2 --debug --logfile=/www/logs/gforum_import.log --type=WWWBoard --source=/www/htdocs/wwwboard/water/
Reading import configuration... done!
Importing User table data... done!
Importing Category table data... done!
Importing Forum table data... done!
Importing Grouping table data... done!
Importing ForumGroup table data... done!
Importing UserNew table data... done!
Importing ForumModerator table data... done!
Importing Post table data... done!
Importing PostAttachment table data... done!
Importing ForumSubscriber table data... done!
Importing Message table data... done!
Importing MessageAttachment table data... done!
Importing UserGroup table data... done!
Importing EditLog table data... done!

Import completed successfully.

I had to tweak the regular expressions in Import::WWWBoard to get the fields to populate, but that's not rocket science (famous last words, eh?). Looking at the database, I see that the posts are being inserted into gforum_Posts. However, none of them are shown on the forum's index page.

If you have any insight regarding where to start with this, I'd appreciate it.