@V_THAKARE wrote:
Hello
HelesicPetr and jbailey.
What Kind of data I can see in WBMFF MissingLinkReport.csv?
Do you have any document for reference with example.
Also,How below table are linked with each other in DB and their Purpose.
--> CONTENTMETADATA
--> EPMASSTORED
--> EPMFTPROP
--> EPMVARIANTLINK
--> EPMSEPFTPRIVATE
--> EPMMEMBERLINK
--> EPMREFERENCELINK
--> EPMCONTAINEDIN
--> EPMDOCUMENTMASTER
--> EPMDOCUMENT
--> ATT_EPMDOCUMENT
--> MigrationSourceSite
Need your suggestion.
Hello,
Let’s address your questions step by step:
WBMFF MissingLinkReport.csv:
The WBMFF MissingLinkReport.csv is generated during the Windchill Bulk Migrator (WBM) process. It provides information about missing links or associations between objects during data migration.
Unfortunately, I don’t have a specific example or reference document for this report. However, you can refer to the PTC Community for discussions related to WBMFF and any available documentation.
Table Relationships in the Database:
Understanding how tables in a database relate to each other is crucial for data integrity and efficient querying.
Let’s explore the relationships between the tables you mentioned:
CONTENTMETADATA: Contains metadata related to content (documents, files, etc.).
EPMASSTORED: Stores information about attachments and their storage locations.
EPMFTPROP: Holds properties associated with files.
EPMVARIANTLINK: Manages relationships between different variants of an object.
EPMSEPFTPRIVATE: Specific to Windchill, but its purpose is not clear from the name alone.
EPMMEMBERLINK: Handles membership relationships (e.g., parts within an assembly).
EPMREFERENCELINK: Represents references between objects.
EPMCONTAINEDIN: Defines containment relationships (e.g., parts within a product).
EPMDOCUMENTMASTER: Contains master information about documents.
EPMDOCUMENT: Stores document-specific data.
ATT_EPMDOCUMENT: Likely related to attachments for documents.
MigrationSourceSite: Indicates the source site during migration.
Each table serves a specific purpose, and their relationships allow you to query and manipulate data effectively.
Hope this will help you.
Best regards
Florence Gayhart
