Process Modeling

Hi All,I have multiple individual excel files and i have a requirement that each file should be made aa a sheets in a  new single excel file.is there any plug-in/way to achieve this ? Thanks in Advance,SSP

I want to verify an excel file after uploading, whether the order of columns in excel file matches with CDT. for example, I have fields like PhysicsMarks,ChemistryMarks as second and third column respectively in excel file and want to ensure that this order of column matches with my cdt like if my cdt have 2nd and 3rd column as PhysicsMarks and ChemistryMarks. How can i achieve this function?

Hi All, I have a scenario where I am getting a URL of the attachment through an API , So I need to hit that URL , So that my file are downloaded . How can I achieve this with the help of Process model or is there any other way  Thanks In advance 

Hi, how to read mails from gmail using Appian BPM using smart services?

Hi, is there any way we could start the process model with start form and pass some input parameters from external URL. We have a request where we will have to search some customers in external system, and pass the related customerId to appian process model which should open a start form. So the similar behavior as appian actions, but being called by using URL in external system and being able to pass some parameters to a start form which should be displayed on a link click. For example, we have to search for a customer in external system. When we find a customer we need, we have to start an appian process for that particular customer only by clicking the http link in external system. Another requirement is to avoid starting the process instance if start form for particular customer is not submitted. So, for example, we find a customer with custId=1 in external system, we would like to generate some URL like http://appian.host/start_process/processModelId=2&custId=1&

Is it possible to send email during start date and end date  ,an Api call will be triggered during start date and it gets  ends at end date . So when the  start date arrives Api call be triggered during which i need email to be sent  and vice versa ( when Api call ends at end date another email needs to be sent )

Hi All, We have a requirement to start appian process automatically when a outlook mailbox recieves emails with body and attachemnt. Then we have to consume the body and attachment in Appian process to process it further. We tried to look into : https://docs.appian.com/suite/help/23.1/Sending_an_Email_Message_to_a_Process.html#starting-a-process-using-an-email But it seems it requires extensive configuration at server level to enable polling icluding setup of routing server like Apache James. Wanted to enquire if there is any solution available which doesn't require server level configuration. Regards, Soumyasish Dutta

Hi everyone, I have a problem with a process model that receives incoming emails that contain certified emails as attachments, with an internal nesting degree usually greater than 3 (therefore at least 3 emails attached inside the attachment of the email sent to the process). With these types of attachments, the email sent to the process never reaches the received message node which I used to activate the process. If I then send an uncertified email, the node receives the email and the process is activated normally.  I attach a screenshot of the input node configuration, with the public event flagged. Has anyone had the same problem?

Hi everyone, i've got a problem with email sent to a process model with multiple nested .msg attachment. I want to extract the last nested email attached to the incoming email, but the received message node doesn't process the .msg file. it simply download all the other files (pdf, .xml...) without reading any information of this series of the nested .msg attached emails. I've used the striphtml(msg!properties.Attachments) function in the received message node configured to receive incoming email, as shown in the pitcure below. I don't use the read msg plug-in because i have to download the .msg file as attachment from the incoming email, so it's useless for my process.  Thank you all

Yesterday afternoon, the Add New record action on 3 different interfaces stopped working and the process models show the same following error: The only change that was made to those 3 interfaces was the following highlighted section was added into the expression mode: *Note - after this change was made to the example above I was able to create a new record in that table with no issue, then proceeded to make the change to the other 2 now having issue. Also, we tried putting it back the way it was and it still gave the error so we are stumped as to what is causing this issue now.

Dear All, Based on process instance ID I have unarchived the main process model but in the main process it has some sub process model also, I need to unarchive the sub process model. Kindly guide me How to unarchive the sub process.  Thanks in advance. 

Hi All, Am getting error message stating Activity class parameter keys must be unique across custom and non custom parameters after clicking validate process model. Can any one let me know how to troubleshoot this error suggestion? Thanks in advance

