Teri E. Flack, M.A. (Public History), M.B.A., began her family history quest over 50 years ago when she asked her paternal grandmother to tell her everything she knew about the Flacks and Fenleys. Alt...
I am scanning in a collection of items. What I am really looking for is how to describe and cite the collections in my care.
KP
Karen Paffendorf
1 year ago
I was suprised that it was hard to get a list of files in a directory on Windows.\nGranted the File Explorer or whatever it is called now may not be suited.\nHowever you should be able to use the command line. I did a short search and found https://www.lifewire.com/dir-command-4050018 . It showed how to get options to the dir command with /? and that /B will hide all that other stuff.
TG
Theresa Giannetto
3 years ago
Help needed with the Karen Directory Printer, please!\nI loved the webinar... got all motivated to organize, but seem to be at a stumbling block with the Karen app!\n\nI file my stuff on OneDrive. It is not on my C: drive.\nFor the life of me, I cannot figure out how/why/where to get the Karen app to point to anything on OneDrive!\nIt will only show folders/files located on the actual hard drive, it appears. \n..\nAm I missing something obvious here? Looking forward to any help you all can provide! Thank you!
1Reply
EM
Emily Moore
3 years ago
Have you tried this approach: https://answers.microsoft.com/en-us/msoffice/forum/all/onedrive-file-listing/d65fbb37-1c6b-4d94-b9be-53a8a791cba5
DE
Diane Eppestine
3 years ago
This is brilliant. I love Excel. It's so versatile - I even created a quilt design on it once upon a time. I'm going to start my finding aid as soon as I post this.\n\nI've been able to split apart file path names, but this shouldn't be too much extra work when doing a folder at a time. Use Windows File Explorer and select the folder, subfolder, or file you want. The Copy Path (in the Clipboard section of the Home tab) can then be used. Paste that into an Excel worksheet. Go to the Excel Data tab, and under Data Tools section, select Text to Columns which brings up a Wizard. Choose Delimited as the Data Type in the first step, then choose Other as the delimiter & enter a backslash next to that. Each segment of the file path will end up in its own column. If needed, move all of the filenames to the same column, then copy/paste into the finding aid. Directions may be slightly different in other versions of Excel/similar products.\n\nHow do you keep track of which folders you've worked on?
PK
Peg Kenaga
4 years ago
This was fantastic! Thank you for your presentation. You answered several questions I have had about using Excel spreadsheets, and creating a "Finding Aid" will be so helpful.
1Reply
TF
Teri Flack
4 years ago
Thank you, Peg.
JW
John Ware
4 years ago
You can create a text file of a directory contents in Windows 10. It is old school, but it works. Open a Command Prompt, navigate to the directory of interest using the cd (Change Directory) command, then perform a dir (directory command) with the following syntax:\n dir *.* /b > FindingAide.txt \nThis will list all the files in that directory by name only and create the text file named FindingAide.txt in that directory. If you want you can add a /s after the /b and the command will then include all subdirectories under that directory. \n dir *.* /b /s > FindingAide.txt\nAlso if you enter dir /? The available syntax options for the dir command.
1Reply
TF
Teri Flack
4 years ago
Thanks for sharing this John. I'm not sure I ever would have figured that out. Teri
DH
Douglas Hill
4 years ago
Where do you put the title of the Book in the Citation column?
1Reply
TF
Teri Flack
4 years ago
I write a normal citation in that column, so I would put Author, Title (publication place: publisher, date), page number. When I name the file I put the title in single 'quotation' marks.
BS
Betty Swan
4 years ago
Teri\nThanks for much for the 'print' file list ap. I have missed this tool since DOS was retired.\nI always found it useful to retire/delete old and redundant data.
Comments (14)
I am scanning in a collection of items. What I am really looking for is how to describe and cite the collections in my care.
I was suprised that it was hard to get a list of files in a directory on Windows.\nGranted the File Explorer or whatever it is called now may not be suited.\nHowever you should be able to use the command line. I did a short search and found https://www.lifewire.com/dir-command-4050018 . It showed how to get options to the dir command with /? and that /B will hide all that other stuff.
Help needed with the Karen Directory Printer, please!\nI loved the webinar... got all motivated to organize, but seem to be at a stumbling block with the Karen app!\n\nI file my stuff on OneDrive. It is not on my C: drive.\nFor the life of me, I cannot figure out how/why/where to get the Karen app to point to anything on OneDrive!\nIt will only show folders/files located on the actual hard drive, it appears. \n..\nAm I missing something obvious here? Looking forward to any help you all can provide! Thank you!
Have you tried this approach: https://answers.microsoft.com/en-us/msoffice/forum/all/onedrive-file-listing/d65fbb37-1c6b-4d94-b9be-53a8a791cba5
This is brilliant. I love Excel. It's so versatile - I even created a quilt design on it once upon a time. I'm going to start my finding aid as soon as I post this.\n\nI've been able to split apart file path names, but this shouldn't be too much extra work when doing a folder at a time. Use Windows File Explorer and select the folder, subfolder, or file you want. The Copy Path (in the Clipboard section of the Home tab) can then be used. Paste that into an Excel worksheet. Go to the Excel Data tab, and under Data Tools section, select Text to Columns which brings up a Wizard. Choose Delimited as the Data Type in the first step, then choose Other as the delimiter & enter a backslash next to that. Each segment of the file path will end up in its own column. If needed, move all of the filenames to the same column, then copy/paste into the finding aid. Directions may be slightly different in other versions of Excel/similar products.\n\nHow do you keep track of which folders you've worked on?
This was fantastic! Thank you for your presentation. You answered several questions I have had about using Excel spreadsheets, and creating a "Finding Aid" will be so helpful.
Thank you, Peg.
You can create a text file of a directory contents in Windows 10. It is old school, but it works. Open a Command Prompt, navigate to the directory of interest using the cd (Change Directory) command, then perform a dir (directory command) with the following syntax:\n dir *.* /b > FindingAide.txt \nThis will list all the files in that directory by name only and create the text file named FindingAide.txt in that directory. If you want you can add a /s after the /b and the command will then include all subdirectories under that directory. \n dir *.* /b /s > FindingAide.txt\nAlso if you enter dir /? The available syntax options for the dir command.
Thanks for sharing this John. I'm not sure I ever would have figured that out. Teri
Where do you put the title of the Book in the Citation column?
I write a normal citation in that column, so I would put Author, Title (publication place: publisher, date), page number. When I name the file I put the title in single 'quotation' marks.
Teri\nThanks for much for the 'print' file list ap. I have missed this tool since DOS was retired.\nI always found it useful to retire/delete old and redundant data.