Share:
Provides the following custom smart services and functions for handling data in Excel. An example usage application for Export SQL to Flat File is also included.
Smart Services included are:
Functions included are:
NOTE: When deploying this plug-in, please delete all old versions of the ExportableDataSubset CDT AND update your model to point to the new version {urn:com:appian:ps:excel:types}ExportableDataSubset
I found the issue. The permissions were not correct on the plugin files on the server.
Is there a way to ignore columns with nulls when using the Import Excel to Database service?
Hi All,
We are currently on Appian v20.2 and Excel Tools (v2.2.9). I have observed below deprecated Appian APIs are being used in the plug-in.
Could you please let me know if hey have any impact on the smart services or functions of the plug-in?
Thanks!
Satya B Andra.
We are currently on Appian 20.2 and Excel Tools (v2.2.9). I have observed below depreacted Appian APIs are being used in the plug-in (From Health Check Report).
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()
Could you please let me know if they have any impact on smart services or functions of the plug-in?
Thank you.
anybody get the following error when using readexcelsheet():
Interface Definition: Expression evaluation error at function 'readexcelsheet' [line 2]:
test code:
readexcelsheet( excelDocument: 21324, sheetNumber: 0, startRow: 0 ),
Verified document exists by trying: getcontentobjectdetailsbyid(21324).
Getting an intermittent timeout error on the Import CSV to Database smart Service.Not made any changes that I'm aware of. Any particular logs to investigate
Can any please let me know the syntax of Read Excel Cell by Name function, as I am not able to get it properly, any screenshot explaining would be greatly helpful .
Thanks in advance!!!
1) Can you elaborate what action are you trying to take for which function?2) Can you please share sample rows of of the type of data you are taking the action with?
Hi, I am using date format like "2020-08-12" or "2020-08-12 03:43:13" in "Import CSV to DB", but get the error message "Date Format must be one of the following 'yyyy-MM-dd', 'yyyy-MM-dd HH:mm:ss', 'HH:mm:Ss'",
Can anybody help me out?
I am using the new plugin "Export SQL data to Excel" and am receiving the following error "Excel Plugin The following error was raised by the Export to Excel function: Attempting to write a row[1] in the range [0,32] that is already written to disk". is anyone else having this issue. I have two nodes the first works fine but errors on the second with the above
using 'Import CSV to Database' i need to add extra columns values into table that are not present in csv;
I can't add this extracolumns into csv file.
How i can import cvs fie into a table and add for each row additional information ?
In case i import the same csv file twice, i need to differenziare rows of first import from rows fron second import.
I note 'Import Excel to Database' have additional params as 'New Columns' 'New Columns values' , but i cant use it because i need to parse CSV file and not excel file
Best regards, Saverio
Is there any other way other than deleting the old version as this seems to manual change for us in 100s of process models and expressions.
One option could be check outdated dependents after the plugin is deployed with new version of Exportable Data Subset. But I haven't tried it and unsure if that will work. Any other suggestions on upgrading the plugin without deleting the older versions?
Thanks in advance,
Arjun.
Hi,
Which format will it support to read date value?
In excel file I had given, 20-07-2020, when readexcelsheet() function, it returns "2020-07-20 00:00:00" (Year-Month-Date time)
For input 05-07-2020, it returns "05-07_2020"
It is behaving differently when date is greater than 12 and less than 12. Which is the correct format to give date in excel file?