Search results

Hello, So I have the "Get Completed" items working and it pulls in 163 records. I then am trying to create a collection from each record so I can write it to excel. When I loop through the collection each time it overrides the previous record. It is trying to write to the Collection - TEST...

Hello, I'm trying to save excel as a PDF file. Does anyone have any easy guide to follow regarding this issue? I have tried to follow a few on youtube but running into issues. Any open to walking me through this one? Thanks, Jon

Hello, Has anyone experienced an excel collection pulling rows but all data being blank? I have two types of excel formats coming into my process. One template it reads everything with no problems, the other one it pulls 50 rows but all data is blank. I tried changing formatting but not...

Hello, Attempting to either pull from a huge excel file. Dumping that collection back into Excel takes a long time (20 minutes +). When attempting to use an execute against that excel file it seems to work but doesn't commit/save the changes. Does anyone know how to get the execute to update...

Hello, Earlier I put out a complex query that was not pulling any data. We have now simplified it and it is still not pulling data. It works fine in sql developer. Works fine each table in BP. Does anyone recognize anything that would cause BP not to "like" this query. Weird thing is it...

Hello, Has anyone used an OLEDB connection to work with a text file? If so have you done so on a Pipe Delimited File? Any insight appreciated. Jon

Hello, I have a complex sql that completes but does not bring any data back. I have pulled data from each view individually. I'm wondering if BP - does not like selects within selects within selects. This exact sql runs and pulls data in sql developer. Anyone have experience with this or any...

Hello, The Microsoft VBO Email - Save Email, saves the email as a .msg. If you change that code to a .pdf it saves but the file is corrupted. Has anyone been able to change the save email to save as a PDF? Thanks, Jon

Hello, I'm trying to set my MOAC prior to running my get collection sql. My execute sql MOAC statement is a simple: "exec apps.mo_global.set_policy_context('S',89)" Could not execute code stage because exception thrown by code stage: ORA-00900: invalid SQL statement I've included the above...

I'm trying to run Excel OLEDB. When I ran it using Microsoft.Jet.OLEDB.4.0 I got it to go through but it could not find the file. I was wondering if that is because I'm on a new version and the Jet appears to be for older excel. In trying to change to the ACE connection I am running into...

I'm trying to pull a simple --- Select * From [Excel Sheet] Could not execute code stage because exception thrown by code stage: Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. I'm trying to use various versions of the following statement. With [Excel...

Hello, I need to run a large sql statement. Currently the only way I know how to pass sql into the Data - OLEDB (Get Collection) is by using a data item with the sql statement. That limits you to a small number of characters (255?). Does anyone know how to pass a large sql statement into the...

Hello, I am writing a collection to excel and saving the workbook. I save with a file name of .CSV or .txt. I've tried both and the file ends up corrupted (still opens and looks fine). I'm trying to load file to a server and need a good file. Any ideas on how to save an excel file or a...

I have a collection and need to populate a spreadsheet with it. I need to populate columns - B, C, D, F, H, I, L Anyone know how to do this?

I'm trying to do a calculation based on the Sys Date in Oracle vs a start date for a period. Any suggestions on how to do this calculation or any suggestions on Oracle Dates/BluePrism?

I'm new to BluePrism and am struggling with how to use Date Calculations. I want to open an AP period the last day of the month but I want to make sure the period being opened is only the next month (in case the next month has already be opened). Can someone give me ideas on how this would...