Go back to previous page
Forum URL: http://www.dombom.com/cgi-bin/dcforum/dcboard.cgi
Forum Name: FatBomb
Topic ID: 11
Message ID: 1
#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!