-
 KDE-Apps.org Applications for the KDE-Desktop 
 GTK-Apps.org Applications using the GTK Toolkit 
 GnomeFiles.org Applications for GNOME 
 MeeGo-Central.org Applications for MeeGo 
 CLI-Apps.org Command Line Applications 
 Qt-Apps.org Free Qt Applications 
 Qt-Prop.org Proprietary Qt Applications 
 Maemo-Apps.org Applications for the Maemo Plattform 
 Java-Apps.org Free Java Applications 
 eyeOS-Apps.org Free eyeOS Applications 
 Wine-Apps.org Wine Applications 
 Server-Apps.org Server Applications 
 apps.ownCloud.com ownCloud Applications 
--
-
 KDE-Look.org Artwork for the KDE-Desktop 
 GNOME-Look.org Artwork for the GNOME-Desktop 
 Xfce-Look.org Artwork for the Xfce-Desktop 
 Box-Look.org Artwork for your Windowmanager 
 E17-Stuff.org Artwork for Enlightenment 
 Beryl-Themes.org Artwork for the Beryl Windowmanager 
 Compiz-Themes.org Artwork for the Compiz Windowmanager 
 EDE-Look.org Themes for your EDE Desktop 
--
-
 Debian-Art.org Stuff for Debian 
 Gentoo-Art.org Artwork for Gentoo Linux 
 SUSE-Art.org Artwork for openSUSE 
 Ubuntu-Art.org Artwork for Ubuntu 
 Kubuntu-Art.org Artwork for Kubuntu 
 LinuxMint-Art.org Artwork for Linux Mint 
 Arch-Stuff.org Art And Stuff for Arch Linux 
 Frugalware-Art.org Themes for Frugalware 
 Fedora-Art.org Artwork for Fedora Linux 
 Mandriva-Art.org Artwork for Mandriva Linux 
--
-
 KDE-Files.org Files for KDE Applications 
 OpenTemplate.org Documents for OpenOffice.org
 GIMPStuff.org Files for GIMP
 InkscapeStuff.org Files for Inkscape
 ScribusStuff.org Files for Scribus
 BlenderStuff.org Textures and Objects for Blender
 VLC-Addons.org Themes and Extensions for VLC
--
-
 KDE-Help.org Support for your KDE Desktop 
 GNOME-Help.org Support for your GNOME Desktop 
 Xfce-Help.org Support for your Xfce Desktop 
--
openDesktop.orgopenDesktop.org:   Applications   Artwork   Linux Distributions   Documents    LinuxDaily.com    Linux42.org    OpenSkillz.com   
 
Apps
News
Groups
Knowledge
Events
Forum
People
Jobs
Register
Login


Sponsoring


-
- Content .- Fans  . 

dataKiosk

   0.8 beta  

KDE Database

Score 79%
dataKiosk
zoom


dataKiosk
zoom


dataKiosk
zoom


Link:  Link
Minimum required   KDE 3.4.x
Downloads:  2444
Submitted:  Feb 9 2005
Updated:  Oct 3 2005

Description:

DataKiosk is a JuK-like database interface tool for generic SQL databases. What does that mean? Essentially, DataKiosk provides a series of wizards (anyone familiar with Qt Designer's database wizards will find them familiar) that allow you to build a custom Juk-like interface for any SQL database with a QtSQL driver.

A little bit about where it came from... DataKiosk began as a solution for a customer with a thorny problem. This customer had some nasty legacy databases with horrible user interfaces that all needed to be merged. While brainstorming for a solution, I came up with the idea of a Juk-like interface. After all, Juk and ITunes are wonderful interfaces for musical databases so, why not extend the concept to other generic SQL databases?

A Flash demo of the application can be found here: http://web.mit.edu/~treat/Public/datakiosk.html

DataKiosk now resides in kdesvn under the extragear/office module.

Announcing dataKiosk version 0.7

************************************************************************

What can this version of dataKiosk do?

dataKiosk 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 configurable 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 :)




Changelog:

******************************************************************************

Preliminary Changelog for dataKiosk 0.8:

* I've changed the project bar to reflect Qt4 designer's widget box layout ideas. This gives a better separation of Tables and Reports and it also allowed me to introduce ...

* Views. These are customizable composite forms that can be optionally populated by the edit forms of the table tree. Searching and scrolling and editing all work as normal from within them.

* Many, many, many, other features and bug fixes that I'll go into detail after the Beta.

For now, check out the demo application that is described here:

http://www.kdedevelopers.org/node/1510

Datakiosk, Baseball and Klik! Three good things that go good together...




LicenseGPL
Send to a friend
Subscribe
Other  Apps  from manyoso
Report inappropriate content



goto page:  1  2 

-
.

 kool!

 
 by ruurd on: Feb 9 2005
 
