Forum Discussion

KSoree's avatar
KSoree
Copper Contributor
Feb 13, 2023
Solved

Re: Capturing document metadata from network location when copying to Sharepoint

Hi All,

 

We are moving our documents to Sharepoint and are hoping to retain information such as date created, author of document and other metadata when copying the file over. At the moment Sharepoint creates a copy with the meta data from the date of copying.

 

I've created a flow using Encodian's Auto tagging documents in SharePoint using Microsoft AI / Text Analytics which is good for drawing some of the content from the within the document but it's not the complete data we're looking for.

 

Has anyone encountered a similar challenge?

 

Many thanks

 

Kamil

  • Hi KSoree ,

    You could use the SharePoint Migration Tool (SPMT) to upload your files into SharePoint.


    That process will keep the created and last modified information and you can map local users to SharePoint users, so you keep the author.

    Best Regards,
    Sven

  • Paul de Jong's avatar
    Paul de Jong
    Iron Contributor

    KSoree 

    If you only need the created and last modified dates (from the operating system) and map the users then the SPMT as suggested by @SvenSieverding is the way forward.

    If you need advanced functionality like capturing properties in pdf files, location details from photos, email metadata, properties in Office files, create/modify dates stored within the documents (if the operating system dates are not useful) then you need to deploy special tools (example).

    Keep the process a simple as possible.

    • KSoree's avatar
      KSoree
      Copper Contributor

      SvenSieverdingThis worked a treat. Thank you. I only carried out a test on on roughly 20 or so documents, but the tool captured the relevant information.

      @PauldeJong we do have a range of files and so an assessment will need to be carried out to ascertain the variety of file types, so I may come back to your example at a later date.

      Many thanks
      Kam

  • SvenSieverding's avatar
    SvenSieverding
    Bronze Contributor

    Hi KSoree ,

    You could use the SharePoint Migration Tool (SPMT) to upload your files into SharePoint.


    That process will keep the created and last modified information and you can map local users to SharePoint users, so you keep the author.

    Best Regards,
    Sven

Resources