Process Automation

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

 hyperlinks can be included in the body of the notification display  Understand if the below edit text options can be included so we can underline text/change colour etc  need to be shown an option how it shows in word document to underline and make it color to text  for the text which we are showin in notifications  in this way need to be shown on the screen to make text to color or underline

Hi Everyone, I am trying to run A360 bot through Appian 22.4 . I have created connected system and then integration. I am trying to run a operation deploy Bot. Can anybody help me on how to get File ID, Name OR how we can run A360 bot through Appian  Thanks in Advance 

Bubble sort starts with very first two elements, comparing them to check which one is greater. ( 5 1 4 2 8 ) –> ( 1 5 4 2 8 ), Here, algorithm compares the first two elements, and swaps since 5 > 1.  ( 1 5 4 2 8 ) –>  ( 1 4 5 2 8 ), Swap since 5 > 4  ( 1 4 5 2 8 ) –>  ( 1 4 2 5 8 ), Swap since 5 > 2  ( 1 4 2 5 8 ) –> ( 1 4 2 5 8 ), Now, since these elements are already in order (8 > 5), algorithm does not swap them.

. 

I have created a single interface that is being called by two separate interface but the text in richtext display should be different only. Everything else will be as it is. How to do that?

Hello everyone,  I have a local variable that query data from data table.The data looks like below:  local!cases: { (clientId: 234,group: 55), (clientId: 600, group: 66), (clientId:234, group: 77), (clientId: 600, group: 88), (clientId: 234, group: 99) } I want to get the group name of only client number 600. Below is my code:  index(local!cases.group,wherecontains(600,tointeger(local!cases.clientId)),null), And got this error:  Invalid index: Cannot index property 'group' of type Text into type List of Number (Integer) Any one got an idea what the reason is? Thanks a lot!

Hi, Is there any function or a recipe to get all the basic users. Please help