Adding a document to a row programmatically

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello,using the following code,i'm trying to add a document to a table; however i can not see anything added in document management.The code also doesn't give any errors, any ideas how to resolve it ?

    DocuRef docuRef;
    DocuActionArchive archive;
    
    erm_OperationInstructions oprinst;
    

    Name _name = "C:\\test.txt";
    
    
    select firstOnly * from oprinst where oprinst.OperationId == 'OP0001002';
    
    
    try
    {
        ttsBegin;
        
        docuRef.clear();
        docuRef.RefRecId = oprinst.RecId;
        docuRef.RefTableId = tableNum(erm_OperationInstructions);
        docuRef.RefCompanyId = curext();
        docuRef.Name = "testfile";
        docuRef.TypeId = 'FILE';
        docuRef.insert();
        archive = new DocuActionArchive();
        archive.add(docuRef, _name);          
        
        ttsCommit;
    }
    catch(Exception::Error)
    {
        info(strfmt("%1",Exception::Error));

    }

*This post is locked for comments

All responses (3)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report
RE: Adding a document to a row programmatically

Hey all,with the following code,it works:

ttsbegin; docuref.TypeId = "TYPEIV"; docuref.Name = _name; docuref.Notes = docuRef.Notes; docuRef.Restriction = DocuRestriction::Internal; docuref.RefCompanyId = curext(); docuref.RefTableId = tablenum(OperationInstructions); docuref.RefRecId = oprinst.RecId; docuref.insert(); docuvalue.initValue(); docuvalue.insert(); docuref.ValueRecId = docuvalue.RecId; docuref.update(); docuvaluerecid = docuvalue.RecId; select forupdate docuvalue where docuvalue.recid == docuvaluerecid; docuvalue = docuvalue::writeDocuValue(docuref,_name+".xlsx"); ttscommit;
Suggested answer

Brandon Wiese 17,788 on at

Like (0)

Report

RE: Adding a document to a row programmatically

Set a breakpoint in the DocuActionArchive\add() method and follow the execution path. Depending on how your Document type of FILE is setup in your system, many things could be going wrong. Some of the errors that can occur would not be caught by a catch(Exception::Error) either, so there might not be any visible results. The UI has a nasty habit of not surfacing CLR or COM errors, for example, like it does X++ errors.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Adding a document to a row programmatically

Have you looked into DocuRef table and verify whether the records are created there ?