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

kumaraveln over 9 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

0 kumaraveln over 9 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
0 kumaraveln over 9 years ago

...o=, 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 -

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:
My output excel had values for only "totalCommitment" column as that is not inside another cdt.

If this plugin doesnt support nested...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 kumaraveln over 9 years ago

... cdt inputs please suggest me an workaround.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 kumaraveln over 9 years ago

If this plugin doesnt support nested cdt inputs please suggest me an workaround.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 9 years ago

Hi Kumaraveln, Yes you are right that this plugin doesn't support a nested cdt. Please find the attached file and let me know if you have any follow up questions.
Export cdt to excel.txt
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 kumaraveln over 9 years ago

Thanks sikhivahans. I quickly went through this and got your logic. Will implement and update this post.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 9 years ago

Sure, Np.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 kumaraveln over 9 years ago

It worked good. Thanks a lot for your time in giving this solution. I hope it is also possible to modify the plugin to support nested cdt. Will give a try sometime later.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 9 years ago

Np, anytime..
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel