Sync local folder of shortcuts to Sharepoint 2010 library

%3CLINGO-SUB%20id%3D%22lingo-sub-2778707%22%20slang%3D%22en-US%22%3ESync%20local%20folder%20of%20shortcuts%20to%20Sharepoint%202010%20library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2778707%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20company%20has%20a%20SP2010%20library%20with%20about%20500%20documents%20in%20it%2C%20across%20multiple%20folders.%20Unfortunately%2C%20we%20are%20unable%20to%20use%20the%20search%20function%20due%20to%20access%20restrictions%2C%20and%20we%20are%20not%20allowed%20to%20change%20our%20permissions%20to%20fix.%20(the%20site%20is%20not%20administered%20locally).%3C%2FP%3E%3CP%3EI%20have%20created%20an%20excel%20web%20query%20file%20which%20pulls%20all%20the%20file%20data%20into%20excel%2C%20and%20built%20a%20VBA%20macro%20to%20create%20a%20local%20folder%20of%20%22internet%20shortcuts%22%20to%20the%20sharepoint%20files%2C%20where%20the%20shortcut%20names%20reflect%20the%20files%20they%20target%2C%20and%20are%20obviously%20searchable%20through%20Windows%20Explorer%20Search%20function.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20the%20above%20is%20a%20pretty%20clunky%20way%20of%20synchronising%20a%20set%20of%20local%20shortcuts%20to%20the%20online%20files%2C%20but%20rather%20than%20do%20this%20the%20long%20way%2C%20is%20there%20something%20out%20there%20which%20could%20automatically%20synchronise%20the%20sharepoint%20library%20to%20a%20local%20folder%20of%20searchable%20shortcuts%20in%20real%20time%2C%20rather%20than%20me%20having%20to%20run%20this%20process%20manually%20whenever%20Sharepoint%20sends%20me%20an%20alert%20that%20something%20has%20changed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERemember%2C%20this%20is%20sharepoint%202010%2C%20so%20Flow%20(PA)%20won't%20work.%20Did%20SP2010%20have%20something%20similar%20to%20flow%20which%20might%20help%20me%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture.JPG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F312431iBDFC049F10F4FF73%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Capture.JPG%22%20alt%3D%22Capture.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2778707%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2010%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

My company has a SP2010 library with about 500 documents in it, across multiple folders. Unfortunately, we are unable to use the search function due to access restrictions, and we are not allowed to change our permissions to fix. (the site is not administered locally).

I have created an excel web query file which pulls all the file data into excel, and built a VBA macro to create a local folder of "internet shortcuts" to the sharepoint files, where the shortcut names reflect the files they target, and are obviously searchable through Windows Explorer Search function.

 

So the above is a pretty clunky way of synchronising a set of local shortcuts to the online files, but rather than do this the long way, is there something out there which could automatically synchronise the sharepoint library to a local folder of searchable shortcuts in real time, rather than me having to run this process manually whenever Sharepoint sends me an alert that something has changed.

 

Remember, this is sharepoint 2010, so Flow (PA) won't work. Did SP2010 have something similar to flow which might help me?

Capture.JPG

0 Replies