Discussion Categories

Hi Everyone, I have a requirement of uploading an excel which contains around 50k records. Currently , we are using plugin to extract data from file to DB which is having automatic batch size. But, CPU utilization and heap memory usage is too high which is causing environment to break down sometimes. I came across Read Excel File Paging Function , But even with this function writing to DB had much complexity of mapping and all. Any other way that we can acheive this using other plugins or anything?

Hello team, is there any best practice on how to auto-release a task which was accepted by somebody from a specific group after some time, lets say 1 hour. In my case i have a group called "Processors" which contains approx 50 users. When a task is assigned to this group the users accept a task a work on them. I want to ensure that when somebody from the group accept a task but not complete it in 1 hour it will be autoreleased and reassign back to the whole group so somebody else can take care of it. Thanks

Hi Team  Here i am looking for different ways to integrate Appian with Microsoft teams without using paid plug in if you have any suggestions how can i implement that would be helpful . Thanks

Hi, We are experiencing issues while trying to import an application from version 23.2 to another running version 22.4"content _a-0000e9b4-aa73-8000-9ba7-011c48011c48_31355: The data for content [id= uuid=_a-0000e9b4-aa73-8000-9ba7-011c48011c48_31355] could not be read from the XML. Cause: javax.xml.bind.UnmarshalException: java.lang.RuntimeException: An error occurred while trying to get the TypedValue type (Id) from XML. XML node: null" To enable the system to allow the import of the application, we have modified the 'MANIFEST.MF' file, and this has worked on previous occasions.

My app is built on an Oracle Database. Would it be possible to overcome the 4000 byte of Text limitation we have for Synchronized Records fields? I know the VARCHAR2(4000) limitation is considered to be a standard column type by Oracle, then choosing the EXTENDED for param. max_string_size in the DB would make it an "extended data type", as CLOB is. But since CLOB is forbidden to become a Snyc. RT field, would my large VARCHAR2 columns be also forbidden? Asking for people who tried it. If no one did, I will ask the DBA, but could be easier to ask here ;)

I've completed Design Appian Records Part 1: Accessing Your Data last week but I'm having few doubts on it & decided to go through it again but I'm unable to access that course. Can anyone help me with this ?

Hi Everyone, Is it possible to update the certain columns only and not all columns of a data store entity using write to multiple datastore entity smart service. Thank you!

I got 502 Bad Gateway during opening my account How it will be resolved

Hi All, I have a requirement to convert an XML file to CSV, where the data points of the XML file can be dynamic. We cannot use CDT/Tables as the data points are not fixed and we need to use some mechanism that identifies the datapoints dynamically can convert to flat CSV file. Please let me know if anyone has any solution for this. TIA.

