Re: Proposed SMS design schema

>>One thing to consider is what if I have two phones(*) and read from
>>one and then write to another.  Is it the same message or a different
>>one?
> 
> That'd be 2 messages in this schema.

Yes.  We need to consider if we want this to be 2 seperate messages.
Think of syncing.  If the message becomes different when going from
phone A to phone B then syncing B back to A will cause it to be seen
as new on A and the message will keep respawning.

That is why I am suggesting we treat it as the same message, and
have it remain the same message even if dumped in Outlook or IMAP
and read back.

That then has implications on how we calculate the message id ...

>>I'd be inclined to sha only the timestamp and the message content 
>>itself
> 
> Are you suggesting sha.new(cotents+timestamp).hexdigest()? That'd 
> eliminate individual phones as unique factors, but that'd be ok with me.

The sha should reflect how unique we want the message id to be.

>>When placing the message into an IMAP folder
> 
> Is this one of the predefined folders, or are these folders being 
> generated dynamically based on the values of the 'folder' attribute?

I'd probably have some mapping that Inbox on the phone maps to a
particular IMAP folder, and Outbox on the phone maps to a different
IMAP folder.  Something similar would be appropriate for Outlook/
Evolution etc.

>>I would want to replace the numbers with email addresses (eg a from
>>of 1234567890 becomes a from of [email protected])
> 
> Where would it make sense to set this up (ie the "@vtext.com" part 
> to be appended to the numbers?)

As part of the export to IMAP (and probably Outlook), the exporter
should turn numbers into valid email addresses and do the reverse
on import.  The idea is that hitting 'reply' in your mail client
should just work.

>>Has anyone found a reliable automated way to work out what carrier
>>a number is on?  As a fallback we can use @teleflip.com 
> 
> Not sure what you meant by that, can you elaborate?

If we know that 212 555 1234 is VZW, then it can be converted to an
email address by appending @vtext.com.  There are similar rules
for the other carriers.  But we need to know the carrier first.

teleflip.com have a service where you can email [email protected]
and they forward to the correct carrier.  They fund things by appending
adverts to the messages, but it is better than nothing and they don't
truncate the messages.

Roger


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click