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 th
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&t=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
Re: Basic Questions
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&t=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. That may be the reason for upgrading... Are you telling me that if I upgrade, then the export feature will work? Or are you guessing that it may work? Before I start putting big effort (which is what I know it is going to be, nothing with Kexi is straightforward), into upgrading, I want to know positively if the export feature works dependably or not. Because
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&t=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
Jaroslaw,
Created the bug report yesterday. Looking forward to the workaround.
Thanks,
Swarup
On 5/27/19 4:48 PM, Jaroslaw Staniek
wrote:
On Mon, 27 May 2019 at
22:35, Swarup <dinban...@sprynet.com>
wrote:
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.
Swarup,
I
double checked and I see I had no data in my test table,
that's why I observe different message. I also confused the
property with the "Default value" property.
It
would be best if you add a bug report to bugs.kde.org then, thanks.
In
the report I will be can recommend a warkaround for you for
changing the property without removing data.
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 databa
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 change the number of characters allowed in a cell without erasing all the data in the table
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? 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. Thanks, Swarup
How to change the number of characters allowed in a cell without erasing all the data in the table
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? 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. Thanks, Swarup
Re: How to collapse table list on left of open table in data view in Kexi 3.1.0
Thank you.
Please note:
On my computer, toggling the Al+0 alternatively shows and hides the
list of tables.
Alt+x doesn't do anything.
On 5/3/19 5:33 PM, Jaroslaw Staniek
wrote:
Hi
Swarup
It's
"Show Project Navigator" - Alt+0.
Below
I am sharing a few related shortcuts:
Activate Project
Navigator - Alt+X
Show
Property Editor - Alt+3
Activate
Property Editor - Alt+-
Switch to
Global Search - Ctrl+K
Our
handbook https://userbase.kde.org/Kexi/Handbook/References/Keyboard_Shortcuts definitely
needs major update - volunteers needed for that.
(CCd
Juan, maybe you have ideas Juan? Appreciated!)
On Fri, 3 May 2019 at 22:38,
Swarup <dinban...@sprynet.com>
wrote:
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
--
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 wrote: On 8 April 2016 at 19:54, Jaroslaw Staniek wrote: On Thursday, 7 April 2016, Swarup 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 12:01 PM, Jaroslaw Staniek wrote: On 15 April 2016 at 17:32, Swarup wrote: On 04/15/2016 11:10 AM, Jaroslaw Staniek wrote: On 15 April 2016 at 14:47, Swarup 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. Can you please send a screenshot, long to documentation or a video? All I see is that order is unspecified. I can reorder rows only for spreadsheet mode ... Please excuse me, I was confused on this point as it has been a while since I worked in MSA. My brother reminded me that new rows always add at the bottom, and then sort according to whichever column one has selected. ___ 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 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 <mailto:dinban...@sprynet.com>> wrote: On 04/15/2016 08:29 AM, Jaroslaw Staniek wrote: On 15 April 2016 at 14:07, Swarup mailto:dinban...@sprynet.com>> wrote: On 04/15/2016 07:45 AM, Jaroslaw Staniek wrote: On 15 April 2016 at 13:36, Swarup mailto:dinban...@sprynet.com>> wrote: On 04/13/2016 03:29 PM, Jaroslaw Staniek wrote: On 8 April 2016 at 19:54, Jaroslaw Staniek <mailto:stan...@kde.org> wrote: On Thursday, 7 April 2016, Swarup <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 Ubuntu 14.04 repos. Please do let me know if you have a solution for this. ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
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 <mailto:dinban...@sprynet.com>> wrote: On 04/15/2016 07:45 AM, Jaroslaw Staniek wrote: On 15 April 2016 at 13:36, Swarup wrote: On 04/13/2016 03:29 PM, Jaroslaw Staniek wrote: On 8 April 2016 at 19:54, Jaroslaw Staniek <mailto:stan...@kde.org> wrote: On Thursday, 7 April 2016, Swarup <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 <mailto:dinban...@sprynet.com>> wrote: On 04/15/2016 07:45 AM, Jaroslaw Staniek wrote: On 15 April 2016 at 13:36, Swarup mailto:dinban...@sprynet.com>> wrote: On 04/13/2016 03:29 PM, Jaroslaw Staniek wrote: On 8 April 2016 at 19:54, Jaroslaw Staniek <mailto:stan...@kde.org> wrote: On Thursday, 7 April 2016, Swarup <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 <mailto:dinban...@sprynet.com>> wrote: On 04/13/2016 03:29 PM, Jaroslaw Staniek wrote: On 8 April 2016 at 19:54, Jaroslaw Staniek <mailto:stan...@kde.org> wrote: On Thursday, 7 April 2016, Swarup <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 wrote: On Thursday, 7 April 2016, Swarup 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] Linux Voice review, Kexi wins in the Databases category
On 12/14/2015 07:22 AM, Jaroslaw Staniek wrote: On 14 December 2015 at 13:13, wrote: Jaroslaw Staniek wrote: The exclusive group or RAD users is not small but severely distributed so quite hard to reach. Misused spreadsheets for example are competitors too. There's always room for IT projects without any reasonable budget assigned. Yes, that's my pet hate, people using spreadsheets for storing tables of text information. :-) That triggered creation of this chapter of the handbook: https://userbase.kde.org/Kexi/Handbook/Introduction_to_Databases/Database_and_Spreadsheet Nothing revolutionary and can be further extended :) PS: And I am unsure why would the LV claim there's no client-server architecture in such RAD tools if all database engines (but SQLite) have always been client-server. Maybe it's about the app and GUI on the server side? A good, easy to use front-end (like Kexi may become or MS Access sort of is) would encourage more use of databases. I've been searching for a decent replacement for MS Access for ages and still haven't found one. My fundamental requirement is soemthing like Access' table view that allows very simple creation and updating of a table. I've yet to find anything. Yes, sometimes I am looking into ways to make Kexi even simpler to use, so if user wants it - it can be in the middle between a spreadsheet and a db creation app. Ad-hoc creating table designs (while entering the data) is one of the things, quite hard to implement though. Interesting, after the idea came MSA (maybe 2003?) added similar feature. But before it's reality we probably need to get reliable alter-table feature to work. What exact features of simple table creation do you mean? I feel this middle ground between a spreadsheet and a db creation app is incredibly important and will increase the value and use of Kexi among the general linux user base exponentially. My estimation is the the majority of potential Kexi users will be wanting it for this feature. That is what a great number of Access users use Access for. These people are not terribly technically inclined, and like the table format of Access better than a spreadsheet format, for their purpose of storing text-based data. I am one such person, and as a Linux user have been using Kexi for this middle ground for several users-- although frankly it is far from satisfactory compared with Access, due to lack of ability to alter the configuration or appearance of a table after it has been created. So in short, I agree with you Chris, that for this middle ground between a spreadsheet and a db creation app, what I think you mean by the alter-table feature, is more important than the simple table creation. Going into data view to make the initial table is no big deal. But after the table is made, then on the fly the following features are I think critically imporant: 1. Ability to create new rows and columns later on, in table view. 2. Ability to rename columns later on. 3. Ability to hide columns and rows in table view. 4. Ability to move columns in table view. 5. Ability to alter the number of characters allowed in a cell after the table is made, without losing all the data. 6. Ability to highlight and copy the cells of limited number of rows and columns, i.e. a sub-section of the table. Some of these features may have already been implemented in your later versions, as in Ubuntu I cannot upgrade to later versions (fixing this is also incredibly needed). I am running version 2.8.5, although I would love to be able to upgrade if there were a reasonable way to do so. Swarup ___ 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 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
Re: [Kexi] When cursor crosses border between Project Navigator and Table Data it abruptly shifts table to beginning
Thanks for your reply. See below, On 07/18/2014 05:22 PM, Jaroslaw Staniek wrote: On 18 July 2014 14:59, Swarup 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 inhttp://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. So to upgrade to Kexi 2.8.5, would I run the following: sudo add-apt-repository ppa:kubuntu-ppa/ppa sudo apt-get update sudo apt-get install If the above are the steps I need, then what should be put in for ? Would it be "kexi", or something else? I do want to ensure these steps are only going to update Kexi, and won't change anything else. I am quite happy with everything else in the computer now and don't want to change anything. 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. Here is the version I am currently running: Qt: 4.8.6 KDE Development Platform: 4.13.2 Kexi: 2.8.1 ___ 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] Re: How to add a column to table in Kexi 1.1.3?
Hi, Anne, Thank you so much for your kind suggestions :). Unfortunately, I am not knowledgeable on those technical aspects you mentioned, and would not be able to execute the 1st, 2nd, and 4th steps without completely step-by-step, explicit instructions. Let us see what JS has to suggest-- perhaps there is an easier way. I too use Ubuntu, and the version of Kexi I have now is the one that comes with the Ubuntu I am using. There is a new Ubuntu version coming out in April I believe, and perhaps Kexi 2.x available for it. Thanks again, Swarup On Thu, 2011-03-24 at 09:56 +0200, Anne Wainwright wrote: > Hi, Swarup, > > The procedure that I have used is to: > > 1. export the data direct* from the database in a delimited format > 2. create & run a script (say, perl) to add an extra delimiter at the > end of each record so extracted > 3. use kexi to add in the new field (thus losing the data as you note) > 4. import the modified delimited data direct* into the modified database > > don't try to add the field direct into the database, kexi won't like > that and you may run into permissions issues. > > best of luck. You should probably upgrade to kexi 2.x but I haven't > myself as does not seem available on ubuntu yet (I may be wrong now but > last time I looked it wasn't). > > if your new field is boolean you may also have issues if running > postgreql. > > If JS suggests any other solution, trust him and not me. It might not > be as simple as I suggest, long time since we did this. > > * direct. via the database's own sql commands, not though kexi. > > hope this helps > > Anne > > Swarup from dinban...@sprynet.com said on Thursday 24 March 2011: > > > Hello, > > I am using Kexi 1.1.3 (KOffice 1.6.3), and need to add a column to a > > table which I have been using for a few years. I have experimented in > > the past with adding columns, and found that when I do so, I lose all > > the data in the table. What I had done was to go into design view and > > type in another column header there-- which does add a column, but > > also causes destruction of all the data in the table. What is the > > technique for adding a column, such that one does not thereby lose > > the data in the table? > > > > Thanks! > > Swarup > > > > ___ > > 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 mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] How to add a column to table in Kexi 1.1.3?
Hello, I am using Kexi 1.1.3 (KOffice 1.6.3), and need to add a column to a table which I have been using for a few years. I have experimented in the past with adding columns, and found that when I do so, I lose all the data in the table. What I had done was to go into design view and type in another column header there-- which does add a column, but also causes destruction of all the data in the table. What is the technique for adding a column, such that one does not thereby lose the data in the table? Thanks! Swarup ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Re: How to select (highlight) one column in Kexi 1.1.3?
On Fri, 2011-01-07 at 09:56 +0100, Jaroslaw Staniek wrote: > On 7 January 2011 04:58, Swarup wrote: > > 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. > > Selecting a column is not possible with simple click. But user can > create a query which selects just one column (field) using the Query > Designer, and then run the query. Then the results should be available > for copying to clipboard, exporting to a file and printing. OK, I created the query and exported it. The order of rows is set according to the primary key column. Is it possible for me to have the query made with the order of rows set according to a different column? I want to have the order of rows set according to a column other than the column I have selected for the query. > > 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. > > That may be possible even with queries in Kexi but not always. > I mean, that you can proceed with the recipe explained above to create > a query showing single column, and then you can add condition to only > display 25 first rows. I said "may be possible" because for this to > work you need to assume you have primary key column defined with clean > sequence of numbers, e.g. 1, 2, ... 25. Then the condition would be > "id <= 25" in the "Condition" column of the query design view. I do have the primary key column defined with clean sequence of numbers. 1. How would you word the condition if you want say, rows 102 to 143? 2. Having sorted the main table sorted using a DIFFERENT column than the primary key, can one then request the query condition according to specific conditions of THAT column? Thanks, Swarup ___ 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
