The standard user import CSV can be used to:
- Create new users
- Update user information
- Delete users
Filling Out the CSV
Using any standard spreadsheet editing software, create a CSV with 16 columns that correspond to the fields necessary for uploading users in batches. Here's a template to get you started.
Description of fields
The standard user creation CSV is similar to the standard course creation/update and registration CSVs in that it uses the same “1” is “yes” “0” is "no" logic for some of the fields. Below are descriptions of each field according to its corresponding column in any application that allows you to edit spreadsheets:
A. SyncID - Required. User email or associate ID number (whichever is used to sync with courses). Leading zeros may not save in Excel. Example: 48562739 B. First Name - Required. First letter capitalized, no punctuation. Example: David C. Last Name - Required. First letter capitalized, no punctuation. Example: David D. Password - Required. User is responsible for maintaining the confidentiality and security of their username and password. E. Username - Required. Can contain letters, numbers, and symbols. Example: DRose22@fmu.edu F. Email - Required. Example: DRose22@fmu.edu G. Show Image - Pertains to profile image, uploaded through User Profile. “1” if you want your profile image to be visible to others in the system, “0” if not. H. Major - Will display in User Profile. Not required. Example: English I. Graduation - Date of graduation (xx/xx/xxxx). Will display in User Profile. Not required. Example: 6/1/2024 J. Faculty - 1 is “yes” and 0 is “no” meaning that it is a student account. K. Website - Will display in User Profile. Not required. Example: https://www.kmartinez.com L. Active - Should always be “1” when creating users. When updating users, enter “0” if for those to be deactivated. M. Birthdate - Will display in User Profile. Can be left blank if COPPA is 1. N. COPPA - Should be “1” if the user is not under the age of 13. Means that users are over the age of 13 and/or have written parental consent/COPPA form on file. O. Update - Update - “1” if the user in the row is being updated and “0” if the user is being created for the first time. P. Delete - “0” if the user is being created or updated and “1” if you wish to delete them
Preparing the CSV for Export
Once all of the relevant data has been put into the file in the correct format, be sure to remove any of the guides that were being used so that the first cell (A1) has [user] in it, immediately followed by the data being uploaded as shown in the image above.
Users can be imported using either the new administration area, or the classic administration area.
User Import in the New Administration Area
System level administrators can access the New Administrator tools by logging in and appending "/administration" at the end of their Digication institution URL, for example: http://yourschool.digication.com/administration.
On the Administration home page, select Import from the left-side menu.
Select Upload from the expanded Imports menu.
Select the Advanced Upload tab (2). Click the Select a file button (3) to locate your CSV on your computer and select the check box for Use Debug Mode (4) to generate a system log for this upload. Select Data (5) and then click the Upload button (6) when you are ready to start the process.
After you upload your CSV, you will be taken to your Logs for technical details about the upload and its progress. Each uploaded file will be represented by its own row in the Logs. The Status column (7) will likely show as “Processing” immediately after you upload. You may need to refresh the page a few times until the status shows as “Complete.” You can view the Successful Entries and Error Entries (8) to determine if your import has been successful.
User Import in the Classic Administration Area
Go to the Administration tab
Click on Import
Check off Debug before selecting and uploading your CSV
The "Logs" Page
After a standard CSV, you'll be brought to the "Logs" page where you'll be able to see how many imports have been attempted and how many entries within those imports have been successful.
Refresh to view your results
After refreshing, you'll be able to view the results of your import once it's complete and then adjust or re-upload accordingly. Keep in mind that for large data imports, you'll have to wait a few moments before this information becomes available.
Please sign in to leave a comment.