Hello everyone. I need help. Am working on a process model for a MILESTONE (BAR) PATTERN interface. When I lunch "Start Process for Debugging", the MILESTONE form load for me to input data. After inputting data, I click next and the next step load until I get to the final step, and I click the submit but nothing happens when I click the submit button. The submit button will not submit the form. Thank you for your assistance. a!columnsLayout( columns: { a!columnLayout( contents: { a!buttonArrayLayout( buttons: { a!buttonWidget( label: "Back", value: local!currentMilestoneBarStep - 1, saveInto: local!currentMilestoneBarStep, style: "NORMAL", showWhen: local!currentMilestoneBarStep > 1 ), a!buttonWidget( label: cons!GCO_TEXT_VALUE_CANCEL, style: if( local!currentMilestoneBarStep = 1, "NORMAL", "LINK" ) ) }, align: "START" ) } ), a!columnLayout( contents: { a!buttonArrayLayout( buttons: a!buttonWidget( label: if( local!currentM

How to drilldown into integration body  to index upto specific field

Hello there, I have a Upload field where user uploads 50 rows of 2 columns data from/csv onto form. I have to read all those and display the data in editable grid before submission. To achieve this i have used submitUploadedFiles function with empty process model to start on its button click. Even though data displayed on Interface object correctly, throwing error on front end. Please help me if i did something wrong. Added code snippet for upload and button a!columnsLayout( columns: { a!columnLayout( contents: a!fileUploadField( instructions: "NOTE: CSV file size cannot exceed 50 rows and should only include tickers and weights", target: cons!SRT_FOLDER_UPLOAD_CSV, maxSelections: 1, value: ri!document1, saveInto: ri!document1 ) ), a!columnLayout( contents: a!buttonArrayLayout( buttons: a!butt

Hi, me and my friend have an Appian Community Edition site where we both can access the Administration console, Appian Designer, etc.  I wanted to work with my friend on the application that is being built in his Appian Site currently. How do we both get access to the application and collaborate on it together? The goal is for both to work on the same application so as to make changes to it simultaneously from two different devices (Two different Appian accounts in this instance). Any help is appreciated

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 ?

Hello, I've been training a document extraction AI Skill in one region and then deployed the AI Skill to a different region. Interestingly, I'm finding that the document extraction in the first region performs better than the document extraction in the newer region. Do AI skills have to be retrained in each region, like when you deploy from TEST to PROD? Thanks!

Hi Community, is there a way to display some text other than the default text in the document viewer ? If there isn't, is there any other component or plugin to do the same ? Thanks.

Hello Community,the more I am working on bigger scale projects with multiple devlopers, I am thinking about a kind of code merging functionality.Currently we have an "overwrite" principle. If i did changes to that interface/expression rule etc and press save then all changes previously done are overwritten. So if person a and person b are working on the same interface, the last one who saves "wins" and the changes of the earlier saver are essentially gone.Does anyone has insights if something in this direction is planned?I can see that difficult for records, decision tables or process models. But for interfaces and expression rules, it should be possible in my mind.Perhaps my idea is totally off the chart :)I am open to your opinions on that. kind regards form Hamburg Germany, Richard

what should i do

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, I am getting around 2000 ids in one local and then passing that ids to one of column in queryfilter using IN operator. But when i test the rule I get this error as: An error occurred while retrieving the data.  So we split the ids in batches by taking 1000 ids in a set and then pass these id to queryfilter through looping. But still it failed with above error. We have already optimized the view also and same query when we run in DB side it took just 0.170sec to bring the data. But same is not working in Appian queryentity. Can anyone please suggest what could be the reason behind this and what all steps we can try to get this working.  Thanks in Advance..

local!supervisorList: if( contains({ 3, 6 }, ri!selectedDashboard), index( /*a!isNotNullOrEmpty(tointeger(ri!reportingEmployeeList)),*/ ri!reportingEmployeeList, wherecontains( cons!INO_DESIG_ID_SUPERVISOR, tointeger( index( ri!reportingEmployeeList, "designationId", 0 ) ) ), {} ), null ), local!supervisorHierarchyList: if( contains({ 3, 6 }, ri!selectedDashboard), a!forEach( items: local!supervisorList, expression: 'type!{urn:com:appian:types:INO}INO_employeeHierarchyHelper'( employee: fv!item, directReportEmployeeList: index( typeof(ri!reportingEmployeeList), wherecontains( index(local!supervisorList, "internalEmpId"), tointeger( index( ri!reportingEmployeeList, "currentReportingManagerId", 0 )

How to get the duplicates from an array: i/p:{1,2,2,3,3}o/p:{2,3}

Code consists of 20 local variable with same rule being called 8 times.

We have validation use case. There's a form contains many input fields, if any field value is missing, when click submit button, the page should scroll to first missing value field, make this field on the top page. Is there any component support such feature? How to do that? Thanks

Hi, I'm trying to read a cell value using function excelreadcellsbyname but i'm getting below error when trying to read a cell value.  can anyone please  help in fixing this issue input : excelreadcellsbyname(640958, { 2 }, { "F9" }), output : Expression evaluation error at function 'excelreadcellsbynumber': The column Value of long (+ve) position doesn't exist in table INVFI