Adding a document to a row programmatically

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (3)

Answers (0)

Community Member 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 ?

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No
Community Member 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;

Was this reply helpful? Yes No

Community site session details

Adding a document to a row programmatically

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Adding a document to a row programmatically

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates