Replicate User Defined Field settings

[Former Member]

I'm trying to find a way to copy the UDF settings for all forms of a single user to each user in a company, then to copy all of the these users and settings onto several databases.

And is supported by SAP.

Any ideas

[former_member583013 · Accepted solution]

Nick,

I am hearing for different sources that this Script is not supported and so on. To my knowledge I have used it and it has worked for me.

I will be more than happy to share the script but please test in on a test system before using it on a Production box and also check with SAP (just in case)

Step 1.

Get the User ID and Names of all your system user from the System to start

SQL for the same is

SELECT USERID, U_NAME FROM OUSR

Step 2.

Copy the User Settings of the Source User from the CPRF table to a temp table

SQL for the same is

if exists (select 1 from sysobjects where name = 'temp_settings')

Begin

drop table temp_settings

End

Select * into temp_settings from CPRF where usersign=[Source_UserId\]

Step 3.

Delete the User setting of the target user from the User Setting table (CPRF)

SQL for the same is

Delete from CPRF where usersign = [Target_UserId\]

Step 4.

Update temp table and change user id to Target User id

SQL for the same is

Update temp_settings Set usersign= [Target_UserId\]

Step 5.

Copy the Setting of the Source User stored in the temp table to the User Setting table

SQL for the same is

Insert into CPRF Select * from temp_settings

REMEMBER, Change the [Source_UserId\] and [Target_UserId\] with the UserId's you got from the OUSR table.

If you want to copy the Source settings to more than One User then just repeat STEP 3, STEP 4 and STEP 5 and change the Target User Id

Let me know if you need any further help on this

<font Color="Red"> You can use the Copy express Add-on from SAP to Copy these user display settings from one DB to another

</font>

Suda

[former_member708266]

Dear,

Please find the answer below.

Q1, copy the UDF settings for all forms of a single user to each user in a company.

A1:

Currently, there is no Business One function available that allows user

preferences to be copied from one user to another.

Q2, copy all of the these users and settings onto several databases.

To copy user defined from a specific company database, please perform

the following steps:

A1:

1. Select the required company database and log in

2. Choose "Administration" and select "Choose company"

3. Click the "New" button

4. Type in the company's database details

5. The new company database will include all "User Defined Fields" of the selected company in step 1.

Wish the answer above is useful for you

Regards

Apple