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