Plug-ins

The plug-in is not compatible with Appian 22.1. what else can I do to import csv to database

I'm using Executestoredprocedure plugin in 21.3 version to execute stored procedure in Oracle database. The procedure using Cursor as out parameter to return select statement result. I found out the open cursors are remaining open in database. Any thought to solve this issue?

Hi team, can anyone suggest me is their any plug in to download folder from the sharepoint

Hi, I'm trying to configure the MSGraph Email Poller and I have given all the required values in third party credentials. secret tenant: using format login.microsoftonline.com/.../ applicationID But I'm getting below error: 2021-08-09 17:50:26,625 [Appian Work Item - 0 - execution00 : UnattendedJavaActivityRequest] DEBUG com.appiancorp.ps.msgraphmail.MSGraphMailPollerSmartServic e - Connecting to MS Graph authentication provider 2021-08-09 17:50:26,863 [Appian Work Item - 0 - execution00 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.msgraphmail.MSGraphMailPollerSmartServic e - Unexpected error polling for mail java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:357) at java.util.concurrent.CompletableFuture.get(CompletableFuture.java:1908) at com.appiancorp.ps.msgraphmail.MSGraphConnector.<init>(MSGraphConnector.java:75) at com.appiancorp.ps.msgraphmail.MSGraph

Hi All, In order to read site_usage.csv log and convert it to readable format I am using readcsvlog (Log Reader - plugin) . But I am facing issue like these params are timestampColumnName, timestampStart, timestampEnd not working and I am getting massive data without these params. Is there any way to filter the csv log data based on timestamp range while reading the csv using plugin. When I read the entire set I have to loop huge number of time for getting the timestamp and filtering it based on date range which is causing performance issue. Regards Bihitak

I want to export grid data obtained from stored procedures to Excel without the need to create any CDTs (I have different tables from different stored procedures) I'm trying to use Export SQL to Excel in a Process Model in order to do this. I can provide it the query (which, once again, contains a stored procedure in almost all cases).  However, when I debug it, I always get the same error, java.lang.reflect.UndeclaredThrowableException My configuration at this momento is the following: -Node inputs Cell_Keys (empty) Cell_Values (empty) Add_as_new_sheet=true Document_name_to_create="SQL_Excel" Document_save_directory="PM Artifacts" Document_to_overwrite (empty) Excel_base_template="PM_blankexcel" (a blank Excel file created following a kind of step by step made for this situation some years ago in Appian community discussions) Include_header_row=true Jndi Name= (here I literally pasted the Connection URL I used in the Connection System obje

Hi Team, Is there any plugin or any way to upload copied image from windows clipboard snipping tool to Appian? like we do in jira , service now Regards Bihitak

