prev
24th June 2005
by Derek Kite
next


This Week...
Digikam adds a Golden Mean photo editing plugin. Kalzium shows isotope and Scientist information. New home:/ ioslave. This ioslave displays all the home folders of the users being in the same group than you. Many bugfixes in KMail, khtml and Kopete.

It is always surprising to see how much work goes into KDE each week. This issue has highlighted commits from the last two weeks. There are a few interesting news items. Adam Treat has taken over maintainership of Kugar, a database reporting tool that has languished in KOffice for some time. Waldo Bastian started porting the D-BUS bindings to Qt 4. KDE 4 porting continues apace, with khtml working apart from some missing functionality.

Adam Treat announced dataKiosk version 0.7:
What can this version of dataKiosk do?

dataKiosk 0.7 can provide a fully featured data entry application tailored to any SQL database in a matter of minutes.

What does fully featured mean?
  1. dataKiosk uses Trolltech's Qt SQL module which includes drivers for: MySQL, PostgreSQL, Oracle, MS SQL Server,IBM DB2, ODBC, SQLite, Interbase, Sybase. a) A single project can even include multiple tables from multiple databases. b) dataKiosk 0.7 ships with identical sample projects for both MySQL and PostgresSQL.
  2. Integrated Basic, Advanced, and Custom SQL query modes that provide seamless searching capabilities no matter how simple or advanced your query needs. a) Basic searches are provided automatically via a search bar attached to every datatable. b) Advanced searches are available via a query editor allowing you to specify the tables/fields/operators and values you wish to narrow your search. c) Custom SQL searches allow you to edit the actual SQL used to generate your search. d) Advanced and Custom searches can be saved with the project to be used again and again. e) You can even specify parameters for your searches to be prompted from the user. Once the search is invoked a parameter prompt dialog pops up with data aware widgets asking the user for the appropriate parameters.
  3. An optimized data entry form that automatically configures it's data aware widgets to the fields in your table including relation combo editors with full text completion. a) The data entry form can keep track of the state of the current record with a colorbox that surrounds the form indicating whether unsaved modifications have been made to the current record. b) The data entry form has navigation buttons and configurable keyboard shortcuts for optimum speed of entry. c) The relation combo editor has the ability to constrain itself to other values in the editor form. Example: If I have two relation combo editors that point to the street and city values of an address, the street relation editor can be constrained to only display those streets from the current city value.
  4. Customizable data tables that automatically include a search bar at the top which converts human language queries into SQL and filters accordingly. a) Data tables can be configured to display or exclude fields with customized labels. b) The fields order and many other properties are also configurable. c) Foreign key fields can be marked as such and configured to display another field via the foreign key relationship.
  5. The ability to relate data tables with master-detail, one-to-one, one-to-many and many-to-many relationships. a) Selecting a particular record from the master table will constrain the child table's records and so on. b) The navigation buttons and keyboard shortcuts are sensitive to the relationships between fields. For instance if you are currently in a child datatable that has a one-to-one relationship with it's parent and you navigate to the next record, you will actually navigate to the parent's next record.
  6. Integrated data reports that can be configurably bound to any set of tables, fields and searches in your project. a) The reports can be associated with a particular saved search or they can be run against the current searches of their respective datatables. b) The reports can be configured to sort and group according to the set of fields associated with it. c) The reports automatically create a JOIN SQL statement combining the associated search (whether it is an Advanced search or a Custom SQL query) and the set of tables and fields associated with it. The resultant data set is then used to generate an XML file and fed to Kugar. d) The reports can even display virtual fields. (See Below.)
  7. Ability to specify the default sorting and grouping of your tables and reports. See above.
  8. Virtual Fields can be added to any data table (and accordingly to any data report) and configured to calculate a user specified equation. Every field in every table can be used as a variable in the virtual field along with constant variables like: current date, current time, a constant string or a constant number.
  9. Clipboard manager modeled after the clipboard manager found in MS Excel or Access. NOTE: This is not clippy! It provides a clipboard stack that does not steal focus from the underlying editor form. You can use this to copy disparate data into your editor form with tab navigation.
  10. In short, INSERT/SELECT/DELETE and create a user friendly interface to any SQL database with a Qt SQL driver to your hearts content :):)
HOMEPAGE: http://extragear.kde.org/apps/datakiosk/

Sebastian Trueg announced a new release of K3b:
The highly anticipated (at least by myself) new K3b release 0.12 is finally here. K3b 0.12 features a lot of cool stuff and also fixes many problems that drove user, especially unexperienced, crazy. As always my ChangeLog is not complete and way too large to state in full.

So here an overview of the highlights in K3b 0.12:
  • The main focus of this release is clearly the audio project. It has been nearly completely rewritten. As a result one can now merge tracks, split them, or add silence at the end or the beginning of a track. The unusual handling of pregaps in older K3b versions is gone. Now the unexperienced user does not need to bother with pregaps at all. K3b does not add two second pregaps by default anymore. It now works like it should: the pregap is simply a property of the track and if one wants to add a real gap there is always the silence source which can be added whereever needed.

    One can now drag audio tracks directly from the audio CD browser into an audio project. No need to rip the tracks manually. Just drag the tracks you want and let K3b do the rest: it will ask for the CDs when writing the project.

    Apart from that we have new audio decoding plugins for Musepack audio files, for all libsndfile and ffmpeg supported audio formats (this includes wma audio files), Musicbrainz support to fetch CD-Text information, as well as a Cddb plugin which queries the internet for a cddb entry for an audio project. The audio project now features a "prelisten" feature. Listen to your audio CD before writing it. This results in a funny sideeffect when used in combination with dragging audio tracks from the audio CD browser: K3b can be used as an audio CD player.

    It is now possible to convert a complete audio CD project into any audio format supported by K3b. The used dialog looks a lot like the audio CD ripping dialog and also features things like file naming patterns or cue file creation.

    Last but not least K3b 0.12 improves the "Auto" writing speed selection in audio CD projects. It will not as before simply use the highest supported writing speed but check for the highest possible writing speed. That means it will test how fast the tracks can be decoded when writing on-the-fly.
  • Another audio CD related feature is the support of audio cues. K3b is now able to import audio cue files into an audio project or simply write them to CD using the write CD image feature.
  • K3b now has proper session management. Don't bother with saving your projects when logging out of KDE. K3b will restart with the exact same open projects as before once you log on again.
  • Also very nice is the new automatic multisession handling in the data project. K3b automatically decides whether to start, continue, or close a multisession CD/DVD based on the size of the project and the remaining size on the media.
  • K3b 0.12 features simple HAL support: K3b will automatically add and remove devices that are turned on or off while K3b is running (for example usb or firewire devices).
K3b 0.12 also features some interesting changes for developers and artists:
  • K3b 0.12 has a highly improved_DCOP_interface which allows for some nice scripting.
  • I enhanced the theming support. All the pictures now have proper names and themes can be installed and removed from the GUI. There is also a little K3b Theme_Howto which should help a lot when creating a theme for K3b.
  • K3b is now split into three parts:
    1. libk3bdevice provides the low level device handling and detection including an implementation of big parts of the MMC standard.
    2. libk3b provides all one needs to write CDs and DVDs along with all the project types but without all the GUI elements used in k3b.
    3. k3b itself, the main application providing the user friendly GUI we all know.
This allows other applications to link against the k3b libs to simply include CD/DVD writing support. Be aware that the API of both libk3bdevice and libk3b are highly unstable and I cannot even guarantee source compatibility before the 1.0 release. So if you want to use one of the libs it might be best to link them statically for now.

Get it from http://www.k3b.org and have fun.

Joris Guisson announces a test version of KTorrent:
KTorrent is a simple BitTorrent client for KDE. I have just released version 1.0rc1. This is a testing release for the final 1.0 release. To get it go to it's homepage at http://lumumba.luc.ac.be/~joris/ktorrent/.

It's main features are:

Carsten Niehaus announced a release of Kalzium, a periodic table of elements (far more than that):
Osnabrück, June 16th 2005: The Kalzium-developers decided it is time for a preview of the good things to come in the next version of Kalzium. This release previews the standalone version planned for July 11 2005. It is almost finished feature wise but does not include translations and documentation as they are too much of an moving target. You can help make a better Kalzium if you test this version and give us feedback using bugs.kde.org or the usual channels.

