Where is help text stored for each object

general discussion
1

Does anyone know the table and field the help text for each object is stored
in? I would like to load some predefined help texts instead of rekeying
everything. Anyone done this?

Thanks,

Julie

Listserv Archives (BOB member since 2002-06-25)

2

Look at Unv_Object_data table where OBJ_DATATYPE = ‘H’. Be careful, if
the help text is more then 240 characters long then Business Objects
will partition the help text into multiple columns on the table and it
identifies it by the value in the OBJ_SLICE Table.
Good Luck

Listserv Archives (BOB member since 2002-06-25)

3

Hi, Julie!

The table you want is UNV_OBJECT_DATA. There are two columns of
interest:
OBJ_DATATYPE which can have values of H (Help Text), S (Select), and W
(Where). There may be others, but these are the ones I use.

    OBJ_DATAVALUE which contains the actual text for each type of   object

above. For example, the row for an object with a OBJ_DATATYPE of ‘H’
would contain the help text for that object.

I haven’t automated filling in the help text, but I imagine you would
just have to select the objects (being sure to restrict on the
appropriate universe) and update these fields. However, as anyone can
tell you, it can be very dangerous to directly update the repository
database (not that many of us haven’t done it )

Hope that helps,
Michael

Julie Moran wrote:

Does anyone know the table and field the help text for each object is stored
in? I would like to load some predefined help texts instead of rekeying
everything. Anyone done this?

Thanks,

Listserv Archives (BOB member since 2002-06-25)

4

Julie Moran wrote:

Does anyone know the table and field the help text for each object is stored
in? I would like to load some predefined help texts instead of rekeying
everything. Anyone done this?

It is stored in the UNV_OBJECT_DATA table, and it’s pretty tricky to load data
into it :wink:

You can have a look into the repository definition on the CD in directory
“freeware”…

hope this helps.

Walter.

DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria
Tel: +43-1-8151456-12, Fax: +43-1-8151456-21
e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at

Listserv Archives (BOB member since 2002-06-25)