Excel Tools

Hi Muthulakshmi - I'd suggest posting your question in Discussions as it will get more visibility there!

Hey All, Is there any smart service which have "Base Template" option, like we had in "Export CDT to excel". Requirement is excel generation with two pages. First page data comes from data store entity, where as second page is static information, which is fixed data. As the "Export Data Store Entity to Excel" not having base template, how to achieve this? Thanks in advance.

Yes, I've reproduced this issue just now as well.  It appears that the queryAppianLogs() function doesn't actually support all of the parameters that are listed.  Maybe Sanchita Gupta or Michael Chirlin have some insight into this issue.

*..when utilizing queryAppianLogs() with hasHeader=false.  For instance:

queryAppianLogs(
  sqlStatement: "select * from login-audit",
  hasHeader: false
)

returns a result set with the column name the same as the column value, not "COLUMN1,COLUMN2.." as defined.  Is anyone else having this issue?

Hey all, we're on the latest version of the plugin (with Appian 19.1) and do not see correct results when utilizing queryAppian

Hi michael,
quick question we are in the version of 2.0.2 and we found that the version now is 2.2.6 is there anything we need reconfigure the nodes after we do the upgrade to the latest version.

There is an issue with the "Import Excel to Database" smart service.
Getting this error - "???Unknown column '' in 'field list'???"
The issue is occurring if I dont pass "New Columns" and "New Columns Values". If nothing is passed then it forms the insert statement with '' blank column name which causes this error.
Once I passed a column name into the "New Columns" and a value to "New Columns Values", it worked.
Example insert statement which gives the exact error in mysql: 

INSERT INTO `TEST_EXCEL1`(`numberColumn`, `textColumn`, ``) VALUES ("111","333","")
MySQL said: 
#1054 - Unknown column '' in 'field list'

Hi Michael,

Error was due to application server cache. Issue was resolved after restarting the application server.

Thank you.

Regards,

Satya Andra.

Are you still having this error?This is an odd error, can you make sure that only one version of excel tools is active on your environment? If on cloud open up a support case ask the support team to manually redeploy the plugin.

Hello,

I have updated Excel Tools plug-in to latest version (v2.2.6) and noticed below error in stdout logs:

2019-09-23 09:38:22,104 [Timer-5] INFO com.appiancorp.cache.sail.StatefulSailCacheImpl - Stateful SAIL current memory cache entries=8 size=201744 bytes
ERROR: Bundle com.appiancorp.ps.exceltools [49] Unable to get module class path. (java.lang.NullPointerException)
java.lang.NullPointerException
at org.apache.felix.framework.BundleRevisionImpl.calculateContentPath(BundleRevisionImpl.java:431)
at org.apache.felix.framework.BundleRevisionImpl.initializeContentPath(BundleRevisionImpl.java:368)
at org.apache.felix.framework.BundleRevisionImpl.getContentPath(BundleRevisionImpl.java:354)
at org.apache.felix.framework.BundleRevisionImpl.getResourceLocal(BundleRevisionImpl.java:493)
at org.apache.felix.framework.BundleWiringImpl.findClassOrResourceByDelegation(BundleWiringImpl.java:1511)
at org.apache.felix.framework.BundleWiringImpl.getResourceByDelegation(BundleWiringImpl.java:1420)
at org.apache.felix.framework.BundleWiringImpl$BundleClassLoader.getResource(BundleWiringImpl.java:2430)
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 running on Appian v19.3. Can you please help me understand and find a fix for the above error?

Thanks in advance.