Multiple values for contact info fields

[dafeder]

How to export contact info fields that have multiple, labled values? These are the existing lables and their counts:

(
    [phone] => Array
        (
            [] => 2939
            [home] => 240
            [Fax] => 16
            [Phone] => 93
            [mobile] => 496
            [other] => 43
            [work] => 705
            [Mobile] => 3
            [work_fax] => 172
            [main] => 1
            [Work] => 63
            [home_fax] => 9
            [company_main] => 5
            [radio] => 1
            [COMPANY_MAIN] => 6
            [Other] => 2
        )

    [email] => Array
        (
            [Email] => 262
            [Work] => 3667
            [] => 539
            [other] => 308
            [work] => 12
            [Obsolete] => 1
            [home] => 9
        )

    [im] => Array
        (
            [] => 4011
            [aim] => 4
            [Skype] => 4
        )

)

[sheldonrampton]

I suggest collapsing the phone addresses into the following 4 or 5 columns:

• work
• mobile
• home
• fax

• other

  If a phone number is not categorizable as mobile, home or fax, you should assume it is a "work" number. You would only need to create the "other" column if there are cases where someone has multiple phone numbers that can't be placed elsewhere. For example, someone might have two "work" phone numbers.

For email addresses, I think the categories should be:

• work
• home
• other

As with phone numbers, "work" should be the default, and you would only need the "other" column if there is a case where someone has multiple email addresses that can't otherwise be classified.

For IM, use your best judgment. I don't know how many of the 4011 IM address are Skype handles or something else.

[dafeder]

Actually, there were only 8 real IM entries. I'm just going to skip the lables for them.