Plug-ins

Process states- Error writing mail to the database, that's what am receiving while running this smart service on the process model, not sure what configuration changes are required.Log states- ERROR com.appiancs.msgraphmail.MSGraphDBHandler - Error writing mail to database java.sql.SQLSyntaxErrorException: (conn=642804) Unknown column 'DOC_ID_NO_ATT' in 'field list'Can anyone help us here.we are using MS Graph Mail Poller smart node to get emails from outlook, but getting the above error, we had already go microsoft azure connection setup.

Hi Team, I have done a small POC on converting DOCX to PDF by Dynamic Document Generator Plugin but the value is blank what I expected in PDF. So if you can suggest it how to display the value in PDF from DOCX by seeing this POC? [View:/cfs-file/__key/communityserver-discussions-components-files/19/5775.Convert-DOCX-to-PDF.docx:320:240]

Hello all, Doing security standardization for more than 100 Appian Applications. Want to  add group as a viewer or administrator for each application. Is there any smart service which will get call from process model add update security roles.   Thanks in advance. Regards, Bhushan

Is there a way to have a calendar component show events (records) on an interface, and be able to select a given event to go to that record summary? Here is a picture with an event, I am using the googleTimelineChartField component, part of the googleChartsFieldv2 plug-in. I want to select the event (in orange) to go to its record summary - how would I do that? Thanks!

Hi everyone. I ran a test recording with jmeter 5.3 using the appian library AppianJsonParser-20.3.0-SNAPSHOT.jar that was pointed out to me. Initially I noticed that the library failed to save the X-APPIAN-CSRF-TOKEN automatically in all call headers and I had to manually insert the value ${COOKIE___appianCsrfToken}. Subsequently the test went on overcoming the initial errors due to the failure to valorise the token indicated above but now it has stopped me at this error (APNX-1-4105-004) which I cannot understand. Can anyone help me figure out what's wrong with the call?

Hi Champ, I am using "<w:br/>" in my expression to have next line when generating my docx file from docx template. It's working fine there; but the same is not working when it's converting to PDF. I have another issue while generating the checxbox in PDF. It's rendering fine in Docx ; but the same is not working in PDF.  I am using pdf from docx plugin for the same. Can someone help me on that. Regards, Ghanashyam

Hi Team, How can I deploy a custom component to Appian Cloud? I don't want publish it to AppMarket, it should be a private component plugin.

Hi Team, Adobe Document Services and Adobe Sign plugin is compatible only for 23.1 version. Is this plugin available in 22.2 version?

Hi  I am not able to connect with google sheet using google sheet plug in, when ever i test connection from connected system i am getting permission denied issue.

Hi, I have a requirement to change the alert for all pm. I find a plugin and it can modify the alert recipient by the smart service PMAlertsRecipientsSetter. But it need the pm uuids as the input. Is there any plugin has the function to get all process model uuids / ids / details in an application? Or any other way to get this input? https://community.appian.com/discussions/f/plug-ins/18173/process-utilities-plugin-to-bulk-update-alerts This question mentioned getapplicationprocessmodelsuuids() but I don't know which plugin has this function

Hi there, Anyone here know how to connect to GitLab? I see there is connected system for GitHub, anyone know there is one for GitLab? Thanks, Lin

Hi Team, I need a plugin having capability to convert DOCX to PDF format. I tried below available plugins for my requirement but I am unable to get any OPEN-SOURCE available for this.  advanced-document-templating-1.0.12.jar (It is not converting complete data. It only shows only picture format data to convert DOCX to PDF not shape format) dynamic-document-generator-2.0.4.jar (It is not converting complete data. It only shows picture format data to convert DOCX to PDF not shape format) convert-docx-to-pdf-(aspose)-2.0.10.jar (It is a paid License) Out of these plugins, convert-docx-to-pdf-(aspose)-2.0.10.jar this plugin  have the capability to convert DOCX to PDF but paid license required. So if you can suggest any other plugin which is available on Appian AppMarket to use for converting DOCX into PDF. (That should be Open Source)

Hi All, We are using  PDF from Single DOCX (with Fonts)  to conver a word into a PDF , After conversion it gives a extra solid lines randomly which is not there in the actual template Template :  Document: Thanks In Advance

How do you install and set up Automated Versioning Manager if you're using Appian Cloud? Thank you.

Hi All, Can someone suggest me the ways of converting an encoded base 64 format into a PDF file? Thanks In Advance, Gousii.

