Comments (2)
@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:
- There is a table
chat_message_join
that maps a message's row ID to chat's row ID. If a message exists in themessages
table but is not inchat_message_join
, that means we cannot determine which chat it was associated with.- It cannot be fixed
- Those messages show up in
Orphaned.html
orOrphaned.txt
file in the export directory
- "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 thetotal_bytes
column in theattachments
table. I don't know why they are different, but the former is the actual storage taken up by iMessage attachments. - 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.
- "No path provided" means there was a row in the
- 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.
Related Issues (20)
- export to excel or other spreadsheet software would be cool
- Have u guys considered making a markdown exporter?
- Integrate Contacts framework HOT 1
- Estimated size 30GB, actual size 11GB. What's missing?
- json export HOT 1
- Add `destination_caller_id` to exported columns HOT 1
- Install on Monterey on M1 Macmini
- Install Issue
- Bug: Group chat message appearing in personal chat export HOT 6
- Significant performance issues when exporting messages HOT 1
- Estimated export size is incorrect
- "zsh: command not found: $" error HOT 4
- Support omitting of "(Read by xxxxx after xxx hours)" HOT 1
- Support ImageMagick v7
- [Feature Request] Automated Backup to S3
- Dec 31, 2000 4:00:00 PM listed as date for some messages HOT 6
- Legacy shared location messages (prior to iOS 17) are displayed incorrectly HOT 1
- iOS 18 and macOS Sequoia Support
- Support new Tapbacks
- Support Text Effects
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from imessage-exporter.