gmane.comp.kde.users.kexi

Exporting Data = Sorted by ID

Renaissance Yoga — 2012-05-13T23:06:40

Greetings,

I am exporting my database as a CSV file, BUT for some reason it always 
starts the CSV file with ID #114, and not ID #1.

For that matter, when I open the Kexi database it always lists ID# 114 
first as well. Each time I try and resort it starting with ID #1, but 
always it reverts back and hence affects the CSV file.

I really need it to list ID#1 first in the CSV - is there anyway to do this?

Thanks,

Satyam

Re: Kexi Digest, Vol 73, Issue 4

rafael2pop — 2012-04-25T08:52:25

Which is the last stable version for downloading ?

Will be needed any action from my side to remain in this list with Kexi-project ? 

Would like to know any link about facts of Kexi on Calligra-suite.org

I discovered that KOffice revamp thru RaspeberryPi.org site (the SBC with HD1080 video and $35 cost (with 256MB Ram).

Guess that most of you already heard chiming about it.

And yes, I'm list maniac in digest mode :=)

Best,

Rafael
Buenos Aires, ARG

--- El mar 24-abr-12, kexi-request-RoXCvvDuEio< at >public.gmane.org <kexi-request-RoXCvvDuEio< at >public.gmane.org> escribió:

>

Re: Kexi mailing list is moving to forums

Jaroslaw Staniek — 2012-04-23T21:04:10

PS2: Please note that developers (and any other contributors such as
packagers) still can use (and they do) the development mailing list
calligra-devel< at >kde.org.

Re: exporting Data

Renaissance Yoga — 2012-04-20T02:58:14

Greetings,

Earlier I had tried in DATA VIEW and it did not work and now again I 
tried - same result.

Did you mean to say DESIGN VIEW; because just now I tried in design view 
and then the export feature is available. That looks like it is going to 
work.

Satyam



On 04/19/2012 08:44 AM, Jaroslaw Staniek wrote:

Re: exporting Data

Jaroslaw Staniek — 2012-04-19T12:44:01


Hi,
Please open the table in data view, then try the Export function again.

exporting Data

Renaissance Yoga — 2012-04-19T12:12:38

Greetings,

I am using:

Kexi, Version 2.2.2 (KOffice 2.2.2), Using KDE Development Platform 
4.5.3 (KDE 4.5.3)

And I want to export my tables but the "export data to file" command is 
de-lited. It cannot be clicked on.

How then can I export the table - what must I do??

Thanks,

Satyam

Exporting Data

Renaissance Yoga — 2012-04-06T00:20:10

Greetings,

I am using:

Kexi, Version 2.2.2 (KOffice 2.2.2), Using KDE Development Platform 
4.5.3 (KDE 4.5.3)

And I want to export my tables but the "export data to file" command is 
de-lited. It cannot be clicked on.

How then can I export the table - what must I do??

Thanks,

Satyam

Re: Kexi and Glom - lean database tools compared

Jaroslaw Staniek — 2012-04-03T18:52:46

Hi,
Update: the link has been changed to:
http://www.linuxpromagazine.com/Issues/2012/1382/Kexi-vs.-Glom/%28kategorie%29/0

Kexi and Glom - lean database tools compared

Jaroslaw Staniek — 2012-03-30T22:52:06

Hello,
A free and fresh copy of Linux Magazine article on Kexi and Glom:

http://www.linuxpromagazine.com/Issues/2012/138/Kexi-vs.-Glom

Kexi Forum

Jaroslaw Staniek — 2012-03-06T11:31:12

Hello,
I have a pleasure to announce creation of the Kexi forum:

http://forum.kde.org/viewforum.php?f=219

For now there are two areas:
- news & discussions
- user help

Have fun!

For your convenience, this is an RSS feed for all Kexi topics:

http://forum.kde.org/search.php?keywords=&terms=all&author=&tags=&sv=0&fid%5B%5D=219&fid%5B%5D=220&fid%5B%5D=221&sc=1&sf=all&sk=t&sd=d&st=0&feed_type=RSS2.0&feed_style=HTML&countlimit=100&submit=Search

You can also set up your own RSS feed for this and other parts of the
KDE forums at http://forum.kde.org/rss.php

Re: [Oracle Forms replacement] Ways to start this project

Jaroslaw Staniek — 2012-02-28T21:28:09

On 28 February 2012 07:33, Jorge Cabezudo Perez
<jorge.cabezudo< at >gmail.com> wrote:

Hello,
As an productive alternative to restarting efforts, I propose looking
at Kexi or Glom projects (in no particular order or depending on your
preference) and express your opinions on what directions would you
like to see in these projects.

These are all free software projects. The DB independence is assured
by the Predicate project in Kexi. XML definition for forms and reports
is close to the one offered by OpenDocument. Most of requirements or
ideas mentioned on this list is already addressed or possible to
address without major conflicts with the actual assumptions set in the
projects.

Re: [ideas] GIS in Kexi; was: Google Fusion Tables - storage for Kexi?

Noli Sicad — 2011-11-30T01:43:28

I like to put these things into perspective. This is the hierarchy:

- GIS
- Spatial
- Map

I think Spatial in Kexi can be easily done using Spatialite. It is

- Sqlite3 + the geom (geometry column added in Sqlite3 file).

Once Kexi can accept (write and read) raw Sqlite3 files (i.e. .db and
.sqlite), it just adding the geometry column (e.g. geom or geometry)
in the table.

GEOS, Proj4 are dependent libraries for Spatialite.

Jaroslaw, I think can we probably propose a GSOC for SQLite3 for Kexi.
It seems that since 2007 Kexi users need read and write access for
SQLite3 in Kexi.

Any comments?

Thanks.

Noli









On 11/29/11, Noli Sicad <nsicad-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:

Re: [ideas] GIS in Kexi; was: Google Fusion Tables - storage for Kexi?

Noli Sicad — 2011-11-29T10:46:23

I forgot to mention, projection library is also needed, aside from GEOS.

PROJ.4 - Cartographic Projections Library
http://trac.osgeo.org/proj/

Noli



On 11/28/11, Noli Sicad <nsicad-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:

Re: a thought about Calligra

Jaroslaw Staniek — 2011-11-28T13:07:00

Small correction, by default Akonadi owns private instance of MySQL.
This configuration should be changed in order to share the instance.
No idea if this is worth the effort on modern machines if you do not
plan to directly reuse Akonadi data stored in the database.

(CC'd to Akonadi hacker)

Re: a thought about Calligra

Jaroslaw Staniek — 2011-11-28T10:51:12

By the way, since you mentioned Akonadi: We have a TODO created long
ago to have data from Akonadi synced with Kexi data sources maybe even
in both directions: Kexi acting as provider for Akonadi and Akonadi
acting as data source for Kexi visible as set of tables with
relationships in Kexi. The use cases covered: having direct access to
all structures like contact data, messaging...

Re: a thought about Calligra

Jaroslaw Staniek — 2011-11-28T10:10:42

2011/11/28 Agustin Benito Bethencourt <toscalix< at >gmail.com>:


Hello Agustin,
You can reuse your local MySQL service (i.e. MySQL Server, not MySQL
Embedded), just provide connection info (user, password) once - when
creating your first Kexi database.

Re: [ideas] GIS in Kexi; was: Google Fusion Tables - storage for Kexi?

Noli Sicad — 2011-11-28T00:57:13

I think GIS in Kexi probably heavy to do in one go. Why just a
Spatialite in Kexi - a support for spatialite in Kexi.

https://www.gaia-gis.it/fossil/spatialite_gui/index

Although, if we can display spatialite geometries in Kexi Map canvas
that would be very good.

GEOS is the engine for displaying the spatial geometries.
http://strk.keybit.net/projects/geos/

Noli

On 11/28/11, Noli Sicad <nsicad-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:

Re: [ideas] GIS in Kexi; was: Google Fusion Tables - storage for Kexi?

Noli Sicad — 2011-11-28T00:30:02

I think this is very good idea - GIS in Kexi.

Requirements for Kexi (Top of mind right now :-) ).

- Map canvas to display vectors - (I think some parts are already done
- Maps in Kexi)
- read and write SQlite3 files
- data source spatialite file (.db or .sqlite).

Spatialite and GEOS libraries needed are here.
http://www.gaia-gis.it/gaia-sins/
http://strk.keybit.net/blog/2011/09/27/geos-3-3-1-released/

What can Maps in Kexi do right now? Can it display vector and raster?

Noli

On 11/28/11, Jaroslaw Staniek <staniek-RoXCvvDuEio< at >public.gmane.org> wrote:

[ideas] GIS in Kexi;was: Google Fusion Tables - storage for Kexi?

Jaroslaw Staniek — 2011-11-28T00:05:00

Kind of constructive idea, how about you and/or other GIS people help
in specifying detailed requirements and development plan for 'GIS in
Kexi' feature and that can be proposed as a Google Summer of Code 2012
project?
So the feature can be implemented earlier...

We have received funds from Google for Maps in Kexi project this year
and it was positive.

Re: [ideas] Google Fusion Tables - storage for Kexi?

Jaroslaw Staniek — 2011-11-27T23:59:15

Hmm, adding linked tables to a project with data source in CSV format.
Yes, a TODO for Kexi... :)

Re: [ideas] Google Fusion Tables - storage for Kexi?

Noli Sicad — 2011-11-27T23:45:36

Here are some thoughts about MS Access and QGIS.
http://gis.stackexchange.com/questions/9462/can-qgis-read-an-odbc-connection

Things being discussed above also applies to Kexi usability outside Kexi GUI.

Noli