Score 50%

Wow. This is very nice.


Ruurd
Reply to this

-

 Surfin consumer data

 
 by athleston on: Feb 10 2005
 
Score 50%
athlestonathleston
-
Peter Lamm 0

United States of America, Minneapolis
Last visit Dec 21 2008
0 Friends
0 Groups

More info
Send a message
Add as friend
Other contents
--

Pretty cool -- I need to go look at Juk!

Curious... how did you prepare the flash movie, what linux tool lets you do that kind of thing?

It looks very promising to me, I like the novelty of this interface to a database. Thats the thing that is so great about the GPL/Open Source, there is so much creativity and innovation that is unleashed when people are FREE in the software sense

:)


Reply to this

-
.

 Long Way to Go

 
 by daflame on: Apr 10 2005
 
Score 50%
daflamedaflame
Alive Software Design
Home
-
Jeremy Jeremy Wilkins 0

Alive Software Design
Canada, Saskatoon
Last visit Mar 19 2007
0 Friends
0 Groups

More info
Send a message
Add as friend
Other contents
--

It seems to me this project has a long way to go yet to be functional. I'm more impressed with the Knoda project at least I can create nice functional controls and forms that have visual appeal, but it lacks the nice date controls this one has. I think I'll make that suggestion.


Some things were never meant to be made and others are a god-send.
Reply to this

-

 Re: Long Way to Go

 
 by manyoso on: Jun 14 2005
 
Score 50%

Please, let me know if you have any problems with the 0.7 release. It has *tons* of bug fixes and new features.


Reply to this

-
.

 Nice Program

 
 by Mucki on: Aug 1 2005
 
Score 50%

I like this program a lot, but I have 2 suggestions.
1: For fields of the type text a normal TextField is used which is rather nasty when the content is long and contains new lines. Ain't it possible to use a TextArea?
2: Since MySql doesn't support sub-queries it is not possible to use a saved search for the Data Report. Maybe supporting to manually edit the SQL query used for the report might help and make the report more flexible at the same time.

Keep up the good work!


Reply to this

-
.

 Thanks :)

 
 by manyoso on: Aug 3 2005
 
Score 50%

1: That will be available in the next version.

2: MySQL does support sub-queries in version 4.1+ which is pretty much required for MySQL with dataKiosk. And version 0.7 _does_ have the ability to manually edit the SQL query and Data Reports _can_ make use of a saved search. I do it all the time ;)

Not sure why you think they can not..


Reply to this

-

 QSQLITE driver

 
 by probono on: Oct 3 2005
 
Score 50%

Hi mayoso,

thanks for dataKiosk, the cmg launches on SUSE 10 but then gives the following error:

QSqlDatabase: QSQLITE driver not loaded
QSqlDatabase: available drivers: (blank)

Maybe the wrapper should explicitly start the database?

Greetings,
probono


Reply to this

-

 Re: QSQLITE driver

 
 by manyoso on: Oct 3 2005
 
Score 50%

It does explicitely start the database and I've included the sqlite driver... I wonder what is going on with my klik file. We're discussing it in #klik and your help would be appreciated ;)


Reply to this

-
.

 Good app

 
 by kwr2k on: Oct 4 2005
 
Score 50%

This looks good but where I can find HOWTO to use this with, say Oracle?

Thanks.


Reply to this

-

 Re: Good app

 
 by manyoso on: Oct 4 2005
 
Score 50%

No HOWTO exists, but I am going to be writing one for Oracle's OTN website by the end of the month. It is already lined up. I'll post about it here when it is ready...

For the most part though, you'd use this with ORACLE just like you would with any other SQL database server. Just choose the Qt Oracle driver...


Reply to this

goto page:  1  2 

Add commentBack






-
-
How do you like Plasma 5?
 The best KDE Desktop ever.
 Definitely a nice improvement.
 Not decided yet. Haven't tried it yet.
 I do not like some of the changes.
 KDE is taking the wrong way.
 I am still sticking with KDE 3.5.
 I have no opinion, but wanted to vote anyway.

resultmore
 
 
 Who we are
Contact
More about us
Frequently Asked Questions
Register
Twitter
Blog
Explore
Apps
Jobs
Knowledge
Events
People
Updates on identi.ca
Updates on Twitter
Facebook App
Content RSS   
Events RSS   

Participate
Groups
Forum
Add App
Public API
About KDE-Apps.org
Legal Notice
Spreadshirt Shop
CafePress Shop
Advertising
Sponsor us
Report Abuse
 

Copyright 2003-2014 KDE-Apps.org Team  
All rights reserved. KDE-Apps.org is not liable for any content or goods on this site.
All contributors are responsible for the lawfulness of their uploads.
KDE and K Desktop Environment are trademarks of KDE e.V.