Question

In many cases, our FogBugz users have to send e-mails from FogBugz to a third party. Most of the time, they are sending to someone within our organization. It would be great if there was a way to pre-populate the auto-complete list for e-mail fields ("Correspondent", "To", "Cc" etc) with contacts from Exchange.

Basically, I want to import all Exchange users into FogBugz (not as users though) to be able to send them an e-mail just by entering their name.

Is it possible to import e-mails like this through the API or on a database level?

Thanks

Case FC1964424

Answer 1

Using the XML API is the easiest way to import contacts. There is a new XML API for FogBugz 7.3+

Adding Contacts

https://[fogbugz]/api.asp?token=[token]&cmd=addEmailAddress&sFullEmail=foo@bar.com

Removing Contacts

https://[fogbugz]/api.asp?token=[token]&cmd=deleteEmailAddress&sEmail=foo@bar.com

Finding Contacts

https://[fogbugz]/api.asp?token=[token]&cmd=findEmailAddress&sEmail=foo

Finding All Contacts

https://[fogbugz]/api.asp?token=[token]&cmd=findEmailAddress&sEmail=@

Note: There is a gotcha here. The addEmailAddress command takes a parameter named sFullEmail but the others take sEmail. We have case FC1964424 open to normalize this (and also to make sure the responses are more informative.

For more information see the full XML API documentation.

Answer 2

Surely there could be a more graceful way to do it? The other problem is when a correspondent changes their email address (company name change). It doesn't matter how many times I key in the new email when sending responses to a case, the auto-complete entry comes up with their original (and now obsolete) address.

It would be really nice to have a contact directory with maintenance features to add/delete/update/import contacts for all users to have access when sending emails. A pop-up address book for choosing the address would be nice too.

Thanks! Joe

Answer 3

If you just need a quick fix you may remove the adress from the bugemail table directly in the database.