[Kexi] branches/koffice/1.6/koffice/kexi

2006-10-26 Thread Jaroslaw Staniek
SVN commit 599352 by staniek:

* Kexi Query Designer supports parameter queries *

Query Designer
- New: Added support for parameter queries in design and SQL view. 
  User is asked for entering value of a parameter in a dialog window. 
  Paramers can be of any type except Object.


CCMAIL:[EMAIL PROTECTED]
CCMAIL:kexi@kde.org



 M  +3 -3  kexidb/Makefile.am  
 M  +56 -38kexidb/connection.cpp  
 M  +45 -17kexidb/connection.h  
 M  +20 -1 kexidb/cursor.cpp  
 M  +8 -0  kexidb/cursor.h  
 M  +1 -0  kexidb/drivers/mySQL/mysqlcursor.cpp  
 M  +0 -2  kexidb/drivers/sqlite/sqlitecursor.cpp  
 M  +2 -1  kexidb/drivers/sqlite/sqlitecursor.h  
 M  +139 -265  kexidb/expression.cpp  
 M  +70 -87kexidb/expression.h  
 M  +1 -2  kexidb/field.cpp  
 AMkexidb/fieldvalidator.cpp   [License: LGPL (v2+)]
 AMkexidb/fieldvalidator.h   [License: LGPL (v2+)]
 M  +2 -0  kexidb/kexidb.pro  
 M  +942 -1290 kexidb/parser/sqlparser.cpp  
 M  +66 -78kexidb/parser/sqlparser.h  
 M  +66 -65kexidb/parser/sqlparser.y  
 M  +259 -282  kexidb/parser/sqlscanner.cpp  
 M  +15 -10kexidb/parser/sqlscanner.l  
 M  +23 -0 kexidb/parser/sqltypes.h  
 M  +8 -0  kexidb/queryschema.cpp  
 M  +10 -4 kexidb/queryschema.h  
 AMkexidb/queryschemaparameter.cpp   [License: LGPL (v2+)]
 AMkexidb/queryschemaparameter.h   [License: LGPL (v2+)]
 M  +21 -1 kexidb/utils.cpp  
 M  +20 -12kexidb/utils.h  
 M  +9 -5  plugins/queries/kexiquerydesignerguieditor.cpp  
 M  +3 -2  plugins/queries/kexiquerydesignersql.cpp  
 M  +21 -9 plugins/queries/kexiqueryview.cpp  
 M  +5 -1  plugins/queries/kexiqueryview.h  
 M  +1 -1  widget/Makefile.am  
 AMwidget/kexiqueryparameters.cpp   [License: LGPL (v2+) (wrong 
address)]
 AMwidget/kexiqueryparameters.h   [License: LGPL (v2+) (wrong 
address)]


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


Re: [Kexi] OS X

2007-05-16 Thread Jaroslaw Staniek
Marijn Kruisselbrink said the following, On 2007-05-16 17:22:
> Wille wrote:
>> Hello
>>
>> I must say that Kexi is very interesting. I tried it on PC, and was 
>> just about to buy it when I switched to OS X.
>>
>> So right now I would be extremely happy if you released a version for 
>> OS X.
>> Many web developers I know run MS Access, and many of then have Macs 
>> and as you know MS Access isn't available for OS X, so they run a PC 
>> just to be able to run MS Access.
> KDE4, and with it KOffice2 will also have a native OSX version, probably 
> including kexi. Right now you can already download (experimental) 
> snapshots for OSX from 
> http://ranger.users.finkproject.org/kde/index.php/Home

Yes, Kexi 2.x (for KDE4) will be included there in more or less the same time 
as on other Unix systems, it only depends on how well KDE4 is supported there 
(and it's OK now).
KOffice 1.6.x with the newest Kexi is available on Mac:
http://pdb.finkproject.org/pdb/package.php/koffice

You can ask Benjamin Reed  for more info.

Regarding paid technical support (outside of KDE itself), Mac version is not 
included right now (maybe one day?).

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice: http://www.kexi.pl/en, http://www.koffice.org
  KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kde.org
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] Compilation of Kexi 2.0 pre-alpha enabled in SVN

2007-06-15 Thread Jaroslaw Staniek

.kexi files can be opened as well as server databases (it was the case in 
december but now it works with GUI, i.e. the startup dialog).

During porting many features were disabled; now these will be reenabled one by 
one.

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice: http://www.kexi.pl/en, http://www.koffice.org
  KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kde.org
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] koffice/kexi

2007-11-18 Thread Jaroslaw Staniek
SVN commit 738459 by staniek:

sqlite2 is no longer supported by Kexi. Use Kexi 1.x to migrate to sqlite3 if 
you need.

CCMAIL:kexi@kde.org


 M  +1 -1  3rdparty/CMakeLists.txt  
 M  +1 -1  kexidb/drivers/CMakeLists.txt  


--- trunk/koffice/kexi/3rdparty/CMakeLists.txt #738458:738459
@@ -1,4 +1,4 @@
 
 add_subdirectory( kexisql3 )
-add_subdirectory( kexisql )
+#ancient add_subdirectory( kexisql )
 
--- trunk/koffice/kexi/kexidb/drivers/CMakeLists.txt #738458:738459
@@ -1,7 +1,7 @@
 
 
 add_subdirectory( sqlite )
-add_subdirectory( sqlite2 )
+#ancient add_subdirectory( sqlite2 )
 
 INCLUDE (FindMySQL)
 IF (MYSQL_FOUND)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] KOffice status survey

2007-12-05 Thread Jaroslaw Staniek
Inge Wallin said the following, On 2007-12-04 14:06:

> We were discussing the tagging of the next alpha together with KDE 4.0RC2 on 
> IRC today, and the topic of the current status of KOffice came up.  It turns 
> out that nobody really knows the full status, so we decided to do a little 
> survey.
> 
> Would the maintainers of each component please reply to this mail in the 
> mailing list and state here:
>  * which features that are still not implemented, but which you want for 2.0?

* Turning KexiDB as Predicate library _out_ of KOffice
* putting CSV import/export back for reusing in kofficelibs

>  * which features that exist, but are still far from usable?

Not ported in Kexi (and not using Qt4 improvements): Forms, simple printing
Those alone can be treat as whole applications.

I imagine very long period before there's chance for any freeze in Kexi 2.0.
The reason is as obvious as KDE 4 - we and particulary I, need to split my 
time and give some chance for KDE 4 internals, especially Windows port for the 
KDE framework and some strategic KDE applications other than KOffice.

> You do *not* have to name every feature in the program, and especially not 
> those that only have polishing left.

We know the main showstopper for any app would be the level of support of 
underlying file format, to avoid data loss and users frustration. I believe a 
failure here would be worse than delays in our situation.
For everyone it's ODF, except for Kexi which maintains its own file format 
consisted of XML subformats (QT Desingner's), some custom ones. Chunks of ODF 
are the matter of the future beyond 2.0 (e.g. embedding whole ODT templates) - 
ODF provides nothing for database apps except connectivity information for 
apps like word processors, and this is not especially bad thing.

On top of that Kexi's storage model would improve by migrating to the newest 
stable SQLite. This is not started and isn't a matter of replacing a library - 
semi-automatic import/export features and/or conditions backward compatibility 
have to developed.

Scripts, what is another whole big layer, can take extensibility to the next 
level - we do not maintain the object model yet - one that can stay solid for 
years allowing for backward compatibility. Scripts are central part of Kexi, 
as it's more development tool than any other app.

Adam Pigg is implementing introductory stages for object model in his much 
appreciated reporting module [1]. There is not much reuse, largely because of 
we're short on manpower. Again, the reporting module is something like a whole 
application.

To put more vivid thing at the end, we are going to have one more driver in 
2.0, providing Sybase and MSSQL db support. This one comes from a new, 
vigorous developer Sharan Rao, which I met at Akademy this year.

[1] http://kde-apps.org/content/show.php/Kexi+Report+Part?content=58208

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice: http://www.kexi.pl/en, http://www.koffice.org
  KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kde.org
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] branches/koffice/1.6/koffice/kexi/kexidb

2008-01-10 Thread Jaroslaw Staniek
SVN commit 759457 by staniek:

KexiDB

fix the bug #146818: handling expressions containing 
binary operators like *, /, -, + where both arguments are of 
floating-point type (with single or double precision). 
Previously the result was marked as boolean, now it is 
floating-point.

CCMAIL:[EMAIL PROTECTED]
CCMAIL:kexi@kde.org



 M  +2 -6  expression.cpp  


--- branches/koffice/1.6/koffice/kexi/kexidb/expression.cpp #759456:759457
@@ -400,14 +400,10 @@
if (ltInt && rtInt)
return KexiDB::maximumForIntegerTypes(lt, rt);
 
-   if (Field::isFPNumericType(lt) && rtInt)
+   if (Field::isFPNumericType(lt) && (rtInt || lt==rt))
return lt;
-   if (Field::isFPNumericType(rt) && ltInt)
+   if (Field::isFPNumericType(rt) && (ltInt || lt==rt))
return rt;
-   if ((lt==Field::Double || lt==Field::Float) && rtInt)
-   return lt;
-   if ((rt==Field::Double || rt==Field::Float) && ltInt)
-   return rt;
 
return Field::Boolean;
 }
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] branches/koffice/1.6/koffice/kexi/widget/tableview

2008-01-17 Thread Jaroslaw Staniek
SVN commit 762477 by staniek:

A fix for data editing
- When a default value is specified for an field with 'required' flag, 
  it was not only applied when a new row is created, 
  but also when an existing row is edited, 
  thus overwriting the existing value. 

CCMAIL:[EMAIL PROTECTED]
CCMAIL:kexi@kde.org



 M  +1 -1  kexitableviewdata.cpp  


--- branches/koffice/1.6/koffice/kexi/widget/tableview/kexitableviewdata.cpp 
#762476:762477
@@ -628,7 +628,7 @@
 //(taken here for optimization)
 #define GET_VALUE if (!val) { \
val = m_cursor \
-   ? m_pRowEditBuffer->at( 
*it_f.current()->columnInfo, true /* useDefaultValueIfPossible */ ) \
+   ? m_pRowEditBuffer->at( 
*it_f.current()->columnInfo, (*it_r).isNull() /* useDefaultValueIfPossible */ ) 
\
: m_pRowEditBuffer->at( *f ); \
if (!val) \
val = &(*it_r); /* get old value */ \
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Kexi + Kugar

2008-01-21 Thread Jaroslaw Staniek
Matija Šuklje said the following, On 2008-01-20 17:31:

> I just started managing our house's bills in Kexi and wanted to use Kugar to 
> produce reports for it ...and was surprised to notice that Kugar uses its own 
> (and only its own) "DB".

Kugar is obsolete in part due to its architecture. And predicting long ago we 
have not been using it for Kexi.

A new OpenRPT-based tool is in development (by Adam Pigg) for KOffice 2. 
http://www.piggz.co.uk/kexirpt4.png
http://www.piggz.co.uk/kexirpt_designer1.png

> Is there a half-way normal way of using Kexi and Kugar

Sorry, there isn't

 > together and if not, what would be a better idea?

For now use external reporting tools like OpenRPT. We have written MANY links 
for you:
  
http://kexi-project.org/wiki/wikiview/index.php?RelatedProjects#Reporting_Tools

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi)
  KDE Libraries for MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Merge data from Kexi to KWord

2008-02-11 Thread Jaroslaw Staniek
John Jason Jordan said the following, On 2008-02-11 07:37:

> I can't get it to work. 
> 
> I go into Tools > Configure Mail Merge > Open Existing, and in the
> popup I select Qt-SQL Source (power user) - which is the only choice -
> and then I click on OK. 
> 
> This gives me another popup asking for Hostname, Driver, Database name,
> Username and Port. I enter the name of the computer (Devil7), leave the
> driver at QMYSQL3 (the only option), drag the database file from
> Nautilus into the Database Name box (the filename appears correctly),
> enter my username (jjj), and leave the Port at "default." 
> 
> When I click on OK, I am prompted for the password, so I enter the root
> password. And then I get "Can't connect to MySQL server on
> 'Devil7' (111)." 
> 
> I suspect that putting "Devil7" in the top box is wrong, but I can't
> find anything in the Help files that explains where to tell KWord to
> look for the file. The file is right here on the same computer as KWord
> - not on a networked server somewhere. 

IIRC, this feature has been added long before Kexi appeared.

Kexi's is not QtSQL-based, the KWord's feature is not dependent on whether the 
database was created usign Kexi or not. Your problem can be related to 
connection itself. Why do you use nautilus in the procedure or enter uppercase 
computer name? Try entering IP address or locelhost if the database is put on 
the same computer.

and try to test:
mysql -h {IP} -u root -p

> Can someone give me a step by step for how to get KWord to merge data
> from a Kexi database file?

Exprort to CSV from Kexi, then paste or insert the file. Kexi also ofers a 
Python plugin for exporting tables to html, which could be imported too.

For Kexi 2 there's a plan for more direct embedding of query results in other 
KDE apps.

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi)
  KDE Libraries for MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Merge data from Kexi to KWord

2008-02-12 Thread Jaroslaw Staniek
John Jason Jordan said the following, On 2008-02-12 04:13:
> On Mon, 11 Feb 2008 10:12:04 +0100
> Jaroslaw Staniek <[EMAIL PROTECTED]> dijo:
> 
>> John Jason Jordan said the following, On 2008-02-11 07:37:
>>> I go into Tools > Configure Mail Merge > Open Existing, and in the
>>> popup I select Qt-SQL Source (power user) - which is the only choice -
>>> and then I click on OK. 
>>>
>>> This gives me another popup asking for Hostname, Driver, Database name,
>>> Username and Port. I enter the name of the computer (Devil7), leave the
>>> driver at QMYSQL3 (the only option), drag the database file from
>>> Nautilus into the Database Name box (the filename appears correctly),
>>> enter my username (jjj), and leave the Port at "default." 
>>>
>>> When I click on OK, I am prompted for the password, so I enter the root
>>> password. And then I get "Can't connect to MySQL server on
>>> 'Devil7' (111)." 
>>>
>>> I suspect that putting "Devil7" in the top box is wrong, but I can't
>>> find anything in the Help files that explains where to tell KWord to
>>> look for the file. The file is right here on the same computer as KWord
>>> - not on a networked server somewhere. 
> 
>> IIRC, this feature has been added long before Kexi appeared.
> 
> Which feature do you mean?

Tools > Configure Mail Merge; it's not related to Kexi in any explicit way.

>> Kexi's is not QtSQL-based, the KWord's feature is not dependent on whether 
>> the 
>> database was created usign Kexi or not. Your problem can be related to 
>> connection itself. Why do you use nautilus in the procedure or enter 
>> uppercase 
>> computer name? Try entering IP address or locelhost if the database is put 
>> on 
>> the same computer.
>>
>> and try to test:
>> mysql -h {IP} -u root -p
> 
> I get the error message "Can't connect to local MySQL server through
> socket '/var/run/mysqld/mysqld.sock' (2)." I get this error message
> whether I try to connect via KWord (Tools > Configure Mail Merge), or
> using the command line you gave me above.
> 
> As for why I used Nautilus, it was just a fast way to type the filename
> into the box in the KWord connection window. The Kexi file is
> named /home/jjj/REPI/QuestionBank_kexi.kexi. I got tired of typing it
> over and over again and found that the filename and path are inserted
> automatically if I just drag the file from a Nautilus window into the
> box. Besides, it eliminates typos.

.kexi files are SQLite files. This is completely different thing compared to 
mysql databases and their server names. Unless KWord 1.x can open SQLite 
format (usign QtSQL), you cannot type .kexi filename into KWord Mailmerge's 
input box.

>>> Can someone give me a step by step for how to get KWord to merge data
>>> from a Kexi database file?
>> Exprort to CSV from Kexi, then paste or insert the file. Kexi also ofers a 
>> Python plugin for exporting tables to html, which could be imported too.
> 
> I can export from Kexi as .csv files, but the database has 43 tables in
> it. Doing them one at a time would be painful. Furthermore, I never
> want to merge an entire table, so I use queries to select specific
> records from the 43 tables and place them into another table called
> "Worktable." "Worktable" is what I want to merge from, but the data in
> it will always be changing. Furthermore, most of the tables have 25+
> fields but I want only selected fields, not the entire table. Pasting
> an entire table into a KWord document is not a solution.

Couldn't you run a query within Kexi to limit your set of records?

>> For Kexi 2 there's a plan for more direct embedding of query results in 
>> other 
>> KDE apps.
> 
> So at this time KWord cannot connect to data in Kexi?

You should be able - by connecting to native database (raw tables) on top of 
which Kexi is operating. Either SQLite, PostgreSQL or MySQL. Always be 
providing proper conenction data - again - without mixing kexi database file 
path with server database name.

> Thanks for the suggestions. Still trying to figure out how to merge
> selected data into a word processor. I'd actually prefer to merge into
> OpenOffice.org Writer, but I tried KWord because OOo cannot merge data
> from Kexi either. I thought it might be easier using a KDE app like
> KWord.

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi)
  KDE Libraries for MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] www.kexi-project.org web site

2008-03-31 Thread Jaroslaw Staniek

The web site has been offline for some days due to problems at the provider 
side. It's online now.
The only inconvenience now is that the kexi-project.org address is not 
working, please use www.kexi-project.org.

I am sorry for any inconveniences.

Let me announce by the way: while the load is increasing, we'd be interested 
in switching to other professional (bigger) hosting provider that would want 
to sponsor the hosting.
The requirements are: SFTP access, PHP+MySQL, not more than 1GB of space.
We do not plan to host any big binaries -- these are hosted by KDE servers.

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi)
  KDE Libraries for MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] www.kexi-project.org web site

2008-03-31 Thread Jaroslaw Staniek
Jaroslaw Staniek said the following, On 2008-03-31 14:15:
> The only inconvenience now is that the kexi-project.org address is not 
> working, please use www.kexi-project.org.

Fixed now too.

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi)
  KDE Libraries for MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] [kexi] How to import to kexi from OO Base?

2008-04-22 Thread Jaroslaw Staniek
Dinbandhu said the following, On 2008-04-22 02:07:
> Hi,
> I have just found out about kexi and am excited to try it. I would like
> to import one of my databases from OpenOffice Base 2.3. I opened kexi,
> and the import option only seems to provide ready-made import of MS
> Access files. I'm sure there must be a way to import from OO Base. Could
> someone tell me the best way? I use OO in Linux Ubuntu 7.04 (Feisty),
> and will be using kexi in Ubuntu Feisty as well.

Hello Dinbandhu,
Try to export your tables to a CSV format and then import them in Kexi. No 
import option at higher level (whole databases) is available.
Regarding queries, you could try to copy their SQL statements.
Regarding forms, you'd need to recreate them by hand, as there is no common 
file or XML format now we could share.

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi)
  KDE Libraries for MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Trying to import an MS Access database

2008-04-22 Thread Jaroslaw Staniek
Dinbandhu said the following, On 2008-04-22 02:30:
> Hi,
> While I am waiting to find out how to import my OO Base database, I
> thought I would try out Kexi in the mean time by importing using Kexi's
> import wizard for importing an MS Access database. My computer has a
> dual boot with Ubuntu Feisty, and Win98. On the Win98 partition I have
> an MS Access database. And in my Ubuntu partition I have Kexi installed,
> so there I started up Kexi, went into Kexi's import wizard and browsed
> to and selected the MSA DB in my Win98 partition-- but upon clicking
> "next", I got the following error message:
> 
> "Could not import database "/media/disk/My Documents/Win98
> Pravacans/Database of Transcribed Provecans.mdb". This type is not
> supported.
> 
> But it says in the import window for file types, "All Supported Files
> *.mda,*.mdb,*.mde". So it should be supported. This seems to be the very
> type of file which the import wizard is designed to import. So why isn't
> it working?

In Kexi 1.x were not checking for existence of the driver when displaying 
*.md* the filter.

Install kexi-mdb-driver
More info at http://kexi-project.org/wiki/wikiview/[EMAIL PROTECTED]

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi)
  KDE Libraries for MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Trying to import an MS Access database

2008-04-22 Thread Jaroslaw Staniek

Please read the relevant pages on kexi-proejct.org, then you will know that 
1.x is the current stable version. Bugs related to your distribution should be 
reported to your vendor and only if you have any evidence the issue is related 
to the source code, report them to bugs.kde.org.

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi)
  KDE Libraries for MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] How to import to kexi from OO Base?

2008-04-22 Thread Jaroslaw Staniek
Dinbandhu said the following, On 2008-04-22 14:38:

> Ok -- here is the critical point. I exported from OO Base as a CSV file,
> and was able to import the CSV file into Kexi. And in Kexi's import
> preview window it gives a view of the table and how it will look after
> it is imported. There everything is perfect. But when I actually run the
> import, then anywhere in the original table where there is an empty
> cell, there Kexi is not keeping it empty as it should but is rather
> bringing in data from cells in the next column to the right. So that in
> the final imported table, the data are no longer in the correct columns
> where they belong. In the preview version everything is perfect. But
> once the import is actually executed, due to not recognizing empty cells
> as empty, all the data is in the wrong columns. Is there some way to fix
> this?

If you have picked right delimiter and other options and you are (almost) sure 
there is still a bug, please file a bug report on bugs.kde.org. There, you can 
attach the problematic csv file (sometimes even one row is enough).

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi)
  KDE Libraries for MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] How to import to kexi from OO Base?

2008-04-22 Thread Jaroslaw Staniek
Dinbandhu said the following, On 2008-04-22 16:26:

> Before reporting a bug, may I just ask you: am I correct in thinking
> that since the table is correctly shown in Kexi's preview window, and
> only becomes wrong after the import operation is carried out, that this
> suggests a problem inside Kexi? If there were errors in my delimiter
> settings etc, then wouldn't one expect the preview view of the table in
> Kexi to also have those same errors? 

It shoud look the same in the table view after import and in the preview.

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi)
  KDE Libraries for MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] How to import to kexi from OO Base?

2008-04-23 Thread Jaroslaw Staniek
Dinbandhu said the following, On 2008-04-24 01:19:
> On Tue, 2008-04-22 at 14:56 +0200, Jaroslaw Staniek wrote:
>> If you have picked right delimiter and other options and you are (almost) 
>> sure 
>> there is still a bug, please file a bug report on bugs.kde.org. There, you 
>> can 
>> attach the problematic csv file (sometimes even one row is enough).
> 
> I opened an account at bugs.kde.org and started the wizard for entering
> a new bug, but its first question is: What version of KDE are you using?
> 
> When I submitted the reply: 3.5.6

Is this required field?

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi)
  KDE Libraries for MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] How to import to kexi from OO Base?

2008-04-24 Thread Jaroslaw Staniek
Dinbandhu said the following, On 2008-04-24 02:38:
> On Thu, 2008-04-24 at 02:04 +0200, Jaroslaw Staniek wrote:
>> Dinbandhu said the following, On 2008-04-24 01:41:
>>>>> I opened an account at bugs.kde.org and started the wizard for entering
>>>>> a new bug, but its first question is: What version of KDE are you using?
>>>>>
>>>>> When I submitted the reply: 3.5.6
>>>> Is this required field?
>>> Yes, it is a required field. And you must select one of the given
>>> options.
>>>
>>> 3.5.6 was not actually one of the options, though. One option was
>>> "versions prior to 3.5.6", and then the next option was "3.5.8", and
>>> then there were more recent version options. But 3.5.6 itself was not
>>> listed. In that scenario it was not clear which I should choose, so I
>>> selected "versions prior to 3.5.6" because what I have is not "3.5.8".
>> So try to cheat, as the report apparently does not depend on anyting new in 
>> 3.5.8+
> 
> That worked. I moved ahead, and upon my entering a brief description of
> the bug, it offered similar previously reported bugs-- and I found that
> indeed it is already reported. Here below is the bug as reported
> 10/28/07:

Dinbandhu, I just have no time currently but if you look at [1]
you'll discover I've tried to address your issue with the bugzilla first. I'll 
look carefully at your report and respond via the bugzilla.

Thanks for your interest!

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi)
  KDE Libraries for MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] How to import to kexi from OO Base?

2008-04-24 Thread Jaroslaw Staniek
Dinbandhu said the following, On 2008-04-24 23:46:
> On Thu, 2008-04-24 at 22:41 +0200, Jaroslaw Staniek wrote:
> 
>> Dinbandhu, I just have no time currently but if you look at [1]
>> you'll discover I've tried to address your issue with the bugzilla first. 
> 
> I'm sorry, what does "[1]" refer to? I went to the bug's page in
> bugzilla but could not see where you had written something.

I am sorry,
[1] http://lists.kde.org/?l=kde-core-devel&m=120902354122917&w=2


-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi)
  KDE Libraries for MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] There more maintenance patches available for Kexi 1.1.3

2008-04-30 Thread Jaroslaw Staniek

Dear users,
As there are no new releases of KOffice in 1.x series, we're providing 
imporatant maintenance patches from time to time. These patches are especially 
recommended for Linux/Unix distributions: in order to maintain high quality of 
the software, packagers should apple them before building.

A fix for handling long text types in MySQL migration
http://kexi-project.org/wiki/wikiview/[EMAIL PROTECTED]

A fix for handling boolean types in PostgreSQL driver and PostgreSQL migration 
plugin
http://kexi-project.org/wiki/wikiview/[EMAIL PROTECTED] 


A fix for possible crash in buffered mode in SQLite driver
http://kexi-project.org/wiki/wikiview/[EMAIL PROTECTED]


Please also look at the previous patches if you haven't done so.

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi)
  KDE Libraries for MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] There more maintenance patches available for Kexi 1.1.3

2008-05-01 Thread Jaroslaw Staniek

BTW, for users of GMANE news gateway: GMANE obfuscates urls containing @ 
character so here's the shortened link again: 
http://tnij.org/fix-handling-long-text-type

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi)
  KDE Libraries for MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Linux + windows

2008-06-01 Thread Jaroslaw Staniek
clarge said the following, On 2008-06-02 01:38:
> If I get the windows version can I copy the files back a forth between Linux 
> and windows machines with corupting the data? I may have times I wish to put 
> the data base on my windows machine to take with me and input data then bring 
> it home and put on Linux box to finish inputing and sorting.

Yes, you can, that has always been the goal. And add Mac to this equation too
(for Kexi  2.0).

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi)
  KDE Libraries for MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] Kexi@kde.org list works again

2008-11-06 Thread Jaroslaw Staniek

Congratulations,
If you can see this message, you most probably can use the Kexi@kde.org 
mailing list again.

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


[Kexi] [article] "Dump Microsoft Access, Get Kexi"

2008-11-06 Thread Jaroslaw Staniek

http://64.233.183.104/search?q=cache:Njm6So1lkuIJ:www.linux-mag.com/id/7176

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


Re: [Kexi] Linking form to tables.

2008-11-07 Thread Jaroslaw Staniek
Biswajit Dutta Baruah said the following, On 2008-11-07 12:39:
> Dear Friends,
> 
> One of the problems I have faced in using kexi is using forms to tables.
> I find that kexi can link only one table to one form. In other words, I
> cannot have two forms to enter data in a single table. Ideally to keep
> things in order its easier to keep data well distributed between
> multiple tables. 

I would search for 'subforms' term at http://lists.kde.org/?l=kexi&r=1&w=2

For example it returns this thread:
http://lists.kde.org/?l=kexi&m=117994307511103&w=2

We need some more to get subforms. We're in transition stage to KDE4 now.

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


Re: [Kexi] Linking form to tables.

2008-11-07 Thread Jaroslaw Staniek
Biswajit Dutta Baruah said the following, On 2008-11-07 12:39:
> Dear Friends,
> 
> One of the problems I have faced in using kexi is using forms to tables.
> I find that kexi can link only one table to one form. In other words, I
> cannot have two forms to enter data in a single table. Ideally to keep
> things in order its easier to keep data well distributed between
> multiple tables. 

Hi
I would search for 'subforms' term at http://lists.kde.org/?l=kexi&r=1&w=2

For example it returns this thread:
http://lists.kde.org/?l=kexi&m=117994307511103&w=2

We need some more to get subforms. We're in transition stage to KDE4 now.

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


Re: [Kexi] Forms Question

2008-12-29 Thread Jaroslaw Staniek
2008/12/29 scott :
>  Just starting out with Kexi and so far I think it's great.  Perhaps
> when I get familiar with it I can help further develop it.  Or at least
> improve on the documentation.

Hi Scott,
good to hear your plans :)

> But for now I have a couple of questions
> concerning forms.  1) I would like to have a menu form where I can enter
> either a ID number which then after pressing the appropriate button it
> launches me to a new form where the information is that matches the ID
> number.  Can this be done and if so how?

I am assuming you're using 1.1.3 version from KOffice 1.6.3, as 2.0 is alpha.
It's not possible by setting a property nor using a script (I think)
as there are no bindings for scripts at the interactive level yet.
Using find dialog is the only option virtually close to what you
describe, at the moment.

> 2) If a form is displayed, I
> then press a button to launch a query, when the results are returned,
> can I have a button or two that, that is associated with each row
> returned, when pressed launch the appropriate form?

Not yet. It's useful option indeed.

>   Also, can a rule be setup for a input area that it is to match two or
> more possibilities?  Such might be that a field is either Male or Female?

For two-values-based field, you can use the boolean data type and the
checkbox widget.
For more values, create a small two-column table (ID, Name) and use it
in the lookup column setup (the column in the master table should be
of type Integer. A simple kde-files.org example [1] provides more info
on the design of lookup columns.

[1] http://www.kde-files.org/content/show.php/Simple+Database?content=23137

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


Re: [Kexi] Forms Question

2008-12-30 Thread Jaroslaw Staniek
2008/12/30 scott :
>   Let me ask you this:  Is it possible to define a one to many
> relationship?

Defining database relationships (that could allow for referential
integrity, cascade updates, etc.) is disabled currently, until we find
a way and time to do this in one go for most of our backends (this is
a price we pay for this freedom of choice).

>   Also, is Kexi written in C or C++?

Standard C++, without STL, with currently I-would-say-leading in this
class: Qt [1] and KDE libraries [2] :).

Happy New Year!

[1] http://trolltech.com/products/products/appdev
[2] http://techbase.kde.org/Development


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


Re: [Kexi] Compiling Kexi

2009-01-12 Thread Jaroslaw Staniek
2009/1/11 scott :
>   I am trying to compile Kexi per the instructions found at:
> http://kexi-project.org/wiki/wikiview/index@usingsubversion.html
>
>   Ran into a snag where it states in the instructions:
> ./configure --enable-debug=full --prefix=`kde-config --prefix`
>  perl admin/am_edit
>
>  Is it supposed to be "--prefix-perl=admin/am_edit"?   If not, what is
> this specification supposed to be?

'perl admin/am_edit' in the 2nd row is a distinct command. Please try
the compilation without running it, first.


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


Re: [Kexi] KDE: ODBC

2009-01-21 Thread Jaroslaw Staniek
Peter Harvey said the following, On 2009-01-19 21:10:

> Many years ago I contributed code to integrate ODBC into KDE. This
> included the KDE control panel for example. However; the structure of
> the KDE control panel changed radically soon after and the ODBC bits
> were pushed aside.
> 
> I am interested in picking this effort up again and carrying it forward.
> I just moved the Qt-based GUI bits out of unixODBC and into a new
> project on source forge called unixODBC-GUI-Qt. My thinking is that this
> code could be the basis for some ODBC integration into KDE.

Peter,
I am looking forward to see your ideas implemented :)

BTW, At some level ODBC is a subject of research within Kexi, by Sharan Rao.
The goal here is not only to develop 1-to-1 frontend for unixODBC, which would 
be rather straightforward (but still a lot of work and testing), but also some 
interfaces that can enable interaction of ODBC layer with data definition and 
data access interfaces like Predicate (aka KexiDB v2).

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


Re: [Kexi] KDE: ODBC

2009-01-21 Thread Jaroslaw Staniek
2009/1/21 Sharan Rao :

> And the kexi-odbc bridge is being done :). perhaps I will move the
> code to the repository this weekend.

Wow, Sharan you just demonstrate your magic again :)

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


Re: [Kexi] Documentation for Combo boxes and the like

2009-02-05 Thread Jaroslaw Staniek
2009/2/5 Manfred Jung :
> Hi all
>
> Kexi might be my answer to getting rid of a certain micro$oft program.
> but im new to Kexi and have to unleran some of the old habits. i suppose.
>
> I tried fiddling around with combo boxes looked at the documentation
> (hanbook), found nothing (I might be looking in the wrong places). I
> also searched the mailing-list. I looked a the Sample database and there
> is a combo box working. But i could not find where the como-box gets
> told where to fetch the data to display in the drop down section.

Hi,
- in the table designer, lookup column tab on the right hand; in the table
data mode you'll see comboboxes

So in the table designer, just select table in the lookup column tab
on the right hand and a bound column within this table (the same
pane). In the example database, click on the 2nd tab to see how this
has been set up.

- in the form designer - once you have lookup columns in your table's
project, you can
put combo boxes onto your form (use similar lookup field tab)

see the 2nd tab here
http://www.kexi-project.org/pics/1.1.1/lookup_column_design.png

> Further I don't see where the combo-box is told which is the bound
> column. etc.
>
> Is there some documentation on the various controls Kexi uses?
>
> One more thing. Does Kexi have something that M$ Access calls a subform?

it's not available yet

> Any help or pointer to the right documentation is most appreciated.

It's here: http://docs.kde.org/kde3/en/koffice/kexi/index.html
In particular 'http://docs.kde.org/kde3/en/koffice/kexi/designing-forms.html'
(Most important terms) is, well... important.


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


Re: [Kexi] Documentation for Combo boxes and the like

2009-02-05 Thread Jaroslaw Staniek
2009/2/5 Manfred Jung :
> Thanks so much
>
> I see the concept here is quite different but also logical. In access you
> define such relationship for the combo box itself regardless of the tables
> and their relationships. Thanks this helped a lot.
>
> The combo-box displays in the drop down contents of the underlying table. Is
> there a way to say which fields should be displayed?

Yes there is -- see the "visible column" field on
http://www.kexi-project.org/pics/1.1.1/lookup_column_design.png

BTW, with 1) additional wizard for the feature and 2) MSAccess-like
possibility of designing the binding for combobox widget itself, I
hope one day more use cases will be covered.

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


Re: [Kexi] Documentation for Combo boxes and the like

2009-02-05 Thread Jaroslaw Staniek
By the way, corrently only one column can be declared as visible in
the "lookup column" pane.

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


Re: [Kexi] Documentation for Combo boxes and the like

2009-02-06 Thread Jaroslaw Staniek
2009/2/6 Manfred Jung :
> Indeed You are right with thevisible column. this seems to be the collum
> that gets displayed when a selection has been made and the drop down combo
> box is closed. Nevertheless kexi displays mor than one column in the drop
> down part of the combo box if the underlying table has more than one column.
> This is nice but it would be better to find a way to decide which columns
> gets displayed and in which order. But I understand kexi is a project in
> progress.

You have no gui for setting up this yet even while the file format
allows for such definitions.
>
> One more question if I may. There seems to be no wiggit  to display a table
> in a form. (ie more than one  record in a list). I would need this in a form
> to display all phone numbers of a particular contact. The phone numbers are
> saved in a seperate table since on person can have many phone numbers. Or is
> there a better/different way of doing this in kexi?

Your use case is important, and by the way, it is similar to subforms
-- if we look at the way of interaction of the table view with the
parent form, it's similar to how subform interacts with the parent
form. Both things are on the TODO list, subforms first, then
sub-table-views.

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


Re: [Kexi] Getting to know internals

2009-02-07 Thread Jaroslaw Staniek
2009/2/7 scott :
>   I would like to contribute to Kexi and have been poking around the
> source.  Is there some documentation as to what source modules do what?

Hi Scott,
Adam is right that the Reports module maintained by him is the most
active part of Kexi development these months.I am (still) mostly
focused on refactoring, at the moment its related to forms. Main
window will receive more changes from developer POV too.

The http://www.kexi-project.org/docs/svn-api/html/ link points to old
(april 2008) doxygen documentation. It's beter to checkout the source
code and use Doxygen on kexi/ directory.

api.kde.org [2] has up to date documentation of Kexi source code but
only koproperty, as api.kde.org is a place where common libraries are
documented, not applications.

So, a good starting point is http://kexi-project.org/wiki/wikiview/
In particular:
Kexi Architecture
http://kexi-project.org/wiki/wikiview/index@kexiarchitecture.html

Kexi Libraries Dependency
http://kexi-project.org/wiki/wikiview/index@kexilibrariesdependency.html

These are documents created for 1.x development but are mostly ok for 2.x.
Do not hesitate to ask about details here or on IRC: #kexi or #koffice
channel on chat.freenode.net server.

[1] http://www.stack.nl/~dimitri/doxygen/
[2] http://api.kde.org/koffice-api/koffice-apidocs/kexi/html/index.html

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


[Kexi] Maximum size and security of Kexi databases [was: Kexi information]

2009-02-09 Thread Jaroslaw Staniek
2009/2/9 Ben wrote:

> I am switching my website and small business systems to Linux but finding a
> suitable alternative to access is proving troublesome. I have done some
> reading on kexi but I have not found the information I require. If you could
> answer the following questions that would be excellent as kexi appears very
> appealing.
>
> 1) What is the max size of a Kexi database?
> 2) How many simultaneous users does Kexi support?
> 3) What are it's security features? IE: bit encryption, user access
> controls etc.
> 4) How does kexi perform over in a client-server network environment?

Hi Ben,
If you use file databases (SQLite-based), all properties of SQLite
applies to Kexi, i.e. please read e.g.
http://www.sqlite.org/whentouse.html

If you decide to use MySQL, PostgreSQL (or in the future -- 2.x --
series: MS SQL Server,  Oracle, Sybase, etc.), please refer to the
respective database's documentation on its capatibilities. Kexi
inherits these (main) capatibilities from the databases, although its
strategy is to strip down the features to a subset (although the
application can be extended for specialized use by developers).

For some related information please visit
http://kexi-project.org/wiki/wikiview/index@kexicomparisons.html

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


Re: [Kexi] MDB database

2009-03-10 Thread Jaroslaw Staniek
2009/3/10 Steve Brettell :
> When I try to open my MDB file in Kexi, I get "no appropriate migration
> driver found."  Is there a solution for this?

Hi
The solution is to install the MDB migration driver, which is packages
separately of Kexi, even if it's a part of the project.
Please always mention name and version of your distribution. Search
for "mdb" or "access" in your packaging systems.

For details see Answer 4.1 at
http://kexi-project.org/wiki/wikiview/index@kexifaq.html

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


[Kexi] Kexi 2.0 development status

2009-04-10 Thread Jaroslaw Staniek
Hello,
For your information,
I have posted some update on Kexi development:
http://forum.kde.org/what-happened-to-kexi-t-42220.html

Feel free to request more information.

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


[Kexi] Kexi 2.0 Alpha 12 available

2009-04-11 Thread Jaroslaw Staniek
Hello,
Alpha 12 is just a tagged revision, indication one milestone in the
development of 2.0.
Some more information in adition to the extensive but technical
changelog [1] can be found at a new blog entry:
http://www.kdedevelopers.org/node/3933.

