CANNOT FIND XLSB & XLSM FILES (Happened in Alfred V4 & V5)

[WInd]

 

I have to search all file types, and only in this way can I see my xlsb and xlsm files. 

 

I have tried to add user defined file types already, but Alfred still could not file these types.

 

Edited July 15, 2022 by WInd

[Andrew]

@WInd Are the files found when you use the open keyword in Alfred?

 

The screenshot you post, this configuration expects UTIs, not file extensions. (Interestingly, I also see Parallels icon associations for these extensions in the screenshot, which is odd).

 

Try dragging one of the files which cannot be found into Alfred Preference's Help > Troubleshooting > File Search Troubleshooting, this will give more info on the UTI and if the file is in scope / indexed by macOS.

 

Thanks,

Andrew

[WInd]

Starting Diagnostics...

File: 'SAP SBS ACDOCA Universal Journal Entry Line Items 2022.xlsb'
 

-----------------------------------------------------------

Check file cache database...

✅ File cache integrity is ok

-----------------------------------------------------------

Check if file is readable...

✅ Alfred has permissions to read this file.

-----------------------------------------------------------

Check if volume '/' is indexed by macOS...

✅ Indexing is enabled on this drive

-----------------------------------------------------------

Check direct file metadata...

✅ Direct metadata available

Display Name: SAP SBS ACDOCA Universal Journal Entry Line Items 2022.xlsb
 Other Names: 
Content Type: com.microsoft.excel.sheet.binary.macroenabled
   Last Used: 

-----------------------------------------------------------

Check mdls file metadata...

✅ Metadata contains required items

_kMDItemDisplayNameWithExtensions      = "SAP SBS ACDOCA Universal Journal Entry Line Items 2022.xlsb"
kMDItemContentCreationDate             = 2022-06-20 上午9:44:03 +0000
kMDItemContentCreationDate_Ranking     = 2022-06-20 上午12:00:00 +0000
kMDItemContentModificationDate         = 2022-07-19 下午1:32:25 +0000
kMDItemContentModificationDate_Ranking = 2022-07-19 上午12:00:00 +0000
kMDItemContentType                     = "com.microsoft.excel.sheet.binary.macroenabled"
kMDItemContentTypeTree                 = (
    "com.microsoft.excel.sheet.binary.macroenabled",
    "public.data",
    "public.item"
)
kMDItemDateAdded                       = 2022-07-19 下午1:32:25 +0000
kMDItemDateAdded_Ranking               = 2022-07-19 上午12:00:00 +0000
kMDItemDisplayName                     = "SAP SBS ACDOCA Universal Journal Entry Line Items 2022.xlsb"
kMDItemDocumentIdentifier              = 23816
kMDItemFSContentChangeDate             = 2022-07-19 下午1:32:25 +0000
kMDItemFSCreationDate                  = 2022-06-20 上午9:44:03 +0000
kMDItemFSCreatorCode                   = ""
kMDItemFSFinderFlags                   = 0
kMDItemFSHasCustomIcon                 = (null)
kMDItemFSInvisible                     = 0
kMDItemFSIsExtensionHidden             = 0
kMDItemFSIsStationery                  = (null)
kMDItemFSLabel                         = 0
kMDItemFSName                          = "SAP SBS ACDOCA Universal Journal Entry Line Items 2022.xlsb"
kMDItemFSNodeCount                     = (null)
kMDItemFSOwnerGroupID                  = 20
kMDItemFSOwnerUserID                   = 501
kMDItemFSSize                          = 25000827
kMDItemFSTypeCode                      = ""
kMDItemInterestingDate_Ranking         = 2022-07-19 上午12:00:00 +0000
kMDItemKind                            = "Microsoft Excel Binary Workbook (.xlsb)"
kMDItemLogicalSize                     = 25000827
kMDItemPhysicalSize                    = 25001984

-----------------------------------------------------------

Check file is in search scope...

✅ File exists within Alfred's default search scope

-----------------------------------------------------------

✅ Troubleshooting passed
 

Edited July 20, 2022 by WInd

[WInd]

Hi Andrew

 

I guess the reason is the default searching type is Office Open XML, so that XLSB & XLSM files are excluded.

[Andrew]

Are the files being found with the open keyword?

 

Also, the dialog above is looking for the content type instead of extension, e.g. from your diagnostics:

kMDItemContentType = "com.microsoft.excel.sheet.binary.macroenabled"

 

So instead of xlsb, you want com.microsoft.excel.sheet.binary.macroenabled

 

This is also what should have been automatically populated when you drag a file into the custom types table.

[WInd]

Q1：Are the files being found with the open keyword?
in fact, I cannot find these files while typing the names of these files or xlsb/xlsm.

The test passed because I drag the files into troubleshooting windows.

 

Q2: So instead of xlsb, you want com.microsoft.excel.sheet.binary.macroenabled

in my opinion, these are same meaning.

 

 

[Andrew]

57 minutes ago, WInd said:

Q2: So instead of xlsb, you want com.microsoft.excel.sheet.binary.macroenabled

in my opinion, these are same meaning.

 

Alfred crafts metadata queries to the macOS Metadata index which requires the kMDItemContentType, so while you may think they are the same, macOS doesn't.

[WInd]

Many thanks, Andrew.

 

This problem has been solved.