Gossamer Forum
Home : Products : Gossamer Links : Pre Sales :

Re: Yet Another Links to Links SQL Question...

Quote Reply
Re: Yet Another Links to Links SQL Question... In reply to
>> Also, is there a way to do batch uploads into Links SQL from either
>> an Access DB, Excel Spreadsheet, or one of these exported to .txt?

right now, no. Alex said he improved the import, maybe this has been added.

The "no" is only relative. You _can_ import anything from text files into Links, the problem is category placement.

I've worked out a system that I mark the highest current ID in the Links database, import my new links, (one category at a time) then insert the ID into the CatLinks table with the LinkID:CategoryID I want to have.

insert into catlinks (CategoryID,LinkID)
Select 123,ID from Links
where Links.ID > 'number_recorded_above'

where 123 is the category you want to place them into.

So it can be done, just not in one shot. It should be fairly easy to have GT add, but there is so much to do, who knows if and when.


PUGDOGŪ Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Forum:http://LinkSQL.com/forum
Subject Author Views Date
Thread Yet Another Links to Links SQL Question... ATKOgirl 3146 May 1, 2001, 6:51 AM
Post Re: Yet Another Links to Links SQL Question...
Stealth 3076 May 1, 2001, 7:16 AM
Post Re: Yet Another Links to Links SQL Question...
pugdog 3080 May 1, 2001, 10:13 AM