[1] http://wiki.koffice.org/index.php?title=Kexi/Releases/Kexi_2.0_Alpha_12

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


Re: [Kexi] switching from FM to Kexi?

2009-04-22 Thread Jaroslaw Staniek
2009/4/22 derob...@gmail.com :
> 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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Access

2009-05-05 Thread Jaroslaw Staniek
2009/5/5 Stephen S. Brettell :
> I apologize, because you answered this for me before, but my system
> crashed, and I forgot the solution you gave me.
>
> I want to import an Access (mdb) database
> I have downloaded, and (according to my system) installed the mdb
> migration driver
> I still can't import the database
>
> You gave me an answer before that worked, but all was lost in my crash
>
> Can you walk me through the process of getting Kexi to import an MDB
> file, including what software I need, and how to properly install it?
>
> I am using Kexi 1.1.3 with KDE 4.1 desktop on ubuntu's latest
> manifestation, whatever cute name they've given it (lazy louse or
> whatever)
>
> Thank you for your indulgence

Steve, please use the instructions I wrote here
https://bugs.kde.org/show_bug.cgi?id=185750#c2

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Access

2009-05-08 Thread Jaroslaw Staniek
2009/5/9 Stephen Brettell :
> Has the Kexi Project page been eliminated?

It hasn't, just there is some reorganization on sponsor's server.

> I downloaded, and tried to follow your instructions, but it seems that one
> version is interfering with another, and so it cant be installed.  I now
> have to figure out where the files are and erase them, reload the package
> and start over.

If you use some kind of packaging system, previous version could be uninstalled?

--
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Kexi vs. FileMaker

2009-05-20 Thread Jaroslaw Staniek
2009/5/20 i...@{...}:
> Hello,
> I'm new to the Linux world and I find it fantastic... most of the time.
> I've been looking around for a way to use FileMaker on Linux (Ubuntu,
> Debian, Fedora).
> And I read about Kexi. Is it possible for Kexi to open or import FileMaker
> files? And If not, can I cross may fingers and hope it will do so soon?

Hi
There is no such filter, and the authors of Filemaker apparently
developed really proprietary format...
Yes, you can cross your fingers but you really have to have big fingers :)

The easier start would be to look at possibility of export (or even
share) only _data_ from Filemaker. We have not that many users of
naive Mac around yet (but yes I know Filemaker also works on Windows).
Spreading the word about Kexi and actually using it for projects
started from scratch would increase user base and thus increase
chances for existence of more export tools.

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] Buffered cursors for sqlite3

2009-06-26 Thread Jaroslaw Staniek
Adam,
Turns out that it's safer to say: buferred cursors does not work at
all for sqlite 3. The implementation just does not crash, but only
worked for sqlite 2.

It's all a TODO work.

If needed, you can buffer on your own by reading into QList or QVector
of records (as we do in KexiTableViewData).
libpredicate will deliver this feature, since we have more and more
use cases for this.

I am not even sure mysql or pgsql implementation can even work correctly.

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Rép. : Re: Kexi

2009-07-12 Thread Jaroslaw Staniek
2009/7/8 Saad Mansour :
> - Is it possible to match the data ( extracted from the DB with Kexi
> product) with some report models already done.

Hi, depends on the case, so you would have to provide examples.
Sometimes scripting would be needed.

> - Graphical mode ( drag and drop) to make links between tables on the DB (
> and visualize them as in Microsoft Access).

DB relationsips are not yet supported. Only some (inner)  joins within
queries are.

> - Drivers (JDBC or ODBC) for access to db2 or oracle database.

db2 unsupported,
native oracle driver is available in Kexi 2.0 (which is unstable now).

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Rép. : Re: Kexi

2009-07-12 Thread Jaroslaw Staniek
2009/7/12 Steve Brettell :
>
>
> I downloaded the plugin to read mdb files, and it has been working, until the 
> last time I tried to open the same old mdb file.  Now it says the 
> extension/plugin, whatever it's called isn't available.
>
> I upgraded to Jaunty Jackalope Ubuntu inthe meanwhile.
>
> Can you think of a fix for this?
>

Please use the instructions I wrote here
https://bugs.kde.org/show_bug.cgi?id=185750#c2


-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Rép. : Re: Kexi

2009-07-14 Thread Jaroslaw Staniek
2009/7/14 Saad Mansour :
> Hi Jaroslaw,
>
> Thanks for your answer, i wanted to know if it's possible to install and run
> only Kexi or it's necessary to download the whole KOffice suite in order to
> have Kexi?

Only kexi and "koffice libs" packages are required. Also kexi drivers
are optional.
Some distributions do not split features well enough (in our opinion)
but we are trying to address this if possible.
For sure, if this is your request, Kexi can be used independently of
other applications like KSpread or KWord.


PS: I recommend registering at
https://mail.kde.org/mailman/listinfo/kexi and writing to kexi@kde.org
to share knowledge.

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Rép. : Re: Kexi

2009-07-15 Thread Jaroslaw Staniek
2009/7/15 Saad Mansour :
> Hi Jaroslaw,
>
> Thanks for your fast answer. One last question though, if we change the Kexi
> version ( from a version to an another), do we have te Redefine all the
> macros again or they are usable in the new version? I'm asking this because
> it's a real probleme on Microsoft Access curently, if you go from MS 2003 to
> MS 2007 you have to work all your macros again.

Kexi does not support MSAccess-style macros yet, just scripts.
Scripts could require fixing when major stable Kexi version 2 appears.

We try to maintain compatibility but for this we need to design public
programming interfaces carefully what is costly - takes time.

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] kexi.po.mo

2009-07-20 Thread Jaroslaw Staniek
Jaroslav,
Thanks for your contribution.

You can translate the handbook to Czech, but this won't be official one.

The english handbook (a base for translation within KDE) was created
as a simpler version of the Polish one, with screenshots removed.
I do not maintain the english handbook, instead there is a plan to
adopt it for 2.x series of Kexi when its features are frozen. Until
then many efforts would be duplicated, so I discourage from extending
handbooks of 1.x series. Would you be interested in helping in this
regard?

Regarding .po/.mo files - these are strictly bound to given version of
Kexi, so if you take a translation for Kexi 2007.1.1, you may for
example end up with 1% of tanslations not matching your version. And
so on and so on. The files themselves are platform-independent, these
are just bound to application versions.

You mentioned you have translated kexi.po to Czech. It appears that
(http://i18n.kde.org/stats/gui/stable/package/koffice/cs/) that
kexi.po (1.x) isn't fully translated. Wouldn't you want to contact the
Team and update the file (if possible)? You can also ask if the Czech
translation of kexi needs a maintainer.

(CC'd to kexi@kde.org list; you can subscribe at
https://mail.kde.org/mailman/listinfo/kexi/)
-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Kexi Interest

2009-09-03 Thread Jaroslaw Staniek
2009/9/3 Arthur Baldwin :

> At my workplace I was finally successful in installing the older version of
> Kexi, along with the help of the EnterpriseDB GUI installer to setup
> PostGreSQL 8.3, and began using the form designer to at least begin playing
> with Kexi.  It didn't take me very long to realize that there is no
> provision for "Sub Forms" aka "Master/Detail" Forms.  Is this one of the
> planned additions to Kexi 2.0?

Yes it is for 2.x series, perhaps for 2.1 once the core code stabilizes.
I am afraid I cannot disclose any timing yet.

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Kexi Interest

2009-09-03 Thread Jaroslaw Staniek
2009/9/3 Arthur Baldwin :
> One of my own strong desires is to see an MSAccess replacement that can
> handle the preservation of "mixed case names" for Tables, Queries, Forms,
> and Reports.  I think it would be acceptable to replace spaces with
> underscores, if it's too much hassle to maintain the spaces in names.
> PgAdmin3 allows you to create table names with mixed case in the GUI
> environment, and I understand that the PostGreSQL backend allows you to
> delimit the name with double quote marks in order to maintain things like
> mixed case and special characters.

Kexi supports captions in addition to names for table, queries, etc.
They just not appear in the project navigator _for now_.
The goal for this was to present the names in the same way as the
database server sees them.
Of course relevant options that affect display of names, are posible
to implement and that's in fact on out TODO list.

PS: could you please CC general discussion to kexi@kde.org next time?

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] Kexi TODOs page

2009-09-07 Thread Jaroslaw Staniek
Dear All,
I've given more attention to the TODO page [1].
BTW I added mediawiki templates that you're free to use on other pages
too. These are simplified compared to techbase feature plan pages but
seem to work in context of a single app.

[1] http://wiki.koffice.org/index.php?title=Kexi/TODOs

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Using KoProperty in Kolf

2009-09-18 Thread Jaroslaw Staniek
2009/9/18 Stefan Majewsky :
> Hi,
>
> as I pointed out in a blog post last month, I'm looking for a property editor
> to use in the course editor of the minigolf game Kolf 2. KoProperty looks very
> well suited for this job, but I would like to clarify some points with you:
>
> 1. How can we go about integrating KoProperty into the Kolf sources? Simply
> copying all files is not good, because you're actively working on it (and I'll
> probably also want to make some modifications, see below). svn:externals also
> seems not to be an option, because the build system seems to require a build
> of the complete KOffice.

Stefan, thanks for your interest :)
I propose copying (branching) the code as temporary solution.
I think about having the lib as Qt-only and putting it somewhere
outside of koffice.
Until then I guess we could exchange patches. Doing that please also
alter the cmake file, in particular change the name to something like
kopropertykolf or so. Later you shall be able to change to shared
qt-only library and packagers would not notice anything except just a
need for adding additional dependency.

Please not that your special editors and types could be implemented
outside of koptoperty in factories delivered by plugins. This could
avoid many internal modifications.

> 2. Which storage backend does KoProperty use? I need to read QMetaProperties
> from QObjects, and write values back in.

Own property set "Set" class and "Property" item is used.
You'll be able to map your Qt properties to these easily. In fact I do
that in Kexi Forms but since other uses of KoProperty are not based on
Qt properties, this code is not shared.
I am open to have it in KoProperty though.

> 3. I need to add support for my own data types (three-dimensional variants of
> QPointF, QSizeF, and QRectF). Is this possible?

It's possible to add of course and I am open for supporting you.
Reasonable medium where we can share the docs on how to use the
framework is probably techbase. How do you like it?

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Using KoProperty in Kolf

2009-09-18 Thread Jaroslaw Staniek
2009/9/19 Stefan Majewsky :

> So for now, I would create a static copy of KoProperty as you described.
> Are you signed up on reviewboard.kde.org? This should ease patch management
> quite a bit.

I am, we could use koffice group for now...

> I'll try to create a patch for that next week, in order to get into the code
> structure and such. I have a question with that, though: How do you handle
> localizable captions for the properties (and the localizable title, e.g.
> "Table field" in Kexi's table designer) currently?

see Property::setCaption(), Property::caption()

> Techbase is a good idea. As I pointed out on Planet KDE some time ago, I'm
> very interested in extensive API and design documentation. You can also expect
> comments on and patches for the KoProperty API from my side, whenever
> appropriate.

Great!

> P.S. You have CCd some related mailing lists. Should I subscribe to these?

That's good idea, at least kexi@kde.org, which is very silent one.

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Using KoProperty in Kolf

2009-09-20 Thread Jaroslaw Staniek
2009/9/20 Stefan Majewsky :
> Hi again,
>
> I've looked into the source of KoProperty, and tried if I can get KoProperty
> to build standalone (only with KDE 4 dependencies loaded) in a quick-and-dirty
> way. What I've noticed immediately:
>
> 1. Some parts of KoProperty seem to depend on other code from Kexi:
>a) EditorView.cpp includes kexiutils/styleproxy.h
>b) editors/spinbox.cpp needs the KoUnit class

I am copying the class then, hopefully today.

> 2. It still needs Qt3Support:
>a) Property.{h,cpp} use QVariant::{CString,PointArray}
>b) editors/pixmapedit.cpp needs some old Qt::WindowType values

Please let me look at this today...

> What can we do to sort out these issues? They're blocking me from building
> KoProperty without Kexi.
>
> BTW another question on the build process: Once we get KoProperty to the point
> that it does not need Kexi anymore, I could simply include it into the Kolf
> repository with an svn:externals definition. Is this okay for you?

OK, unless you want to release Kolf in a binary form. Then we'll have
conflict between KOffice and Kolf.
So I propose to svn branch and merge changes (there will not be too
many I guess?).

Two copies won't be needed once we move the code to the outside of
kolf and koffice (but where?).

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Using KoProperty in Kolf

2009-09-20 Thread Jaroslaw Staniek
OK,
Stefan, I've just commited a fix for qt3 dependency and removed
(unused anyway) dependency on styleproxy.
If there are other issues, you may want to fix them e.g. by disabling
some editors, e.g. those that depend on kobase library (KoUnit class).
We'll move such things to a separate plugin I guess.

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Using KoProperty in Kolf

