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... > > 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. > There are ready to use tools, e.g. https://sqliteviewer.com/blog/export-sqlite-to-access/ I hope it works for you. > Thank you, > Swarup > -- regards, Jaroslaw Staniek KDE: : A worldwide 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 <http://www.linkedin.com/in/jstaniek>