Excel Tools

Hi - we are running into a show-stopper situation, wherein one of the smart services offered as part of this offering - "Import CSV to Database" is not working for PostGre SQL database (one of the databases supported/ compatible with Appian platform). 

We are getting the below error: 

• Error in v5 plugin: syntax error at or near "`" Position: 15 
• Error in v6 plugin: java.lang.reflect.UndeclaredThrowableException

Since this is quite critical, can someone please confirm if someone has made this working with PostGre?

Hi , 

I was able to use the queryappianlogs function with the older version of Excel tools. But, when i updated this latest Excel tools plugin, i am getting error message and the data is not shown. Can you please fix this in this in the latest version?

Please find below the error log in the application server log.

ERROR: Bundle com.appiancorp.ps.exceltools [61] Unable to get module class path. (java.lang.NullPointerException)
java.lang.NullPointerException
	at org.apache.felix.framework.BundleRevisionImpl.calculateContentPath(BundleRevisionImpl.java:432)
	at org.apache.felix.framework.BundleRevisionImpl.initializeContentPath(BundleRevisionImpl.java:365)
	at org.apache.felix.framework.BundleRevisionImpl.getContentPath(BundleRevisionImpl.java:351)
	at org.apache.felix.framework.BundleRevisionImpl.getResourceLocal(BundleRevisionImpl.java:494)
	at org.apache.felix.framework.BundleWiringImpl.findClassOrResourceByDelegation(BundleWiringImpl.java:1617)
	at org.apache.felix.framework.BundleWiringImpl.getResourceByDelegation(BundleWiringImpl.java:1460)
	at org.apache.felix.framework.BundleWiringImpl$BundleClassLoader.getResource(BundleWiringImpl.java:2597)
	at com.ibm.db2.jcc.am.wd.run(wd.java:49)
	at java.security.AccessController.doPrivileged(Native Method)
	at com.ibm.db2.jcc.am.GlobalProperties.a(GlobalProperties.java:146)
	at com.ibm.db2.jcc.am.GlobalProperties.d(GlobalProperties.java:100)
	at com.ibm.db2.jcc.am.dr.run(dr.java:124)
	at java.util.TimerThread.mainLoop(Timer.java:555)
	at java.util.TimerThread.run(Timer.java:505)
java.lang.NullPointerException
ERROR: Bundle com.appiancorp.ps.exceltools [61] Unable to get module class path. (java.lang.NullPointerException)
java.lang.NullPointerException
	at org.apache.felix.framework.BundleRevisionImpl.calculateContentPath(BundleRevisionImpl.java:432)
	at org.apache.felix.framework.BundleRevisionImpl.initializeContentPath(BundleRevisionImpl.java:365)
	at org.apache.felix.framework.BundleRevisionImpl.getContentPath(BundleRevisionImpl.java:351)
	at org.apache.felix.framework.BundleRevisionImpl.getResourceLocal(BundleRevisionImpl.java:494)
	at org.apache.felix.framework.BundleWiringImpl.findClassOrResourceByDelegation(BundleWiringImpl.java:1617)
	at org.apache.felix.framework.BundleWiringImpl.getResourceByDelegation(BundleWiringImpl.java:1460)
	at org.apache.felix.framework.BundleWiringImpl$BundleClassLoader.getResource(BundleWiringImpl.java:2597)
	at com.ibm.db2.jcc.am.wd.run(wd.java:49)
	at java.security.AccessController.doPrivileged(Native Method)
	at com.ibm.db2.jcc.am.GlobalProperties.a(GlobalProperties.java:146)
	at com.ibm.db2.jcc.am.GlobalProperties.d(GlobalProperties.java:100)
	at com.ibm.db2.jcc.am.dr.run(dr.java:124)
	at java.util.TimerThread.mainLoop(Timer.java:555)
	at java.util.TimerThread.run(Timer.java:505)
java.lang.NullPointerException

we are using 2.2.11 and missing smart service Export SQL data to CSV.

Can that be added ?

Hello,

Does this plugin no longer include the Export CDT to Excel smart service? If it is no longer supported, has anything replaced it?  I have a use case that requires exporting a CDT, datasubset, map, or some other type that is not from the DSE to excel.

Thank you,
Walker

I am also having a similar use case. If this is addressed it would be very helpful!

Hello,

We would like to have an enhancement for readexcelsheet function.

Nature of this function:

• If the entire row is empty it will not read it/bring it to Appian
• There is no limit on how many rows to be read

What is needed?:
Can we introduce 2 new parameters?

• Allow nulls to be included
  Reason: When we do a validation check on the rows, we need to mention which row is having the validation error. Due to an empty row in middle, row calculation will be wrong as this function is not including any empty rows in the output. To avoid the row count issue, we would like to enable this feature.
• Max row parameter
  As we are allowing null values, we should add some kind of restriction on how many rows to be read. By default, we can define some max limit. 50000 Rows max?

• Fixed backwards compatibility issues with 2.2.10

Hello,

Does the current version of this plugin allow export of a datasubset or CDT to excel, and allow for download of that excel from the UI?  If so, which functions would be used?  I also noticed there are currently two versions of this plugin accessible through the cloud.

Thank you,

Walker

• Reverting to 2.2.9 due to compatibility issues with 2.2.10

These items were likely flagged before as well. We are going to address theses in the future. At this point, there is no danger these will stop working any time soon.