2009-09-20 Thread Jaroslaw Staniek
2009/9/20 Stefan Majewsky :
> Am Sonntag 20 September 2009 21:38:26 schrieb Jaroslaw Staniek:
>> > What can we do to sort out these issues? They're blocking me from
>> > building KoProperty without Kexi.
>> >
>> > BTW another question on the build process: Once we get KoProperty to the
>> > point that it does not need Kexi anymore, I could simply include it into
>> > the Kolf repository with an svn:externals definition. Is this okay for
>> > you?
>>
>> OK, unless you want to release Kolf in a binary form. Then we'll have
>> conflict between KOffice and Kolf.
>
> The first release of Kolf will most definitely be with KDE/kdegames 4.4. Until
> then, a better solution than svn:externals should be available. For now, we
> could also change KoProperty into a static lib, and not install the library
> and its headers, in order to avoid conflicts? (Is KoProperty used anywhere
> outside Kexi at the moment?)

I try to avoid static libs because this increases link time on any
platform I know, what sucks.
I have another idea: what if I move my cmakelists.txt out of the dir
and you will use svn:externals and copy of the cmakelists.txt file
with just changed library name?
Then I also propose to remove the install( FILES ***.h ... ) section.
We'd avoid conflicts this way I guess.

>
>> Two copies won't be needed
>
> svn:externals is not a copy. It is a special property for a subdirectory of an
> SVN repository, that tells SVN to checkout this part of the repository from
> some other repository (and commit changes to there also). Much like a symlink.

sure but I mean copies of installed libs - that would be a conflict,
two libs with the same name and set of headers

>
>> once we move the code to the outside of
>> kolf and koffice (but where?).
>
> The obvious places would be kdelibs, or kdesupport if the library becomes Qt-
> only. We could also try to get it merged into Qt, if the Qt guys are
> interested in it.

I hope kdelibs wont become such a kitchen sink for everything we have..
It is already enough to use it on stripped down installations and on the mobile.

So yes, I wish we had the lib in kdesupport.

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Using KoProperty in Kolf

2009-09-20 Thread Jaroslaw Staniek
2009/9/21 Stefan Majewsky :
> Another idea: We use the same CMakeLists, but in the parent directory of
> KoProperty, we define some variable ${KOPROPERTY_TARGETNAME}, which is used
> anywhere in the CMakeLists instead of the target name "koproperty". This
> should make it easier to keep the CMakeLists in sync (e.g. if I want to add or
> remove some files from the build) while avoiding conflicts. I would set the
> variable to something like "kolfproperty" then, while you stay with
> "koproperty".

OK, feel free to commit this change (assuming you also commit addition
to koffice/kexi/CMakeLists.txt).

>> Then I also propose to remove the install( FILES ***.h ... ) section.
>> We'd avoid conflicts this way I guess.
>
> +1

I mean rather: comment out them. I also don't need to install them in
case of kexi.

>> I hope kdelibs wont become such a kitchen sink for everything we have..
>> It is already enough to use it on stripped down installations and on the
>>  mobile.
>
> If only kdelibs was as modular as Qt.
>
>> So yes, I wish we had the lib in kdesupport.
>
> Okay, noted inside my brain. I'll not insert any KDE dependencies.

Actually we have them, but as said, can be moved to separate libraries
providing factory(ies).
So you can do the same if you need editors that are even dependent on Kolf.

Also regarding being part of Qt - I don't think so, since the generic
answer so far was "we have already propety editor provided by
Designer".
IIRC there was 1 additional project (or even 2) in Qt Solutions, looks
like dropped already.

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] KOffice for Windows nightly build status page

2009-10-09 Thread Jaroslaw Staniek
Hi,
As announced at [1] there's Windows nightly build status page [2] for
various KDE modules, including KOffice (scroll to the bottom).
All compiled against KDElibs trunk with 2 compilers. Kudos to Patrick,
and the Windows team, and of course to qtdf (hosting)!
You can ping me about build errors (until there's email
notification...), I try to fix quickly just like I did (I hope) today
for mingw.

[1] http://winkde.org/pub/kde/ports/win32/dashboard/
[2] http://saroengels.blogspot.com/2009/10/build-server-web.html

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] LinkedIn Group: Kexi - Next Generation Desktop Databases

2009-11-20 Thread Jaroslaw Staniek
Hi,
Just created LinkedIn Group: Kexi - Next Generation Desktop Databases

This group has been provided for Kexi users and developers to enable
sharing knowledge and ideas for further development of the next
generation desktop database solutions. You're welcome to join!

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] Fwd: Kexi development

2009-12-22 Thread Jaroslaw Staniek
-- Forwarded message --
From: Jaroslaw Staniek 
Date: 2009/12/22
Subject: Re: Kexi development
To: Bob Mesibov 

2009/12/22 Bob Mesibov :
> Hi, Jaroslaw.
>
> I came to Kexi 1.1.3 (running through Gnome on Ubuntu 9.10) after a long 
> period of struggling to make sqlite usable with its various SQL-type 
> front-ends. Too hard! I'm a zoologist, and I now use Kexi to manage and 
> report from 4 tables:
>
> - a ca 500-record table of scientific names
> - a ca 5200-record of specimen collecting events
> - two ca 5000-record tables of specimen lots in museums. These two tables 
> each share a field with the names and events tables, so that I can query a 
> specimen lot in either table and also get full name and event data for the 
> records queried.
>
> Kexi is excellent! It's at least as easy to use as FileMaker Pro, and I find 
> it much easier on the eyes (see attached screenshot).
>

Dear Bob,
It is great to hear kind words from you, and I am glad you have found
use case for Kexi.

> I would be very interested to hear where Kexi 2 is going, and would be happy 
> to be an end-user tester, if you need one.

Kexi 2.2. will be the firtst release in series 2.x, to be shipped with
KOffice 2.2 around May 2010.
http://wiki.koffice.org/index.php?title=Schedules/KOffice/2.2/Release_Plan

It is still vital project, vital within KOffice and KDE.

Regarding tests, so far users that do not compile the program have
limited access to it. Once Kexi is released as beta version so I
forecast Ubuntu may ship it eg. within Kubuntu.
It is also good idea to find contributor that will create binary
packages for Kexi earlier, i.e. also for alpha versions.
There wouldn't be any conflicting version with 1.1.x series.

What I think about is to request some support from the community for
creating operating system image for virtualbox (or vmware) with test
version of Kexi. I guess such tool could be good for testers...

> At this early stage, the only items on my wish-list are probably already on 
> your to-do list 
> (http://kexi-project.org/wiki/wikiview/index@currenttasks_jstaniek.html).

The pages are quite outdated as you may imagine, as a temporary tool
we use http://wiki.koffice.org/index.php?title=Kexi
I am sorry about not communicated that clearly.

New pages that probably may be interesting for you are as follows:

http://wiki.koffice.org/index.php?title=Kexi/Releases/Kexi_2.2
http://wiki.koffice.org/index.php?title=Kexi/TODOs - includes long-term TODOs

> These are:
>
> 1. allow relationship-building without having to create a query

This is a TODO after 2.2, the reason for delay is that different
database backends have different behaviour regarding relationships.
And relationships are quite hard to glue well to the GUI. The top
priority is any feature is to assure users will not lose their designs
and data.

> 2. allow saving of a query as a database object [So far as I can see, I can 
> only save a query result by exporting it to .csv]

I think you mean saving the results of running the queries?
Something like "Data insertion query (INSERT INTO)" or "Table creation
query (CREATE TABLE)" (also: DELETE query).
That could be good idea indeed -  I see a lot of uses for that (I've
been using that a lot in my MS Access days in the previous century ;)
).

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Kexi development

2009-12-22 Thread Jaroslaw Staniek
2009/12/22 Bob Mesibov :

[..]
> I've bookmarked the new TODO, etc and also subscribed to the Kexi list. Since 
> I am not a programmer, perhaps I can help in future with writing the 
> Help/Handbook?
>

Bob,
That's good idea. As you know kexi 1.x has a small handbook.
I do not plan to update it for 1.x for obvious reasons (2.x series are coming).
On the other hand, the user interface of 2.x is not completed.
Having this in mind of course if you feel quite strong about creating
kexi 2.x documentation for end-users.
You can start with a plain text. If it's to early for you, since I
heard you have no access to kexi 2.x; I suggest to wait with that for
stable version.

> "I think you mean saving the results of running the queries? Something like 
> "Data insertion query (INSERT INTO)" or "Table creation query (CREATE TABLE)" 
> (also: DELETE query)."
>
> Yes, exactly.

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] The Kexi Project's Twitter Channel

2009-12-22 Thread Jaroslaw Staniek
Kexi Project on Twitter:
Now you can hear the latest news from the Kexi Development front at
http://twitter.com/kexi_project :)
If you do not want to use a twitter account, the option is to
subscribe to this RSS feed
http://twitter.com/statuses/user_timeline/98714604.rss

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Kexi-mdb-plugin with Ubuntu 9.10

2009-12-23 Thread Jaroslaw Staniek
2009/12/23 Move Offshore :
>  Thanks for Kexi.  Great package alternating MSACCESS.  I could use Kexi
> to import MSAccess in Ubuntu 9.04 but this importing plugin is not working
> in Ubuntu 9.10.  Please help me.

Is this because the package cannot be found in 9.10? Alternatively you
could just download the 9.04 package to your local and install by
typing (I guess) this command-line command:
dpkg -i filename.deb.

If this fails or is too hard please ask on an ubuntu forum. There is
also KOffice forum: http://forum.kde.org/viewforum.php?f=96

> And I couldnt see any report creation tool
> in Kexi 1.1.3 (KOFFICE 1.6.3).

1.1.x series only offer simple printouts, after you open table or
query (Print/print preview in file menu).

>
> Can i use report creation plugin separately, if yes please help me where can
> i get report creation plugin for Kexi.

The new reports are only compatible with Kexi 2.2 or newer, unreleased yet.

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] Kexi at the KOffice Forum

2009-12-23 Thread Jaroslaw Staniek
Hi,
Forum lovers can also ask for support at KDE's KOffice Forum:
http://forum.kde.org/viewforum.php?f=96 (registration needed)

-- 
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@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Boolean criteria in query

2010-02-19 Thread Jaroslaw Staniek
On 19 February 2010 12:21, Guillermo Molleda Jimena  wrote:
> Only say that in Kexi (1.1.3) is impossible do a query with boolean
> criteria.
>
> You could view the screenshot.PNG from M$ Access with OR, AND and other
> powerful tools (BETWEEN, ...)

Thanks for the info!
That's true for now and already known. One needs to work in SQL view
to use complex expressions. Then save the query and do not move to
design view to avoid destroying the expressions.
The same parser that is used in the SQL view will be used in the
criteria column of the design view, I hope in Kexi 2.3.

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


[Kexi] Kexi in February

2010-03-02 Thread Jaroslaw Staniek
http://www.kdedevelopers.org/node/4175

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


[Kexi] [forum] Kexi and external databases

2010-03-06 Thread Jaroslaw Staniek
http://forum.kde.org/viewtopic.php?f=96&t=86304&p=150408#p150408

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


Re: [Kexi] Thanks for Kexi!

2010-03-19 Thread Jaroslaw Staniek
On 19 March 2010 06:14, Mark Barazzuol  wrote:
> I stumbled upon Kexi when desperate for a MsAccess type of solution for
> linux.  While I'm checking out version 1.1.3, I'm very impressed with what
> you have and what you are planning.  Some features are already easier and
> simpler than Access.    I'm even more surprised when I see how small your
> team is.  So thank you for doing this.
>
> I find I'm waiting for two features before I dive in.
>
> The first is more event hooks for the forms.   I'm really happy to see you
> are doing those.
>
> The second is another scripting option than Ruby or Python.  I was wondering
> why you guys didn't choose something similar in structure to C as it seems
> to be the best known, and may provide the lowest barrier of entry.
> Javascript may do the trick.   I just need it better explained how to hook
> them up to events, buttons etc.  And clearer examples of how to create a
> dynamic SQL statement for running queries, updating / deleting rows etc.
>
> I'm looking forward to Kexi 2.2.   Please keep up the hard work.  And thank
> you again.

