The File Renamer Flow is used for bulk renaming documents by duplicating the document multiple times and appending the students name to the document. The File Renamer uses the format "{filenamehere}_{studentnamehere}.*" when renaming files.
STEP 1: Export an *.XLSX file from SEQTA containing the student list for 1 or more classes
- In SEQTA Go to Pastoral Care Workspace > Reporting
- From the list of reports search for Brigidine File Renamer
- From the Timetable Period list select the current timetable period if not already selected (If already selected it will appear in the Selected tab)
- From the Class Code list select the classes you would like to use to rename the file (you can select multiple classes per file renamed)
- Click Apply, ensuring to check the output matches what you expect from your above selections.
- From the top menu click Export and select XLSX
- Please rename the resulting XLSX file from the previous step to something appropriate as this may cause name conflicts if subsequent flows are ran with the same file name.
STEP 2: Edit the above *.XLSX file so the data is formatted as Table1
- Open the excel sheet exported from previous process. (Most likely in your downloaded folder).
- Ensure the top left cell is selected (A1).
- Select all the data by holding Ctrl + A
- Format the selected data into a table by holding Ctrl + T
- Accept the defaults ensuring the tick box My table has headers is ticked.
- Save.
STEP 3: Run the *.XLSX file through the "File Rename Flow" along with the file we need to rename
- Navigate to the flow (Need to access the flow from the email when the flow was shared, Jason is working on making a proper link)
- At the top click run and an options pane will slide in from the right.
- In the first box locate *.XLSX file with the student names.
- In the second box locate the file you want to rename.
- Run flow.
- You will receive an email once the flow has completed, this can take around 5 minutes depending on how many students are in the list.
- Once you receive the email you should be able to find the files in your OneDrive > File Renamer.
- Please wait for the flow to complete before doing another.
- You are free to delete the "XLSX Grave" folder as it is required by the flow to first dump the *.XLSX file into Ondrive before it is processed, so once processed we don't need it.
- The File Renamer folder itself can also be deleted after processing as this is created every time the flow is run if it doesn't exist.