Plug-ins

Good Day I am trying to send a csv file from Appian to an external sftp server. I have setup the username and password in the 3rd Party Credentials and I added the plug-in to the allowed Plug-In list. In my configuration of the SFTP object: i have the following for file transfer configs: where server host name refers to the actual server name. Remote host path:  Document to Send : pv!stockData   ( where pv!stockData is of type document and is an output from the Export Data Entity to CSV : Process model runs but I am receiving : FAILED and the error is "No Such File" Please advise what I have done incorrectly. Thanks

I'm encountering an issue with the Automated Versioning Manager (AVM) in Appian while managing application exports and imports through GitHub. Here's the scenario: When I export an application from Appian Designer, I receive a ZIP file that contains a 'META-INF' folder. Inside this folder, there are two files: 'export' and 'MANIFEST.MF'. I then use AVM to push this ZIP file to a GitHub branch. When I download the ZIP file from the GitHub branch or update my local repository with the application using the AVM command, the 'META-INF' folder now contains an additional subfolder named with the UUID of the application. Inside this subfolder, the same 'export' and 'MANIFEST.MF' files are present. Due to this additional subfolder, when I try to import the application back into Appian, it throws an error: The specified file does not contain a valid package and cannot be imported. (APNX-1-4154-000). How can I prevent the creation of thi

Hi, We are trying to use Kafka Tools plug-in to consume and publish from Kafka with Schema Registry from Confluent Cloud. This plug-in does not support AVRO format in Confluent's Schema Registry, so we're evaluating if we could solve this by creating a Smart Service Plug-in to serialize/deserialize with the AVRO Java libraries. The idea is to serialize the messages before using Publish to Kafka and then deserialize the data after Consume from Kafka stores them in db. Does anyone know if these Smart Services can send and receive the binary in AVRO format? Has anyone tried to do this or something similar? Thanks in advance

Is there a way to get list of unused plugins across the environment?

Hello,I am using Cucumber for Appian for Automation testing.  I am using syntaxGiven I populate field type "File Upload" named "FIELD_LABEL with "VALUE" to upload a file. I have tried giving absolute path of the file in "VALUE" and I get error  message:<<An error has occurred: Wait for Field Type - FILE_UPLOAD - File Upload>>

Hi All,We are using Fill PDF plugin in our project. We are getting the contents.error.alertMsg error sometimes. In some previous thread, its mentioned that this will come when there is some null value. I provided " " values for null values, but still getting the same error. Any insights on this issue.

Hi, we are using import excel to db plugin to dump data from to excel to DB. It is reading the data from excel cell. But if the excel cell contains "- ", / "$" then the plugin removed the value from the content.  For example: Excel Cell Contains "Testing - Monday", then in staging table contains "Testing Monday" Excel Cell Contains "Testing$", then in staging table contains "Testing". Is anything we missed. Can anyone help on this.          

Hi I have UI screen interrace which consist of custom plugin and Appian SAIL component (button). Is there a way to pass event to plugin in response to outside UI events. I want to invoke a function inside my custom plugin when submit button is clicked.   How can I archive this?  

How to pass parameters dynamically to HTML to pdf smart service?

I want to create a password protected zip and while executing this plugin, it creates the zip but it is not password protected zip file. Also, while I trying to extract the files from zip, getting error for all the files in zip. I am facing the same issue with another plugin (Zip Utility -> Create Zip File) from same provider.Please check the screenshots below: 

When trying to import data from CSV to Oracle DB, getting  Error executing SQL java.sql.SQLSyntaxErrorException: ORA-00904: "column_name": invalid identifier . CSV File has headers and they are same as column names in DB table. Has anyone encountered this issue? Also noticed that the column names in sql statement are framed within " quotes like below Caused by: Error : 904, Position : 49, Sql = select "column_name1", "column_name2", "clumn_name3", "column_name4" from "table_name" where 1=0 , OriginalSql = select "column_name1", "column_name2", "clumn_name3", "column_name4" from "table_name" where 1=0 , Error Msg = ORA-00904: "column_name4": invalid identifier Note: Facing this issue only when file has headers in it.

We are trying to utilize the Pinecone integration from Appian, but running into a problem where it requires environment to be defined. We have reached out to Pinecone who has informed us that they have a new SDK where environment is not required and that the Appian call needs to be updated. Are there plans to updates this integration point? Can you give some guidance, we have a project that requires this integration. Here's the information from Pinecone: "Pinecone no longer requires the environment to be part of the connection. Our latest SDKs all connect to a global control plane instead. This means a single project can now host indexes in different environments/cloud regions, and you only need to set the API key to use your indexes." Can somebody help us with the update to the pinecone plugin

Hi, We are looking into creating a custom Smart service plug-in to serialize/deserialize using the AVRO Java libraries. We have seen that the code can be sent through the AppMarket Submissions Site for approval, but in the documentation page that details how to build this type of plug-ins it says the for Appian cloud customers it has to be tested in a licensed local installation of Appian. "In order to individually build a custom smart service plug-in, a licensed local installation of Appian is required. Appian Cloud customers who have a local installation must develop and test the custom smart service locally and coordinate with Appian Technical Support to deploy it on their site." If anyone know the steps that we must follow to get a custom Smart service plug-in reviewed and approved, or if anyone has already done this before and can tell us about the process it would be really helpful. Thanks in advance

Hi Community,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 "invalid privatekey: [B@41050c98". I have generated the Key Pair through Puttygen software, and the Remote directory Team has configured the Public Key on there end. Please if anyone have any idea regarding this help meThanks, Prathamesh

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?