Where are the Business Portal Users stored.

(0) Share

Report

Posted on by Bill Campbell

Where are the Business Portal users stored when you configure them in the BP User (Add) window.

I have over 100 employees who all "now" work for a new company - same desk - same office - new company database and therefore we need to move the pointer for

- Default Company

- Employee ID - Company

- Project Time - Company

- Project Expense - Company

- User - Company.

Anyone out there (tonight Sunday) that might be able to tell me where to find the details.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

Bill, if I remember correctly they are kept in mbfusers in the DYNAMICS database.

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report
Copy link

Link copied!

So the rest of the question is - would it be possible to generate a script that would move all the employee records from one company to another. It is a all or nothing option - all employees are all moving to the new company.

What I have done so far is created a new database, restored the 'old' company (from today) into the 'new' database - so now we have the same data in two DB's

Business Portal has all the employee records pointing to 'old' company and I need to move them to 'new' company.

Unfortunately, I do not know the way to interact with the Employee ID from SharePoint as it is stored in the SQL Table.

Anyone have any suggestions.

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

Does this link provide any useful guidance?

http://renjanvarughese.blogspot.com/2013/10/how-to-move-and-upgrade-business-portal.html

I tried the links it mentions but nothing is returned.

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report
Copy link

Link copied!

Not really what I am looking for. We are not moving to a new server or updating BP, we have to change the Company pointer for all the users already in an active Business Portal setting.

Thanks for the input by the way.

Was this reply helpful? Yes No
Rob Bernhardt Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Bill,

First, a call to support might be the best option. They probably have gone through something like this and may have a detailed list.

Below are a few pointers. You will need to run SQL configuration to enable the new company in BP.

- Default Company (look in DYNAMICS..MbfUserPreferenceSetting table. Pay attention to the ResourceID column where the value equals PreferredContainer.)

- Employee ID - Company (look in MbfRoleUser table. For a role name matching the RoleID guid, look in MbfRole. You'd need to change the Container column here.)

- Project Time - Company (You will need to give your users the appropriate roles via MBF administration for the new company. This shouldn't require SharePoint changes.)

- Project Expense - Company (You will need to give your users the appropriate roles via MBF administration for the new company. This shouldn't require SharePoint changes.)

- User - Company. (You will need to give your users the appropriate roles via MBF administration for the new company. This shouldn't require SharePoint changes.)

Was this reply helpful? Yes No
Derek Albaugh Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Bill,

You mentioned you're "not moving to a new server or updating BP, we have to change the Company pointer for all the users already in an active Business Portal setting".

By 'Company pointer' are you referring to the company ID value from one company to another?

Ideally, if I understand what you're doing correctly, you'll want to do what Rob mentioned and after this new company is added to the SY01500 table (Company Master), run SQL Configuration for Business Portal, which will see this new company database and add it to Business Portal like we'd normally do. You'll also need to add Web Services to this new company database, depending on what version of Business Portal and SharePoint are being used.

Once that is done, then you can add the users back and use the MBFUser, MBFRole and MBFRoleUser tables in DYNAMICS to re-create the same MBF Roles the users are assigned in the original company database to the new one.

The SharePoint group information isn't company specific, so you won't need to add the users back to those groups as they should already be there.

This would be the supported process that we would recommend.

Thanks,

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report
Copy link

Link copied!

I am missing something - run SQL configuration - where? Sorry for the dumbness of the reply, but I have been trying to figure this out for a while and I am a bit confused.

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report
Copy link

Link copied!

Being the 'stressed' consultant is not a great thing - but I realized I was looking on the SQL Server and not th BP Server - so I am in the middle of running the Wizard to add the new company now to Business Portal.

I have already manually added the user in BP to the new SQL Company - but that was only the half of it. This final step should take care of the rest.

I will update this shortly.

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report
Copy link

Link copied!

Running the Web Wizard on the Business Portal Server worked and we are not able to add projects and users to the existing projects within BP. All users appear to be operational.

Thanks for your assistance in getting to the bottom of this mess.

Was this reply helpful? Yes No