Home

Auto populating columns

%3CLINGO-SUB%20id%3D%22lingo-sub-693702%22%20slang%3D%22en-US%22%3EAuto%20populating%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-693702%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20take%20old%20cluttered%20hard%20drives%20and%20upload%20them%20onto%20a%20SharePoint%20site%20that%20is%20easily%20searchable%20for%20others%20in%20the%20company.%20Is%20there%20a%20way%20I%20can%20do%20something%20in%20SharePoint%20that%20would%20allow%20me%20to%20upload%20a%20document%20in%20to%20a%20library%20and%20have%20it%20automatically%20populate%20columns%20with%20metadata%20from%20the%20file%20like%20dates%2C%20titles%2C%20author%2C%20etc.%20I'm%20also%20wondering%20if%20there%20is%20a%20way%20i%20can%20automatically%20generate%20tags%20for%20these%20docs%20to%20make%20them%20easier%20to%20find%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-693702%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-693759%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20populating%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-693759%22%20slang%3D%22en-US%22%3EYou%20can%20upload%20documents%20in%20SharePoint.%20While%20uploading%2C%20it%20would%20take%20few%20metadata%20automatically%2C%20name%2C%20created%20date%20and%20created%20by%20as%20person%20uploading%20it.%20Depending%20on%20the%20version%20of%20SharePoint%20you%20are%20using%2C%20we%20are%20write%20a%20utility%20to%20make%20changes%20to%20metadata.%20Additionally%2C%20the%20utility(powershell)%20could%20also%20be%20used%20to%20tag%20documents%20initially.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-694439%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20populating%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-694439%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360674%22%20target%3D%22_blank%22%3E%40jdelong%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Jdelong%2C%3C%2FP%3E%3CP%3EFirst%20of%20all%3A%20smart%20move%20to%20consolidate%20the%20data%20into%20a%20single%20environment.%3C%2FP%3E%3CP%3EYou%20have%20several%20options%3A%3CBR%20%2F%3Ea.%20Use%20the%20OOTB%20%22Open%20with%20Explorer%22%20(using%20IE)%20or%20the%20SharePoint%20Online%20Modern%20view%20to%20upload%20complete%20folder%20structures.%3CBR%20%2F%3EYou%20end%20up%20with%20new%20creation%2Fmodification%20dates%20and%20the%20metadata%20can%20only%20be%20extracted%20from%20Office%20files.%3C%2FP%3E%3CP%3Eb.%20Use%20the%20Microsoft%20Migration%20tool%20(%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepointmigration%2Fintroducing-the-sharepoint-migration-tool%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepointmigration%2Fintroducing-the-sharepoint-migration-tool%3C%2FA%3E)%3CBR%20%2F%3EThis%20is%20a%20free%20tool.%20The%20metadata%20extraction%20is%20again%20very%20limited.%3C%2FP%3E%3CP%3Ec.%20Use%20Enterprise%20migration%20tools%20(see%20%3CA%20href%3D%22https%3A%2F%2Fdirectory.collab365.community%2Foffice365-sharepoint%2Fbest-sharepoint-migration-tools%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdirectory.collab365.community%2Foffice365-sharepoint%2Fbest-sharepoint-migration-tools%2F%3C%2FA%3E)%3CBR%20%2F%3EThese%20tools%20provide%20rich%20functionality%20to%20retain%20original%20modify%20dates%20or%20permissions.%20The%20ability%20to%20extract%20metadata%20from%20the%20document's%20various%20between%20the%20tools.%3C%2FP%3E%3CP%3Ed.%20Use%203rd%20party%20apps%20that%20provide%20metadata%20extraction%20capabilities%20(e.g.%20%3CA%20href%3D%22http%3A%2F%2Fwww.slimapplications.com%2Fproduct%2Fexplorer%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.slimapplications.com%2Fproduct%2Fexplorer%2F%3C%2FA%3E)%3CBR%20%2F%3EThe%20apps%20provide%20functionality%20to%20extract%20metadata%20from%20various%20types%20(Office%2C%20emails%2C%20PDFs%2C%20images%2C%20audio%20files%2C%20video%20files%2C%20...)%20during%20uploading.%3CBR%20%2F%3Ee.%20Use%20ODFB%20sync%20client%3CBR%20%2F%3EThough%20it%20allows%20uploading%20of%20files%20it%20does%20not%20support%20metadata.%26nbsp%3B%3C%2FP%3E%3CP%3EPaul%20%7C%20SLIM%20Applications%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
jdelong
Occasional Visitor

I am trying to take old cluttered hard drives and upload them onto a SharePoint site that is easily searchable for others in the company. Is there a way I can do something in SharePoint that would allow me to upload a document in to a library and have it automatically populate columns with metadata from the file like dates, titles, author, etc. I'm also wondering if there is a way i can automatically generate tags for these docs to make them easier to find?

2 Replies
You can upload documents in SharePoint. While uploading, it would take few metadata automatically, name, created date and created by as person uploading it. Depending on the version of SharePoint you are using, we are write a utility to make changes to metadata. Additionally, the utility(powershell) could also be used to tag documents initially.

@jdelong 

Hi Jdelong,

First of all: smart move to consolidate the data into a single environment.

You have several options:
a. Use the OOTB "Open with Explorer" (using IE) or the SharePoint Online Modern view to upload complete folder structures.
You end up with new creation/modification dates and the metadata can only be extracted from Office files.

b. Use the Microsoft Migration tool (https://docs.microsoft.com/en-us/sharepointmigration/introducing-the-sharepoint-migration-tool)
This is a free tool. The metadata extraction is again very limited.

c. Use Enterprise migration tools (see https://directory.collab365.community/office365-sharepoint/best-sharepoint-migration-tools/)
These tools provide rich functionality to retain original modify dates or permissions. The ability to extract metadata from the document's various between the tools.

d. Use 3rd party apps that provide metadata extraction capabilities (e.g. http://www.slimapplications.com/product/explorer/)
The apps provide functionality to extract metadata from various types (Office, emails, PDFs, images, audio files, video files, ...) during uploading.
e. Use ODFB sync client
Though it allows uploading of files it does not support metadata. 

Paul | SLIM Applications

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies