Procedure on migrating users to another YF server

Mike Sheehan ●

Hi Pearlsia,

Thank you for reaching out. We do indeed have a Wiki entry on Bulk User Imports, please reference the following for that: https://wiki.yellowfinbi.com/display/USER74/Users#Users-BulkUserImport.

There is also a way to bulk export via backend config queries.

Thanks for reaching out. There is indeed no way to accomplish this via the Admin Console, but it's possible to write a query against the config DB to give you most of the data needed for export.

You users should be contained in a CSV format with data contained within quotes. See the example below and on the screen for more detail. The example file format is as follows:

# Comments can be present. Starting with a # only. Blank lines will also be skipped. # First Name, Last Name, Initial, Salutation Code, Language Code, Time Zone Code, Email Address, UserName, Password, Role Code "Bob", "Jones", "A", "MR", "EN", "", "bob.jones@company.com", "bob.jones@company.com", "password", "YFADMIN"

Most of these are found in the 'person' table. You can populate this .CSV using a query against your Yellowfin Configuration Database. Please ensure you have full backups of both your Yellowfin Configuration Database and your Yellowfin Installation Folder before running any queries directly against the Yellowfin Config DB.

The following query should pull a list of all of your users:

SELECT p.FirstName, p.LastName, p.MiddleInitial, p.SalutationCode, p.PreferredLanguageCode, p.LocalTimeZoneCode, c.emailAddress, i.EmailLeft, i.Password, s.RoleCode
FROM Person p
INNER JOIN IpContact c ON p.IpPerson=c.IpID
INNER JOIN IpClass i ON p.IpPerson=i.IpID
INNER JOIN StaffMemberRole s ON p.IpPerson=s.IpEmployee
WHERE i.enddate > now() and s.enddate > now();

Hopefully this helps! Please let me know if you have any further questions.

Regards,

Mike

Hi Pearlsia,

Thank you for reaching out. We do indeed have a Wiki entry on Bulk User Imports, please reference the following for that: https://wiki.yellowfinbi.com/display/USER74/Users#Users-BulkUserImport.

There is also a way to bulk export via backend config queries.

Thanks for reaching out. There is indeed no way to accomplish this via the Admin Console, but it's possible to write a query against the config DB to give you most of the data needed for export.

You users should be contained in a CSV format with data contained within quotes. See the example below and on the screen for more detail. The example file format is as follows:

# Comments can be present. Starting with a # only. Blank lines will also be skipped. # First Name, Last Name, Initial, Salutation Code, Language Code, Time Zone Code, Email Address, UserName, Password, Role Code "Bob", "Jones", "A", "MR", "EN", "", "bob.jones@company.com", "bob.jones@company.com", "password", "YFADMIN"

Most of these are found in the 'person' table. You can populate this .CSV using a query against your Yellowfin Configuration Database. Please ensure you have full backups of both your Yellowfin Configuration Database and your Yellowfin Installation Folder before running any queries directly against the Yellowfin Config DB.

The following query should pull a list of all of your users:

SELECT p.FirstName, p.LastName, p.MiddleInitial, p.SalutationCode, p.PreferredLanguageCode, p.LocalTimeZoneCode, c.emailAddress, i.EmailLeft, i.Password, s.RoleCode
FROM Person p
INNER JOIN IpContact c ON p.IpPerson=c.IpID
INNER JOIN IpClass i ON p.IpPerson=i.IpID
INNER JOIN StaffMemberRole s ON p.IpPerson=s.IpEmployee
WHERE i.enddate > now() and s.enddate > now();

Hopefully this helps! Please let me know if you have any further questions.

Regards,

Mike

2

Mike Sheehan ● ●

Hi Pearlsia,

Thank you for reaching out. We do indeed have a Wiki entry on Bulk User Imports, please reference the following for that: https://wiki.yellowfinbi.com/display/USER74/Users#Users-BulkUserImport.

There is also a way to bulk export via backend config queries.

