4

I am trying to obtain the "Where from" extended file attribute which is located on the "get info" context-menu of a file in MacOS.

Example

When right-clicking on the file and displaying the info it shows the this metadata.

The highlighted part in the image below shows the information I want to obtain (the link of the website where the file was downloaded from).

'Where from' on MacOS file info

I want to use this Mac-specific function using Python. I thought of using OS tools but couldn't figure out any.

hc_dev
  • 8,389
  • 1
  • 26
  • 38
ome
  • 61
  • 6
  • 1
    This is stored in the kMDItemWhereFroms item in the file metadata, and can be shown using the `mdls` unix command. I don't know how to get to that from Python, but maybe this gives you some more keywords to search for. :) (Well, obviously you could always do `subprocess.run("mdls ...")` but that does not seem very elegant.) – Ture Pålsson Dec 22 '21 at 06:53
  • @TurePålsson, thanks for sharing the MetaData (MD) utils like [`mdls`](https://ss64.com/osx/mdls.html) to list the metadata attributes for a specified file. If you like, contribute your comment to my answer ️ – hc_dev Dec 22 '21 at 09:28

2 Answers2

6

TL;DR: Get the extended attribute like MacOS's "Where from" by e.g. pip-install pyxattr and use xattr.getxattr("file.pdf", "com.apple.metadata:kMDItemWhereFroms").

Extended Attributes on files

These extended file attributes like your "Where From" in MacOS (since 10.4) store metadata not interpreted by the filesystem. They exist for different operating systems.

using the command-line

You can also query them on the command-line with tools like:

exiftool -MDItemWhereFroms -MDItemTitle -MDItemAuthors -MDItemDownloadedDate /path/to/file

xattr -p -l -x /path/to/file

On MacOS many attributes are displayed in property-list format, thus use -x option to obtain hexadecimal output.

using Python

Ture Pålsson pointed out the missing link keywords. Such common and appropriate terms are helpful to search Python Package Index (PyPi):

Search PyPi by keywords: extend file attributes, meta data:

For example to list and get attributes use (adapted from pyxattr's official docs)

import xattr

xattr.listxattr("file.pdf")
# ['user.mime_type', 'com.apple.metadata:kMDItemWhereFroms']
xattr.getxattr("file.pdf", "user.mime_type")
# 'text/plain'
xattr.getxattr("file.pdf", "com.apple.metadata:kMDItemWhereFroms")
# ['https://example.com/downloads/file.pdf']

However you will have to convert the MacOS specific metadata which is stored in plist format, e.g. using plistlib.

File metadata on MacOS

Mac OS X 10.4 (Tiger) introduced Spotlight a system for extracting (or harvesting), storing, indexing, and querying metadata. It provides an integrated system-wide service for searching and indexing.

This metadata is stored as extended file attributes having keys prefixed with com.apple.metadata:. The "Where from" attribute for example has the key com.apple.metadata:kMDItemWhereFroms.

using Python

Use osxmetadata to use similar functionality like in MacOS's md* utils:

from osxmetadata import OSXMetaData

filename = 'file.pdf'
meta = OSXMetaData(filename)

# get and print "Where from" list, downloaded date, title
print(meta.wherefroms, meta.downloadeddate, meta.title)

See also

hc_dev
  • 8,389
  • 1
  • 26
  • 38
1

macOS stores metadata such as the "Where from" attribute under the key com.apple.metadata:kMDItemWhereFroms.

import xattr

value = xattr.getxattr("sublime_text_build_4121_mac.zip",'com.apple.metadata:kMDItemWhereFroms').decode("ISO-8859-1")

print(value)

'bplist00¢\x01\x02_\x10@https://download.sublimetext.com/sublime_text_build_4121_mac.zip_\x10\x1chttps://www.sublimetext.com/\x08\x0bN\x00\x00\x00\x00\x00\x00\x01\x01\x00\x00\x00\x00\x00\x00\x00\x03\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00m'

I had faced a similar problem long ago. We did not use Python to solve it.

hc_dev
  • 8,389
  • 1
  • 26
  • 38
Rajath Rao - Software Engineer
  • 1,107
  • 1
  • 12
  • 26