<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<br>
<br>
<div class="moz-cite-prefix">On 7/30/20 5:02 PM, Jaroslaw Staniek
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAOj7QQ2y5QHXJqxHBoMjbvWDFFSfiMk-kWCp1f1K-MnOghdt7w@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<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"
moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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>
</div>
</blockquote>
<br>
Are you telling me that if I upgrade, then the export feature will
work?<br>
<br>
Or are you guessing that it <i>may</i> work?<br>
<br>
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.<br>
<br>
<blockquote type="cite"
cite="mid:CAOj7QQ2y5QHXJqxHBoMjbvWDFFSfiMk-kWCp1f1K-MnOghdt7w@mail.gmail.com">
<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>
<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"
moz-do-not-send="true">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>
</div>
</blockquote>
<br>
On the link you gave me, they themselves are writing "This method
involves complicated procedure, which on going wrong can lead to
loss of data from the Sqlite database".<br>
<br>
I am really regretting that I got my whole database stuck in Kexi.
I've been using this since 2008 for the past 14 years, and now I
wish to not remain stuck in this format any longer which has so many
limitations. It should not be listed as the alternative to MS
Access. The two cannot be compared.<br>
<br>
If you are able to provide me some real support and guidance for how
to dependably get my data out of this program, I will be very
grateful.<br>
<br>
Thank you,<br>
Swarup<br>
<br>
<br>
<br>
</body>
</html>