Discussion Categories

How to transfer the data of excel file into mysql Database?

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

Getting "error has occured " while trying to download "Appian selenium api",Can someone help me with this issue

Getting "RecordFormatException" while updating the record in excel file. Used apache poi with the version 4.0.0 for reading and writing to the excel file. Can any one help on this issue?

I have one array like {1,2,3,4,12,12}, I want a new sub array from 3rd index till end like {3,4,12,12}is there any rule or function?

hello community, I would like to try the first level exam (associate) and I wanted to ask if it was possible to take the exam in Italian/Spanish or if alternatively it was possible to use google translate Best regards

When i'm creating cdt from database i'm facing this issue:- ->After selecting Data source no table or view is there for selection  -> data source (oracle DB)

Hello, I have an interface that needs to show default value in dropdown for my users when some options are specified (see example below)  { a!DropdownField( label: "Toto dropdown", choiceLabels: {"1", "2", "3"}, choiceValues: {1, 2, 3}, value: ri!toto ), a!DropdownField( label: "Tutu dropdown", choiceLabels: {"4", "5", "6"}, choiceValues: {1, 2, 3}, value: ri!tutu ), a!DropdownField( label: "Foo dropdown", choiceLabels: {"Test", "Test2"}, choiceValues: {140, 150}, value: if( and( isnull(ri!foo), a!isNotNullOrEmpty(ri!toto), a!isNotNullOrEmpty(ri!tutu) ), if( and(ri!toto = 1, ri!tutu = 2), 140, 150 ), ri!foo ), saveInto: ri!foo ) } This interface is embedded in a form component, when i submit this form and the default value of the "Foo dropdown" hasn&#3

Getting this below mentioned query: Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error in rule 'isbn_mapbookdetails': Invalid index: Cannot index property 'body' of type Text into type Text Since, I am new to Appian, is there anyone who can help me  out?

Hi, I am having issues in my application with values being passed on.  While I am checking my record relationship, I am not able to get the field entries while checking the preview. itemid field is the common field. But no entries are found.  Where am I going wrong? There are two records Asset and Request. Trying to relate both these records.  My Asset Record Fields.  My Request Record Fields Because of this issue, I am not able to reference any asset fields in my request related interfaces. If I use two separate rule inputs to access the fields, my process models are working fine. But I want to use relationships to access my related records. I know this is a basic problem but somehow I am not able to fix it.  My table looks like this Appreciate if someone helps me with fixing and letting me know where I am doing an error? Thanks

