Intro
The local accountant, Hanne Hansen, needs help in sorting her files.What you will learn
- Primarily:
- Work with files
- Create a log
- Secondarily:
- For each loops
- Date and time
- Lists
Client Name
Accountant Hanne HansenProcess Name
FileSortingDescription
The one-person company Accountant Hanne Hansen spends valuable time sorting its files day after day. You'll create an RPA process that solves this:- Download the example files here
- Create an automation that sorts each file type (Notepad, Word, and Excel) into the right folder
- Beware: There is a zip-file, which you need to extract initially
- Create a log that includes:
- Time-stamp
- The number of sorted files
- How many individual files got sorted (Notepad, Word, and Excel)
- The full path of each file
Hints
- Unzipping
- Get files in folder
- Collect the file names in a list
- For each
- Iterates the list
- Unzip files
- Delete file(s)
- Get files in folder
- Sort files
- Get files in folder
- For each
- If else
- Move file(s)
- Logging
- Create three new lists (one for each file type)
- In each branch in the If, add an Add item to list
- Get current date and time
- Convert datetime to text
- Set variable (to be able to create a log in multiple lines)
- Write text to file
