Excel Tools

Question #1: I was using version 1.8.8 and just updated to newest version. Could I assume performance is much better on the newest version for the SQL TO EXCEL smart service? On the 1.8.8 version I was getting the error: The following error was raised by the Export to Excel function:  Closed Resultset: getMetaData . Question #1: is there any timeout limit that this plugin has?

Hi,

I was using "Import Excel to Database" smart service and every time I start the process for debugging, it throws the same error. Is there any proper documentation for this smart service? If so, please share the documentation of the smart service. I am sharing of the error which has been occured

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column '' in 'field list'

at sun.reflect.GeneratedConstructorAccessor773.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)

at com.mysql.jdbc.Util.getInstance(Util.java:408)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)

at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2124)

at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1801)

... 25 more

2019-02-09 05:57:55,961 [Appian Work Item - 495 - execution02 : UnattendedJavaActivityRequest] ERROR com.appiancorp.util.BundleUtils - Cannot retrieve the value for key "Unknown column '' in 'field list'" from the bundle.

Thanks in Advance.

Hi,

I am using "Export SQL to Excel" smart  service to export the data but getting the  error as " The following error was raised by the Export to Excel function: Row 0 has been flushed, cannot evaluate all cells". I am getting this error even with the limit set to 100 rows. Any advice would be appreciated!

Thanks.

Hello,  Does anyone have an example (recipe) for using the "Import Excel to Database" Smart Service?  Thanks --Greg

Hi sandhyam0001 and amitb0004  - I would suggest posting in Discussions https://community.appian.com/discussions/ if you have a question.  Your question will get the most visibility that way!  

while importing application it gives me an error>>>

"The specified file does not contain a valid package and cannot be imported. (APNX-1-4154-000)"

Hello,

Could you please redirect us to latest documentation/readme.pdf?

Hi Corrado de Candia where can we find more documentation of the plugin? Like a User Guide. Thanks !!!

When will you re-add the ability to take an arbitrary set of data, do appian-side processing/transformation to it, and write the result easily to an Excel file complete with word wrap enabled on the written cells?  The only previous way to do all of this was the Export CDT to excel, now removed, with no functional replacement at all.

I know I could create a scrap DB table with arbitrary text columns and write data to it, then invoke it with the SQL to excel smart service, but even this super cumbersome approach still doesn't (as far as I'm aware) contain the way to set / preserve word wrap on filled cells.

Hello,

We have upgraded to the latest version of this plug-in and encountering 'ERROR com.appiancorp.ps.exceltools.smartservice.ImportCsvToDatabase - Invalid object name' issue for the tables that were defined under a schema. It was working before. Kindly resolve the same.