User Profile
AdamAtTheMuseum
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Extract metadata from excel and add to document library in folders
Hello I have been given 30,000 construction project files. Lucky me? They have come to me in folders in the following folder structure: ContractorName\DocumentType and the document title. For example: JimTheBuilder\Drawings\Drawing1.dwg JimTheBuilder\Drawings\Drawing2.dwg JimTheBuilder\Drawings\Drawing3.dwg JimTheBuilder\Specifications\Spec1.doc JaneTheContractor\Drawings\Elevation1.dwg JaneTheContractor\Reports\Report.doc etc etc The client has placed them complete with folder structure in a Document Library called AllVersionsArchive The client has also given me an Excel file with Metadata for each file. One row for each file, all on one sheet. She wants me to find a way to add the metadata to every file in the document library. There are three "fields" that are the same in the folder structure and the metadata. Folders: ContractorName\DocumentType\fileName Excel: ContractorName\DocumentType\fileName The file names are unique and can be used as a Primary Key the Excel file has extra metadata: description, status, shortName, ReceivedDate, IssueNumber, revisionLetter Its the metadata in blue that I have to add to each file in each folder. As I see it I need to: Go through the Excel data row by row, for each file, find the matching file name in the SharePoint document library attach the metadata. I have some basic PowerAutomate experience and I am OK with PoweShell. But Im not a programmer and need some help and pointers as to where to start. I have Googled around of course but its the requirement to go recursively through the folders to find a match that defeats me. I was also considering converting the files and folders into just one flat Document Library containg the fileName, ContractorName and Document type. I could then perhaps mathch the metadata more easily? Any ideas? Adam.Win PE not working after an ADK update
Config Manager CB 2303 Yesterday I applied the latest ADK and all seemed to go OK but now I cant use WinPE to image any devices. The devices will boot into Win PE but will not get as far as the next step where we choose which task sequence to run. The device will just reboot. I have tried different models, all fail. I have rebooted the server (several times) I have re-installed the ADK and the WIN PE add-on and re-distributed to the DP. Every time I update the DP (we only have one) I get this error below. Note the second image. Can anyone tell me what the problem is? We are gradually moving away from MECM imaging but still need it pretty much daily. Thank you Adam.SharePoint online - search for documents containing #147 only
My manager would like to search SharePoint for only files that contain the phrase #147 (This is how some projects have been referred to in files in the past) I would have thought that using double quotes like "#147" would do that. But it seems not. If I search SharePoint for "#147" it will return every file with 147 in it. For example "Timetable for bus number 147" or a file with a figure such as £147 or $147 in it. How can I make SharePoint only return files with #147 in them? thanks in advance.
