Process Automation

Hi team, I was following the document  https://academy.appian.com/#/online-courses/fc14c3d1-0eb3-4d9d-8ae2-fc0149ae7585 asking me to select Template from the toolbar and then select 'Import Template' but I do not find the import template icon on my community edition.  I can just see the default ones.. When I see the Appian documentation at https://docs.appian.com/suite/help/22.3/rpa-8.5/templates/rpa-templates.html I can see the import template icon on the top right in the doc. Can someone pls help is it just me or do I need to update something somewhere to get the import template icon ?? for now while I wait I have raised this to support team as well thanks jaideep

Background: Using integrations I have called several endpoints and pulled the data into a map with nested maps.  I now need to move values from the nested map to the parent, as they are all 1:1 relations. a!localVariables( local!CDT: a!map(id: 1, name: "Walt Disney", demographics: a!map(age: 73, gender: "M")), local!CDT) This returns:  Map id1(Number (Integer)) name"Walt Disney"(Text) demographicsMap age73(Number (Integer)) gender"M"(Text) what I am in the need of is: a!map(id: 1, name: "Walt Disney", Age: 73, gender: "M")

Hello good evening, I need help, well, it turns out that I have a problem, for example, when I want to omit certain special characters, I use substitute, all fine for example if I only want to omit the symbol "&", but when I put another symbol, for example "%", instead of replacing it, I get a blank space, I have already used substitute, stripwith, a regex, and I can not find a solution, I attach my code. a!localVariables( local!subs:substitute(ri!name," & "," "), local!formatB: cleanwith( local!subs, cons!GT_CONS_Clean /*1234567890qwertyuiopñáéÃ%ADóúÃ%81ÉÃ%8DÓÚQWERTYUIOPasdfghjklASDFGHJKLzxcvbnm-ZXCVBNMÑ_ */ ), if( length( local!formatB ) = 0, "attach", local!formatB ) ) I have already tried these functions and I can't get that.  regexreplaceall("\s\W", local!sub, "_") stripwith(ri!name," &#$%&/|¡? ") For example, when I try to test this string, instead

Hi Experts, I have a requirement where we have to get the input from user for the time fields, User want the time to be entered in HH:MM:SS in 24hrs format where SS is optional. Below are the input with expected stored output Input1: 23:55:55      Output: 23:55:55 Input2: 10:32           Output: 10:32:00 Input3: 23                Output  23:00:00 Input4: 231000        Output: 23:10:00 Input5: 2359            Output: 23:59:00 Input6: 23               Output: 23:00:00 Kindly suggest for the feasibility of such expression as how can we achieve this.

Hi there, could anyone let me know what's the problem here, in the following expression rule, if the condition is meeting, it will return the records which meet the condition, if there are no records meet the condition, I just want to return 0 item, but here it returns 2 "0 items". replacing "{}" with null does not work either. what I should do? regards Lin

Hi All, I have a table with studentid|subjectid 1     | 10 1     | 11 2     | 12 Students who belong to 10 and 11 should get 1|Science, 2|Maths. How can I get the output like this.        

Getting "RecordFormatException" while updating the record in excel file. Used apache poi with the version 4.0.0 for reading and writing to the excel file. Can any one help on this issue?

Hi all, {1,2,3,8,9,9,9,9,9,80,90,70}, {56,76,54,32}, {20,23,45,54,32,54}, {1,2,3,4,5,6,7}, {11,12,13,14,15,16,17,18} Please suggest how do this using foreach function get output like this, length of array 1 is 12length of array 2 is 4length of array 3 is 6length of array 4 is 7length of array 5 is 8 Thank You In Advance

Hi All, I have been trying the image recognition RPA functionality, getting the below error & I have used the given templates & ran the process in the available resource.  Kindly let me know where can we insert the image for Image recognition, How to configure this?

Dear david.catalan    Could you help me to resolve this issue? I am following the course and trying to record the searching bank name and certificate number action in chrome browser but could not get the list of applications Please refer to the screenshots below: I have chrome in the start menu Could not see any applications in the dropdown list,

My teammate found a bug when using proper() to display a label; a word preceded by a non-alphabetic character will not be converted to proper case. If the 11th floor is home to the HR department. Floor.id = 11 Floor.department.name = "human resources" We would expect: Floor 11 (Human Resources) but instead get: Floor 11 (human Resources) To reproduce the issue, I used this expression to check capitalization: proper( "I am reporting that ""proper() coNverts each [alphabetic] cHaRacter into ProPeR caSe " & "(unless a non-alphabetic character precedes it)""" ), Where I would expect: I Am Reporting That "Proper() Converts Each [Alphabetic] Character Into Proper Case (Unless A Non-alphabetic Character Precedes It) It's returning: I Am Reporting That "proper() Converts Each [alphabetic] Character Into Proper Case (unless A Non-alphabetic Character Precedes It) Is proper() working as designed? Side note: 22.4 documentation reads, "Converts each character i

for example my input is 0323 and i need output march-2023 (or) 03-2023

Hi Everyone, I have the requirement where the excel file is to be read by IDP. But I am not sure if IDP can extract data from excel file. Can anyone please help me out if it is possible through IDP or any other alternatives? Thanks, Shubham

