WikiWirral Share a Little Learn a Lot about your Wirral
Forum Stats
12331 Members
65 Forums
73265 Topics
989431 Posts
45 posts in the last 24hrs
Max Online: 7831 @ 8th Apr 2013 4:18pm
Who's Online - Click Me
83 registered (alan128, 14 invisible), 1460 Guests and 293 Spiders online.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


(Views 7days)This Weeks Most Read
Bexit Offer for EU Citizens 646
Every little helps... 333
Deja Vu, Lightning Strikes Thrice, Groundhog Day 183
Benefit Cap is Unlawful 173
VW t4 fixed side window replacement 149
audi specialised pls 139
Ipad 1 charger 116
Kingsway Academy 55
Mainstream Media- Over and Out 34
Portraying A Nation-Germany 1919-1933 Tate Liverpool 17
New General Forums
Mainstream Media- Over and Out
by RUDEBOX
26th Jun 2017 9:35pm
Kingsway Academy
by lincle
26th Jun 2017 10:48am
Theresa May and the Holy Grail
by snowhite
25th Jun 2017 6:17pm
Deja Vu, Lightning Strikes Thrice, Groundhog Day
by fish5133
22nd Jun 2017 7:38pm
New Wirral History
Round the Wirral with a movie camera[1934]
by snowhite
16th Jun 2017 2:03pm
Bascule Bridge
by Sufee
6th Jun 2017 9:09pm
Pathe news short - merseytunnel 1934
by oldpm01
5th Jun 2017 1:57pm
1878 Post Office Directory of Cheshire query
by derekdwc
1st Jun 2017 10:41pm
Bakery at 275 Poulton Road 1925 onwards
by JAFitz
30th May 2017 8:59pm
Forum Tips
Photo Gallery Forums
wirral from Liverpool big wheel
New Brighton Big Wheel
Topic Replies
Every little helps...
by lollipop
12:02 AM
Apple TV box the 1gen
by Tait1969
05:20 PM
Sailing volunteers
by dogsbrain
10:19 AM
Bean to cup coffee machine
by monsterz4
08:56 AM
Ipad 1 charger
by _Ste_
26th Jun 2017 7:22pm
Portraying A Nation-Germany 1919-1933 Tate Liverpool
by paxvobiscum
26th Jun 2017 7:06pm
Shotwick - Old And New (Hall and Solar Farm)
by w10694
26th Jun 2017 6:42pm
Bexit Offer for EU Citizens
by cools
26th Jun 2017 11:27am
live webcam from africa, a must see
by cools
25th Jun 2017 9:01pm
June
M Tu W Th F Sa Su
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 ?
Portraying A Nation-Germany 1919-1933 Tate Liverpool
by paxvobiscum
26th Jun 2017 7:06pm
Shotwick - Old And New (Hall and Solar Farm)
by w10694
26th Jun 2017 6:42pm
Topic Options
Rate This Topic
#674744 - 10th Mar 2012 3:34pm help creating an excel list of hd folders conten
derekdwc Online   content


Forum Veteran

Registered: 13th Oct 2008
Posts: 5015
Loc: 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


Edited by derekdwc (10th Mar 2012 3:35pm)

Top
Google Ads
#674748 - 10th Mar 2012 3:44pm Re: help creating an excel list of hd folders conten [Re: derekdwc]
ex0__ Offline
Forum Addict

Registered: 25th Apr 2011
Posts: 1337
Loc: 1337
_________________________
-----
1337

Top
#674797 - 10th Mar 2012 6:18pm Re: help creating an excel list of hd folders conten [Re: derekdwc]
BandyCoot Offline

Forum Veteran

Registered: 7th Dec 2008
Posts: 5360
Loc: 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.

Top
#674930 - 11th Mar 2012 10:15am Re: help creating an excel list of hd folders conten [Re: derekdwc]
Mark Online   Reading


Wiki Master

Registered: 9th Nov 2003
Posts: 21062
Loc: 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

Top
#674964 - 11th Mar 2012 12:34pm Re: help creating an excel list of hd folders conten [Re: derekdwc]
derekdwc Online   content


Forum Veteran

Registered: 13th Oct 2008
Posts: 5015
Loc: 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


Edited by derekdwc (11th Mar 2012 12:39pm)

Top
#674968 - 11th Mar 2012 12:37pm Re: help creating an excel list of hd folders conten [Re: derekdwc]
Mark Online   Reading


Wiki Master

Registered: 9th Nov 2003
Posts: 21062
Loc: 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

Top
#674970 - 11th Mar 2012 12:43pm Re: help creating an excel list of hd folders conten [Re: derekdwc]
derekdwc Online   content


