Experience imports allow you to bulk import experiences or your users. Only site administrators or those with access to manage experiences will be able to complete this action. To access the experience import template, go to your Administration tools, click the Users dropdown, and then select Experience Import. You will see a list of the imports already run by your campus.

Experience_Imports.gif

You can click "Where do I start?" at the top of the page to read about some experience import examples. When you are ready to begin the import process, click Create Import in the upper right hand corner.

2017-03-27_1413.png

Now, you can download the Experience Import Template (attached at the bottom of this article). Below you will find a list of all the fields in the template, their descriptions, validation information, and examples. Note that the rows that are bolded are mandatory for your import to be successful. Any additional fields are optional for you to include.

Field Name

Description

Validation/Example

Action

Enter “Create” in this field to signify experience creation

 

Only “Create” will work in this field

ExperienceTypeID

ID Number for the Experience Type

 

Experience Type ID number; Example: 1, 12, 36

 

Username

Authentication credential used to access the system

 

Any combination of letters or letters and numbers; Example: jdoe123

 

ExperienceName

The name of the experience to be recorded in the system

 

Any combination of letters, spaces, apostrophes, or quotes; Example: Student Leader of the Year Award

 

Description

Description of the experience

 

Any combination of letters, spaces, apostrophes, or quotes; Example: Received award from the Office of Student Life

 

Date

Date you are completing the import

 

MM/DD/YYYY, Example: 04/03/2017

 

StartDate

Start date of the experience

MM/DD/YYYY, Example: 04/03/2017

 

EndDate

End date of the experience

MM/DD/YYYY, Example: 04/03/2017

 

Hours

Number of hours tracked during experience

 

H:MM, Example: 4:30

 

OrganizationID*

If the experience is tied to an organization, enter the Organization ID OR the Organization name. The import will fail if you enter both.

 

Organization ID number; Example: 54213

OrganizationName*

If the experience is tied to an organization, enter the Organization ID OR the Organization name. The import will fail if you enter both.

 

Organization name, exactly as it is listed in the system; Example: Student Government Association

Reflection

Enter the user’s personal reflection of the experience

Any combination of letters, spaces, apostrophes, or quotes

Website

Website that is tied to the experience (if needed)

Any valid website ending in .com, .edu, .org etc.

 

ContactName

Contact person who can verify the experience

 

Any combination of letters, spaces, apostrophes, or quotes; Example: Jane Smith

 

ContactTitle

Title of the contact person who can verify experience

 

Any combination of letters, spaces, apostrophes, or quotes; Example: Director of Student Life

 

ContactPhone

Domestic (U.S. and Canada) mobile phone number of verification contact

Any combination of digits, maximum 10 characters

 

ContactEmail

Institution-assigned email address of verification contact

Any valid e-mail address ending in .edu or .ca; Example: jsmith@engageu.edu

 

AdditionalInfo

Any additional information regarding the experience

Any combination of letters, spaces, apostrophes, or quotes

Status

Mark whether the experience will be “Approved” or “Denied” in the system

Only Approved or Denied will work in this field

 

ReviewedByUsername

Authenticated username of the user who reviewed the experience

Any combination of letters or letters and numbers; Example: jdoe123

 

ReviewedComments

Additional comments that are optional to add regarding approving or denying the experience

Any combination of letters, spaces, apostrophes, or quotes

 

ReviewedDate

Date the experience was reviewed

MM/DD/YYYY, Example: 04/03/2017


Return to your CollegiateLink screen to upload the import when you are finished completing the template. Click Choose File to select your import template and then click Upload. If you have any questions or issues setting up this import, please reach out to us at support@campuslabs.com.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Need More Help?

Additional Support

Powered by Zendesk