Plug-ins

Hi , As pe the  Function Plug-ins - Appian 22.2 , We can inject the service ( ContentService ) as a argument to the custom functions. When I try to inject as  below public String dowork(@Parameter String para, ContentService cs) { } I am getting below error. : Unable to find a required instance of ContentService. Is there any other annotation or setting ? Thanks & Regards, Chaminda

Hi, I'm generating a word docx using docx from dynamic template and converting the docx to pdf using PDF from DOCX smart service. I'm able to generate the docx properly but while converting to PDF the text is getting overlapped in single line.  can anyone help me on how to convert DOCX (generated using docx from dynamic template) into pdf with proper format. Thanks in Advance.

Hi Team, I am having an issue with reading the log file (login-audit.csv). It contains multiple rows, but the function is only returning the header and not the rows. However, when I try with other log files, it works fine. Currently Our Appian version is 24.1 and we are using this plugin firsttime.   Expression -    readcsvlogpaging(   csvPath: "login-audit.csv",   startIndex :1,   batchSize:20 )   Output     'type!{com.appiancorp.logreader}CsvContents'('logName': "/usr/local/appian/ae/logs/login-audit.csv", 'totalCount': -1, 'headers': {"2024-05-14 00:00:05", "Appian", "Succeeded", "3.106.112.168", "Web API", "Appian", "cd05a5a0-b1e5-4ffb-8dd6-0f7007e505ce", ""})

Hi Team, Import excel to database plugin not writing in database table and not getting error in output parameter and in tomcat logs. The issue i am facing in my Prod environment and even not facing frequently. Could you please help me on this to move further. The same process i tried individual with only node of import excel to database, its working. The issue not occurring repeatedly and same file is working for some time. Thanks, Pradeep Sridharan 

hi i have a query that i am using to fetch the data from post grace sql to appian  but while i am making a manual query  in that query i have empty values  as some contion  in the above condition we have empty values  whic is not considerding by plugin and displaying the below error  please give me any solution on this 

Hi, I'm trying to import a CSV file into a PostgreSQL DB. Customer requires all data from appian must rely on that DB which is connected as datasource. I'm using the plug in Excel tool and the Smart Service Import CSV to Database.  I got the following error from stdOut log:  ERROR ImportCsvToDatabase8 Error executing SQL org.postgresql.util.PSQLException: ERROR: syntax error at or near "," Position: 17 From database, i turned statements log on and i found out the following statement:  2024-03-29 17:32:08 UTC:10.245.48.249(51148):appian@postgres:[3319]:ERROR: syntax error at or near "," at character 17 2024-03-29 17:32:08 UTC:10.245.48.249(51148):appian@postgres:[3319]:STATEMENT: select `field1`, `field2` from `table` where 1=0 2024-03-29 17:32:08 UTC:10.245.48.249(51148):appian@postgres:[3319]:LOG: execute S_1: ROLLBACK I'm running the same statement on my client in Postgres and i got the same error of course. What I found out is that backtick is cau

