Hi Jim,
I now downloaded the "binary zip" from db.apache.org/ddlutils/
which luckily installs A LOT easier than the source edition...
Also needed 2 extra JARs: mysql-connector-java-5.0.8-bin.jar
and postgresql-8.2-507.jdbc4.jar - for obvious reasons :-).
A few fixes were needed to get the ddl utils XML files made
from the MySQL contents okay to import into PostgreSQL...:
- somehow ddl-utils used the '0000-00-00 00:00:00' invalid
timestamp instead of proper "null" for mysql null times,
so I had to replace all those by '1980-01-01 00:00:00'
in the XML file generated by reading the mysql DB :-p.
- the mysql database contains an index on longdescs.thetext
but postgresql cannot make an index over strings > 2.6 kB
so I removed that index from the schema definition XML
before importing (create DB and fill in contents) the XML
files into postgresql again...
Now I could import the data into my favorite database :-)
dosbugzilla=> \d duplicates
Table "public.duplicates"
Column | Type | Modifiers
---------+---------+--------------------
dupe_of | integer | not null default 0
dupe | integer | not null default 0
Indexes:
"duplicates_pkey" PRIMARY KEY, btree (dupe)
...
Current database: f5109_bugs
mysql> describe duplicates;
+---------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| dupe_of | mediumint(9) | NO | | 0 | |
| dupe | mediumint(9) | NO | PRI | 0 | |
+---------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
...
Cute, isn't it? :-D
> The guys at SourceForge say there's isn't a way to do it (at least,
> not now) and they had the ticket open for over a year. SourceForge
> even pulled in a developer to look at the request. They said they'd
> need to write a program to do all the cross-mapping of the fields to
> put it in a format the Trackers would understand.
In other words, they would have to but do not have the time to
write a TOOL which reads the bugzilla database and spits out
entries for a sf tracker database. Which is what I would try
to do for them. I am sure there will be some file format which
is okay for them for reading database entries as long as they
are formatted okay for the tracker database already.
> import our data. I was willing to partially fund a developer
Where would you take that kind of $?
> reminded them how this would be a great selling point for SF to
> other projects that used bugzilla, to migrate to the SF Trackers.
Indeed. Yet for our own needs, I would already be happy if we
can migrate some core fields such as the component names and
bug descriptions and replies.
> By all means, open your own support request with them. The last guy
> I worked with on the ticket (who eventually informed me that their
> management decided that importing from bugzilla to the SF Trackers
> wasn't on their priority list) was Jacob Moorman. He should tell you
> the same thing.
I think it will be better to keep some continuity, so could
you get me in touch with that Jacob Moorman and remind him
that we can build on the previous dialogue about that ticket?
> In the meantime, I'm going to go through some of the still-open
> bugs to see if any of them can be closed...
Sure, always useful, but I am a bit careful with that. For example
I marked several kernel bugs as "fixed in svn", but will not close
them until Geraldo is done with the kernel changelog docwriting
so we can make a 2038 file release. We cannot expect people to do
SVN checkouts and compiles to get rid of their 1.0 bugs.
> I'm curious how many of those 85 still-open bugs are still valid
> after FreeDOS 1.0. :-)
Actually quite a few bugs are hard to verify, need special software
or hardware or a server and client to check if the bug still exists.
But indeed several of them are probably already fixed, just not
verified to be fixed. Some more can be fixed for 1.1 :-).
Eric
PS: XSLT and XML gods are of course welcome to try to write
a transformation of fields directly based on the XML files
made by ddl-utils, for example to some nice-to-import file
format for the SF people.
PPS: If all else fails, I could write a tool which reads the
SQL database and interacts with the web forms to push the
text content into trackers, but I would need help with that
to get started about how to "remote control" http/html forms.
As said earlier in this thread, our timestamps would get lost
then because the web dialog just fills in the real "now" time.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Freedos-devel mailing list
Freedos-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/freedos-devel
