Obtaining metadata "Where from" of a file on Mac-CodePudding

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.

CodePudding user response：

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.

CodePudding user response：

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:

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

xattr (apparently MacOS also uses a Python-script)

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:

xattr
pyxattr
osxmetadata, requires Python 3.7 , MacOS only

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)

Example

Extended Attributes on files

using the command-line

using Python

File metadata on MacOS

using Python

See also