Plug-ins

I am facing issue while using the SSH Key Pair authentication for SFTP. So when I am trying using Basic Credentials, I am able to establish the connection with Remote Directory and able to Send and Receive File. But for same username when I am trying through SSH Key Pair authentication I am getting error as ".filetransfer.sftp.SendFileOverSFTP - com.jcraft.jsch.JSchException: Algorithm negotiation fail". I have created Third-Party Credentials in Appian using the username only and uploaded the private key along with a constant associated with it. Here is my File Transfer Configurations CDT: 'type!{plugins.ps.appiancorp.com/.../}FT_Config'( serverHostName: "xyz.com", serverPort: 22, scsExternalSystemKey: "aws-cmd", usePerUserCredentials: false(), privateKeyFile: cons!MS_SFTP_USER_PRIVATE_KEY_FILE )

Hello Everyone,  I am trying to show a hyperlink field in a word document which generates from 'Docx from dynamic template', the URL for the hyperlink will be dynamic passed from a rule. I tried using the merge field logic to show dynamic hyperlink but couldn't find a solution. The link always redirects to downloads/URL something like - C:\\Users\Downloads\mergeField. I would like to know if there is a way to link a dynamic URL. Thanks in advance. I tried the merge fields based on the blog below, but it didn't work. blog.softartisans.com/.../ The hyperlink is always redirecting to downloads as shown below. Tejaswi

Good morning everybody, With the plugin Dynamic Document Generator I can not modify the fonts, I can not add unicode symbols of special characters like the checkbox, the html page is saved in a single page, the borders of the tables are displayed differently from the html, do you know how I can solve all these issues that I can put chech box, generate more than one page and the borders when I want to move from HMTL to PDF. Thanks 

Hello, SFTP Send File smart service is failing with the error Connection refused. Third-party credentials are setup and have not changed. The plugin has access to the third party credentials. We are passing the values to the smart service as below:             File Transfer Configurations: 'type!{plugins.ps.appiancorp.com/.../}FT_Config'(             serverHostName: cons!SFTP_HOST_NAME, (text)             serverPort: cons!SFTP_SERVER_PORT_NUMBER, (integer)             scsExternalSystemKey: cons!SFTP_EXTERNAL_SYSTEM_KEY, (text)             usePerUserCredentials: false(), (boolean)            )            Remote File Path: /filePath/fileName.pdf            Document To Send: Document Can you please let me

Hi Team, I am getting a below error:  [Appian Work Item - 617826 - WorkID 530 - execution02 - process 537400621 - model 281 : UnattendedJavaActivityRequest] ERROR com.vuram.pgp.util.KeyBasedLargeFileProcessor - message integrity check passed. Is anybody else is facing this issue? Is there any way that i can resolve this error? Thanks, Sayali

If I have four tables in a database how do I export them in a single sheet of Excel? 1

I'm trying to use encryptvalue() and decryptvalue() in my existing rule. The purpose of using this function is to encrypt a value before inserting to Appian Cloud Database and decrypt a value when reading it from Appian Cloud Database. When trying to use encryptvalue(), I got an error saying ```Expression evaluation error at function 'encryptvalue' [line 2]: This plug-in [com.appiansolutionengineering.encryption] is not registered to access secured values for the given external system key [encryptdecryptkey]. Check the external systems plug-ins list in the Administration Console.``` Currently, I don't have any third party credentials nor Plug-Ins registered. How to use encryptvalue() and is there any other work around for encrypting data in Appian Cloud Database?

Hi All,  We have a requirement for counting the number of pages in a word Doc , Is there any solution for this.  Already tried to convert to PDF and to take the count but format is getting changed and not getting the exact count.

So the requirement is to generate a PDF with dynamic fields, so we created a word document and when we are trying to convert word to PDF, the format is getting chnaged entirely. Tried 1. PDF from DOCX : The format is completely deteriorate what should we  pass "PDF Options" Tried 2. PDF from Single DOCX with Fonts , Content not visible in PDF (what should we pass in Font Document) Tried 3.PDF from HTML : Getting document in one single page

Hi! I am trying to generate a pdf document from an html using the "HTML to PDF" plugin. The html structure used is the following: // HTML <table> <thead><tr><td> <div class="header-space"> </div> </td></tr></thead> <tbody><tr><td> <div class="content">...</div> </td></tr></tbody> <tfoot><tr><td> <div class="footer-space"> </div> </td></tr></tfoot></table><div class="header">...</div><div class="footer">...</div>// CSS.header, .header-space,.footer, .footer-space { height: 100px;}.header { position: fixed; top: 0;}.footer { position: fixed; bottom: 0;}The problem comes when transforming to PDF. It works by replicating the header, but from the second page the content overlaps the header.My cloud version is 22.

How to convert text to UTF-8? Do we have any function or plugin for this?

