Skip to main content
M
m.ditodaro4-Participant
4-Participant
July 28, 2023
Solved

Bulk Migrator loading "Described by Document"

  • July 28, 2023
  • 1 reply
  • 1941 views

Hi everyone,

we are uploading documents exported from another pdm (being deleted...) using a mass migration tool developed by an external company.

 

I have to check if all the documents (pdf,doc,...) are really loaded in db.

I just found some documents not uploading and I don't know why.

do i just need a SELECT * FROM WTPARTMASTER, WTPART, ...?

to check if all documents have been imported and try to upload them again.

 

Thanks for any help!

 

 

Best answer by avillanueva

No, that's the wrong class/table. If you know the numbers of the documents you are checking to be there, then you can export all numbers and compare offline to find what's missing. If number of documents is less than 1000, you can add those numbers to your query.

SELECT WTDOCUMENTNUMBER FROM WTDOCUMENTMASTER

that will get you all docs loaded. Should not matter the version/iteration.

You could also check for specific numbers like this:

SELECT WTDOCUMENTNUMBER FROM WTDOCUMENTMASTER

WHERE WTDOCUMENTNUMBER IN ('DOC1','DOC2','DOC3' ....)

1 reply

avillanueva
23-Emerald I
avillanueva23-Emerald IAnswer
23-Emerald I
July 28, 2023

No, that's the wrong class/table. If you know the numbers of the documents you are checking to be there, then you can export all numbers and compare offline to find what's missing. If number of documents is less than 1000, you can add those numbers to your query.

SELECT WTDOCUMENTNUMBER FROM WTDOCUMENTMASTER

that will get you all docs loaded. Should not matter the version/iteration.

You could also check for specific numbers like this:

SELECT WTDOCUMENTNUMBER FROM WTDOCUMENTMASTER

WHERE WTDOCUMENTNUMBER IN ('DOC1','DOC2','DOC3' ....)

    M
    m.ditodaro4-ParticipantAuthor
    4-Participant
    July 28, 2023

    the information used by the bulk migrator tools are the following

     

    P:\EIT_FILES\CAD_Files\001\-11\842\A_01001-11842A-01_0.pdf001-11842A-01A1ITA_PRODUCTPRODUCT/Default/0003_LINEE_STANDARD_SORMA99
    P:\EIT_FILES\CAD_Files\001\-11\842\A_01001-11842A-01_0.doc001-11842A-01A1ITA_PRODUCTPRODUCT/Default/0003_LINEE_STANDARD_SORMA99

     

    i need to check if the .pdf and .doc files are loaded  inquiring with WTPART/WTPARTMASTER code 001-11842A-01

     

    thanks

    avillanueva
    23-Emerald I
    avillanueva23-Emerald I
    23-Emerald I
    July 28, 2023

    There is two things. Looks like the migrator is loading the document and linking it to the WTPart. If the document does not exist, it cannot create the link. Check for the existence of those documents keying off third column (001-11842A-01 for example). It looks like both of those files are loaded to the same document. Remember, we are storing documents, not files. Many files can exist in one document. Strange, there is not an indicated which file is primary and which is secondary.

     

    wait, you are saying that the third column is the WTPart number? Or did you enable content on WTParts? Am I correct in assuming both of those files resolve to the same document?

    Terms & ConditionsCookie settingsAccessibility statement