Content Management and Capture

 View Only

  • 1.  CMOD DocumentID

    Posted Wed October 21, 2020 02:01 AM
    Hello,

    can you please advise me where DocumentId is stored in CMOD? Whether it is like in FileNet where it is stored in the DocVersion table.

    Thank you in advance


    ------------------------------
    Stanislav Kaiseršot
    ------------------------------


  • 2.  RE: CMOD DocumentID

    Posted Thu October 22, 2020 02:14 PM
    Stanislav,

    To get the docID one need to use the odwek java api method    odHit.getDocId( )

    ------------------------------
    NITISH
    ------------------------------

    Original Message


  • 3.  RE: CMOD DocumentID

    Posted Fri October 23, 2020 03:50 AM
    Hello Nitish,

    thank you for your reply. Is docID generated on the fly during odHit.getDocId( ) or it is saved somwhere in CMOD database ?
    Can customer use docID to store it into some integrated system and then use docID to get the concrete document from CMOD after some time?

    Regards,

    ------------------------------
    Stanislav Kaiseršot
    ------------------------------

    Original Message


  • 4.  RE: CMOD DocumentID

    Posted Tue November 03, 2020 09:01 AM
    Stanislav, CMOD V10.1 added support for Unique Document ID.

    Generates a unique identifier for every row loaded into OnDemand

    Configurable per application group

    String field of length 36 bytes

    Example:

      ac9223b3-f741-4608-ba92-749fda48d866

    If defined, then automatically generated during load

    If multiple rows to same document, each row has its own unique identifier

          Previously with ERM – such rows could not participate in ERM

    Only applies to new data loaded

    ------------------------------
    Bud Paton
    ------------------------------

    Original Message


  • 5.  RE: CMOD DocumentID

    Posted 27 days ago

    Hello everybody,

    I come back on this "old" ticket as I'm interested in.

    I'm using ODWEK ODApi 10.5.0.4 to search and get documents from OnDemand.

    Indeed, I get an (probable) unique ID from the document with com.ibm.edms.od.ODHit.getDocId() (on 218 characters of alphanumeric string m_docid attribute), and I can get the "physical" PDF document with com.ibm.edms.od.ODHit.retrieve (com.ibm.edms.od. ArsWWWInterface.apiRetrieve) thanks to this DocId.

    I suppose there is a link between its DocId and the "physical" PDF file stored on the server FileSystem ? But I don't manage to find it in the DB2 database of OnDemand:

    select agid,table_name from ARSSEG where agid=17260#

AGID        TABLE_NAME
----------  ------------------
17260       FKH2

    But no track of this ID in the database :

    select * from FKH2 where APPID="BLABLAARC"#

BDATE  IDATE       APPID           CCUST     CAGEN DOC_NAME    DOC_OFF     DOC_LEN     COMP_OFF    COMP_LEN    ANNOT         COMP_TYPE             RESOURCE    PRI_NID SEC_NID
------ ----------- --------------- --------- ----- ----------- ----------- ----------- ----------- ----------- ------------- --------------------- ----------- ------- ------- -------------------------------
18213  1576603980  BLABLAARC       REF123-5  001   976FAAA               0       27289           0       27289 x'55'         x'44'                           0       2       0

    Do you know where I can find it ?

    Thanks in advance

    Regards



    ------------------------------
    Manuel PAITREAULT
    ------------------------------

    Original Message


  • 6.  RE: CMOD DocumentID

    Posted 26 days ago

    Hello Manuel, 

    Re: I suppose there is a link between its DocId and the "physical" PDF file stored on the server FileSystem ?

    No. The Unique ID Field is optional. The Unique ID field contains a 36-byte unique identification string for each row in the database. It does not provide a physical link to the file system storage.

    Regards

     



    ------------------------------
    Neil Parrott
    Senior Product Manager
    IBM Content Services
    IBM Software

    ------------------------------

    Original Message


  • 7.  RE: CMOD DocumentID

    Posted 26 days ago

    Hello Neil,

    thanks a lot for your quick reply.

    My final goal is to extract unitarily all documents (with their metadata) from a specific Application Group with ARSDOC command or ODWEK java library. In order to re-import them in another system.

    I have also found the table sa2 which identifies (unitary document by document) each document loaded in OnDemand. In this table, there is a LOAD_ID attribute which looks to be a concatenation of AppGrpID-PRINID-SECNID-DOCNAME-Date-Date-AppID. But how to be sure this is a unique ID (in order to re-associate a physical file to its metadata) ?

    By using ODWEK, when I call ODFolder.search, I get a list of ODHit and each of them is identified (I don't know where and how) by a m_docid identifier which is an alpha-numeric ~200-characters string (probably unique and non ambiguous) :

    Do you know how ODWEK gets this m_docid identifier (somewhere in the DB2 database ? Or in live built ?) ?

    Because, it is this same m_docid  identifier which is used to download the PDF file from server :

    Thanks for your clarification



    ------------------------------
    Manuel PAITREAULT
    ------------------------------

    Original Message