OnCourse User Export

Modified on Wed, Jul 17 at 8:58 AM

OnCourse User Export


Overview

This task exports User data for OnCourse. It will create up to two csv files: Students and Staff.


Options

The export can be configured to save locally, be sent in an email, or have the files sent to another machine using (S)FTP.

Individual files can be selected to be included.

Individual schools can be selected to be included.

Export Type: Full or Basic. Full will export all columns. Basic will remove the following columns:

Street_Address11           

Street_Address21           

City1     

County1              

State1  

Country1            

Postal_Code1   

Postal_Code_Ext1          

Phone1 Phone_Ext1      

Alt_Addr_Apt_Num1    

Alt_Addr_Street11         

Alt_Addr_Street21         

Alt_Addr_City1

Alt_Addr_State1             

Alt_Addr_Postal_Code1

Alt_Addr_Postal_Code_Ext1      

Phone_Alt21     

Phone_Alt2_Ext1            

Phone_Alt1       

Phone_Alt_Ext1

Gender1             

Marital_Status1

Citizenship_Status1       

Ethnicity1           

Birth_Date1       

Ann_Date1        

SSN1



Output

Students

Column

UniqueID1

First_Name1

Last_Name1

Email1
User_Type1
Primary_School_ID1
District_ID
UniqueID2
Prefix1
Middle_Name1
Suffix1
Primary_Department_ID1
Login_User_ID1
Preferred_Name1
Street_Address11
Street_Address21
City1
County1
State1
Country1
Postal_Code1
Postal_Code_Ext1
Phone1
Phone_Ext1
Alt_Addr_Apt_Num1
Alt_Addr_Street11
Alt_Addr_Street21
Alt_Addr_City1
Alt_Addr_State1
Alt_Addr_Postal_Code1
Alt_Addr_Postal_Code_Ext1
Phone_Alt21
Phone_Alt2_Ext1
Phone_Alt1
Phone_Alt_Ext1
Gender1
Marital_Status1
Citizenship_Status1
Ethnicity1
Birth_Date1
Ann_Date1
SSN1
Job_Title1
Degree1
Institution1
Highly_Qualified1
Certification1
Active1





Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article