Kalzium is an interactive application which shows you information about the periodic table of the elements. Kalzium can be used as an as an information database. Kalzium has already some nice features, however but there remains things to add. As Kalzium has been included in KDE 3.1+, we still work steadily to add in some new enhancements, while hopefully making it as fast and usefull as possible. You can help us by testing it or make proposals for new features or a better design.

This version of Kalzium requires KDE 3.3 or greater.

URL:
http://www.cip.biologie.uni-osnabrueck.de/niehaus/kalzium-3.5-preview1.tar.bz2

GnuPG-Signature:
http://www.cip.biologie.uni-osnabrueck.de/niehaus/kalzium-3.5-preview1.tar.bz2.sig


Statistics
Commits: 2247 by 198 developers, 55167 lines modified, 2528 new files.
Open Bugs: 8988
Open Wishes: 8402
Bugs Opened: 321 in the last 7 days.
Bugs Closed: 325 in the last 7 days.

Commit Summary
Module Commits
www
337
l10n
242
extragear
240
work
201
stable
174
kdepim
148
koffice
114
kdeedu
111
kdelibs
103
kdenonbeta
103
Lines Developer Commits
1458
Laurent Montel
83
477
David Faure
76
773
Nikolas Zimmermann
56
565
Adriaan de Groot
49
147
Rob Buis
48
726
Frans Englich
44
215
Anne-Marie Mahfouf
44
145
Carsten Niehaus
40
320
Pino Toscano
40
589
Sebastian Trueg
39

Internationalisation (i18n) Status
Language Percentage Complete
British English
99.95%
Swedish
99.78%
Estonian
96.37%
Portuguese
96.20%
Danish
95.87%
Italian
93.19%
French
92.28%
Serbian
91.89%
Dutch
91.03%
Spanish
91.02%

Bug Killers
Bug Killer Number Of Bugs Closed
Thiago Macieira
28
Maks Orlovich
17
Jason vanRijn Kasper
13
Inge Wallin
13
Stephan Binner
11
David Faure
11
Alexandre Pereira de Oliveira
10
Heinrich Wendel
10
Tommi Tervo
9
Lex Hider
9

Contents
  Bug Fixes Features Optimise Security Other
Accessibility [*]
Development Tools [*] [*] [*]
Educational [*] [*] [*]
Graphics [*] [*] [*] [*]
KDE-Base [*] [*] [*] [*]
KDE-PIM [*] [*] [*] [*]
Office [*] [*] [*] [*]
Konqueror [*] [*] [*] [*]
Multimedia [*] [*] [*] [*]
Networking Tools [*] [*] [*] [*]
User Interface [*] [*] [*] [*]
Utilities [*] [*] [*]
Games [*] [*]
Other

There are 269 selections this week.

Bug Fixes
Development Tools
Nicolas Goutte committed a change to /trunk/KDE/kdesdk/kbabel/common/libgettext/pofiles.ll:
Allow files with end lines having CR/LF or CR instead of LF only
BUG:105399
Diff Revision 425852

Nicolas Goutte committed a change to /trunk/KDE/kdesdk/kbabel/common/poinfo.cpp:
- Avoid to use QRegEXp for parsing the Gettext .po files' headers
- Make the check for the Content-Type less strict to allow not to have
a ; character before "charset"
BUG:106733
Diff Revision 425853

Oliver Kellogg committed a change to /trunk/KDE/kdesdk/umbrello/umbrello/umllistview.cpp:
Implement listview drag/drop of attributes and operations.
The update of the model objects is still missing.
CCBUG:107551
Diff Revision 426709

Oliver Kellogg committed changes in /trunk/KDE/kdesdk/umbrello:
moveObject(): Update the model objects after a drop.
BUG:107551
Diffs: 1, 2, 3 Revision 427031

Christian Loose committed changes in /trunk/KDE/kdesdk/cervisia:
Be nice and ask before overwriting existing files.
BUG: 107201
Diffs: 1, 2, 3, 4, 5 Revision 428324

