Plug-ins

Hi All, When starting to run a health check, getting below expression error: Expression evaluation error [evaluation ID = 2f8ea:98060] in rule 'ahc_ui_requesthealthcheck' at function 'gethealthcheckcollectionstatus' [line 67]: The function 'gethealthcheckcollectionstatus' is unavailable. Could you please advise on what needs to be done and steps to be followed on how to run the health check from admin console?

Hi everyone, I'm looking for documentation or guidance regarding the download document from s3 bucket. My node is completing but no file is appearing in the target folder. So, what could be the issue?

Hello, I am using the PDF from XSL-FO Transformation with Fonts Smart Service from the Dynamic Document Generator (https://community.appian.com/b/appmarket/posts/dynamic-document-generator) plugin, version 1.9.1 I have no examples of using this Smart Service and the plugin documentation doesn't have specific examples. I have tried to use the only complete code I can find in the community: https://community.appian.com/discussions/f/plug-ins/17891/pdf-from-xsl-fo-smart-service  This produces a PDF without errors, but when I try to open it I get a "Damaged file" from Acrobat Reader. This is how I configured the Smart Service: Xml Document: a constant to test.xml file, with the code from the example Xsl Document: a constant to _xslStyleSheet.xsl file, with the code from the example Xsl Parameters: null Font Document: null Font Italic Document: null Font Bold Document: null Font Bold Italic Document: null Create New&

Hi All, Is anyone aware of Export Database Data to CSV smart service? We are using this smart service in one of our processes and saving the data in one table using Import Database Data from CSV. Export in CSV is working fine but when importing the data in table, it is giving format error on date column. We want to find how this Export Database Data to CSV works to understand if this format change is occuring when generating the CSV. We are currently analysing all the possibilities of this issue. Kindly assist. Thanks and Regards,Diksha

Hi, I am unable to convert csv to excel using smart service "Generate Excel from CSV" after downloading plugin "CSV to Excel", version: 1.0.1. It was working earlier with version 1.0.0. Please update us with a solution to this since it is impacting business requirements. Regards, Akansha Kumari

Hi anyone know how generate qr code with embedded logo in the center of the qr?

Hi All, These are the steps which we have done to generate the Doc. Step 1: Created a Docx using Create Dynamic Doc from Template. Step 2: In That Docx we have a table, we have a paragraph and we have an Image which populates dynamically which is like a signature.                                                                                                    «[#if signature?has_content]» Your sincerely,   «[#else]» No Signature added «[/#if]» Step 3: the Docx

Hi All, We have a Use Case in which we need to do the excel header validation for the Excel File which is having 358 columns and 12000 rows of data. When we tried to execute the below code: fn!readexcelsheetpaging( exceldocument: ri!excelFile, sheetNumber: 0, numberOfColumns: 358, paginginfo:a!pagingInfo( startIndex: 1, batchSize: 1, sort: null ) Output : It is not returning any data for 12000 rows, however it is working for max 8000 rows in excel file. Do anyone has faced same issue or error ?

Hi All Good morning! Can you please let me know if anyone has used the  googleGanttChartField or timelinechartfield plugin in Appian to create a gantt chart using dynamic data, (i.e) data from a record type. If so , can you please providing the guidance or a sample code snippet to configure the same ? Thanks for your help! Regards Soniya PS

I have requirement That One question with multiple answers using poll option Can we do polling in Appian. Thanks, Divya

Hello All, The requirement is to send the entity data with the header and footer. Header and footer contain dynamic data. Header is not columns name; columns name will be the 2-line code. The file needs to be csv Pipe separated file. Sample file. H|2022-11-16|Filename Name|Age|City|Department Sahil|26|City1|Dept1 IBM|27|City2|Dept2 Appian|28|City2|Dept3 T|2022-11-16|Number In the above sample file data, the bold one is the header and footer. Thanks in advance

Hi there! We are looking for a plugin for QR Scan, We need scan and detect a QR from appian interface. Have we any way to do that? without take or upload photos? Usually we have seen this in many apps and Appian should have a way to do that. Thanks in advance!!

After updating the plugin getting the following errors (Note: It was working fine in the earlier version) : Import CSV to Database v6  - Changed to Date Format must be one of the following 'yyyy-MM-dd', 'yyyy-MM-dd HH:mm:ss', 'yyyy-MM-ddTHH:mm:ssZ', 'HH:mm:ss'.Snippet of Datetime format - "2021-12-10 14:20:42.740"    Load CSV File To Database (Using Out-of-Box Appian Datasource) - java.lang.Exception: This method only work with MySQL databases.

Hi Team, I am looking for a plug-in or Public Appian API or function to list all Folders in an Application including rule, process model, KC, document folders. I tried with below function which returned only the folders inside KC of an application when given searchCriteria with APP_PREFIX&*. Please do the needful findcontentbyattribute( searchAllContent: false(), contentType: "folder", attributeName: "name", searchCriteria: "<APP_PREFIX>*") Thanks, Bharathwaj RK

Hi I am trying to find inactive users using getuserlastlogin function. It returns date for some user and for some user it returns null. Am I missing anything?

Can we hide a table along with its header dynamically in a word document if no rows are available for that table??

Hi, i have a requirement to extract a particular cell(integer) from an excel sheet the specified cell is in G column 46th row. Please update on the solution.

HI,  I'm trying to use Delete Rule/Constant Versions smart service to delete rules from a specific folder, I was able to execute the node perfectly, but the versions of rules/ constants are not being deleted.  Can someone suggest on what needs to be done? Note: Currently I'm using 1.4.0 version of the plugin.

I am having trouble figuring out how to add events to the calendar template utility that I've added to my application. I'd like to be able to add events directly from the calendar interface if possible. The process model has already been created, I'm just not sure how to go about actually implementing the functionality.

I am trying to import the calendar template plugin to my application as I would like to use the calendar component in an interface. However when I try to import the zip file, it is only importing the CT application and a couple of the folders but nothing else. I ran an inspection and got the above result. In the import log I am getting the reason for the error as "User Does Not Have Rights to Perform this Operation (APNX-1-4071-007)". How would I go about fixing these issues and importing the entire package?

Hello, can the usage of plugins (once installed) restricted with a security(role/permission model or something similar? Thank youThomas

Hello All, I need to display excel within appian UI (interface may be). I need to edit the excel and save it back to where it was (knowledge Centre). How can I implement it? any suggestion is appreciated.

Is it possible to read a password protected excel? I tried using function readexcelsheetpaging() as below readexcelsheetpaging(  excelDocument:<<doc>> sheetNumber:0, pagingInfo:a!pagingInfo(1,-1),   password:"ABCD@1234") However, I am getting error: Expression evaluation error at function 'readexcelsheetpaging': The passed parameter(s) are of the wrong type. Received the type com.appiancorp.common.xml.JaxbConversionException: JAXB was not able to produce a value for typed value TypedValue[it=3,v=ABCD@1234] as java class java.lang.Integer.

Hello everyone, Is there a plug-in, or an option in Appian, to implement a RFC 3161 Protocol compliant external Time Stamp, when applying a Digital Signature to a PDF document? The Timestamp should be embedded in the PDF document itself. There should be a possibility to choose the Hash algorithm which can be one of the following: SHA1 SHA256 SHA512 MD5 Any help is appreciated.

Hi,We are getting below error when trying to read document from MFT folder. It was working fine and suddenly breaking.[Appian Work Item - 245513 - WorkID 6 - execution02 - process 537248294 - model 8379 : UnattendedJavaActivityRequest] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=536905115, classname=com.appian.ps.plugins.sftpsmartservices.ReceiveFileOverSFTPBasic java.lang.StringIndexOutOfBoundsException: String index out of range: -1Could you please help me here?