Author Topic: Merging four blogs in one  (Read 6834 times)

Offline Wayfarer

  • Bonfire
  • ***
  • Posts: 100
  • Karma: +0/-0
    • La Bitacora del Caminante
Merging four blogs in one
« on: February 17, 2011, 10:43:30 PM »
Hello. I'm re-organizing my blog. I currently have a main blog with three sub-blogs, in three subfolders of the main folder. Back in 2005 it had sense to make it that way... but now I wish to merge all the sub-blogs with the main blog. I know I can manually copy all posts in the sub-blogs as posts in the main blog, one by one... but that would take a lot of time.

I suspect that all the posts in the DB have a unique ID regardless of the blog they belong to, and also that posts are retrieved for each blog using a 'Blog ID' field. Am I right? Then, there should be easy to move all the posts at once to the main blog just by accesing the database table and changing the 'Blog ID' to the one that identifies the main blog, right?

If so, the question is: which tool (or tools) can I use to access the Blog database directly?

Thanks in advance and best regards,

-- Wayfarer

PS. As always, Blog (with initial uppercase) = the program / blog (all lowercase) = the web log. ;-)
My website: www.thewayfarer.info
My search site: www.cannotbefound.com
My music: www.amadian.com

Offline Fahim

  • Administrator
  • Inferno
  • *****
  • Posts: 663
  • Karma: +4/-0
    • http://www.farook.org
Re: Merging four blogs in one
« Reply #1 on: February 18, 2011, 07:34:39 AM »
Hey :) Unfortunately, I haven't used Blog in a long time and it's been even longer since I did any coding work on it. So I don't remember how it was set up. What you say sounds logical and I hope that's the way I did it but I can't be absolutely certain. To make things worse, I'm on a Mac now and so don't have a Windows machine with the proper tools to even go back and check quickly :)

But if you want to go through the DB and check, the DB software came from ElevateSoft. I'm not using their newer ElevateDB. Rather, what I used was the DBISAM database. The DBISAM info is here:

http://www.elevatesoft.com/products?category=dbisam&type=delphibcb

I believe they had a set of free tools to access DBISAM databases but I can't seem to find the download on the site. Perhaps you need to register to download since the whole download area requires a login. Only thing is, I don't remember my login either and so you probably would need to create your own login and see if the tools are still available for download.

Hope this helps.

Offline Wayfarer

  • Bonfire
  • ***
  • Posts: 100
  • Karma: +0/-0
    • La Bitacora del Caminante
Re: Merging four blogs in one
« Reply #2 on: February 18, 2011, 08:30:58 AM »
I guess this is going to be complicated...

So I'm the very last user of Blog, I guess :-P

-- Wayfarer
My website: www.thewayfarer.info
My search site: www.cannotbefound.com
My music: www.amadian.com

Offline Fahim

  • Administrator
  • Inferno
  • *****
  • Posts: 663
  • Karma: +4/-0
    • http://www.farook.org
Re: Merging four blogs in one
« Reply #3 on: February 18, 2011, 08:31:55 AM »
There's one more user that I know of but he's a programmer and so he's been figuring out stuff as he goes :)

Offline Wayfarer

  • Bonfire
  • ***
  • Posts: 100
  • Karma: +0/-0
    • La Bitacora del Caminante
Re: Merging four blogs in one
« Reply #4 on: February 18, 2011, 09:14:41 AM »
Maybe it'd be a good idea to release the source code through Sourceforge, Freshmeat or a similar site ;-)

By the way,  I was right about the BlogID topic. :-) I've found a tool that lets me make changes directly in the tables: EMS DBISAM Manager. It's also obsolete and there's not even mention of it in the current EMC website, but it's still on their FTP server and works fine. I still have to do the change register by register, but it's a lot less job than doing it manually by reposting ;-)

Regards,

-- Wayfarer
My website: www.thewayfarer.info
My search site: www.cannotbefound.com
My music: www.amadian.com

Offline Fahim

  • Administrator
  • Inferno
  • *****
  • Posts: 663
  • Karma: +4/-0
    • http://www.farook.org
Re: Merging four blogs in one
« Reply #5 on: February 18, 2011, 07:53:02 PM »
If the tool supports SQL queries (and you know SQL) you should be able to do the changes via an SQL statement instead of changing the records one by one :)

Offline Midnight_Programmer

  • No flame
  • *
  • Posts: 5
  • Karma: +0/-0
    • http://www.petersplace.org.uk
Re: Merging four blogs in one
« Reply #6 on: August 27, 2011, 10:52:52 PM »
Hi Wayfarer,

Just checking, the link to the ftp site no longer seems to be active.  Is the name of the file you downloaded something like 425dbisamdd.exe?  Only I've got this program amongst my various Blog files & directories, & can't remember what it was for.

The reason I'm asking is that I may be using Blog for a project I have in mind, & I'm just checking before I start, that I have all the tools & info I might need :)

Offline Fahim

  • Administrator
  • Inferno
  • *****
  • Posts: 663
  • Karma: +4/-0
    • http://www.farook.org
Re: Merging four blogs in one
« Reply #7 on: August 28, 2011, 06:08:48 AM »
That's definitely one of the DBISAM installers but I can't tell from looking at the file name whehter it's the installer for the DBISAM Delphi components or the tools - there are two separate downloads for those two. What you can do is to start the installer because there are several steps before the actual installation and before you get to that, the dialog should tell you which one it is.

Offline Midnight_Programmer

  • No flame
  • *
  • Posts: 5
  • Karma: +0/-0
    • http://www.petersplace.org.uk
Re: Merging four blogs in one
« Reply #8 on: September 06, 2011, 12:52:14 AM »
Just to let you know, as you suggested I ran the installer & monitored the messages.  I got one that said "....The enclosed software is provided as a supplement to the base DBISAM product.  It includes several utilities for interactively working with DBISAM databases and also includes their source code as a sample of how to use the DBISAM product.  If you have any problems at all while using the software or encounter a bug and need further information, please contact our support staff at....",  so it looks like it's the package that can be used to manipulate the database! :)