Dynamic (excel based) adress list synchronisation

%3CLINGO-SUB%20id%3D%22lingo-sub-754474%22%20slang%3D%22en-US%22%3EDynamic%20(excel%20based)%20adress%20list%20synchronisation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754474%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20noble%20task%20to%20find%20a%20way%20to%20make%20a%20contact%20list%20available%20to%20a%20O365%20GAL%20and%20would%20love%20some%20input%2Fguidance%20from%20all%20you%20knowledgeable%20folks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESituation%3A%20at%20any%20given%20time%20we%20can%20(we%20do%20it%20~hourly)%20generate%20an%20excel%20file%20(through%20python)%20with%20regularily%20updating%2Fchanging%20contact%20information%20of%20about%2020.000%20relations.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20this%20updated%20information%20in%20a%20GAL%2C%20but%20am%20unsure%20on%20how%20to%20make%20the%20connection.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20current%20plan%20is%20to%20put%20the%20in%20an%20active%20directory%2C%20but%20as%20this%20would%20be%20more%20programming%20work%20I'm%20hoping%20for%20an%20easier%2Fmore%20direct%20solution.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-754474%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eadress%20list%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExchange%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EGAL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-755254%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20(excel%20based)%20adress%20list%20synchronisation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-755254%22%20slang%3D%22en-US%22%3E%3CP%3EWell%20you%20can%20use%20the%20relevant%20PowerShell%20cmdlets%20to%20create%2Fupdate%20contacts%20in%20the%20GAL%2C%20but%20it's%20pretty%20much%20the%20same%20level%20of%20work%20as%20putting%20them%20in%20AD.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have the noble task to find a way to make a contact list available to a O365 GAL and would love some input/guidance from all you knowledgeable folks.

 

Situation: at any given time we can (we do it ~hourly) generate an excel file (through python) with regularily updating/changing contact information of about 20.000 relations.

 

I need this updated information in a GAL, but am unsure on how to make the connection.

 

My current plan is to put the in an active directory, but as this would be more programming work I'm hoping for an easier/more direct solution. 

 

Any ideas? 

 

 

1 Reply
Highlighted

Well you can use the relevant PowerShell cmdlets to create/update contacts in the GAL, but it's pretty much the same level of work as putting them in AD.