SOLVED

Bulk import members - None of your contacts have an xyz.onmicrosoft.com address

%3CLINGO-SUB%20id%3D%22lingo-sub-363163%22%20slang%3D%22en-US%22%3EBulk%20import%20members%20-%20None%20of%20your%20contacts%20have%20an%20xyz.onmicrosoft.com%20address%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363163%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20struggling%20a%20bit%20with%20bulk%20importing%20members%20via%20CSV.%20I%20created%20the%20CSV%20with%20the%20%22E-Mail%22%20header%20and%20put%20some%20e-mail%20addresses%20in%20to%20test.%20I%20entered%20their%20primary%20SMTP%20address.%3C%2FP%3E%3CP%3EWhen%20I%20click%20the%20preview%20button%2C%20Yammer%20tells%20me%20none%20of%20the%20contacts%20have%20an%20xyz.onmicrosoft.com%20email%20address%20even%20though%2C%20when%20you%20look%20at%20their%20Exchange%20details%2C%20they%20all%20have%20one%20as%20an%20alias%20defined%20on%20their%20account.%3C%2FP%3E%3CP%3EEven%20when%20I%20change%20the%20'real%20domain'%20in%20the%20CSV%20with%20the%20.onmicrosoft.com%20domain%2C%20the%20same%20error%20pops%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThese%20users%20are%20already%20in%20the%20Yammer%20network%20and%20are%20already%20members%20of%20several%20other%20Yammer%20groups%20so%20this%20strikes%20me%20as%20a%20very%20strange%20error%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20else%20encountered%20this%20before%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-363163%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EYammer%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-382702%22%20slang%3D%22en-US%22%3ERe%3A%20Bulk%20import%20members%20-%20None%20of%20your%20contacts%20have%20an%20xyz.onmicrosoft.com%20address%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-382702%22%20slang%3D%22en-US%22%3E%3CP%3EGot%20the%20same%20error!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-832120%22%20slang%3D%22en-US%22%3ERe%3A%20Bulk%20import%20members%20-%20None%20of%20your%20contacts%20have%20an%20xyz.onmicrosoft.com%20address%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-832120%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F183455%22%20target%3D%22_blank%22%3E%40Cedric%20OSTER%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F31161%22%20target%3D%22_blank%22%3E%40Steve%20Hernou%3C%2FA%3E%26nbsp%3B%20-%20A%20little%20late%20to%20the%20party%2C%20but%20for%20me%2C%20I%20received%20the%20same%20error%20today%20and%20I%20saw%20my%20mistake%20was%20initially%20saving%20the%20file%20as%20a%20%22CSV%20UTF-8%20(Comma%20delimited)%22%20instead%20of%20%22CSV%20(Comma%20delimited)%22.%26nbsp%3B%20Once%20I%20changed%20to%20the%20standard%20CSV%20format%20the%20import%20worked%20fine.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-833096%22%20slang%3D%22en-US%22%3ERe%3A%20Bulk%20import%20members%20-%20None%20of%20your%20contacts%20have%20an%20xyz.onmicrosoft.com%20address%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-833096%22%20slang%3D%22en-US%22%3EFeeling%20quite%20the%20dummy%20right%20now%20%3AD.%20Resaved%20the%20csv%20in%20CSV%20instead%20of%20CSV%20UTF-8%20and%20bam%2C%20addresses%20are%20there.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20Jeffrey!%3C%2FLINGO-BODY%3E
Contributor

Hi

 

I am struggling a bit with bulk importing members via CSV. I created the CSV with the "E-Mail" header and put some e-mail addresses in to test. I entered their primary SMTP address.

When I click the preview button, Yammer tells me none of the contacts have an xyz.onmicrosoft.com email address even though, when you look at their Exchange details, they all have one as an alias defined on their account.

Even when I change the 'real domain' in the CSV with the .onmicrosoft.com domain, the same error pops up.

 

These users are already in the Yammer network and are already members of several other Yammer groups so this strikes me as a very strange error :)

 

Has anyone else encountered this before?

3 Replies
best response confirmed by Steve Hernou (Contributor)
Solution

@Cedric OSTER @Steve Hernou  - A little late to the party, but for me, I received the same error today and I saw my mistake was initially saving the file as a "CSV UTF-8 (Comma delimited)" instead of "CSV (Comma delimited)".  Once I changed to the standard CSV format the import worked fine.

Feeling quite the dummy right now :D . Resaved the csv in CSV instead of CSV UTF-8 and bam, addresses are there.

Thanks Jeffrey!