Has anyone used the "Export CDT To Excel" document generation smart se

Yes, I got the export function to work. If I remember correctly it was all in the configuration of the node.

Inputs: CDT is required, Cdty_fields_to_export is required here is mine ={"wrid","submittername","submitdate","projectedstartdate","projectedlaunchdate","actuallaunchdate","workrequeststatus","projectstatus","projectmanagerid","product","workrequesttype","categorypriority","phase","description","title","theme","organizationalpriority","category","grouptag"}, document_name_to_create is required, document_save_directory is required, Excel_base_template is required (see attached), Sheet_number is required I set mine to 0. Also, on the output I have a rule that creates a link for me to retrieve the document.

export template.xlsx

Can we have multiple CDT as input? In our requirement we need to show 65 columns. So in our standards we cant have more than 50 .

Can we have multiple CDT as input? In our requirement we need to show 65 columns. So in our standards we cant have more than 50 .

Hi Souvik,

AFAIK , "Export CDT to Excel" won't allow multiple cdt.

1) Simplest way is to construct a flat cdt(Temporary cdt) with fields from 2 or more cdt's. (As this is not a transactional table nor we are writing to DB, no need to limit the fields to the standards).

 

Thanks

Siva Chimata