Provides the following custom smart services and functions for handling data in Excel. An example usage application for Export SQL to Flat File is also included.
Smart Services included are:
Functions included are:
NOTE: When deploying this plug-in, please delete all old versions of the ExportableDataSubset CDT AND update your model to point to the new version {urn:com:appian:ps:excel:types}ExportableDataSubset
Share:
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
Hi MatD61 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.
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)"