Re: Multiple E-mail Addresses

This is a cryptographically signed message in MIME format.

--===============7212902681854345628==
Content-Type: multipart/signed; boundary="=_h4pZeTscz0jmUBsetk0EBsm";
 protocol="application/pkcs7-signature"; micalg=sha-1

This is a cryptographically signed message in MIME format.

--=_h4pZeTscz0jmUBsetk0EBsm
Content-Type: text/plain; charset=utf-8; format=flowed; DelSp=Yes
MIME-Version: 1.0
Content-Disposition: inline


Quoting Ian Turner <[email protected]>:

> Hi Michael, thanks for the quick reply.
>
> On 03/12/2017 06:47 PM, Michael J Rubinsky wrote:
>> This answer depends on how you want them configured.
> Based on the seeming popularity of this question, is it worth setting up
> a reasonable default to allow multiple addresses per contact?
>> If you want a single field capable of handling multiple addresses, you
>> need to add the 'emails' attribute to the localsql configuration, and
>> add the object_emails (or whatever you want to call it) row to the
>> turba_objects table.
> If I go this path, what is the correct type to use for the new column?
> Just varchar?

If the varchar size limit is high enough on your RDBMS, then that  
would be fine. Otherwise, a 'text' type of field would work as well.

>> Be warned, however, that this type of field will cause problems with
>> protocols like ActiveSync.
> Are you sure? This patch
> <https://github.com/horde/horde/commit/3530a41e84bcd7616c5f52e14b1b8250a7c97184#diff-8c4998c505940c73677670c7bdb01b6a>
> seems specifically oriented to make the emails field work with ActiveSync.

Huh. Haven't noticed that before :)

It's a workaround that maps *up to* 3 email addresses into the  
ActiveSync Email fields. If you enter more than 3 email addresses into  
the Turba UI, and then edit the contact on an ActiveSync client, this  
will cause the loss of the email addresses over 3 when it syncs back  
to Horde.

For best ActiveSync compatibility of multiple email addresses, it's  
best to use the 'email', 'workEmail', and 'homeEmail' fields.

-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject

--=_h4pZeTscz0jmUBsetk0EBsm
Content-Type: application/pkcs7-signature; name=smime.p7s
Content-Description: S/MIME Signature
Content-Disposition: attachment; filename=smime.p7s
Content-Transfer-Encoding: base64

