Paul:
I'm still looking for a way to this same thing. I have tried the import utilities under Admin/Database/Links Properties as well as in MySQLMan. Both work but both only allow you to import to one table at a time. I want to import a pipe delimited ASCII file that has a category definition in it as well. The present format is URL|TITLE|DESCRIPTION|KEYWORDS|CATEGORY|EMAIL. I can import the first four fields to the Links table just by swapping the field order on import, no problem. But Category at the same time? that's another story.
I looked at the admin frame to add new links and I see it calls db.cgi?do=add_record&db=Links&URL=http... etc. using an input select field name of CatLinks.CategoryID=n. I'm guessing that what I need is a way to add the links in the delimited ASCII using db.cgi? Does that sound right to you? Why isn't there an easier way to do this?
Mark Brasche
http://SurfSafely.com/
I'm still looking for a way to this same thing. I have tried the import utilities under Admin/Database/Links Properties as well as in MySQLMan. Both work but both only allow you to import to one table at a time. I want to import a pipe delimited ASCII file that has a category definition in it as well. The present format is URL|TITLE|DESCRIPTION|KEYWORDS|CATEGORY|EMAIL. I can import the first four fields to the Links table just by swapping the field order on import, no problem. But Category at the same time? that's another story.
I looked at the admin frame to add new links and I see it calls db.cgi?do=add_record&db=Links&URL=http... etc. using an input select field name of CatLinks.CategoryID=n. I'm guessing that what I need is a way to add the links in the delimited ASCII using db.cgi? Does that sound right to you? Why isn't there an easier way to do this?
Mark Brasche
http://SurfSafely.com/