Excel Tools

We have a similar requirement where we need to import data from CSV / Excel to PostgreSql database. Please let us know if this plugin supports PostgreSql DB as well. 

Hi there,

We are using this tool with PostgreSQL 11.X version and we are getting error while saving simple data ( not dates fields).

I believe the tool supports ( ORACLE, MSSQL, MYSQL, DB2 and MARIADB) only, Kindly modify it to support PosgreSQL also.

Apricate your quick response. 

Thanks,

Bharat

Hi everybody, I'm really dummy on Appian (I'm workin' with it since 2 weeks). My boss give me a task where I have to read an Excel File and build a query to update some rows (I read IDs on Excel) on a DB.

I don't have great problems with the query, but I actually don't know how to read the xls. May someone give me an example to follow?

Thanx very much to everybody

Max

After upgrade to this latest version 2.2.19 we note Health Check continues to report this plug-in as High Risk "Excel Tools (com.appiancorp.ps.exceltools) references private Appian APIs [private] com.appiancorp.common.xml.XmlBeanSerializer.populateObject(java.lang.Object, org.w3c.dom.Node

Is this expected? Can this High Risk be resolved?

A log extract showing error

2022-06-28 18:30:54,015 [Appian Work Item - 272 - execution00 : UnattendedJavaActivityRequest] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=247948, classname=com.appiancorp.ps.exceltools.smartservice.MergeExcelDocuments org.apache.poi.openxml4j.exceptions.InvalidOperationException: A part with the name '/docProps/core.xml' already exists : Packages shall not contain equivalent part names and package implementers shall neither create nor recognize packages with equivalent part names. [M1.12] at org.apache.poi.openxml4j.opc.OPCPackage.addPackagePart(OPCPackage.java:941) at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:547) at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1490) at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1477) at org.apache.poi.openxml4j.opc.ZipPackage.closeImpl(ZipPackage.java:472) at org.apache.poi.openxml4j.opc.OPCPackage.close(OPCPackage.java:464) at org.apache.poi.ooxml.POIXMLDocument.close(POIXMLDocument.java:189) at org.apache.poi.xssf.usermodel.XSSFWorkbook.close(XSSFWorkbook.java:609) at com.appiancorp.ps.exceltools.smartservice.MergeExcelDocuments.mergeExcelFiles(MergeExcelDocuments.java:147) at com.appiancorp.ps.exceltools.smartservice.MergeExcelDocuments.run(MergeExcelDocuments.java:95) at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.lambda$call$0(DefaultActivityExecutor.java:136)

Hi,

Upgrading to latest version 2.2.19 has not cured the issue. A server restart hasn't worked either.

Can anyone shed any light on how to get round this issue?

Regards

A quick search shows this to be a known bug in the docfetcher module and is fixed in 1.1.15 (DocFetcher / Bugs / #987 A part with the name '/docProps/core.xml' already exists (sourceforge.net)).

Will upgrade to latest version of plugin cure this issue?

Regards

Hi

Using Merge Excel documents (v2.2.18 of plugin on Appian 22.1) has been working very successfully. Now shows an error -

Merge Excel Documents A part with the name '/docProps/core.xml' already exists : Packages shall not contain equivalent part names and package implementers shall neither create nor recognize packages with equivalent part names. [M1.12].

Any ideas as to cause and how to overcome this error?

Regards

Hi

The above has now reoccurred after having successfully running for a couple of months. Any ideas on how to fix?

Regards

Can i know what is the maximum rows that can be inserted at once while importing Excel/CSV file.