[prev in list] [next in list] [prev in thread] [next in thread]
List: kexi
Subject: Re: Basic Questions
From: Jaroslaw Staniek <staniek () kde ! org>
Date: 2020-07-30 21:02:09
Message-ID: CAOj7QQ2y5QHXJqxHBoMjbvWDFFSfiMk-kWCp1f1K-MnOghdt7w () mail ! gmail ! com
[Download RAW message or body]
On Thu, 30 Jul 2020 at 21:44, Swarup <dinbandhu@sprynet.com> wrote:
>
>
> On 7/30/20 3:32 PM, Jaroslaw Staniek wrote:
>
>
>
> On Thu, 30 Jul 2020 at 17:38, Swarup <dinbandhu@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>
[Attachment #3 (text/html)]
<div dir="ltr"><div dir="ltr"><div class="gmail_default" \
style="font-family:monospace,monospace;font-size:small"><br></div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, 30 Jul 2020 at 21:44, \
Swarup <<a href="mailto:dinbandhu@sprynet.com">dinbandhu@sprynet.com</a>> \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<br>
<br>
<div>On 7/30/20 3:32 PM, Jaroslaw Staniek
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">
<div style="font-family:monospace,monospace;font-size:small"><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, 30 Jul 2020 at
17:38, Swarup <<a href="mailto:dinbandhu@sprynet.com" \
target="_blank">dinbandhu@sprynet.com</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"> <div> Hello<br>
<br>
1. I am using Kexi Version 3.1.0 in Ubuntu 19.04. <br>
<br>
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.<br>
</div>
</blockquote>
<div><br>
</div>
<div style="font-family:monospace,monospace;font-size:small">Hello.
Right. First step is to upgrade to 3.2. </div>
<div style="font-family:monospace,monospace;font-size:small"><br>
</div>
<div style="font-family:monospace,monospace;font-size:small">This
topic can be studied here <a \
href="https://forum.kde.org/viewtopic.php?f=221&t=132264" \
style="font-family:Arial,Helvetica,sans-serif" \
target="_blank">https://forum.kde.org/viewtopic.php?f=221&t=132264</a></div>
<div style="font-family:monospace,monospace;font-size:small"><br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"> <div> <br>
3. Is there a very easy, user friendly way to update to
the latest version of Kexi?<br>
</div>
</blockquote>
<div><br>
</div>
<div>
<div style="font-family:monospace,monospace;font-size:small">Always
three ways as follows, whatever suits best:</div>
<br>
</div>
<div style="font-family:monospace,monospace;font-size:small">1.
Request an easy way from your distributor </div>
<div style="font-family:monospace,monospace;font-size:small">2.
Change the distributor</div>
<div style="font-family:monospace,monospace;font-size:small">3.
Install a Flatpak snapshot <a \
href="https://community.kde.org/Kexi/Snapshots" \
target="_blank">https://community.kde.org/Kexi/Snapshots</a></div> </div>
</div>
</blockquote>
<br>
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.<br>
<br>
<blockquote type="cite">
<div dir="ltr">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"> <div> <br>
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.</div>
</blockquote>
<div><br>
</div>
<div>
<div style="font-family:monospace,monospace;font-size:small">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.</div>
</div>
<div> </div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"> <div> <br>
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?<br>
</div>
</blockquote>
<div><br>
</div>
<div style="font-family:monospace,monospace;font-size:small">Users
can export each table by right-clicking and exporting to a
file. </div>
</div>
</div>
</blockquote>
<br>
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.<br></div></blockquote><div><br></div><div class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">That may be the reason for \
upgrading...</div><div class="gmail_default" \
style="font-family:monospace,monospace;font-size:small"></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div> <br>
<blockquote type="cite">
<div dir="ltr">
<div class="gmail_quote">
<div style="font-family:monospace,monospace;font-size:small">Because
these are SQLite tables, users can also run apps like
sqlitebrowser to export all tables in one go
(File->Export->CSV).</div>
</div>
<br>
</div>
</blockquote>
I am not a techy to start learning how to use apps like
sqlitebrowser.<br>
<br>
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.<br></div></blockquote><div><br></div><div class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">There are ready to use tools, \
e.g. <a href="https://sqliteviewer.com/blog/export-sqlite-to-access/" \
style="font-family:Arial,Helvetica,sans-serif">https://sqliteviewer.com/blog/export-sqlite-to-access/</a></div><div \
class="gmail_default" style="font-family:monospace,monospace;font-size:small">I hope \
it works for you.</div><div class="gmail_default" \
style="font-family:monospace,monospace;font-size:small"><br></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div> <br>
Thank you,<br>
Swarup<br>
</div>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" \
class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div \
dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div>regards, Jaroslaw \
Staniek<br><br>KDE:<br>: A worldwide network of software engineers, artists, writers, \
translators<br>: and facilitators committed to Free Software development - <a \
href="http://kde.org" target="_blank">kde.org</a><br>KEXI:<br>: A visual database \
apps builder - <a href="http://kexi-project.org/" \
target="_blank">kexi-project.org</a> <a href="http://calligra.org/kexi" \
target="_blank">calligra.org/kexi</a></div><div> <a \
href="https://twitter.com/kexi_project" target="_blank">twitter.com/kexi_project</a> \
<a href="https://facebook.com/kexi.project" \
target="_blank">facebook.com/kexi.project</a> <a href="https://t.me/kexi_project" \
target="_blank">t.me/kexi_project</a><br>Qt Certified Specialist:<br>: <a \
href="http://www.linkedin.com/in/jstaniek" \
target="_blank">linkedin.com/in/jstaniek</a></div></div></div></div></div></div></div></div></div></div></div></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic