I finally got a chance to look further into this.
The contacts import process has a few problems when dealing with CSV files. CSV files can contain line breaks in a "Notes" field for a contact, but import() in /program/lib/Roundcube/rcube_csv2vcard.php splits on line breaks and then attempts to parse each line individually. As a result, the first contact that contains a line break in the CSV file causes subsequent contacts to be skipped up until the stars are in alignment several contacts further down the file.
Also, explode_quoted_string() in /program/lib/Roundcube/rcube_utils.php doesn't seem to do proper range checking for strings beginning with a ". It's making PHP complain, but doesn't seem to be affecting the output.
The "type=main" issue I originally reported is caused by an entry at the top of rcube_csv2vcard.php, where field mappings are listed. There are a couple of TODO notes next to several field mappings, including the second and third email addresses -- which is why the type setup is a little bit screwy.
So, CSV contacts import from Office 2010 is pretty icky. Most imported contacts should be expected to be missing data.
If you guys are cool with me chewing on this, then: I'll update to 0.9.3; double-check the field mappings against Office 2010 UI; re-factor the CSV file parsing code to treat it as a stream and maintain quoted state and all that good stuff; set up a Github account; do a pull request, which I've never done before, so probably I'll be a little bit of a pain in the ass.
Is that all copacetic?
- R.
[__ Robert Sheldon [__ No Problem [__ Information technology support and services [__ (530) 575-0278