--- title: "Comment by Danny on \"Data Migration/Extraction from Autodesk Vault\" | Hashnode" description: "Hello Andrew, Could you please help me with the following question? Fileassciation table has links between files and when I open some physical files randomly mo" url: "https://hashnode.com/posts/data-migrationextraction-from-autodesk-vault/6242a0a5db84f8c50fa5ba53/comment/642ab53183927af52f35c11a" --- [Discussion](https://hashnode.com/posts/data-migrationextraction-from-autodesk-vault/6242a0a5db84f8c50fa5ba53) Comment [Data Migration/Extraction from Autodesk Vault](https://hashnode.com/posts/data-migrationextraction-from-autodesk-vault/6242a0a5db84f8c50fa5ba53) [Danny](https://hashnode.com/@danny448) [Apr 3, 2023](https://hashnode.com/posts/data-migrationextraction-from-autodesk-vault/6242a0a5db84f8c50fa5ba53/comment/642ab53183927af52f35c11a) Hello Andrew, Could you please help me with the following question? Fileassciation table has links between files and when I open some physical files randomly most of them are in sync( meaning both fileassociation table and physical file have same links). But I noticed few file assembly files have child objects but these were not present in fileassociation table. What could be the reason for it or where can I find all the links correctly? Also I tried to read Bomblob field of fileiteration table but I couldn't see anything related to child ids [Andrew B](https://hashnode.com/@abowden) [Apr 19, 2023](https://hashnode.com/posts/data-migrationextraction-from-autodesk-vault/6242a0a5db84f8c50fa5ba53/comment/642ab53183927af52f35c11a#reply-643f911163692ff13574951c) Hi Danny, are you trying to determine the BOM using the fileassociation table? See my above answer to Joshi about fetching the BOM data from the FileIteration table in the BOMBlob field. Processing the XML data from that was the only reliable way I found to get the data matching up against what Inventor showed (You'll likely need to look at the XRefId for the child record) This is an example of the Components section of the XML from an assembly: This translates to: -BOM item #2 (CompId) -ChildID (FileIteration.FileIterationId from DB) of 868932