I am using the LDAP tools application and reieveing the following error [Appian Work Item - 323 - WorkID 69 - execution02 - process 2098658 - model 65 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.plugins.directory.syncwithusernames.service.SynchronizationService - Error while conducting name search:  javax.naming.PartialResultException [Root exception is javax.naming.CommunicationException: DomainDnsZones.eg.Albaraka.local:389 [Root exception is java.net.SocketTimeoutException: connect timed out]]

Hello Everyone i need small help regarding to the  "audioPlayerField()", i want to play the mp3 audio in interface so that i am using the  audioPlayerField() but i am unable to play the song can any one help for this 

Hi all,  I have seen that the decodeJWT function of JWT Tools plug-in returns the decoded token but only if the signature is valid, otherwise it returns null. This function needs jwks url to retrieve the proper public key and validate the given token.  Does anyone know if there is a way to decode a JWT without validating the signature? It is possible to decode a JWT with a private key stored in scs? Is there any other plug-in to create and validate JWTs? Thanks in advance. 

Hi, I wanted to ask what is the maximum number of records that can be loaded into the DB using the Load Csv File to Database plug-in?

Hi Team,[Deprecated] Export SQL to Excel smart service is failing in our DEV environment Appian version 23.2. Geeting below mentioned error:"The following error was raised by the Export to Excel function:  null"Same smart service is working in another DEV environment of same version.Please do the needful on this issue. Regards,Sandeep

I'm generating a word docx using docx from dynamic template and converting the docx to pdf using PDF from DOCX smart service. I'm able to generate the docx properly but while converting to PDF the text is not coming in the pdf file. can you please help me to find out the problem? 

I am trying to user Move to FileSystem smart service to move files from a network drive to an Appian folder. The process keeps on failing at the Move to Collab node. I am seeing the below error in application server log Caused by: com.appiancorp.suiteapi.process.exceptions.SmartServiceException: java.lang.Exception: Invalid File Path: \\\\RmsStgIntWeb1\\Section15Attachments\\test1.txt This is a shared folder on a network server. I tried giving my local folder path, another mounted shared srive path, but each time getting the same Invalid Path error. What am I doing wrong here? Would really appreciate if someone is using this smart service and can help me out. Thanks in advance. Subhashre 

HI Team, I wanted to reduce the size of the images what users are uploading,  they are high mb and causing the disk space memory usage , Do we have a plugin which reduce the size if image like if user uploaded is 30mb then reduce it to 3 mb . I see image compression plugin but looks like it has some vulnerabilities, Any suggestions will be helpfull Thanks,

We have a requirement to get files from NFS path into Document object as down the lane, we have to pass it to other api, which accepts only Document object for file. Can someone recommed us with approach to work it out?

Hi, I'm trying to compare the similarity between two texts(For a dashboard), I found a plugin (similarity) but apparently it has a high cpu usage. Does anyone know if there is any out of the box solution or another plugin for this? Thanks!

import csv to database smart service from Excel tool is creating an issue with connected system data source

Hello, I'm trying to send a file from my Appian application to a remote server that has its own hostname, username, password, and key file. I have implemented the process to do this. While attempting to connect to this remote server, I have configured the file transfer configuration like this: 'type!{plugins.ps.appiancorp.com/.../}FT_Config'( serverPort: 22, serverHostName: cons!ETT_HostName, privateKeyFile: cons!ETT_SERVER_PRIVATE_KEY_RSA ) However, I still don't know how to successfully connect to the server, even though the process does not throw any errors. How can I resolve this? I'm really stuck; I can't find documentation, tutorials, or even an explanation of how the plugin works for beginners, which is a very terrible thing for such an important plugin. The problem is that the process is not throwing any errors and there's no logic to connect to the server without the username and password.

Hi All, We have installed plug-in for Range slider and we now we have to store the slider value selected by customer in one of our variable. Kindly let us know how can we save value to a variable?.We have already created a variable and tried saving the value in 'range slider save into' but it is not working as expected. Thanks

Hi All,  I'm using the Google Charts Component Plugin, specifically for Tree Maps. I want to display the values dynamically in the tooltip as shown in the google developer documentation. But, in the Appian tree map plugin function, i only see option to show basic tooltip with showTooltips:true() option. Is there a way to display dynamic tooltip in Appian as shown in the google developer documentation. Thanks in advance.

Good day, I would like to know if there is a plugin that allows extracting data marked as "tags" in .doc/.docx documents I would need the same functionality that the PDF Tools plugin allows with .pdf files (getPDFFormField, getPDFText, etc.) but for MS Word files Thank you very much in advance and farewell. PS: In the image: example of a MS Word tag from which I want to extract its information

Hello, I have used the smart service "Import Excel to Database" to import a huge Excel Data(200 rows and 150 columns) into a table. Issue 1.  When we add more than 10 columns to import excel to DB we are getting an Error  (conn=935099) You need to set exactly 15 parameters on the prepared statement.  Issue 2. we tried Importing 10 columns from excel to DB, even though we have 100 rows in excel, it was importing 20,000 null rows in DB. Could any one help me with these issues, Thanks Gopala Krishna Raju

Hello, We are trying to integrate with a client's external system to send notifications and, when we send documents attached to the notification, they arrive corrupted. As I mentioned, to send the notifications we need to call an external system and the request body has 3 parameters. One of them must be in base64, which originally is an XML that contains the notification information (body, recipients, attachments, etc.).  The XML code is the follow one: concat( "", "", "", /*(Opcional) Indicar si se debe realizar la comunicación solamente por una vÃ%ADa de envÃ%ADo: SMS, EMAIL, PUSH sin contingencias*/ "EMAIL", "", "", ri!codigoPeticion, "", /*Destinatarios*/ joinarray( a!forEach( items: ri!arrayDestinatarios, expression: char(10) & "" & fv!item & "" ), "" ), "", ri!asunto, "", toHtml(ri!cuerpo), "", if( a!isNull

I am getting this error on Export to Excel function when I am exporting the data in excel via SQL query-  The following error was raised by the Export to Excel function: Attempting to write a row[4] in the range [0,157943] that is already written to disk. We have this functionality where there is a Create and Modify workflow and we want to create a excel template in both scenarios using SQL query. The strange thing is  - We are using same excel base template on both Create and Modify workflow but this error only occurs when executing Modify workflow. We have formula on A column which is populated on 4th row and excel headers till 3 rows so the starting cell is B5.  Can anyone please help me out to understand the root cause here?

Hi, we are attempting to use the Appian PowerBi plugin.  We are able to successfully connect.  However, when we attempt to use operations like "Get all Groups" we are getting error code 401 unauthorized.  I would appreciate any help. Here's a screenshot of the error: