Gotcha!
Here is the code. Hope it helps:
Collection_3 = Collection_1.Rows.OfType(Of DataRow)().Where(Function(a) Collection_1.Rows.OfType(Of DataRow)().[Select](Function(k) Convert.ToString(k("Street"))).Except(Collection_2.Rows.OfType(Of DataRow)().[Select](Function(k)...
If you are seeking unique values from both the collections combined, wouldn't merging the collection and removing duplicates based on "Street" column serve the purpose ?
Download the update version of Excel-VBO having Pivot related actions - https://digitalexchange.blueprism.com/dx/entry/9648/solution/ms-excel-vbo---extended
or you can create a custom code stage with something like this :
ws.PivotTables(PivotTableName).SourceData = "pivotsheet!A1:C15000"
Have you checked the folder permissions on the account that is currently logged in to Blueprism ?
Nevertheless, utilize command line to del the folder.
Use this command : rmdir /s/q "FULL_FOLDER_PATH"
You can use "Run process"/"Start process" action in one of the Utilities VBO
Its an old issue that was packaged with Blueprism.
Basically the shipped Excel VBO from an older version fetches the data from clipboard in Text format instead of UnicodeText
Open the Global code of Excel VBO and look for line :
Clipboard.GetDataObject().GetData(DataFormats.Text, True)
and...
There are a couple of issues with what you are trying to achieve:
1) The ExecWithTimeout is a private Function/Sub which is a part of Excel VBO and not Word VBO, which is why you are getting the error
2) newname = doc.name will generate an error in a lambda expression, as newname is the output...
You can have a skeleton stored in a Data Item, lets call it [Text_1].
Text_1 Initial value should be:
STOP
STOP
CMD
PREP
NO
Dynamic Value Here
END
TRANSTYPE,B,S
SETTDATE
GO
GO
Use a calculation stage to replace 'Dynamic Value Here' with whatever value is arriving dynamically...
The Message-ID that you see in the Outlook client under File>properties>Internet headers IS NOT THE SAME as the actual message Id of the respective email.
I hope you are using the message id returned from one of the action of the VBO.
If not, look for an action which outputs the message id of...
You can continue to use the Get Received Items (Basic) Action for this.
In the Subject Input, use "%Plant Name:%"
For Get Received Items (Advanced), try : "@SQL=urn:schemas:httpmail:subject LIKE '%Plant Name:%'"
Haven't tried it myself, but here are some references that maybe helpful :
https://stackoverflow.com/questions/12464616/oracle-bulk-updates-using-odp-net
https://www.rpaforum.net/threads/how-to-send-huge-data-in-sql-faster.10486/#post-20779
I couldn't understand the question clearly.
Refer this : https://www.rpaforum.net/threads/comparing-two-collections-and-and-saving-unique-values.14717/#post-31525
Is this something you are after ? If not, please post more screenshots to explain it better.
Here are 3 ways :
1) (Recommended) Create a custom code stage. SAP provides "Script Recording & Playback" feature which you can leverage to sneak peek the code and customize it to suit your needs.
2) Look for a keyboard shortcut and use that in send keys. Refer Here for Keyboard Shorcuts
3) Try...
Were you able to find a resolution to this ?
For such scenarios, where the dropdown selection isn't registered by the webpage, try to send "TAB" key after selecting the item.
Select Item(Browser mode) > Focus Dropdown(Win/AA/UIA) > Send Tab Key (GSK/GSKE)
It has worked for me in past with...
It does seem like environment specific problem, which are hard to troubleshoot.
Try to run the process on a different machine and evaluate.
If it still fails, reach out to BP support
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.