WikiWirral Online with you since 2003, fantastic.
Forum Statistics
Posts1,028,136
Topics75,598
Members13,514
Forums65
Posts in last 24hrs21
Most Online14,906
Nov 23rd, 2019
Who's Online Now
42 registered members (12 invisible), 1,425 guests, and198 spiders.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


Popular Topics(Views 7days)
160 Woody
79 toy
New General Forums
George Carlin
by BultacoAstro. 10th Sep 2020 9:00am
Our Earth
by granny. 8th Sep 2020 10:02am
The Moon Landing ?
by BultacoAstro. 29th Aug 2020 4:58pm
Harry McGuire.
by casper. 28th Aug 2020 11:15am
New Wirral History
Argyle Theatre
by mikeeb. 25th Sep 2020 1:23pm
St Andrews Square
by MIKE6570. 22nd Sep 2020 5:22pm
Stage-Coach Timetables in 1830's
by mikeeb. 19th Sep 2020 4:05pm
Birkenhead Trams 1876
by mikeeb. 17th Sep 2020 3:38pm
WHAT PUB
by derekdwc. 12th Sep 2020 12:51pm
Forum Tips
Photo Gallery Forums
Boaty McBoatface takes shape
The gathering storm: Mersey waterfront today
Topic Replies
LCT 7074
by diggingdeeper. 26th Sep 2020 12:03am
SEISS 3rd Grant
by diggingdeeper. 25th Sep 2020 10:06pm
Birkenhead Trams 1876
by yoller. 25th Sep 2020 9:59pm
Coronavirus
by casper. 25th Sep 2020 7:39pm
peugeot
by lincle. 25th Sep 2020 5:17pm
Video of Bidston Court dismantling - Hillbark
by mikeeb. 25th Sep 2020 5:06pm
History of Mersey Tunnels Video
by mikeeb. 25th Sep 2020 3:34pm
Argyle Theatre
by mikeeb. 25th Sep 2020 1:23pm
Our Earth
by mikeeb. 25th Sep 2020 11:32am
September
M T W T F S S
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30
Recent Posts : What's On ?
Previous Topic
Next Topic
Print Topic
Rate Topic
help creating an excel list of hd folders conten #674744
10th Mar 2012 3:34pm
10th Mar 2012 3:34pm
Joined: Oct 2008
Posts: 5,143
Birkenhead
derekdwc Online content OP
Forum Veteran
derekdwc  Online Content OP
Forum Veteran
Joined: Oct 2008
Posts: 5,143
Birkenhead
I would like to have a prog(pref free) that does something similar to search in XP where if I search for .jpeg for example it brings up a list of all the .jpegs on that hard drive. Is there any way of making the search list into an excel file

Last edited by derekdwc; 10th Mar 2012 3:35pm.
Google Ads
Re: help creating an excel list of hd folders conten [Re: derekdwc] #674748
10th Mar 2012 3:44pm
10th Mar 2012 3:44pm
Joined: Apr 2011
Posts: 1,337
1337
ex0__ Offline
Forum Addict
ex0__  Offline
Forum Addict
Joined: Apr 2011
Posts: 1,337
1337


-----
1337
Re: help creating an excel list of hd folders conten [Re: derekdwc] #674797
10th Mar 2012 6:18pm
10th Mar 2012 6:18pm
Joined: Dec 2008
Posts: 5,438
Birkenhead
BandyCoot Offline

Forum Veteran
BandyCoot  Offline

Forum Veteran
Joined: Dec 2008
Posts: 5,438
Birkenhead
used to work with msdos but I used to use wild card plus file extension i.e. *.jpg and it would find the lot. Don't know what part of the memory bank that was dragged up from.


Birkenhead........ God's own Room 101.
Re: help creating an excel list of hd folders conten [Re: derekdwc] #674930
11th Mar 2012 10:15am
11th Mar 2012 10:15am
Joined: Nov 2003
Posts: 21,231
Wirral
Mark Offline

Wiki Master
Mark  Offline

Wiki Master
Joined: Nov 2003
Posts: 21,231
Wirral
What do you want to do with the list ?
As that could be the decider and advice to follow.

think


My Avatar images are all from the Wirral Gallery.Click Me
Wow Wirral History is coming along Great! Wirral History

we get +200 new members a month now smile
Re: help creating an excel list of hd folders conten [Re: derekdwc] #674964
11th Mar 2012 12:34pm
11th Mar 2012 12:34pm
Joined: Oct 2008
Posts: 5,143
Birkenhead
derekdwc Online content OP
Forum Veteran
derekdwc  Online Content OP
Forum Veteran
Joined: Oct 2008
Posts: 5,143
Birkenhead
I've got several external hard drives and I've copied various folders of pics to them sometimes duplicating a folder at a later date which had extra pics in, so I want to make a list of them to find what drives they're on.
Also got lots of ebooks that are in folders by author but would like a list by book title but without having to open each foler,
At the moment I am using Treesize Pro and ACDC but that means going through one folder at a time.
Ideally I'd like to have excel lists of all my .mp3s, .jpegs and .mobi