I am new to Appian and I am evaluating the Appian RPA. I have already completed "Appian Robotic Process Automation (RPA): Learn to Develop Bots" course. I want to learn the process automation using Appain RPA so could you please suggest any course with detailed explanation? Thanks in Advance!!!

The guides don't say anywhere how to open IDP.Perhaps it's not installed on our instance and it would be obvious from the main menu.Where does IDP normally appear? In the top right main menu?Are there permissions associated with it?Our system administrator is on vacation and I'm not sure if I just can't find it because I'm learning how to use Appian, or if it's not installed. Thank you.

Hi All, I am Trying to Fetch Last login Details of some users by using getuserlastlogin() but it is returning Null values for users who logged in 1 week before. Does This function work only for last 24 Hrs? Thanks in Advance!!

Hi I am getting an error message below. Could you tell me how to solve it. ■the whole message displayed by the Configurator -----------------------------------------------------------[INFO] Scanning for projects...[INFO] Downloading from SERVER_ID: mnvk.appian.community/.../maven-metadata.xml[INFO] Downloading from SERVER_ID: mnvk.appian.community/.../maven-metadata.xml[WARNING] Could not transfer metadata org.apache.maven.plugins/maven-metadata.xml from/to SERVER_ID (mnvk.appian.community/.../repo): authentication failed for mnvk.appian.community/.../maven-metadata.xml, status: 401 Unauthorized[WARNING] Could not transfer metadata org.codehaus.mojo/maven-metadata.xml from/to SERVER_ID (mnvk.appian.community/.../repo): authentication failed for mnvk.appian.community/.../maven-metadata.xml, status: 401 Unauthorized[INFO] Downloading from SERVER_ID: mnvk.appian.community/.../maven-metadata.xml[WARNING] Could not transfer metadata org.apache.maven.plugins:maven-archetype-plugin/maven-me

Hi, I have an excel file which looks like  that I am importing to my Appian DB through the smart service 'Import Excel to DB' and Ticket_Number is the primary key on my DB. It appears to me that the Smart service is sorting the primary key in ascending order (which I don't want).. I don't want to sort my data in either ascending or descending order. One solution is to create a separate primary key and prevent this from happening but is it possible to restrict the sorting in the smart service 'Import Excel to DB'. Is this a bug ?? or just that I am not aware of how to prevent my smart service to do any kind of sorting ? please help  thanks jaideep

Hi I am trying to do 'Maven Setting' with Appian RPA Configurator. However, an error message below is poped up. ・Authentication Error!: Check that the provided console repository URL and the maven API key are valid. This means that the provided console repository URL and the maven API key I input  is incorrect, isn't it? Please let me know if there is a possible cause other than incorrect input of the value.

Hi everyone, I have a CDT CDT type process variable called pv!caseIds, which contains a column showing case IDs as below: [caseIDs=1, deleteDate=11/12/2001 17:30 GMT+11:00],[caseIDs=2, deleteDate=11/12/2001 17:30 GMT+11:00],[caseIDs=3, deleteDate=11/12/2001 17:30 GMT+11:00],[caseIDs=-1, deleteDate=11/12/2001 17:30 GMT+11:00],[caseIDs=-2, deleteDate=11/12/2001 17:30 GMT+11:00],[caseIDs=10, deleteDate=11/12/2001 17:30 GMT+11:00],[caseIDs=3030064, deleteDate=11/12/2001 17:30 GMT+11:00] I also have a text list of case IDs, saved in another process variable called pv!caseIdText = {1,2,-2} Now I want to find all the case IDs in pv!caseIds.caseIds column that ARE NOT in pv!caseIdText (which are {3,-1,-2,10,3030064}) I tried using difference() as below: difference((pv!caseIds.caseIds, pv!caseIdText) and got this error message: Expression evaluation error at function 'difference' parameter 1 [line 2]: Invalid index: Cannot index property 'caseIds' of type Text int

When I use formatjson function, it automatically change "&" to "\u0026" , and "<>" to "\u003c\u003e", how to aviod that? Can anybody help? Thanks

Hi , Requirement : I want to download a file using RPA but when the bot click download the file, The file is saving in download folder by default but we need (save as popup) so the we can save the downloaded file in specific location  when i am trying to download manually save as pop-up is showing  and i can save in specific location but its not showing when RPA bot download's the  file  I have tried changing settings of chrome but its not working , please suggest with some solutions  Thanks & Regards  Shashank 

Hi All, I have to check whether the current time(irrespective of any user time zone) is between 7pm EST to 9am EST. So we tried to convert the current time to EST first and then to compare it with "7:00 PM" & "9:00 AM" EST (by creating text constant). We just tested with below code to check whether comparison works fine by changing the constant value, but it fails  totime( gmt(  local(now(), "EST" )    )  ) > totime(cons!xyz)  where cons!xyz = "7:00 PM" (a text constant) So please help me how to make this work. Thanks in advance.

How much data we can retrieve from database in expression rule?

I would like my AppianRPAagent to connect to resource.  So, I refered to URL Below. docs.appian.com/.../agents.html After I created a new resource "TestResource", I downloaded AppianRPAagent.exe and run it.However, "TestResource" didn't get online. ■Resource detail Could you tell me what makes this error arise?