Gossamer Forum
Home : Products : Gossamer Links : Discussions :

problem with data import form links2 - have extra fields

Quote Reply
problem with data import form links2 - have extra fields
I have the latest version 3.+ and I am trying to import data from links2 - I have a total of 54 fields in links2.

Do I need to take any extra measures to import data with extra fields? I think I read somewhere that the first line of my links.db should define all fields by their name - is it ture?

Basically I am getting error for links.def field #16 (State) - so it skips #16 and except for that goes on to create all the remaining fields in SQL table but "does not import any links". All categories are imported ok (I think) but no links.

Importing Links ... Import error: WARNING: Unable to insert link `VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'): Unknown column 'State' in 'field list'


Here are some of my additional fields in links2.
Address => [14, 'alpha', 35, 75, 0,'', ''],
City => [15, 'alpha', 20, 30, 0,'', ''],
State => [16, 'alpha', 5, 20, 1,'', ''],
ZIP => [17, 'alpha', 10, 10, 0,'', ''],
Phone => [18, 'alpha', 15, 20, 1,'', ''],

and so on..

Any suggestions?
Thanks