Im not exactly sure this will work but how about making a cgi script to format it.....
open(FILE,"data.txt") || die "Can't open file:$!";
@data=<FILE>;
close(FILE);
($title,$url,$desc,$contactname,$contactemail)=split(/\n/,@data);
open(FILE,"links.db") || die "Can't open file:$!";
print FILE "$title|$url|$desc|$contactname|$contactemail\n";
close(FILE);
You need to add the delimiter for the additional fields at the end and the ID at the beginning.
(the txt file would need to be in that format with the title followed by url followed by description etc........)
This is by no means guaranteed to work and backup everything IF you try it....Im sure others will give some better ideas.
If you have 5000 then I think you are in trouble because from what you've shown, it doesnt seem like the txt file has all the necessary fields such as ID, Date, Contact Name etc.......you you will have to manually add them.....I wouldnt recommend trying to import data from other search directories that dont have the same structure as links.
Paul Wilson.
new -
http://www.wiredon.net