MIIMzgYJKoZIhvcNAQcCoIIMvzCCDLsCAQExDzANBglghkgBZQMEAgEFADALBgkqhkiG9w0BBwGg
ggn2MIIE9zCCA9+gAwIBAgIQK46fVBh0jdmXIk2MwSsKZjANBgkqhkiG9w0BAQsFADB1MQswCQYD
VQQGEwJJTDEWMBQGA1UEChMNU3RhcnRDb20gTHRkLjEpMCcGA1UECxMgU3RhcnRDb20gQ2VydGlm
aWNhdGlvbiBBdXRob3JpdHkxIzAhBgNVBAMTGlN0YXJ0Q29tIENsYXNzIDEgQ2xpZW50IENBMB4X
DTE2MDkwOTE4MTAxMFoXDTE3MDkwOTE4MTAxMFowQDEbMBkGA1UEAwwSbXJ1Ymluc2tAaG9yZGUu
b3JnMSEwHwYJKoZIhvcNAQkBFhJtcnViaW5za0Bob3JkZS5vcmcwggEiMA0GCSqGSIb3DQEBAQUA
A4IBDwAwggEKAoIBAQCnMMN6rJECDaGDgZyV/ESR1C7ubLy3gw598sL3x2Gsfi7mCh18Ptzk+kC9
6O2s4GPqaPMiaUalDIEBegVUt5mvDfdmwvBk+zqk6ZLKgV5Bb+BN5HQDvEYyLN+KTFge985rhiE7
7lyGuOkd806VhTdK1tem6Ifk5d0YlHid6DYk6cBRyVStAza7ILKU24F4kRTznQDOkMI+oJ9Cv+cn
sCi10L+YEn2Gmk4YhNW3I1nx0Uem8pvKCVzdubkRqiRJKqWMnzYw1mwpMIhSVIpt42cpD69+4YeL
hudNHOTE5wkqS2zdShndUR0CewYVRu6usM0OozOJcLUO5CoPzEHqWf1VAgMBAAGjggG2MIIBsjAO
BgNVHQ8BAf8EBAMCBLAwHQYDVR0lBBYwFAYIKwYBBQUHAwIGCCsGAQUFBwMEMAkGA1UdEwQCMAAw
HQYDVR0OBBYEFFGBjuiI1mnyyYS3VIMzaxbtfGl9MB8GA1UdIwQYMBaAFCSBbDlhvkkPj7cbRivJ
KLUnSG1oMG8GCCsGAQUFBwEBBGMwYTAkBggrBgEFBQcwAYYYaHR0cDovL29jc3Auc3RhcnRzc2wu
Y29tMDkGCCsGAQUFBzAChi1odHRwOi8vYWlhLnN0YXJ0c3NsLmNvbS9jZXJ0cy9zY2EuY2xpZW50
MS5jcnQwOAYDVR0fBDEwLzAtoCugKYYnaHR0cDovL2NybC5zdGFydHNzbC5jb20vc2NhLWNsaWVu
dDEuY3JsMB0GA1UdEQQWMBSBEm1ydWJpbnNrQGhvcmRlLm9yZzAjBgNVHRIEHDAahhhodHRwOi8v
d3d3LnN0YXJ0c3NsLmNvbS8wRwYDVR0gBEAwPjA8BgsrBgEEAYG1NwECBTAtMCsGCCsGAQUFBwIB
Fh9odHRwczovL3d3dy5zdGFydHNzbC5jb20vcG9saWN5MA0GCSqGSIb3DQEBCwUAA4IBAQC5Plcw
OvfWf/v/sUEU945Qr29Y4rBkHlgvB+aDkuZoZS6eqhT3RZwM4yjRbPKJ2mFnwGKUdNoRwxqxydJ/
sxJ/HjvnoPqLRd2rxRkB158BeUsdUc73qEGaLy7rgn0nx5kknQTWGde7E4Y9lMXWtT+Fl81RJwO2
kfsLZ/gHpzyR8ZV1QS8WSVZ27cvvW0EoAL2haBOxIRLhu4E2eMMJhri8BBtaw+zwHrDzgjEvamZ7
FMxMHYoWpPLugPLu9Jjp3eE9phTFtpKH1dd3dTc2o2oFqvodggsCi9ufHyLLo0Vjl/pqmvHXpobo
4f8Wl/sD7ZtXGFa+rWfigUPPpMxOHHIaMIIE9zCCA9+gAwIBAgIQK46fVBh0jdmXIk2MwSsKZjAN
BgkqhkiG9w0BAQsFADB1MQswCQYDVQQGEwJJTDEWMBQGA1UEChMNU3RhcnRDb20gTHRkLjEpMCcG
A1UECxMgU3RhcnRDb20gQ2VydGlmaWNhdGlvbiBBdXRob3JpdHkxIzAhBgNVBAMTGlN0YXJ0Q29t
IENsYXNzIDEgQ2xpZW50IENBMB4XDTE2MDkwOTE4MTAxMFoXDTE3MDkwOTE4MTAxMFowQDEbMBkG
A1UEAwwSbXJ1Ymluc2tAaG9yZGUub3JnMSEwHwYJKoZIhvcNAQkBFhJtcnViaW5za0Bob3JkZS5v
cmcwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQCnMMN6rJECDaGDgZyV/ESR1C7ubLy3
gw598sL3x2Gsfi7mCh18Ptzk+kC96O2s4GPqaPMiaUalDIEBegVUt5mvDfdmwvBk+zqk6ZLKgV5B
b+BN5HQDvEYyLN+KTFge985rhiE77lyGuOkd806VhTdK1tem6Ifk5d0YlHid6DYk6cBRyVStAza7
ILKU24F4kRTznQDOkMI+oJ9Cv+cnsCi10L+YEn2Gmk4YhNW3I1nx0Uem8pvKCVzdubkRqiRJKqWM
nzYw1mwpMIhSVIpt42cpD69+4YeLhudNHOTE5wkqS2zdShndUR0CewYVRu6usM0OozOJcLUO5CoP
zEHqWf1VAgMBAAGjggG2MIIBsjAOBgNVHQ8BAf8EBAMCBLAwHQYDVR0lBBYwFAYIKwYBBQUHAwIG
CCsGAQUFBwMEMAkGA1UdEwQCMAAwHQYDVR0OBBYEFFGBjuiI1mnyyYS3VIMzaxbtfGl9MB8GA1Ud
IwQYMBaAFCSBbDlhvkkPj7cbRivJKLUnSG1oMG8GCCsGAQUFBwEBBGMwYTAkBggrBgEFBQcwAYYY
aHR0cDovL29jc3Auc3RhcnRzc2wuY29tMDkGCCsGAQUFBzAChi1odHRwOi8vYWlhLnN0YXJ0c3Ns
LmNvbS9jZXJ0cy9zY2EuY2xpZW50MS5jcnQwOAYDVR0fBDEwLzAtoCugKYYnaHR0cDovL2NybC5z
dGFydHNzbC5jb20vc2NhLWNsaWVudDEuY3JsMB0GA1UdEQQWMBSBEm1ydWJpbnNrQGhvcmRlLm9y
ZzAjBgNVHRIEHDAahhhodHRwOi8vd3d3LnN0YXJ0c3NsLmNvbS8wRwYDVR0gBEAwPjA8BgsrBgEE
AYG1NwECBTAtMCsGCCsGAQUFBwIBFh9odHRwczovL3d3dy5zdGFydHNzbC5jb20vcG9saWN5MA0G
CSqGSIb3DQEBCwUAA4IBAQC5PlcwOvfWf/v/sUEU945Qr29Y4rBkHlgvB+aDkuZoZS6eqhT3RZwM
4yjRbPKJ2mFnwGKUdNoRwxqxydJ/sxJ/HjvnoPqLRd2rxRkB158BeUsdUc73qEGaLy7rgn0nx5kk
nQTWGde7E4Y9lMXWtT+Fl81RJwO2kfsLZ/gHpzyR8ZV1QS8WSVZ27cvvW0EoAL2haBOxIRLhu4E2
eMMJhri8BBtaw+zwHrDzgjEvamZ7FMxMHYoWpPLugPLu9Jjp3eE9phTFtpKH1dd3dTc2o2oFqvod
ggsCi9ufHyLLo0Vjl/pqmvHXpobo4f8Wl/sD7ZtXGFa+rWfigUPPpMxOHHIaMYICnDCCApgCAQEw
gYkwdTELMAkGA1UEBhMCSUwxFjAUBgNVBAoTDVN0YXJ0Q29tIEx0ZC4xKTAnBgNVBAsTIFN0YXJ0
Q29tIENlcnRpZmljYXRpb24gQXV0aG9yaXR5MSMwIQYDVQQDExpTdGFydENvbSBDbGFzcyAxIENs
aWVudCBDQQIQK46fVBh0jdmXIk2MwSsKZjANBglghkgBZQMEAgEFAKCB5DAYBgkqhkiG9w0BCQMx
CwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0xNzAzMTMwMTA1NDVaMC8GCSqGSIb3DQEJBDEi
BCCTh1FWm3BY1utvV57sRFpOHcMU5yUzSmbmQAYJz906KTB5BgkqhkiG9w0BCQ8xbDBqMAsGCWCG
SAFlAwQBKjALBglghkgBZQMEARYwCwYJYIZIAWUDBAECMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMC
AgIAgDANBggqhkiG9w0DAgIBQDAHBgUrDgMCBzANBggqhkiG9w0DAgIBKDANBgkqhkiG9w0BAQEF
AASCAQBa9R3vmox5qvuNcKqRL7fpmiA0Oe1yUbcLB+q39+p62A/qRMq+Cr+ilOGJHJfUL5QA6KSW
F4/NS23BhgmRICp1GochwnLE5hdCCZ4Gn7sJX6CTd1xDFc5vF8vAniHkYKAbYGV60HxPy3Y45SH5
SNCLvQGeIpwSXb8KYV3+lKxp7GbbNumzdaZ/0bt6UcS84zyo4YxXdmHafEaDTbHcvd9Mx6Wejyfl
5qjoj6vHXe5hdAZbb7CsWOpFlWB66yW7JHaK4M/Oqfl1OUzYiFVHVrMmA7XGTulTfDzj6wHNNNyq
s//rKYN8PpBGlnWHx+mTgva4PhjuOM1SAz0hnKPxp9P7
--=_h4pZeTscz0jmUBsetk0EBsm--


--===============7212902681854345628==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

-- 
turba mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: [email protected]
--===============7212902681854345628==--