Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Exporting Links

Quote Reply
Exporting Links
Hello,
is it possible to export only links of one category and its subcategories? How does it work?
Thanks in advance for your help.
Regards,
Wolfgang
Quote Reply
Re: Exporting Links In reply to
Right now there is no feature to do that.

You'd have to build the category hierarchy, then dump all links that matched any of the category IDs.

This would have to be a program, not a simple command.

Quote Reply
Re: Exporting Links In reply to
The power of SQL constantly amazes me!

Quote Reply
Re: Exporting Links In reply to
You could use the SQL Monitor:

SELECT Links.*
INTO OUTFILE '/full/path/to/file'
FROM Links, Cateogry
WHERE Links.CategoryID = Category.ID AND
Category.Name LIKE 'MyCategory%'

Where MyCategory is the category you want to export.

Cheers,

Alex
Quote Reply
Re: Exporting Links In reply to
And error 13 is:

Quote:
hits:/usr/home/gossamer-threads$ perror 13
Permission denied
hits:/usr/home/gossamer-threads$

So you probably didn't have permission to write to where you wanted the file stored. Mysql can run as root or as user 'mysql', and it may not be able to create files where you wanted.

Cheers,

Alex
Quote Reply
Re: Exporting Links In reply to
Hi Alex,
thanks for your reply. With the SQL Monitor it works only like this:

SELECT Links.*
FROM Links, Category
WHERE Links.CategoryID = Category.ID AND
Category.Name LIKE 'MYCATEGORY'

and then select in the box an output file. This has to be an existing file.
The other commands were producing on our site an errorcode 13.
Best Regards and Thanks again,
Wolfgang

Quote Reply
Re: [i01] Exporting Links In reply to
With LinksSQL 2.1.0 doesn't work!

How I can make it?

The problem are the new 'catlinks' table Frown

Thank you in advance!

-----------------------
Nomada