Hi All, Can any one guide me to use Unarchive process smart service plugin? I just need to know the security permission required to unarchive a process. If i am system administrator, I was able to unarchive process but i am not able to do the same if am having basic user permission.  Note: I have administrator access to both "Unarchive PM" and target PM(Which i need to unarchive). Also I was able to use "Archive process" smart service successfully with basic user access. Please suggest any reason behind this. Thanks in advance!

Hi, I am working on an editable grid which shows excel data. I am fetching excel data from excel using "readexcelsheetpaging()" function. Now i want to map data to editable fields and i tried to do fv!item.fieldName but it is not working. a!localVariables( /*local!studentData:excelreadcellsbyname(ri!excelFile,{1},{"A1","B1","C1"}),*/ /*local!studentData:excelreadcellsbynumber(ri!excelFile,{1},{1,2,3},{2,3,4,5}),*/ local!studentData:readexcelsheetpaging(ri!excelFile,0,a!pagingInfo(2,10)), local!gridDataType: 'type!{urn:com:appian:SD}SD_Student_Data'(), a!formLayout( label: "Student Details", contents: { a!sectionLayout( contents: { a!gridLayout( label: "Editable Grid", labelPosition: "ABOVE", headerCells: { /*a!gridLayoutHeaderCell(label: "ID"),*/ a!gridLayoutHeaderCell(label: "First Name"), a!gridLayoutHeaderCell(label: "Last Name"), a!gridLayoutHeaderCell(label: "Em

we recently implemented a process to read emails from an outlook inbox using the MSGraph email poller detailed here: https://community.appian.com/b/appmarket/posts/msgraph-email-poller after implementing we're seeing severe performance issues where the poller is only able to process one email per minute. the emails have a 1mb attachment, and per the documentation, we are expecting 30-50 emails per minutes at the very least. does anyone have any insights they can share to get around this performance issue?  thanks!

Hi, I have been using the Deprecated Export SQL to Excel Smart Service for a document download functionality. When the process model is initiated back to back like twice, or randomly out of nowhere with even the first try, the smart service gives this error and the process model fails: "The following error was raised by the Export to Excel function: ORA-01843: not a valid month".  I did an analysis on the SQL code, it works on the database and I believe it should be fine. In the SQL code, I have to_date function and I am comparing two dates with different formats such as MM/DD/yyyy and yyyyMMdd. I am wondering if anyone else is facing a similar issue and what would be the possible solution?

Hi, Scenario: In one of the integrations, the output will be in XML format and in that XML output there will be encoded PDF under a tag< DOCUMENT>. How to read that encoded PDF file and how to convert that into a PDF. Thanks & Regards, Shaik Gousiya.

Hi Champ, I am using docx from template smart service to create my docx from a template and converting to same to pdf later on to generate my pdf in the required format. I have a use case where I need to show checkbox to the user which they can fill it later on. Is it feasible ? Regards, Ghanashyam

Hi Guys, I had a requirement that my Appian Application needs to consume data from Kafka. For this i have added a Plug-in called (Kafka tool). It contains 2 smart services.  1. Consume from Kafka. 2. Publish To Kafka. So, i used Consume from Kafka Node in my process model. In data tab there are following Node inputs and node outputs to configure. Node Inputs: Servers * (Text) Data Source Name * (Text) Transaction Table Name * (Text) Security Protocol * (Text) Secure Credentials Store Key (Text) S A S L Mechanism (Text) Group Id * (Text) Num Consumers * (Number (Integer)) Topic * (Text) Job Type Id * (Number (Integer)) Runtime In Minutes * (Number (Integer)) Polling Interval In Ms * (Number (Integer)) Sleeping Interval In Ms *&nbs

Hi, Move to collab is not receiving files from the folder. Files exist in the folder and Poll File System folder smart service is able to read the list of files. Details below: 1) Move to Collab Output 2) Poll file system folder Output Both constants point to same folder on local server. Please let me know if anyone has faced this issue

Hi! I am currently using the smart service "MS Word 2007 Doc from Template" to generate a word with a default template and to be able to retrieve the data of a record within a label that can be printed as a sticker. My question is, is there a way that I can generate a word document with N records and when I retrieve that data each record is stored in a separate tag. It would be something like this: Thanks for your help.

Hi Appian folks, I was trying to go through Appian documentation and academy for creating a custom function plug-in. I had a question: Trying to import "com.appiancorp.suiteapi.expression.annotations" on IntelliJ for Java class. It is unable to recognize the "com.appiancorp" library. We might need a JAR file for "com.appiancorp" package. I am trying find the JAR file to download but unable to find it. Am I missing anything here? Also, is there any other approach that you could suggest to get the appropriate libraries to create a custom plug-in for Appian via. IntelliJ?