Mark, thanks for your kind words!
Scripting in javascript is possible using (via
http://techbase.kde.org/Development/Languages/Kross) however it needs
polishing and dedicated users that work with us actively on improving
things. Also the documentation (it's easy to contribute on userbase
wikis!)

As for hooks in forms - my personal goal here is to let the user
forget about scripting as long as possible, thus having more friendly
solution than MSA where in order to have e.g. a tree widget, one needs
to load DLL/OCX and use fragile and complex VBA-VB bridges.

You're invited to https://mail.kde.org/mailman/listinfo/kexi mailing
list and the #kexi IRC channel.

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


[Kexi] Kexi, Kivio, Kontact and other productivity apps reviewed by linux.com

2010-03-19 Thread Jaroslaw Staniek
Kexi, Kivio and other productivity apps reviewed by linux.com:

http://www.linux.com/news/software/applications/294573-10-free-productivity-tools-for-linux-

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


Re: [Kexi] Kexi with QT only

2010-04-02 Thread Jaroslaw Staniek
On 2 April 2010 09:57, Giuseppe Torelli  wrote:
> Kexi is a GREAT software for Linux. An Access alternative was really
> missing before Kexi came to existence. However to use Kexi you have to
> install a bunch of KDE libraries and those Linux users like who don't
> use neither GNOME or KDE to use Kexi have to install a LOT of packages
> only to use one software.

Hi Giuseppe
To be clear: Kexi is KDE application. KDE no longer means K Desktop
Environment, but just KDE.
Thus Kexi depends on some KDE and KOffice libraries exactly as you
noted. These libraries extend (not replace) Qt in many areas. If one
would write app like Kexi from scratch using Qt only, most of the
libraries it needs would have to be  reimplemented or copied. Yet,
users would end up with more libraries loaded in their systems, not
less. How is that possible?
The simple answer is: sharing. KDE applications share common
libraries, or graphics, or even message translations, that in turn are
loaded only once on your system. And this is also e.g. why KOffice
takes a fraction of space that is needed for openoffice.org.

Really, only small applications rewrite everything from scratch, and
the level of integration is poor, e.g. no mime types are properly
handled, settings system is unfamiliar...

At operating system level, what you need to run is just X11 with
window manager (I am sure you know this very well but I mention that
to others). Kexi, like most of KDE apps, does not limit you in
regarding your desktop. So desktop (kde workspace) is not a dependency
and is not installed.
Also, packaging systems install only needed parts, some of them are
large (well, not anymore in 2010) - like icons (shared between apps) -
but how we're talking about GUI program. Kexi itself is even clearly
splitted into packages so users can install only needed components (we
openly work with Linux/Windows/etc. distribution makers to handle that
well - example document: [0])

I strongly encourage users that do not install KDE/Gnome Desktops to
use Kexi, and share the experiences. We can improve  integration
together - but only if we know the issues or wishes. Maybe something
can be improved in packaging at KDE level too. An example of how
stripping down of applications is possible, is the Fremantle Office -
KOffice compilation for maemo (later: MeeGo) mobile phones [1]. It
fits on the phone obviously without Gnom/KDE desktop :)
That said, much of the work is also on  the distributors side, not the
developers.

You're welcome to the Kexi mailing list [2]. There's also KOffice
mailing list [3].

[0] http://websvn.kde.org/*checkout*/trunk/koffice/README.PACKAGERS
[1] http://www.koffice.org/news/office-viewer-for-maemo5-based-on-koffice/
[2] https://mail.kde.org/mailman/listinfo/kexi
[3] https://mail.kde.org/mailman/listinfo/koffice

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


Re: [Kexi] Kexi with QT only

2010-04-02 Thread Jaroslaw Staniek
On 2 April 2010 11:14, Giuseppe Torelli  wrote:
> On Fri, Apr 2, 2010 at 10:56 AM, Jaroslaw Staniek  wrote:
>> At operating system level, what you need to run is just X11 with
>> window manager (I am sure you know this very well but I mention that
>> to others). Kexi, like most of KDE apps, does not limit you in
>> regarding your desktop. So desktop (kde workspace) is not a dependency
>> and is not installed.
>> Also, packaging systems install only needed parts, some of them are
>> large (well, not anymore in 2010) - like icons (shared between apps) -
>> but how we're talking about GUI program. Kexi itself is even clearly
>> splitted into packages so users can install only needed components (we
>> openly work with Linux/Windows/etc. distribution makers to handle that
>> well - example document: [0])
>
> Thank you for your detailed answer, I appreciated that but:
>
> g...@gt-desktop:~$ sudo apt-get install kexi
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> The following extra packages will be installed:
>  exiv2 kde-icons-oxygen kdebase-runtime kdebase-runtime-bin-kde4
> kdebase-runtime-data kdebase-runtime-data-common kdelibs-bin
> kdelibs-data kdelibs4c2a kdelibs5 kdelibs5-data
>  khelpcenter4 koffice-data koffice-libs libavahi-qt3-1
> libclucene0ldbl libexiv2-5 libknotificationitem1 liblua50 liblualib50
> liblzma0 libplasma3 libpq5 libpqxx-2.6.9ldbl
>  libqt3-mt libqt4-qt3support libraptor1 librasqal1 librdf0
> libsoprano4 libstreamanalyzer0 libstreams0 libxcb-shape0 libxcb-shm0
> libxcb-xv0 libxine1 libxine1-bin libxine1-console
>  libxine1-misc-plugins libxine1-x phonon-backend-xine raptor-utils
> redland-utils soprano-daemon
>
> The following NEW packages will be installed:
>  exiv2 kde-icons-oxygen kdebase-runtime kdebase-runtime-bin-kde4
> kdebase-runtime-data kdebase-runtime-data-common kdelibs-bin
> kdelibs-data kdelibs4c2a kdelibs5 kdelibs5-data
>  kexi khelpcenter4 koffice-data koffice-libs libavahi-qt3-1
> libclucene0ldbl libexiv2-5 libknotificationitem1 liblua50 liblualib50
> liblzma0 libplasma3 libpq5 libpqxx-2.6.9ldbl
>  libqt3-mt libqt4-qt3support libraptor1 librasqal1 librdf0
> libsoprano4 libstreamanalyzer0 libstreams0 libxcb-shape0 libxcb-shm0
> libxcb-xv0 libxine1 libxine1-bin libxine1-console
>  libxine1-misc-plugins libxine1-x phonon-backend-xine raptor-utils
> redland-utils soprano-daemon
> 0 upgraded, 45 newly installed, 0 to remove and 0 not upgraded.
> Need to get 69.0MB of archives.
>
> Let's leave xine packages and the others apart but have you noticed I
> am forced to install:

I am not sure xine is needed, could be solved by KDE team and the
packagers team.

> exiv2 kde-icons-oxygen kdebase-runtime kdebase-runtime-bin-kde4
> kdebase-runtime-data kdebase-runtime-data-common kdelibs-bin
> kdelibs-data kdelibs4c2a kdelibs5 kdelibs5-data khelpcenter4
> koffice-data koffice-libs?

I understand your concerns, but if one day you use more than one KDE
app on your non-KDE system, the investment shall pay off. I have had
packaged Kexi 1.x on Windows, which looked a lot like Qt-only app from
your perspective, and you know what? It took itself about 20MB
compressed. So even for 4 such "statically bundled" apps we would
already have consumed 80MB of archives. Example of openoffice.org
shows the case of "statically bundling" - it carries everything with
is, from the display subsystem to the file format handling routines.
No single other app on your computer will use these binaries. For
KDE/KOffice libs you have at least chances for that...

Icons are a must as I said. Also the help center. The data packages
are for infrastructure like mime types handling.
kdebase-runtime is the runtime only, kdebase-workspace makes the
actual KDE Desktop, and is not forced.
The split is exactly for your convenience. I wouldn't worry about the
number of packages (it is exactly the result of fine-grained split).
The sum of 69MB is even smaller than openoffice.org, not mentioning
base java packages... Quite a good match for a runtime component that
is a base for hundred+ apps.

Important reason for troubles in supporting Qt-only versions of a
bigger application is compatibility. If I create a .kexi file with the
full version of Kexi (even if not run Kexi under the KDE Desktop), and
send the file to you, you may be not able to install all the
components (not everything is possible to be Qt-only), and then the
.kexi file won't be fully functional for you. To my understanding that
would be quite a big cost compared to using several dozens of
megabytes of your RAM or hard disk...

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


Re: [Kexi] Sample database

2010-06-02 Thread Jaroslaw Staniek
On 3 June 2010 00:42, Manfred Jung  wrote:

> I wonder if creating and documenting another sample database would be of
> interest for the http://userbase.kde.org/Kexi/Tutorials page.
>
> If that is OK then I would be willing to create one or a few. My idea
> instead of developing one full fledged database is to create samples in
> module form that show of specific features. So that new users can look up ho
> to do certain things in kexi. Nevertheless each feature demonstration would
> result in a functional database app.
>
> My first idea would be to create a switchboard type of main menu showing how
> you can open and close a number of forms and show a report.

Good idea!

> Second one would be to demonstrate a flat file database.

Please note that SQLite is not a flat file database, it's an optimized
file database.
(in case you plan to refer to this specific feature)

> Third one would be to show a relational database. Illustrating how one can
> select records from a related table and link them to the main record.
> Then a drill down feature
> etc.

Good one.
As for 2.2., just please note that this is only possible using query
(and results are not editable for now).
Filters aren't present nor subforms.

> I would be willing to do this with step by step documentation provided that
> where I need help I can write to the developers for help. This is specially
> true if for some unknown reason Kexi crashes at a particular point in a
> reproducible and predictable pattern. Or when there is just no documentation
> about a feature yet that would be part of the database and I need to get the
> info to actually complete a particular step.
>
> Now I know the developers are quite busy and my intention is not to tie down
> their creative time. there fore I would keep my requests to an absolute
> necessary minimum.

You can keep the intermediate result of your work on the wiki, as it's
the goal of the site :)

PS: cc'd to kexi@kde.org, you can continue to write there too so
others are informed.

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


Re: [Kexi] Relationship plugin

2010-07-06 Thread Jaroslaw Staniek
On 7 July 2010 00:36, Adam Pigg  wrote:
> Hey, just flicking through the TODOs, and i wondered, does the relationship
> plugin actually enforce any referential integrity, or is it just for viewing
> purposes?

Hi,
The right word is DID not DOES :)
Relationships plugin was disabled just after we started to use kexidb.
The idea is enforce integrity, yes. However the first step would be to
show them, if there are any.
Changes to kexidb would be a must (and then: drivers), we have to know
what is the scope of the changes so it's good idea to note them down.
We're not in comfortable position since that would happen outside of
Predicate and merging would be needed. I understand however that we
cannot block features because Predicate move takes so much time

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


Re: [Kexi] [Bug 244420] Kexi mdb import crashes when transferring data to target

2010-07-19 Thread Jaroslaw Staniek
2010/7/19 Steve Dowe :
> Hi Jaroslaw,
>
> Wow, that was quick work.  How can anyone not love open source with
> turnarounds this quick?! :-D
>
> Ok, I think I'm going to download the development branch of KOffice and
> compile from that.  I'm going from instructions on the Wiki:
> http://wiki.koffice.org/index.php?title=Building/Building_KOffice
>
> Will your fix be included in this?

Yes, thanks.

PS: please use kexi@kde.org so everyone can benefit from the info.

>
>
> Thanks again - I feel a praiseworthy blog coming on ;)
>
> Steve
>
> On 18/07/10 23:10, Jarosław Staniek  wrote:
>> https://bugs.kde.org/show_bug.cgi?id=244420
>>
>>
>>
>>
>>
>> --- Comment #4 from Jarosław Staniek   2010-07-19 00:10:51 
>> ---
>> Steve,
>> Big thanks for your test data. There appears to be pilsarticles.HTMLText memo
>> field that contains more than 16KB of data.
>> The above fix adds support for <=64KB of data per value.
>> You can use the source from KDE SVN or apply these patches to your code:
>>
>> http://websvn.kde.org/trunk/koffice/kexi/migration/mdb/src/keximdb/mdbmigrate.cpp?r1=1089606&r2=1151354&pathrev=1151354&view=patch
>>
>> http://websvn.kde.org/trunk/koffice/kexi/migration/mdb/src/mdbtools/libmdb/data.c?r1=1021308&r2=1151354&pathrev=1151354&view=patch
>>
>> PS: I noticed that the display routines of table view is not optimized for 
>> such
>> large text values. Optimizing this remains as a TODO.
>>
>
> --
> Steve Dowe
> Web Developer / Red Hat Certified Engineer
>
> One Cool Ltd is registered in England and Wales, company no. 4323680
> 42 Alexandra Road, Farnborough, GU14 6DA. VAT no. GB 777 0935 89
> http://www.onecool.com M:07855 955951 T:08456 807805 F:07006 049413
>



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


Re: [Kexi] [Bug 244420] Kexi mdb import crashes when transferring data to target

2010-07-19 Thread Jaroslaw Staniek
On 19 July 2010 10:34, Steve Dowe  wrote:
> On 19/07/10 08:31, Jaroslaw Staniek wrote:
>>> Ok, I think I'm going to download the development branch of KOffice and
>>> compile from that.  I'm going from instructions on the Wiki:
>>> http://wiki.koffice.org/index.php?title=Building/Building_KOffice
>>>
>>> Will your fix be included in this?
>>
>> Yes, thanks.
>>
>> PS: please use kexi@kde.org so everyone can benefit from the info.
>
> Sorry, I didn't mean to exclude the list.
>
> I'm having one problem building koffice from source.  I've followed the
> instructions on the wiki, but when I type
>
> # cmake -DCMAKE_INSTALL_PREFIX=$HOME/kde4/inst $HOME/kde4/src
> -DCMAKE_BUILD_TYPE=RelWithDebInfo
>
> I get
>
> CMake Error: The source directory "/home/kde-devel/kde4/src" does not
> appear to contain CMakeLists.txt.
> Specify --help for usage, or press the help button on the CMake GUI.

Sorry, there are bugs on the page. I hope I fixed them now.
The thing is that the command should be:

cmake -DCMAKE_INSTALL_PREFIX=$HOME/kde4/inst $HOME/kde4/src/koffice
-DCMAKE_BUILD_TYPE=RelWithDebInfo

(the directory with source code is $HOME/kde4/src/koffice, not $HOME/kde4/src)

Also added "cd $HOME/kde4/src" lines to the instructions.

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


Re: [Kexi] [Bug 244420] Kexi mdb import crashes when transferring data to target

