cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

O365 data import using CSV files

ImIronMan
By Level 6 Flexeran
Level 6 Flexeran

Hello Experts

We are implementing O365 integration (2019R1), however customer raised concerns on the previleges required for the integration and asked a question if we can import the same data using CSV file with below details into FNMS . Can you please help if it is possible to import O365 data using csv file ? Any challenges ? Any alternatives ?

User Principal Name
Display Name
Deleted Date
Has Exchange License
Has OneDrive License
Has SharePoint License
Has Skype For Business License
Has Yammer License
Has Teams License
Exchange License Assign Date
OneDrive License Assign Date
SharePoint License Assign Date
Skype For Business License Assign Date
Yammer License Assign Date
Teams License Assign Date
Assigned Products

(1) Reply

A cumbersome way to approach this without using the productized O365 Adapter would be the following:

1) Import your purchase history for your O365 entitlements in the traditional manner

2) Create a Named User/Subscription license for these purchases for your active O365 Subscriptions

3) Taking a similar CSV, write a Business Adapter that would read this CSV/Excel spreadsheet and allocate the users to the proper O365 Named User license.

 

Kirk