09-22-14, 22:44 #1Registered User
- Join Date
- Sep 2014
Unanswered: Extracting data from IPhone sms file
I am using SQ Lite to extract data from an SMS file from my Iphone. I have completed just about everything I need to extract the messages, date, phone number, actual text message,etc. However, I need to code in AM/PM values. In addition, when I go to execute the command, it does not go through all the records. There are over 7000 data lines.This is very important, it is for a child custody case happening tomorrow morning. I am NEW NEW NEW and self taught, so any help would be appreciated. In addition, when I export this to a CSV file, none of the SQL commands filter over to the CSV file. I need to print this for court tomorrow. My grandsons custody is at risk. Please Help!
SELECT datetime(date + 978307200, 'unixepoch','-4 hours'), handle.id, is_from_me, text FROM message JOIN handle ON message.handle_id=handle.ROWID ORDER BY 1;
09-23-14, 00:02 #2Resident Curmudgeon
Provided Answers: 54
- Join Date
- Feb 2004
- In front of the computer
Ask your attorney to request either a stay or a continuance to process this new evidence (depending on the state of the case and the jurisdiction or jurisdictions). This is not something that you want to trifle with, so get an expert witness and ask them to do the extraction for you.
-PatPIn theory, theory and practice are identical. In practice, theory and practice are unrelated.