switching from FM to Kexi?

I have just discover Kexi and tried to read as much as possible to get
an idea if what I would like to do is possible with it or not. This tool
sounds very promising. I am looking for re-building a databank I created
3 years ago with Filemaker. I am not a database guru, far from that,
this was the only one I did, and it was quite fun. But today I need to
do some major modifications on it to improve the ease of use and I am
looking for some alternatives to filemaker. One of my wishes would be to
offer an internet accessibility to the database and to integrate if
possible an image database to it with image preview.

    The today databank is filled / managed thanks to a series of form
which are connecting in a kind of workflow, related to a request number.
The forms are built with simple fields, combo box, grids and buttons
which oft launch a small script deciding the next form to display,
depending of a parameter (for example if Method = = freezer method, then
go to "freezer method" form , if Method = = chemical method, then go to
"chemical method" form). The database is used by several users from
different computer at the same time, so I need a server.

    Ideally, I would like to use MySQL or PostgreSQL as server databank
(sounds robust for image data), to have user filling / editing / reading
the form via the browser and also if this is possible to have the
possibility to integrated images to request number. And that all (quite
a lot I believe) hopefully in agreement with in the concept of Rapid
Database Application Development :-) .

    Would be that possible with Kexi 2.0 ?

    Thanks in advances for any advices,

Best,

Quentin
.


_______________________________________________
Kexi mailing list
Kexi@...
https://mail.kde.org/mailman/listinfo/kexi

[Jaroslaw Staniek-2]

2009/4/22 derobill@... <derobill@...>:

> I have just discover Kexi and tried to read as much as possible to get
> an idea if what I would like to do is possible with it or not. This tool
> sounds very promising. I am looking for re-building a databank I created
> 3 years ago with Filemaker. I am not a database guru, far from that,
> this was the only one I did, and it was quite fun. But today I need to
> do some major modifications on it to improve the ease of use and I am
> looking for some alternatives to filemaker. One of my wishes would be to
> offer an internet accessibility to the database and to integrate if
> possible an image database to it with image preview.
>
>    The today databank is filled / managed thanks to a series of form
> which are connecting in a kind of workflow, related to a request number.
> The forms are built with simple fields, combo box, grids and buttons
> which oft launch a small script deciding the next form to display,
> depending of a parameter (for example if Method = = freezer method, then
> go to "freezer method" form , if Method = = chemical method, then go to
> "chemical method" form). The database is used by several users from
> different computer at the same time, so I need a server.
>
>    Ideally, I would like to use MySQL or PostgreSQL as server databank
> (sounds robust for image data), to have user filling / editing / reading
> the form via the browser and also if this is possible to have the
> possibility to integrated images to request number. And that all (quite
> a lot I believe) hopefully in agreement with in the concept of Rapid
> Database Application Development :-) .
>
>    Would be that possible with Kexi 2.0 ?

Hi Quentin,
It appears that you need the following features: good comboboxes and
some relationships, all within forms, and server database
connectivity. Kexi 2.0 is in transition state so if you depend on it
these times you would need to prepare yourself to cooperation with us
and patience: feature after feature is ported to the new KDE 4/KOffice
2, or even completely reworked, and thus while there are shining stars
like Reports, you may also find some features missing compared to Kexi
1.x.
Moreover while we're open to add features you will discover as
"definitely needed" in the folowing months you may find  that we (at
least I am) more focused on stabilization of the current features and
e.g. backward compatibility with previous 1.x series.
This does not mean ignoring the request, e.g. recently I've added
autodetected boolean type to the CSV import function. So yes, we
definitely need such real-world requests, and we have hundreds of
these carefully noted down :)

--
regards / pozdrawiam, Jaroslaw Staniek
_______________________________________________
Kexi mailing list
Kexi@...
https://mail.kde.org/mailman/listinfo/kexi

Hi Jaroslaw and other

Thanks prompt answer you gave me. I still spend time to look around what is possible in Kexi. But few information are available, what Kexi can really do. It is difficult  for me to decide if Kexi could be a solution for me. Could anyone tell me what is already available in Kexi, eventually what is available in alpha and beta version, and what won't be available before a long time. I am also open in using Kexi 1.6 if this offer more at this time.

I would be grateful if you people could comment those different point, to see on what I can count on and what may come soon. Thanks in advances, it will help me to clarify the situation, and this may also useful for other potential users

• Connection to a SQL server for several users from several computers

• To build the database without having to code for the database.

• 
  

• To design form with auto completion fields
•                                                ,combo box
•                                                        , datum
•                                                            ,tabs
•                                                      and grids       .

• The possibilities to bound some simple scripts bound with button to jump to the right form  or to influence the display of the page depending of certain values

