42dddde1-2fbf-4ec8-985a-47a157730fd6.zip

c4d4b003-77ca-49aa-b3a9-0dc56c07dd29.png

The goal of this workflow is to save time and organize sub-folders by moving all the files into specific sub-folders. It gives users the ability to add their custom mapping for the folder and sub-folder mapping for the required file types, if not already present.

This workflow is designed to group all the files into different sub-folders based on file extension. The folder path is provided by the user. This workflow accepts the following 3 as input arguments:

in_strOptionByUser (String) - represents the value to decide whether the bot should start or not.

in_strUserInputFolderPath (String) - represents the folder path to organize the files.

in_strUserInput (String) – represents the selected option (out of 3 options – Create new folder, Add in existing folder, Keep in Miscellaneous), chosen by the user if file type is unknown.

This workflow can be used to organize any given folder. It comes pre-loaded with the essential file types and folder structure. The file types defined in the Config file are:

         o Excel_WordDoc – .doc, .docx, .csv, .xls, .xlsx

It asks the user to select the folder he/she wants to organize, loops all the files present in the folder, checks the extension of each file and moves it into the respective sub-folder. More file types can be pre-defined in the Config file just by adding a row and entering details ‘File extension’ and ‘Folder Name’. For any file which has an unknown extension, it gives the user the three options below:

Create a new folder – Creates new sub-folder with the name entered by the user and moves the file to that sub-folder. It also adds this file-folder mapping into the Config file and moves all the files with this extension to the required sub-folder.

Add in existing folder – Gives a drop-down option to the user and moves the file to the chosen subfolder. It also adds this file-folder mapping into the Config file and moves all the files with this extension to the required sub-folder.

Keep in miscellaneous – Moves the file to the miscellaneous sub-folder.

This workflow also gives the user the option to move all the personal files to the personal sub-folder if the ‘Username’ is filled in the Config file. The bot will check the name of each file and if it has ‘Username’ in it, it will create a sub-folder named “Username” and moves the file into it.

Attended bot to organize files in a folder into different sub-folders based on extension. For unknown file types, option appears to create a new, add in existing or move to Miscellaneous sub-folder.

e096009b-6dbf-44ed-98f9-24f354001d0a.png

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.

File and Folder Organizer

File and Folder Organizer

Read Sheets from .xls/.xlsx file…

Merge Content of Multiple Excel Files…