Process Automation

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?

Dear I am setting up an environment to evaluate Appian RPA, referring to the URL below.https://docs.appian.com/suite/help/22.4/rpa-8.3/custom_code/configurator.html I have a question. I clicked the button "download" to install Maven,but an error message popped up. Could you tell me what prevented me from installing Maven? Thank you.

hi, my query is if i want to read xsl document  details in expression rule is any function for this

My requirement is to fetch the correct option for the respective question which is there in the database. So what condition i need to apply in choiceLabels() as am getting questions in the correct order only but only the option from the first row is getting repeated for all the questions. so i want first 4 data to go for 1st checkboxField() , next 4 to second checkboxField() & so on. local!data:rule!MWJ_qe_forQuestions(), local!option:split(rule!MWJ_qe_fetchQuizOptions(),";"), local!choose:{1,2,3,4}, contents: { a!forEach( items:split(local!data,";"), expression: a!checkboxField( label:fv!item, labelPosition: "ABOVE", choiceLabels:{ a!forEach( items:index(split(local!option,","),{local!choose},0), expression:fv!item,)}, choiceValues: { a!forEach( items:index(split(local!option,","),{local!choose},0), expression:fv!item, )},

I have created a RPA process to log into a software on our internal network and take screenshots of a machines status and then sends those screenshots to a user outside of the network.  The bot is running unattended on a Virtual Machine.  When I have the remote desktop open, the screenshots take the image of the entire screen.  However, when I allow the bot to run unattended the screen resolution is too small to capture the whole screen (see attached images as examples).  The virtual machine is managed via VMware. Does anyone know how to increase the screen resolution of the bot on the unattended Virtual Machine?

Hi Guys, is there any way to increase the expression rule timeout which is pulling data from a view .  As now its getting timeout because of the complex logic in view so i  just need to increase the timeout of a expression rule to check it  Thanks in advance