cad5e2ef-d8ee-4363-bb56-37d46f2480d1.jpg

Solution Architect

a6e5b969-be6e-4756-ae53-47d3cb899ca4.png

The System Service Manager package contains the four activities listed below.

1.  **Get Service Status:** This activity can be used to check the status of a particular service. For example, if you are running an application that depends on a specific service, you can use this activity to check if the service is running or not. If the service is not running, you can take appropriate action to start the service.
2.  **Start Service:** This activity can be used to start a service that is not running. If you need to start a database service before running a script that relies on it, you can use this activity to start the service before running the script.
3.  **Stop Service:** This activity can be used to stop a service. If you are running an application that is causing issues, you can use this activity to stop the service associated with the application.
4.  **Restart Service:** This activity can be used to restart a service. For example, if you need to apply changes to a service configuration, you can use this activity to stop and start the service to apply the changes.

The mandatory input field ServiceName is expected as the service name in the general tab of service property sheet.

  

The workflow will be blocked until the service operation finishes or the amount of time specified in Timeout field is reached. If the Timeout field is not specified, the workflow will be blocked until the service operation finishes.

  

**Note:** Regarding the permission of the execution of activities 2,3,4, the User Access Control dialogue will be prompted, and you need to manually click the button or disable the the notification. Please refer to this link for more details: https://support.microsoft.com/en-gb/topic/guided-help-adjust-user-account-control-settings-in-windows-7-and-windows-8-605f891d-42c5-2b93-4b4b-e4c5d4d35f60.

These activities will help users identify the status of service, start or restart the service if necessary.

a44749f2-092f-4322-af4f-c53173a83a5e.png

The System Service Manager package contains the four activities listed below:

1.  **Get Service Status:** This activity can be used to check the status of a particular service. For example, if you are running an application that depends on a specific service, you can use this activity to check if the service is running or not. If the service is not running, you can take appropriate action to start the service.
2.  **Start Service:** This activity can be used to start a service that is not running. If you need to start a database service before running a script that relies on it, you can use this activity to start the service before running the script.
3.  **Stop Service:** This activity can be used to stop a service. If you are running an application that is causing issues, you can use this activity to stop the service associated with the application.
4.  **Restart Service:** This activity can be used to restart a service. For example, if you need to apply changes to a service configuration, you can use this activity to stop and start the service to apply the changes.

The mandatory input field ServiceName is expected as the service name in the general tab of service property sheet.

  

The workflow will be blocked until the service operation finishes or the amount of time specified in Timeout field is reached. If the Timeout field is not specified, the workflow will be blocked until the service operation finishes.

  

**Note:** Regarding the permission of the execution of activities 2,3,4, the User Access Control dialogue will be prompted, and you need to manually click the button or disable the the notification. Please refer to this link for more details: https://support.microsoft.com/en-gb/topic/guided-help-adjust-user-account-control-settings-in-windows-7-and-windows-8-605f891d-42c5-2b93-4b4b-e4c5d4d35f60.

These activities will help users identify the status of a service, start or restart the service if necessary.

It takes a project directory where all the XAML files are saved along with project.json as input.

It fetches the below details:

*   Project name from project.json
*   Introduction: Project description from project.json
*   Annotation of all the xaml files.
*   Arguments details of each xaml file → Direction, type and description
*   Project dependencies from project.json
*   Studio version used for development

As a good practice, the developer would need to add an annotation to each and every workflow and its arguments which will help them in creating TDD/DSD.

This package will help the developer to create the initial version of a Technical Design Document or Design Specification Document.

In spite of going through an UiAutomation (or any other approach) to Save Excel As any other available format, this activity can be leveraged to do the same with many inbuilt features.

  

Inbuilt features include all the file type conversions from a default Excel to the provided / compatible formats (please refer MSDN for Format compatibility), which are not included in the UI dropdown in the Excel application, rather expand its purview to the older formats which can be leveraged into your automation processes.

  

This activity helps you save Excel files (xls, xlsx, xlt, xltx, xlsb, xlsm, xltm, csv) into 32 other formats provided in the Activity UI dropdown.

This activity helps you save Excel files (xls, xlsx, xlt, xltx ,xlsb, xlsm, xltm, csv) into 32 other formats provided in the Activity UI dropdown.

8d91cc95-eba1-44dd-bdc9-aa7a168cbf78.png

In spite of going through an UiAutomation (or any other approach) to Save Excel As any other available format, this activity can be leveraged to do the same with many inbuilt features.

  

Inbuilt features include all the file type conversions from a default Excel to the provided / compatible formats (please refer MSDN for Format compatibility), which are not included in the UI dropdown in the Excel application, rather expand its purview to the older formats which can be leveraged into your automation processes.

  

This activity helps you save Excel files (xls, xlsx, xlt, xltx, xlsb, xlsm, xltm, csv) into 51 other formats provided in the Activity UI dropdown and more (legacy formats as well).

This activity helps you save Excel files (xls, xlsx, xlt, xltx ,xlsb, xlsm, xltm, csv) into 51 other formats provided in the Activity UI dropdown and more

Inspite of going through an UiAutomation (or any other approach) to Save Word As any other available format, this activity can be leveraged to do the same with many inbuilt features.

  

Inbuilt features include all the file type conversions from a default Word to the provided/compatible formats (please refer MSDN for Format compatibility) which are not included in the UI dropdown in the Word desktop application, rather which expands its purview to the older formats which can be leveraged into your automation processes.

  

This activity helps you save Word files (doc, docx, rft etc...) into 21 other formats given in the Activity UI dropdown.

This activity helps you save Word files (doc, docx, rft etc...) into 21 other formats given in the Activity UI dropdown

11404d46-ffac-4dd3-a14d-037e77c65db8.png

