Plug-ins

Summary: I am running into an error in a lower environment when trying to use validateemailaddress from People Functions plug-in and getcontentbyattribute from Content Tools plug-in. Both functions were working a few days ago and are currently working in the higher environment. Input: a!validateEmailAddress("test@email.com") validateEmailAddress("test@email.com")  Output: "Expression evaluation error at function a!validateEmailAddress: The function a!validateEmailAddress is unavailable." ***Same error for getcontentbyattribute "Expression evaluation error at function 'validateEmailAddress': The function 'validateemailaddress' is unavailable."  Steps Already Taken 1. Update People Functions plug-in in the lower environment 2. Update Content Tools plug-in in the lower environment 3. Use different casing on the function: validateEmailAddress() & validateemailaddress() 4. ADDED: Use prefix o

Hi,  I have used the Text Doc from Template smart service to pass text to my document by using ###tag###. I have checkbox fields in the document, is there any way i can pass the yes/no value to the checkboxes from Appian so that the document is generated with filled checkbox fields?  Thanks in advance!

Hi , we are using this plug-in for signing PDF document with corporate certificate (pfx). My question is how to make certificate trusted without doing anything on client side (Adobe Reader )? BR,Natasa

Hi Team ,  We trying to migrate few application from cloud to On-premise . While deployment , we found "Zip Extractor" has dependency. We couldn't able to find it in the APP market . The plug-in has the smart service - Extract the ZIP file. Need guidance on how to proceed on this ?

Hello! I am getting an error message trying to run a test after updating to the latest version yesterday (March 6, 2023). We are using Appian 22.4, Chrome version 111. The test crashes on trying to open a Chrome window in which to run the automation. The issue seems to be with the chromedriver.exe. Can you please update the driver to the latest version? The error message reads as follows: setup with browser__EXCEPTION__:org.openqa.selenium.SessionNotCreatedException: Could not start a new session. Response code 500. Message: session not created: This version of ChromeDriver only supports Chrome version 107 Current browser version is 111.0.5563.65 with binary path C:\Program Files (x86)\Google\Chrome\Application\chrome.exe Host info: host: 'GS-5CD7525XJ9', ip: '192.168.1.251' Build info: version: '4.7.2', revision: '4d4020c3b7' System info: os.name: 'Windows 10', os.arch: 'x86', os.version: '10.0', java.version: '1.8.0_211'

Hi, I am using Import CSV to Database plugin to save data from CSV to database table. However the last row of the CSV data is getting stored twice in the database table. Can anyone please let me know how to overcome the issue? Below is the configuration of the smart service we are using: Delimiter: , File Has Header: true Column names: <no value> Csv header names: <no value>

I need to create a multi language plugin in appian that supports the application with variety of local languages. need to know the step by step process in order to create the same.

Hi All,I have requirement to generate a pdf file where user is given option to enter text value in the pdf file. I thought to go with Docx with Dynamic template but I am not sure how to generate user input field in the pdf file Thanks in advance

Hi all, Is there any smart Service that create a process or create an interface like there is a expresión rule smart Service? Appian creates some processes and interfaces automatically within the record wizard when creating action. My purpose is just to create the empty objects (no logic/code inside), therefore I name them as my naming convention. Developers must implement them. Thank you

Hi All,Can we check and enable/disable track changes to word documents using Appian. Thanks in advance,Surya 

We have a requirement in which Excel File is having more than 350 columns and more than 15k rows. We want to split this file into 2 files for further processing based on rowcount. Have anyone implemented this kind of functionality in Appian?

Hi, We have a requirement to write data in one of the sheets where the base template is excel with macro. We are able to write data in the adjacent sheet in the excel macro but the file is getting converted to xlsx. Could you please advise if its possible to retain the excel as xlms or Is there any workaround/ plugin to achieve this. Thanks in advance, Anju

Hi, As per my requirement I had to make use of the plug-in called "Twilio" for sending SMS to the users to authenticate them. I also created an account in Console Twilio in order to get the tokens to establish the connection. And I managed to get the URLs of first 4 fields like the Account SID, Authentication Token, API Key SID, API Key Secret.  But I am unable to get the path for the remaining 3 fields which are TwiML App SID, Workspace SID, Chat Service SID. Can anyone help me out how to configure the remaining and from where can I get the URLs of those particular fields. Thanks in advance, Gousi.

Hello, I've been trying to make a dual-y chart. If I understood correctly, I had to use googleScatterChartField, but I can't see the labels of axis and values for the second y. The code is here: a!localVariables( local!colData: {{ type: "number",id: "Age",rowDataKey: "Age"}, {type: "number",id: "Weight",rowDataKey: "Weight"}, { type: "number", id: "Height", rowDataKey: "Height"}}, local!rowData: {{Age: 28, Weight: 43, Height: 10}, {Age: 9, Weight: 39, Height: 20}, {Age: 2, Weight: 52, Height: 30}, {Age: 20, Weight: 72, Height: 35}}, { googleScatterChartField( label: "Chart", validations:"val", chartColumnData: local!colData, chartRowData: local!rowData ) } )

Hello, I'm looking for automation to validate that all plugins installed in our QA environment are also installed in our production environment. Right now we have to read through the list of plugins in our admin console but this is a manual process that we're looking to get away from. Does Appian provide a web api or anything that would allow us to get a list of plugins for each environment?

