Plug-ins

Upon reading or uploading an excel file receiving the following log error 2022-01-20 21:09:00,529 [ajp-nio-0.0.0.0-8009-exec-6] ERROR com.appiancorp.ps.exceltools.expression.ReadExcelFileFunction - Failed to read zip entry sourcejava.io.IOException: Failed to read zip entry source I am uploading a .xlsx file but it is saying failed to read zip entry source. 

Hi All, I am trying to use "Receive a file from RDBMS BLOB" smart service and it is appending zero every time in the file name. Can anyone please help me on this. Any reply is appreciated. Thanks in Advance, Neha Raghuvanshi

Hello, I am using Send File Over SFTP smart service and I'm supposed to place a file in docfiles folder of F drive in the destination remote VM. So I've given the remote file path as "F:/docfiles/sample.pdf"  However File is not being transferred to remote file path and I am receiving No Such File error in Appian though I have sample.pdf available in Appian repository. Any thoughts pls ? Error transferring file to SFTP server2: No such file

I would like to know if we have any replacement or equally functioning Deprecated Export CDT to Excel. I am aware we have Export DSE to Excel but my requirement is to export the local data into Excel and we are not storing data in the table.

Hi, Mail server to database smart service is not working for 21.4 appian update. Its working fine with same configuration for 21.3.  Getting error [Cipher suits are not appropriate] may be the security needs to be updates in java.securities file.

I need the correct format to create inputs when calling the Execute Stored Procedure plugin from an expression rule.  Here is my entire rule. I want to send an integer as an input (and ri!num is an integer) into a stored procedure and retrieve the results as the dataset is too large for Appian to handle comfortably.a!localVariables( local!spResult: fn!executestoredprocedure( dataSourceName: "jdbc/Appian", procedureName: "jsonValTest", inputs: { id: ri!num } ), local!result: if( local!spResult.success, local!spResult.result[1], local!spResult.error ), local!result )Here is my stored procedure: The SQL query when run as a query minus any parameters works. Have I fouled the SQL procedure or do I have the syntax wrong on the execute stored procedure (or both)? Thanks in advance.

Hi Appian DevsI need a bit reference from you to use the right plugin to convert a docx file to pdf which can carry the correct formatting including font style, font family, special characters, ###tags### and text colors correctly during the conversion from docx to pdf.Can you help me in picking out the right plugin?

Hi, How can we take a screenshot of the interface when we click on the button?

We have a process that successfully intakes excel files but below is a use case where the file is not uploaded/error occurs: Use Case 1 - Fail 1. download the excel file from elsewhere (.e. shared site) 2. File is stored on desktop/downloads folder 3. Open Appian > Select file to be uploaded from downloads folder 4. File upload fails Use Case 2 - Pass 1. Open same file that failed in Excel on desktop 2. Rename the file in anyway (i.e. add number 1 to end of title) 3. Open Appian > select new renamed file to be uploaded from downloads 4. File upload is successful Why is use case 1 failing? Can we change something so it is accepted?

I need to download the Eclipse plugin development tool bundle for a new development machine. It was previously available at "s3.amazonaws.com/.../site.xml" but now is not locatable. I've read through the "Extending Appian" documentation and it looks like Appian has removed all mention of how to actually set up your plugin development environment for some reason.

Hi All, Did anyone tried passing the parameter as in condition for a query database smart service For example : update tablename set status="test1" where case_id in ac!caseId How to pass the case ID values of multiple and what is the type of the parameter for this?

I am running into this error on interfaces with the rich text plug-in. Has anyone seen this before? Could it be related to popup blockers? "Failed to load plugin: code from url...." This only happens sometimes when running on google chrome (Appian version 21.4)

We are following the same link ( community.appian.com/.../kafka-tools) to set up the connectivity with KAFKA. We installed KAFKA in the windows system and in same system, Appian is installed. We're trying to connect to KAFKA without SSL/ SASL_SSL. Following are the configuration details we have specified in the data section of configure publish to KAFKA smart service. Secure Credentials Store Key: "kafkacredstore" Servers: "localhost:9095" Topic: "DETestTopic" Payload: "===========Test Payload==============" Security Protocol: "PLAINTEXT" SASL Mechanism: TrustStore: KeyStore: Attached screenshots: 1- Third-Party Credentials configuration 2- KAFKA server.properties we are getting below error. Problem: An error occurred in executing an Activity Class. Details: [Invalid sasl mechanism] Recommended Action: Examine the activity class to correct the error and then resume. Priority of this problem: High Priority

Hello, I’m evaluating the Appian tool for a customer, and one of the criteria I’m looking at is the ability to import BPMN, as well as BI. Tried to install the BPMN plugin from the AppMarket - but all I get is "This app is available to download for Appian Customers, Partners, and Employees. Please make sure to self-associate from your profile." 1. What does that mean? or: "Thank you for your interest! Please confirm that you would like to be contacted about this app?" and I choose Yes.  A couple weeks passed by and nothing happened. 2. any idea?

