Modifying CSV files for SDS

%3CLINGO-SUB%20id%3D%22lingo-sub-1686253%22%20slang%3D%22en-US%22%3EModifying%20CSV%20files%20for%20SDS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1686253%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3EThe%20long%20introduction%20is%20necessary.%20Sorry!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20past%20spring%20my%20school%20adopted%20O365%20and%20added%20its%20own%20domain.%20I%20created%20students'%20and%20teachers'%20accounts%20manually.%20We%20log%20in%20with%20our%20work%20e-mail%20addresses%20(in%20the%20format%20of%20%22john.doe%40domain%22)%20and%20use%20Outlook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20the%20school%20year%20I%20wanted%20to%20use%20SDS%20synchronization%20via%20API%20from%20my%20school's%20register.%20However%2C%20according%20to%20the%20tutorial%2C%20the%20schools%20register%20sets%20up%20its%20own%20format%20of%20addresses%2C%20like%20%22jdoe%40domain%22.%3C%2FP%3E%3CP%3ENow%20I%20need%20someone%20to%20confirm%20I'm%20right%20about%20the%20following%3A%20synchro%20via%20API%20would%20create%20new%20teachers%20accounts%20and%20force%20them%20to%20abandon%20their%20previous%20ones%20completely%20shattering%20e-mail%20communication.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%2C%20of%20course%2C%20unacceptable.%20Now%20I'm%20thinking%20about%20SDS%20synchro%20via%20CSVs%20(exported%20from%20the%20register).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20love%20to%20know%3A%3C%2FP%3E%3CP%3E1.%20If%20I%20modify%20%22student.csv%22%20and%20%22teacher.csv%22%20changing%20Usernames%20from%20%22jdoe%40domain%22%20to%26nbsp%3B%22john.doe%40domain%22%2C%20will%20it%20synchronize%20well%20with%20the%20existing%20addresses%2Faccounts%3F%3C%2FP%3E%3CP%3E2.%20Which%20option%20to%20choose%3A%20Existing%20Users%20or%20New%20Users%3F%20I%20don't%20understand%20it%3A%20I%20have%20existing%20users%20who%20I%20want%20to%20map%20to%20new%20teams%20but%20also%20I'll%20have%20some%20new%20teachers%20and%20students%20whose%20accounts%20need%20to%20be%20created%20and%20mapped%20as%20above.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20be%20immensely%20grateful%20for%20any%20help.%3CBR%20%2F%3EZ.S%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1686253%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E.CSV%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESchool%20Data%20Sync%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hi!

The long introduction is necessary. Sorry! 

 

This past spring my school adopted O365 and added its own domain. I created students' and teachers' accounts manually. We log in with our work e-mail addresses (in the format of "john.doe@domain") and use Outlook.

 

With the school year I wanted to use SDS synchronization via API from my school's register. However, according to the tutorial, the schools register sets up its own format of addresses, like "jdoe@domain".

Now I need someone to confirm I'm right about the following: synchro via API would create new teachers accounts and force them to abandon their previous ones completely shattering e-mail communication.

 

This is, of course, unacceptable. Now I'm thinking about SDS synchro via CSVs (exported from the register).

 

I'd love to know:

1. If I modify "student.csv" and "teacher.csv" changing Usernames from "jdoe@domain" to "john.doe@domain", will it synchronize well with the existing addresses/accounts?

2. Which option to choose: Existing Users or New Users? I don't understand it: I have existing users who I want to map to new teams but also I'll have some new teachers and students whose accounts need to be created and mapped as above.

 

I'd be immensely grateful for any help.
Z.S

0 Replies