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
Hi,

>if I append a seventh field |ID to my spider output which >it
>leaves blank for SQL to autoassign and I rearrange and >trim the links.def file to this?
Yes that should be fine as the import script auto assigns the ID regardless.

>Does the field Related equate to FatherID in SQL?
>or can I leave this field blank?
You shouldn't have to worry about the FatherID because the import script is made to handle it, you just need to put the full category name for Name in the category file.

> Will SQL allow me to import those records?
You will not be able to import links without categories, it will cause errors. What I recommend then is if the link doesn't have a category, then have your spider put it in a default one.

Hope that helps,
Mel

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 10869 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