Discussion Categories

I cannot connect my Robot to MS Access in local PC where AppianRPAagent.exe exists.I am getting an error message "No suitable driver found for jdbc:ucanaccess://C:\AppianRPA\AppianRPARbot-CustomJavaCode\UcanAccess\AccessFile\targetDB.accdb". However, after implementing JDBC using the same connection string When java is executed on eclipse, to connect to MS Access is successful without issue.So I think the connection string is correct. In this case, I think there are two main reasons.-1. The external jar required to run JDBC has not been built to Appian. By the way, I'm using a library called "ucaccess".-2. In the first place, Appian RPA cannot access local files by design. I have two questions about 1.・Is the external jar unusable in Appian RPA?・Is there a way to check if the external jar is built correctly? I have a questions about 2.・Is this inference correct? If you know of any possible reasons other than the above, please let me know. Thank you.

The no.of.tasks is being displayed the same times as the no.of members in the group. For eg- I am having  a group with 3 members who will be reviewing  a particular task, i.e. for 3 same process IDs i have 3 different task IDs, because of which when i am displaying it in the UI, its showing 3 same tasks where it should have been 1. How do I deal with this problem?

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 Appian, There is a Process model(A) and within it there is Process model(B) as sub-process. When executing the process, it works fine with great performance for the first loop. (less than 1 sec) But for the loops after the frist loop, the process performance slows down massively (more than 13~16 sec, at least 13 times the first loop performance.)     The preformance of the process slows down massively. And this is a critical problem for us. What might be the reason for slow down of the performance. And how could we fix this? Thank you

Hi,  My company is moving towards Appian and we would like to use the power of Appian IDP. However there are many data that are confidential and are customer related and keeping it on Appian application or DB may violate our data protection or GDPR policies. We as Appian developers won't be able to promote IDP even though we have an Appian domain. People might see it as risk. So for me to sell IDP and its features I will also have to prove the post reconciliation data is being removed/deleted from Appian application or DB. I do not have the end to end knowledge of all the Appian IDP objects and process models. Please help me to know how I can ensure that once my data is processed if I have to delete the document and its related data - how do I do it ? Currently I see on the site Is there a way user is given a choice to delete the document ??  Tables: For now I am aware that dudocunderstanding and tables related to the newly created CDT like contains the

I want a separator line(Horizontal) similar to the one offered in SectionLayout. Is there any such component or work around for the same outside sectionLayout?

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,Can someone please provide a small & clear example of code snippet on how to find total for column values in a grid ?I am new to Appian and finding difficult in understanding the related blogs & docs.Usecase: I have two columns. Rows appear upon clicking Add Dynamic link. last row of the grid should have Total/Sum of respective columns row data

Hi, am working on a use case where, service backed record is supposed to fetch data, used to display and to be fed to corresponding Reports. The provider system is having around 2 million records, and the record sync is timing out (100000 records synced in 40 minutes). Additionally for every call 1000 records are returned. Requirement here being to sync the entire 2 million records in Appian record type.  In case you'll have experienced something similar or have a solution/workaround for the scenario, request to please advice. Thanks in advance. Regards, Amit

Hi, I have a process model with the below scenario. I have a main table where I need to store my parent db record and after generating the parent db record I am collecting the parent record id using script task. So far so good. Now, I have a "Write to Multiple Data Store Entities" smart service using which I planning to store data (DB records) of the child tables and passing parent record id reference to the child tables. The way I have designed my db tables like using parent child reference keys (using primary, foreign key reference). I am good at this stage too. Now, the issue was, I may or may not have child entity tables data. If there is no data in the child entities, still an empty row getting created in the child db table. How can I handle the situation.

Hi team, We are using the OOTB Sharepoint Integration feature to upload documents from Appian. Everything works as expected, but for random docs, the docs in SP are getting corrupted and we are not able to open it. Please note that we are able to open the same document in Appian. So, I strongly feel that while pushing documents from Appian to SP, it is getting corrupted. I also did compare the size: the corrupted document in SP are of lesser size compared to actual document in Appian. Did anyone faced the similar issue? I am sure that there is no change in Process / documents that are being uploaded and please note that it happens very randomly. Regards,Sriram. S