Instead of going through an UiAutomation (or any other approach) to Save Word As any other available format, this activity can be leveraged to do the same with many inbuilt features.

  

Inbuilt features include all the file type conversions from a default Word to the provided/compatible formats and more (please refer MSDN for Format compatibility) which are not included in the UI dropdown in the Word desktop application, rather which expands its purview to the older formats which can be leveraged into your automation processes.

  

This activity helps you save Word files (doc, docx, rft, etc.) into 21 other formats given in the Activity UI dropdown and more legacy formats as well.

This activity helps you save Word files (doc, docx, rtf, etc.) into 21 other formats given in the Activity UI dropdown.

An activity that reduces the effort of building string extraction logic using logical 'AND' and 'OR' operator giving the user/developer the freedom of conditional search/extraction of a result string from a Source string using two input strings. (Before and After). Has Presets/settings for seamless activity execution and features that can be turned on and off, without which the user would require to write additional code.

  

Helps in quick development of logic for citizen developers or use-cases that require extensive string operations helping in reduction of effort.

This custom activity extracts a string enclosed between two string inputs (Before and After string), with settings and features.

b1cbca05-df3c-4892-a1ee-2b3d01911d0c.png

An activity that reduces the effort of building string extraction logic using logical 'AND' and 'OR' operator giving the user/developer the freedom of conditional search/extraction of a result string from a Source string using two input strings. (Before and After). Has Presets/settings for seamless activity execution and features that can be turned on and off, without which the user would require to write additional code.

  

Helps in quick development of logic for citizen developers or use-cases that require extensive string operations helping in reduction of effort. String cleanup activity help in sanitization and quick development.

This custom activity extracts a string enclosed between two string inputs (Before and After string), with settings and features. An additional activity to cleanup strings is also available.

a1becd4c-bc39-4cc8-96aa-91e9f7b407a6.png

This workflow is a starter template for business users who prepare a lot of presentations and Bingo cards. It is a form based attended BOT which will prompt for user inputs and based on the preferences will generate grid based Bingo cards available to be copied as a HTML object to any office file (PPT, Word, Excel etc).

This simple skeletal workflow comprises an initial logic that can be built upon for advanced designs for generating Bingo Cards for presentations and PPTs.

d33735ca-1080-451e-8057-0cc09815058e.png

This custom activity is composed of 7 string matching algorithms and 1 helper tool activity (string clean-up).

  

The following activities are included in the package:

· Damerau Levenshtein

· Dice Coefficient

· Hamming Distance

· Jaccard Similarity

· Jaro Distance

· Jaro Winkler

· Levenshtein

· String Clean-up (helper activity tool)

This group of custom activities (String Algorithms) serve the purpose of reducing development time for the user intending to implement one or more string matching logics in their project.

This group of custom activities (String Matching Algorithms) serve the purpose of reducing development time for the user intending to implement one or more string matching logic in their project.

**The following activities are included in this package:**

Edit / Distance Based

- Levenshtein
- Damerau Levenshtein (Restricted and Default)
- Weighted Levenshtein
- Euclidean Distance
- Hamming Distance
- Jaro Distance
- Jaro Winkler
- Chapman Mean Length
- Chapman Length Deviation
- Minkowski Distance 

Sequence / Alignment Based

- Smith Waterman
- Smith Waterman Gotoh
- Smith Waterman Gotoh Windowed Affine
- Needleman–Wunsch
- Ratcliff Obershelp
- Longest Common Subsequence (LCS) 

Token Based

- Jaccard Index
- Sørensen–Dice coefficient
- Block Distance
- Tversky Index
- Overlap coefficient.
- Matching Coefficient
- Cosine Similarity
- Q-Grams
- N-Grams 

Hybrid Algorithms

- SIFT4
- Monge Elkan
- Generalized Compression Distance

Phonetic / Sound Based

- Soundex
- Metaphone
- Caverphone
- Double Metaphone
- Match Rating approach 

String Hash Based

- SimHash
- MinHash 

Fuzzy Wuzzy Algorithms

- Fuzzy Ratio

1. Simple Ratio
2. Partial Ratio
3. Token Sort Ratio
4. Token Set Ratio
5. Token Initialism Ratio
6. Weighted Ratio

- Fuzzy Token Abbreviation Ratio
- Fuzzy Process Extraction 

Extension Activities

- Get Similarities.
- Get Minimum Similarity.
- Get Minimum Similarities .
- Get Maximum Similarity.
- Get Maximum Similarities.
- Get Threshold Matches (Contains Fuzzy) 

String Cleanup Helpers

- String Cleanup
- HTML Tag Cleanup
- Unicode Normalize
- Clean Accent Characters
- Graphics Cleanup
- Whitespace Cleanup
- Other Cleanup

Note: Some dependencies used are bundled in the package, hence you do not need to install any other package except the current one downloaded from Marketplace.

1aa130ec-260d-44a7-b202-9491d95bdda7.png

This group of custom activities serves a certain purpose of controlling (increasing and decreasing) the volume of an audio output of any application or the  Master System Volume. It has the capacity to return the status of Mute, set to mute and unmute Master, as well as application volume.

Activities that can get, set, or change master (system) volume and application volume.

1de0e61f-1aa5-4e1c-92ca-d17d679ebd3b.png

This package is comprised of the following 9 activities:

  

· Adding a file to recent files

· Clearing all recent files from the explorer

· Clearing clipboard

· Clean up all temporary files

· Emptying recycle bin

· Flushing the DNS cache using DLL (unattended) and command line as well

· Getting the current user’s admin status

· Recycling a file or directory (Attended and unattended)

  

For more detailed information regarding each activity, please check the user guide attached in the Documentation section.

This group of custom activities (System Utility) serves the purpose of System Cleanup and other fringe features.

About me