Importing User Portraits from SharePoint Server
Regular and Automated Import
Create a scheduled task on the server with periodicity e.g. once per day which will run the following command:
%ProgramFiles%\ALVAO\Admin\ImportPortraitsSharepoint.exe /server <sql_server> /db <alvao_database> /portalUrl <url> /username <login> /password <pass>
Note: This task can be optionally created already during the installation of ALVAO Server using the ALVAO Server Setup application.
One-Time Import
If you want to import portraits from SharePoint immediately, follow the steps below:
- In ALVAO Admin application, go to the main menu and select File – Load – Load pictures from SharePoint.
- Enter the SharePoint address and the login data and then click on OK.
- This will launch the ImportPortraitsSharepoint utility with the corresponding parameters which will load the user portraits to the ALVAO database.
ImportPortraitsSharepoint Utility
The ImportPortraitsSharepoint utility loads user portraits from SharePoint 2010, 2013 or SharePoint Online (Office 365) to ALVAO system.
This utility is a part of the ALVAO Admin installation and is installed in the same folder, i.e. usually in "%ProgramFiles%\ALVAO\Admin".
Command Line Parameters
| Parameter |
Description |
Required |
Example |
/conn <string>
/server <server>
/db <db> |
Database connection settings. |
Yes |
/conn "Integrated Security=True;Initial Catalog=ALVAO;Data Source=.\SQLEXPRESS;" /server .\SQLEXPRESS /db ALVAO |
| /portalUrl <url> |
SharePoint address. |
Yes |
/portalUrl https://company.sharepoint.com |
| /office365 |
A flag specifying Office 365. |
No |
/office365 |
| /username <login> |
Username for SharePoint login. |
No |
/username john.smith@company.com |
| /password <pass> |
Password for SharePoint login. |
No |
/password password |
| /wait |
Wait for key press at the end of the import. |
No |
/wait |
| /progress |
Display import progress. |
No |
/progress |
If no user name for SharePoint login is specified, the import will use the current account (please note that this is not supported in Office 365 or if SharePoint uses form authentication). If the SharePoint address contains "sharepoint.com" or "onmicrosoft.com", the option office365 will be enabled automatically.
User Matching
Converting SharePoint users to ALVAO system users uses the following:
- E-mail – SharePoint attribute Email.
- Username – SharePoint attribute Name (standard matching with domain).
- Name – SharePoint attribute Title.
Did not find what you were looking for? Ask our technical support team.
|