Basic Questions

[Jaroslaw Staniek]

On Thu, 30 Jul 2020 at 21:44, Swarup <dinbandhu at sprynet.com> wrote:

>
>
> On 7/30/20 3:32 PM, Jaroslaw Staniek wrote:
>
>
>
> On Thu, 30 Jul 2020 at 17:38, Swarup <dinbandhu at 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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kexi/attachments/20200730/df602bc9/attachment-0001.htm>