Go back to previous page
Forum URL: http://www.dombom.com/cgi-bin/dcforum/dcboard.cgi
Forum Name: FatBomb
Topic ID: 11
#0, "Readjusting" Databases for FatBomb
Posted by Kurt on May-12-04 at 05:13 PM
FatBomb lets you use a variety of resources as content. If you have links, chances are they are easy to incorporate into a FatBomb search.

You just need to get them into the proper format.

Here's two tools that will convert databases into a format FatBomb can use:

Here's a script you install on a server to convert data files:

http://www.smarterscripts.com/dbc/

And OpenOffice has a free SpreadSheet program than can manipulate "tables" as well:

http://www.openoffice.org

I haven't used either, but both should do the trick, depending on your own data files...

FatBomb works very well with Tasari's TazBomb so you can include ALL your own links in the SERPs.

Also, Jeff Hope's soon-to-come AtlasBomb includes a powerful "sitemapper" that will build links to all your domain's pages.

You can even have a second (third) install of FatBomb JUST for your own domain(s) links, working as a "site search".

FatBomb is really verstile and can be easily adapted to perfrom a number of "duties".


#1, RE: "Readjusting" Databases for FatBomb
Posted by totenmaske on May-21-04 at 01:56 PM
In response to message #0
Hi All,

Just for 'flavor' I thought I would run down my process for converting files to FatBomb compatible format for Excel users.

1)Import the XLS, CSV, or TXT file into MS Excel.

2)Delete any non-relevant fields from the pheed and/or manipulate the existing fields into something more usable (for instance if the only "usable" fields are LinkURL and TITLE then you can use the CONCATENATE function in Excel to create a usable description field - I can cover this more in depth later if need be as it requires a few extra steps and NotePad Lite to work.

3)Re-arrange the fields into the proper order (LinkURL, TITLE, DESC (I think)).

4)Use a custom MS Excel Macro to export the data as Pipe Delimited. (I downloaded the Macro for free from somewhere...I'll see if I can find the file)

5)You're Done!

It looks harder than it actually is...as this is the process I used to convert the three custom databases that I am currently using on GothSeek.com.

----------------------
Stanley aka Totenmaske

Affiliate-Blog.com
Cherry Bomb XML List
GothSeek.com - the Gothic Search Engine - Powered by FatBomb!


#2, RE: "Readjusting" Databases for FatBomb
Posted by totenmaske on Jun-01-04 at 06:50 AM
In response to message #1
I've had some emails requesting the Excel Macro...

------------------------ Macro -----------------------

Sub ExportDB()

' This macro saves the active worksheet to a pipe-delimited flat file at c:data.txt

Dim SrcRg As Range

Dim CurrRow As Range

Dim CurrCell As Range

Dim CurrTextStr As String

Dim ListSep As String

Dim DataTextStr As String

ListSep = "|"

Set SrcRg = ActiveSheet.UsedRange

Open "C:data.txt" For Output As #1

For Each CurrRow In SrcRg.Rows

CurrTextStr = ""

For Each CurrCell In CurrRow.Cells

CurrTextStr = CurrTextStr & CurrCell.Value & ListSep

Next

While Right(CurrTextStr, 1) = ListSep

CurrTextStr = Left(CurrTextStr, Len(CurrTextStr) - 1)

Wend

'Added next line to put | at end of each line

CurrTextStr = CurrTextStr & ListSep

Print #1, CurrTextStr

Next

Close #1

End Sub

------------------------ Macro -----------------------


----------------------
Stanley aka Totenmaske

Affiliate-Blog.com
My FatBomb Feeds
Cherry Bomb XML List
GothSeek.com - the Gothic Search Engine - Powered by FatBomb!


#3, RE: "Readjusting" Databases for FatBomb
Posted by totenmaske on Jun-12-04 at 09:03 AM
In response to message #2
I've had some emails requesting additional information about the Excel macro I posted.

Here is the URL for the site where I got the macro:
http://www.web-bazaar.com/cgi/manuals/dbdoc_add_items.html

...happy bombing!

----------------------
Stanley aka Totenmaske

Affiliate-Blog.com
My FatBomb Feeds
Cherry Bomb XML List
GothSeek.com - the Gothic Search Engine - Powered by FatBomb!


#4, RE: "Readjusting" Databases for FatBomb
Posted by rob on Jul-21-04 at 12:04 PM
In response to message #3
Thanks very much, Stanley,

>> if the only "usable" fields are LinkURL and TITLE then you can use the CONCATENATE function in Excel to create a usable description field - I can cover this more in depth later if need be as it requires a few extra steps and NotePad Lite to work.


Could you please tell us more about how to use the CONCATENATE function in Excel to create a usable description field?

Thank you again.

Rob