As part of my organisation's move to SharePoint, I have been given the task of setting up a SharePoint site for my team as well as migrating my team's shared network drive.
Luckily, the folder structure on the shared drive is already fairly well organised, and I have been able to write a Python script which uses the full file path to automatically associate metadata tags ("Contract", "Month", "Year", "Person", "Travel", "Budget"...) with each file.
My aim is to set up one SharePoint library for our team which will allow users to access information easily and quickly using metadata search, without having to navigate through a complicated folder hierarchy. Since I am new to SharePoint, my questions are
1) Is this approach feasible / recommended?
2) Assuming I have some form of structured text file whose entries are network share file paths and their associated metadata, what would be the best way to migrate these files to the SharePoint site automatically?