Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Help - Data Import From a Flat File

Quote Reply
Help - Data Import From a Flat File
This has probably been covered somewhere on the forum, but I'm having difficulty locating the answer to these questions ...

I would like to import flat files to flesh out catagories and links. I know how to use SQLMan to bring the data into the individual tables (Links and Catagories) in my database, but I don't know how to get the data to be relational between tables. I want LinksSQL to respond to the new data as if it were input via the interface for creating new catagories and new links from LinksSQL.

Is there something that I'm overlooking inside of LinksSQL that makes this import procedure a snap? I can only imagine that there is, but I'm not seeing it.

Can someone give me a nudge in the right direction here?

Last edited by:

wilbur: Mar 2, 2002, 11:20 PM
Quote Reply
Re: [wilbur] Help - Data Import From a Flat File In reply to
I've got it now -- at least, most of it. It'll just take some Excel work to get the data right for the two imports into Categories and Links.

There is one thing though, does CatLinks take care of itself? If so, is there something that I need to do inside of LinksSQL to update that table information?