Gossamer Forum
Home : Gossamer Threads Inc. : Custom Modification Jobs :

Re: *LinksSQL 2* How much to convert my text db>MySQL?

Quote Reply
Re: *LinksSQL 2* How much to convert my text db>MySQL? In reply to
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/
Subject Author Views Date
Thread *LinksSQL 2* How much to convert my text db>MySQL? HomerUSA 11193 Mar 26, 2001, 1:32 AM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
Paul 10986 Mar 26, 2001, 4:10 AM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
HomerUSA 10999 Mar 26, 2001, 5:03 AM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
Paul 10979 Mar 26, 2001, 5:07 AM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
HomerUSA 10897 Mar 26, 2001, 5:23 AM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
Paul 10912 Mar 26, 2001, 5:29 AM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
surfsafely 10870 Apr 8, 2001, 4:56 PM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
Mel_g 10901 Apr 12, 2001, 12:19 PM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
surfsafely 10778 Apr 12, 2001, 1:34 PM
Post Re: *LinksSQL 2* How much to convert my text db>MySQL?
Stealth 10763 Apr 12, 2001, 2:08 PM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
Mel_g 10821 Apr 12, 2001, 4:12 PM
Post Re: *LinksSQL 2* How much to convert my text db>MySQL?
surfsafely 10746 Apr 12, 2001, 4:27 PM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
surfsafely 10811 Apr 12, 2001, 6:07 PM
Post Re: *LinksSQL 2* How much to convert my text db>MySQL?
surfsafely 10669 Apr 14, 2001, 5:51 PM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
Mel_g 10700 Apr 17, 2001, 8:59 AM
Post Re: *LinksSQL 2* How much to convert my text db>MySQL?
surfsafely 10678 Apr 17, 2001, 12:17 PM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
surfsafely 10667 Apr 17, 2001, 1:26 PM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
Alex 10700 Apr 18, 2001, 3:39 PM
Post Re: *LinksSQL 2* How much to convert my text db>MySQL?
surfsafely 10589 Apr 18, 2001, 4:57 PM
Post Re: *LinksSQL 2* How much to convert my text db>MySQL?
surfsafely 10560 Apr 18, 2001, 9:07 PM