Site Links
Pricing & Order
Members Area
Support Options
Who's Online Now
4 registered members (TheBrit, Zarzal, Yarpâ„¢, Gizmo), 85 guests, and 235 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
So. California
Posts: 472
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
isaac 18
Gizmo 16
Zarzal 12
TheBrit 10
SteveS 8
Ruben 4
jorb 4
Latest Photos
Testing to drag photos
Comfortable Cats
BSA photos
Previous Thread
Next Thread
Print Thread
Importing Really Old Flat File Stuff #234331
01/31/10 07:45 PM
01/31/10 07:45 PM
whk  Offline OP
Joined: Jan 2009
Posts: 91
Portsmouth, RI
We have a forum that was upgraded in 2007 from UBB 5.44b, and incrementally upgraded to that we are running now. The conversion went very well, and over time I've actually been able to change some of the old anonymous posts to the real user that posted them (before we required registration to post).

Prior to running UBB 5.44b, we used a forum hosted on the International Sailing Federation website in 1999 and 2000. We have the files for the postings. They are all in html in a single directory. Here is a link to the "top level". If you drill down you'll see a tiered forum hirearchy. Just don't click on the ISAF Sailing Forums link, because it no longer exists.

So my question - Does anyone know of a way to import these posts into the existing UBB forum so it preserves the post, dates, titles and post names? If I have to bring them into a single forum, then use moderator privileges to move them, that's ok.

Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: Importing Really Old Flat File Stuff [Re: whk] #234333
01/31/10 10:05 PM
01/31/10 10:05 PM
SD  Offline
Former Developer
Joined: Apr 2007
Posts: 4,313
SoCal, USA
would prolly need to write an importer.. not a major job, but a 'generic' importer doesn't exist..

things like usernames would have to assume there was some sort of mapping to existing users or maybe used an anon user, who posted with a name instead..

would really be just what a site scraper would do, recursively calling from the top level and working down the layers..

maybe some rules for destination forums would also be added..

nice thing is that it is only topics/posts.. not a full blown import.. so ubbt_POSTS and ubbt_TOPICS would bear the brunt.. to a lesser degree, ubbt_FORUMS (post counts, if applicable) and ubbt_USERS (once again post counts, if applicable).. then you could use the cpanel content rebuilder to do the rest of the clean up..

can be done, but it's custom work.. smile

Re: Importing Really Old Flat File Stuff [Re: SD] #234348
02/01/10 03:48 PM
02/01/10 03:48 PM
Ruben  Offline

Joined: Dec 2003
Posts: 5,952
What would be really slick is to add to the stock code to allow us to merge or split a ubb board. Going both ways.

So you could have a old board and a second new board.Merge the old board into a existing new board like this topic is about. Or instead of pruning topics allow us to export the selected topics to a separate UBB board.

Cat does the Meow!

Blue Man Group

There is no such thing as stupid questions. Just stupid answers
Re: Importing Really Old Flat File Stuff [Re: Ruben] #234349
02/01/10 03:53 PM
02/01/10 03:53 PM
SD  Offline
Former Developer
Joined: Apr 2007
Posts: 4,313
SoCal, USA

i've already added 'arcive topics' on a board an instead of pruning (prune is STILL allowed).. it just moves the ubbt_POSTS stuff to ubbt_POSTS_ARCHIVE and then sets the TOPIC_STATUS to 'A' (can't remember the exact field name)..

then really a small mod to showflat, postlist, search and allows for them to exist and be displayed normally, but they don't affect the 95% daily operations..

this takes the load of running the board WAY down and also makes showflat and post list scream like a new board does wink

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Speaking of Http to https, complaints from user
by PianoWorld. 12/16/18 03:40 PM
update multilanguage site problem
by Zarzal. 12/15/18 04:20 PM
Char coding utf-8 and older forums
by Zarzal. 12/15/18 03:59 PM
table issue
by TheBrit. 12/13/18 06:05 PM
testing table layout
by TheBrit. 12/13/18 11:16 AM
Forum Statistics
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2