Hi, Dropdown field is getting error, can anyone provide inputs to resolve. a!localVariables( local!refData: rule!EC_getReferenceData( appName: "EC", category: cons!EC_REFERENCE_CATEGORY[{ 2, 3, 4, 5 }] ), local!departmentList: rule!EC_filterRefData( refData: local!refData, category: cons!EC_REFERENCE_CATEGORY[2] ), local!Existing_Emp_ID: if( rule!APN_IsBlank( ri!Employee['recordType!{13a37d27-9cf0-4b44-aa16-596960c2aeb6}EC Employee.fields.{5dd14089-6372-498b-bdd4-49221479de4c}id'] ), false(), true() ), local!Emp_Data: length( rule!EC_getEmployeeDetails( empRefId: ri!Employee['recordType!{13a37d27-9cf0-4b44-aa16-596960c2aeb6}EC Employee.fields.{5dd14089-6372-498b-bdd4-49221479de4c}id'] ) ), local!EMP_Code: if( rule!APN_IsBlank( ri!Employee['recordType!{13a37d27-9cf0-4b44-aa16-596960c2aeb6}EC Employee.fields.{5dd14089-6372-498b-bdd4-49221479de4c}id'] ), concat("EC" & local!Emp_Data + 1), ri!Employee['recordType!{13a37d27-9cf0-4b44-aa16-596960c2aeb6}EC Employee.fields.{190fbb44-7340-

Has anyone successfully installed Appian on a Mac that uses the M1 Chip (Apple Silicon)? Currently I am having an issue as the Dockerfiile is using centos7 which is created for Intel chips, and its resulting an error because of the M1.  Getting this error when doing a docker-compose build: failed to solve: rpc error: code = Unknown desc = failed to solve with frontend dockerfile.v0: failed to create LLB definition: no match for platform in manifest sha256:691c55aabb3c4e3b89b953dd2f022f7ea845e5443954767d321d5f5fa394e28c: not found Another example of the error: https://stackoverflow.com/questions/67911250/cant-build-docker-compose-on-m1-chipset  I know this is not an Appian issue but anyone that has been through the same thing and managed to find a solution would help a lot!

Hi, How to prevent running of truncate and delete query accidentally on database table. Is there any role and access setup can be done to prevent this considering having "System Admin" access in APPIAN. Regards Bihitak

Hi all, {1,2,3,8,9,9,9,9,9,80,90,70}, {56,76,54,32}, {20,23,45,54,32,54}, {1,2,3,4,5,6,7}, {11,12,13,14,15,16,17,18} Please suggest how do this using foreach function get output like this, length of array 1 is 12length of array 2 is 4length of array 3 is 6length of array 4 is 7length of array 5 is 8 Thank You In Advance

So I would like the user to click a link or a button in a UX and that launches a process model. The process model will determine a url that needs to be opened in a new tab. I only want the process model to run when the user clicks the button or link.I have tried a!startprocess with success: but im not sure how to get the url opened in a new tab. It successfully runs the process but nothing else seems to happen.Trying various things on the OnSuccess. Httpreponse etc

Hi there, I have one CDT array { {a: 1, b: "R" }, {a: 2, b: "E" }, {a: 3, b: "R" }, } what's the good way to update field b from "R" to "T". tried this, it does not work. a!update(CDT.b, {1, 3}, "T") anyone has the experience dong this? Regards, Lin

Hi I want to test an integration which should create a new record in an external system. This is the code that creates a 'job', with its name, the department, an array for the offices ids and a template_job ida!tojson({ "job_name": "AppianFlow3"& " "&"Related data"&ri!record['recordType!NJW NewJoiner.relationships.njwGhOfficePicklist.fields.officegh']&ri!record['recordType!{1fc618ce-6255-402a-81f8-007ca9ca5de4}NJW NewJoiner.relationships.{925eac6a-be91-4fe5-b4a3-1009d480994a}njwGhOfficePicklist.fields.id']& "NJWRecordType"&ri!record['recordType!NJW NewJoiner.fields.division']&" "& ri!record['recordType!NJW NewJoiner.fields.businessmanagerapprover']&ri!record['recordType!NJW NewJoiner.fields.id'], "department_id":"4076573002", "office_ids":{"4036737002"} , "template_job_id":"5468426002" } ) I want to test the integration by getting one record by id of the record type NJWNewJoiner and parse in the json request some fields from the NJWNewJoiner Record type as well as

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.

Hi, I have a requirement, where invoice documents from multiple vendors will be sent to Appian as a single PDF (page number around 250 - 300) file. As the invoice documents for each vendor needs to be processed using IDP, we need to split the PDF document into multiple PDFs. The pages for each vendor invoice documents will not be static, it can vary depending upon the content on the documents.  Kindly share your thoughts on how to proceed with splitting the PDF file to send them further for processing. Regards, Deepak Devarajan   

Hi Community, I am getting error while using decision to get total amount.  Error says "Expression evaluation error: Syntax error. Details: Expression evaluation error at function a!textField parameter 4 [line 90]: Missing right parenthesis in expression, found COMMA"

Hi, In changing the Appian User password, can we change the password by using smartservice and interface obejct. (Not the method in which the user sets the password in Settings -> Password.) Or is there a function that allows administrators to reset(change) passwords in the Admin console? Searching through the communty pages, it seems that the function was not provided a few years ago, but now I am wondering if there has been any development. Thank you

Hi All, We are trying to display the tasks count in the navigation panel as dynamic label.It works as expected in web browser .But when we access the same from custom mobile app the tab name is not updating dynamically and it updates only after logout-login. Solutions tried: 1.We have tried to remove the count if the site is accessed from mobile device using a!isnativemobile() function .Which throw the error mentioned below 2.We have tried converting the label from external expression rule which didnt help much. Please suggest.

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?

I want to use the function numprocessesforprocessmodelforstatus(id, status, includeSubProcessData), but I don't understand how to get the ID of the process model I want to reference. The documentation doesn't give an example that incorporates fetching the ID of a model, the example just says "numprocessesforprocessmodelforstatus(processModelId,"completed")" but doesn't explain how to get the id. The documentation has been giving me a headache since day one. If I look up "process model id" I get zero results in the documentation search.

when i debugging my process model and I want to view my form  but I found this error An Error Has Occurred The task status null is invalid. Please solve my error ASAP. Thanks.