In this article you will learn how to merge multiple CSV Files with same header using Windows PowerShell.
Currently, I am working on eRoom to SharePoint migration project with the help of Metalogix. Metalogix eRoom console has a feature to run pre-migration check to identify possible migration issues which could occur during migration that includes the following:
Identifying these possible issues is necessary so that you can plan for these failures by talking to end user. Metalogix eRoom console generate report of each of these issues based on source eRoom and target SharePoint site where the content will be migrated. These reports are generated in the form of .csv files. Every eRoom pre-migration check feature generates 4 such files. For us, we have to migrate approximately 230 eRoom to SharePoint 2010 environment. So we wanted to run pre-migration check to all of these 230 eRooms and generate consolidated report so that we can review it with business user. Now to combine these 230 csv files for every issue could take days and involve lot of manual efforts. To avoid those manual efforts, I decided to use Windows PowerShell which provides tons of cmdlets (command lets) which could do easy trick to avoid such manual efforts. I have created PowerShell function with the following: Accepts 3 parameters
Based on the path and filter criteria, it finds list of files to be merged.
Active Directory-222