Excel Tools

Hi Mathieu Drouin The following smart services have moved to the deprecated palette. It is recommended to use base product functionality where possible: Export CDT to Excel, Export SQL to Excel, Export SQL to FlatFile

What is the status of the Export SQL data to Excel/CSV smart services?

They show up as deprecated when I import the plugin.

Dear Sylvain Furt and Mike Cichy: We have been testing some of your suggestions on our DEV environment issue; thank you so much for your valuable input!

Hello,

We have recently upgraded to 18.4, and are looking to implement exportable excel reports using the Getdatasubsetdownloadlinkfromprocess function like we have used in previous versions. In the Modules listed on the plugin, it says that the function still exists and is not deprecated, but when I go to search and implement, this function does not appear. Has anyone else had a similar issue? Also, may we have some documentation behind this plugin like previous versions?

Best Regards

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)"