Re: [Kexi] [ideas] GIS in Kexi; was: Google Fusion Tables - storage for Kexi?
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 wrote: > 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 wrote: >> 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 wrote: >>> 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 wrote: >>>> 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. >>>> >>>> -- >>>> regards / pozdrawiam, Jaroslaw Staniek >>>> http://www.linkedin.com/in/jstaniek >>>> Kexi & Calligra (kexi-project.org, identi.ca/kexi, calligra-suite.org) >>>> KDE Software Development Platform on MS Windows (windows.kde.org) >>>> >>> >> > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] [ideas] GIS in Kexi; was: Google Fusion Tables - storage for Kexi?
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 wrote: > 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 wrote: >> 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 wrote: >>> 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. >>> >>> -- >>> regards / pozdrawiam, Jaroslaw Staniek >>> http://www.linkedin.com/in/jstaniek >>> Kexi & Calligra (kexi-project.org, identi.ca/kexi, calligra-suite.org) >>> KDE Software Development Platform on MS Windows (windows.kde.org) >>> >> > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] [ideas] GIS in Kexi; was: Google Fusion Tables - storage for Kexi?
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 wrote: > 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 wrote: >> 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. >> >> -- >> regards / pozdrawiam, Jaroslaw Staniek >> http://www.linkedin.com/in/jstaniek >> Kexi & Calligra (kexi-project.org, identi.ca/kexi, calligra-suite.org) >> KDE Software Development Platform on MS Windows (windows.kde.org) >> > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] [ideas] GIS in Kexi; was: Google Fusion Tables - storage for Kexi?
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 wrote: > 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. > > -- > regards / pozdrawiam, Jaroslaw Staniek > http://www.linkedin.com/in/jstaniek > Kexi & Calligra (kexi-project.org, identi.ca/kexi, calligra-suite.org) > KDE Software Development Platform on MS Windows (windows.kde.org) > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] [ideas] Google Fusion Tables - storage for Kexi?
> I feel no surprise MS Access is somewhat 'aside' of such developments: > it allows either for embedding ActiveX elements or binding to custom > data via degraded ODBC interface. So few points where > integration/extensibility is possible... 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 ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] [ideas] Google Fusion Tables - storage for Kexi?
This is QGIS user post regarding Spatialite and MS Access. http://groups.google.com/group/spatialite-users/browse_thread/thread/6418b8b04e0c3bf0?pli=1 BTW, MS Access don't not work with QGIS. Noli On 11/27/11, Noli Sicad wrote: >>> QGIS can read and write PosgreSQL (i.e. PostGIS) and sqlite (i.e >>> spatialite files) and QGIS has a python bindiings (i.e. PyQGIS) and >>> soon probably a javascript bindings as well in QGIS version 2 (plan). >>> >>> http://linfiniti.com/2011/11/more-on-qgis-desktop-web-fusion/ >> >> This is all very interesting. It would be possible to have proper >> integration if we have any contributor in this area. >> Even starting with small thing would make a difference. The one who is >> interested would decide on the future shape of Kexi :) > > You might be interested to read the first part, (if you have not seen > this already). > > http://linfiniti.com/2011/11/fusing-web-technologies-with-qgis/ > > I believe a lot of QGIS users will be using Kexi if there is read and > write for sqlite3 files. Right now, they are looking for MS Access > alternative that would with QGIS. > > Noli > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] [ideas] Google Fusion Tables - storage for Kexi?
>> QGIS can read and write PosgreSQL (i.e. PostGIS) and sqlite (i.e >> spatialite files) and QGIS has a python bindiings (i.e. PyQGIS) and >> soon probably a javascript bindings as well in QGIS version 2 (plan). >> >> http://linfiniti.com/2011/11/more-on-qgis-desktop-web-fusion/ > > This is all very interesting. It would be possible to have proper > integration if we have any contributor in this area. > Even starting with small thing would make a difference. The one who is > interested would decide on the future shape of Kexi :) You might be interested to read the first part, (if you have not seen this already). http://linfiniti.com/2011/11/fusing-web-technologies-with-qgis/ I believe a lot of QGIS users will be using Kexi if there is read and write for sqlite3 files. Right now, they are looking for MS Access alternative that would with QGIS. Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] [ideas] Google Fusion Tables - storage for Kexi?
> The goal is to make Kexi able to open sqlite3 files directly. > This is a higher-priority plan for the next version after Kexi 2.4. Read and write sqlite3 files directly? I hope it is not a year or 2 from now but sooner. Any programs / apps that can read and write .kexi files at the moment? Any python, javascript bindings that can read and write .kexi files at the moment? Kexi would be good data input for QGIS, if it can read and write sqlite (i.e. spatailite files) even just non spatial. http://www.qgis.org/ QGIS can read and write PosgreSQL (i.e. PostGIS) and sqlite (i.e spatialite files) and QGIS has a python bindiings (i.e. PyQGIS) and soon probably a javascript bindings as well in QGIS version 2 (plan). http://linfiniti.com/2011/11/more-on-qgis-desktop-web-fusion/ Thanks. Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] [ideas] Google Fusion Tables - storage for Kexi?
Hi Jaroslaw, Would Kexi now imports sqlite3 files (e.g. db and sqlite)? Noli On 11/24/11, Jaroslaw Staniek wrote: > On 24 November 2011 08:59, Noli Sicad wrote: >> My alternative for Google Fusion Tables is GeoJSON. >> >> http://geojson.org > > Nice! > (Noli, yes I still remember about your needs regarding spatial databases :) > > I would add there are two things: > 1. Services that users can plug into to have free storage (pros: > freeloading, cons: lock-in, 'different' approach to security) > 2. Free/libre implementations (pros: more control, cons: you're on > your own hosting) > > -- > regards / pozdrawiam, Jaroslaw Staniek > http://www.linkedin.com/in/jstaniek > Kexi & Calligra (kexi-project.org, identi.ca/kexi, calligra-suite.org) > KDE Software Development Platform on MS Windows (windows.kde.org) > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] [ideas] Google Fusion Tables - storage for Kexi?
My alternative for Google Fusion Tables is GeoJSON. http://geojson.org/ http://leaflet.cloudmade.com/examples/geojson.html http://dev.openlayers.org/releases/OpenLayers-2.11/examples/geojson.html Spatialite has support for GeoJSON. http://www.google.com.au/#sclient=psy-ab&hl=en&source=hp&q=spatialite+geojson&pbx=1&oq=spatialite+geojson&aq=f&aqi=&aql=&gs_sm=e&gs_upl=3590l5897l0l6260l11l8l0l0l0l0l0l0ll0l0&bav=on.2,or.r_gc.r_pw.,cf.osb&fp=35bebb7d66b154d0&biw=1321&bih=564 Noli On 11/24/11, Jaroslaw Staniek wrote: > Google Fusion Tables - custom storage as Kexi tables? > This year they have gsoc APIs. > > http://www.google.com/fusiontables/Home/ > > What do you think? > > -- > regards / pozdrawiam, Jaroslaw Staniek > http://www.linkedin.com/in/jstaniek > Kexi & Calligra (kexi-project.org, identi.ca/kexi, calligra-suite.org) > KDE Software Development Platform on MS Windows (windows.kde.org) > ___ > Kexi mailing list > Kexi@kde.org > https://mail.kde.org/mailman/listinfo/kexi > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Kexi Updates?
Hi, It seems that there is no updates in Kexi in this mailing list. While searching for Kexi news and updates, I got this, http://blogs.kde.org/taxonomy/term/7 Hope to see more new screenshots in Kexi and new features posted in Kexi site. Thanks, Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Re: [news] Web Browser widget at its full speed
Jaroslaw, I hope I can use OpenLayers with new web page in Kexi. http://www.openlayers.org/ Then Kexi with Spatialite library (SQLite extension) geometry to render to OpenLayers. http://www.gaia-gis.it/spatialite-2.4.0-4/spatialite-cookbook/index.html Noli On 6/30/11, Jaroslaw Staniek wrote: > Hello, > With new developer on board, Season of KDE brings fruits for Kexi. Web > Browser widget at its full speed: http://blogs.kde.org/node/4448 > > -- > regards / pozdrawiam, Jaroslaw Staniek > http://www.linkedin.com/in/jstaniek > Kexi & Calligra (kexi-project.org, identi.ca/kexi, calligra-suite.org) > KDE Software Development Platform on MS Windows (windows.kde.org) > ___ > Kexi mailing list > Kexi@kde.org > https://mail.kde.org/mailman/listinfo/kexi > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Re: Season of Kexi status
Hi Jaroslaw, Where you do keep their weekly reports for SofC, Week 1 and Week 2? I did not see any entries in their blogs. Noli On 6/21/11, Jaroslaw Staniek wrote: > Hi, > For your information, if you find yourself interested in tracking Kexi > development closer (or also participate in any way) -- two projects > within the Kexi project are going forward, with contributions from new > Kexi developers: > > 1. Summer of Code (maps elements): > http://community.kde.org/GSoC/2011/StatusReports#Radek_Wicik > 2. Season of KDE (web elements): > http://community.kde.org/GSoC/2011/StatusReports#Shreya_Pandit > > Special group dedicated to such development has been created, can be > read by anyone: > https://groups.google.com/forum/#!forum/season-of-kexi > > -- > regards / pozdrawiam, Jaroslaw Staniek > http://www.linkedin.com/in/jstaniek > Kexi & Calligra (kexi-project.org, identi.ca/kexi, calligra-suite.org) > KDE Software Development Platform on MS Windows (windows.kde.org) > ___ > Kexi mailing list > Kexi@kde.org > https://mail.kde.org/mailman/listinfo/kexi > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Re: Kexi selected for Google Summer of Code!
Hi Jaroslaw, Reading this note[1], it seems that you want to use OSM for Kexi marble widget you can use OSM sqlite3 database file and MBTiles [1] http://community.kde.org/Kexi/Junior_Jobs/Map_Browser_Form_Widget/Log-2011-04-08 Sqlite3 database for offline: a) OSM sqlite3 - OSM Tiles (i,e, map2sqlite) http://www.gisnotes.com/wordpress/2010/08/iphone-dev-note-21-route-me-offline-mapping-from-database/ b) MapBoxTiles (MBTiles) https://github.com/mapbox/mbtiles-spec See sample project of MBTiles in https://github.com/mapbox/route-me Importer and Exporter of MBTiles https://github.com/mapbox/mbutil You can easily make Mapbox Maps using TileMill http://mapbox.com/#/ BTW, Spatialite has support for projection and GEOS. Supporting spatialite / sqlite3 database in Kexi will make things easier to implement more sensible marble widget in Kexi. Here's the changelog of spatialite RC-4. http://www.gaia-gis.it/spatialite-2.4.0-4/changelog.html RC-4 [2010-11-14] * libspatialite o completely refactored CSV/TXT reader o now supporting KML and GML geometry output [AsKML(), AsGml()] o introduced a new SQL function supporting easy WGS84 POINTs filtering: PtDistWithin() o fixed several memory leaks (mainly related with the new WKT parser introduced in RC-3) o fixed some bugs o major updates to the build scripts o update: SQLite v.3.7.3 [introducing Geometry Callbacks support: RTreeIntersects(), RTreeWithin(), RTreeContains(), RTreeDistWithin()] http://www.gaia-gis.it/spatialite-2.4.0-4/index.html Thanks. Regards, Noli On 5/2/11, Jaroslaw Staniek wrote: > On 2 May 2011 06:59, Noli Sicad wrote: >> Hi Jaroslaw, >> >> Congratulations! >> >> I hope Kexi Marble widget [1] can read render spatialite database >> query (i.e Vector Polylines) thru KML. > > Noli, > Good suggestions. Added to notes. Looking forward to cooperate/hear > opinions from you during this development, so we won't miss core > features. > > -- > regards / pozdrawiam, Jaroslaw Staniek > http://www.linkedin.com/in/jstaniek > Kexi & Calligra (kexi-project.org, identi.ca/kexi, calligra-suite.org) > KDE Software Development Platform on MS Windows (windows.kde.org) > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Re: Kexi selected for Google Summer of Code!
Hi Jaroslaw, Congratulations! I hope Kexi Marble widget [1] can read render spatialite database query (i.e Vector Polylines) thru KML. [1] http://community.kde.org/Kexi/Junior_Jobs/Map_Browser_Form_Widget#TODOs Spatialite has support for KML (i.e. output SQL query as AsKML). Mable[2] has already support for vector render thru KML and GPX. [2] http://edu.kde.org/marble/ " Marble has got support for several 3rd party data sources like OpenStreetMap, Wikipedia, KML, GPX etc." Noli On 4/29/11, Jaroslaw Staniek wrote: > Hello, > It is nice to inform you that Kexi has been selected as a project for > Google Summer of Code! > Kexi code is also developed under the Season of KDE umbrella. > > More information at http://www.kdedevelopers.org/node/4419 > > -- > regards / pozdrawiam, Jaroslaw Staniek > http://www.linkedin.com/in/jstaniek > Kexi & Calligra (kexi-project.org, identi.ca/kexi, calligra-suite.org) > KDE Software Development Platform on MS Windows (windows.kde.org) > ___ > Kexi mailing list > Kexi@kde.org > https://mail.kde.org/mailman/listinfo/kexi > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Re: [calligra/kexi-maps-wicik] /: FEATURE: Initial version of Map widget in kexi forms
On 4/7/11, Jaroslaw Staniek wrote: > On 6 April 2011 23:10, Radosław Wicik wrote: > >> Coming next maps in reports, then connect it to DB for setting and >> displaying data with/on maps. >> >> If that will be ready then I'll try flake shapes. >> >> After that I'll go deeper, define new data types: >>- points >>- lines >>- polygons >> thanks to it it will be possible to add some "zones" on maps, >> What do you think about this plan? >> >> What do you think about me blogging my "way of the Calligra developer"? >> This would be technical, high level view about the source, and thinks >> that I found hard to understand or interesting, maybe this would be >> helpful for somebody? > > Hi Radek, > No doubt it will be helpful! Just make sure your blog is syndicated at > http://planetkde.org/ before you blog. > Regarding the data types, it's hard to add it in current kexi, since > kexidb is feature-frozen. Predicate is not but it's in heavy > development (refactoring) and I wouldn't like to destabilize it. > > I am not 100% sure about the use case. If you mean adding lines, > points and polygons to the map (by the user), I would recommend using > some predefined XML (first define it on a wiki page). > In any kexi database there's kexi__objectdata table where you can save > extra data string related to any object (here: form and report). Query > objects use that to store SQL statements and forms use it to store > QtDesigner-like XML for UIs. Spatialite, Sqlite GIS extension can do this. http://www.gaia-gis.it/spatialite/spatialite-tutorial-2.3.1.html Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Koffice Kexi and Calligra Kexi - Was and Now.
Hi, Just for the record to explain what is going on, why Koffice Kexi becomes Calligra Kexi. Read - Behind the KOffice split http://lwn.net/SubscriberLink/419822/7c50edb32265e3ed/ Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Meego 1.1 and Koffice 2.2.95 - No Kexi package
Hi, I found that koffice and freoffice rpm in this repository state for meego_1.1_core (below). https://build.pub.meego.com/package/binaries?package=koffice&project=home%3Amkruisselbrink%3Aminimalkde&repository=meego_1.1_core However, there is no Kexi package. I wonder when is the Calligra Suite 2.4 Alpha release? I hope on this release would have, at least Meego Netbook UX integration. I hope it will be in the next 3 months before Meego 1.2 SDK and Phone release in April. Regarding, Meego Handset UX integration, we hope Nokia, Intel, AMD will fund more developer to expediate this process in the next 6 months. Android 3.0 is coming integration on Google doc for sure. Nokia, Intel and AMD are far behind Apple and Google in this mobile arena right now. FYI, some more interesting links. http://dot.kde.org/2010/12/03/kdes-mobile-team-meets-first-sprint http://community.kde.org/KDE_Mobile/Sprints/November2010-Planning http://www.kogmbh.com/news.html Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Re: Calligra Kexi and Meego
I guess the next question / step is how to get the kde library in Meego. http://community.kde.org/KDE_Mobile/Meego_development_with_KDE Then, Kexi in Meego http://wiki.koffice.org/index.php?title=Building/Building_KOffice This is Calligra outlook http://blog.cberger.net/2010/12/07/calligra-past-present-future-a-few-answers/ (The comment of Freddie regarding calligra naming on the above is very interesting). I hope Calligra developers especially those supported by Nokia to put a wiki how to compile kde library and Calligra Suite in Meego. I found this blog. http://www.valdyas.org/fading/index.cgi/hacking/meegoblog.html With this info, I hope that there will be package / rpm for Calligra Suite in Meego soon. But I am in doubt if Kexi is included. Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Re: Calligra Kexi and Meego
I am really excited the possibility of running Kexi in Tablet UX. Although at this moment, there is no Tablet UX in Meego 1.1 SDK however, once the phone UX is becoming to finalize then Tablet UX will probably formulate very quickly. I think right now, the strategy for Kexi in Meego is to try to build it with Netbook UX in Meego 1.1 SDK. There is alpha website for Meego Developer. http://developer.meego.com/ User Name: meego Password: developer You can probably get the Meego 1.1 SDK for Ubuntu as mentioned in the site and build Kexi or Calligra 2.4. Right Android and iPad does not have good database application. Bento in ipad is no so good. It is only 1 table per database. It is using sqlite database format. I think running Kexi in current form in Meego 1.1 SDK Netbook UX will be good promotion for Kexi. This will excite the whole Meego community and promote Kexi. It might get some attention from Nokia and Intel and probably they will the further development effort interms of funds and developer manpower. Noli On 12/11/10, Jaroslaw Staniek wrote: > On 11 December 2010 04:43, Noli Sicad wrote: >> Hi Jaroslaw, >> >> Do you know if Office Suite for the MeeGo Platform for Meego manage to >> build kexi in Meego netbook UX and phone UX? > > Alpha version could be available in Calligra 2.4. > For now it could be built (didn't try but other Calligra apps can be > built) but only offers desktop UX there. This als omeans no > integration with MeeGo. > > We're working on adding the phone and tabled UX to kexi. Natural > choice is to have designing features disabled on phones but perhaps to > still have them on tablet (that's may be exciting). > > You're invoted to discuss feature sets and ideas, this is good moment I > think. > > Thanks for the links. > > > -- > regards / pozdrawiam, Jaroslaw Staniek > http://www.linkedin.com/in/jstaniek > Kexi & Calligra (kexi-project.org, identi.ca/kexi, calligra-suite.org) > KDE Software Development Platform on MS Windows (windows.kde.org) > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Calligra Kexi and Meego
Hi Jaroslaw, Do you know if Office Suite for the MeeGo Platform for Meego manage to build kexi in Meego netbook UX and phone UX? Office Suite for the MeeGo Platform http://conference2010.meego.com/session/office-suite-meego-platform http://www.itworld.com/open-source/129859/the-end-koffice-the-end-kde What version of kexi is working with Meego? Thanks. Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Calligra Kexi and Meego
Hi Jaroslaw, Do you know if Office Suite for the MeeGo Platform for Meego manage to build kexi in Meego netbook UX and phone UX? Office Suite for the MeeGo Platform http://conference2010.meego.com/session/office-suite-meego-platform http://www.itworld.com/open-source/129859/the-end-koffice-the-end-kde What version of kexi is working with Meego? Thanks. Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Re: How to install Kexi (Jaroslaw Staniek)
This is the package. http://packages.ubuntu.com/lucid-backports/kde/kexi https://launchpad.net/lucid-backports I think this is the right one. deb http://au.archive.ubuntu.com/ubuntu/ lucid-backports main restricted universe multiverse On 11/17/10, Jaroslaw Staniek wrote: > 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: How to install Kexi (Jaroslaw Staniek)
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 Noli On 11/17/10, Colin Hersom wrote: > On 16/11/10 12:07, Ian "Witty" Whitfield wrote: >> >> 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!!) >> > > Kexi is missing from the repositories for 10.04, but has re-appeared in > 10.10, so I suggest that you upgrade ASAP. > > Colin. > ___ > Kexi mailing list > Kexi@kde.org > https://mail.kde.org/mailman/listinfo/kexi > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Kexi 2.2 PostgreSql driver not deciphering money type
Hi, It seems that the kexi postgresql driver could not deciphering / understand / encode money. In this case this table tblData. CREATE TABLE tblData ( Croptypevarchar (32), Age int, Areafloat, TRV int, SCOST money, PCOST money, P1P2float, SLOGfloat, PULPfloat, CFREV money, LCOST money, TCOST money, SACOST money, RCOST money ); Thanks, Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Geting Kexi2.2 SVN source only for patching purposes
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. Thanks Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Geting Kexi2.2 SVN source only for patching purposes
Hi, I would like to patch my ubunutu 10.04 Kexi2.2 to fix for stability issue of SQLite driver and for memo fields in MS Access released for Kexi 2.2 as mentioned in the site. http://www.kexi-project.org/ I am not using any KDE at the moment except Kexi2.2. I don't want to download the whole Koffice 2.2.1 tarball source. Any instruction how to get Kexi2.2.1 source in SVN and patch it. BTW, I just like to verify as well if the SQLite driver fix can actually open sqlite3 database now. Thanks. Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Postgresql and Kexi 2.2 import database working?
I removed the offending data and it is working now. The Kexi is not Irish friendly :- ) Thanks. Noli On 9/4/10, Adam Pigg wrote: > Surely i havent made a junior mistake like that! I'll check to see if > something isnt being escaped, though i swear i thought it was :) > > Adam > > On Saturday 04 September 2010 02:42:00 Noli Sicad wrote: >> I think there is problem with reading the data, when the record has this >> entry, >> >> Mr. Bill O'Neilly >> >> >> WARNING: nonstandard use of \' in a string literal >> LINE 1: INSERT INTO customer VALUES (14,'Mr ','Bill','O\''Neill','2... >> ^ >> HINT: Use '' to write quotes in strings, or use the escape string >> syntax (E'...'). >> >> >> Noli >> >> ` >> >> transaction committed more than once >> kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: >> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() >> >> || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, >> >> o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='barcode' AND >> o_type=1 LIMIT 1" >> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index >> "barcode_pkey" for table "barcode" >> kexi(7247)/KexiDB KexiDB::Connection::querySingleString: >> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() >> "SELECT o_id FROM kexi__objects WHERE o_type=1 AND >> lower(o_name)='barcode' LIMIT 1" >> kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: >> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() >> >> || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, >> >> o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='customer' >> AND o_type=1 LIMIT 1" >> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index >> "customer_pkey" for table "customer" >> kexi(7247)/KexiDB KexiDB::Connection::querySingleString: >> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() >> "SELECT o_id FROM kexi__objects WHERE o_type=1 AND >> lower(o_name)='customer' LIMIT 1" >> kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: >> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() >> >> || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, >> >> o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='item' AND >> o_type=1 LIMIT 1" >> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index >> "item_pkey" for table "item" >> kexi(7247)/KexiDB KexiDB::Connection::querySingleString: >> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() >> "SELECT o_id FROM kexi__objects WHERE o_type=1 AND >> lower(o_name)='item' LIMIT 1" >> kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: >> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() >> >> || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, >> >> o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='orderinfo' >> AND o_type=1 LIMIT 1" >> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index >> "orderinfo_pkey" for table "orderinfo" >> kexi(7247)/KexiDB KexiDB::Connection::querySingleString: >> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() >> "SELECT o_id FROM kexi__objects WHERE o_type=1 AND >> lower(o_name)='orderinfo' LIMIT 1" >> kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: >> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() >> >> || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, >> >> o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='orderline' >> AND o_type=1 LIMIT 1" >> kexi(7247)/KexiDB KexiDB::Connection::querySingleString: >> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() >> "SELECT o_id FROM kexi__objects WHERE o_type=1 AND >> lower(o_name)='orderline' LIMIT 1" >> kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: >> Connection::querySin
Re: [Kexi] Postgresql and Kexi 2.2 import database working?
I think there is problem with reading the data, when the record has this entry, Mr. Bill O'Neilly WARNING: nonstandard use of \' in a string literal LINE 1: INSERT INTO customer VALUES (14,'Mr ','Bill','O\''Neill','2... ^ HINT: Use '' to write quotes in strings, or use the escape string syntax (E'...'). Noli ` transaction committed more than once kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='barcode' AND o_type=1 LIMIT 1" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "barcode_pkey" for table "barcode" kexi(7247)/KexiDB KexiDB::Connection::querySingleString: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() "SELECT o_id FROM kexi__objects WHERE o_type=1 AND lower(o_name)='barcode' LIMIT 1" kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='customer' AND o_type=1 LIMIT 1" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "customer_pkey" for table "customer" kexi(7247)/KexiDB KexiDB::Connection::querySingleString: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() "SELECT o_id FROM kexi__objects WHERE o_type=1 AND lower(o_name)='customer' LIMIT 1" kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='item' AND o_type=1 LIMIT 1" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "item_pkey" for table "item" kexi(7247)/KexiDB KexiDB::Connection::querySingleString: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() "SELECT o_id FROM kexi__objects WHERE o_type=1 AND lower(o_name)='item' LIMIT 1" kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='orderinfo' AND o_type=1 LIMIT 1" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "orderinfo_pkey" for table "orderinfo" kexi(7247)/KexiDB KexiDB::Connection::querySingleString: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() "SELECT o_id FROM kexi__objects WHERE o_type=1 AND lower(o_name)='orderinfo' LIMIT 1" kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='orderline' AND o_type=1 LIMIT 1" kexi(7247)/KexiDB KexiDB::Connection::querySingleString: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() "SELECT o_id FROM kexi__objects WHERE o_type=1 AND lower(o_name)='orderline' LIMIT 1" kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='stock' AND o_type=1 LIMIT 1" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "stock_pkey" for table "stock" kexi(7247)/KexiDB KexiDB::Connection::querySingleString: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() "SELECT o_id FROM kexi__objects WHERE o_type=1 AND lower(o_name)='stock' LIMIT 1" transaction committed more than once WARNING: nonstandard use of \' in a string literal LINE 1: INSERT INTO customer VALUES (14,'Mr ','Bill','O\''Neill','2... ^ HINT: Use '' to write quotes in strings, or use the escape string syntax (E'...'). ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Postgresql and Kexi 2.2 import database working?
Adam
It does not work in my side. I just lost my sample database in the
postgresql server when I tried creating first the same database in
kexi and then tried to import the database.
I am using ubuntu 10.04. I have been waiting for 15 minutes and
nothing happened.
n...@noli-laptop:~$ kexi
kexi(7516)/kdecore (services) KMimeTypeFactory::parseMagic: Now
parsing "/usr/share/mime/magic"
kexi(7516)/kio (KDirModel) KDirModelPrivate::_k_slotDeleteItems: No
node found for item that was just removed:
KUrl("file:///home/noli/Documents/OtagoData")
kexi(7516)/kio (KDirModel) KDirModelPrivate::_k_slotDeleteItems: No
node found for item that was just removed:
KUrl("file:///home/noli/Documents/OtagoData")
kDebugStream called after destruction (from virtual
KexiDB::AlterTableHandler::MoveFieldPositionAction::~MoveFieldPositionAction()
file ../../../kexi/kexidb/alter.cpp line 717)
0xb6854fa0
kDebugStream called after destruction (from virtual
KexiDB::AlterTableHandler::FieldActionBase::~FieldActionBase() file
../../../kexi/kexidb/alter.cpp line 105)
0xb6854fa0
kDebugStream called after destruction (from virtual
KexiDB::AlterTableHandler::ActionBase::~ActionBase() file
../../../kexi/kexidb/alter.cpp line 57)
0xb6854fa0
kDebugStream called after destruction (from virtual
KexiDB::AlterTableHandler::InsertFieldAction::~InsertFieldAction()
file ../../../kexi/kexidb/alter.cpp line 571)
0xb6854f80
kDebugStream called after destruction (from virtual
KexiDB::AlterTableHandler::FieldActionBase::~FieldActionBase() file
../../../kexi/kexidb/alter.cpp line 105)
0xb6854f80
kDebugStream called after destruction (from virtual
KexiDB::AlterTableHandler::ActionBase::~ActionBase() file
../../../kexi/kexidb/alter.cpp line 57)
0xb6854f80
kDebugStream called after destruction (from virtual
KexiDB::AlterTableHandler::RemoveFieldAction::~RemoveFieldAction()
file ../../../kexi/kexidb/alter.cpp line 492)
0xb6854f68
kDebugStream called after destruction (from virtual
KexiDB::AlterTableHandler::FieldActionBase::~FieldActionBase() file
../../../kexi/kexidb/alter.cpp line 105)
0xb6854f68
kDebugStream called after destruction (from virtual
KexiDB::AlterTableHandler::ActionBase::~ActionBase() file
../../../kexi/kexidb/alter.cpp line 57)
0xb6854f68
kDebugStream called after destruction (from virtual
KexiDB::AlterTableHandler::ChangeFieldPropertyAction::~ChangeFieldPropertyAction()
file ../../../kexi/kexidb/alter.cpp line 209)
0xb6854f40
kDebugStream called after destruction (from virtual
KexiDB::AlterTableHandler::FieldActionBase::~FieldActionBase() file
../../../kexi/kexidb/alter.cpp line 105)
0xb6854f40
kDebugStream called after destruction (from virtual
KexiDB::AlterTableHandler::ActionBase::~ActionBase() file
../../../kexi/kexidb/alter.cpp line 57)
0xb6854f40
n...@noli-laptop:~$
Noli
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Postgresql and Kexi 2.2 import database working?
Here's the log. Noli
~
n...@noli-laptop:~$ kexi
kexi(6542)/kdecore (services) KMimeTypeFactory::parseMagic: Now
parsing "/usr/share/mime/magic"
kexi(6542)/KexiDB (driver impl) KexiDB::pqxxSqlCursor::drv_open:
pqxxSqlCursor::drv_open:exception - "ERROR: relation "kexi__db" does
not exist
LINE 1: SELECT db_value FROM kexi__db WHERE db_property='kexidb_majo...
^
"
kexi(6542)/KexiDB KexiDB::Connection::querySingleString:
Connection::querySingleRecord(): !executeQuery() "SELECT db_value
FROM kexi__db WHERE db_property='kexidb_major_ver' LIMIT 1"
kexi(6542)/kio (KDirModel) KDirModelPrivate::_k_slotDeleteItems: No
node found for item that was just removed:
KUrl("file:///home/noli/Documents/OtagoData")
kexi(6542)/kio (KDirModel) KDirModelPrivate::_k_slotDeleteItems: No
node found for item that was just removed:
KUrl("file:///home/noli/Documents/OtagoData")
Closing connection while nontransaction still open
On 9/3/10, Adam Pigg wrote:
> Have you any output at the console to aid in this?
>
> Noli Sicad wrote:
>
>> Hi,
>>
>> I am moving away from Sqlite3 still there is no support at this
>> moment. I am migrating to postgresql / PostGIS and trying to import
>> the data in Kexi2.2
>>
>>
>> I am trying to import database from postgresql to Kexi 2.2 now. It is
>> connecting to the postgresql database but in the last stage of import
>> the database. It is stuck in "Importing" Form, the last stage next to
>> Finish.
>>
>> Now, is the Postgresql and Kexi 2,2 import database working?
>>
>> Thanks.
>>
>> Noli
>
>
> ___
> Kexi mailing list
> Kexi@kde.org
> https://mail.kde.org/mailman/listinfo/kexi
>
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Postgresql and Kexi 2.2 import database working?
Hi, I am moving away from Sqlite3 still there is no support at this moment. I am migrating to postgresql / PostGIS and trying to import the data in Kexi2.2 I am trying to import database from postgresql to Kexi 2.2 now. It is connecting to the postgresql database but in the last stage of import the database. It is stuck in "Importing" Form, the last stage next to Finish. Now, is the Postgresql and Kexi 2,2 import database working? Thanks. Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Python Script and Kexi2.2
Hi Adam, Thanks for the example. Noli On 9/3/10, Adam Pigg wrote: > Yes, i wrote one last night! :) > > At the bottom of: > http://userbase.kde.org/Kexi#Documentation.2C_Tutorials_and_Samples > > is a link to > http://kde-files.org/content/show.php?content=129683 > > Adam > > On Friday 03 September 2010 09:50:07 Noli Sicad wrote: >> Hi Adam, >> >> Do you have any kexi2.2 example that uses javascript to share. >> >> I think Kexi2.2 needs examples. I wonder why there is no template >> available. I am using Ubuntu 10.04 >> >> Noli >> >> On 9/3/10, 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 >> > :) >> > >> > Adam >> > >> > Jaroslaw Staniek wrote: >> >> 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. >> > >> > ___ >> > Kexi mailing list >> > Kexi@kde.org >> > https://mail.kde.org/mailman/listinfo/kexi > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Python Script and Kexi2.2
Hi Adam, Do you have any kexi2.2 example that uses javascript to share. I think Kexi2.2 needs examples. I wonder why there is no template available. I am using Ubuntu 10.04 Noli On 9/3/10, 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 :) > > Adam > > Jaroslaw Staniek wrote: > >> 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. >> > > > ___ > Kexi mailing list > Kexi@kde.org > https://mail.kde.org/mailman/listinfo/kexi > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Kexi file and Sqlite3 ODBC driver
If kexi has odbc support and odbc driver, then it supports all the databases i.e. present and future databases and any other data source. See how MS Access uses odbc. http://www.aspfree.com/c/a/Microsoft-Access/Importing-Data-into-MS-Acceess-with-ODBC/1/ Kexi can be even use in corporate world, not just for personal database management. Noli On 9/2/10, Noli Sicad wrote: > Linux and unix users are big users of odbc, 2 groups are extending > support in linux and unix > > http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/ > > http://www.unixodbc.org/ > > A good product must have support for odbc :-) > > Noli > > On 9/2/10, Noli Sicad wrote: >> Hi Jaroslaw, >> >>>> Any odbc driver for Kexi? >>> >>> We have code (in trunk/koffice/kexi/kexidb/drivers/odbc directory in >>> KDE SVN) but just lack maintainer, who would be someone using ODBC on >>> daily basis. >> >> We do systems modellers e.g. operations research like the >> glpk/mathprog, AMPL communities, business analysts and researchers are >> getting a lot of data from one source to other. >> >> http://www.mail-archive.com/help-g...@gnu.org/ >> >> Database users e.g. Sqlite users are big user of odbc. >> >> Is the odbc driver works in kexi2.2? Any tarball release that has odbc >> support? >> >> Noli >> > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Kexi file and Sqlite3 ODBC driver
Linux and unix users are big users of odbc, 2 groups are extending support in linux and unix http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/ http://www.unixodbc.org/ A good product must have support for odbc :-) Noli On 9/2/10, Noli Sicad wrote: > Hi Jaroslaw, > >>> Any odbc driver for Kexi? >> >> We have code (in trunk/koffice/kexi/kexidb/drivers/odbc directory in >> KDE SVN) but just lack maintainer, who would be someone using ODBC on >> daily basis. > > We do systems modellers e.g. operations research like the > glpk/mathprog, AMPL communities, business analysts and researchers are > getting a lot of data from one source to other. > > http://www.mail-archive.com/help-g...@gnu.org/ > > Database users e.g. Sqlite users are big user of odbc. > > Is the odbc driver works in kexi2.2? Any tarball release that has odbc > support? > > Noli > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Kexi file and Sqlite3 ODBC driver
Hi Jaroslaw, >> Any odbc driver for Kexi? > > We have code (in trunk/koffice/kexi/kexidb/drivers/odbc directory in > KDE SVN) but just lack maintainer, who would be someone using ODBC on > daily basis. We do systems modellers e.g. operations research like the glpk/mathprog, AMPL communities, business analysts and researchers are getting a lot of data from one source to other. http://www.mail-archive.com/help-g...@gnu.org/ Database users e.g. Sqlite users are big user of odbc. Is the odbc driver works in kexi2.2? Any tarball release that has odbc support? Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Sqlite, Spatialite, ODBC and Kexi
Hi Jaroslaw Thanks again for your reply. My idea is to use Kexi as user interface for my forest management and carbon sequestration linear programming modelling so farmers and foresters can use it very easily. I saw great potential of using Kexi since there is business graphics included for the results aside from interface into database i.e. sqlite / spatialite and postgresql / postgis. Spatialite and PostGIS are spatial databases. > SQLite is limited in terms of metadata and types declaration, that's the > reason. > Things at sqlite level improved since the decission was made, so that > gives some hope. This is good news. >> I think you can easily do support for sqlite and spatialite thru ODBC. >> I think you know that there is odbc for sqlite. I am using the odbc >> sqlite for my linear programming model. > > That's true but ODBC is by definition very limited stipped-down API. > Speaking of limited APIs, for _now_ you can always export your > native-sqlite database tables to CSV files and improt them, > one-by-one. It that's performed with care, you'll see the same tables > in the new .kexi file as in your current file. Yes, I did this. This is not the problem for me. I can always create the tables and let the user input the data or import the data. As mentioned, the end users are farmers, land owners and forester who are not really keen doing these things. > I fully understand - this is suboptimal. My problem is reading the kexi file outside kexi thru odbc. > Other way is to recreate empty tables in Kexi and then copy the data > by executing SQL scripts created by .dump command of sqlite. > Please check if the querying capability of Kexi is sufficient for you > before deciding to use it as a frontend these months. Yes, this is good idea. I use .loadshp in spatialite to import shapefile (ArcGIS polygons and data into spatialite. >> Is Kexi2.3 has support for sqlite? > > 2.4 or later would support it. Importance of the feature depends on > number of requests - you're the first showing so much interest. Support for sqlite in Kexi is winning feature for Kexi. It attacks a lot of users especially non programmers. Linux needs filemaker alternative and every filemaker users is looking for support for sqlite and postgresql. Augmenting the business graphics would be good as well. If there is support for python, we can use matplotlib for graphics. It just need a matplotlib container similar to Orange. http://www.ailab.si/orange/features.html http://matplotlib.sourceforge.net/ I tried glom and I think kexi is far advantage than glom. Kexi just needs some examples included in the package so users can start using i Thanks a lot. Regards, Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Kexi file and Sqlite3 ODBC driver
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: 1Time: 0.042 Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Python Script and Kexi2.2
Hi, I am searching the net for Python and Kexi2.2. It seems no entry. Is python script working in Kexi2.2? Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Simple Kexi2.2 Example Database with Python Script
Hi, I am trying to use Kexi2.2 as data input and result reporting for my linear programming model. I use glpk/mathprog that uses odbc to reading data as input and writing data for results. My linear programming model uses sqlite/spatialite database / file. I manage to import my mdb database to Kexi and I can open it sqlite and spatialite. Hopefully, I can data - tables / spatial data thru linear programming model - scripting language -mathprog and still be able to read back in Kexi. I am looking for a simple kexi2.2 database example that uses python script. To see how python script works in Kexi. Where can I get the kexi database that is mentioned here? http://www.kdedevelopers.org/node/3933 It seems that there are very few documentation on Kexi2.2. Thanks in advance. Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Simple Kexi2.2 Example Database with Python Script
Hi, I am trying to use Kexi2.2 as data input and result reporting for my linear programming model. I use glpk/mathprog that uses odbc to reading data as input and writing data for results. My linear programming model uses sqlite/spatialite database / file. I manage to import my mdb database to Kexi and I can open it sqlite and spatialite. Hopefully, I can data - tables / spatial data thru linear programming model - scripting language -mathprog and still be able to read back in Kexi. I am looking for a simple kexi2.2 database example that uses python script. To see how python script works in Kexi. Where can I get the kexi database that is mentioned here? http://www.kdedevelopers.org/node/3933 It seems that there are very few documentation on Kexi2.2. Thanks in advance. Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
