Exporting Using CDT To Excel Format Plugin

Additional information, this is my plugin current values set. Thanks!

This guide helps a lot. The CDT to Excel section explains where you can specify which CDT fields to write to the excel file.

Export to Excel - Documentation.pdf

Hi johnrheyj,
The reason why you are getting the different output in your report than what is expected is because in your inputs of excel generation smart service, you have mapped inputs in both "cdt_fields_to_export" & "Cell Keys/Cell Values" - on account of which your both of these executed - so your cell keys and cell values renderes as expected, however it was because of the "cdt_fields_to_export" - the service renders the unwanted columns in the report as well as your CDT has that data in those fields.

In order to fix this - you don't need to map "cdt_fields_to_export" in your smart service configuration (leave this blank) and simply populate the correct/desired Cell Keys and its respective Cell Values which you want to populate in your generated report and that should work for you.

Please let us know if this helps or if you still face the similar issue.

Thanks!

Hi @akhiln,

Tried your suggestion but still no luck with it. Please see attached file output of the settings. I leave the parameter "cdt_fields_to_export" but it display all values in my CDT.

Hi Johnreyj - it seems this Export CDT to Excel smart service is not working as expected then. We can achieve the excel generation by other smart service as well present under this category as mentioned in the document attached by kevinn above - "Export Report to Excel" - in this you can try providing just the Cell Keys and Cell Values and see if this gives you the desired output which is expected.

Please let us know if this helps or if you still face the same issue.

Thanks !

@akhiln,

what I've tried was to remove the field from cdt_fields_to_export that was posting values to the others cell. cdt_fields_to_export was not entirely blank since when I tried this one the above notes happens. I guess need to double check it this will work continuously. Thanks for the advise!