If you are planning on adding more than a handful of users at one time, uploading via spreadsheet may be a good option to save time. It is best to use our sample spreadsheet.
There are only 3 required fields:
- First name
- Last name
- Email address
You can include the following optional fields, as well:
- Manager e-mail address (highly recommended)
- Job title
- Job description
- Mobile phone
- Account status (One letter code; A = Active, D = Deleted, L = Locked)
- Work phone
- Twitter username
- Skype name
- LinkedIn profile URL
- Home phone
- Home address
- Country code (Standard 2-character codes; i.e. US, UK, DE -- See this Wikipedia artcile for a full list)
- ZIP/postal code
- Date of birth (must be in format yyyy-mm-dd)
- Employee ID
- Hire date (must be in format yyyy-mm-dd)
- Exit date (must be in format yyyy-mm-dd)
Once you have compiled all your spreadsheet, you will copy/paste it into our system on the Import Users from Spreadsheet page. (Please feel free to delete the standard column headers that are listed in on this page if you are also copying the headers from your spreadsheeet).
Don't be too concerned with how the data looks when you copy/paste. The system essentially maps the information based on tabs that are pulled from the spreadsheet.
On the next page, the system will ask you to confirm that the headers from your spreadsheet match the fields that exist in Primalogik. If you are using our spreadsheet, you should have no problem here. If you used one you made yourself and things are not formatted properly, you can do the mapping at this stage.
Once you confirm that the headers all match the the Primalogik fields, press Preview to see the user accounts that will be coming in.
In most cases, you'll want to import all of the users from your spreadsheet. Use the top checkbox (displayed in the screenshot above) to choose everyone. Otherwise, feel free to use the individual checkboxes next to each person's name to select one-by-one.
Be sure to press Import Selected Users to finalize the process.
*Note: The system will not send any account confirmation emails to these users at this point. If you would like to do so, see our article Sending account confirmation emails en masse.