View Full Version: Custom Books In Portal (ess/mss)

LawsonTalk > LSF 9.0 (NEW!!) > Custom Books In Portal (ess/mss)



Title: Custom Books In Portal (ess/mss)
Description: Loading thru LO920?


Mil0n023 - January 23, 2008 09:37 PM (GMT)
Anyone use the LO920 to load custom books for Logan? We just started to migrated to LSF9.0 - and heard that I need to run this to load all my custom bookmarks? How does this program work?


schroncd - January 24, 2008 02:32 AM (GMT)
LO920 is used to load bookmarks that are already in a special csv format. My guess is that your custom bookmarks have not been so packaged. You'd be better served to load them individually with LO12 and LO14.

Once you have them loaded into one instance let me know and I'll post a way to generate a csv file for all your custom bookmarks that will offer you a portable solution so you can use LO920 going forward. I'd post it tonight but I don't have access to my notes from this machine.

schroncd - January 24, 2008 02:59 AM (GMT)
Ah HAH!! Found my notes!

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.

Mil0n023 - January 30, 2008 03:32 PM (GMT)
:blink: excellent info - however, we are remotely hosted so I haven't the power!

I did rngdbdump the LOBKMARK from my 8.03 Logan, and now looking thru the csv file it appears to be right..?

Now am I to assume I can just put this lobkmar.csv in the 9.0 directory for lo920 to pick up?

:bow:

schroncd - January 30, 2008 07:31 PM (GMT)
Not unless it's in the format that I specified above - and note that I add a header and a preceeding column in the instructions. If you just drop your existing rngdbdump .csv in the LAWSONLD directory it will blow up..

another caveat is that you have to verify that the bookmarks are now CORRECT - Many changed in the 9.0 configuration

And lastly.. your rngdbdump has bookmarks in it that are already in your 9.0 setup. Unless you remove those you are gonna have PROBLEMS...

So for God's sake, do it in TEST first - and be darned sure you have a good backup before you begin!




Hosted for free by InvisionFree