Recent content by jonnymop5

Hey Fergupa, what is the correct version of java access bridge?

Hi Harish, I get completed items from queue and they come is as Item IDs. I then try to do a loop to put all of the information into a collection. I can get each individual item to update via the Get Item Data but then each loop it just overrides the previous entry into collection. Any idea...

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...

Hi GatesV, I just wanted to follow-up that I got the the shared email working. I had missed a start parameter. Those screenshots were great. Thanks!

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

It doesn't give me the option to add to those items. I'm missing something obvious I know but just can't get there.

I just wanted to bump this to see if anyone had any ideas. Thanks.

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...

Thanks so much for the screenshots. I'm wondering if I need to change a setting in Outlook. I'm getting a compile error on the behalf of part of the code. See screenshot.

Gates, I tried to put your code in and I it is not working. I tried the below (which I thought was the combo of what you were sending. Anyone know what I'm doing wrong.

Hi GatesV, I can read from shared boxes and move to subfolders (then move again to other subfolders). Shoot me exactly what you are looking for and I will help you out. Thanks, Jon