Excel - Print (Fit to Page) Code Stage
Hi All,Has anyone ever created a code stage for Excel to fit to pages when printing (e.g fit to 1 page wide/tall)? Thanks!
Forum Posts
Connection Failed SQL Server Blue Prism Hub 4.7
Is there any way to install Blue Prism Hub 4.6 or earlier without using SSL Encryption CA? I need to run some tests in my test environment to load data into the Blue Prism queue through API. Thank you in advance!Blue Prism Enterprise v7
OLEDB - Data type mismatch in criteria expression
Hi, I was trying to fetch data from an Excel using OLEDB with below query but getting an error - Could not execute code stage because exception thrown by code stage: Data type mismatch in criteria expression.SELECT [No],[Resp (3&4)] FROM [Call Sheet$...
Resolved! Looking for a suggestion regarding the connection of Blue Prism Database and Power BI
Hi,I have connected the Blue Prism database to Power BI to get an overview of all our bots. I just have to click on the “ Update ” button in Power BI. The data is automatically transferred from the database. I have noticed that uploading the data to ...
Resolved! To add data line by line in a Text Data Item
Hi,Is there any way to add data to a text data item line by line? I need to add data from a collection column into a single text data item in the below format. Is there any option to append line breaks or any other methods available to achieve this?A...
Facing issue while importing the form in Blueprism hub: Refreshing queues failed. 106
Hi Community,Hope you are doing well.I am trying to import interact form from blueprism test region to production region and while importing the form into production region and selecting the work queue by typing the work queue name in text box. i can...
Capture - Bprelease not exporting when custom template is fed
Hello - i followed below steps - for exporting bp release from capture- step 3 is failing.once i click on restore exports to defaults. step 3 is working fine.Step 1 - Create or edit a BP release templateStep 2 - Load that template in BP Capture >Sett...
Resolved! Blue Prism HUB will work without Force Encryption Enable in SQL?
Hi Team,We are going to implement Blue prism HUB 5.1 in our environment.We have crated the new Data base and a New Blue prism Connection for HUB.We are currently not using any SSL Encryption certificates for the BP Enterprise.Will Blue prism HUB work...
Receiving Junk data from HTTP/API Response
Hi All,We create orders through API requests / HTTP requests (using the POST Method) by sending JSON files and saving the API response in text format.But we are receiving junk data like below from the Response in HTTP and API. Below is the blue prism...
Resolved! Save Excel worksheet as csv
Newbee question so an example would be helpful...I'm looking for an action that saves a populated Excel worksheet as a .csv file.I expect I need to extend the existing VBO Excel SaveWorkbookAs action which uses the code:wb.SaveAs(filename)to somehow ...
IBM Personal Communicator : Unable to specify Environment variable as Session file Path
Hello all, I am trying to specify the session file path (.WS) for an IBM Personal Communicator (COM API) Emulator through an environment variable and when I use the Navigate/Launch stage with the data item in the path, I get the following error mess...
Excel Operations logic help
Hi,I am requesting a logic help here which I need to handle with Excel VBO in Blue Prism. It would be great, if someone can share ideas on how to implement it.Please check the attached Excel file Images, in which there are 2 sets of data with ID 111...
BP v7.0.1 upgrade and callback channel error
Hi, Community.Can anyone guide us regarding the following error message?We have upgraded the BP from 6.8.1 to 7.0.1 and ASCR setting remained as default with its port = 10000, hostname = localhost, callback = gRPC.We changed the port number to 20000 ...
Amazon AWS S3 Integration
Hello!Is there anyway to integrate Blue Prism with AWS S3 storage. It would be helpful to know if there is any inbuilt object to send files to S3 storage using Blue Prism.
Seeking Alternatives to Replace OLEDB in Automation
Hi Team,We are currently processing bulk data in our automations through OLEDB. However, as our internal team is ending support for OLEDB, we are seeking alternative methods to efficiently process bulk data. Could you please suggest some effective al...
