So I communicate with my clients now via text as I am sure many people do however, unlike my CRM with email, call logs, etc that is not really attached anywhere to my client record. I thought it might be appropriate to put some of that data into my CRM, but first of all I need to get it from my iphone backup. Here we go…
C:\Users\insert your user name here\AppData\Roaming\Apple Computer\MobileSync\Backup\alongNumberMatchesYourPhone\3d0d7e5fb2ce288813306e4d4636395e047a3d28fyi the above number will be the same
the 3d0d7e5fb2ce288813306e4d4636395e047a3d28 should be the actual file name on your computer although the directory name that looks similar will differ the file name should not. Well I copied the file over (duplicate) just in case. I downloaded MySql lite to use to access it, renamed my copied file to an extension .db3 so it would see it, then I exported it to excel, had to format the date using the following:
you should find the dates are represented as either the number of seconds since 1/1/2001, or 1/1/1970, depending on the position of the date field. In Excel, you could use a formula such as =1/1/2001 + A1/60/60/24 where A1 is your time data. (mine used 1/1/1970 iPhone 3gs)
then I imported it into MSAccess to do some reporting an (wa-la), can’t spell french words in Tejas, it is great as it shows, who, when and the message text. Good Stuff! Here is my link love thanks for the help!