Vault data issue

[CG_10468982]

I am using Windchill Supplier Management Release 12.0 and Datecode with CPS 12.0.0.0

Could you please share with us the steps for copying the latest iteration of vault data?

[HelesicPetr]

Hello @CG_10468982 

What is your issue?

You can go to a database find the latest version of your object and find information about vault. 

and then just copy the file from a folder. 

select for EPMDocument to get vault information in MS SQL

select substring(convert(varchar(100),convert(varbinary(100), FVI.uniqueSequenceNumber, 256),2),3,14) vaultFileName,apData.idA3A5 as FvItem, apData.fileName ,MSTR.documentNumber, EPM.versionIdA2versionInfo,EPM.iterationIdA2iterationInfo, MSTR.CADName from wcuser.EPMDocument EPM 
INNER JOIN  wcuser.HolderToContent CONTENT
 ON CONTENT.idA3A5 = EPM.idA2A2
 inner join wcuser.ApplicationData apData
 ON apData.idA2A2 = CONTENT.idA3B5
 inner join wcuser.EPMDocumentMaster MSTR
 on MSTR.idA2A2 = EPM.idA3masterReference
 inner join wcuser.FvItem FVI
 on apData.idA3A5 = FVI.idA2A2

 where MSTR.CADName like 'ASSEMBLY123.asm' and EPM.latestiterationInfo=1

then just use CTRL+C , CTRL+V in the correct folder

Hope this can help

PS> for family table there is little bit different select

PetrH