Plug-ins

Hi all, I have an issue concerning Add Documents to Zip plugin.  More specifically with the customer being able to unzip the files with the default WinZip utility.  Currently the zip files are empty and they are forced to use 7-Zip.  Since it's not really a best practice to ask the customer to download a third party software to unzip the files, I would like to try and troubleshoot the issue.  Side note** All company internal members have no issues unzipping the files using WinZip.  This is purely an external issue.

I am having same field names in database table as well as in my excel file. Also configured it in data store correctly. But while using import excel smart service to dump data, even after providing same table name as database table, data source name- "jdbc/Appian", and excel document having similar fields, there is no error populating but I cannot see my data in my database, nothing's happing there. 

Hi all, I have a list that I need to display the fields dynamically for, and one of the fields are a list. Right now I am using a styledTextEditorField for users to input a list, and the output is in HTML format. The document template I use so far is this - «@before-row[#list doc.notes.note as n]»«${n.@title}» Reports(s): «${n.@reports}» «${n.@noteText}» «@after-row[/#list]» The noteText must be a list, and if I try to export with the noteText as is, it just exports the html directly like  <ul><li><p>edit 1</p></li><li><p>edit 2</p></li><li><p>edit 3</p></li></ul> When I try to replace the special characters in the XML generation it throws an error  "The value of attribute "noteText" associated with an element type "note" must not contain the '<' character."(Text)

Hello everyone, I'm trying to retrieve logs using the Log Reader plugin. I've encountered an issue. When the log file exceeds 10 MB, the previous log data is stored in a file named "xxx.csv.1," and the original log file ("xxx.csv") is initialized. I can successfully retrieve log data from "xxx.csv," but I'm unable to access the data in "xxx.csv.1." According to the Log Reader documentation, it should be able to read "xxx.csv.1." Is there something I'm doing wrong? Any advice would be greatly appreciated.

Import Excel to Database  Plugin -  we are importing the data with this plugin and using the latest version of it, but in the new version we are seeing one issue,  Excel headers and Table columns name required  to keep the same, for example  CONTACT_NUMBER(Excel template)  = CONTACT_NUMBER(Table column) then only plugin is going to work. but user's file header with Contact Number not CONTACT_NUMBER.  is there any alternative way to have headers with camel case and the logical wording not the table column name in the template like CONTACT_NUMBER or any way to edit the template headers after upload and to make change in header from Contact Number->  CONTACT_NUMBER(Excel template) to match table column name?

I've created a new company specific Component Plugin following the Package Structure - Appian 24.2. It was submitted, approved and signed. When I've tried to deploy it in our cloud-based DEV environment, then plugin upload returned with an error. In the logs I can see the following:2024-07-23 20:34:59,754 [ajp-nio-0.0.0.0-8009-exec-13068] ERROR com.appiancorp.plugins.LoggingPluginEventListener - Failed to load Plug-in 'plugin-id' (plugin-id) version 0.0: 'customfield (1.0.6) - Could not find html-entry-point file: index.html'2024-07-23 20:34:59,757 [ajp-nio-0.0.0.0-8009-exec-13068] ERROR com.appiancorp.plugins.DeployUploadedPluginReaction - Failed to deploy plugin file customfield_1.0.6_signed.zipjava.lang.IllegalStateException: Plugin was deployed but not successfully enabled We've checked the plugin file with more colleagues together, and it follows exactly the required structure, and index.html file is in the customfield/v1 folder as required. Did yo

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