Developers Forum

how we can import data in database table when we have export data stored in datatable variable , we dont know the no of column in exported table and Imported table at run time but both tables are same numbers of columns and same type then how can we do it .  can we write insert queries in Insert activity present in AA 360 where we directly insert row without specifies the name of column and their values . 

I am having an issue (probably?) related to automation anywhere’s updates. Every time the control room gets updated, the device is automatically disconnected. I mean I guess it does make sense because if there is a new updated, you must update yours. I would just like to know if there is any place that these changes/updates are posted/communicated to people. It is not cool to arrive early in the morning at work and nothing runned as expected.(it is probably related to updates because it happens every time the control room changes some resource.)

Hi Everyone  How to convert date format from dd/MMM/yyyy to dd/MM/yyyy?Example:06/Oct/2023 to 06/10/2023?

I have downloaded PdftoCsv taskbot from bot store, when running the bot entering required inputs, getting error as “Specified folder path is invalid". Can someone help here please.

I’m building an automation via a process that uses bots and forms. I can run the process in AARI, but when opening the process to make changes, it will not load.  Has anyone had this happen and how can I resolve it?

I created the below program that copies Column B to Column C using Excel as a database action. There is a side effect for the insert/update/delete action at line 5; that does not keep the trailing spaces after "aa    " in line 2 after the copy.  So, when I check for equality after the copy only lines 3,4,5,6,7 are considered equal. Is there a way to keep trailing spaces and prevent this automatic trimming behavior?  

After running the bot it shows the following message….Why is this message showing again and again?Requesting solution from Expert to solve this problem. Advance ThanksPatwary

Hi, Good day, I have a bot that needs to work with a queue. After completing all the queue items, I have to perform consolidation. Now, how can I determine the queue status to know if it's the last work item? Additionally, I have an application that experiences downtime every day from 10 AM IST to 12 PM IST. When the bot, which is implemented to work with the queue, reaches this particular time, the work items should not be processed Since the Application will be down. Once the downtime until 12 PM IST is over, the bot should resume from where it left off.  Thanks,Sridhar 

Hi, When I run my bot in an unattended manner on a VM, I encounter the next problem: Mensaje de error:User not logged into the machine. This may be due to multiple reasons.1. Check that your username and domain name is correct in the provided device login credentials.2. Login into the machine as that user before running the bot.3. Some other user may have logged into the machine.But my credentials on the device are correct, this problem occurs at night when the PC is blocked, the PC is a virtual machine.

Hi everybody, how are you?I would like to ask you about a problem with reading emails.I am wanting to get email from Outlook web.And the error message is "The provided connection details are invalid".I tried with Imap and Pop3, but it gives me the same error. I tested the credentials and they are ok.I am new to A360. I hope you can help me, please.Thank you so much 

Has anyone had a process that involves updating a pptx file?  If so, what method are you using to navigate, etc through a template pptx file.

Hi All, From about 8 - 10 days, My team started experiencing the "The Process cannot access the file because it is being used" Error. Bots used to work for months without issue suddenly began failing on this exact action for Excel or CSV files. We are getting this randomly across different bots. The file is not being used by any other bots or users. The path is also not being used by anybody else. Looking forward to your immediate help. 

Hello,Can someone please help me with the answers for the below questions.How to speed up the procedure by optimizing the bot? Is it possible to run the bot in the backend or background, so that we may run multiple bots at a same time?

Hi I have the iframe in a website which and i want to extract the data in it and that objects are not capturing, some objects are label that wont work for all login basically that label name itself is what i need to extract and the selection we can only give the name. please help me to work on this

I deleted a creator user and created a new one. How can the bots be transferred from the deleted user to the new user? I have version 16685. Thanks for help!

Hi,Getting the attached error in browser (Checked with both chrome and Edge) when the BOT clicks on a certain button only. All other actions happens normally. We have used to Automation Anywhere 360 to develop this BOT. Kindly request your support identify the issue here.  

