I am using the "Export CDT to Excel" smart service. My CDT has nested

kumaraveln over 10 years ago

I am using the "Export CDT to Excel" smart service. My CDT has nested cdts (upto 1 level). Will this plugin work for nested cdt type. I tried below two options.

Input 1:
CDT - <<myCdtStructure>> [id=, transactionId=, clientRequestInfo=[id=, transactionId=, borrowerName=Xennon, obligorNumber=78, obligationNumber=, crCrmNumber=78, moodysNumber=, decisionMatrixDate=, office=, costCenter=], clientLoanInfo=, totalCommitment=209, templateInfo=, templateCmntsInfo=, sasResponseInfo=[id=, transactionId=, overallRating=2.8, prior=, trend=, policyExceptionComments=], underwriterInfo=[id=, transactionId=, preparedBy=Kevork Oflazian, preparedDate=7/11/2014, reviewedBy=, reviewedDate=7/11/2014, exceptionType=, finalDisposition=, decisionBy=]]

cdt_fields_to_export - {"clientRequestInfo.borrowerName","clientRequestInfo.obligorNumber","clientRequestInfo.crCrmNumber","underwriterInfo.preparedBy","underwriterInfo.preparedDate","sasResponseInfo.overallRating","underwrit...

Discussion posts and replies are publicly visible

Parents

0 kumaraveln over 10 years ago

...erInfo.reviewedDate","totalCommitment"}

Cell_keys - {"A1","B1","C1","D1","E1","F1","G1","H1","I1"}
Cell_value - {"Borrower Name","Obligor Number","CR/CRM Number","Prepared By","Prepared Date","Overall Rating","Reviewed Date","Total Commitment"}

document_name_to_create - Name of the Excel document to create
Document_save_directory - Folder where the document should be saved into
Document_to_overwrite -
Excel_base_template - Empty excel file (.xlsx).
Fail_on_error - true
include_header_row - true
sheet_number - 0
Starting_cell -

Result 1:
The following error was raised by the Export to Excel function: java.lang.Throwable: The input fields does not match the fields in the CDT

Input 2:
CDT - <<myCdtStructure>> [id=, transactionId=, clientRequestInfo=[id=, transactionId=, borrowerName=Xennon, obligorNumber=78, obligationNumber=, crCrmNumber=78, moodysNumber=, decisionMatrixDate=, office=, costCenter=], clientLoanInfo=, totalCommitment=209, templateInf...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 kumaraveln over 10 years ago

...erInfo.reviewedDate","totalCommitment"}

Cell_keys - {"A1","B1","C1","D1","E1","F1","G1","H1","I1"}
Cell_value - {"Borrower Name","Obligor Number","CR/CRM Number","Prepared By","Prepared Date","Overall Rating","Reviewed Date","Total Commitment"}

document_name_to_create - Name of the Excel document to create
Document_save_directory - Folder where the document should be saved into
Document_to_overwrite -
Excel_base_template - Empty excel file (.xlsx).
Fail_on_error - true
include_header_row - true
sheet_number - 0
Starting_cell -

Result 1:
The following error was raised by the Export to Excel function: java.lang.Throwable: The input fields does not match the fields in the CDT

Input 2:
CDT - <<myCdtStructure>> [id=, transactionId=, clientRequestInfo=[id=, transactionId=, borrowerName=Xennon, obligorNumber=78, obligationNumber=, crCrmNumber=78, moodysNumber=, decisionMatrixDate=, office=, costCenter=], clientLoanInfo=, totalCommitment=209, templateInf...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data