The FatBomb Forum is no longer active. Use it for reference only.
For active discussions of Fatbomb, please visit:
The MadBomber Forum

Also see:
FatBomb ReadMe  :-:     :-:
  Newbie Install Guide

Subject: ""Readjusting" Databases for FatBomb"   Previous Topic | Next Topic
Printer-friendly copy    
Conferences FatBomb Topic #11
Reading page 1 of 1 pages
Kurtadmin click here to view user rating
Member since Dec-5-02
8831 posts, 5 feedbacks, 8 points
May-12-04, 05:13 PM (PST)
Click to EMail Kurt Click to send private message to Kurt Click to view user profileClick to add this user to your buddy list  
""Readjusting" Databases for FatBomb"
 
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".


-Boom boom boom boom.


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote
totenmaske
Member since Jul-26-03
573 posts, Rate this user
May-21-04, 01:56 PM (PST)
Click to EMail totenmaske Click to send private message to totenmaske Click to view user profileClick to add this user to your buddy list  
1. "RE: "Readjusting" Databases for FatBomb"
 
   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!


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote
totenmaske
Member since Jul-26-03
573 posts, Rate this user
Jun-01-04, 06:50 AM (PST)
Click to EMail totenmaske Click to send private message to totenmaske Click to view user profileClick to add this user to your buddy list  
2. "RE: "Readjusting" Databases for FatBomb"
 
   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!


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote
totenmaske
Member since Jul-26-03
573 posts, Rate this user
Jun-12-04, 09:03 AM (PST)
Click to EMail totenmaske Click to send private message to totenmaske Click to view user profileClick to add this user to your buddy list  
3. "RE: "Readjusting" Databases for FatBomb"
 
   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!


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote
rob
Member since May-12-03
99 posts, Rate this user
Jul-21-04, 12:04 PM (PST)
Click to EMail rob Click to send private message to rob Click to add this user to your buddy list  
4. "RE: "Readjusting" Databases for FatBomb"
 
   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


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote


Conferences | Topics | Previous Topic | Next Topic
Rate this topic Rate this topic