2010-07-19 Thread Jaroslaw Staniek
On 19 July 2010 14:41, Steve Dowe  wrote:
> On 19/07/10 11:25, Jaroslaw Staniek wrote:
>> Sorry, there are bugs on the page. I hope I fixed them now.
>> The thing is that the command should be:
>>
>> cmake -DCMAKE_INSTALL_PREFIX=$HOME/kde4/inst $HOME/kde4/src/koffice
>> -DCMAKE_BUILD_TYPE=RelWithDebInfo
>>
>> (the directory with source code is $HOME/kde4/src/koffice, not 
>> $HOME/kde4/src)
>
> D'oh! I should have spotted that!
>
> Sadly I have one more problem. The cmake configure script can't find
> sqlite libraries.  I get:
>
> -- Could NOT find Sqlite  (missing:  SQLITE_INCLUDE_DIR SQLITE_LIBRARIES)
> -- SQLite NOT found
>
> I've installed all obvious packages in Fedora.  Either I haven't
> installed the right one or the path isn't being set properly.

You need sqlite and sqlite-devel packages, version >= 3.6.16.

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


Re: [Kexi] [Bug 244420] Kexi mdb import crashes when transferring data to target

2010-07-21 Thread Jaroslaw Staniek
On 21 July 2010 15:37, Steve Dowe  wrote:
> On 19/07/10 11:25, Jaroslaw Staniek wrote:
>> Sorry, there are bugs on the page. I hope I fixed them now.
>> The thing is that the command should be:
>>
>> cmake -DCMAKE_INSTALL_PREFIX=$HOME/kde4/inst $HOME/kde4/src/koffice
>> -DCMAKE_BUILD_TYPE=RelWithDebInfo
>>
>> (the directory with source code is $HOME/kde4/src/koffice, not 
>> $HOME/kde4/src)
>
> D'oh! I should have spotted that!
>
> Sadly I have one more problem. The cmake configure script can't find
> sqlite libraries.  I get:
>
> -- Could NOT find Sqlite  (missing:  SQLITE_INCLUDE_DIR SQLITE_LIBRARIES)
> -- SQLite NOT found
>
> I've installed all obvious packages in Fedora.  Either I haven't
> installed the right one or the path isn't being set properly.
>
> Could you tell me an example file that is required for Kexi to compile?
>  I'll then be able to search for the correct package using yum.

If you installed sqlite and sqlite-devel packages, try to remove all
files from your build directory and repeat the compilation.
Maybe cmake caches the information about missing dependencies.

/usr/include/sqlite3.h is needed, proveded by sqlite-devel.
/usr/lib/pkgconfig/sqlite3.pc is needed too.
/usr/lib/libsqlite.so.0 is needed too.
-- 
regards / pozdrawiam, Jaroslaw Staniek
 http://www.linkedin.com/in/jstaniek
 Kexi & KOffice (http://www.kexi-project.org, http://www.koffice.org)
 KDE Software Development Platform on MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Kexi information

2010-07-21 Thread Jaroslaw Staniek
On 21 July 2010 19:36, Jeff Mitchell  wrote:
> Jaroslaw,
>
> Are you able to help Ryan?
>
> Thanks,
> Jeff
>
>  Original Message 
> Subject:        Kexi information
> Date:   Wed, 21 Jul 2010 08:46:07 -0700
> From:   Ryan Larkin-Smith M.Ed. 
> To:     info-northamer...@kde.org
>
>
>
> Jeff, Thanks for your time this morning. I am looking for an alternative
> to Filemaker Pro and was looking at Kexi. I would like to talk to
> somebody that could help me understand how it works and what it's
> features are. Thanks for your help.

Hello Ryan,
You can start your research with
http://kexi-project.org/wiki/wikiview/index@kexifeatures.html

Kexi is more like MS Access. GLOM is more like Filemaker if similarity
is the priority for you.

PS: There is no import from Filemaker.

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


[Kexi] Web Acces (was: Info request)

2010-08-17 Thread Jaroslaw Staniek
On 16 August 2010 12:40, LIBERO  wrote:

> I would like to test your nice application Kexi.
> In past I did several small project using ms access and I hope to be able to
> use Kexi in future.
> The main question is about use of Kexi within a network.
> As you know using Ms Access in network from different PC is one of the most
> critical aspect .
> Before to start study Kexi I would be sure don't have surprise at the end
> about performance and band occupation and speed.
>
> I'm not a programmer and I hope my question are not stupid ones.
> Is there any possibility to use Kexi using web browser ?

Hi!
We have been working on Kexi Web Forms that offer such features, for
Kexi 1.x series. This is disabled for versions 2.x however. We plan to
in later releases but most probably not in 2010.

Links: http://www.kexi-project.org/wiki/wikiview/index@web.html

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


Re: [Kexi] Kexi file and Sqlite3 ODBC driver

2010-09-02 Thread Jaroslaw Staniek
On 2 September 2010 09:19, Noli Sicad  wrote:
> Hi,
>
> It seems that kexi file could not be read by sqlite3 odbc driver.
> However, it can be read / write by sqlite3 and spatialite in terminal
> - CLI
>
> See the error below
> ~~
>
>>glpsol --cover --clique --gomory --mir -m "transp_sqlite3_kexi.mod"
> GLPSOL: GLPK LP/MIP Solver, v4.44
> Parameter(s) specified in the command line:
>  --cover --clique --gomory --mir -m transp_sqlite3_kexi.mod
> Reading model section from transp_sqlite3_kexi.mod...
> Reading data section from transp_sqlite3_kexi.mod...
> 93 lines were read
> Reading plants...
> Connected to SQLite 3.6.22 - glpk.kexi
> SELECT PLANT, CAPA AS CAPACITY FROM transp_capa
> transp_sqlite3_kexi.mod:18: field PLANT missing in input table
> MathProg model processing error
>>Exit code: 1    Time: 0.042

Hi Noli,
Is the 'field PLANT missing in input table' error related to Kexi at all?
Kexi uses unpatched sqlite3 that is present in your operating system.

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


Re: [Kexi] Python Script and Kexi2.2

2010-09-02 Thread Jaroslaw Staniek
On 2 September 2010 04:56, Noli Sicad  wrote:
> Hi,
>
> I am searching the net for Python and Kexi2.2. It seems no entry. Is
> python script working in Kexi2.2?

No, this addition and scripts for other languages is planned to be
available again in 2.4.

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


Re: [Kexi] No urgency to enable kexi to create composite primary keys -Must be another way then?

2010-09-02 Thread Jaroslaw Staniek
On 2 September 2010 18:09, msjs08  wrote:
>
> Hi All
> There seems not to be urgency to enable kexi to create composite primary keys.
> Then there must be another way to do the following three tables?
> I thought you could only do it via a composite primary key.
>
> Many plants can have the same common name and many plants can have many 
> common names.
> (I created the original layout for OOOBase)

Max,
I understand your need. Using composite keys for many-to-many
relationships can add extra safety but in absence of the feature
things can still work.

However even without I wonder how to present. There are no subforms
that would present you common names for selected plant. Similarly
there is no way to add a button displaying, say, form with common
names for selected plant. Not yet.

I see this addition very important anyway.
There are plans to design many-tom-many relationships directly in
kexi, i.e. without even thinking about PlantComName.

It's good idea to report a wish for the feature at
https://bugs.kde.org and vote for it (there's "Vote" link for each
wish).
The list of current wishes for Kexi is: http://bit.ly/9xInzW

Thanks for your contributions!

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


Re: [Kexi] Python Script and Kexi2.2

2010-09-03 Thread Jaroslaw Staniek
On 3 September 2010 10:32, Adam Pigg  wrote:
> Scripts should be available in any languages supported by Kross.
>
> On my system i have python and javascript/qtscript (qtscript is better!).
>
> I just choose to write in js in the examples because i dont know python :)
>

Of course, I misunderstood.

So, there's a fresh example from Adam (but in Javascript):

