Plug-ins

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

Hello, We are using MS Graph Email Poller for our project, and we upgraded to the latest version 3.1.0. Based on the documentation we followed all the instruction but we are getting as ErrorMessage: "Error executing the request" nothing else, could you share any insight what can cause this? Thanks, Suhas

I've been using the "SFTP Smart Services" plugin to retrieve a csv file through a process model. What I'd like to do is download the file, read the data, then write the data to the database. Right now I am stuck on the retrieving part. The "Receive File Over SFTP" node works without error (at least not any error that stops the process model) and in fact I am seeing the file appear in the document folder I sent it to. However there are some problems: 1) the file is listed as "Not in this application" (an issue I only care about if it prevents me from doing the rest of the operation, which I assume it doesn't) 2) when I look at the process details, the error output says "2: No such file" and the status says, "FAILED" 3) the document output doesn't output the file we've just retrieved.  Since the document id isn't output, I can't go further than this in the process model. Any ideas on what I am doing wrong?

Hello World, I want to convert pdf, jpg, png documents into Binary format.  What would be the right procedure to achieve this. regards Navneet Kashyap

Hi All, I am generating a document using DOCX from dynamic template smart service but the document is not generating, error says that one of the field consists of "<" symbol. When I removed the symbol then it works. Could anyone please suggest if "<" symbol is supported in docx from dynamic template smart services. Thank You