tag:help.lighthouseapp.com,2008-09-20:/discussions/tips-tricks/344-importing-from-fogbugzLighthouse: Discussion 2011-04-07T05:37:58Ztag:help.lighthouseapp.com,2008-09-20:Comment/22707912010-07-15T18:59:38Z2010-07-15T18:59:40ZImporting from FogBugz<div><p>I saw a few threads in which people wanted to migrate their
FogBugz cases into Lighthouse, and while there is no official
solution, there are ways to do it, albeit in a limited way.</p>
<p>Basically, you export your FogBugz data to CSV using BugzReport,
and then import using csv2lighthouse ruby script.</p>
<p>There is one major limitation: csv2lighthouse only imports three
fields (title, description, tags). I want to extend the script, but
I have to learn Ruby first, so I'll let you know how that one
goes.</p>
<p>A couple of notes -</p>
<p>1) When exporting from FogBugz to CSV using BugzReport, make
sure to only choose three columns of data. Choose wisely!<br>
I chose title, last comment, and area.</p>
<p>2) If you absolutely need a fourth column, like the case number,
export that column and concatenate with title or some other column
in Excel or similiar. As long as your CSV has three columns called
title, description, tags, you'll be set.</p>
<p>3) If you've never used Ruby before, or the terminal, don't
worry. It's not that hard. Just install Ruby, then install the
lighthouse API. Then download csv2lighthouse from GIThub and
execute. In case you've never used Ruby before, you need to send
the script the CSV document name as a command line argument like
this:</p>
<p>csv2lighthouse.rb fogbugz.csv</p>
<p>Only other drawback is BugzReport seems to truncate data kind of
randomly when you export. I'm not sure what's going on there, but
it's not a huge deal.</p>
<p>So yeah, that's what I did, and now Lighthouse has 5 years worth
of issue tracking from FogBugz!</p></div>Alec Slomantag:help.lighthouseapp.com,2008-09-20:Comment/22707912010-07-15T19:34:15Z2010-07-15T19:34:15ZImporting from FogBugz<div><p>Thanks for the writeup!</p>
<p>I saw this today as well <a href=
"http://github.com/billsinc/csv2lighthouse">http://github.com/billsinc/csv2lighthouse</a></p></div>Will Duncantag:help.lighthouseapp.com,2008-09-20:Comment/22707912010-07-15T20:51:33Z2010-07-15T20:51:38ZImporting from FogBugz<div><p>Cool! Thanks.</p></div>Alec Sloman