Hello, I am using Google Gantt chart for my current project for display dependency task data like Task Name, Start Date & Time, Due Date & Time and Duration. Here I want to display Day (Sunday, Monday, Tuesday .....Saturday) instead of date can any one help me to how to we achieve this for this Plug-in. I have tried these Appian Date to Day Convert Functions (text and weekday) but when write the format like "dddd". the plug-in throughs an error as below. Thanks in Advance, Mahesh

Hi, We have installed SAP JCo (Java Connector) on Appian Cloud Server, to call SAP BAPI using Sap Invoke functions provided by Appian. We are consistently facing cache issues in our environment where the BAPI configurations and credentials used with SapInvoke function does not get refreshed. Due to which we are not able to fetch updated data in proper structure. This generally happens when an existing BAPI configuration gets changed or modified at SAP end. As per our understanding of SAP JCo, it caches metadata to improve the throughput of the application. However, please note that if any changes are made to the BAPI structure in SAP, the old version will still be cached until the cache is refreshed via a server restart. We were able to find a Knowledge Base Article - KB1232 to clear the cache, but our understanding is that it is targeted for on-premise servers. I would like to know if there any other effective method that we can take to handle this cache issue, other th

i developed a smart service in appian  iam facing a issue while adding external jars getting classNotFoundException while using the plugin in appian even i simply copy paste the required external jars in META-INF/lib folder after convert into jar and deploying the jar in onpremise server while running the plugin classNotFoundException we got for creating a WorkBook 2023-02-09 13:08:47,874 [ThreadPoolTaskExecutor-9383] ERROR com.appiancorp.process.workpoller.WorkItemListener - The following exception occurred while attempting to complete work item [[WorkId: 45, EngineId: execution00, Request: UnattendedJavaActivityRequest:1154462 as M0223 by M0223, ProcessId: 14617, ProcessModelId: 726, Response: null]] - Exception: javax.resource.spi.work.WorkCompletedException: java.lang.NoClassDefFoundError: org/openxmlformats/schemas/spreadsheetml/x2006/main/CTWorkbook at org.springframework.jca.work.SimpleTaskWorkManager$DelegatingWorkAdapter.run(SimpleTaskWorkManager.java:247) at java.util

I want to make an application that uses Import CSV to Database and updates CSV files from an interface.What steps should be taken to create it?Are there any other required objects besides interfaces, process modellers, and CDTs?And what settings are required for each object?

Tell me how to use the plugin “Import CSV to Database”.I downloaded the plugin but don't know what to do next.

Hi, everyone! I need to import a spreadsheet data into a database table and I'm using Import Excel to Database smart service for that matter with parameters described below: Batch Size = 1000; Data Source Name = "jdbc/Appian"; Database Field Names = {  "EQUIPMENT_NO",  "MATERIAL_TOT",  "SUPERIOR_EQUIPMENT_NO",  "SUPERIOR_TECH_ID",  "CALCULATED_ACTIVITY",  "NEXT_LEAK_TEST_DATE",  "HAL_SERIAL_NO",  "ISOTOPE",  "SORT_FIELD",  "AMI_DOCUMENT_NO"}; Excel Document = pv!sapInventory; Excel Header Names = {  "Equipment",  "Material/TOT",  "Superord. Equipment",  "Superior TechID",  "Calculated Activity",  "Next Leak Test Required Date",  "Halliburton Serial No.",  "Isotope",  "Sort field&qu

I am trying to update particular values of a CDT from one process model to another active instance process model using Set External PVs plugin. When I try to give the same CDT type, it is showing the following error - "Invalid Cast: Cannot cast from type 'Text' to type 'CDT name' (Data Inputs)". I tried giving text datatype that didnt work as expected. It is working fine for primitive data types but not for CDT. Can anyone please let me know how to do that?Thanks in advance

I an looking for work around of calworkminutesplugin function this function used to calculate time in min so i tried with calworkhours for that but this function giving me wrong output eben for hour .

I have been trying to configure the Send File over FTP smart service all day and have not had any success.  Not sure what else to try. Current Process Model is simply create a CSV file and upload it over FTP: Send File Over FTP configuration: External System key - avalon Use Per User Credentials - False Server Hostname  ="avalon.lhtech.com" Server Port - 21 Remote directory path  ="/Vendor_Shipment_Reports/432.csv" Document to Send - =pv!HydacShipFinal - created in previous step as 432.csv Enter Local Active Mode - False Binary File Type - True I have created my credentials in " Third Party Credentials" as avalon: Every time I run the process, I get the following error via the log: 2022-11-01 19:11:32,441 [Appian Work Item - 4585 - WorkID 114 - execution02 - process 536871728 - model 684 : UnattendedJavaActivityRequest] ERROR com.appian.ps.plugins.sftpsmartservices.FTPConfig - Login failed 2022-11-01 19:11:32,442 [Appian Work Item - 45

Hello Everyone, I have a requirement where I need to get the Precise Location details based on Latitude and Longitude. But when I am using Google Maps Plugin and using the Operation "Get Geocoding Information", It is returning a list of locations i.e list of dictionaries with location names. The resultant locations are not accurate. Is there any possible way or plugin that has other parameters such as Horizontal accuracy and Vertical accuracy. Here I am capturing the location details from Process Model "Capture location on submission". Where I get 5 Values 1. Latitude 2. Longitude 3. Horizontal Accuracy 4. Vertical Accuracy 5. Altitude Here's an example of the Outputs/results that I am getting based on my Latitude and Longitude values. Would love to have any kind of suggestion and also alternate possible ways to achieve this. Thanks in advance.