Just as it is possible to create users using a .csv file it is also possible to expire an entire list of users the same way.
For more information on creating users from a csv file, click here.
In this Article:
Example CSV Set Up
In this example, we've added three different users using this csv file. Notice in the file, that end date and start date are empty. Download CSV template for your own use.
In this example, we've created this list of users from the above list.
Questions? Go to instructions to add users via CSV.
Expiring users by CSV
To expire users, you can use a file formatted the same way. Just add or change the end date for the user(s) you want to expire. See the End Date Formatting Guidelines below to ensure you enter it correctly.
Important:
For our examples, we're using Excel, rather than Numbers to edit the CSV. Using Numbers can sometimes result in file formats that are not compatible with CORE. If you do use Numbers, be sure to export a CSV file from the file you're editing. CSV files can also be edited directly, using any text editor if Excel is not available.
In this example, we're only going to expire one user.
Formatting the endDate Column
The endDate column must be filed out according to a certain convention. This example shows that a user's account will expiring at the beginning of the day on November 10th 2022, Pacific time.
This String is entered using a format for year, month, day, followed by Time in hours, minutes seconds. The dash (or plus sign) indicates time zone relative to GMT 0 (London Time). Time stamps are put in 24 hour time. The format is often abbreviated as YYYY-MM-DDThh:mm:ss-hh:mm:
YYYY-MM-DD = Year-Month-Date
Thh:mm:ss = Time in 24 hours as Hours:Minutes:Seconds
-hh:mm = Timezone in hours and minutes
Reference: TimeZone Map
This entry shows that a user's account would expire on Oct 10th, 2022, at 2:30pm, Pacific Time:
2022-10-10T14:30:00-07:00
This entry is for the date Sept 3rd, 2022, 5:15pm, London Time.
2022-09-03T:17:15:00-00:00
The simplest way to enter these dates is to keep your Time Zone local, and keep the time 00:00:00. This way, only the date is matters. For instance, this date will expire the users account in the first seconds of November 1st, 2022, on the West Coast of the United States.
2022-11-01T00:00:00-07:00
Upload the New CSV
The process to expire a group of users by CSV is similiar to creating them, with the important difference in selecting update rather than create.
From the User panel:
Click "Import from CSV"
On the next window, select update.
Upload the correctly formatted CSV file.
Submit.
Email Notification:
The confirmation e-mail will give you the number of users affected.
It will still say "user import" in the subject line, even though this action edits users, rather than creating new ones.
Confirm Changes
Changes of user accounts can be visually confirmed from scrolling through the user panel. This example shows one user expired as expected.
Downloadable Files