Excel Tools

In Convert Excel to CSV Node, please check the value for "Number Of Columns To Read In Row" in Node Inputs, If that is 0, you will receive an empty CSV. Try giving some value or leaving it to blank instead of 0.

I have faced similar issue last week and when I updated this, the node worked fine.

Hi

I am facing an issue with "Convert Excel to CSV". In Excel there is data. However, when the excel is inputted to this smart service to convert it to corresponding .CSV, it gets it converted into a CSV but the CSV is empty. 

Any help on why is this happening? It was working fine till 7th June (I checked the folder where both the .xslx and corresponding .csv is getting stored). However it is not working now. Just an FYI, the version of my environment is 20.1 and we the upgrade has happened more than month ago (so I don't think the upgrade has anything to do with this).

Can I get a suggestion of why the smart service is behaving like this? Thanks in advance!!

Yes, please delete the old plugin, then please delete all old versions of the "ExportableDataSubset" CDT 
After that, deploy paste the new file in the folder.
Then update your model to point to the new version {urn:com:appian:ps:excel:types}ExportableDataSubset.

while tried using the plugin version 2.7.7 on Appian 20.1 Cloud there were no issues reported on process model but on log found below error

2020-06-02 08:09:22,051 [Appian Work Item - 4821 - execution00 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.exceltools.smartservice.ImportCsvToDatabase5 - Unknown column 'ID' in 'field list'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'ID' in 'field list'

But the column ID exists on .csv file and Db table as first column.

Bhargav Solanki , we have older installed on premise env. And the newer version file name is "com.appiancorp.ps.exceltools-2.2.7.jar". 

How do we install this new version on our on-permise? we have already used smart services from this plugin on few PM.

1. Do we delete the old plugin on _plugin folder and place the new file? 

2. or can the new file exisits along with the old plugin ?

please suggest

check if there are empty column after notes. If not copy the content data from the sheet and paste it into new sheet and try it out it might work.

Hello,

I am using "Import Excel to Database" smart service and getting an error  "???Unknown column '' in 'field list'???" while writing to the data base. When I check the logs its adding one null column by default, Can anyone please help me in understanding the cause for this error and how to fix it?

insert into `MyTableName` (`ID`, `EID`, `Name`, `Notes`,``) values (\'1\', \'2\', \'gh\',\'\')',1054

Hi Ze-Yang,

As noted in our Plug-in Policies, content is free and made available as-is. All plug-ins are use-at-your-own-risk, and their functionality is not guaranteed by Appian.

HI - similarly to Content Tools, it should work with newer versions thank the "Compatible Version(s):" listed. Compatible Version(s) is a referenced of what the author says they have tested with when submitting the app. Appian has great backwards compatibility, so newer versions than listed should not be an issue.