Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Import from Links2.0 to Links SQL

Quote Reply
Import from Links2.0 to Links SQL
Anyone knows how to import into Links SQL from Links2.0?
The files from Links2.0 are:
links.db, linksid.txt, categories.db, categoryid.txt, email.db, validate.db
But Database, import/export in Admin requires links.def and category.def

What is the correct date format for the import? Is it 02-August-2003 ? or something else?

Desperately need help....
Quote Reply
Re: [ccjong] Import from Links2.0 to Links SQL In reply to
Hi!

The *.db files are the database files in which you need to have the entries. The *.defs files are the definition files with the help of it then connects to the *.db files and ontains field property informations.

In the Admin of the Links SQL you only need to enter the Location of those def files and the import will do the rest. Mind you, the location of the def files needs to be relative, like /www/home/mysite/links/admin/defs (with no trailing slash / at the end!!!). The directory defs contain all the def files. Once it has found those files, it will get all what it needs and start importing. You need to have patience. This area has been really designed stmart.

You can choose different options out there like delete during the import, etc. Try and play with the import. It will not destroy anything, especially not the old *.db files!

To make sure what exactly it should be in the *.db files, the best would be to go in the admin of Links 2.0 and create entries or links in respective categories and see what is written in the *.db files. This will explain what format of the date is required.

Ask me if you need help.
Quote Reply
Re: [ccjong] Import from Links2.0 to Links SQL In reply to
You are on Windows server. You the relative path should be like that in windows (like c:\mysite\links\admin\defs) and not in unix the way I mentioned. It simply needs to find it locally and not through web URL. What it should not be is a URL.