Process Modeling

I'm using Export to csv smart service but when i export the data it returns only the timestamp for the data time column.I want the date & time .here is my table on UI: here s the column in db: here is the CDT column: and here is the csv column:

Hi, Do we have any chance of removing the above highlighted mail ID and change to custom mail ID?? Thanks in Advance, Gousii.

 Is there any way to check how each node of a process model is performing? Like how long a node is taking to complete. I know we have two(Default Process Model Optimization Metrics,Default Process Optimization Metrics) out of the box reports present in appian objects but can we use them if the process model does not have any attended nodes? or is there any way around to get this info?

The properties in the process model is not opening. Please suggest some solution for it. I have the rights to modify the process model as well.

I need to implement duplicate functionality. for that, I have a grid view and corresponding to each row i have a button for duplicate.  On button click, I am using a!startProcess() to call process model in which passing a parameter in which we pass the id of that row. In Process model, we are passing that id to the stored procedure in which we have written the insert query for the same data as that id has. And as a output we are receiving the new id.  With this new id, we have to open a interface for which I have used User Input Task. But the process runs and stuck on the User input Task i.e. the interface is not called through UI. How to solve this?? Please suggest anyone....

I submitted an user input task but when supervisor rejects. It should come back to the user input task where an user can again submit the form by editing details. I did this but I'm unable to resubmit the form. Can anyone please help?

If an user task completed in the process but I again want to go for it to complete. How will I do that?

Hi All, I have a list of strings saved as one of my process variables, I'm just trying to display this list in a table for an email . Each item creating a new row in the table. Any Idea how can achieve this? 

Hi all, I am generating XML document....based on that...i have to display the  xml text  in docx template.is there any way i can achieve this?

In sync record smart service ,How can we sync more than 1000 identifiers list of primary key values?

Hi ,  I have a requirement to generate PDF File and pass some value from outside , when i am using .PDF File as template i am not getting ###value### replace with option how can i resolve this ?

User will complete one task namely task A today and the next task named task B should be created only at 5AM EST the next day. Until 5AM EST, the process has to be in waiting stage. Task A can be completed at any time the previous day. How to achieve this?Thanks in advance

Hi All,When I run the process, I am getting the error in "Send Email" node. Error Details - "index (Data Inputs)".Assignment of the node, it is set as run whoever started the process.Please suggest if anyone had an idea about this.Thankyou in advance!

Hi, Question for the community. I have a process id and which is the efficient way to find the process status. I don't need any other info from the status only whether it is completed or now.

Hi All, We are facing an issue with execute store procedure.  The stored procedure involves an OPENQUERY statement that connects to another server's database table and inserts data into it. Previously, we were using the deprecated Execute Stored Procedure method without any issues. As part of our version upgrade, we have updated with Execute Stored Procedure (Native) method, which is not functioning as expected. Please find the sample query in the stored procedure - INSERT OPENQUERY (<linkedServerName>, 'Select <columns from linked server DB Table>') SELECT <columns from current DB Table>; Error Message:  The operation could not be performed due to the OLE DB provider "MSOLEDBSQL" for linked server "dxbkdb01_edms" being unable to begin a distributed transaction. Thanks for your guidance in advance!!

I have a Process Model in which last node is as same as start node's interface , this last node is just showing some grid on the same interface after getting few details, But the problem is this , the last node is working if I monitor it but it won't show it's result on site instead it refreshes the page and start a new form to get submit.

I have read the documentation and I think I have followed what is suggested but I still cannot start the process- from the interface. this is the section of the interface where I am calling the process model: a!sideBySideItem( item: a!imageField( images: a!userImage( user: local!currentuser, link: a!dynamicLink( value: local!imageuser, saveInto: a!startProcess( processModel: cons!GLP_UPDATEPROFILEPICTURE, processParameters: { userToUpdate: local!currentuser }, onSuccess: a!save( target: local!imageuser, value: fv!processInfo ) ) ) ), isThumbnail: true(), style: "AVATAR" ), width: "MINIMIZE" ),

I have created a process model that produces an Excel file and places it in a knowledge center. Is there a way to automatically download the excel file from the process model without using a user form with a download link? It seems like such a basic functionality that I am a bit confused as to why it is so complicated.

Hi, My requirement is that user can select already uploaded word template document(some substitution keys included in the template already) from a dropdown on a form. After selecting, I have to scan all the substitution keys from the template and show in the grid on the same screen with 2 columns - field name(substitution key) and value(that will replace substitution key). So, after submitting the form, the word document will be populated with those values. I know we can do this from process model with word from template smart service but my requirement is that substitution keys can vary in number. So, I have to get the values from the interface only.

Hi, In my Process Model I have a Write Records Smart Service. When I go to the "Data" tab, I see only Pause On Error (Boolean) under the node inputs. I don't see "Records"(any type). When I try to add it manually I see a dialog box saying "The Activity Class Parameter name is already in use". I don't know what to do...

I am generating an excel with Export DSE to EXCEL.The smartservice consults a view with the data ordered by a date field.The result obtained in the smartservice is ordered by id (PK), not by date.How can we order by the date field in this smartservice or collect the records as they are in the view without ordering them by pk?

Hi! I´m trying to make a process in which a document (pdf) is uploaded, then some values are extracted and reconciliated and, finally, those values are saved into a record. By now I managed to create a process until the reconciliation of the document: First of all, the process start form allows the user to upload the document After that, I start the doc extraction and, when it is finished, the user is allow to supervise and reconcile the values which are not correct and "train" the program. By now, this step appears as a task in tempo (I don´t know how to make it appear in the process, by now I have to click into" reconcile doc straction" and "execute the task", manually My doubt here is how to save the values, mapping them with specific columns of a created record. By now I have a data type (general) only with the fields (id factura, nomProveedor, NIF...). 

Hi! I have a write records smart service but it gives me the following error: Unable to write to the source because the data source did not respond. Error Details: Field 'a_id' doesn't have a default value What is causing this trouble?

Hi, I have a simple process model which I am using to send emails. If I am sending email to person who is OOO, then I would like to collect OOO email. In order to achieve this, I did the below setup, but still no luck. Appreciate if someone help on this. Thanks, in advance. In addition to the below setups, I have also added conf.suite.ANONYMOUS_ACCESS=true in the custom.properties file.

Hi, I have a requirement to send/receive message to process instance. My instance holds 3-4 receive message events a particular receive message will be executed based on the msg.properties.xyz properties. When a particular receive message event continues and the process terminates I am getting a error email from rest of the listeners. Problem:  This notification is sent for canceled event messages of type Process to Process. Details:  Canceled consumed message in Message Filter (ERROR:EVAL:@reason=Invalid bean property name 'rejectToRequestor' (valid properties are jmstype;username;eventtype;acceptandallocaterequest;originprocessmodelid;originprocessid;destinationprocessid), bean error code 0) for message sent to persistent id 0003ea7b-4569-8000-4990-7f0000014e7a on named port 'reject To Requestor'. The process itself has not been canceled and may continue to consume events. Recommended Action:  Check the message listener for correctness. Cleanse the