Excel Tools

We've just upgraded Excel Tools to the latest version (2.2.5) from 2.2.4 and shortly thereafter the STDOUT logs have been filling up with the following message:- 

ERROR: Bundle com.appiancorp.ps.exceltools [56] Unable to get module class path. (java.lang.NullPointerException)
java.lang.NullPointerException

Has anyone seen this before, know what it means and how to resolve? 

Running 19.2 on AppianCloud.  

Hi - check the comments above as the lack of the functionality has proven an issue for other practitioners for a while now. No ideal direct replacement exists unless you can use some of the out of the box functionality to achieve your use case. 

is "Parse Excel to CDT" service not available in v19.1? if not what is it's alternative?

For the Export Data Store Entity to CSV, can we have an input parameter for the field to sort on?  In addition, can this field be one of the fields that is not in the selection.

Import CSV to Database (Smart Service) is failing to correctly parse fields containing commas 

Hi Brianc,

Yes I am also having this issue, that function is not displaying for me anymore

How do I find the documentation to configure the plugin? I am using the plugin in Appian Cloud. I downloaded the JAR but haven't found a PDF yet (unless its lurking inside a JAR, inside the JAR...) - looking for details on how to configure Import CSV to Database v4 - thanks!

What base product functionality reproduces Export CDT to Excel?  With it, I was able to have a data set pre-loaded in a process variable and then transform certain columns as necessary for friendlier display - i.e. translating messy-looking dateTime columns into just a date in the customer's preferred date format, or taking bare usernames and translating those to their full name, etc... all while writing to a pre-formatted template with customized column widths and filtering applied to the column headers, as well as a cover sheet listing metrics like date generated and filters elected by the user.   Is there new base product functionality that reproduces this that we haven't been told about yet?

We have a complex query that changes based on date and result need to be in excel. I used "Export SQL to Excel" for similar functionality on many applications. Now that it's deprecated I do not want to use in on my current new application. What's the replacement functionality for deprecated "Export SQL to Excel"?

Hello April Schuppel  

I encountered a limitation with the base product services whereby it cannot export with more than 50 columns.

community.appian.com/.../export-to-csv-with-more-than-50-columns

Thanks,

Mat