PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 11/12/2008 8:57 PM by  John Henley
Copy bookmarks from one environment to another
 7 Replies
Sort:
You are not authorized to post a reply.
Author Messages
chad208
Advanced Member
(67 points)
Advanced Member
Posts:25


Send Message:

--
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
    Private
    Private
    Senior Member
    (9899 points)
    Senior Member
    Posts:3317


    Send Message:

    --
    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.
    Thanks for using the LawsonGuru.com forums!
    John
    chad208
    Advanced Member
    (67 points)
    Advanced Member
    Posts:25


    Send Message:

    --
    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
    President
    Private
    Veteran Member
    (1431 points)
    Veteran Member
    Posts:477


    Send Message:

    --
    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
    Private
    Private
    Senior Member
    (9899 points)
    Senior Member
    Posts:3317


    Send Message:

    --
    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.
    Thanks for using the LawsonGuru.com forums!
    John
    John Henley
    Private
    Private
    Senior Member
    (9899 points)
    Senior Member
    Posts:3317


    Send Message:

    --
    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.
    Thanks for using the LawsonGuru.com forums!
    John
    Kwane McNeal
    President
    Private
    Veteran Member
    (1431 points)
    Veteran Member
    Posts:477


    Send Message:

    --
    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
    Private
    Private
    Senior Member
    (9899 points)
    Senior Member
    Posts:3317


    Send Message:

    --
    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.
    Thanks for using the LawsonGuru.com forums!
    John
    You are not authorized to post a reply.