Plug-ins

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.

hi iam using richTextFieldWithTables component where i cant add validations that i have enterd 6 charectes name and clicked on enter it is showing count of 11  but i need to writea condintion if a user enters 4000 charectrs he should not procede further how can we give validation bcz on chage of size of text or on click on enter or by adding tables charcters count is getting count i had used strip html fucntion but it dosent help me any suggestions please 

After upgrading to the latest version PDF Tools 2.4.1, the generated PDF is having format font issues. I created a new word template from scratch which it uses the word template to convert to PDF and still no luck. I have attached screenshots of the pdf and snippet of the process model. Anyone faced this issue? Please give me your suggestions on how to solve this issue.

Hi While using Import CSV to database, i am facing this issue, Error message : Error executing SQL.Can any one help me with the solutionThanks in Advance

Hi all, I have a problem converting bolded words from docx to pdf using PDF from DOCX Smart Service. Bolded words have special characters(need to use UTF-8). Is there a way to do this using this smart service(pdf options)? Thanks in advance.

I am trying to return a document to a component plugin via a connected system plugin's clientApi.  However, I have not been able to find a secure way to retrieve the user in order to do so.  Is there a way to get the user from the session server-side?

Good Evening Great People, I keep having a problem with the Import Excel to Database Plug-in Smart Service. I import the Data, the are no errors on all the notes, however the information is not written to database. The first time, I encountered the problem, I just deleted the plug-in and re-deployed it and it worked. The second time I encountered the problem, I reverified the Entity mappings on my Datastore. Then the third time, I resolved it by removing the delete  Today, I encounter a similar problem and I have tried the previous tricks non of them work. What are the possible reasons that this plug-in could fail to write to DB even though there are no process note errors Your assistance would be highly appreciated thank you