View Full Version: Migrating Custom Bookmarks

LawsonTalk > System Admin > Migrating Custom Bookmarks


Title: Migrating Custom Bookmarks
Description: LAWSONLD.custom.csv


schroncd - November 28, 2007 03:40 PM (GMT)
I developed this process for a client and thought I would share:

Assuming you have created custom bookmarks in one of your environments, you can easily migrate them to any other environment using these simple instructions.

. cv to the SOURCE environment and run this command:

rngdbdump -c logan LOBKMARK -f PARENT-BKMARK LAWSON-NAME NAME DESCRIPTION URL ACCESS NEW-WINDOW WIN-WIDTH WIN-HEIGHT MENUBAR TOOLBAR DIRECTORYBAR LOCATIONBAR STATUSBAR DEFAULT-GIF ACTIVE-GIF > source.csv

Migrate source.csv to $LAWDIR/logan/work/LAWSONLD of your TARGET environment, . cv to it and run this command:

rngdbdump -c logan LOBKMARK -f PARENT-BKMARK LAWSON-NAME NAME DESCRIPTION URL ACCESS NEW-WINDOW WIN-WIDTH WIN-HEIGHT MENUBAR TOOLBAR DIRECTORYBAR LOCATIONBAR STATUSBAR DEFAULT-GIF ACTIVE-GIF > target.csv

Now extract the differences from source.csv that are not in target.csv:

egrep -vf target.csv source.csv > custom.csv

Create a file header for your custom load file:

head -1 LAWSONLD.portal > LAWSONLD.custom.csv

Finish formatting LAWSONLD.custom.csv

sed 's/^/"C,"/g' custom.csv >> LAWSONLD.custom.csv

rm custom.csv source.csv target.csv

Run LO920 to load the custon bookmarks


LAWSONLD.custom.csv is now portable to any target environment where you want those bookmarks.

shane pennington - November 30, 2007 03:33 PM (GMT)
Very nice. Thanks David. I will test it out. I do have some concern regarding the exisitence of some other custom bookmarks in the target environment and whether they may get blown away.

In any event. This is simple and appreciated.

Thanks again,
~Shane

Milo - December 12, 2007 02:06 PM (GMT)
QUOTE
Now extract the differences from source.csv that are not in target.csv:


No problem -- all existing custom bookmarks will remain untouched.



Hosted for free by InvisionFree