Inbound Data Sync

Josh Willcock

Modified on: Fri, 5 Apr, 2019 at 12:22 PM

Many organisations use systems which enable direct single sign on through set standards. For organisations who use other systems the CLC use a method to assist with this in an attempt to standardize the process, this ensures you receive the best possible service and reliability.

Users can be automatically created, updated and removed on the system without any human interaction. Using a CSV Data Sync also means you can be on our RoadMap Cloud Network.

In order to sync learner information with the CLC we require that you place a Zipped CSV file on to our SFTP server. You will be given your own login details for the server and your files will not be visible to any other parties.

Naming convention Your file must be called UserUploadYYYYMMDD.csv Zipped in UserUploadYYYYMMDD.zip.

Formatting Your CSV must be comma delimited. Values must be enclosed with “”.

Required Fields Your CSV must contain the following headers and values for all learners: * Fields must be unique and be in order (username, email, everything else)

username*

email*

firstname

lastname

uniqueid

josh.willcock

jwillcock@charitylearning.org

Josh

Willcock

S11481

Your Fields If you wish to report on learners or use the hierarchies technology, you must provide location information for the learners. Below is a sample however you can include as many fields as you require.

ismanager(1,0 for true,false)

department

subdepartment

title

learninggroup

1

Technical

Development

Developer

General

Processes

Updating existing users

Customer - Nightly drop of FULL CSV of all current staff and up to date fields