Discussion Categories

HI All, I have a requirement to process a CSV file to my database. i have used a smart service(Export CSV to Database) from Excel Tools plugin. But some of the special characters are not read properly.For example:  The data i have received in CSV has : ~@ö<é;ó¿üäÖÇ*àÄ=É!"ѧæñ á½èçòíê° after consuming the file i have got this in my database : ~@�<�;�����*��=�!"ѧ�������� Can anyone suggest if we have any alternative options for this please. Thanks,Sai Kiran Pannala.

Hi I would like to ask a question. I want to cast multiple record type to custom data type. If possible how can i cast it. Here is my cast data.

Hi, I am facing an issue where I want to add all the value of a column and display it on the top of the gridfield, The source of data is a recordType (Adding the code down below), Please help me with this. { a!textField( label: "Sum Of Values", labelPosition: "JUSTIFIED", value: a!currency(isoCode: "USD", value: 0), readOnly: true ), a!gridField( labelPosition: "COLLAPSED", data: 'recordType!{b43afdfb-93b4-4d94-9708-ffa71f87754a}MWM Test', columns: { a!gridColumn( label: "Value", sortField: 'recordType!{b43afdfb-93b4-4d94-9708-ffa71f87754a}MWM Test.fields.{2682c5c7-76eb-4a9a-abf5-d409f2bc3f80}budget', value: a!currency( isoCode: "USD", value: fv!row['recordType!{b43afdfb-93b4-4d94-9708-ffa71f87754a}MWM Test.fields.{2682c5c7-76eb-4a9a-abf5-d409f2bc3f80}budget'] ), align: "CENTER", width: "NARROW" ) }, pageSize: 100, selectable: true, selectionStyle: "ROW_HI

Hi I got a error when using multiple sql statement on query database smart service. Is not possible to use multiple sql slect statement on one query database smart service.

I have a text field in an interface and I have defined a character limit of 40. I need to be able to type both English and Greek characters in the field. When I write in Greek, the character limit count shows the double number of characters I actually type, so even if I type one character it shows 2/40. In English, it works properly. I think it is caused by the encoding, but I don’t know and can’t find any documentation on how to fix it. Is there a way to fix this problem? Maybe to configure the app so it reads all Unicode characters with UTF-8? Or is the problem somewhere else?

Create group smart service is throwing an error which reads:  Problem:  An error occurred in executing an Activity Class. Details:  A system error occurred while creating the group. Recommended Action:  Examine the activity class to correct the error and then resume. What I have tried - I believe all parameters are correctly configured and values are being fetched correctly in the process variables. Also, the same process is running correctly in different environment with the same values.  Checked the security of the process model. I checked the System Logs and it reads: 2024-06-11 10:28:24,162 [Appian Work Item - 572737 - WorkID 64 - execution00 - process 311873 - model 277 : UnattendedJavaActivityRequest] ERROR com.appiancorp.process.runtime.activities.CreateCustomGroupActivity - SignalException: Received signal InvalidCreatorException from GROUPS.createGroup on groups SignalException: Received signal InvalidCreatorException from GROUPS.createGroup on group

Hi all, Where we can find the details in system logs when making changes to outbound email toggle under admin console??(who made the changes)

I need to add editable grid in intake form of Case Type in Case Management Studio, but the form builder does not have the option to add grid in the intake form.Does Appian have any plan to add editable grid in intake form in future?

Hello, I had faced the fallowing error when the user opened the transactions follow-up page in a transactions project: Unexpected token '<', "html><hea" __is not valid JSON Note that, I gave access to a user outside our Appian servers, and the user faced this error. we didn't use any authentication method for the user login. Did anyone see this error before or knows whats its problem.

I want to have a dropdown/picker field that allows use either select from options or input a value when it is not in options

Hello, We are connecting both appian and AWS. will upload documents from appian side and in aws will extract and store the data. Now to populate data in  Appian to establish a connection found a "AWS Opensearch".plugin. When trying to download getting an error stating "This app is available to download for Appian Customers, Partners, and Employees. Please make sure to self-associate from your profile". Can someone guide me what needs to be done from my end to use this plugin. Or any restrictions for using this plugin what other approach i can take to get the data using opensearch service Regards, Chaithra

Hello, I have a grid to populate with data from 2 different tables. Using the Id of countries  from the first column I have to get the values for other 3 columns from a different table. Can Someone help how to approach this.

I am trying to create a Salesforce Connected System with Username - Password Oauth. I am getting Appian was unable to connect to the provided Instance URL The following error occurred: ConnectionTimeoutException Please ensure the Salesforce Instance URL in the Connected System is valid.

text - "CM: Nick Hunt ECE: Fred Wang General Contractor: Villamar PM: Rick Chan RF Designer: Eric Chan ", output- CM: Nick Hunt  PM: Rick Chan RF

a!localVariables( local!startDate: date(ri!year,ri!month,1), local!daysInMonth: daysinmonth(ri!month,ri!year), local!startDateDay: weekday(local!startDate), local!endDateDay: weekday(eomonth(local!startDate,0)), local!days: {"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"}, local!dates: a!forEach( items: enumerate(local!daysInMonth) + 1, expression: local!startDate + fv!item - 1 ), local!datesWithDays: a!forEach( local!dates, { day: local!days[weekday(fv!item)], date: fv!item } ), { a!gridField( label: "Calendar", labelPosition: "ABOVE", data: local!datesWithDays, columns: { a!gridColumn( label: "Sunday", sortField: "sunday", value: if(fv!row.day="Sunday",fv!row.date,"") ), a!gridColumn( label: "Monday", sortField: "monday", value: if(fv!row.day="Monday",fv!row.date,"") ), a!gridColumn( label: &

hey hi  all,  I am facing an issue with the expression rule that extract the data subset from the task report which in turn, I need to showcase the tasks for the user action to perform the tasks but i unable to fetch the right data from the expression rule    from above code snippets and snap shot i want extract only "REVIEW PROCUREMENT REQUEST" which is dynamic display name but it show the node          name in the expression rule even though it takes it show the display in the task report. thanks in advance!!!                                                                                                                          &

I am performing a loop process in which I obtain process information using script task `有効なプロセスを取得` and cancel each process one by one using cancel process `プロセスを強制キャンセル`. If the number of script tasks processed exceeds 1000, a process error will occur. What should I do to avoid this error?

Hi, we have a functionality to upload a file and save it in a folder in SharePoint. The connected system we are using is through the HTTP integrated Microsoft Graph Connected System. It works fine for a file size up to 100MB but post that we are facing Integration Error as [title=There was a problem with the request, message=Failed to connect to https://graph.microsoft.com/v1.0/drives/b!m6Ln0pXy60eQAb14pUvBiE4NVb13D6JDnJVPxlNZJEQw55MIsIdnQa8ktIM9MLWk/items/01HO3UJFSOHDXPAJQEDRA2S5JCHFKWTKGT:/MS_dummy_file_250MB20242245_024518.bin:/content, detail=HTTP/1.1 499 ]. Please can one suggest how to resolve this issue so that files with larger size can be uploaded using same connected system.

Hello everyone,We have a client requirement where we need to export Client and Employee data recieved from document extraction in a PM to an Excel template provided by the client, where client data should be inserted in their respective positions in sheet 1 and the multiple employee data should be inserted accordingly in its desginated cells in sheet 2. Attached are pictures of the Excel template formats for both sheets, as well as the format of the data we are receiving. We tried using the Export Data Store Entity to Excel smart service in the process model, but the results were unsatisfactory. We also used Appian RPA Excel operations, which provided a solution, but it took 25 minutes, which is not viable in all conditions. We are looking for a more efficient solution to export data into Excel. Any tips or assistance would be greatly appreciated.

Hi, I could not find any docs satisfying my requirement .Can anyone help me in designing a grid as below. Name textbox1 textbox2 textbox3 PersonA 10 1 100 PersonB 20 2 100 TOTAL 30 3 200 User will enter values in rows for textbox1, textbox2 and textbox3. Last row should display the total of the values entered in above rows. 

Hello everyone, I have configured a Task report and use this to resume a User input task from My task list. When I resume the process from process instances then I am able to resume, but when I click on the task from My task list, it is showing "The Requested Task Is Not Available The task may have been deleted or completed by another assignee". What will be the possible solution for this error?

Hi team, Is there a way to access real-time information in SAP database like data link? I know there are BAPI smart service and SAP GUI libraries, and cofiguring record type with BAPI can have a bunch of records.But I also know the record type can have data as of the timing of full sync, which takes place once a day not every 10 mins. If we can configure the record type with jdbc instead of the smart service, I hope we can refer the latest data.But the problem is that SAP does not allow users to connect directly to its database with jdbc. Is there a good way to fulfill our requirement?What I wonder is if we can connect to SAP BTP with jdbc, we might be able to see the real-time data via BTP.And the idea I came up with is if the record type can be refreshed every 10 mins, this also helps us. I appreciate any suggestion. Thank you in advance,Masaki

I want to create new entity category and entity types in Case Management Studio. With "Create Entity" action I am able to create entity of type "Submitter" of category "Person", there no option available to create entity of other types. I did not find any feature in Case Management Studio that allows to create new Entity Category and Entity Types.Is there any way to create new Entity Category and Entity Types.

Hi Team, I have a requirement to execute an expression rule by retrieving the rule name from the database. To provide a background on the ask: We have a landing page where tasks from various other applications/line of business is displayed. So every application designer would have to create an expression rule to return their tasks and then plugin to our common or parent expression rule. The parent rule consolidates all the tasks data from various applications and then display it in the grid. But the problem here is, one application might be in DEV phase, one in QA and another in UAT, so during the deployment there is always a problem due to the missing precedents and we have to comment out that rule that's not present in higher env and then uncomment it back. So in order to resolve this the business wanted to save all the rule names pertaining to each application in the DB and dynamically retrieve the rule name from DB and execute it. I understand that we can pass the rule referenc

Hello, I have the following error from web browser interface (NOT MOBILE): "Start process link not displayed because the system is in a degraded (stateless) status" , when a user press on a  a!linkField( links: {a!startProcessLink(.... I saw that there are some problems with it explained here: https://community.appian.com/support/w/kb/1338/kb-1867-start-process-link-not-displayed-because-the-system-is-in-a-degraded-stateless-status-error-when-starting-processes-in-the-appian-for-mobile-devices-app but I don't have a mobile interface is a simple interface exposed as a report in sites. (ps: appian version  used 18.3) Can someone give a clue what can I do?  kind regards, ana