Export Win Explorer folder columns/properties of each file

Talk about anything at all....

Export Win Explorer folder columns/properties of each file

Postby willincalif » Tue Aug 14, 2018 2:33 am

I'm looking to export the data that's in columns of specific windows folders in Windows 10.
Situation: I have hundreds of photos in windows folders. I'm trying to determine which camera settings work the best for specific pictures and situations. So I have about 18 columns of info such as focal length, exposure bias, F-stop, metering mode etc.
If I could export the data in to calc I could sort all kinds of ways, giving me valuable data for the future.

I did read some older posts about this but either the OO functions had changed or it wasn't the same situation.

Thank you for helping me figure this unique challenge out.

Will in Calif
Last edited by willincalif on Tue Aug 14, 2018 7:32 pm, edited 1 time in total.
William Burch
OpenOffice 4.1.5 on Windows 10
willincalif
 
Posts: 5
Joined: Tue Aug 14, 2018 2:04 am

Re: Export Win Explorer folder columns/properties of each fi

Postby robleyd » Tue Aug 14, 2018 2:52 am

I've moved your topic to General Discussion as your problem seems external to OpenOffice.

It sounds like you are dealing with EXIF data, but it isn't clear from your question as to whether you have already collected the data into a single location, or whether you only see individual data for each image.

Apparently this isn't a unique requirement, as there is apparently software available that will do a bulk export of EXIF data in CSV format, suitable for importing into a database or spreadsheet - perhaps this may be the solution you need? If so, this web search may point you in the right direction.
Cheers
David
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.5 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1970
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Export Win Explorer folder columns/properties of each fi

Postby MrProgrammer » Tue Aug 14, 2018 9:21 am

willincalif wrote:I have hundreds of photos in windows folders. I'm trying to determine which camera settings work the best for specific pictures and situations. So I have about 18 columns of info such as focal length, exposure bias, F-stop, metering mode etc.
Those using a Mac who want to work with this EXIF data can use /Applications/Utilities/Terminal.app and the mdls command to create a text file with the data, then use Insert → Sheet from file and the Text Import dialog. The find command can process multiple nested directories.

willincalif wrote:If I could export the data in to calc I could sort all kinds of ways, giving me valuable data for the future.
Once you've exported the data, we can help you with an import to Calc. Begin with the tutorial below. Until you have exported the data, this discussion is just about Windoze and you may have better success getting assistance with that task at a forum for that operating system.

[Tutorial] Text to Columns

$ mdls IMG_1703.JPG     # Sample export of EXIF data on a Mac 
kMDItemAcquisitionMake = "Canon"
kMDItemAcquisitionModel = "Canon PowerShot SD1300 IS"
kMDItemAperture = 2.96875
kMDItemBitsPerSample = 32
kMDItemColorSpace = "RGB"
kMDItemContentCreationDate = 2018-01-14 20:22:34 +0000
kMDItemContentModificationDate = 2018-01-14 20:22:34 +0000
kMDItemContentType = "public.jpeg"
kMDItemContentTypeTree = (
"public.jpeg",
"public.image",
"public.data",
"public.item",
"public.content"
)
kMDItemDateAdded = 2018-01-14 19:49:23 +0000
kMDItemDisplayName = "IMG_1703.JPG"
kMDItemEXIFVersion = "2.2.1"
kMDItemExposureMode = 0
kMDItemExposureTimeSeconds = 0.004
kMDItemFlashOnOff = 0
kMDItemFNumber = 2.8
kMDItemFocalLength = 5
kMDItemFSContentChangeDate = 2018-01-14 20:22:34 +0000
kMDItemFSCreationDate = 2018-01-14 20:22:34 +0000
kMDItemFSCreatorCode = ""
kMDItemFSFinderFlags = 0
kMDItemFSHasCustomIcon = (null)
kMDItemFSInvisible = 0
kMDItemFSIsExtensionHidden = 0
kMDItemFSIsStationery = (null)
kMDItemFSLabel = 0
kMDItemFSName = "IMG_1703.JPG"
kMDItemFSNodeCount = (null)
kMDItemFSOwnerGroupID = 20
kMDItemFSOwnerUserID = 502
kMDItemFSSize = 4847577
kMDItemFSTypeCode = ""
kMDItemHasAlphaChannel = 0
kMDItemISOSpeed = 125
kMDItemKind = "JPEG image"
kMDItemLastUsedDate = 2018-01-14 19:49:24 +0000
kMDItemLogicalSize = 4847577
kMDItemOrientation = 0
kMDItemPhysicalSize = 4849664
kMDItemPixelCount = 12000000
kMDItemPixelHeight = 3000
kMDItemPixelWidth = 4000
kMDItemProfileName = "sRGB IEC61966-2.1"
kMDItemRedEyeOnOff = 0
kMDItemResolutionHeightDPI = 180
kMDItemResolutionWidthDPI = 180
kMDItemUseCount = 1
kMDItemUsedDates = (
"2018-01-14 06:00:00 +0000"
)
kMDItemWhiteBalance = 0
Last edited by MrProgrammer on Fri Aug 17, 2018 3:45 am, edited 1 time in total.
Mr. Programmer
AOO 4.1.5 Build 9789 on Mac OS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Volunteer
 
Posts: 3472
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Export Win Explorer folder columns/properties of each fi

Postby willincalif » Tue Aug 14, 2018 8:24 pm

