Saving everyone time with file names

This video explains everything: https://www.youtube.com/watch?v=YyfSYwUy4z0

But I’ll explain it below as well using Golf 041 as an example:

Step 1:

1. Search in the bottom, left corner of the desktop (the Window’s icon): cmd and click on the Command Prompt App
2. Once that opens, make sure you go to the Q drive à C:\Users\kate220>Q: (obviously our usernames are going to be different)
3. Copy where the images are…like so Q:\>cd Q:\BrainHoney\Courses\GOLF-041\GOLF-041-D002\Media\Images
4. You should see Q:\BrainHoney\Courses\GOLF-041\GOLF-041-D002\Media\Images>
5. Then add >dir > test.txt to the end, like so Q:\BrainHoney\Courses\GOLF-041\GOLF-041-D002\Media\Images>dir > text.txt
6. Then go back to the actual folder with all of the images and you should be able to open a text box with that info

Step 2:

1. Go into your metadata sheet and go to open and click This PC and look for the txt file you just made
2. Click Open
3. Click Delimited on the Text Import Wizard box that pops up
4. Keep clicking next
5. With Delimiters, check the space option then click next
6. Click General then Finish
7. Now you should be able to copy and paste all of the file names into your metadata sheet!
8. NOTE: Add a sheet onto your metadata sheet and paste all of those names, THEN you can use those for both the file name AND source!
1. NOTE 2: Make sure you double check that everything copied over correctly! Espeically with numbered images and file names with spaces in them!
2. Use this equation for the name: ="ce_(coursename#)_"&MID(Sheet1!A1,1,100)
3. Use this equation for the source: ="Q:\BrainHoney\Courses\GOLF-041\GOLF-041-D002\Media\Images\"&MID(Sheet1!A1,1,100)
4. NOTE: Got these equations from Cesar.

Kate