During setting up HoudahSpot to search DT databases, I stumbled upon the following:
The template provided by HoudahSpot seaches files with type com.devon-technologies.metadata.think3.
However, all the databases DT3 creates have a type of dyn.ah62d4qmuhk2x43dyqmu1g3mw
I tested this with DT 3.6.1 on two different Mac, running 10.13.6 and 10.14.6, respectively.
Is this something that should be investigated?
Thanks,
Stefan
No. HoudahSpot is looking for DEVONthink’s Spotlight metadata, not DEVONthink databases.
But then there is still something that is not working…
All the DT3 databases have “Create Spotlight Index” activated, yet HoudahSpot does not find anything.
From what I can see, no Spotlight metadata is generated for the databases.
How do you know it “does not find anything”?
If you want to find DT3 content in Houdaspot, do not search by Date or Kind; search instead by Content date or Content Kind.
I search for a term inside DT. It returns several results.
Then I search for the same term in HoudahSpot. It returns “No files found”.
I only search for text, no other attributes.
A text string.
On 10.13.6, this is not applicable. On 10.14.6, I have manually added DT3. This has no effect on the issue.
I also have clicked “Rebuild” for the spotlight index of the database in DT3 on both Macs. This also has no effect. All the files in ~/Library/Metadata/com.devon-technologies.think3/remain unchanged.
The issue is that DT does not create any spotlight index for my databases despite the settings. So HoudahSpot has no data to search.
Also, there is contradictory information about where DT3 stores Spotlight metadata:
I see data in ~/Library/Metadata/com.devon-technologies.think3
The DT 3.6.1 manual says the index files are created in ~/ Library/Cache/Metadata, which does not exist on both my Macs. There is a folder ~/ Library/Caches/Metadata which does not contain any Spotlight metadata files.
Spotlight metadata would be stored per-database here. What are you seeing in there?
In Terminal, run this command…
mdfind kMDItemContentType=="com.devon-technologies.metadata.think3"
What is found?
PS: ~/Library/Cache/Metadata is used for other caching. I will adjust the documentation.
The command returns 142 entries for what I suppose are two separate databases (guessing from the UUID-like folder names):
/Users/stefan/Library/Metadata/com.devon-technologies.think3/3991EDA2-5FA4-453C-BC4F-8385BCBF8C87/39/3AD8C633-F431-4174-BC17-FC7020F1BE0B.dt3
/Users/stefan/Library/Metadata/com.devon-technologies.think3/3991EDA2-5FA4-453C-BC4F-8385BCBF8C87/41/7C870695-5282-4781-A312-D91B7A4F3310.dt3
/Users/stefan/Library/Metadata/com.devon-technologies.think3/3991EDA2-5FA4-453C-BC4F-8385BCBF8C87/4d/B075B6A6-20E3-4A2A-9A8C-98045BC436DC.dt3
/Users/stefan/Library/Metadata/com.devon-technologies.think3/3991EDA2-5FA4-453C-BC4F-8385BCBF8C87/52/17CCA5DE-3D4F-4F90-BDDA-6DF26971B307.dt3
/Users/stefan/Library/Metadata/com.devon-technologies.think3/3991EDA2-5FA4-453C-BC4F-8385BCBF8C87/76/B0E38F79-E657-4097-97ED-E38743FC12AF.dt3
/Users/stefan/Library/Metadata/com.devon-technologies.think3/88805440-ACE8-4D02-B6B6-BCDFA102B20C/00/00F53F8C-A6A1-4675-A0BD-9C35992F5CB7.dt3
/Users/stefan/Library/Metadata/com.devon-technologies.think3/88805440-ACE8-4D02-B6B6-BCDFA102B20C/00/013FC376-8EAE-490B-88BB-48586C3B3C8F.dt3
/Users/stefan/Library/Metadata/com.devon-technologies.think3/88805440-ACE8-4D02-B6B6-BCDFA102B20C/00/020CACBC-5B8F-40E0-996B-4205462CB581.dt3
/Users/stefan/Library/Metadata/com.devon-technologies.think3/88805440-ACE8-4D02-B6B6-BCDFA102B20C/00/03129500-F16C-4322-9B00-20DED35C6209.dt3
...
However, I have more than two databases. I actively use ten different DT3 databases - one for each DDC main group - that each have the “Create Spotlight index” set.