Welcome to the FogBugz Knowledge Exchange

Question

2

I'm currently running self-hosted FB 6, but due to changing circumstances, "on demand" for Startup/Student is what I'd like to switch to.

Can I get my existing data imported into the "free" version?

edited Nov 23 2010 at 15:13

Greg Saven♦
2,469●1●5●13

asked Dec 30 2009 at 23:47

Roddy
431●2●8

I added a plugin request that might address this kind of thing: fogbugz.stackexchange.com/questions/1158/… – db♦ Jan 21 2010 at 14:53

Rich Armstrong · Accepted Answer · 2009-12-30 23:50:09Z UTC

0

If it's in SQL Server, then the answer is "probably". If it's in any other DB, that would require developer time, so we can't offer that currently.

answered Dec 30 2009 at 23:50

Rich Armstrong♦♦
13k●11●29

	Thanks. It's MySQL at the moment :-( – Roddy Dec 30 2009 at 23:53
	Yeah, sorry, that clearly takes developer time. We'd have a hard time justifying it for a free account. – Rich Armstrong♦ Dec 31 2009 at 17:54

Tim · Answer 2 · 2010-01-21 04:06:55Z UTC

0

Given that there is an API for FB and you have the schema for the old one, this could be a fairly straightforward tool to build.

answered Jan 21 2010 at 4:06

Tim
254●2●9

James McLeod · Answer 3 · 2010-01-21 16:13:42Z UTC

I have done exactly what you are trying to do with PHP, using a MyODBC connection to retrieve data from the existing database and the FogBugz API (using HTTP POST requests) to insert the cases into FogBugz. I was able to create cases as if they had been opened on the date and by the person who opened really opened them using the API, and resolve them as they were resolved in "real life."

It's not a difficult problem, nor even particularly time-consuming. There are better languages to use than PHP, but I think anything that allows you to post requests will work (stay away from HTTP GET requests - you may run into problems with long bug descriptions!)

Can I get a bug database imported into the student/startup version?

3 Answers