Looking good!



- Export and re-import of Turba data: OK

- Re-import of data exported in "Outlook format": OK

- Import of Outlook 2003 data: OK

- Import of exported data in Outlook 2003: Untested.

   German Outlook versions only recognize German field names.

- Import of Thunderbird data: OK

Pong. Queued for testing this week.

Ping?

Changes have been made in CVS for this ticket:

http://cvs.horde.org/diff.php/turba/docs/CHANGES?r1=1.438&r2=1.439&ty=u

I had to split out the outlook mappings, because they are also used 
for outlook exports. Please test what I committed.

Changes have been made in CVS for this ticket:

http://cvs.horde.org/diff.php/turba/data.php?r1=1.106&r2=1.107&ty=u

That's fine with me. Might be a good idea to add a comment about the 
suspected source of the values i.e. "Outlook 2000 or earlier" so we 
can kill them in Horde 5+ :-)

I'd like to keep the existing entries, they shouldn't hurt.

I was not able to verify them. Chuck commited the original mappings 
three years ago, maybe he still got the original email with the field 
output from Francois, if at all. Anyhow, those field names are from 
Outlook 2000 or earlier, so I think it's safe to remove them.
Bug :-) I was masochistic enough to map the fields and somehow 
overseen it during review of the patch.



Have a nice weekend,

Thomas

Any reason not to keep the old mappings? And if you remove them, why 
not the internetfreebusy entry?

Here's a patch for CVS HEAD to support Outlook 2003 properly.

While I was at it, I also added support for Entourage and Thunderbird :-)

Thunderbird fields:



First Name,Last Name,Display Name,Nickname,Primary Email,Secondary 
Email,Work Phone,Home Phone,Fax Number,Pager Number,Mobile Number,Home 
Address,Home Address 2,Home City,Home State,Home ZipCode,Home 
Country,Work Address,Work Address 2,Work City,Work State,Work 
ZipCode,Work Country,Job Title,Department,Organization,Web Page 1,Web 
Page 2,Birth Year,Birth Month,Birth Day,Custom 1,Custom 2,Custom 
3,Custom 4,Notes

Outlook 2003 fields supplied by Francois Marier:



"Title","First Name","Middle Name","Last 
Name","Suffix","Company","Department","Job Title","Business 
Street","Business Street 2","Business Street 3","Business 
City","Business State","Business Postal Code","Business Country","Home 
Street","Home Street 2","Home Street 3","Home City","Home State","Home 
Postal Code","Home Country","Other Street","Other Street 2","Other 
Street 3","Other City","Other State","Other Postal Code","Other 
Country","Assistant's Phone","Business Fax","Business Phone","Business 
Phone 2","Callback","Car Phone","Company Main Phone","Home Fax","Home 
Phone","Home Phone 2","ISDN","Mobile Phone","Other Fax","Other 
Phone","Pager","Primary Phone","Radio Phone","TTY/TDD 
Phone","Telex","Account","Anniversary","Assistant's Name","Billing 
Information","Birthday","Business Address PO 
Box","Categories","Children","Directory Server","E-mail 
Address","E-mail Type","E-mail Display Name","E-mail 2 
Address","E-mail 2 Type","E-mail 2 Display Name","E-mail 3 
Address","E-mail 3 Type","E-mail 3 Display Name","Gender","Government 
ID Number","Hobby","Home Address PO Box","Initials","Internet Free 
Busy","Keywords","Language","Location","Manager's 
Name","Mileage","Notes","Office Location","Organizational ID 
Number","Other Address PO 
Box","Priority","Private","Profession","Referred 
By","Sensitivity","Spouse","User 1","User 2","User 3","User 4","Web 
Page"

Ok, thanks. I wrote "Francois Marier" an email, he submitted the 
mappings in the first place.

No, I don't have an Entourage license.

A friend of mine sent me the English field names for Entourage, which 
is Outlook for MacOS:



"First Name        Last Name        Title        Suffix        Nickname        Company        Job 
Title        Dept        Work Street Address        Work City        Work State        Work Zip        Work 
Country/Region        Work URL        Home Street Address        Home City        Home State        Home 
Zip        Home Country/Region        Home URL        Home Phone 1        Home Phone 2        Home 
Fax        Work Phone 1        Work Phone 2        Work Fax        Pager        Mobile Phone        Main 
Phone        Assistant Phone        Custom Phone 1        Custom Phone 2        Custom Phone 
3        Custom Phone 4        Email Address 1        Email Address 2        Email Address 3        Email 
Address 4        Email Address 5        Email Address 6        Email Address 7        Email 
Address 8        Email Address 9        Email Address 10        Email Address 11        Email 
Address 12        Email Address 13        Instant Messaging 1        Instant Messaging 
2        Instant Messaging 3        Instant Messaging 4        Instant Messaging 5        Instant 
Messaging 6        Instant Messaging 7        Instant Messaging 8        Instant Messaging 
9        Instant Messaging 10        Instant Messaging 11        Instant Messaging 
12        Instant Messaging 13        Custom 1        Custom 2        Custom 3        Custom 4        Custom 
5        Custom 6        Custom 7        Custom 8        Custom date 1        Custom date 
2        Spouse        Birthday        Anniversary        Notes        Age        Astrology 
sign        Bloodtype        Furigana Company Name        Furigana First Name        Furigana Last 
Name        Furigana Spouse Name        Interests"



I especially like "Bloodtype" :o)



As you can see, some mappings would be needed. I really would like to 
see the CSV output of an American Outlook. Chuck, do you have access 
to that? ;-)

No, and I'm not sure if this mapping still holds for any recent 
Outlook versions anyway. It was added back at (probably) Office 97 or 
Office 2000 times.

Thanks, Jan. Was the given name field previoulsy called "first_name" in Turba?

Or do you have an English Outlook version to verify the given name 
field is not called "first_name" in Outlook's CSV export?

The point of the $outlook_mapping hash was, to automatically map 
fields exported from Outlook that have different names than Turba. I 
have removed all fields that already have the same names like our 
current default attributes.

Changes have been made in CVS for this ticket:

http://cvs.horde.org/diff.php/turba/data.php?r1=1.103&r2=1.104&ty=u

Yes. Just export some contacts via CSV. You'll find "firstname" in the 
headerline. If you re-import them, Turba is unable to automatically 
map "first_name" to the proper given name field. If you look at the 
standard attributes.php file,

it's spelled "firstname", right?
They map from the same name to the same name :-)

-> No mapping done.

So we're looking to map firstname to the turba field first_name, and 
it should be the opposite?



Why does the patch remove the pgp and smime mappings?

Yes, this is works fine.
Turba exports your given name as "firstname". If you reimport the same 
CSV file exported by Turba, the field "firstname" will currently be 
translated to "first_name" and Turba is then unable to automatically 
match the CSV field to the corresponding Turba key. As far as I was 
able to google it, Outlook uses the field "first_name" and some of the 
mapping array values should be flipped.

I'm not sure I understand the issue you are describing. When you 
import CSV data into Turba, regardless of the original source, you can 
select/edit the field mappings yourself?



Can you give a more descriptive use case for when this fails?

Hello together,



if you export contacts via CSV and re-import the same file again,

some fields won't get mapped automatically. This is due the wrong

assignment of Outlook field mapping, changing "firstname" into "first_name".



Attached patch fixes the issue. I also removed fields mapping to the 
same name.



I tried to have a look at Outlook's field names, unfortunately the 
field names are localized (sic!) so I only see German field names. 
Would be nice if someone with an English Outlook version could check 
the field names.



Cheers,

Thomas