Discussion Categories

Hi <Summary for the current situation> 1. In "Data Source Management" of "Appian Admin Colsole". The existing "Name", "Type", and "Connection String" are maintained, and only "Username" and "Password" are changed and applied.      ex) previous username= appian1, changed username= appian2            (previous schema= appian1, new schema= appian2) 2. In this case, the problem that arises is, the previously created CDT continues to look at the previous schema (appian1).          (The following error message appears.) 3. I don't see a way to change the schema anywhere in the CDT object or XSD file. 4. Is there a way to change the schema of CDT, or is there a way to solve the situation? Thank you

Hi All,  I am working on a use case where i need to first convert CSV to excel then import converted excel with extra column to a staging table.  Reason to use import excel to database intend of directly using csv to database is i need to dynamically add process instance id in staging table. I didn't find any option to achieve same in CSV to Database.  CSV to excel is working fine. I am able to generate XLSX file and passing it to import excel to database. My process is getting completed successfully but i don't see data in staging table.  I tried converting csv to xlsx in my local machine and used locally converted xlsx in process model, it worked but same when i am trying to achieve from CSV to excel smart service generated excel, data is not getting imported. I don't have auto generated column in my XLSX file. Please advice what can be done resolve this issue.  Thanks in advance for your help. 

Hey Guys, i just want to write a rule expression. wrting(create) data to the database using record type. the record type is already synced with the database. I can not figure it out. i also tried using Write to record smart serice but  i keep getiing error that i can not use record type.  how is something so easy so difficult to find solution. please help. i just need a a expression structure for writing data to the database using record type

I am currently having issues while working with a one-to-one nested cdt design (without reference data).  I have simplified this problem by creating the following 2 tables: CREATE TABLE TEST_PARENT(parentId INT PRIMARY KEY AUTO_INCREMENT,parentName VARCHAR(50)); CREATE TABLE TEST_CHILD(childId INT PRIMARY KEY AUTO_INCREMENT,parentId INT,childName VARCHAR(50)); ALTER TABLE TEST_CHILD ADD CONSTRAINT FOREIGN KEY(parentId) references TEST_PARENT(parentId); While trying to publish the nested CDT TEST_PARENT with the following configurations: I am receiving the following error: The repeated column error does not make sense to me as the columnName defined in the second screenshot is the foreign key column on the child table which is pointing to the parent.  I am struggling to get this to map properly and get around this error and would appreciate any assistance.

Hi,We are getting below error when trying to read document from MFT folder. It was working fine and suddenly breaking.[Appian Work Item - 245513 - WorkID 6 - execution02 - process 537248294 - model 8379 : UnattendedJavaActivityRequest] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=536905115, classname=com.appian.ps.plugins.sftpsmartservices.ReceiveFileOverSFTPBasic java.lang.StringIndexOutOfBoundsException: String index out of range: -1Could you please help me here?

Can Appian receive an email and create an action based upon that email?

HI I have a requirement to export more than one lakh records into excel sheet. challenges:      -> Data is coming from a view having multiple joins.( Facing performance issue at production)     -> So we followed appian records approach, but export to excel button is getting disabled when record count is more than one lakh.     -> As the records count is high, we are not interested to go stored pro and staging table approach Any advice is helpful

Hello Community, I have an interface that displays two types of data coming from two methods that delivers the json values. If this is an individual I have built out a CDT that ties into the method "individualResult".  If it's a group, I will have to tie into the "groupResult" method.   The properties are the same, but the methods are different.  I'm wondering if anyone has a recommendation as to how to build this out? Let me know if more information is required. Thank you.

Hi all,  May i know how to extract data from an xml file Thank You In Advance

How to retrieve the sign document back to the appian

Hi All, In our application folder more than 4000 child folder reside inside the folder. First of all, I want to extract all the folder and show in the grid and then I want to seach them by folder creation Date. Kindly guide me on how to do this. Regards, Vikram Kumar Singh

Hi  all,  may I know, how to extract data from an xml file Thank You

Hi There, I’m trying to use card as buttons pattern to call an interface. Interface is having gridfield used inside a!headerContentLayout() to display task lists. However, I’m not sure how can I call call this interface using card as buttons pattern. Is that a right way of calling ? Please do let me know if you need any more details.

Hello All, My requirement is client is sending an csv file to Appian which we need to insert in Appian table. I am using "Import CSV to Database V6" smart service. But now client want to send the file with some header and footer. Can anyone tell me how to read a csv file in Appian which is having header and footer. In Appian we don't need to save the header and footer we can simply ignore that. But how to ignore that in the Appian because client is sending same file to multiple platforms, so we need to do that in Appian itself. Thanks in advance Regards Sahil Batra

Hi All,           I have a requirement that to display the month name & Year  from two particular dates .Is there any direct function or please give any valuable suggestions on the same. Ex:11/2021 --10/2022  It should display Nov2021,Dec 2021.....Oct 2022 Thanks & Regards Saidivya Minna.

Expression evaluation error [evaluation ID = a6b59:bf472] in rule 'ofm_repairsection' at function a!buttonWidget [line 222]: An error occurred while executing a save: java.lang.IllegalStateException: A Value should not be the result of activation What exactly this error mean.....

Hi everyone, I just created one interface which queries data from a record type, to build a dashboard.  I want to call that interface into a bigger interface, in which if I click the card field, the dashboard will show up. This existing interface is using a!cardLayOut for displaying other field, and I couldn't find any solution to call the new interface into it, as the a!cardLayOut link parameter only accepts  a!documentDownloadLink(), a!dynamicLink(), a!newsEntryLink(), a!processTaskLink(), a!recordLink(), a!reportLink(), a!safeLink(), a!startProcessLink(), a!submitLink(), a!userRecordLink(), or a!authorizationLink(). Is there any way I can work around with it?

the

Is it a bug or is there some other reason why my users cannot see records in Tempo or other places when I explicitly gave them permissions in the security configurations? Is anyone else having this problem.  I don't want to run around with expressions if the option exist to give them at least viewer permission in the security configuration.  I have given permission on the record type, data store, site, interface ... They still cannot view the record type, even though the tab is visible in Tempo

I need to copy the First Sheet from an Excel Document and add the same to the new Excel Document as its FIrst Sheet. can you please suggest the best approach and the smart services. Note: The First sheet will contains the data, so it should not be altered while copying

Hi Guys, Please help me on the below! I need to import list users from excel to the process model and then add them to numberous group. Can you please help me on the same??

Example:  Rule input has no. of items 24, I want to retrieve in batches of 10. i.e at 1st I need to get top 10, 2nd time next 10 items and 3rd time should get 4 items

I have created a Connected System that uses OpenAPI.  I then created an Integration that uses the OpenAPI CS to call a User Authentication API that returns a service token.  That token is then used to authenticate  other APIs that are available for the application.  Every API must have the token referenced in the header in order to authenticate.  I am trying to create an Expression Rule that can be used as a wrapper to call the User Authentication API and return the token.  I would like to use this rule as the Header value when creating additional integrations for the other APIs so that the authentication can occur every time the integration is called.  When I test the expression rule, I get an error that reads: "The jsonText parameter must not be null or empty." Here is a screen shot of the Integration, which works when I manually insert a valid bearer token: Here is the expression rule that fails: It seems like the API is

I'm trying to open a summary page in site by using a hyperlink from dashboard and I'm getting the following error "An error has occured The field [e40--------] does not exist.(APNx -1---)"

Hi all, may I know, how to extract the xml data in an xml file Thank You