Plug-ins

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?

Hi all,  May i know how to extract data from an xml file Thank You In Advance

Hello All, My requirement is client is sending an csv file to Appian which we need to insert in Appian table. I am using "Import CSV to Database V6" smart service. But now client want to send the file with some header and footer. Can anyone tell me how to read a csv file in Appian which is having header and footer. In Appian we don't need to save the header and footer we can simply ignore that. But how to ignore that in the Appian because client is sending same file to multiple platforms, so we need to do that in Appian itself. Thanks in advance Regards Sahil Batra

I need to copy the First Sheet from an Excel Document and add the same to the new Excel Document as its FIrst Sheet. can you please suggest the best approach and the smart services. Note: The First sheet will contains the data, so it should not be altered while copying

Hi Guys, Please help me on the below! I need to import list users from excel to the process model and then add them to numberous group. Can you please help me on the same??

Hi all, may I know, how to extract the xml data in an xml file Thank You

Hi all, I notice that the HTML Display Functions plugin is not listed on the app market and therefore may not be supported in the future, but I'm sure that many of us have it deployed in our environments for one reason: the function ncolumntable(). For anyone looking to remove this plugin, I'm including here an expression rule that I wrote to perform a similar task, and it also has the benefit of having no limit on the number of columns. Given a list of column headers, a list of Dictionaries, Maps, or CDTs containing the data to display, identifiers for fields in the data (optional - if blank, a!keys() will be used to determine the list of identifiers for each row of data), and some optional formatting parameters, this rule returns HTML code to generate a table displaying the data. This expression rule has the following parameters: columnHeaders (List of Text) data (Any Type) columnKeys (List of Text) headerColor (Text) evenRowColor (Text) oddRowColor (Text) /*