Thanks for reaching out. There is indeed no way to accomplish this via the Admin Console, but it's possible to write a query against the config DB to give you most of the data needed for export.

You users should be contained in a CSV format with data contained within quotes. See the example below and on the screen for more detail. The example file format is as follows:

# Comments can be present. Starting with a # only. Blank lines will also be skipped. # First Name, Last Name, Initial, Salutation Code, Language Code, Time Zone Code, Email Address, UserName, Password, Role Code "Bob", "Jones", "A", "MR", "EN", "", "bob.jones@company.com", "bob.jones@company.com", "password", "YFADMIN"

Most of these are found in the 'person' table. You can populate this .CSV using a query against your Yellowfin Configuration Database. Please ensure you have full backups of both your Yellowfin Configuration Database and your Yellowfin Installation Folder before running any queries directly against the Yellowfin Config DB.

The following query should pull a list of all of your users:

SELECT p.FirstName, p.LastName, p.MiddleInitial, p.SalutationCode, p.PreferredLanguageCode, p.LocalTimeZoneCode, c.emailAddress, i.EmailLeft, i.Password, s.RoleCode
FROM Person p
INNER JOIN IpContact c ON p.IpPerson=c.IpID
INNER JOIN IpClass i ON p.IpPerson=i.IpID
INNER JOIN StaffMemberRole s ON p.IpPerson=s.IpEmployee
WHERE i.enddate > now() and s.enddate > now();

Hopefully this helps! Please let me know if you have any further questions.

Regards,

Mike

Hi Pearlsia,

Thank you for reaching out. We do indeed have a Wiki entry on Bulk User Imports, please reference the following for that: https://wiki.yellowfinbi.com/display/USER74/Users#Users-BulkUserImport.

There is also a way to bulk export via backend config queries.

Thanks for reaching out. There is indeed no way to accomplish this via the Admin Console, but it's possible to write a query against the config DB to give you most of the data needed for export.

You users should be contained in a CSV format with data contained within quotes. See the example below and on the screen for more detail. The example file format is as follows:

# Comments can be present. Starting with a # only. Blank lines will also be skipped. # First Name, Last Name, Initial, Salutation Code, Language Code, Time Zone Code, Email Address, UserName, Password, Role Code "Bob", "Jones", "A", "MR", "EN", "", "bob.jones@company.com", "bob.jones@company.com", "password", "YFADMIN"

Most of these are found in the 'person' table. You can populate this .CSV using a query against your Yellowfin Configuration Database. Please ensure you have full backups of both your Yellowfin Configuration Database and your Yellowfin Installation Folder before running any queries directly against the Yellowfin Config DB.

The following query should pull a list of all of your users:

SELECT p.FirstName, p.LastName, p.MiddleInitial, p.SalutationCode, p.PreferredLanguageCode, p.LocalTimeZoneCode, c.emailAddress, i.EmailLeft, i.Password, s.RoleCode
FROM Person p
INNER JOIN IpContact c ON p.IpPerson=c.IpID
INNER JOIN IpClass i ON p.IpPerson=i.IpID
INNER JOIN StaffMemberRole s ON p.IpPerson=s.IpEmployee
WHERE i.enddate > now() and s.enddate > now();

Hopefully this helps! Please let me know if you have any further questions.

Regards,

Mike

Reply URL

1

Pearlsia ●

Hello Mike,

Sorry for the late reply. Just restored the whole DB into the new target one. Was just a bit worried about orphaned records or something. Could be great if users can be included in the exported *.yfx.

Thank you for the response.

Appreciate it alot.

Kindest regards,

Pearlsia.

URL

1

Mike Sheehan ●

Hi Pearlsia,

You're welcome! We'd previously logged an enhancement request to allow bulk user export from the UI, but the idea was marked as Not Planned due to the ease of the workaround. I'll go ahead and mark this as Answered all considered. Please don't hesitate to reach out with any other questions or concerns.

Regards,

Mike

URL

Procedure on migrating users to another YF server

Replies (1)