http://kde-files.org/content/show.php?content=129683
-- 
regards / pozdrawiam, Jaroslaw Staniek
 http://www.linkedin.com/in/jstaniek
 Kexi & KOffice (http://kexi-project.org, http://identi.ca/kexi,
http://koffice.org)
 KDE Software Development Platform on MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


Re: [Kexi] Geting Kexi2.2 SVN source only for patching purposes

2010-09-20 Thread Jaroslaw Staniek
On 20 September 2010 07:28, Noli Sicad  wrote:
> Hi,
>
> It seems that this instruction is just patching,
>
> http://kexi-project.org/wiki/wikiview/index@kexi2.2_patches.html#msaccess_large_memo
>
> I think a lot of problem getting this done. I don't have even Qt build system.
>
> Any compiled binary that we can download just to use the new feature / fixes.

Hi Noli,
I think the most efficient way would be to ask maintainer of your
package to apply the patch.
I announced availability of all the patches ASAP on proper announcement channel.

-- 
regards / pozdrawiam, Jaroslaw Staniek
 http://www.linkedin.com/in/jstaniek
 Kexi & KOffice (http://kexi-project.org, http://identi.ca/kexi,
http://koffice.org)
 KDE Software Development Platform on MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] Re: Installing Kexi

2010-09-29 Thread Jaroslaw Staniek
On 29 September 2010 14:12,   wrote:
>
> I've no experience of Linux but I have a SmartQ tablet running Linux and I
> wanted to install Kexi
>
> I've downloaded the koffice-1.6.3.tar.bz2 and placed on the SD card of the
> gadget, but I'm not sure what to do next. When I click on that file i get a
> winzip-type window opening asking if I wish to extract the files.
>      Do I extract them somewhere and then is there a kind of 'setup' or
> 'install' file I run or

Hi Roger,
There are no details about what the device has inside and whether it's
exatendable. You may need to contact the vendor to ask about
installing third party applications and Kexi in particular. Kexi
project does not deploy software, it provides it to vendors in the
source form.
I think the device you have is not a full PC-type device and does not
run standard operating system.
Idea of running Kexi 2.x on smaller form-factor devices is more than
interesting and we have some plans for the forthcoming development.

-- 
regards / pozdrawiam, Jaroslaw Staniek
 http://www.linkedin.com/in/jstaniek
 Kexi & KOffice (http://kexi-project.org, http://identi.ca/kexi,
http://koffice.org)
 KDE Software Development Platform on MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] Re: Installing Kexi

2010-09-29 Thread Jaroslaw Staniek
On 29 September 2010 15:04,   wrote:
> Thank you for replying so quickly Jaroslav
>
> The SmartQ is an iPad clone with a triple boot (Android, WinCE, Linux -
> debian, I think)
>
> I runs AbiWord and some other applications and I was quite keen to manage a
> run a small relational database on it, but if it isn't to be...

It's all technically possible, I found this:
"The Linux firmware that comes with the Q5/7 and V5/7 devices is an
Ubuntu 9.10 (Karmic Koala) build"
at http://www.smartqmid.com/wiki/index.php?title=Linux

And I found this:
http://www.smartqmid.com/wiki/index.php?title=Smarq_specific#Software_building

You could try to find package manager and see if debian packages for
the ARM (?) architecture work.
Or use command line apt-get tools (or dpkg if you have .deb file for
kexi and its dependencies).

But as I see no kexi packages for ubuntu 9.10 on ARM
(http://packages.ubuntu.com/karmic/kexi), someone needs to build it.
It's good idea to contact the ubuntu developers reguralry and request
the packages. Please inform us about any success, so
http://userbase.kde.org/KOffice/Download can be updated!

Regards!

-- 
regards / pozdrawiam, Jaroslaw Staniek
 http://www.linkedin.com/in/jstaniek
 Kexi & KOffice (http://kexi-project.org, http://identi.ca/kexi,
http://koffice.org)
 KDE Software Development Platform on MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] Re: Kexi 2.2.2 crashes when I am trying to create a text box

2010-10-05 Thread Jaroslaw Staniek
On 5 October 2010 20:34, Detlef Lechner  wrote:
> Hi!
>
> Kexi 2.2.2 under KDE 4.5.1 Trying to make a form. I was able to create a
> label. But when I am trying to create a text box and forming a
> cursor->eof rectangular outline on the form's surface, on releasing the
> left mouse key Kexi will crash. Is this a known bug?
> When I started Kexi in a terminal, after the crash I obtain: "QLayout
> Attempting to add QLayout "" to KexiFormView
> "Entwurfsansicht_for_fm2begriffe2010_object", which already has a
> layout. kexi(22247)/kexi (general) KFormDesigner::FormIOloadFormFromDom:
> original format is older than current: 2
> kexi(22247)/KexiDB KexiDB::Connection::querySingleString:
> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof()
> "SELECT o_data FROM kexi_objectdata WHERE o_id=17 AND
> o_sub_id='extended_schema' LIMIT 1".

Hello Detlef,
The defect is most probably reported in
https://bugs.kde.org/show_bug.cgi?id=247183

It may be fixed, we are waiting for feedback.
You can apply this patch: http://bugsfiles.kde.org/attachment.cgi?id=51871
(as described at
http://kexi-project.org/wiki/wikiview/index@kexi2.2_patches.html)
or wait for 2.3.0.

In any case I recommend to temporarily change style of your KDE
widgets to something other than Oxygen (in Personal
Settings->Appearance->Style) to see if the problem is related to
Oxygen.

-- 
regards / pozdrawiam, Jaroslaw Staniek
 http://www.linkedin.com/in/jstaniek
 Kexi & KOffice (http://kexi-project.org, http://identi.ca/kexi,
http://koffice.org)
 KDE Software Development Platform on MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] Re: [Kexi 2.2.2.] The find dialog doe not seem to find anything in my form

2010-10-05 Thread Jaroslaw Staniek
On 6 October 2010 07:27, Detlef Lechner  wrote:
> Hi!
>
> I created a (simple) form in Kexi 2.2.2. The »Find« dialog does not
> include a drop-down field "Look in". The find dialog doe not seem to
> find anything in my form. How can I make the Find dialog to find a
> string in the underlying table? (This was no issue in Keksi 1.1.3
> (KOffice 1.6.3 using KDE 3.5.10).

Hi,
Are you able to move between records on your form using the record
navigator at the bottom?
Find only works when data source is assigned to the form.

-- 
regards / pozdrawiam, Jaroslaw Staniek
 http://www.linkedin.com/in/jstaniek
 Kexi & KOffice (http://kexi-project.org, http://identi.ca/kexi,
http://koffice.org)
 KDE Software Development Platform on MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] Re: Dear Kexi Development Group

2010-10-13 Thread Jaroslaw Staniek
On 13 October 2010 17:55, Giovanni Corriga  wrote:
>  Dear Kexi Development Group,
>
> I send this email to ask you a question: how to solve the problem of the
> graphical interface of this DBMS in its current form if it were ported to
> Mac OS, given the existence of the porting of KDE libraries? The interface
> to the Ribbon, which can fit under Linux or Windows, does not work under
> Apple.

Dear Giovanni,
I agree that not having menu at all is not the way to go. It should be
enabled on Mac by default due to UI gudelines, and available to show
on the other OSes.
Apple has ribbon/side pane interface as well. it's based on drawers
and floating windows. The latter were always there,
For instance one can look at iWorks or Filemaker. The look is just
different but tabs and buttons are still there.
Sticking to just menus takes the power out of users unfortunately:
many menus of more complex applications are very big and thus
suboptimal to use.
What remains to do is actual applying native style and look to the Mac
port of Kexi.
I am open to guide developers willing to contribute in this area.
Currently I am not in permanent contact even with Mac users of Kexi 2.

-- 
regards / pozdrawiam, Jaroslaw Staniek
 http://www.linkedin.com/in/jstaniek
 Kexi & KOffice (http://kexi-project.org, http://identi.ca/kexi,
http://koffice.org)
 KDE Software Development Platform on MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] Re: Dear Kexi Development Group

2010-10-13 Thread Jaroslaw Staniek
On 13 October 2010 19:12, Giovanni Corriga  wrote:
>  Dear Kexi Development Group,
>
> thanks for your prompt reply.
> The fact that in future versions for Windows and Linux native Kexi menus can
> be enabled again is good news.
> With regard to what is said in the third paragraph of your response we
> agree: too complex applications with highly nested menus are often
> unsuitable for end users. If I remember correctly, a survey that was done
> years ago, it appeared that the mass of users using only 15% of the
> functionality of any program.
> But a problem arises: KDE standards and they must, or should I say should be
> followed.
> How to solve the problem?

The standard/guidelines would have to be extended.

> Lately KDE seems taken from the "not invented here syndrome." I also think
> of KDevelop. Throw away the work of so many years of development and start
> again, at least when you could save or update of the work done. There are
> the "Principle of the Pig" and "keeps things simple, stupid", if anyone
> remembers him. The fact is that since the user interface of KDevelop 4 I do
> not like, I decided to take the hand of the old code 3.5.5 and update
> everything. An infamous work if done alone.

Regarding KDevelop I am observing users of KDevelop on daily basis and
they are happy with the new interrface. Old one was suboptimal for
reasons I and you already have mentioned. I am not afraid of NIH
syndrome - KDevelop shares concept of views with Apple XCode, Eclipse
and recently Qt Creator, to name just these three. Kexi will
increasingly benefit from usage of views I hope.

> PS: I think I'll end up returning to Superbase type user interface for the
> Atari ST, or even further back, like Archive of old Sinclair QL. What
> memories.

Ah you met Atari fan here :)

PS: please use kexi@kde.org for the conversation.

-- 
regards / pozdrawiam, Jaroslaw Staniek
 http://www.linkedin.com/in/jstaniek
 Kexi & KOffice (http://kexi-project.org, http://identi.ca/kexi,
http://koffice.org)
 KDE Software Development Platform on MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] Re: How do I get old Kexi?

2010-10-15 Thread Jaroslaw Staniek
On 15 October 2010 04:35, Bob Mesibov  wrote:
> I upgraded to Linux Mint 9 from Mint 8 and the old Kexi is no longer in the 
> repositories. I tried this advice
>
> http://ubuntuforums.org/showthread.php?t=1475827
>
> but kexi is still not available. The .deb package kexi 1:1.6.3-7ubuntu10 on 
> launchpad
>
> https://launchpad.net/ubuntu/lucid/i386/kexi/1:1.6.3-7ubuntu10
>
> has a list of dependencies. All are installed except koffice-libs, for which 
> both '>=1:1.6.3' and '<<1:1.6.4' are listed, and I can't work out how to get 
> around this - I can only install one or the other.
>
> Suggestions?

Bob,
For relatively modern hardware, solution is to setup virtual machine
with older distribution and have it for such purposes. If I had to
perform extensive testing various versions of the app, I would go this
way.
Old packages could stop work on newer versions of distributions, I
think, especially because dependencies (like libraries) are newer
there.
For the same reasone even building the old code on newer system is not
an option because you would have the old KDElibs (version 3.x) at
least present, what is probably also missing on newer version of most
distributions.

-- 
regards / pozdrawiam, Jaroslaw Staniek
 http://www.linkedin.com/in/jstaniek
 Kexi & KOffice (http://kexi-project.org, http://identi.ca/kexi,
http://koffice.org)
 KDE Software Development Platform on MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] Re: How do I get old Kexi?

2010-10-15 Thread Jaroslaw Staniek
On 15 October 2010 11:33, Bob Mesibov  wrote:
> Many thanks for that advice, Jaroslaw. Well, another possibility is to 
> install the latest Kexi, as part of KOffice. Unfortunately, this is also not 
> easy. The Mint repos only have 2.1, and Kexi isn't included. 2.2 would have 
> to be built by the user.
>
> It looks like Kexi has 'slipped between the cracks' and isn't available as a 
> separate application to current Mint users (including Mint 9 KDE users). Is 
> there an agreement with kde.org that prevents you from organising the updated 
> Kexi as a separate application?

Kexi shares increasingly more and more facilities with other KOffice
applications. Therefore common libraries are needed, called usually
something like kofficelibs.
Kexi if properly packaged by distro, can be installed separately. Only
user can decide to e.g. install KWord in addition.

I encourage you to talk to your distribution makers, we highly depend
on motivated, active users.

In any case please consider updating
http://userbase.kde.org/KOffice/Download if you have something to add
- you will save our (and other users) time. Thanks!

-- 
regards / pozdrawiam, Jaroslaw Staniek
 http://www.linkedin.com/in/jstaniek
 Kexi & KOffice (http://kexi-project.org, http://identi.ca/kexi,
http://koffice.org)
 KDE Software Development Platform on MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] Re: How to install Kexi

2010-11-15 Thread Jaroslaw Staniek
On 15 November 2010 19:34, Ian "Witty" Whitfield
 wrote:
> Hi All
>
> New to this list.
>
> For the past few days I have been trying to get hold of Kexi to try it
> out as a replacement for OOBase. But I'm having no luck!!

Hello Ian,
What is your operating system and its version?

Kexi package(s) are available in the same places as KOffice packages.
This is documented at http://userbase.kde.org/KOffice/Download

This may help (or we may need to update this page). Everyone can!

-- 
regards / pozdrawiam, Jaroslaw Staniek
 http://www.linkedin.com/in/jstaniek
 Kexi & KOffice (http://kexi-project.org, http://identi.ca/kexi,
http://koffice.org)
 KDE Software Development Platform on MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] Re: How to install Kexi (Jaroslaw Staniek)

2010-11-16 Thread Jaroslaw Staniek
On 16 November 2010 13:07, Ian "Witty" Whitfield
 wrote:
> Thanks for the reply Jaroslaw
>
>>   wrote:
>>
>>> >  Hi All
>>> >
>>> >  New to this list.
>>> >
>>> >  For the past few days I have been trying to get hold of Kexi to try it
>>> >  out as a replacement for OOBase. But I'm having no luck!!
>>>
> Jaroslaw replied...
>> Hello Ian,
>> What is your operating system and its version?
>>
>> Kexi package(s) are available in the same places as KOffice packages.
>> This is documented athttp://userbase.kde.org/KOffice/Download
>>
>> This may help (or we may need to update this page). Everyone can!
>>
>
> My Operating System is Kubuntu 10.04, (soon to move to 10.10), and I
> also have Mint 9 KDE running here as well. (Sorry I should have
> mentioned this!!)
>
> I went to the page you pointed me to and ran the commands there - No Kexi!!
>
> So I thought maybe I must remove all the stuff I have done already first
> so I removed KOffice completely.
>
> I then ran the commands again - No KOffice at all!!
>
> So I rebooted the computer and then I had KOffice back BUT STILL NO KEXI
>
> What am I missing!!!

"To obtain KOffice 2.2.0 enable the official backports repository and
update your system.
Refer to  help.ubuntu.com for detailed instructions how to add a repository:

https://help.ubuntu.com/community/Repositories/Kubuntu
"

-- 
regards / pozdrawiam, Jaroslaw Staniek
 http://www.linkedin.com/in/jstaniek
 Kexi & KOffice (http://kexi-project.org, http://identi.ca/kexi,
http://koffice.org)
 KDE Software Development Platform on MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] Re: How to install Kexi (Jaroslaw Staniek)

2010-11-16 Thread Jaroslaw Staniek
On 16 November 2010 23:56, Noli Sicad  wrote:
> I am using  Kexi2.2.2 in Ubuntu 10.04.
>
> Here's repo to get it.
> deb http://ppa.launchpad.net/lamont/backports/ubuntu lucid main

Is this right address?
I am browsing and cannot see any trace of koffice or kexi:

http://ppa.launchpad.net/lamont/backports/ubuntu/pool/main/

-- 
regards / pozdrawiam, Jaroslaw Staniek
 http://www.linkedin.com/in/jstaniek
 Kexi & KOffice (http://kexi-project.org, http://identi.ca/kexi,
http://koffice.org)
 KDE Software Development Platform on MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] Re: [Bug 676398] Re: Kexi Package Way Too Monolithic

2010-11-17 Thread Jaroslaw Staniek
>> Kexi Package Way Too Monolithic
>> https://bugs.launchpad.net/bugs/676398

On 17 November 2010 15:24, Jonathan Riddell  wrote:
> I don't see installing a couple of database access libraries as being a
> problem.  libsybdb5, libxbase2.0-0 and libpqxx-3.0 aren't large and
> don't require installing the actual database server.

Jonathan,
I have to disagree. All distros properly packaging Kexi have the splitting.
What you say is not excuse for giving up with splitting. Lack of time is.
But the issue was reported to Debian years ago in the time of KOffice
1.4 and now to Ubuntu.

> Splitting up kexi would have people install and run kexi then wonder why
> it wasn't connecting to their preferred database.  Working out that you
> have to install another package isn't a great user experience.

The idea of recommended packages can address that.
In next version plugins would depend on kspread and maybe on openoffice.
Would it make sense to make Kexi dependent on those? This degrades its value.
Would you also add this dependency?

-- 
regards / pozdrawiam, Jaroslaw Staniek
 http://www.linkedin.com/in/jstaniek
 Kexi & KOffice (http://kexi-project.org, http://identi.ca/kexi,
http://koffice.org)
 KDE Software Development Platform on MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


[Kexi] Re: Report - from multiple tables

2010-11-24 Thread Jaroslaw Staniek
2010/11/24 Marcin Małecki :
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> My system:
> Kexi version 2.2.2, KDE development 4.5.1
> Ubuntu 10.10
>
> I have created database for my clients. It contains 7 tables all tide to
> one reference number set in one of the tables.
>
> I wanted to create report that would pull information from all of the
> table based on the reference number.
> The problems I encountered so far are:
> 1) I do not know how to pull from more then one table at once

Hi Marcin,
More info is needed about how the tables are joined. We have to see if
you could you use query to select the data.

> 2) I do not know how to pull specific record rather then all of the records

Parameter query [1] may be useful to select one record, however the
GUI allows only for entering the value to search (e.g. ID or text); it
is not possible to select record from table view and do something with
it (e.g. print it).

[1] http://www.kexi-project.org/pics/1.1.1/parameter_query/parameter_query.html

-- 
regards / pozdrawiam, Jaroslaw Staniek
 http://www.linkedin.com/in/jstaniek
 Kexi & KOffice (http://kexi-project.org, http://identi.ca/kexi,
http://koffice.org)
 KDE Software Development Platform on MS Windows (http://windows.kde.org)
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi


  1   2   3   4   >