Copy bookmarks from one environment to another

chad208

Advanced Member

Posts: 25

11/12/2008 1:38 PM

We have two (2) environments running on our test system. One of the environments is running an 8.0.3 version of Self Service and another is running 9.0.

Does anyone know of a method I can utilize to copy Portal bookmarks from one environment to another. Thanks in advance.

John Henley

Senior Member

Posts: 3348

11/12/2008 7:12 PM

You should be able to dump to a CSV file using LO921, then load into the other environment using LO920.
You'll probably want to massage the CSV file in-between to make sure you are only loading bookmarks you want, since you would otherwise be loading/creating duplicates in your 9.0 portal.

chad208

Advanced Member

Posts: 25

11/12/2008 7:23 PM

I believe when we went to LSF 9 and upgraded Portal LO921 was removed as we do not have the LO921 form. Is this incorrect?

Kwane McNeal

Veteran Member

Posts: 479

11/12/2008 7:30 PM

Chad,
John's directions to you were correct. On the 8.0.3 side, use the LO921 to dump the bookmarks. The form is still available to you, so you should have no issues using it. On the 9.0.0.x side, then load them with LO920. You are correct, on the LSF9 side you do NOT have LO921.

The other method is to copy the tables via dbcopy. That is the method the migration uses. This will give you EXACT copies, BUT has the risks of reintroducing the invalid 8.0.3 bookmarks into LSF9, so you would have some clean up there also.

All in all, John's method is safer, and my method is faster.

Kwane

John Henley

Senior Member

Posts: 3348

11/12/2008 7:34 PM

Sorry, I misread your initial post, I thought it implied you had 8.0.3 version of environment for the 8.0.3 self service.

John Henley

Senior Member

Posts: 3348

11/12/2008 7:37 PM

You could use MS Addins to dump from LOBKMARK to create a CSV file you could then upload via LO920.

Kwane, I think it would be sqldbcopy, not dbcopy, since he has TWO LOGANS, i.e. two different environments.

Kwane McNeal

Veteran Member

Posts: 479

11/12/2008 7:51 PM

John,
Nope. Check out $GENDIR/ug81/copybkmrkdata.pl

For Chad, he would a dbdump/dbload, as the tables have no changes in structure.

Kwane

John Henley

Senior Member

Posts: 3348

11/12/2008 8:57 PM

When you run that migration script ($GENDIR/ug81/copybkmrkdata.pl), both LOGAN803 and LOGAN (lsf9) are installed in the same environment. dbcopy only works if the product lines are in the same environment. To copy across environments, you need to use sqldbcopy.

Regardless, depending on what he's trying to do, he probably shouldn't be copying the table data anyway, but should use LO920 for loading into the new environment to get new bookmark numbers, etc. To copy directly via the table would potentially corrupt his bookmarks.