Last edited by derekdwc; 11th Mar 2012 12:39pm.
Re: help creating an excel list of hd folders conten [Re: derekdwc] #674968
11th Mar 2012 12:37pm
11th Mar 2012 12:37pm
Joined: Nov 2003
Posts: 21,231
Wirral
Mark Offline

Wiki Master
Mark  Offline

Wiki Master
Joined: Nov 2003
Posts: 21,231
Wirral
What OS are you using? Operating System ?

As that can help too.

There are Duplicate Finding programs out there.


My Avatar images are all from the Wirral Gallery.Click Me
Wow Wirral History is coming along Great! Wirral History

we get +200 new members a month now smile
Re: help creating an excel list of hd folders conten [Re: derekdwc] #674970
11th Mar 2012 12:43pm
11th Mar 2012 12:43pm
Joined: Oct 2008
Posts: 5,143
Birkenhead
derekdwc Online content OP
Forum Veteran
derekdwc  Online Content OP
Forum Veteran
Joined: Oct 2008
Posts: 5,143
Birkenhead
XP on one pc and windows 7 on another.
Ideally what comes up in the start-search- jpeg in Xp would be great if I could make a list from that

Last edited by derekdwc; 11th Mar 2012 12:43pm.
Re: help creating an excel list of hd folders conten [Re: derekdwc] #674971
11th Mar 2012 12:50pm
11th Mar 2012 12:50pm
Joined: Oct 2008
Posts: 5,143
Birkenhead
derekdwc Online content OP
Forum Veteran
derekdwc  Online Content OP
Forum Veteran
Joined: Oct 2008
Posts: 5,143
Birkenhead
Progs that other members have used and can recommend would be helpful - free ones and even paid for ones

Re: help creating an excel list of hd folders conten [Re: ex0__] #674983
11th Mar 2012 1:17pm
11th Mar 2012 1:17pm
Joined: Apr 2011
Posts: 1,337
1337
ex0__ Offline
Forum Addict
ex0__  Offline
Forum Addict
Joined: Apr 2011
Posts: 1,337
1337


This does what you're asking for.

I don't know of anything that'll dump lists into excel because I don't know anyone that would use excel in that way. It'll drop the list into a .txt though and you could then try and find a way to shove that into excel .. though I don't know why you'd want to.

Excel isn't built for lists or meant to be used that way.


-----
1337
Re: help creating an excel list of hd folders conten [Re: derekdwc] #675087
11th Mar 2012 6:18pm
11th Mar 2012 6:18pm
Joined: Oct 2008
Posts: 5,143
Birkenhead
derekdwc Online content OP
Forum Veteran
derekdwc  Online Content OP
Forum Veteran
Joined: Oct 2008
Posts: 5,143
Birkenhead
thanks exO just tried that program, it's ok on windows 7 but will not load into XP.
I like to do various sorts A-Z and data advanced filters in excel. I'm not any good on databases

Re: help creating an excel list of hd folders conten [Re: derekdwc] #675197
11th Mar 2012 11:36pm
11th Mar 2012 11:36pm
Joined: Oct 2011
Posts: 68
wallasey
K
karlb Offline
Member
karlb  Offline
Member
K
Joined: Oct 2011
Posts: 68
wallasey
Originally Posted by derekdwc
thanks exO just tried that program, it's ok on windows 7 but will not load into XP.

Have you tried installing the visual basic runtimes at the bottom of the page.
Or you could try http://www.nirsoft.net/utils/search_my_files.html You can save the output as csv and import them into excel.

Re: help creating an excel list of hd folders conten [Re: derekdwc] #675233
12th Mar 2012 3:33am
12th Mar 2012 3:33am
Joined: Aug 2007
Posts: 2,989
Birkenhead, United Kingdom
S
SoundLad Offline

Are you SoNutz?
SoundLad  Offline

Are you SoNutz?
Forum Master
S
Joined: Aug 2007
Posts: 2,989
Birkenhead, United Kingdom
Theres also the old fasioned way of doing it.. Start / Run / Cmd in the Command Prompt screen do the following....

__________________________________________________________________
Microsoft Windows XP blah blah
Version Blah Blah

Type the Following
"C:\>"cd\(directory you want to list) or if you want to do the whole drive just type cd\

"C:\>"dir *.jpg /a/s >dump.txt

now this will search the whole drive for JPG files and dump them in the Dump.txt.. You can then open notepad and goto c:\dump.txt and it will have the list of the JPGS in there.. You could then copy and use paste special in the Excel Spreadsheet to add them all. To search the whole listing press CTLR - F and use the find function..

IF this is too technical for you then im sure someone on here will be of help but this is how i search for files if i cant be bothered using the stupid windows search.. as that DIR command above removes all attributes and search each individual directory and its great if you search for one file for example..

"C:\>" dir photo1.jpg /a/s >dump.txt
or you can leave the >dump.txt out and it'l show you on the CMD screen.. Anyway thats the way i would search for something.. Sorry if its too over the top.. Hope this helps..


Lee Mills

