Bulk importing users into articy:server

Thu 9. Jul 2015, 10:08

If you want to create a bunch of users very fast, the best way is to use the CSV import from articy:server.

Although this functionality was implement for testing purposes, it may be handy for customers as well. So let me give you some help here on how to use it and what to keep in mind.

Lets start with the attached Users.xlsx worksheet (Unzip the file first). Open this in Microsoft excel or your spreadsheet tool.

The first row contains the headline and at least the Username column must be present. All other columns are optional and lead to a default handling if they are missing.
Write the users Name in the Username column, this name is used as login and display name. All printable characters are allowed here.
If the E-Mail column is present and the cell is not empty the value is set in the users e-mail property. This property is available in the articy:draft API and can be used to automation processes. If you don't use it simply leave it empty.
The "Password" column can be used to set a specific password for an user. If the column is missing or the cell for a user is empty, the user gets his Username as password.
Last but not least the License column. You can specify which type of license a specific user should get. This is done with one of the following one character values
  • M - assign a multi-user license
  • V - assign a viewer license
  • F - assign a floating multi-user license
  • N (or an empty cell or missing column) - assign no license to that user

Now save the file as CSV.

For those of you that only use ascii or windows codepage 1252 chars in their user names you are done.
For all others, DON'T save as CSV if you are using Microsoft Excel, because it would replace any non ascii character with a '?' You can use the "Unicode Text (*.txt)" instead.
The "save as..." dialog of most other spreadsheet softwares allow to specify a character set. Use UTF-8 here. The "download as" from Google spreadsheet automatically uses utf-8 encoding in the file.
You may take a look at this article: https://www.ablebits.com/office-addins-blog/2014/04/24/convert-excel-csv/

When importing articy:server is smart enough to auto detect the proper field separator char. Allowed are ',' (Comma), ';' (Semicolon) as used in European CSVs and Tab (used when exporting as "Unicode Text")

The next step is to import this into articy:server. Follow the next steps
  • Log on to the machine that runs the articy:server
  • stop the articy:server windows service
  • open a cmd or powershell window
  • navigate to the installation folder of the articy:server (normally C:\Program Files\articy server 2\server)
  • start the articy:server in console mode using the commandline ArticyServer.exe /con /importusers "<Full qualified filepath to you CSV>"
  • You will now see a line for each user in your CSV that either is "User ... created" or skipped, if that username already exist in the database.
  • Now press CTRL-C to signal the server to terminate, and wait until you have returned to the command prompt
  • re-start the articy:server service
Attachments
Users.zip
Sample file as zipped XLSX worksheet
(11.43 KiB) Downloaded 1417 times
User avatar
[Articy] Peter Sabath
Articy Staff
Articy Staff
 
Posts: 89
Joined: Wed 23. Nov 2011, 13:58
Location: Bochum

Return to Knowledge Base

Who is online

Users browsing this forum: No registered users and 5 guests

Who We Are
Contact Us
Social Links