Plug-ins

I have a required where i have to load more than 1lakh records of excel data in database is there any way to do that from excel to database. do appian 17.4 version support below plugin?

Hi We are using JMS Message Producer plug in for IBM MQ. We are getting "JmqiException: CC=2;RC=2059;AMQ9503: Channel negotiation failed. [3=APPIAN.EUSFE1A.S1]" error in Appian and " AMQ9637E: During handshake, the remote partner sent no certificate. EXPLANATION:The conversation cannot begin because a certificate has not been supplied bythe remote partner." error at destination. Could you please help on this?

Hi, Have a requirement to see if there is a way to dynamically add a signature field anywhere on an existing PDF form.   I ran across this bulleted feature related to sign pdf plugin and was wondering if anyone would chime in on experience using this feature.   There doesn't seem to be any documentation for the plug-in so wanted to get input from the community before seeing if it works.       Place a new signature field anywhere on the document  (https://community.appian.com/b/appmarket/posts/sign-pdf-document) If anyone has any success stories/experiences to share  using this plug-ins feature would enjoy hearing about them before investigating deeper (e.g. does the feature work?   Any requirements on type of PDF document required, fillable or non-fillable PDF? Thanks, Bob

Hi, I am using the plug in Import CSV To Databasev6 to load data from csv to a database table(Oracle SQL Developer) but I am receiving the following error:- ERROR com.appiancorp.ps.exceltools.smartservice.ImportCsvToDatabase61 - Error executing SQL; java.sql.SQLSyntaxErrorException: ORA-00904: "contact_area": invalid identifier; ; at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509); at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461); at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104); at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553); Can anyone help me resolve this error?

We are looking to achieve an in-app eSignature function within our Appian workflow process. Is this available? DocuSign integrations are available in the AppMarket, but all seem to route the user outside of Appian to the DocuSign platform to capture the approver's signature. Adobe Sign Utility & Sign PDF Document both seem to be more in line with our request, but I would like to confirm if either are feasible. Screenshot below shows the PDF embedded in the review pane where we would like to capture the eSignature directly within Appian. 

Can someone please provide getAllKCs plugin here..not able to find it in the community

How do i use GitHub connected system plugin 

Hi all, I am trying to fill a pdf with process information but I only read that it can be done using a Form PDF that you can do it with Adobe for example. I don't have this app so I wonder if exists another form to fill a template that I have as PDF. I tried to put the parámeters between ###parameter1### as it works for HTML but obviously the getpdffields() function doesn't return any parameters. I am also attaching the document that I am using as a test template I hope anyone can tell me an alternative solution. Thanks in advance. Sergio. [View:/cfs-file/__key/communityserver-discussions-components-files/19/Prueba-Minuta-_2800_1_2900_.pdf:320:240]

Hi, I am new to Appian. I need to integrate Twilio Chat functionality in my Appian Application. We have Partner account. I need to know exact steps for integrating Twilio in detail. E.g. Twilio account creation, Set up at appian side. Prerequisites for it etc.

Is it possible to add a Plugin from a Non-paid community site?

I am facing the same issue with "PDF from single DOCX(with fonts)" smartservice, I am passing "Arial" font documents stored in a constant and passing that as reference, but the generated pdf always has "Times New Roman", can you please let me know at the earliest I am saving all Arial Font documents in the constant and passing it, and using that in the html  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <style type="text/css"></style></head><body width="100%"> <p><span style='font-size:20.0pt;font-family:"Arial",sans-serif;font-weight: bold;'>Connecting documents</span></p> <p style='margin-bottom:8.0pt;line-height:180%'><spanstyle='font-size:10.0pt;line-height:180%;font-family:"Arial",sans-serif;'>Welcome to ABC <br /></span><span style='font-size:10.0pt;line

Hi, I am using docx from dynamic template service in my process model, which is working fine and word doc is getting generated using template. Facing two issues here , which are as follows: How to not print the table (grid) when we have no values for the specific process variable , Tried to use if condition in the data model XML , but not working. How do I define the if condition in my word template for null / not null check? The word document generated is converted to PDF using PDF from doc service , but the PDF fields are not properly aligned (though alignment is proper in word doc) Thank you

I have tried to import google analytics utility into my application im getting the below error. kindly help me to resolve this

