Discussion Categories

Hi i have polled emails using filter and poll plugin in a process model. The body is saved as a .EML file in a folder.  Is there anyway to extract the body of the EML file in to a table. Or to convert the .EML file into different format so that it can be extracted in to a table. I cannot use ReadEML plugin due to jar file conflict. any suggestions??

Hi there, I have a desired requirement from a client about checking to see if two values are an 85% match. So for example, if a user entered ABC, Inc. for one value and ABC, Co. for another, it would be flagged. This is just one example, if the similarity of names was in the middle or end of the value, it would also be flagged. I just can't seem to wrap my head around any logic to make this possible. Any suggestions? Thanks!

Hello, We have Rich Text Editor to take input from user which can contain special character . We are using stripHtml() to get the text and later on we are comparing the text with Regex to show validation on RTE.The issue we are facing with stripHtml() is that it is leaving some characters as html encoded in the returned text. But we require the character itself.How can we handle such case for all the special characters? For reference -In the output, the special character ( š ) is coming as html encoded whereas the other character which  is <, can be compared using regex.We need the output as - "š<"How to handle all the such characters which will be coming as html encoded? Is there any other function which we can use to achieve the above result ?

While executing PM i am getting error how can i resolve ?a!localVariables( local!currGrantWorkflow: rule!GAI_getWorkflow(workflowId: ri!workflowId).data, local!refDecTree: if( rule!SCO_isBoolNotEmptyAndTrue( local!currGrantWorkflow['recordType!{f8c3f153-12d0-4850-97d9-bd6878795255}GAI Workflow.fields.{5febe064-3783-49f6-ac2c-1f69ce22e5b5}isCustomWorkflow'] ), null, rule!GAI_getRefWorkflowDecisionTree( currStatusId: local!currGrantWorkflow['recordType!{f8c3f153-12d0-4850-97d9-bd6878795255}GAI Workflow.fields.{7cd66171-e9d3-45ae-9967-fe88fbd9f594}fkWorkflowTypeStatusId'], taskDecisionId: ri!taskDecisionId ).data ), local!customDecTree: if( rule!SCO_isBoolBlankOrEmptyOrFalse( local!currGrantWorkflow['recordType!{f8c3f153-12d0-4850-97d9-bd6878795255}GAI Workflow.fields.{5febe064-3783-49f6-ac2c-1f69ce22e5b5}isCustomWorkflow'] ), null, rule!GAI_getCustomWorkflowDecisionTree( currStatusId: local!currGrantWorkflow['reco

Hi All, I have a requirement to upload attachments to a target folder location and assign them before perform submit on UI screen. Is there ant way I can achieve this? Thanks in advannce.

i have faced  access denied problem when i add more than one email type in AI Skill Email Object 

I have followed setup instruction as per 23.3 doc and installed RPA Agent, JDK and Maven.  The agent icon in status bar is not turning to blue, I see it grayed out. And hence the robot is not coming online. Please suggest.

Hi, I have an upcoming application that is going to have a heavy IDP component. I haven't actually worked with IDP yet, and development hasn't started yet, so all of what I've been researching for Appian capabilities has been what Appian has in their documentation and other community questions. The question is, when the user uploads the form and there are attachments that also have to be extracted, does each document have to be in its own PDF? Or can they all be uploaded as one, multi-page PDF and the system can extract them all separately? Thank you!  And I apologize if I'm not wording things properly, again, I don't actually have any hands on IDP experience yet, I know each form a user could upload has to be configured and classified, so this is assuming the main form and possible attachments have been configured. 

Actually i am getting a csv  document from sftp to the staging table i am writing expression rule to count the data. so here i am getting a error memory threshold reached during output conversion. Can some one give perfect resolution for these. 

Hi everyone, I would like to export my app from dev to prod environment. In the 2 different environments there is a folder with the same name but containing different files. I would like to delete the current app in prod and replace it with the updated version of dev, but keep that specific folder that already exists in prod, then replace the same folder of the app imported from dev to prod with the files I need, keeping the same UUIDs of the documents contained in it and also the other information. It can be done? Or can you download a folder from a specific development environment on the local PC and then upload it as a zip file to the desired environment without changing the uuids? What is very important for me is that the uuids do not change. Thanks in advance

i want to highlight these two duplicate values when a user enter a duplicate value. Please suggest me validation code.

Hi All, We are using MariaDB. Is it mandatory to provide after keyword in alter table query while adding new column? We are moving from lower environment to higher environment. In lower environment, the columns are in a certain order and in higher environment, we are trying to add the columns in the last and not in the same way as lower environment. Eg: In lower env, table is like firstname, middlename, lastname. In higher environment, it will be like middlename, firstname, lastname. But both environment CDTs will be like firstname, middlename, lastname. Will these cause any issues??

Hi Team,I have a few doubts in start node triggers. My requirement is to trigger a process model when certain conditions are met. So, what we are doing is we created a interface for users to schedule the process when to occur. we storing the date & time in separate constants. Try 1: then in the process model start node trigger we added a time recurrence to daily and it's time to value from the time constant = pm!timezone and checking whether the date constant is today or not in timer conditions (advanced options) and delay to 0 mins. each time after the trigger the process model will update the date constant to future date. Issue: working for the first time only(while publishing) after the constant update its not working.Try 2: process model will trigger daily at 00:00 , a xor to check whether its today or not, and a script task with scheduler (delay until the datetime mentioned in the constant). Issue: if the user sets the schedule to 06:00 but trigger star

i want an interface as "TEST 1 APPROVAL" with  fields name, section and class with cancel,approve and reject button .once we approve another interface with same fields must display with title "Test 2 approval" 

Hi All, If somebody has worked on Jira integration, Let me know if we can get the data based on list of project ids.(if i pass single project id it is returning the data).Solution i Have :- i can use a!foreach in order get whole data

Hello techies,  I need to use the merge() function on a dynamic list but it isn't proving easy.  Please check the following code snippet and suggest applying it on the dynamic list local!a.b a!localVariables( local!a: { { a: 1, b: { 1, 2, 3 } }, { a: 2, b: { "asdf", 5, 6 } }, { a: 1, b: { 7, 8 } } }, { merge({ 1, 2, 3 }, { "asdf", 5, 6 }, { 7, 8 }), /*working*/ merge(local!a.b[1], local!a.b[2], local!a.b[3]), /*not working*/ merge(a!forEach(local!a.b, fv!item)) /*incorrect result*/ })

We have a record type hooked up to a table.  Adding new records works well.  But, there is an issue with record edits.  The record gets updated in DB, but the auto record sync following the record update fails.  Here is data from error email: Problem: An error occurred in executing an Activity Class. Details: Unable to sync due to a system failure. Recommended Action: Examine the activity class to correct the error and then resume. Here is some relevant data from tomcat-stdOut.log: [http-nio-8080-exec-734] ERROR com.appiancorp.record.service.RecordReplicaUpdateService - Loading updates to synced record type(s) in ADS failed, invalidated record type(s): ...com.appiancorp.suiteapi.common.exceptions.AppianException: Unable to sync due to a system failure. (APNX-1-4521-016)...Caused by: com.appian.data.client.AdsUserInputException: APNX-3-1000-030: Invalid transaction data. Cannot update the same entity multiple times in the same transaction. Invalid id(s): ... Note: E

In my "Request " CDT  , i have a field named "branch" of type number.  I am trying to display the branch ID  on the interface , from the query "GetRequestData".  value: rule!GetRequestData(ri!documentID).branch, ri!documentID holds the ID of the request.  when I test the query it returns the data correctly, but on the interface it doesn't show. when i debug the process model it shows ((Cannot index property 'branch' of type String into type List of Variant))  i don't quite understand the error message. how can i display it correctly ?    

a!localVariables( local!selectedPermission, local!selectedArea, local!selectedComponent, local!selectedDepartment, local!departments: a!refreshVariable( value: rule!MECMS_getDepartmentList(activeFilter: true), refreshOnVarChange: { ri!refreshInt } ), local!area: a!refreshVariable( value: if( rule!APN_isBlank(local!selectedPermission), null, rule!MECMS_getRefArea( selections: {"id", "value"}, permissionId: local!selectedPermission, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: - 1) ).data ), refreshOnVarChange: { ri!refreshInt } ), local!component: a!refreshVariable( value: rule!MECMS_getRefComponent( selections: {"id", "value", "areaId"}, areaId: if( a!isNotNullOrEmpty(local!selectedArea), local!selectedArea, if( rule!APN_isEmpty(local!area), -1, local!area.id ) ), pagingInfo: a!pagingInfo( startIn

Hi All, Second error: Appian environment went down and became very slow. From Appian admin we received the tomcat.std logs: 2022-11-22 03:00:07,489 [RecordSyncScheduler_Worker-1] ERROR com.appiancorp.core.expr.portable.storage.StorageDoubleTimestamp - Incorrect type (java.sql.Date) for DateTime variable (2022-06-08). Expected Type: java.sql.Timestamp. Auto-correcting to "2022-06-08 00:00:00.0" 2022-11-22 03:00:07,489 [RecordSyncScheduler_Worker-1] ERROR com.appiancorp.core.expr.portable.storage.StorageDoubleTimestamp - Incorrect type (java.sql.Date) for DateTime variable (2022-06-15). Expected Type: java.sql.Timestamp. Auto-correcting to "2022-06-15 00:00:00.0" 2022-11-22 03:00:11,412 [RecordSyncScheduler_Worker-1] INFO com.appiancorp.record.service.quartz.LoggingTriggerListener - Trigger [group: record_load_group, name: 2] completed for job [group: record_load_group, name: 2] 2022-11-22 04:00:00,708 [RecordSyncScheduler_Worker-2] INFO com.appiancorp.record.service.quartz.LoggingTrig

I have created a PM to get Json data, next I have created a webApiPost Start Process, I have tested the request, status code:200, after filling the body {} with json data, is passed to a process variable. But the purpose is to store all the data with mutliple table, through one CDT.

How I know what are the new objects come in Appian 23.3 and 23.2 versions  Please share me docs.appian.com page link for new release of 23.3 and 23.2 versions

Using integrations, I am retrieving outlook emails, but only receiving 255 characters rather than the whole body. Is there any way to get the whole email body?

I'm a newbie to Appian, looking for the documentation on initial steps for creating the promote-to-production landscape.  )This is assuming an "enterprise application" architecture (think: multiple users creating POs and then a Purchasing Dept. making buys), and not a mobile app architecture where we have to deploy an applet to multiple devices.) I have found the documentation on "Deployments" and "Packages," but not the precursor documentation on how to set up the landscape, declare where Dev is and where Test is and where Prod is, how to add a Training environment into the landscape if desired, how to set up Primary Dev and HotFix Dev, etc., such that a Deployment can move applications and objects from a Source to Target. Tried searching on "landscape" but that took me to portrait-vs-landscape in document orientation.  Other ideas on what search terms to use, or can anyone point me directly to the documentation?

I have "requestID" as a foreign key in 2 tables "attachment" and "Document"  i passed it as process variable through a task script. When i debug the process it works but it saves the foreign key "Null".  what might be the reason?