Excel Tools

Question:  When using an excel template; is it possible to set the Word Wrap for a column so that when the spreadsheet is opened then the data from a paragraph field is wrapped in a column cell versus the default single line.?

Ben Dudley  - I just downloaded this plug-in today and the Readme file doesn't appear to have any documentation or examples related to the "Export CDT data to Excel" smart service. Can you assist with this? Thanks! JT

Hello, I am getting error below when deploying the plugin. I've deleted the old CDT. Kindly, please shed some light on the issue.

ERROR com.appiancorp.plugins.LoggingPluginEventListener - Failed to enable Plug-in 'com.appiancorp.ps.exceltools' (com.appiancorp.ps.exceltools) version 2.0.2: 'Could not create types for [class com.appiancorp.ps.exceltools.datatype.ExportableDataSubset]. Cause: An error occurred while trying to save the type information to the Appian data source. No types have been imported. Cause: Type definitions could not be found in the Appian data source for the following type ids: 110 (APNX-1-4166-003)

Same with previous posters, we were looking at migrating a lot of our functionality away from the older style deprecated plugs ins that the HEalthcheck has highlighted to use the Excel Tools functionality but the loss of the Export CDT to Excel smart service now prohibits that activity (if we wanted to use the up to date version of the plug in - bit of a catch 22 situation).  

For the CSV to database V3 smart-service, we have also found that the insert scripts from the CSV file for databases that use Schemas are generating incorrectly.

The insert scripts are generated like the below,

insert into [schema.tableName] (column1,colum2) values (value1,value2)  -- WRONG

But it should be generated as,

insert into [schema].[tableName] (column1,colum2) values (value1,value2) – CORRECT

Any chance this could be addressed in a future update?

Same with Mike Schmitt comment above, our project also make use of the Export CDT to Excel smart service quite heavily. Is there any plans underway for adding this back to the Excel Tools plugin?

Is there any particular reason the Export CDT to Excel functionality has apparently been removed as of the last update?  I rely on this smart service in a few different places in a few different projects, and want to be able to upgrade plug-in versions in the future without losing this ability.

For clarification, I use Export CDT to Excel for use cases which are NOT handled by Export DSE to Excel (such as reformatting data post-query before inserting into excel).

where do i get the latest jar ? please help

Th new version for Import CSV to database is not working , when we provide input name  -Table  with a schema name , it is not working  ,So when checked the code , we found the issue  that it is not creating the query string properly . for Ex -- If the table reference is -- Schema.table name   ,it create the query string as insert into [schema.tableName] (column1,colum2) values (value1,value2)   but it should be  insert into [schema].[tableName] (column1,colum2) values (value1,value2) . If we provide the Input as schema].[tableName instead of schema.tableName it is working.

The Upgraded plugin  for Import CSV to Database is not working , when we give reference the table  through a schema.for example if we have a table country  which is not under any schema , the import will work for it , but if we have some thing like address.country  where address is the schema , it is failing to update the DB and through error as invalid table object.

Hi,

I am using this service to Export CDT to Excel, i have configured the CDT, CDT fields, Document Name, Document Save Directory, Excel Base Template, Sheet No, Starting Cell and Include header to false. I didn't configured Document to overwrite in the process.

When i am running this process model the excel is generating as expected but the configured Excel Base Template is also getting updated. I have tried with re-configuring the nodes and by deleting/updating/adding the Template but still the issue remains same.

Could you please suggest me if i am missing anything from my side and could you please check this functionality once again

Thanks in advance