|Problems? Is your data what you think it is?|
One to Many is Too Many?by Jamin (Novice)
|on Apr 22, 2008 at 19:57 UTC||Need Help??|
Jamin has asked for the
wisdom of the Perl Monks concerning the following question:
I need some Perl help from the masters. I haven't been able to figure this one out, or find anyone who can even begin to figure it out.
I have 2 data files I am trying to combine, and I have not been able to figure out a good way to do this that is not really sloppy. As an example, consider a Bug Tracking database.
One file contains the Bugs:
I need to have all the Comments for one bug, concatenated into one field.
The history is this: I am writing a script to manipulate data to migrate from our old bug tracker to our new one. The new one has only one field for ALL the comments. It also will only allow a one-time import, no updates. So I have to have ALL the comments from ONE bug, in a giant comments field.
I have started this off 100 times and it get's so stinkin' convoluted, I can't even read it anymore.
ANY ideas? At All? This MUST have come up somewhere before?