Part of my evaluation process is getting at least some of our data from our previous tracking system, Trac, into Mingle. Ideally, I'd be able to get everything, and I'm trying to figure out how much can be brought over.
The basic ticket-level properties from Trac I'm not very worried about. Concepts like summary, status, milestone, severity etc can be made to have basically a one-to-one correspondence with Mingle. The only question I can see so far is what do the Excel columns need to be called to map to the 'static' card properties of card type, title, and description?
My main worries are ticket cross references, attachments, and comments.
- Ticket cross references are the equivalent of card keywords, so some text in the description of one ticket references another by hyperlink, like the card keywords in Mingle. The keyword is #, so format wise there's no problem. The problem is that I don't see a way for the import to actually define what card ID the new cards will have.
- Attachments I'm not sure how to approach at all, so any ideas are appreciated. Trac stores attachments in the file system, and I don't know how Mingle does them at all.
- Comments are tough because Excel, or even CSV/tab-delimited in general, obviously doesn't have a good way of representing multiple elements in a 'column' per row. Most likely thing to me right now is figuring out how to concatenate all the comments from Trac and putting them in the description field for the insert, but that seems less than ideal.