An Error Has Occurred An error occurred while applying the context for the ZMS_ST DBA Case related action [identifier=126]. Details: No process parameter found corresponding to override [name=pv!processId]. Non-parameter process variables cannot be overridden.

Hi All, I wanted to transfer the data from cdt to Excel, but earlier the Export cdt to excel smart service was thr but recently it is showing as deprecated, how to handle this now? Thanks in Advance

Dear Practitioner's, I have a process model with a Start Event Timer configured to run periodically. The scheduler must be enabled/disabled based on a feature flag which is nothing but an entry in a DB table that returns a true/false (via a rule XYZ_isFeatureEnabled(name: "<featureName>") ). I tried to add a timer condition with expression in the Start Event but it does not fetch the latest value from this table and requires the process model to be re-published to get the latest value from DB. Is this a standard behaviour when it comes to Start Event Timer? I had to fall back to the OG method of adding a XOR gate after the start event to check if the feature is enabled/disabled and simply route to an End Event when it's not enabled. This works but I was trying to avoid triggering an instance itself. Any thoughts?

Hello,  I had added a CALL INTEGRATION smart service in my process model and couldn't modify its properties as shown in the picture, while i open it from another user with the same security rules and it works properly. Note that my user is system administrator and included in the process model creators group. I also checked the process folder's security and everything seems fine. Any Advice?

Hi, When i am trying to write the data to data store entity data was not writing to DB but in instance the columns has the data. And one more weird thing happening is in the completed instance if i trigger from the write to data store entity or from before node to write to DSE the data is inserting to dB but when it ran as new instance only pv variables has the data and nit writing to DB, what could be the reason for this could anyone please suggest on this

"the limit of file size that can be passed in a web-service."

How to update the data of Student Form using Process Model

I'm using "Copy document" and "Export  Data Store entity to Excel" smart services in a process model to generate a excel sheet. While the sheet is generated when the contents are displayed, the cells don't fit to the width of the contents within them. In excel we can generally expand according to the width of the contents by selecting all rows and columns and double clicking in the middle of any two columns. But that is after generating the file. So, I want this columns to be auto adjusted or expanded while generating itself. how do I make this happen? Now, How I need it to be, Thanks, Shravan

I have few active receive message(cancel_process) event with a condition to match a request id and then proceed. A different process executes and send message(cancel_request) with request id to all receivers, this call does not have destination process ids. After this, all active receive message node moved further even though the condition was false. The receive message executes even when the condition evaluated to false, has anyone faced this issue? Thanks in advance!

Hi Team, I have a parent process model calling another process model using "Sub-Process" service. Here we have input as well as output data configured. If the child sub-process has any error in it, then the parent process model is in Active status at the sub-process node. We do not get any alert emails neither with regards to the parent process nor with child process model. I have another parent process model calling another process model using "Sub-Process" service. Here we have only input data configured. If the child sub-process has any error in it, then the parent process model is in canceled by exception status at the sub-process node. We receive alerts stating that there is an error in task "child sub-process node name". I concluded that if output data is configured and the child sub-process fails then the parent process model stays in active status and in such cases we don't get system default alert emails or any kind of alert mails stating that

How to find the wrong email address when we are fetching data from the DB? (I am fetching employe's Data from DB, after fetching the data I need to send the mail notification to those Employ's, but "I don't want to send the email notification whose gave me the wrong email format or wrong email in process model Also I need to find the invalid email id")  Can Anyone help me for this,

Hi All, Recently we have upgraded the Appian version  to 22.4.455.0  from 21.3  . after the upgrade process models are not opening and its keep on loading , But for some people its opeing in incognito mode , we have tried in both edge and chrome. I have attached the image below can somebody please help me on this Thanks in advance

I am trying to use the import csv to database v6 node in the process model. Now while executing the model, there is an error saying "error executing sql". Now im not able to decode what is the error because I tried importing into the database directly from phpmyadim using the same parameters , it works ther, but does not work here. Can anyone tell me what I am possibly missing ?