Re: help creating an excel list of hd folders conten [Re: derekdwc] #675405
12th Mar 2012 9:02pm
12th Mar 2012 9:02pm
Joined: Apr 2011
Posts: 22
Neston
N
NestonCYC Offline
Newbeee
NestonCYC  Offline
Newbeee
N
Joined: Apr 2011
Posts: 22
Neston
Hi,

You might want to take a quick look at Glary Utilities. It has a free version as well as a paid for Pro version. I'm using Pro but had a quick look at their website for the free version and the things I mention below appear to be in there.

Firstly, this is a tremendous free application for general PC maintenance - it has a simple one click option for undertaking automated routine clean up. I've been using it for years and it helps keeps my PC's free from clutter both at the file and registry level.

With respect to your specific q's - I think it will do what you want but not in the way you envisage - actually I think it might be better for you, if I understand your requirements correctly:

Under the Modules / Files and Folders section is a Disk Analysis option. This performs a summary analysis by folder, disk or multiple disks depending on the search / scan critieria you select. The explorer like interface then visualises:-

1) Which folders are using the most / least space
2) A summary of each file type i.e the total size of each file type by folder / disk(s). So for example on my PC right now I can see that I have 1.13GB of .jpg files on my C drive in 17234 files! (they are mostly small web design image / icons)
3) By clicking/selecting on the file type a sub pane in the interface lists all of those files (and if you initially analysed multiple disks then it would present them across all disks). I can order the files my name, location, size etc in the usual Explorer way.
4) The appllication also includes an inherent link to Windows Explorer - so once you have identified the appropriate file you can easily delete / rename etc. without having to leave the main app or rescan.

I think this might be better as with this approach you get "live" files update as you scan. With the excel approach everytime you added / delete files you would need to manually search and copy / paste update Excel. Then you would need to do what you wantedneeded to do in Excel and then manually locate the file you wanted to make changes on in Windows Explorer which is pretty tiresome and labour intensive.

Incidentally, another module included in the main utility app is a duplicate files finder. I've not had the need to play with that yet but that might also help you out.

Hope this makes sense, it's a bit difficult describing the functionality exactly but I suggest you give it a try as it's free, it is pretty simple and intuative to use and even if it doesn't solve the problem you mention (but I think it does, as I use it in a similar way to control my mp3 files), it's still a fantastic clean up utility.

Cheers,

Neston


Moderated by  Mark 

Random Wirral Images

Click to View Topic.
Newest Topics
SEISS 3rd Grant
by diggingdeeper. 25th Sep 2020 10:06pm
Argyle Theatre
by mikeeb. 25th Sep 2020 1:23pm
Woody
by lincle. 23rd Sep 2020 1:57pm
St Andrews Square
by MIKE6570. 22nd Sep 2020 5:22pm
Stage-Coach Timetables in 1830's
by mikeeb. 19th Sep 2020 4:05pm
For Sale & Free
peugeot
by lincle. 25th Sep 2020 5:17pm
toy
by sunnyside. 22nd Sep 2020 12:55pm
Wanted Bultaco Astro Or Pursang 360 Model 104
by BultacoAstro. 13th Sep 2020 10:39pm
Wooden Single Bed, Headboard, Mattress and Drawer
by rhoobarb2002. 12th Sep 2020 5:07pm
Vauxhall Alloy Wheels - Astra, Corsa, Zafira etc.
by j_demo. 12th Sep 2020 2:44pm
Member Spotlight
granny
granny
Wirral
Posts: 17,422
Joined: June 2011
Show All Member Profiles 
Newest Members
Mikey54, calltutors, RyanEvans, mange1827, Stephen_59
13514 Registered Users
Today's Birthdays
No Birthdays
New Wirral Info
Van carpet fitter
by Gibbo. 17th Sep 2020 9:16am
Tower road. Birkenhead and now Dock road
by keef666. 6th Sep 2020 1:53pm
Enjoy the street theatre!
by Excoriator. 5th Sep 2020 3:50pm
Laminate flooring
by casper. 4th Sep 2020 6:33pm
Road resurfacing 2020
by keef666. 20th Aug 2020 8:30am
News : New Topics
SEISS 3rd Grant
by diggingdeeper. 25th Sep 2020 10:06pm
Award for Corbyn ???
by granny. 27th Aug 2020 10:41pm
Casper Specials
by granny. 23rd Aug 2020 5:39pm
When Damascus Falls !
by granny. 13th Feb 2020 11:12pm
Coronavirus
by cools. 30th Jan 2020 5:38pm
New Enthusiast Forums
Woody
by lincle. 23rd Sep 2020 1:57pm
Dorothea Quarry Aug 2020
by KevinFinity. 18th Sep 2020 9:45pm
cat found,Wallasey
by doggod. 17th Sep 2020 8:55pm
Spring fitting required
by gerrymoore. 17th Sep 2020 9:20am
Customer Is Always Right
by BultacoAstro. 3rd Sep 2020 12:19pm
Popular Topics(Views 24hrs)
Wirral Sunrise Sunset
Sunrise Sat 7:06am
Sunset Sat 6:59pm
Local Time Sat 6:34am
Powered by UBB.threads™ PHP Forum Software 7.6.1.1