Forum Veteran

Registered: 13th Oct 2008
Posts: 5015
Loc: 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


Edited by derekdwc (11th Mar 2012 12:43pm)

Top
#674971 - 11th Mar 2012 12:50pm Re: help creating an excel list of hd folders conten [Re: derekdwc]
derekdwc Online   content


Forum Veteran

Registered: 13th Oct 2008
Posts: 5015
Loc: Birkenhead
Progs that other members have used and can recommend would be helpful - free ones and even paid for ones

Top
#674983 - 11th Mar 2012 1:17pm Re: help creating an excel list of hd folders conten [Re: ex0__]
ex0__ Offline
Forum Addict

Registered: 25th Apr 2011
Posts: 1337
Loc: 1337
Originally Posted By: ex0


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

Top
#675087 - 11th Mar 2012 6:18pm Re: help creating an excel list of hd folders conten [Re: derekdwc]
derekdwc Online   content


Forum Veteran

Registered: 13th Oct 2008
Posts: 5015
Loc: 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

Top
#675197 - 11th Mar 2012 11:36pm Re: help creating an excel list of hd folders conten [Re: derekdwc]
karlb Offline
Member

Registered: 6th Oct 2011
Posts: 63
Loc: 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.

Top
#675233 - 12th Mar 2012 3:33am Re: help creating an excel list of hd folders conten [Re: derekdwc]
SoundLad Offline

Are you SoNutz?
Forum Master

Registered: 22nd Aug 2007
Posts: 2987
Loc: 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


Top
#675405 - 12th Mar 2012 9:02pm Re: help creating an excel list of hd folders conten [Re: derekdwc]
NestonCYC Offline
Newbeee

Registered: 2nd Apr 2011
Posts: 19
Loc: 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

Top

Moderator:  Mark 
Random Wirral Images

Click to View Topic.
Newest Topics
Every little helps...
by palemoon
09:43 AM
Portraying A Nation-Germany 1919-1933 Tate Liverpool
by paxvobiscum
26th Jun 2017 7:06pm
audi specialised pls
by Little_B
25th Jun 2017 5:02pm
Bexit Offer for EU Citizens
by granny
23rd Jun 2017 9:38am
Benefit Cap is Unlawful
by RUDEBOX
22nd Jun 2017 7:37pm
For Sale & Free
Bean to cup coffee machine
by monsterz4
08:56 AM
Ipad 1 charger
by madrob
25th Jun 2017 2:34pm
Washing machine
by GingerTom
20th Jun 2017 9:05pm
22" full 1080p hd and freeview tv
by monsterz4
20th Jun 2017 8:50pm
Apple TV box the 1gen
by monsterz4
20th Jun 2017 8:48pm
Featured Member
Registered: 19th May 2017
Posts: 3
Newest Members
Charlotte, OwenChristian, DaveAitch, Fairz87, mikerobbo84
12331 Registered Users
Today's Birthdays
No Birthdays
New Wirral Info
Portraying A Nation-Germany 1919-1933 Tate Liverpool
by paxvobiscum
26th Jun 2017 7:06pm
Shotwick - Old And New (Hall and Solar Farm)
by diggingdeeper
15th Jun 2017 10:19pm
Sefton Park
by diggingdeeper
15th Jun 2017 10:02pm
Property Law
by lau2908
14th Jun 2017 8:04pm
van driver needed
by futurepast
14th Jun 2017 7:34pm
News : New Topics
Every little helps...
by palemoon
09:43 AM
Bexit Offer for EU Citizens
by granny
23rd Jun 2017 9:38am
Benefit Cap is Unlawful
by RUDEBOX
22nd Jun 2017 7:37pm
Finsbury Park mosque.
by Beethoven
19th Jun 2017 11:42am
Grenfell Tower - Notting Hill
by diggingdeeper
14th Jun 2017 5:13am
New Enthusiast Forums
audi specialised pls
by Little_B
25th Jun 2017 5:02pm
VW t4 fixed side window replacement
by Mike72
22nd Jun 2017 8:00am
Range Rover P38A Air Suspension Help Needed
by Martin1943
20th Jun 2017 8:06pm
Loving Home Wanted For 3 Cats.
by DavidC
20th Jun 2017 8:32am
Loving Home Wanted For 3 Cats.
by DavidC
18th Jun 2017 6:02pm
(Views 24hrs)Trending Newest Topics
Every little helps... 333
Wirral Sunrise Sunset
Sunrise Wed 4:46am
Sunset Wed 9:45pm
Local Time Wed 4:25am
WikiWirral Can . . . .