Educational
Peter Hedlund committed changes in /trunk/KDE/kdeedu/kvoctrain/kvoctrain/query-dialogs:
Use word wrap in the example sentence query dialog.BUG:106443
Diffs: 1, 2 Revision 425567
View Visual Changes (to 1 file)

Peter Hedlund committed a change to /trunk/KDE/kdeedu/kwordquiz/src/kwordquizview.cpp:
Don't crash when running a Qt patched by SuSE. Thanks to Albert Astals Cid for tracking this one down.BUG:93803
Diff Revision 426340

Games
Heinrich Wendel committed changes in /trunk/KDE/kdegames:
fix the system wide highscore system to work again
fix bug #103116 (usernames are converted to lowercase)
fix bug #90680 (use the username from kemailsettings as default instead of anonymous)
BUG: 103116
BUG: 90680
BUG: 76437
BUG: 78341
Diffs: 1, 2, 3, 4, 5, 6, 7, 8, 9 Revision 427375

Graphics
Jörn Ahrens committed changes in /trunk/extragear/graphics/digikam/showfoto:
BUG: 107155
Diffs: 1, 2 Revision 424259

Matthias Kretz committed a change to /trunk/KDE/kdegraphics/kview/photobook/Makefile.am:
BUG: 106747
install ui.rc file into share/apps/kview
Diff Revision 424927

Aurélien Gâteau committed changes in /trunk/extragear/graphics/gwenview:
Sort external tools by name.
BUG: 107207
Diffs: 1, 2, 3, 4, 5 Revision 425091

Aurélien Gâteau committed a change to /trunk/extragear/graphics/gwenview/gvcore/thumbnailloadjob.cpp:
Check KFileMetaInfo.isValid() before calling KFileMetaInfo.item("Dimensions").
Please confirm it fixes the crash.
CCBUG: 107734
Diff Revision 427137

Wilfried Huss committed a change to /trunk/KDE/kdegraphics/kviewshell/kmultipage.cpp:
Fix bug 107322 for single page mode.
BUG:107322
Diff Revision 427140

Aurélien Gâteau committed changes in /trunk/extragear/graphics/gwenview:
- Reworked the JPEG error manager from jpegformattype a bit
- Moved it to imageutils/jpegerrormanager.h
- Use it in imageutils/jpegcontent.cpp
BUG: 107737
CCBUG: 102239
Diffs: 1, 2, 3, 4 Revision 427490

Albert Astals Cid committed changes in /trunk/KDE/kdegraphics/kpdf:
always notify the shell we've opened a new url, fixes comment #4 from 106771106771
Diffs: 1, 2 Revision 428028

KDE-Base
Nicolas Goutte committed a change to /trunk/KDE/kdebase/kioslave/man/man2html.cpp:
- Fix off-by-one error of the function strlimitcpy
(The qstr functions assumes that the lenght includes the NUL byte,
the function strlimitcpy excludes the NUL byte from the length)
- remove the function strmaxcpy
(which is basically qtrsncpy with another definition of the lenght)
(This fixes the macro .Nm, compared to old bug #32153)
Diff Revision 424267

David Faure committed a change to /trunk/KDE/kdebase/kdesktop/krootwm.cc:
Remove bookmarks from kdesktop RMB popup
BUG: 62791

Fix bug when using "Disable desktop menu", kwin, kicker etc. weren't told about it,
so some gray area remained on top of the desktop. Code taken from kcontrol/konq/desktopbehavior_impl.cpp
CCBUG: 46209
Diff Revision 424583

Daniel Teske committed changes in /trunk/KDE/kdelibs/kio/bookmarks:
Prepate kio/bookmarks for my keditbookmarks patch.

This change should be enough for
BUG: 88608
Diffs: 1, 2, 3 Revision 425765

Simone Gotti committed a change to /trunk/KDE/kdelibs/kio/misc/kntlm/kntlm.cpp:
Fix wrong auth string sent to server for NTLMv2, patch from Szombathelyi György.

CCBUG: 93454
Diff Revision 425781

Waldo Bastian committed a change to /trunk/KDE/kdelibs/kdecore/klockfile.cpp: