OneDrive migration

[itgeek]

Hi,

 

I am planning moving all student home areas to OneDrive. I have had a look at the Microsoft SharePoint Migration Tool and ran a manual test and can confirm that this works. In regards to the bulk migration I understand you can use an excel csv to do this, however how do I get all the students OneDrive locations and mapping to the users home folders? Is this the best way or have others used anything else?

 

Thanks

[djm968]

Have a look at this.

 

https://learn.microsoft.com/en-us/sharepointmigration/how-to-format-your-csv-file-for-data-content-migration

 

The lines in the CSV file will look something like this, and all lines will follow the same structure, with the exception of the %username% variables, these will be unique for each user.

 

\\sharedfolder\homedrives\%username%,,,https://yourdomain-my.sharepoint.com/personal/%username%_yourdomain_com/,DocLibraryName,DocLibraryName_subfolder

Edited October 18, 2024 by djm968

[Bumhug360]

Be aware you will need a lot of free space on the C drive of the machine you are running it on (150GB minimum seems to be a good place to start) when going the csv route as it creates lots of temporary files.

 

Have used it loads of times and never had an issue so would certainly recommend

[jtotheb]

Hi,

In regards to the bulk migration I understand you can use an excel csv to do this, however how do I get all the students OneDrive locations and mapping to the users home folders? Is this the best way or have others used anything else?

 

Another Microsoft option is Migration Manager which is driven from 365 with an on-premise agent that does the data moving rather than it being an application like SPMT. The big plus is you can have multiple migration agents installed (assuming you have the resources) to really shift the data up into OneDrive. The end result is the same though.

 

https://medium.com/@serenisoft/understanding-the-differences-between-migration-manager-and-sharepoint-migration-tool-spmt-for-72d43e0c3d75

 

It was a bit quick and dirty but I used some really basic Excel concatenate action to build my source Homefolder UNC paths and target OneDrive URLs and then put those into the Upload Template CSV from Migration Manager (which looks near enough identical to the SPMT one).