That would be a bit complicated since the Category IDs are stored in the CatLinks intersecting table.
What you could try doing is the following:
1) Only import the LINKID into the CatLinks table.
--> if you are successful, then execute the following SQL Statement in the SQL Monitor option in MySQLMan:
UPDATE CatLinks SET CategoryID = 'someid' WHERE CategoryID = ''
I am not sure if a '0' is inserted or if that column is left as an empty string, which if it does, then the above SQL statement would work.
Or you could copy the LinkIDs into another spreadsheet and then add another column called CategoryID and add in a default value in that column for all records...then IMPORT the spreadsheet into your CatLinks table in your LINKS database.
========================================
Buh Bye!
Cheers,
Me
What you could try doing is the following:
1) Only import the LINKID into the CatLinks table.
--> if you are successful, then execute the following SQL Statement in the SQL Monitor option in MySQLMan:
Quote:
UPDATE CatLinks SET CategoryID = 'someid' WHERE CategoryID = ''
I am not sure if a '0' is inserted or if that column is left as an empty string, which if it does, then the above SQL statement would work.
Or you could copy the LinkIDs into another spreadsheet and then add another column called CategoryID and add in a default value in that column for all records...then IMPORT the spreadsheet into your CatLinks table in your LINKS database.
========================================
Buh Bye!
Cheers,
Me
