Copy Form Setting from one user to another

[Former Member]

Hi,

I am using 2005A.

How to copy form setting (rows and UDFs at header) from one user to another user?

Thanks

[Former Member]

You can use the addon "Copy Express".

Regards,

WB

[Former Member]

Is it possible to copy User Defined Fields in table from one database to another database

[Former Member]

Yes, Copy Express can copy UDF from one table to another, I tried it many times, no problem on it.

[rasmuswulff_jensen]

The SDK also have an object for this regarding the rows.. it called the FormPreferencesService

[Former Member]

Hi Ming Ming On,

I found a note couple of years ago.

I can't remember the note number, and I attach the note here.

Solution

The following queries enables you to set preferences for one user and copy those to another user who is supposed to have the same preferences.

Explanation for the queries variables:

dest - Company database name

sourcid - Represents the user ID from whom the preferences will be copied.

destid - Represents the user ID to whom the preferences will be copied.

How to get the user ID?

From SAP Business One query interface or from the SQL Query Analyzer, run the query as follows:

1. SELECT T0.U_NAME, USERID FROM OUSR T0 FOR BROWSE

2. From the query's results, identify both the sourcid and the destid.

3. In order to copy the preferences from sourcid to destid, run the query as follows:

a) Replace the text dest with the company database name.

b) Replace the text sourceid with the user ID from which the preferences will be copied.

c) Replace the text destid with the user ID to which the preferences will be copied.

d) Use dest, if exists (select 1 from sysobjects where name = 'temp_dev_sup')

e) Begin - drop table temp_dev_sup

f) End - select * into temp_dev_sup from cprf where usersign='sourcid'

Deleting a certain user:

Delete from cprf where usersign='destid'

Update userid in temporary table:

1. Update temp_dev_sup

2. Set usersign='destid'where usersign='sourcid'

Insert preferces into CPRF table

1. Insert into cprf

2. Select "" from temp_dev_sup where usersign='destid*'

예제)

1. Use TEST_MONAMI

2. drop table temp_dev_sup

3. Delete from cprf where usersign='2'

4. select * into temp_dev_sup from cprf where usersign='1'

5. Update temp_dev_sup

Set usersign='2'where usersign='1'

6. Insert into cprf

Select * from temp_dev_sup where usersign='2'

[Former Member]

Hi

Can any one find this Note?

Do any one know if this is still supported by SAP?

Regards