Can I some how export my favorites...

[Stewe Lundin]

Can I some how export my favorites and their settings(icons, custom names and colors). 

I my DEV and TEST instance I have a set up of favorites that I don't use in Prod, and when we re clone the environments, TEST more often then DEV, from PROD my account is destroyed. 

[Chuck Tomasi · Accepted solution]

go to the menu filter and type sys_ui_bookmark.list

Filter on records where the user column has your values

Then use Export> XML from the list menu to save as XML

On the new system (after cloning, or whatever)

Import XML from the list filter.

Locate your saved file, and you're done.

[TimothyI]

As a new admin in sub PROD environments this is a nice trick

[Joe Fieck]

This is an older thread but the only one that looked close to what I am seeing. 

I can export my favorites to XML then clear my list of favorites but when I import them again I loose the structure.

For example:
I have a favorite with two sub links as such:

Performance Analytics

    -Automatic indicators
    -Dashboards

But when I export then reimport it comes back as:

Automatic Indicators
Dashboards

I loose the structure where they used to be under the "Performance Analytics" function.

Maybe I'm missing a step...?

[tac11tac11]

I realize this is way after the fact and listed elsewhere.

There is a second table that contains the groups.  sys_ui_bookmark_group

So, to move from instance to instance, you need your records from both tables... sys_ui_bookmark_group and sys_ui_bookmark.  In the sys_ui_bookmark_group table, the parent_group field maintains the relationships between groups.  In the sys_ui_bookmark table, the group field maintains the relationships between the bookmark and the containing group.  Both of these fields use a sys_id.

Cheers.

Todd