Import user portraits from SharePoint server
Regular automatic import
Create a scheduled task on the server with a recurrence period of e.g. 1 time per day that runs the following command:
%ProgramFiles%\ALVAO\MailboxReader\ImportPortraitsSharepoint.exe /server <sql_server> /db <database_alvao> /portalUrl <url> /username <login> /password <pass>
Note:
This task can optionally be created when you install ALVAO Server using
ALVAO Server Setup.
One-time import
To import portraits once, run a scheduled job created on the server or copy the ImportPortraitsSharepoint application from the application server to your computer and run it from the command line. The application is installed together with the ALVAO Servide Desk MailboxReader in the "%ProgramFiles%\ALVAO\MailboxReader" directory.
Utility ImportPortraitsSharepoint
The ImportPortraitsSharepoint utility loads user portraits from SharePoint 2010, 2013 or SharePoint Online (Office 365) into Alvao.
The utility is part of the ALVAO Service Desk MailboxReader installation and is installed in the same folder, usually in "%ProgramFiles%\ALVAO\MailboxReader".
Command line parameters
Parameter |
Description |
Mandatory |
Example |
/conn <string> /server <server> /db <db> |
Setting the DB connection. |
Yes |
/conn "Integrated Security=True;Initial Catalog=ALVAO;Data Source=.\SQLEXPRESS;" /server .\SQLEXPRESS /db ALVAO |
/portalUrl <url> |
SharePoint address. |
Yes |
/portalUrl https://firma.sharepoint.com |
/office365 |
Flag that this is Office 365. |
No |
/office365 |
/username <login> |
User name for logging into SharePoint. |
No |
/username jan.rychly@firma.cz |
/password <pass> |
Password to log into SharePoint. |
No |
/password password |
/wait |
Wait for a keystroke at the end of the import. |
No |
/wait |
/progress |
Display import progress. |
No |
/progress |
If no username is specified for SharePoint login, the current account is used (note: not supported in Office 365, or if SharePoint has forms authentication). If the SharePoint address contains "sharepoint.com" or "onmicrosoft.com", the office365 option is automatically enabled.
User pairing
To convert users from SharePoint to Alvao users, use:
- E-mail - SharePoint attribute Email.
- User Name - SharePoint attribute Name (standard domain comparison).
- Name - SharePoint attribute Title.
Did not find what you were looking for? Ask our technical support team.