22,647
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
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.
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.
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.
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,
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.)
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.
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.
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.
Bill, if I remember correctly they are kept in mbfusers in the DYNAMICS database.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