Hello, I am trying to authenticate with DocuSign through Oauth following their documentation of oauth https://developers.docusign.com/platform/auth/authcode/authcode-get-token/ The thing is that I am trying to achieve this without using a connected system. I have created an integration that makes the request of the first step which is: Which the response according to the docusign documentation should be a callback with a code: But the response I am getting on my integration is this (the code that should be received is nowhere to be found): Here is how I have configured the integration: Does anyone know how to configure the integration in order to get the correct response? What I need is the code that should come in the response. Thank you! 

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, I need to modify time stamp given by caladddays to 12:00AM always. How do I do that. Thanks

Hello All, I have a requirement that, this type of grid has to be shown(each row has different mapping), the existing structure has the card layout on top of that how this can be done?   Let me once if anyone can find out solution or idea on this. Thanks in advance.

Hi everyone, Can appian do this query? I would like to query all of the data of the merchant without transaction between a specified date range and show it in the read-only grid, I already have view table  but I can show all of the merchant without transaction between a specified date range.

Hello, User Group Functionality Description Comments Grnators Action         Edit         Edit         Edit         Edit Users Part of Group Users Emailid Remove A   x B   x C   x     These are two editable grids . When I press edit link in above grid , then below grid named "Users PArt of Group" should be displayed. How to do that using recordaction field 

I'm try to integrate Appian with BOX here  I have used Box File Utilities plugin and followed the given step provided in Manual I have created a App in box as well as all required key are generated in BOX Now in Appian I need to generate token for which I'm using createtoken() function from the Above plugin. Where .pem files need to be updated for privatekey and publickey parameter. I have generated json file in box and got private key. And generated public key from generate option available in Add and Manage Public Keys section. But still i'm getting below error while try generating token using createtoken() function Could anyone please guide me on this, Thanks in Advance

Can someone please help me out with how I can go about the Connected System integration between Appian and Blue Prism? I have tried creating a Connected System with type 'Blue Prism' and configured the API endpoint and credentials but getting below error when testing the connection.

Hi all, I have to deal with metadata on my processes. Most of them upper 20 parameters. My engine rule Will need to Fetch the specific parameter and its value coming from interfaces, data bases or integrations. So I wonder what It is best way to deal with them for performance: 1) create a CDT with upper 20 fields (and It could be defined more than 50 fields) 2) create a CDT with 2 fields: key and value and work as a list. 3) Define a Map as any type objects. Thank you.

Which operations are not supported on the CDT editor interface? (select multiple from bellow options) a. Add a field  b. delete a field from cdt. c. change field of cdt d. define a field as the primary key of cdt.

Hi, everyone. I'm learning from "Online Course - Advanced Expressions: Part 2".I have a question about "Exercise: Looping Functions (Online Course | Learning at Appian)". Exercise: Looping Functions(Online Course | Learning at Appian) The answer of "Scenario 4" is 1333 (1332 + initial value 1), but adding all the values of "local!sensor" gives 1361.The last value of 29 in the third map seems to be ignored. a!localVariables( local!sensor: { a!map(data: {125,92,22,63,73,28,19}), a!map(data: {35,65,92,22,63,73,28}), a!map(data: {2,35,65,22,63,73,18,29}), a!map(data: {9,35,65,63,35,28,19}) }, .... .... reduce(fn!sum, 1, local!sensor.data) ) Is the answer 1333 correct?Is this behavior by design? Regards!

Hi Folks, Is there a way to show the value in a dropdown in italics? Regards, Ghanashyam

How to get the Rule Id of the Expression I want to update, since I want this dynamically based on the rule name I am extracting elsewhere and passing as a process parameter? Here when I select the rule by typing and prompt, and save it into a pv created using (+), it is showing the value for that particular rule, I but I want it to be dynamically populated.