Combining extensive business experience in various industries with advanced software development skills with the goal of designing fast &amp; scalable Robotic Process Automation solutions. We believe human work should be creative and inspiring.

Provide the path to the specific field in the input category. The activity will read the file and extract the name of all the sheets in the workbook even the hidden ones if they can be accessed. All the names will be returned in the output category in the Sheets field as an array of strings.This activity can be used in case a sheet with an unknown name and unknown index needs to be processed or if the name of a hidden sheet needs to be retrieved.

Retrieve the names of all the sheets in a workbook file

RPA Developer

This package contains three activities that work with a queue of objects that should replace using the Invoke Method activity in this case.<ul><li>Enqueue adds an item to the end of the queue.</li><li>Deqeueue removes and return the first item from the queue.</li><li>Peek returns the first item from the queue without removing it.</li></ul>A local queue is a good replacement for the queue from Orchestrator when not complex items are used in a process.For more details of how queue works check the <a href=https://docs.microsoft.com/en-us/dotnet/api/system.collections.queue?view=netframework-4.8 target=_blank>official documentation</a> from .Net.

Activities to work with In Memory Queue from System.Collections

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

 - These activities are straightforward and easy to use. Good job!
As a suggestion, it'd be useful to have one activity to create and initialize a queue with specified items (something like the Build DataTable activity). In addition, it could be a bit easier to have a way to specify the type of the items in the queues (like the For Each activity).


This component contains two activities:<ol><li>Normalize Selector - removes any characters that are not numbers or letters with * for a much more dynamic selector.</li><li>Replace Diacritics - normalizes a string by replacing diacritics with their equivalent without a glyph.</li></ol>Possible use cases:<ul><li>Comparing texts from 2 sources where texts can appear with or without glyphs.</li><li>Using a dynamic selector that contains special characters that might differ.</li></ul>

Normalize strings for better matching of texts

- These activities are useful when doing automations in multicultural environments or that target applications that are localized.
The Remove Diactrics works fine, but it seems that the Normalize Selector activity replaces each character by an asterisk, which creates problems if you copy and paste the selector string from an activity's Selector property, because it has characters like <, > and quotation marks.
 For example: 
"<html title='MSN | Hotmail, Notícias, Horóscopo, Famosos, Clima, Outlook' /><webctrl id='q' tag='INPUT' />" 
becomes "*html*title**MSN***Hotmail**Not*cias**Hor*scopo**Famosos**Clima**Outlook*****webctrl*id**q**tag**INPUT****".
So I'd like to suggest for the Normalize Selector activity to be fine tuned a bit more, to ignore characters that can happen in the selector structure (<, >, =, quotes, etc) and also to combine multiple asterisks that are together (*** is the same as * in selectors).

By using the provided application, anyone can transform any device with a SIM card in a powerful tool to send and receive messages.By providing the IP from your Gateway you can tell send a SMS or receive any number of messages from that device.

Send and receive SMS messages through your own device

Generation process for the permanent attestation document from the workplace that proves the need of commuting to the workplace and of the statement of own responsibility in the COVID-19 context, using personal data picked up from the given e-mail mailbox.

- All mail messages received on the given Outlook e-mail address are read, having the given keywords in the subject. These mail messages must have attached an .xlsx file which contains the personal data required for filling the documents. These files are downloaded locally, in a temporary folder.

- The received files are read and the attestations are created, which are then sent back to the requester. The data from these files is added in a centralizing file, in order to maintain a good visibility on the requesters for these documents.

- After sending all the attestations (which only happens once, when the request is received), the centralizer is read and all the information for all the requesters is read. For all the requesters, the corresponding statements are sent. These statements are sent on each process run, with the current date completed in the documents. 

Generation process of the travel permits required in the COVID-19 context, using personal data picked up from the given e-mail mailbox.

About Us

Get Workbook Sheets Names…

FutureWorkForce - Local Queue…

FutureWorkForce - Remove Special Characters…

FutureWorkForce - SMS Activities through Gateway…

FutureWorkForce - Automated Travel Permit (RO)…

Help

How To