SOLVED

Document Management - get the metadata of the document after Moveing Documents from one doc library

%3CLINGO-SUB%20id%3D%22lingo-sub-851621%22%20slang%3D%22en-US%22%3EDocument%20Management%20-%20get%20the%20metadata%20of%20the%20document%20after%20Moveing%20Documents%20from%20one%20doc%20library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-851621%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Experts%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20requirement%20which%20i%20am%20struggling%20from%20last%20few%20days.%3C%2FP%3E%3CP%3EThe%20requirement%20is%20as%20follows%3A%3C%2FP%3E%3CP%3EScenario%20%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20SharePoint%20online%2C%20i%20have%20hub%20site%20and%20under%20the%20hub%20site%20i%20have%202%20associated%20sites(Team%20site%20or%20Community%20Site).%3C%2FP%3E%3CP%3EUnder%20each%20associated%20site%20%2C%20i%20have%201%20document%20Library%20each-%20Say%20DocLib%20A%20and%20DocLib%20B.%3C%2FP%3E%3CP%3EIn%20both%20the%20site%20the%20Document%20ID%20service%20feature%20is%20enabled.%3C%2FP%3E%3CP%3EInitially%20both%20the%20document%20libraries%20have%20identical%20schema%20(say%20%22Title%22%2C%20%22Name%22%2C%20%22Category%22%2C%20%22Document%20ID%22)%3C%2FP%3E%3CP%3ENow%20i%20upload%20a%20document%20in%20one%20of%20the%20document%20library%20DocLib%20A%20of%20a%20site%20and%20added%20the%20values%20in%20properties%20or%20metadata%20of%20the%20document.%3C%2FP%3E%3CP%3EAfter%20adding%20i%20get%20the%20document%20ID%20which%20is%20unique%20from%20Document%20ID%20Service%20feature.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20i%20Move%20the%20document%20from%20DocLib%20A%20document%20library%20of%20one%20associated%20site%20to%20Another%20DocLib%20B%20document%20library%20of%20another%20associated%20site.%20Since%20the%20schemas%20or%20structures%20are%20identical%2C%20all%20the%20values%20of%20Properties%20get%20mapped%20into%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20i%20added%20a%20new%20column%20in%20the%20DocLib%20B%20and%20added%20the%20value%20into%20it.%20Then%20i%20again%20moved%20back%20from%20DocLib%20B%20to%20DocLib%20A.%3C%2FP%3E%3CP%3EHere%2C%20since%20the%20schemas%20are%20not%20identical%20(newly%20added%20column%20are%20not%20added%20in%20Doc%20Lib%20A)%2C%20the%20value%20of%20newly%20added%20column%20of%20DocLib%20B%20is%20not%20moved%20or%20not%20viewed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20that%20i%20again%20moved%20the%20item%20from%20DocLib%20A%20to%20DocLib%20B%20the%20value%20which%20i%20added%20gets%20restored.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20my%20question%20is%20where%20the%20values%20of%20the%20properties%20gets%20stored%20in%20SharePoint%2C%20against%20the%20Documeni%20ID.%20Can%20i%20get%20all%20the%20metadata%20of%20the%20document%20with%20respect%20to%20Document%20ID%3F%20If%20yes%20how%20can%20we%20get%20the%20same.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20and%20Regards%3C%2FP%3E%3CP%3EAsesh%20Maity%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-851621%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-853896%22%20slang%3D%22en-US%22%3ERe%3A%20Document%20Management%20-%20get%20the%20metadata%20of%20the%20document%20after%20Moveing%20Documents%20from%20one%20doc%20libr%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-853896%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F235568%22%20target%3D%22_blank%22%3E%40Asesh%20Kumar%20Maity%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3ELooks%20like%20this%20is%20just%20standard%20property%20promotion%20%2F%20property%20demotion%20at%20work.%3C%2FP%3E%3CP%3EThe%20SharePoint%20column%20values%20are%20also%20stored%20in%20certain%20file%20types%20such%20as%20docx%2C%20xlsx%2C%20tiff%2C%20...%3CBR%20%2F%3ESo%20when%20a%20file%20moves%20to%20another%20library%20the%20property%20promotion%20will%20extract%20the%20values%20from%20the%20file%20and%20capture%20them%20into%20the%20columns%20in%20that%20library.%3CBR%20%2F%3E%3CBR%20%2F%3EDid%20you%20use%20an%20Office%20file%20(e.g.%20docx%2Fxlsx%2Fpptx)%3F%3CBR%20%2F%3E%3CBR%20%2F%3EA%20quick%20check%3A%20repeat%20the%20same%20steps%20with%20a%20pdf%20or%20zip%20file.%20The%20property%20promotion%2Fdemotion%20does%20not%20support%20pdf%20or%20zip%20files.%3C%2FP%3E%3CP%3EPaul%20%7C%20SLIM%20Applications%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Dear Experts,

 

I have a requirement which i am struggling from last few days.

The requirement is as follows:

Scenario :

 

In SharePoint online, i have hub site and under the hub site i have 2 associated sites(Team site or Community Site).

Under each associated site , i have 1 document Library each- Say DocLib A and DocLib B.

In both the site the Document ID service feature is enabled.

Initially both the document libraries have identical schema (say "Title", "Name", "Category", "Document ID")

Now i upload a document in one of the document library DocLib A of a site and added the values in properties or metadata of the document.

After adding i get the document ID which is unique from Document ID Service feature.

 

Now i Move the document from DocLib A document library of one associated site to Another DocLib B document library of another associated site. Since the schemas or structures are identical, all the values of Properties get mapped into it.

 

Now i added a new column in the DocLib B and added the value into it. Then i again moved back from DocLib B to DocLib A.

Here, since the schemas are not identical (newly added column are not added in Doc Lib A), the value of newly added column of DocLib B is not moved or not viewed.

 

After that i again moved the item from DocLib A to DocLib B the value which i added gets restored.

 

Now my question is where the values of the properties gets stored in SharePoint, against the Documeni ID. Can i get all the metadata of the document with respect to Document ID? If yes how can we get the same.

 

Thanks and Regards

Asesh Maity

 

 

1 Reply
best response confirmed by Asesh Kumar Maity (Contributor)
Solution

@Asesh Kumar Maity 
Looks like this is just standard property promotion / property demotion at work.

The SharePoint column values are also stored in certain file types such as docx, xlsx, tiff, ...
So when a file moves to another library the property promotion will extract the values from the file and capture them into the columns in that library.

Did you use an Office file (e.g. docx/xlsx/pptx)?

A quick check: repeat the same steps with a pdf or zip file. The property promotion/demotion does not support pdf or zip files.

Paul | SLIM Applications