•  Transform the Kexi form in web form to fill and query the information with the browser                    

• Possibility to upload image in the database to archive them
•                                                                       ,to tag them
•                                                   and to display on request                                                                                   .

• Possibility to display a graph of certain values on the front end page

Best,

Quentin




 







Jaroslaw Staniek wrote:

2009/4/22 derobill@... derobill@...:
  

I have just discover Kexi and tried to read as much as possible to get
an idea if what I would like to do is possible with it or not. This tool
sounds very promising. I am looking for re-building a databank I created
3 years ago with Filemaker. I am not a database guru, far from that,
this was the only one I did, and it was quite fun. But today I need to
do some major modifications on it to improve the ease of use and I am
looking for some alternatives to filemaker. One of my wishes would be to
offer an internet accessibility to the database and to integrate if
possible an image database to it with image preview.

   The today databank is filled / managed thanks to a series of form
which are connecting in a kind of workflow, related to a request number.
The forms are built with simple fields, combo box, grids and buttons
which oft launch a small script deciding the next form to display,
depending of a parameter (for example if Method = = freezer method, then
go to "freezer method" form , if Method = = chemical method, then go to
"chemical method" form). The database is used by several users from
different computer at the same time, so I need a server.

   Ideally, I would like to use MySQL or PostgreSQL as server databank
(sounds robust for image data), to have user filling / editing / reading
the form via the browser and also if this is possible to have the
possibility to integrated images to request number. And that all (quite
a lot I believe) hopefully in agreement with in the concept of Rapid
Database Application Development :-) .

   Would be that possible with Kexi 2.0 ?
    

Hi Quentin,
It appears that you need the following features: good comboboxes and
some relationships, all within forms, and server database
connectivity. Kexi 2.0 is in transition state so if you depend on it
these times you would need to prepare yourself to cooperation with us
and patience: feature after feature is ported to the new KDE 4/KOffice
2, or even completely reworked, and thus while there are shining stars
like Reports, you may also find some features missing compared to Kexi
1.x.
Moreover while we're open to add features you will discover as
"definitely needed" in the folowing months you may find  that we (at
least I am) more focused on stabilization of the current features and
e.g. backward compatibility with previous 1.x series.
This does not mean ignoring the request, e.g. recently I've added
autodetected boolean type to the CSV import function. So yes, we
definitely need such real-world requests, and we have hundreds of
these carefully noted down :)

  

_______________________________________________
Kexi mailing list
Kexi@...
https://mail.kde.org/mailman/listinfo/kexi

[Jaroslaw Staniek]

2009/5/19 derobill@... <derobill@...>:

> Thanks prompt answer you gave me. I still spend time to look around what is
> possible in Kexi. But few information are available, what Kexi can really
> do. It is difficult  for me to decide if Kexi could be a solution for me.
> Could anyone tell me what is already available in Kexi, eventually what is
> available in alpha and beta version, and what won't be available before a
> long time. I am also open in using Kexi 1.6 if this offer more at this time.

The latest stable version is 1.6. In addition it is the version that
is closed for features addition.
So 1.6 is way to go if you want to think about using the application.

Features of that version are published at
http://kexi-project.org/wiki/wikiview/index.php@...

> I would be grateful if you people could comment those different point, to
> see on what I can count on and what may come soon. Thanks in advances, it
> will help me to clarify the situation, and this may also useful for other
> potential users
>

I am referring to 1.6 version below.

> Connection to a SQL server for several users from several computers

> To build the database without having to code for the database.

There is table designer for simple use. However no poweruser
facilities can be designed here like triggers or indices (other than
primary key and single field keys).

> To design form with auto completion fields

no autocompletion for now

>                                                ,combo box

available
>                                                        , datum

date & date/time fields available
>                                                            ,tabs

tab widgets available

>                                                      and grids       .

grid (table view) available

>
> The possibilities to bound some simple scripts bound with button to jump to
> the right form  or to influence the display of the page depending of certain
> values

not available

>  Transform the Kexi form in web form to fill and query the information with
> the browser

available, may need assistance from the developer(s)

> Possibility to upload image in the database to archive them

available ("object" data type)

>                                                                       ,to
> tag them

perhaps through additional text column

>                                                   and to display on
> request

through form view

>               .
>
> Possibility to display a graph of certain values on the front end page

Charts are not available, neither graphs (in the scrict meaning).

--
regards / pozdrawiam, Jaroslaw Staniek
 Kexi & KOffice (http://www.kexi-project.org, http://www.koffice.org)
 KDE Libraries for MS Windows (http://windows.kde.org)
 http://www.linkedin.com/in/jstaniek
_______________________________________________
Kexi mailing list
Kexi@...
https://mail.kde.org/mailman/listinfo/kexi