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

database question

Quote Reply
database question
Hi,

My client has an Access database with the following structure:
- name
- (some data like street, phone, etc...)
- url

Besides, its thread structured, with subcategories and stuff.

Does LinksSQL import this data?

Thanks
Diego

Quote Reply
Re: database question In reply to
I would move around the columns...and add additional columns in the Access table/relation to MATCH the default structure of the LINKS table.

Then export the table as a tab delimited text file.

Then you can import the data via MySQLMan.

Regards,

Eliot Lee
Quote Reply
Re: database question In reply to
Thanks!
can you send me the structure used in LinksSql?

regards,
Diego


Quote Reply
Re: database question In reply to
Nope...why don't you BUY a license and install it??? You will see what the structure is!

Regards,

Eliot Lee
Quote Reply
Re: database question In reply to
Eliot,
I just wanted to know how much work will it take me to convert the database I have to the one used in LinksSQL.
The title in this forum is "Links SQL Pre Sales", and i believe its for posting questions before i BUY it! :)

Thanks anyway,
Diego


Quote Reply
Re: database question In reply to
Yea...but it is not for asking things like "What is structure? Can you give it to me???" That is knowledge only licensed users should know about! Would you like me to post codes also from the LINKS SQL scripts??? Because I betcha that was going to be your next question.

Anyway, depending on how your other "database" is structured (if it is truly relational or not), you should not have a problem importing individual tables from an Access database into MySQL. But the structure in terms of columns between Access and MySQL tables must match in order for the import process to work sucessfully.

Regards,

Eliot Lee
Quote Reply
Re: database question In reply to
Hi,

You can see the structure online at:

http://www.gossamer-threads.com/..._guide_links_db.html

Username admin, pass admin.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: database question In reply to
The link to the structure GIF is dead (02-Sep-2001, 09:00 EST).

Quote Reply
Re: database question In reply to
Quote Reply
Re: database question In reply to
Hi,

Should be fixed now, sorry about that.

Cheers,

Alex

--
Gossamer Threads Inc.