Hi Can any one help me on how to read EML file in Process Model? I need to map the body directly to a folder instead of downloading it.

Hello all, im currently looking for a way of protecting a PDF with password, in the current version (19.4) we are using the protect PDF plugin, but we need to upgrade the version to 21.4, and it seems that the plugin is no longer available,  i've been looking at similar addons, or some appian feature to protect a PDF but didn't find anything, any suggestion? thank you in advance.

Hi, We are trying to use executestoredprocedure for a procedure written in SQL server. The procedure takes 2 parameters of type 'bigint' and executes successfully within the database client but it fails to execute stating 'cannot convert nvarchar to bigint'. Any idea how to bypass this issue?

Hi Community, I'm developing a plugin and have it installed on my local Appian but was wondering how I can debug my plugin on eclipse. I want to put breakpoints so I can see if my variables are being populated as it is run in process model. Does anyone know how to set it up or is there a guide on Appian? Thank You

Hi,  I have a requirement to create a PDF with one table and known number of columns. But the number of columns are 15 for one of the case.  Till now, my approach is to create DOCX using dynamic template where I have already oriented the page in landscape with narrow margin but still fitting 15 columns on one page is not looking visually good.  So, wanted to check if there is any better approach to do this.. Also, I have already asked the user if those 15 columns are really required or we can cut down to few if possible. Thanks & Regards, Nafis

Hi I'm using 'Import excel to database' smart service in the process model. When I run the process:- 1. It works when we unfreeze the first header row otherwise it throw error 2. It sometimes throw error like "???Invalid Content ID???" or "Index: 1, Size: 1" Does anyone have suggestions regarding the proper configuration of excel required while uploading ?

Does anyone have a good example of a plugin where the output of the smart service is a CDT that was defined by the plugin? bonus points if it's a nested CDT.  I'm getting really close to getting this to work. I have the CDT being successfully created by the plugin, and the smart service shows the correct type on the output tab at design time.  When I execute the process model, I get a runtime exception: 7:39:50,921 INFO  [stdout] (default-threads - 36) 2021-12-13 17:39:50,919 [default-threads - 36] ERROR com.appiancorp.suiteapi.common.TypedValueParameterConverter - Cannot convert TypedValue17:39:50,921 INFO  [stdout] (default-threads - 36) java.lang.IllegalArgumentException: Argument is not an array17:39:50,922 INFO  [stdout] (default-threads - 36)      at java.lang.reflect.Array.getLength(Native Method)17:39:50,922 INFO  [stdout] (default-threads - 36)      at com.appiancorp.suiteapi.common.RecordConverter.convertPara

Hi Community, I'm trying to use Advance document Templating Plugin's smart service PDF from DocX to convert a DocX to PDF. I've attached the example DocX I'm using below and the resulting PDF. The conversion occurs I get a new PDF but a table is missing and the images are displaced. On the community someone mention using DOCX From Dynamic Template smart service before it, but I still get the same results probably because I just have a blank value of "<project></project>" for XML Data Model input. Has anyone else run into a similar issue or know of a fix for this?  Thanks, Eric Example Doc: [View:/cfs-file/__key/communityserver-discussions-components-files/19/sampleTables.docx:320:240] Resulting PDF: [View:/cfs-file/__key/communityserver-discussions-components-files/19/NewDocToPDF.pdf:320:240]

HI All, Where can i find release notes for older versions of Plugins.I want to compare the version differences between the latest and previous versions. Thanks, Sai Kiran Pannala.

Hi ,  we have an on-premise environment and we have installed the this plug-in ( google chart component ) in our environment, and when we started working on it we are facing below error, i have attached a screenshot of the issue .we are using 21.3 version. thanks in advance

Hi, Google Maps Integration is working and displaying fine in Appian Mobile App but the same is not getting visible in Interface, only web content is getting displayed. Checked Integrations and plug-ins, it is working fine and correctly installed. In laptop interface, it doesn't load the API, the API_KEY is working as I am able to see the details on phone after searching. Is there any special setting which I missed to configure the API. PFB the code snippets which is part of cardLayout: ---------------------------------------------------------------------------------------------------------- googleMapsDirectionsField( label: "Directions", labelPosition: "ABOVE", height: "AUTO", googleMapsApiKey: cons!BM_MAPS_API_KEY, origin: local!finalOrigin, destination: local!finalDestination, enableZoom: true(), enablePanning: true(), enableStreetView: false(), enableTrafficLayer: true() ), googleMapsDisplayField( label: "Display", labelPosition: "AB