Plug-ins

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

Hello everyone, i installed fitness for appian and configured the config.properties as shown in the documentation. But i'm getting the errors below. this is my code: !define TEST_SYSTEM {slim} !define COMMAND_PATTERN= {java -Dlog4j.configuration=file:///${automated.testing.home}/log4j.properties -cp %p %m } !path ${automated.testing.home} !| script |com.appiancorp.ps.automatedtest.fixture.SitesFixture | |setup with |CHROME |browser | |set appian url to |https://url here| |set appian version to|20 | |set appian locale to |en_US | ***! By the running the code above i am getting this error: I have jre 1.8, but jdk path is not set. Could that be the issue?

Hi, On 7/20 we upgraded from 22.1 to 22.2.  We are using the Amazon S3 Utils version 1.1 and we can no longer upload to S3 after the upgrade.  This plug-in [com.appiancorp.ps.plugins.amazonS3Utils] is not registered to access secured values for the given external system key [s3prod]. Check the external systems plug-ins list in the Administration Console. Error Occured: Error while uploading the file to Amazon S3. Error is: The security token included in the request is invalid. (Service: AWSKMS; Status Code: 400; Error Code: UnrecognizedClientException; Request ID: c1e7278c-ca73-46bd-bcf9-c510a620018a) Thanks, Scott

Hello Team, I would like to know if there is any plugin/smart service available to split data from one sheet and place it to multiple sheets in same excel? eg: suppose if I have 100 rows in first sheet of excel, I want to cut first 25 rows from it and place it in new sheet. Thank you in advance.

Hi I'm not able to deploy the  SQL to Excel Plugin as its not shown when searched in add plugin on Appian cloud environment. What might be the reason?

Hi ,I would  like to know why i'snt more available this plugin? it is marked as "Archived" on Appmarket. one month ago i have downloaded and  tested it and it was working as well...is there some other same plugin that i can use?BR//A.Milani

Hello, we have an issue with one of the plugin called Content Tools (https://community.appian.com/b/appmarket/posts/content-tools). We use a function "getdownloadersfromgroup" in an expression rule to find who downloaded the file. We did not have a problem with this function until now. Whoever wants to execute this expression (besides designers) gets this error: Error Evaluating UI Expression Expression evaluation error [evaluation ID = 99b65:7ceed] in rule 'hrzn_checkdownloadvalidation' (called by rules 'hrzn_s_coverletterac' > 'hrzn_f_authoritycorrespondencev2') at function a!forEach [line 4]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function 'getdownloadersfromgroup' [line 6]: The user [...] does not have sufficient privileges to perform the requested action. Even if we set security of this expression "hrzn_checkdownloadvalidation" to All users -> Administrator, they still get the er

Can you please explain how i can export the data from excel to database? There is no documentation or step by step process which i can follow. A simple example with few rows of data and a table will suffice.

I have a setup where a particular column of a table contains a JSON object that I need to search through. I basically want to go through each row in that table and use JSONpath to filter out results, but I am unsure how to apply that to an appian query of the data. I figure I use JSONpath as an expression in a filter, something like the image below, but I don't know what I would enter for the required 'value' parameter. Is there something like fv!item which is used in foreach loops, but used in query filters that I can use here? Otherwise, if I am going about this all wrong, can someone explain how to use jsonpath within an appian query so I don't have to do something like query everything and filter it afterwards with JSONpath? 

Hi all, I have installed the GIS plugin [https://community.appian.com/b/appmarket/posts/arcgis-map-integration] into my DEV appian environment.  I am now trying to wire it up to our GIS system.  However, there is very little [as in zero] guidance on what the properties fields are supposed to contain.  I have tried putting the URL of our GIS system into the Map data property of the plugin [after putting the ArcGIS Map component onto an interface, however it doesn't accept a URL.  There is no documentation or examples that I could find that describe how I am supposed to wire this component up... can anyone suggest what I need to do to link this component to our GIS system? thanks heaps, David :-)

I'm trying to get from ad SFTP repo a file when i click on a startprocesslink i'm able to retrive date from the repo. but i want to directly download file on desktop client machine of the user onSuccess of the process.

Hi Team, I wanted to compress appian documents which are uploaded by user, so i can zip them and send to other system via exposing an api , Can we  have any plugin for this? Thanks,

i Wanted to store appian document into blob format in database, Can we  have plugin for this

When using the SFTP Smart Services plugin, is it possible somehow to get the date that a target file was last modified? I would like to check to see if the file I'm about to download is the most recent version or not.

Hi,  I need to encrypt text with an asymmetric algorithm.  I hope to use "Java Cryptography Architecture (JCA) Tools" because it exposes many algorithms to use, and I want to use RSA/ECB/PKCS1Padding.  I don't see any method to generate Public/private key and every key I passed to keyencrypt I obtain an error:   "Expression evaluation error at function 'keyencrypt' [line 5]: An error occurred: java.security.InvalidKeyException: unknown key type passed to RSA"  This is "my code" (the key it's a generated public key):  keyencrypt( cleartext :"cleartext", key: text2hex("MIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEA4IJZLsjlx+o4RSvafaAcReoNnzrI0UXu7kZyXPe31ql32X9AvhC6QQIUmLkr1Evm0zP/SgVG9YX3DSqBUgPo04iv1I1/wNKwAf1/uH9EiiqdpczefyxxnzJiKUTcx2/4mA4E4QxCIL5JsZb78WoYZrd2kToW/WD01MnSFiCgSyjGdd812GY2EVzfvlv8kYuti3icMUyitEfHhtw8cAWI6/nVrRPNs0e5NsvtZJ0nfrXsfQDR0C7+ivQK+fQabi8oRGsbTZceAvVlqVE669zoIwIFLcB+eY