Has anyone encountered an error with the Recorder: Capture action in which the action fails due to inability to find the “Client” control type? Here is where the control type is specified in my action:  Unfortunately I cannot uncheck this “Control Type” box and I don’t know how to modify the attribute.  Here is the error I am getting:  Any advice is appreciated. I am using Microsoft Edge.  ***update***The snapshot excerpt below from the documentation mentions the Client control type.It sounds like the element I am capturing just doesn’t support “Get property”. Can anyone offer clarity about this or how to go about this a different way? You can see in my screenshot below that I am just selecting a simple div element with the recorder. I am not a web developer so I may be missing something completely obvious. Would love to be enlightened if that is the case! Thanks again!

Has anyone set up an open-source LLM to run locally/on-prem? My company is concerned about data security with cloud-based AI services and foundation models, so I am looking into fine-tuning an open-source model and running it internally.My vision is start very small (fine tune the model on our employee handbook for a Q&A chat interface). My hope is that this eventually leads to adoption of third-party services for broader application after getting buy-in. Specifically, I am curious about:Hardware requirements (NVIDIA vs other/amount of memory needed/etc.) Time it takes to fine tune Inference time Integration with A360 I have heard differing opinions on whether this is a feasible/practical route and would love to hear what you all think. 

Hi,I am trying to update credentials in credential vault using API. I am using PUT method with the URL -“<control room url>/v2/credentialvault/credentials/<CREDENTIAL ID>/attributevalues/<CREDENTIAL ATTRIBUTE ID>”JSON :{      “value” : “New_Password”      “version” : “2”} Authorization method and token is fine.I still get the error as : {   "code":"json.deserialization.exception",   "details":null,   "message":"Invalid request parameters"} What am I doing wrong? Please help. Thanks a lot 

Hi guys,I have two problems1.I have an invoice in PDF format.In addition, I have an Excel list with departments and their abbreviations which should but do not have to appear in this invoice.The location of the department name in the invoice is not fixed, and can be arbitrary.Is it possible to match the Excel list against the PDF to get the following conditionDepartment in Invoice PDF = Department which is stored in SAP;if no, then replace the department in SAP with the department stored in Excel list.  2.I have an XML file from which I need to extract certain values. The values can always be in different places, but always have the same header. As an example.Invoice date must be read out.Header = StartDateTimeshortly thereafter comes the date that must be read out.I have a hard time because the data are not always in the same lines and also many unnecessary text between the data and partly in the same lines as the data are.Do you have an idea how I can filter out the specific values? 

I’ve run into an issue with the Json response body of an internal API. A successful POST request will return an array of JSON objects but without a parent or root name. This is causing some trouble with the JSON package as it needs a root name in order to fetch the node value. Is there another package that can parse this data without needing an object root name? Below is an example of the response:[ { "mrn": "211757", "firstName": "Tester", "lastName": "Jimmy", "dateOfBirth": "2022-02-02", "gender": "None", "county": "", "homePhone": "111-111-1111", "workPhone": "222-222-2222", "cellPhone": "333-333-3333", "email": "b@h.com", "primaryPhone": "None", "codeStat": "Ycanth RPh", "category": "Ycanth", "insCoord": "", "primaryRN": "" }, { "mrn": "211758", "firstName": "Tester", "lastName": "Jimmy", "dateOfBirth": "2022-02-02", "gender": "None",

What is the file extension for bots in Automation Anywhere A360 version? Some sources suggest it is .jar, while others claim it should be in JSON format. I personally believe that the packages are in .jar format and bot files are in JSON format. Can someone please clarify this doubt?

Hello,I am trying to migrate my bots from v11 to A360.But the modulo operator (%) in number assign action does not work.Am I missing something or is there another way to calculate modulo?Thanks. 

I am getting an exception Message when i run the BOT even the device is connected 

i(exactly my corporation) setting the license for using AARI and i go to the 'AARI web server' -> Manage -> Process for Process Set up and face to above problem... i checked the role(AAE AARI admin role) at the admin account and also made for AARI user account.. how can i solve that?(process set up error)