Excel Tools: Export CDT to Excel smart service can't be found under Integration Services Excel Tools

Question

I have downloaded and deployed the latest version of the plugin (2.0.2) and found that I am unable to select the Export CDT to Excel smart service. The icon seems to be missing from the palette. Switching back to version 2.0.0 brings it back again. 
 Has anyone else encountered this issue with 2.0.2 and was able to resolve it?

harishkumart · Accepted Answer

Hi, We also had the same problem previously and got to know that there was some sort of race condition in the export cdt to exel which is causing load on appian server so the smart service is depricated and will not be available to configure it anymore. How ever the process models that have the smart service already used will continue to execute. You will not be able to find this smart service in your pallete. Instead we have to use export sql to Excel smart service now on. If you see the snapshot below. You can see that this smart service is depricated in version 2.0.2

Mike Schmitt · Answer

Apparently, version 2.0.2 of this plug-in has deprecated the CDT to Excel smart service for reasons not given (perhaps the aforementioned race condition). 
 Per the Shared Components Record : 
 
 The official AppMarket page for this plug-in is here . I suggest, for anyone else who requires the CDT to Excel node to remain available, drop by and leave a comment there also. 
 This is also very dismaying to me, as I have several places where I require to use this smart service, and was looking forward to upgrading some of my legacy uses to the (relatively recent) updated version that allows word wrapping to be preserved. 
 And to clarify, I use Export CDT to Excel for use cases that are NOT handled by either Export SQL to Excel or Export Data Store Entity to Excel . My primary issue with these is that the export requires data to be exported as-is to Excel straight from a database table or view, but in many cases I require the ability to transform one or more columns (convert usernames to user full names, convert awkward datetimes to sortable-formatted datestamps, etc etc).

Excel Tools: Export CDT to Excel smart service can't be found under Integration Services > Excel Tools

Top Replies