Convert current time to milliseconds. Ex. 1719220373569 (5:13 pm in China) Any idea, how we can achieve this in Appian? Any function or plugins?

Please tell me how to use "Create PDF". I would like to overwrite data on an existing PDF and create a new PDF. Therefore, I implemented the following processing. ・Copy Template PDF: Create a copy version of the base PDF and store it in "pv!copyTemplate" ・Edit PDF Name: Change the name of "pv!copyTemplate" ・Create PDF: Each parameter is set as below.Create New Document: falseExisting Document: pv!copyTemplatePause On Error: falseContents: (describe the contents as an expression) No values ​​are set for any parameters not listed above. This is the PDF to copy from.I have confirmed that the content is retained even after the "Edit PDF Name" process is completed. However, when the "Create PDF" process is finished and you check the contents of the same file, it looks like the following.The value set in the parameter "Contents" is listed, but the PDF that was supposed to be set in "Existing Document" is not reflected.

Hi I have to create a document with dynamic grids, Is there a way to generate document with dynamic grids using any of smart services/Plugins available in Appian? Thanks R Gopala Krishna Raju

Hi Community, I using Import CSV to Database smart service to load data into a database staging table. and I am getting the below error. Can anyone please help?

Can someone help in configuring DOCX From Dynamic Template What document should be sent for Docx Template and how to generate Xml data model, Can someone share sample screenshots

Hi! I'm trying to use the "Log Reader" pluging to read the login-audit.csv logs through expression rules, but it doesnt work. According to the comments on the pluging it seems that this is a common failure, so does anybody knows how to make it work or any other way to store this information on the Appian Database?

In our project each person has a QR code generated and stored as an image in Appian. I have to generate a single PDF out of "N" number of selected persons QR Code images by having them side by side and a page can have max of 18 QR codes. Please see the attached image for the expected document.Any idea how to achieve this? Thanks in advance.

Good afternoon, I am encrypting a simple text to test with hmacsha256bytehash, but I can't find any functionality to decrypt it, could you help me? Thank you so much

DOCX from dynamic template plugin node is available in my community version how to import that in my community sanbox

HI All, I have a requirement to process a CSV file to my database. i have used a smart service(Export CSV to Database) from Excel Tools plugin. But some of the special characters are not read properly.For example:  The data i have received in CSV has : ~@ö<é;ó¿üäÖÇ*àÄ=É!"ѧæñ á½èçòíê° after consuming the file i have got this in my database : ~@�<�;�����*��=�!"ѧ�������� Can anyone suggest if we have any alternative options for this please. Thanks,Sai Kiran Pannala.

Hello, We are connecting both appian and AWS. will upload documents from appian side and in aws will extract and store the data. Now to populate data in  Appian to establish a connection found a "AWS Opensearch".plugin. When trying to download getting an error stating "This app is available to download for Appian Customers, Partners, and Employees. Please make sure to self-associate from your profile". Can someone guide me what needs to be done from my end to use this plugin. Or any restrictions for using this plugin what other approach i can take to get the data using opensearch service Regards, Chaithra

Hello Appian expert, We want to send emails from Appian using Outlook 365 account. For that, we tried using MS Outlook 365 connected system and followed all the account set-up steps. but the connected system is not able to validate credentials and returns 'Invalid Access' Steps:  Login to Azure AD, go to ‘App Registration’ and create a new app. Use the generated Client ID and Tenant ID from that app into the connected system Generate client secret from ‘Certificates and Secrets’ and pass it as input In the ‘API permissions’ option, click on ‘Add permission’ > select the Microsoft Graph API > Add (Application) Mail.Send permission Use emailaddress@domain.onmicrosoft.com email id To confirm, we are able to use the same account using MS Graph Explorer and successfully send emails. My questions: 1. Have you used this connected system and if so, please share any of the steps we missed? 2. What are the alternative

Hi everyone, I'm having an issue with Read MSG plug-in that the generated output .html document is coming out blank. The .msg file itself does have content in it though. I config the Read MSG node as guided in the plug-in documentation. The generated document (output html file) was stored in a process variable. When I download that html file from Appian folder and open it, it is a blank file.  This is the original msg file:  And below is the generated html: I'm looking for a solution to solve this issue or a workaround way for me to convert .msg to html. Does anyone have any idea?  Thank you

Hello! My team and I are attempting to create a demo of a project for potential customers. The intended application would be able to take images from a mobile device, save these photos as documents in Appian, and have workflows in which those photos would be viewed/displayed in high enough resolution for end users to make determinations based on said photos. In your experience, what are the best plugins to achieve this functionality? I have found an image capture plug-in component from Vuram on the appmarket, but from the comments it seems that the photos are binned down to a very low resolution, which may disrupt our workflow tasks.  What is the gold standard for image capture and viewing in Appian? Thank you so much in advance for your help!