Excel Tools

Hi Dmitry,

Thank you for this plug-in, we have been using this extensively in live environments.

Recently since 2.2.9 version we started seeing high risk items (deprecated API references) in our health check report.

Even after upgrading to 2.2.10 version it is still there. Please see below:

5 plug-ins are using Appian APIs that are deprecated, private or have been removed. Plug-ins using APIs that have been removed from the latest Appian version will fail to function after an upgrade. Plug-ins using private APIs are not supported and risk breaking during an upgrade or between hotfixes. Plug-ins using deprecated APIs require refactoring to use alternative APIs as they will be removed and stop working in a future release. Contact Appian Professional Services for assistance updating a plug-in when expertise is not already available.
"Excel Tools (com.appiancorp.ps.exceltools) references private and deprecated Appian APIs
[private] com.appiancorp.common.xml.XmlBeanSerializer.populateObject(java.lang.Object, org.w3c.dom.Node)
[private] com.appiancorp.services.ASLIdentity.getIdentity()
[private] com.appiancorp.type.TypeRef.getId()
[deprecated] com.appiancorp.services.ServiceContext.getIdentity()
[deprecated] com.appiancorp.suiteapi.common.ServiceLocator.getContentService(com.appiancorp.services.ServiceContext)
[deprecated] com.appiancorp.suiteapi.common.ServiceLocator.getGroupService(com.appiancorp.services.ServiceContext)
[deprecated] com.appiancorp.suiteapi.common.ServiceLocator.getProcessAnalyticsService2(com.appiancorp.services.ServiceContext)
[deprecated] com.appiancorp.suiteapi.common.ServiceLocator.getProcessDesignService(com.appiancorp.services.ServiceContext)
[deprecated] com.appiancorp.suiteapi.common.ServiceLocator.getProcessExecutionService(com.appiancorp.services.ServiceContext)
[deprecated] com.appiancorp.suiteapi.common.ServiceLocator.getTypeService(com.appiancorp.services.ServiceContext)
[deprecated] com.appiancorp.suiteapi.common.ServiceLocator.getUserService(com.appiancorp.services.ServiceContext)
[deprecated] com.appiancorp.suiteapi.content.ContentService.getChildren(java.lang.Long, com.appiancorp.suiteapi.content.ContentFilter, java.lang.Integer)
[deprecated] com.appiancorp.suiteapi.process.GenericTypedVariable.<init>()
[deprecated] com.appiancorp.suiteapi.process.GenericTypedVariable.setType(java.lang.Long)
[deprecated] com.appiancorp.suiteapi.process.GenericTypedVariable.setValue(java.lang.Object)
[deprecated] com.appiancorp.suiteapi.process.analytics2.ProcessReport.copy()"

Can you please advise if there is a plan to fix this in 2.2.11?

Thanks Dmitry.  Is 2.2.10 compatible with Appian 20.1?  Also, is there a step by step user guide to help users with how to successfully import excel data?  We have the Readme that comes with excel steps but it has very little practical steps.  

We are on ver 2.2.10.  Appian health check shows High risk message regarding this plugin.  Please provide updated plugin.

Excel Tools (com.appiancorp.ps.exceltools) references private and deprecated Appian APIs
[private] com.appiancorp.common.xml.XmlBeanSerializer.populateObject(java.lang.Object, org.w3c.dom.Node)
[private] com.appiancorp.services.ASLIdentity.getIdentity()
[private] com.appiancorp.type.TypeRef.getId()
[deprecated] com.appiancorp.services.ServiceContext.getIdentity()
[deprecated] com.appiancorp.suiteapi.common.ServiceLocator.getContentService(com.appiancorp.services.ServiceContext)
[deprecated] com.appiancorp.suiteapi.common.ServiceLocator.getGroupService(com.appiancorp.services.ServiceContext)
[deprecated] com.appiancorp.suiteapi.common.ServiceLocator.getProcessAnalyticsService2(com.appiancorp.services.ServiceContext)
[deprecated] com.appiancorp.suiteapi.common.ServiceLocator.getProcessDesignService(com.appiancorp.services.ServiceContext)
[deprecated] com.appiancorp.suiteapi.common.ServiceLocator.getProcessExecutionService(com.appiancorp.services.ServiceContext)
[deprecated] com.appiancorp.suiteapi.common.ServiceLocator.getTypeService(com.appiancorp.services.ServiceContext)
[deprecated] com.appiancorp.suiteapi.common.ServiceLocator.getUserService(com.appiancorp.services.ServiceContext)

We are on appian 20.2 and using readexcelsheet function and getting below error along with tomcat getting forcibly shutting down.

The excel tool version is 2.2.10 (com.appiancorp.ps.exceltools-2.2.10)

Any one faced this issue or some bundle missing?

2020-11-20 10:31:52,351 [Timer-5] INFO com.appiancorp.cache.sail.StatefulSailCacheImpl - Stateful SAIL current memory cache entries=0
2020-11-20 10:47:31,150 [ajp-nio-0.0.0.0-8009-exec-3] ERROR com.appiancorp.util.BundleUtils - Cannot retrieve the value for key "function.areusersaddedbyrule.param.users.description" from the bundle.
2020-11-20 10:47:31,150 [ajp-nio-0.0.0.0-8009-exec-3] ERROR com.appiancorp.util.BundleUtils - Cannot retrieve the value for key "function.aregroupsaddedbyrule.param.groupIds.description" from the bundle.
2020-11-20 10:48:19 INFO [ajp-nio-0.0.0.0-8009-exec-7] com.sun.jersey.server.impl.application.WebApplicationImpl._initiate Initiating Jersey application, version 'Jersey: 1.19 02/11/2015 03:25 AM'
./inner-start.sh: line 17: 18965 Killed ./catalina.sh run
2020-11-20 10:49:27 Appian in Tomcat is forcibly killed

Thanks

Nirav

Hi, the most up to date version of this plugin is 2.2.10.

When you deploy the plugin, there will only be one version of the plugin as a whole in the environment.

However, some of the components like Smart Services will have versions available for use in the Process Modeler for backwards compatibility.

Please let me know more details if you are experiencing an issue with this plugin.

Does anyone know what the most up to date version of excel tools is?  Or is there only one version of excel tools?  I see above that it is compatible with Appian version 17.1 and above.  

Does "Import Excel to Database" support .xls ?

We are facing issue when uploading XLS file making the node to fail. There is no issue with uploading XLSX files though.

ERROR:

"The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with OOXML (Office Open XML) Documents. You need to call a different part of POI to process this data (eg HSSF instead of XSSF)"

Hi Dmitry,

Cant create dynamic view. Could you please elaborate ootb ss.

Are you building a query dynamically in such a way that you cannot create a view with that query? If you can create a view, then you can create a DSE against the view and use the OOTB SS.

Thanks April!!

I will try.