Hi, I've had to reply to a question about plugins fews weeks ago, but, never could find the correct ones for sure, reading over the Appian documentation : What are the 3 points to verify/valid before to be able to add a plugin in the App Market :  (sorry if the question is approximate) Compatibility with the target Appian versions  Its limits Who is the author Its size  Appian-Cloud-Approved I would have check 1-2-5. What about you ? docs.appian.com/.../Shared_Components.html

Hi all, Is it possible by some method, Plugin or API or whatever, the use of HTML, Javascript and CSS in Appian?If this is possible? If yes, please give an example or show me the path to add those into appain

I have a requirement to convert doc, docx to pdf. I found we can do it using PDF from Single Docx (with fonts) smart service.  This smart service works well for converting docx to odf but it run for .doc files too with inconsistent behavior. For some .doc document this service works fine but for other it returns an error "org.docx4j.openpackaging.exceptions.Docx4JException: This file seems to be a binary doc/ppt/xls, not an encrypted OLE2 file containing a doc/pptx/xlsx" Does anyone else encountered the same?

Hi all,   I cannot find  "Parse Excel Spreadsheet to CDT" smart service in Appian 22.2. Is there anyone know why? Thanks

ContextFor a client I'm currently making use of the Automated Deployment Manager plugin, in this case specifically the deploy-application.sh script. Everything is working fine right now, however we have a specific requirement ask that I'm having difficulty with: Currently, a Deployment through this plugin will halt if the Inspection yields any Error messages it seems. My client wants to be able to have deployments halted upon Warnings coming back as well. I can think of a workaround by doing an Inspect, digging through the result log for Warnings, and using a Process Model / Parent-Script logic flow to halt then conditionally do the Inspect/Deploy action, but that seems inefficient as it forces 2 separate Inspect actions upon a successful deployment. Question Is there any way to instruct the ADM script to halt on Inspect Warnings as well as Inspect Errors, and if not does Appian have any recommendations on what modifications could be made within the scripts to accomplish this?

Im getting this error when my document is less than 4 gb and it has only  500 rows. Im trying to modify a excel file with a value in a particular cell this is the value that i want in the cell this is the excel wich has  500  rows this is the configuration of the  the service

I have a template docx that has a total of 3 fields attached template docx, I am required to update only 2 of these fields: 1) doc.project.name 2) doc.project.address,  during the initial document creation. The updated template is then uploaded to SharePoint. Later, I will have to download this document from SharePoint and update the third field. I pass in only the 2 fields into my expression rule to generate the xml. Xml generated via expression rule: <project> <name>Ary Rock</name> <address>/address> </project> Error: freemarker.core.NonStringException: For "${...}" content: Expected a string or something automatically convertible to string (number, date or boolean), but this evaluated to a sequence+hash (wrapper: .. [View:/cfs-file/__key/communityserver-discussions-components-files/19/2625.wordTemplateForDynamicGeneration.docx:320:240] Goal: I would like the updated template document to have the updated fields and also show t

Hi eveyone, I'm trying to add and deploy Content tools plugin, but I get this error: "HTTP Code: 500 APNX-1-4198-019 An Error Has Occurred Expression evaluation error [evaluation ID = e1688:2495d] : An error occurred while executing a save: java.util.UnknownFormatConversionException: Conversion = 'D'" Any suggestions on how I can deploy and use the plugin functions?

Hi All, We are having issue in "Generate Excel from CSV" plugin. The process model executes the steps, however, the output is not generating in the folder. Tried using both the ways "Create New document" true and false. In both option it is neither generating output nor throwing exception. Please find the sample CSV file to be converted. Regards, Aarthi.P

I am using this smart service "PDF from Single DOCX (with Fonts)" to convert docx to pdf, but the bullet points are being retrieved as "#" , is there any way to resolve this?

Good afternoon!  I'm creating an app in 'My Community Edition Site', Appian Version:22.2. I'm using the plug-in Excel Tools, Import CSV to Database v6.  When creating the process, everything is working but the data is not being updated to the database, CDT or record list.  I'm going to attach all the evidences for you to understand and find the problem with me because I don't know what else to do, I've tried many different things, some told me to review the data types or the table name [emoticon:ca08b2c27c2f40e993e89508acf29e0b] The CSV has 3 rows, the header and 2 similar to the picture. If I insert the data in the Could ddbb manually it works perfectly, but it would be better if the process works and I won't need to do 30 inserts. Thanks in advance! Rony-Michelle ;) 

Hey Community suggest me the function or plugin to read excel convert into cdt