Plug-ins

Hi all, I am using Import CSV to Database to import a file to a database table. So far I can see the file has to match everything with the table definition but I now I got a strange behaviour. I am using a file with a wrong header but the service return import success as true. Makes sense? The same happens if I use a file with more columns that defined in the table. Can you help me? Thanks in advance.

Hi all, I am using the plugin excel tools to import a csv file to db. But after that I want to validate the headers just to see if the column names are the same defined in the db. I tried the function readexcelsheet( excelDocument:local!doc, sheetNumber:0, startRow:0, numberOfColumns: 10 ) But I only got an error saying "evalution error at line ..." Can someone tell me what I am doing wrong? maybe something regarding data? Thanks in advance

Hi All, Can someone recommend under which plugin I can find the function: translateForUser() and the url for the plugin. Need this function for the multi language support

I have a word document with html tags that I need converted to formatted text. For example I would like <strong>Hello</strong> to display as Hello instead. Currently I'm using Open Office writer doc to generate word document and need to embed html text converted to formatted text which should also preserve coloring and formatting. Open Office Writer Doc From Template Smart Service Does anyone know a way to display code in Microsoft Word documents that preserves coloring and formatting? I have tried to include code as html to parse <b>, <i>, <a>, <li>, <div> and <p>, for example. But all the tags and formatted styles have ignored and resulted in a single normal text. But as of now, I could only display it as normal text as Appian ignores all the html formatted code example <div>, <p>, <li>, <b> etc.

Hello All,We are trying to do FTP over SSL using SEND FILE OVER FTPS (Basic credentials) smartservice (SFTP smart services plugin)We have deployed the necessary client certificate in the admin console yet the smart service gives the error message like ERROR READHANDSHAKE RECORDCan anyone help us identify the issue?

Has anyone successfully used the plugin available here - https://community.appian.com/b/appmarket/posts/imedidata-integration-function to call the iMedidata ?

From what I know, you have to go to Admin console and select plug-ins tab. Then choose the plug-ins and deploy it. But, to add plug-ins that are not included in the Appian App Market, you have to contact with the Appian Support team. Do I have the right idea? What I want to do is add plug-ins on on-premise base. How do I add plug-ins?  Could I get a specific description of how? Thank you.

Hi All, Can anybody help if Appian 20.4 version compatible with Google Analytics plugin? . We are aiming to use only for page views of each user in application. thanks 

I have existing groups of type "Custom" that should have really been created with a different Group Type and would like to address this issue. Need to use the following APIs from GrouppService intefrace to change group type - changeGroupTypeOfGroup or changeGroupTypesOfGroups forum.appian.com/.../GroupService.html Does anyone knows what is the existing plugin name / URL ?

Hi All,      Can you please help me with different Plugins in Appian for Analytics. Warm Regards Vineeth

I am trying to get more knowledge about the "update process instance plugin". I tried to search in the documentation and couldn't find an appropriate solution. Can anyone guide me here?

Hello All,  We have a requirement to send document to another system using FTPS.   Ive installed the required plugin.   I have added third party credentials in admin console.   When I execute the process to test the connection, I get the following error message: There was an error opening the connection to <servername>. Received fatal alert: handshake_failure Is there anything I miss here? Also, please note this is on premise environment. Should we need to set up FTPS server exclusively for Appian to send files?

Hi All, Im trying to invoke SFTP smart services plugin. Is there a way to check if the connection is successful without executing the smart service?? 

Hi all, I am getting the following error while trying to deploy "PDF Tools" Plugin in Appian 20.4 version: Is there any other way or plugin available to merge PDF files?   Thanks in advance, Brinda Sateesh.

Hi,    I am using cucumber for automated testing , can some one help me with sample syntax on how to upload a file in the field from the defined path of my directory.

Can anyone share the documentation regarding how to configure the following smart services? - Import CSV to Database v5 - Load CSV File To Database I am facing an error while using the smart service You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=' at line 1 Is there any way to read a CSV file? I need to find the headers and number of rows available in the file Thanks, Rohit

Hi , I have used fraud ring network graph plugin for one scenario as below, Q1. Can we get the dynamic data from external DB's and build network diagram? How to map the nodes and edges respectively for dynamic values? Q2. I have a requirement, to show the drill-down level of each node as a separate interface. Is it possible to implement the same by using Network-graph-component Plugin? Q3. Can we show/hide the nodes depends on the requirements? Any examples please share. Any reference links and example implementation would be appreciated. 

Hello,  I'm trying to implement functions to check the permissions of a group or a user (first param) on a specific folder or document   (second param) but i'm stuck with  the UserOrGroupDataType coming as a string. How could i make the distinction  between the two kinds of objects inside the java code of the plugin ? Regards  David 

Hello,  Could you please tell me how can i retrieve the caller of a custom function inside this function (in java) ?  I would like to check at least if he has the sysadmin rights. Thanks in advance  David 

Hello All, Please let me know whether anyone worked on plugins to export the report(Readonly grids) to pdf.. We are using  plugin - Dynamic Document Generator and then using pdf from html option. Challenge here is after converting into pdf(using html option) - unable to insert page break so some of the rows were truncated and because of the fontsize columns also truncated. Please let me know whether if any worked on the similar requirement/any workaround. Thanks

How to convert the Network Graph field to image? Any smart services available for the same?

I have two requirements that I am not sure how to tackle:1. I need to to export a datasubset, dictionary, cdt, or map to excel (basically data that is in appian, not in the db) in an interface. 2. I need to upload an excel spreadsheet, and extract the data to display in a grid in the UI.  So I need to extract it to a datasubset, dictionary, cdt, or map. Is there any OTB functionality or plugin that could achieve one or more of these requirements? 

We are in need to use mobile push notifications to generate mobile notifications on certain events, but the issue is that we are on on-premise environment and Mobile push notifications are only available on Appian Cloud. Is there any suggestions or other ways to achieve the mobile push notifications service in self-hosted or on-premise ?

Hello All, I have a requirement to poll mails from an external mail box at a specific interval(eg; once in 5 min), I found plugin " Poll Email from Microsoft Exchange EWS API " from app market. But i couldn't find any configuration details. I followed the steps but facing errors when i run the process. Please suggest if anyone already worked with this plugin or let me know is there any alternative solutions for the same? Regards!! Sujitha