Hi All, I have a requirement for converting hebrew language DOCX Document to PDF Document.I have tried to convert using "PDF from Single DOCX (with Fonts)" Smart Service from dynamic document generator(https://community.appian.com/b/appmarket/posts/dynamic-document-generator).But Hebrew Language content is replaced with ### symbol in created PDF Document using this smart service.So I created constant, added two hebrew ttf document ("NotoSansHebrew-VariableFont_wdth,wght.ttf","NotoSerifHebrew-VariableFont_wdth,wght.ttf") and added as Font Documents in that Smart Service.But still I got the same PDF document with replaced ### symbol. Could you please suggest, what kind of font document we need to upload for hebrew language to get original Hebrew Language PDF Document?  Also I have used "HTML Doc from Template"  Appian smart service to create a HTML document with Hebrew content and using the generated HTML document I tried using the "

Team, We are trying to use MS Graph poller plugin to poll mails from mailbox. We have created an application in Azure and received applicationId,client and secret. But not clear on below highlighted text? What exactly we need to do to add mailbox in the application we created in azure? Any one used it can guide please? Azure team also dont know what to do. In Azure, register an application for Appian to use client credentials. This applications needs to have all mailboxes in scope where you want it to be connecting to. Any documentation which guide how to link mailbox in application scope?

Good morning, I'm trying to obtain a report from a grid. I obtain that grid via an SQL query so I thought of using the SQL to Excel Smart Service included in a plug in for Appian Community Edition, but i haven't been able to obtain the desired result due to "java.lang.reflect.UndeclaredThrowableException". My configuration is the following (I filled the fields marked with * as I guess they are the only required ones and also a couple of the not required ones): -Add as a new sheet=true -Jndi Name= (I copied and pasted the connection url I'm using in the connected system) -sheet_name="output" -sheet number=0 -sql= "EXEC dbo.spRepRevenues '', ''" (which I know works due to the grid showing in the interface using .results) -document name to create (not required): "probandoplugin"  -document save directory (not required): "PM Artifacts" My only guesses are that either the jndi name is wrong (I als

Hello, I am having the following error com.appiancorp.plugins.LoggingPluginEventListener - Failed to load Plug-in 'test.plugin version 0.0: 'Component plug-in approval verification failed. Please contact Appian for approval process' while trying to deploy a JavaScript Component Plugin on server with temporary license as it is just for POC Is there any solution to above ,knowing that I tried to register my machine through AppMarket submission page but it gives me error Please enter a valid FQDN for a non-production environment with an active product license Thanks in advance Nancy Ahmed   Update :I got my developer token and I applied it on my development environment but I am getting same error and I do not know from where I can start investigation

Hello, I see the below error while executing the custom plugin function. I verified the connection and third-party credentials, and it all looks correct. Could anyone please help me understand what the issue could be? Error: (Expression evaluation error in rule 'cbg_po_eds_addmerchant' at function fn!cmpo_eds_ws_getbotwinstitution [line 3]: Unable to find a required instance of SecureCredentialsStore.) (Data Outputs) Server Log:  2022-05-20 21:36:25,659 [Appian Work Item - 173086 - execution05 : ExpressionGroupRequest] ERROR com.appiancorp.process.engine.ExpressionGroup - An error occurred while evaluating expression: addMerchantResponse:rule!CBG_PO_EDS_addMerchant(requestId_int: pv!requestId_int, billingAccount: pv!billingAccount, customer:pv!customer, customerMailAddress: pv!customerMailAddress, appianPrdId: pv!appianPrdId ) (Expression evaluation error in rule 'cbg_po_eds_addmerchant' at function fn!cmpo_eds_ws_getbotwinstitution [line 3]: Unable to find a

Hi everyone, I want to use a!documentViewerField()  but it only works for PDF. I want pptx files to be displayed to user. How can I achieve this?

Good Day Experts, When i tried to convert XHTML to docx i'm getting below error. Can anyone please help me how to overcome this issue ? Thanks in advance. Cheers, Kalai.[View:/cfs-file/__key/communityserver-discussions-components-files/19/error.log:320:240]

Hey there, I'm developing a custom function plugin that will require an http request to an external server. This is done using a third-party Java library. However, in order to make a successful http request, I need to configure a proxy. I have configured the proxy via the Admin console, but it seems this is not getting used by plugins, so I have to manually set the proxy settings in the plugin code. I wanted this to be an easily reusable plugin. Is there a way to pull the proxy configured in the Admin Console for use in function plugins? Thanks in advance. Cheers

Hi, We have updated Dynamic Document Generator Plugin version form 1.8.5 to 1.8.7. After upgrading DOCX from XHTML is breaking when generating document, we didn't make any changes to our existing logic. The same code is working with older version - 1.8.5 in other environment. Based on the error looks like it missed some classes. Error:  com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException: java.lang.NoClassDefFoundError: com/lowagie/text/DocumentException @jialin.wang @Appian please fix this issue ASAP Caused by: java.lang.NoClassDefFoundError: com/lowagie/text/DocumentException at org.docx4j.org.xhtmlrenderer.docx.DocxRenderer.(DocxRenderer.java:160) at org.docx4j.org.xhtmlrenderer.docx.DocxRenderer.(DocxRenderer.java:85) at com.appiancorp.ps.xmlfo.ss.DocxFromXhtmlWithStyling.runSmartService(DocxFromXhtmlWithStyling.java:61) at com.appiancorp.ps.xmlfo.ss.AbstractDocumentGeneration.run(

Hey all, we've been seeing an error with the CDT Diff Utilities plugin on occasion (below).  This error occurs sporadically.  In one process we have seen the error occur for ONLY ONE user 25 times, when we reassign that task to another user, they can complete it with the same data with no issues.  The user completes the same tasks regularly, and sometimes the error does not occur.  Data entered is similar.  The error has occurred 25 times for this single user, while they have had 672 successful submissions.  Otherwise, 67 users have completed the same task 16,897 times without issues. In 2 other medium-use processes the error has occurred one time only each, 1 in a script task set to run as the designer (our admin account) and 1 during a form submission by a different user than the one above. I see one other post related to this error in the plugin's discussion thread, but no other results via search.  Wondering if anyone else has experie

Hello Community, I wanted to know about its efficiency when exporting complex SQL queries in Export SQL to Excel SS, as we have used this smart service to generate data for multiple sheets in excel, but if multiple people triggers the final parent process at the same time, it crashes the server, any one can guide to avoid that or any alternatives ? Is there an issue with this smart service ? Thanks in advance.

What would be the best solution for displaying the data by reading the data from uploaded excel from an Interface? Use Case: 1) Upload the Excel in the Interface. 2) Read the data from the excel.(multiple Sheets - Each sheet will not have more than 10 to 20 rows) 3) Show the data in the Interface (Each sheet will be related as one to many relationship) Note: Sheet1 will have parent table data and other sheets will have child table data

Hi I'm trying to read an excel using Parse Excel to CDT smart Service. I would like to understand in what format we need to pass the value is this parameter.

Hi, I have created a simple Component plugin but getting below error while drag and drop plugin on interface Missing system configuration This component requires the dynamic content domain to be properly configured. Contact your system administrator. We are using On-premise Appian server. This is basic backgroudColor plugin copied from Appian Github. Please suggest what steps are required to rectify this issue.

Hi Team, Is there a way in Appian where we can retain the file extension as the extension that we are using in our template.We have a requirement where we are using the excel base template with in-built macro having the file extension as .xlsm and when trying to generate the excel through appian process the file extension is getting changed to .xlsx.Any suggestions? Thanks

Can someone explain how to configure the "Add Documents to Zip" node? I just want to add the selected images to zip file. Thank you.

Hi, Is there any smart service or plugin that can mass delete first X rule/process model versions. Thanks

Health Check report shows the following message about Deprecated Plug-Ins with no further details. How can I find out which plug-ins are being flagged here?