Welcome to the FogBugz Knowledge Exchange

Question

2

We've written a tool that uses FogBugz' API to import our ~40 users, and then ~40,000 bugs. Mostly this works fine. But if I leave email notification on during this process, it floods all our users with literally thousands of emails. I tried turning email notification off until the import was done, but then when I turned it back on, it sent out all those thousands of emails. I don't want to send any emails about any of the changes made to bugs during the import process.

Is there API I'm overlooking that would allow me to turn off email notification for each user until the import is done? (Or would that just queue the emails like the current approach does?)

Is there another approach I'm not thinking of?

flag	asked Nov 12 2009 at 22:21 lizmarley 21●1

Even on FogBugz 6, I can't see how creating a new case would generate an email in the mailqueue table when the SMTP server was set to NONE. But you could always do a "DELETE FROM MailQueue" when you were done. – Michael Pryor♦ Nov 17 2009 at 0:23

Rich Armstrong · Answer 1 · 2009-11-18 23:00:28Z UTC

3

Set your SMTP server to NONE when you do the import and no emails will ever be created. (or you could turn off the email notification for all of the users and then turn it back on -- not as easy).

Another approach is to turn of the FogBugz Maintenance Service.

After your import, before switching the Maintenance Service back on, empty out the MailQueue table in the FogBugz database. That'll delete the mails before they're ever sent.

edited Nov 18 2009 at 23:00

Rich Armstrong♦♦

answered Nov 13 2009 at 4:36

Michael Pryor♦♦
3,192●2●10

	I forgot to mention we're still on FogBugz 6. We had the SMTP server set to NONE and it didn't send any emails -- until a couple days later when I turned on SMTP so that new changes would get emailed out. Then the stored emails were sent out as fast as the mail server could handle them. Is it safe to manually clear the queue somehow before turning on SMTP? – lizmarley Nov 16 2009 at 19:25
	This shouldn't operate any differently between 6 and 7. Unsent mails are stored in the MailQueue table. Edit applied above. – Rich Armstrong♦ Nov 18 2009 at 23:01

How can I import thousands of bugs via the API without sending out thousands of email notifications?

1 Answer