Docs should say a word on how diagnostics are to be read about imessage-exporter HOT 2 OPEN

@ReagentX Thank you very much for your very clear answer, it helps a lot.

"No path provided" means there was a row in the attachments table that did not contain a path to a file

As a hint - or rather an educated guess - to future users, it seems one reason for these to show up is a bad synchronisation with iCloud (i.e. the picture exists on my phone but not on my PC, despite iCloud sync being on, maybe because it has been deleted on one device 🤷)

from imessage-exporter.

This is a good issue; I will write some documentation to explain this. In the interim I will answer your questions:

1. There is a table chat_message_join that maps a message's row ID to chat's row ID. If a message exists in the messages table but is not in chat_message_join, that means we cannot determine which chat it was associated with.
   • It cannot be fixed
   • Those messages show up in Orphaned.html or Orphaned.txt file in the export directory
2. "Data present on disk" represents the total size of the attachments listed in the attachments when following the listed path to the respective file. "Data referenced in table" is the sum of the total_bytes column in the attachments table. I don't know why they are different, but the former is the actual storage taken up by iMessage attachments.
3. There are two different types of missing files:
   • "No path provided" means there was a row in the attachments table that did not contain a path to a file
   • "No file located" means there was a path, but there was no file at the specified location.
4. Duplicated contacts occur when a single contact has multiple valid phone numbers or iMessage email addresses. The iMessage database stores handles as rows, and multiple rows can match to the same contact. The software does deduplication, but this diagnostic tells you how many contacts required that step.

from imessage-exporter.