Thank you David for the quick response. I did the search you suggested and tried several options, including pixfiler, which is something else.
The data I want to add to calc looks like the attachment, which is a partial screenshot of a windows folder. I do not want to include the actual files.
I'm using windows 10.
Best,
Will
Attachments
the data looks like this.a.jpg
William Burch
OpenOffice 4.1.5 on Windows 10
willincalif
 
Posts: 5
Joined: Tue Aug 14, 2018 2:04 am

Re: Export Win Explorer folder columns/properties of each fi

Postby merlijn » Tue Aug 14, 2018 8:48 pm

If I understand correctly, you want what you see in the columns in windows explorer to be copied to calc? There is a tool called BulkFileChanger that you can use to do that.
http://www.nirsoft.net/utils/bulk_file_changer.html
OpenOffice 4.2.0 (test-build with dutch languagepack) on Windows 10 x64
merlijn
 
Posts: 11
Joined: Mon Jun 11, 2018 8:29 pm

Re: Export Win Explorer folder columns/properties of each fi

Postby robleyd » Wed Aug 15, 2018 2:14 am

Clearly that is EXIF type data, so I'm curious as to why the dedicated software that is around doesn't meet your needs?
Cheers
David
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.5 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1970
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Export Win Explorer folder columns/properties of each fi

Postby willincalif » Thu Aug 16, 2018 2:14 am

Hi again David.
The exif pilot software only has 5 columns of data to start. I add new columns but it just keeps "processing" the data endlessly and nothing changes.
Maybe I would need to buy the batch editor to get all the fields I want (and Support). It's $80 I'm not ready to spend.

Yes, it is exif data but truthfully I could use a tool that compiles folder columns data for other file types too (pdf, ods etc).

I realize that this is really a windows challenge and has little to do with OO. So I'm also seeing what the windows forums have to say.

Will
William Burch
OpenOffice 4.1.5 on Windows 10
willincalif
 
Posts: 5
Joined: Tue Aug 14, 2018 2:04 am

Re: To Merlijn Win Explorer folder columns/properties

Postby willincalif » Thu Aug 16, 2018 2:39 am

Thanks Merlijn. I wish it worked. It does not provide the columns/data I need. Just basic stuff and there is no way to add more columns of data. See attached screenshots. (not sure they will be big enough)
Attachments
Screenshot (138a).png
Screenshot (138a).png (13.58 KiB) Viewed 708 times
Screenshot (138).png
Screenshot (138).png (10.78 KiB) Viewed 708 times
William Burch
OpenOffice 4.1.5 on Windows 10
willincalif
 
Posts: 5
Joined: Tue Aug 14, 2018 2:04 am

Re: Export Win Explorer folder columns/properties of each fi

Postby robleyd » Thu Aug 16, 2018 8:26 am

Having too much time on my hands, I went to http://www.br-software.com/download.html, downloaded the Exif Extractor, installed it in a Windows 7 virtual machine and ran it against a selection of 20 images I prepared earlier :D First run I asked for all the data, second run I limited it to a subset. Results are attached.

Note: when you define the output file, use the full path to the file, otherwise the program will try and place the output in the location where the program was installed and you'll get some permission errors. I know this because...
Attachments
exifdata_part.csv
A subset of the available data
(5.04 KiB) Downloaded 42 times
exifdata_full.csv
All the available data
(5.04 KiB) Downloaded 41 times
Cheers
David
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.5 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1970
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Export Win Explorer folder columns/properties of each fi

Postby willincalif » Thu Aug 16, 2018 7:48 pm

Both data sets are exactly the same.
William Burch
OpenOffice 4.1.5 on Windows 10
willincalif
 
Posts: 5
Joined: Tue Aug 14, 2018 2:04 am

Re: Export Win Explorer folder columns/properties of each fi

Postby robleyd » Fri Aug 17, 2018 2:47 am

User error - by me :D Let me try again.

Looks to me as though there is software out there that may meet your needs; I don't think I can offer anything more useful - hopefully your other resources will help if you need more.
Attachments
test.csv
All the available data
(5.99 KiB) Downloaded 37 times
test2.csv
A subset of the available data
(5.04 KiB) Downloaded 41 times
Cheers
David
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.5 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1970
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: To Merlijn Win Explorer folder columns/properties

Postby merlijn » Sat Aug 18, 2018 4:42 pm

willincalif wrote:Thanks Merlijn. I wish it worked. It does not provide the columns/data I need. Just basic stuff and there is no way to add more columns of data. See attached screenshots. (not sure they will be big enough)


You're right, sorry about that answer, too quick, too easy.
I did find another tool though, there is one little catch: Windows users will hate it, because it's a command line thingy, so no nice graphical user interface and no drag and drop.

The next bit is not related to AOO/LO:

The tool is called ExifTool and you'll find it at https://sno.phy.queensu.ca/~phil/exiftool/
You might have to do some reading and trying yourself before you can get it to do what you want, (for further questions I suggest a forum like stackoverflow or a bit of googling).
I downloaded it, unzipped it and renamed the exe-file to exiftool.exe, (removing the (-k) part of the name)

At http://owl.phy.queensu.ca/~phil/exiftool/examples.html
I found a nice example, (item nr 7) that lists meta information in tab-delimited column form for all images in directory to an output text file named "out.txt":
exiftool -T -createdate -aperture -shutterspeed -iso C:\location_of_your_images > out.txt

That creates a tab delimited text file of which you can import the contents into a calc sheet and manipulate it in anyway you like.

Hope this works better for you.
OpenOffice 4.2.0 (test-build with dutch languagepack) on Windows 10 x64
merlijn
 
Posts: 11
Joined: Mon Jun 11, 2018 8:29 pm


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 6 guests