#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