User Import - "TimeZoneCode" and "RoleCode" List

Hi Grant,

Please see attached for a Time Zone listing csv which you can use for the import. The Role Codes you can get from the Table (staffmemberrole) (You can retrieve these values by running a direct query agaisnt this table) and if you have the Audit reports and/or a YF Configuration DB View installed you can just add the column RoleCode from the staffmemberrole table as such, then use the Drag and Drop Report build to drag in the role code field.

This could produce an example report / output like so which will show you the RoleCodes.

You can leave Initial and SalutationCode blank / use blank quotes "".

Here is an example

Please let me know if the above makes sense and can provide you with what you need to build a working user csv import file.

Thank you,

Paul

Hi Grant,

Quick update. If you want to use a RoleCode which you have not used before then you can lookup either of these 2 tables and get the correct name.

SELECT iporg, reftypecode, refcode

FROM orgreferencecode

WHERE reftypecode = 'ROLE';

or

SELECT * FROM orgrole;

Cheers,

Paul

Hi Grant,

Hope you're having a good week.

Just wanted to check-in and see how it's all going. Was there anything you were needing from me to help get this resolved?

Regards,

Paul

Hi Grant,

Just letting you know that I am going to close off this ticket for now as I have not heard back from you. If you need anything else, please get back to me and I will gladly help further.

Regards,

Paul