Re: Importing tables into Kexi
On 8/7/20 4:25 AM, Jaroslaw Staniek wrote: On Fri, 7 Aug 2020 at 00:22, Swarup <dinban...@sprynet.com> wrote: On 8/6/20 6:03 PM, Jaroslaw Staniek wrote: On Thu, 6 Aug 2020 at 21:40, Swarup <dinban...@sprynet.com> wrote: On 8/6/20 3:20 PM, Jaroslaw Staniek wrote: On Thu, 6 Aug 2020 at 20:04, Swarup <dinban...@sprynet.com> wrote: On 8/6/20 1:22 PM, Jaroslaw Staniek wrote: On Thu, 6 Aug 2020 at 19:14, Swarup <dinban...@sprynet.com> wrote: On 8/6/20 12:54 PM, Jaroslaw Staniek wrote: Hi Swarup KEXI can import individual tables from CSV at the moment. If that is the case then why is the .csv file I browse to greyed out in the import window. The import function is not permitting me to select the file of type .csv for import. "External Data -> Import Data from file" supports CSV. "External Data -> Import tables" supports TSV which is a special tab-based subset of CSV formats. Ok, I see how it works-- that is very good. Now: If I want to make adjustments in the parameters of the table, say, increasing the number of columns beyond the number currently in the .csv file, and increasing the number of characters permitted in a cell, do
Re: Importing tables into Kexi
On 8/6/20 6:03 PM, Jaroslaw Staniek wrote: On Thu, 6 Aug 2020 at 21:40, Swarup <dinban...@sprynet.com> wrote: On 8/6/20 3:20 PM, Jaroslaw Staniek wrote: On Thu, 6 Aug 2020 at 20:04, Swarup <dinban...@sprynet.com> wrote: On 8/6/20 1:22 PM, Jaroslaw Staniek wrote: On Thu, 6 Aug 2020 at 19:14, Swarup <dinban...@sprynet.com> wrote: On 8/6/20 12:54 PM, Jaroslaw Staniek wrote: Hi Swarup KEXI can import individual tables from CSV at the moment. If that is the case then why is the .csv file I browse to greyed out in the import window. The import function is not permitting me to select the file of type .csv for import. "External Data -> Import Data from file" supports CSV. "External Data -> Import tables" supports TSV which is a special tab-based subset of CSV formats. Ok, I see how it works-- that is very good. Now: If I want to make adjustments in the parameters of the table, say, increasing the number of columns beyond the number currently in the .csv file, and increasing the number of characters permitted in a cell, do I do that before or after carrying out the import procedure? Before because altering table in-place is not supported at the moment. But the table doesn't exist in Kexi until I import the .csv file. There is no table for which to go into design view and alter the parameters. Upon importing the .csv, the table gets created. So before importing the .csv,where is the table in which I would go into design view and add more columns, and increase the number of characters permitted per cell? That would be a good extra feature of the importer. I think it was not planned because it is easier to envision one the table altering feature that servers all the needs. Unfortunately that altering has not been delivered yet. One feature (altering) would be also less things to manage. Sure, that is a good idea going forward. But I need to understand what you meant by "Before because altering table in-place is not supported at the mom
Re: Importing tables into Kexi
On 8/6/20 3:20 PM, Jaroslaw Staniek wrote: On Thu, 6 Aug 2020 at 20:04, Swarup <dinban...@sprynet.com> wrote: On 8/6/20 1:22 PM, Jaroslaw Staniek wrote: On Thu, 6 Aug 2020 at 19:14, Swarup <dinban...@sprynet.com> wrote: On 8/6/20 12:54 PM, Jaroslaw Staniek wrote: Hi Swarup KEXI can import individual tables from CSV at the moment. If that is the case then why is the .csv file I browse to greyed out in the import window. The import function is not permitting me to select the file of type .csv for import. "External Data -> Import Data from file" supports CSV. "External Data -> Import tables" supports TSV which is a special tab-based subset of CSV formats. Ok, I see how it works-- that is very good. Now: If I want to make adjustments in the parameters of the table, say, increasing the number of columns beyond the number currently in the .csv file, and increasing the number of characters permitted in a cell, do I do that before or after carrying out the import procedure? Before because altering table in-place is not supported at the moment. But the table doesn't exist in Kexi until I import the .csv file. There is no table for which to go into design view and alter the parameters. Upon importing the .csv, the table gets created. So before importing the .csv,where is the table in which I would go into design view and add more columns, and increase the number of characters permitted per cell? Also I wanted to point out that the CSV format: - does not define representation of multiple tables - does not define constraints like the permitted characters This is all application defined. MDB defines it so it could be useful for the import. On Thu, 6 Aug 2020 at 17:14, Swarup <dinban...@sprynet.com> wrote: Hi there, So I have installed KDE Neon on my system using VM Ware, and by installing kexi there found that the export function worked and I was able to export my table from kexi, as a file of .csv format, which is perfect. I would like to now important that .csv table back into kexi, this time adding more columns and increasing the number of permitted characters per cell. So I
Re: Importing tables into Kexi
On 8/6/20 12:54 PM, Jaroslaw Staniek wrote: Hi Swarup KEXI can import individual tables from CSV at the moment. If that is the case then why is the .csv file I browse to greyed out in the import window. The import function is not permitting me to select the file of type .csv for import. Also I wanted to point out that the CSV format: - does not define representation of multiple tables - does not define constraints like the permitted characters This is all application defined. MDB defines it so it could be useful for the import. On Thu, 6 Aug 2020 at 17:14, Swarup <dinban...@sprynet.com> wrote: Hi there, So I have installed KDE Neon on my system using VM Ware, and by installing kexi there found that the export function worked and I was able to export my table from kexi, as a file of .csv format, which is perfect. I would like to now important that .csv table back into kexi, this time adding more columns and increasing the number of permitted characters per cell. So I brought the .csv file over to my Ubuntu OS, and in Ubuntu I opened Kexi and opened the import function. However when I browse to the folder where the .csv file is located, everything is grayed out including the .csv file. Can Kexi import tables of type .csv, or does the file have to be of type .mdb? Thanks, Swarup
Importing tables into Kexi
Hi there, So I have installed KDE Neon on my system using VM Ware, and by installing kexi there found that the export function worked and I was able to export my table from kexi, as a file of .csv format, which is perfect. I would like to now important that .csv table back into kexi, this time adding more columns and increasing the number of permitted characters per cell. So I brought the .csv file over to my Ubuntu OS, and in Ubuntu I opened Kexi and opened the import function. However when I browse to the folder where the .csv file is located, everything is grayed out including the .csv file. Can Kexi import tables of type .csv, or does the file have to be of type .mdb? Thanks, Swarup
Re: Basic Questions
On 7/31/20 9:26 AM, Jaroslaw Staniek wrote: On Thu, 30 Jul 2020 at 23:26, Swarup <dinban...@sprynet.com> wrote: On 7/30/20 5:02 PM, Jaroslaw Staniek wrote: On Thu, 30 Jul 2020 at 21:44, Swarup <dinban...@sprynet.com> wrote: On 7/30/20 3:32 PM, Jaroslaw Staniek wrote: On Thu, 30 Jul 2020 at 17:38, Swarup <dinban...@sprynet.com> wrote: Hello 1. I am using Kexi Version 3.1.0 in Ubuntu 19.04. 2. I have very basic needs, such as the need to be able to add another column without erasing all my data, and the need to increase the number of characters allowed in a cell, without that change erasing all my data. As I understand, these things cannot be done in Version 3.1.0. Hello. Right. First step is to upgrade to 3.2. This topic can be studied here https://forum.kde.org/viewtopic.php?f=221=132264 3. Is there a very easy, user friendly way to update to the latest version of Kexi? Always three ways as follows, whatever suits best: 1. Request an easy way from your distributor 2. Change the distributor 3. Install a Flatpak snapshot https://community.kde.org/Kexi/Snapshots There is no point in me upgrading to the laterst version, if that version doesn't have the feature of allowing me to add columns or increase the number of allowed characters in a cell without erasing the data. 4. Otherwise, I would like to export my data from Kexi and migrate over to MS Access. I have been using Kexi for many, many years-- but these basic limitations have made my work impossible. I am sorry about that. The forum thread explains a bit the fact that these features mean larger endeavours so we need
Re: Basic Questions
On 7/30/20 3:32 PM, Jaroslaw Staniek wrote: On Thu, 30 Jul 2020 at 17:38, Swarup <dinban...@sprynet.com> wrote: Hello 1. I am using Kexi Version 3.1.0 in Ubuntu 19.04. 2. I have very basic needs, such as the need to be able to add another column without erasing all my data, and the need to increase the number of characters allowed in a cell, without that change erasing all my data. As I understand, these things cannot be done in Version 3.1.0. Hello. Right. First step is to upgrade to 3.2. This topic can be studied here https://forum.kde.org/viewtopic.php?f=221=132264 3. Is there a very easy, user friendly way to update to the latest version of Kexi? Always three ways as follows, whatever suits best: 1. Request an easy way from your distributor 2. Change the distributor 3. Install a Flatpak snapshot https://community.kde.org/Kexi/Snapshots There is no point in me upgrading to the laterst version, if that version doesn't have the feature of allowing me to add columns or increase the number of allowed characters in a cell without erasing the data. 4. Otherwise, I would like to export my data from Kexi and migrate over to MS Access. I have been using Kexi for many, many years-- but these basic limitations have made my work impossible. I am sorry about that. The forum thread explains a bit the fact that these features mean larger endeavours so we need more contributors on board. 5. I do not see any option in Kexi to export my data to say csv. This is an import option, but I do not see an export option. Where is the option to export my data? Users can export each table by right-clicking and exporting to a file. This does not work. Any time I right click and select to export to a file, kexi crashes and shuts down. I have seen this same problem reported by several other users in the Ubuntu forums. Because these are SQLite tables, users can also run apps like sqlitebrowser to export all tables in one go (File->Export->CSV). I am not a techy to start learning how to use apps like sqlitebrowser. I need to get my data out of kexi, and from what I am hearing from you thus far it sounds, unfortunately, like my data is trapped in kexi and unable to get out. Please provide me a simple solution that works to export my data from Kexi. This is urgently needed. Thank you, Swarup
Re: Basic Questions
In years past I have asked for solutions to the below items #2 and #3, but there were none and so your team asked me to submit a request for them, and I did that. If there are still no solutions, please kindly at least just tell me how to export my data from Kexi. I need to get on with my work and need a platform which will allow for those functions. On 7/30/20 11:38 AM, Swarup wrote: Helllo 1. I am using Kexi Version 3.1.0 in Ubuntu 19.04. 2. I have very basic needs, such as the need to be able to add another column without erasing all my data, and the need to increase the number of characters allowed in a cell, without that change erasing all my data. As I understand, these things cannot be done in Version 3.1.0. 3. Is there a very easy, user friendly way to update to the latest version of Kexi? 4. Otherwise, I would like to export my data from Kexi and migrate over to MS Access. I have been using Kexi for many, many years-- but these basic limitations have made my work impossible. 5. I do not see any option in Kexi to export my data to say csv. This is an import option, but I do not see an export option. Where is the option to export my data? Thanks, Swarup
Basic Questions
Helllo 1. I am using Kexi Version 3.1.0 in Ubuntu 19.04. 2. I have very basic needs, such as the need to be able to add another column without erasing all my data, and the need to increase the number of characters allowed in a cell, without that change erasing all my data. As I understand, these things cannot be done in Version 3.1.0. 3. Is there a very easy, user friendly way to update to the latest version of Kexi? 4. Otherwise, I would like to export my data from Kexi and migrate over to MS Access. I have been using Kexi for many, many years-- but these basic limitations have made my work impossible. 5. I do not see any option in Kexi to export my data to say csv. This is an import option, but I do not see an export option. Where is the option to export my data? Thanks, Swarup
Re: How to change the number of characters allowed in a cell without erasing all the data in the table
Hello Jaroslaw, I was so happy to hear your good news. I opened my Kexi table, went into design view, and increased the maximum number of allowed characters for each of my fields of type "text", from 200 to 1000. Went again clicked on the tab to switch back to data view, I got the below message. On the basis of the below, I had to discard the changes I had made, by clicking on "Discard design". You wrote below that this problem was fixed a long time ago. Are you sure about that? Or if there is another way to do this aside from what I did, please let me know. Thanks Swarup On 5/27/19 2:32 PM, Jaroslaw Staniek wrote: On Fri, 24 May 2019 at 00:40, Swarup <dinban...@sprynet.com> wrote: I am using Kexi Version 3.1.0. In earlier versions it was the case that if one were to go into design view and change the settings, such as the setting for the number of characters allowed in each cell, the program would delete all the data in the table. Is that still the case? Hello Swarup Thanks for the question. For quite long time already (3.0?) KEXI does not require removal or recreation of the table if modified property is of such non-fundamental kind. So no worries here. I would very much like to increase the number of characters allowed in each cell, or remove the limit altogether. But cannot afford to lose my data. Also no worries here. If removal or recreation of the table is required KEXI _always_ tells you that and asks for confirmation prior to the change. You then have the opportunity to abandon changes made to the project recently. PS: Sorry, I've been away from keyboard for several days. -- regards, Jaroslaw Staniek KDE: : A world-wide network of software engineers, artists, writers, translators : and facilitators committed to Free Software development - kde.org KEXI: : A visual database apps builder - kexi-project.org calligra.org/kexi twitter.com/kexi_project facebook.com/kexi.project t.me/kexi_project Qt Certified Specialist: : linkedin.com/in/jstaniek
How to collapse table list on left of open table in data view in Kexi 3.1.0
I am using Kexi Version 3.1.0. In earlier versions there used to be a way to collapse the list of tables on the left of the open table in data view, so as to have more room for the open table. I am not seeing any option for that now. Is there a way to do it? Thanks, Swarup
Adding rows in Kexi 3.1.0
I am using Kexi Version 3.1.0. Is there a way to insert a row above/below the current row in an existing table? Thanks, Swarup
Re: [Kexi] Kexi 2.9.11 released
On 04/28/2016 03:26 PM, Jaroslaw Staniek wrote: On 13 April 2016 at 21:29, Jaroslaw Staniek <stan...@kde.org> wrote: On 8 April 2016 at 19:54, Jaroslaw Staniek <stan...@kde.org> wrote: On Thursday, 7 April 2016, Swarup <dinban...@sprynet.com> wrote: Hello there, Any improvements made in providing ability for Ubuntu users to upgrade to later versions? I'm still stuck in-- Kexi Version 2.8.5 Hi I am sorry that ubuntu offers no such support for free software. Upgrading the OS can be an option. Or requesting support from ubuntu or someone who can develop a backport. This can be requested on an ubuntu forum. Hi, A modern way of distributing software may help us soon: http://www.omgubuntu.co.uk/2016/04/ubuntu-16-04-lts-snap-packages PS: Another approach for deployment of Kexi is in our backlog, compatible with more Linuxes: http://appimage.org/ The site you are providing here is a generic tool. Are you saying that I would need to use this tool to make a version of Kexi that will run in Ubuntu? ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Kexi 2.9.11 released
On 04/15/2016 11:10 AM, Jaroslaw Staniek wrote: On 15 April 2016 at 14:47, Swarup <dinban...@sprynet.com> wrote: 2. Will the version of Kexi which is included have the following features: -Ability to add rows to the middle of a table which is already in existence I see how it may be usable. It's not supported now. Database table is not a spreadsheet's sheet, so the order is defined by current sorting, for given column, based on contents. Even if we have this feature, placement of a new row would be kept until another sorting or re-opening the table view. This my be the reason why I know no software that supports the feature. MS Access has this feature, and has had it for many, many years. All the features I asked about are long-held features of MS Access. I migrated from Windows to Linux ten years ago and have been with Linux systems ever since, but these features of MS Access are things I sorely miss. My brother also works on Ubuntu on his Mac, and has installed Parallels (virtual software) so he could install Windows, just so that he could use MS Access. -Ability to add columns to the middle of a table which is already in existence Yes, it has been available for a long time. But table is recreated then from scratch without prior data. We're collecting funds for this big development: https://www.bountysource.com/issues/26881135-add-support-for-alter-table-s-design-without-losing-data It it destroys all the data, the feature is of no use. Again, this has been a standard feature of MSA for many, many years. One can do any sort of manipulation of an MSA table: rearrange rows, rearrange columns, rename columns, add new rows and columns in the middle of pre-existing tables, highlight and copy-paste sections of the table and past it in other sections of the table. The MSA table is so fluid and flexible. And it is this very maneuverability that Liinux users still write about and lament the loss of when they moved to Linux. -Ability to change the name of a column in an existing table. (Currently this requires going into the data view, with the warning that making any changes will wipe out all the data in the table) It's unsupported like the above. -Ability to move existing rows/columns in a table which is already in existence This wish is reported, feel free to vote for it. https://bugs.kde.org/show_bug.cgi?id=361362 My intent here was not at all to rub Kexi's nose in the dirt; I know you are working hard and I appreciate the progress you've made. I only raised the subject as you said you'd never seen any DB software that has the row-adding feature. In my mind, if I have to describe the ideal DB software today though, it does still remain MSA. If you are able to replicate the amazing features in MSA, you will have truly created an amazing tool for Linux users. Swarup ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Kexi 2.9.11 released
On 04/15/2016 09:15 AM, Jaroslaw Staniek wrote: On 15 April 2016 at 14:47, Swarup <dinban...@sprynet.com <mailto:dinban...@sprynet.com>> wrote: On 04/15/2016 08:29 AM, Jaroslaw Staniek wrote: On 15 April 2016 at 14:07, Swarup <dinban...@sprynet.com <mailto:dinban...@sprynet.com>> wrote: On 04/15/2016 07:45 AM, Jaroslaw Staniek wrote: On 15 April 2016 at 13:36, Swarup <dinban...@sprynet.com <mailto:dinban...@sprynet.com>> wrote: On 04/13/2016 03:29 PM, Jaroslaw Staniek wrote: On 8 April 2016 at 19:54, Jaroslaw Staniek<stan...@kde.org> <mailto:stan...@kde.org> wrote: On Thursday, 7 April 2016, Swarup<dinban...@sprynet.com> <mailto:dinban...@sprynet.com> wrote: Hello there, Any improvements made in providing ability for Ubuntu users to upgrade to later versions? I'm still stuck in-- Kexi Version 2.8.5 Hi I am sorry that ubuntu offers no such support for free software. Upgrading the OS can be an option. Or requesting support from ubuntu or someone who can develop a backport. This can be requested on an ubuntu forum. Hi, A modern way of distributing software may help us soon: http://www.omgubuntu.co.uk/2016/04/ubuntu-16-04-lts-snap-packages Looks wonderful-- I am really looking forward to the day when I'll be able to upgrade kexi versions. The version I have right now is so dysfunctional. Any time the mouse crosses from the left side of the screen into the left side of the table, it makes the table jump to the top. This is endlessly frustrating and a huge waste of time. Say I am working in row #750, the mouse moves across the left border of the table and all of a sudden the table jumps to row#1. If there is any fix for this, please advise. All this was long ago fixed. My advice is to upgrade the OS or install another copy in a virtual machine or different computer. Regardless of availability of the Snap packages, staying with outdated software on LTS platforms will be always a compromise. It's not a problem for apps that do not evolve much anymore but Kexi is actively developed and users are hungry for features :) We'll be looking for a way when practically every week new updates appear for Kexi. There are so many software packages which update regularly every week with the Ubuntu update manager-- it happens automatically. If Kexi could be incorporated into this feature, it would be great. OK. Do you mean official packages from Canonical or do you have unofficial repositories added? Either would be perfectly fine. As for upgrading the OS, the Final Version of the new Ubuntu LTS 16.04 is coming out on April 21. My current LTS 14.04 is in all other regards functioning wonderfully, and I would have no other reason to upgrade given my own specific usage patterns and needs. Upgrading would only be done for getting an updated Kexi, and for me upgrading Ubuntu on a MacBook Pro is not a small job. So this being the case, let me just ask the following questions: I can't see updates for even new Ubuntu on this web page, 2.9.7 is too old: http://packages.ubuntu.com/xenial/kexi Does this mean that 16.04 is going to install an old version of kexi? Or are you saying you don't know what version of Kexi it will install? There's contact email kubuntu-de...@lists.ubuntu.com <mailto:kubuntu-de...@lists.ubuntu.com> to the developers where yo ucan ask for help. But have you tried this advice? http://www.askmetutorials.com/2016/02/install-calligra-office-suite-2911-on.html Now this is very exciting indeed. I will definitely try this-- right now. Do I need to first uninstall my existing version of Kexi? And if so, can I use the Ubuntu software manager to do the install? Or can I leave the current install in place and install 2.9.11 alongside it? There can be only one version installed in one system, and the system would only propose installation is newer version is found. I just now uninstalled kexi using the Ubuntu software manager, and then followed the listed tutorial for the new install of Calligra 2.9.11. But to my surprise, it merely re-installed the very same old version which I've had for ages (Kexi Version 2.8.5, Using KDE Platform Version 4.14.13). So I'm afraid the tutorial is not working for installing Calligra 2.9.11. It just installs the ages old version of KOffice which comes with
Re: [Kexi] Kexi 2.9.11 released [updated post]
*Correction*-- see below ... On 04/15/2016 08:29 AM, Jaroslaw Staniek wrote: On 15 April 2016 at 14:07, Swarup <dinban...@sprynet.com <mailto:dinban...@sprynet.com>> wrote: On 04/15/2016 07:45 AM, Jaroslaw Staniek wrote: On 15 April 2016 at 13:36, Swarup <dinban...@sprynet.com> wrote: On 04/13/2016 03:29 PM, Jaroslaw Staniek wrote: On 8 April 2016 at 19:54, Jaroslaw Staniek<stan...@kde.org> <mailto:stan...@kde.org> wrote: On Thursday, 7 April 2016, Swarup<dinban...@sprynet.com> <mailto:dinban...@sprynet.com> wrote: Hello there, Any improvements made in providing ability for Ubuntu users to upgrade to later versions? I'm still stuck in-- Kexi Version 2.8.5 Hi I am sorry that ubuntu offers no such support for free software. Upgrading the OS can be an option. Or requesting support from ubuntu or someone who can develop a backport. This can be requested on an ubuntu forum. Hi, A modern way of distributing software may help us soon: http://www.omgubuntu.co.uk/2016/04/ubuntu-16-04-lts-snap-packages Looks wonderful-- I am really looking forward to the day when I'll be able to upgrade kexi versions. The version I have right now is so dysfunctional. Any time the mouse crosses from the left side of the screen into the left side of the table, it makes the table jump to the top. This is endlessly frustrating and a huge waste of time. Say I am working in row #750, the mouse moves across the left border of the table and all of a sudden the table jumps to row#1. If there is any fix for this, please advise. All this was long ago fixed. My advice is to upgrade the OS or install another copy in a virtual machine or different computer. Regardless of availability of the Snap packages, staying with outdated software on LTS platforms will be always a compromise. It's not a problem for apps that do not evolve much anymore but Kexi is actively developed and users are hungry for features :) We'll be looking for a way when practically every week new updates appear for Kexi. There are so many software packages which update regularly every week with the Ubuntu update manager-- it happens automatically. If Kexi could be incorporated into this feature, it would be great. OK. Do you mean official packages from Canonical or do you have unofficial repositories added? As for upgrading the OS, the Final Version of the new Ubuntu LTS 16.04 is coming out on April 21. My current LTS 14.04 is in all other regards functioning wonderfully, and I would have no other reason to upgrade given my own specific usage patterns and needs. Upgrading would only be done for getting an updated Kexi, and for me upgrading Ubuntu on a MacBook Pro is not a small job. So this being the case, let me just ask the following questions: I can't see updates for even new Ubuntu on this web page, 2.9.7 is too old: http://packages.ubuntu.com/xenial/kexi Does this mean that 16.04 is going to install an old version of kexi? Or are you saying you don't know what version of Kexi it will install? There's contact email kubuntu-de...@lists.ubuntu.com <mailto:kubuntu-de...@lists.ubuntu.com> to the developers where yo ucan ask for help. But have you tried this advice? http://www.askmetutorials.com/2016/02/install-calligra-office-suite-2911-on.html Now this is very exciting indeed. I will definitely try this-- right now. Do I need to first uninstall my existing version of Kexi? And if so, is it ok to use the Ubuntu software manager to do the *uninstall *? Or can I leave the current install in place and install 2.9.11 alongside it? 1. By upgrading to 16.04 LTS, will I get the latest finalized version of Kexi? Or if not, which version of Kexi will be included in Ubuntu 16.04? 2. Will the version of Kexi which is included have the following features: -Ability to add rows to the middle of a table which is already in existence -Ability to add columns to the middle of a table which is already in existence -Ability to change the name of a column in an existing table. (Currently this requires going into the data view, with the warning that making any changes will wipe out all the data in the table) -Ability to move existing rows/columns in a table which is already in existence Have these features not yet been developed then? Thanks, Swarup ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Kexi 2.9.11 released
On 04/15/2016 08:29 AM, Jaroslaw Staniek wrote: On 15 April 2016 at 14:07, Swarup <dinban...@sprynet.com <mailto:dinban...@sprynet.com>> wrote: On 04/15/2016 07:45 AM, Jaroslaw Staniek wrote: On 15 April 2016 at 13:36, Swarup <dinban...@sprynet.com <mailto:dinban...@sprynet.com>> wrote: On 04/13/2016 03:29 PM, Jaroslaw Staniek wrote: On 8 April 2016 at 19:54, Jaroslaw Staniek<stan...@kde.org> <mailto:stan...@kde.org> wrote: On Thursday, 7 April 2016, Swarup<dinban...@sprynet.com> <mailto:dinban...@sprynet.com> wrote: Hello there, Any improvements made in providing ability for Ubuntu users to upgrade to later versions? I'm still stuck in-- Kexi Version 2.8.5 Hi I am sorry that ubuntu offers no such support for free software. Upgrading the OS can be an option. Or requesting support from ubuntu or someone who can develop a backport. This can be requested on an ubuntu forum. Hi, A modern way of distributing software may help us soon: http://www.omgubuntu.co.uk/2016/04/ubuntu-16-04-lts-snap-packages Looks wonderful-- I am really looking forward to the day when I'll be able to upgrade kexi versions. The version I have right now is so dysfunctional. Any time the mouse crosses from the left side of the screen into the left side of the table, it makes the table jump to the top. This is endlessly frustrating and a huge waste of time. Say I am working in row #750, the mouse moves across the left border of the table and all of a sudden the table jumps to row#1. If there is any fix for this, please advise. All this was long ago fixed. My advice is to upgrade the OS or install another copy in a virtual machine or different computer. Regardless of availability of the Snap packages, staying with outdated software on LTS platforms will be always a compromise. It's not a problem for apps that do not evolve much anymore but Kexi is actively developed and users are hungry for features :) We'll be looking for a way when practically every week new updates appear for Kexi. There are so many software packages which update regularly every week with the Ubuntu update manager-- it happens automatically. If Kexi could be incorporated into this feature, it would be great. OK. Do you mean official packages from Canonical or do you have unofficial repositories added? As for upgrading the OS, the Final Version of the new Ubuntu LTS 16.04 is coming out on April 21. My current LTS 14.04 is in all other regards functioning wonderfully, and I would have no other reason to upgrade given my own specific usage patterns and needs. Upgrading would only be done for getting an updated Kexi, and for me upgrading Ubuntu on a MacBook Pro is not a small job. So this being the case, let me just ask the following questions: I can't see updates for even new Ubuntu on this web page, 2.9.7 is too old: http://packages.ubuntu.com/xenial/kexi Does this mean that 16.04 is going to install an old version of kexi? Or are you saying you don't know what version of Kexi it will install? There's contact email kubuntu-de...@lists.ubuntu.com <mailto:kubuntu-de...@lists.ubuntu.com> to the developers where yo ucan ask for help. But have you tried this advice? http://www.askmetutorials.com/2016/02/install-calligra-office-suite-2911-on.html Now this is very exciting indeed. I will definitely try this-- right now. Do I need to first uninstall my existing version of Kexi? And if so, can I use the Ubuntu software manager to do the install? Or can I leave the current install in place and install 2.9.11 alongside it? 1. By upgrading to 16.04 LTS, will I get the latest finalized version of Kexi? Or if not, which version of Kexi will be included in Ubuntu 16.04? 2. Will the version of Kexi which is included have the following features: -Ability to add rows to the middle of a table which is already in existence -Ability to add columns to the middle of a table which is already in existence -Ability to change the name of a column in an existing table. (Currently this requires going into the data view, with the warning that making any changes will wipe out all the data in the table) -Ability to move existing rows/columns in a table which is already in existence Have these features not yet been developed then? Thanks, Swarup ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Kexi 2.9.11 released
On 04/15/2016 07:45 AM, Jaroslaw Staniek wrote: On 15 April 2016 at 13:36, Swarup <dinban...@sprynet.com <mailto:dinban...@sprynet.com>> wrote: On 04/13/2016 03:29 PM, Jaroslaw Staniek wrote: On 8 April 2016 at 19:54, Jaroslaw Staniek<stan...@kde.org> <mailto:stan...@kde.org> wrote: On Thursday, 7 April 2016, Swarup<dinban...@sprynet.com> <mailto:dinban...@sprynet.com> wrote: Hello there, Any improvements made in providing ability for Ubuntu users to upgrade to later versions? I'm still stuck in-- Kexi Version 2.8.5 Hi I am sorry that ubuntu offers no such support for free software. Upgrading the OS can be an option. Or requesting support from ubuntu or someone who can develop a backport. This can be requested on an ubuntu forum. Hi, A modern way of distributing software may help us soon: http://www.omgubuntu.co.uk/2016/04/ubuntu-16-04-lts-snap-packages Looks wonderful-- I am really looking forward to the day when I'll be able to upgrade kexi versions. The version I have right now is so dysfunctional. Any time the mouse crosses from the left side of the screen into the left side of the table, it makes the table jump to the top. This is endlessly frustrating and a huge waste of time. Say I am working in row #750, the mouse moves across the left border of the table and all of a sudden the table jumps to row#1. If there is any fix for this, please advise. All this was long ago fixed. My advice is to upgrade the OS or install another copy in a virtual machine or different computer. Regardless of availability of the Snap packages, staying with outdated software on LTS platforms will be always a compromise. It's not a problem for apps that do not evolve much anymore but Kexi is actively developed and users are hungry for features :) We'll be looking for a way when practically every week new updates appear for Kexi. There are so many software packages which update regularly every week with the Ubuntu update manager-- it happens automatically. If Kexi could be incorporated into this feature, it would be great. As for upgrading the OS, the Final Version of the new Ubuntu LTS 16.04 is coming out on April 21. My current LTS 14.04 is in all other regards functioning wonderfully, and I would have no other reason to upgrade given my own specific usage patterns and needs. Upgrading would only be done for getting an updated Kexi, and for me upgrading Ubuntu on a MacBook Pro is not a small job. So this being the case, let me just ask the following questions: 1. By upgrading to 16.04 LTS, will I get the latest finalized version of Kexi? Or if not, which version of Kexi will be included in Ubuntu 16.04? 2. Will the version of Kexi which is included have the following features: -Ability to add rows to the middle of a table which is already in existence -Ability to add columns to the middle of a table which is already in existence -Ability to change the name of a column in an existing table. (Currently this requires going into the data view, with the warning that making any changes will wipe out all the data in the table) -Ability to move existing rows/columns in a table which is already in existence If these table features have also been incorporated, then that will also provide tremendous inspiration to do the OS upgrade. (If it is just the previously described table-jumps-to-row#1 bug which has been fixed, I will still consider upgrading but I have adjusted myself through long practice to this bug so that I don't cross that table border when working in Kexi.) Swarup ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Kexi 2.9.11 released
On 04/13/2016 03:29 PM, Jaroslaw Staniek wrote: On 8 April 2016 at 19:54, Jaroslaw Staniek <stan...@kde.org> wrote: On Thursday, 7 April 2016, Swarup <dinban...@sprynet.com> wrote: Hello there, Any improvements made in providing ability for Ubuntu users to upgrade to later versions? I'm still stuck in-- Kexi Version 2.8.5 Hi I am sorry that ubuntu offers no such support for free software. Upgrading the OS can be an option. Or requesting support from ubuntu or someone who can develop a backport. This can be requested on an ubuntu forum. Hi, A modern way of distributing software may help us soon: http://www.omgubuntu.co.uk/2016/04/ubuntu-16-04-lts-snap-packages Looks wonderful-- I am really looking forward to the day when I'll be able to upgrade kexi versions. The version I have right now is so dysfunctional. Any time the mouse crosses from the left side of the screen into the left side of the table, it makes the table jump to the top. This is endlessly frustrating and a huge waste of time. Say I am working in row #750, the mouse moves across the left border of the table and all of a sudden the table jumps to row#1. If there is any fix for this, please advise. ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] When cursor crosses border between Project Navigator and Table Data it abruptly shifts table to beginning
I have upgraded to Kexi 2.8.5 successfully. The problem described below remains unchanged. I cannot imagine that anyone who is facing this issue would want to use Kexi in this condition. Let's say a table has 500 rows, and you are looking at row #230. If your cursor happens to cross the border between the table data and the project manager (as inevitably occurs in the process of normal work), the table abruptly jumps to row number one. It becomes impossible to do any work. Please let me know about this. Thanks, Swarup On 07/18/2014 05:22 PM, Jaroslaw Staniek wrote: On 18 July 2014 14:59, Swarup dinban...@sprynet.com wrote: I have been using Kexi for many years. Recently I upgraded to the latest Ubuntu, 14.04. The version of Kexi available in the 14.04 Ubuntu Software Center has a serious problem. Any time the cursor crosses the border between the Project Navigator and the Table Data, the table abruptly jumps to the beginning. This is extremely disruptive to doing any work in the table. Please kindly let me know how this matter can be resolved. Hi, thanks for the contact. Kexi 2.8 (the newer, the better, currently released is 2.8.5, available in http://www.ubuntuupdates.org/ppa/kubuntu_updates?dist=trusty and it's mentioned at https://userbase.kde.org/Calligra/Download#Kubuntu too) has fixed a series of similar bugs: https://bugs.kde.org/show_bug.cgi?id=329892#c1 I hope this is the one you're reporting. I mentioned Kubuntu but you're not forced to change desktop to Plasma by KDE. You'd be just able to update Kexi as well. I do not know what version of Kexi it is, as I could not find an about option or a help option that would enlist it for me. Look at the drop-down Help menu ? button near the top-right Search field: https://www.calligra.org/wp-content/uploads/2011/09/kexi-2.4-startup-new-project.png Also, typing 'kexi --version' in console can disclose the info. ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] When cursor crosses border between Project Navigator and Table Data it abruptly shifts table to beginning
I have been using Kexi for many years. Recently I upgraded to the latest Ubuntu, 14.04. The version of Kexi available in the 14.04 Ubuntu Software Center has a serious problem. Any time the cursor crosses the border between the Project Navigator and the Table Data, the table abruptly jumps to the beginning. This is extremely disruptive to doing any work in the table. Please kindly let me know how this matter can be resolved. I do not know what version of Kexi it is, as I could not find an about option or a help option that would enlist it for me. ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] How to select (highlight) one column in Kexi 1.1.3?
Hello, I am using Kexi 1.1.3 (KOffice 1.6.3), and have a table of around 500 rows. I need to be able to highlight one full column for: 1. printing the data in that column only; 2. copy/pasting the data in that column into another application, for example OO Writer. I would also like to be able to highlight part of the column for the same above two purposes-- for example say, 25 rows only of one column, for copy/paste or for printing. How does one carry out the above? It does not seem to highlight when I make the attempt. Thanks! Swarup ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi