<div dir="ltr"><div dir="ltr"><div class="gmail_default" style="font-family:monospace,monospace;font-size:small"></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, 31 Jul 2020 at 22:25, 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/31/20 9:26 AM, 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
23:26, 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> <br>
<br>
<div>On 7/30/20 5:02 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 21:44, 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> <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 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>
</div>
</blockquote>
<div><br>
</div>
<div>
<div style="font-family:monospace,monospace;font-size:small">My
opinion is that it works in 3.2.0 and I worked on this
issue for 3.2.0.</div>
<div style="font-family:monospace,monospace;font-size:small">Natural thing:
because the Ubuntu distributors are not part of the KEXI
project, they give no guarantee about their binaries,
there is no 100% guarantee how it will behave.</div>
<div style="font-family:monospace,monospace;font-size:small"><br>
</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>
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>
</div>
</blockquote>
<div><br>
</div>
<div>
<div style="font-family:monospace,monospace;font-size:small">Upgrading
is not straightforward due to the distribution's
guidelines. This is why the Flatpak version of KEXI has
been developed - to suit many distributions in one go. If
all effort is put into distributing, there would be no
time for new features or fix in KEXI. Alternative can be a
paid download.</div>
</div>
<div><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>
<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>
<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 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" target="_blank">https://sqliteviewer.com/blog/export-sqlite-to-access/</a></div>
<div 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>
</div>
</blockquote>
</div>
<div><br>
</div>
<div>
<div style="font-family:monospace,monospace;font-size:small">I am
sorry to hear that the free support you received is
insufficient. You can consider finding a paid support, which
would be potentially comparable to MS Access - I guess email
or phone support of MS Access isn't free.</div>
</div>
<div style="font-family:monospace,monospace;font-size:small"><br>
</div>
<div style="font-family:monospace,monospace;font-size:small">Regarding
the migration back, you need general guidance for "how to get
data from SQLite to MS Access".</div>
<div style="font-family:monospace,monospace;font-size:small">There
is no way to migrate forms and reports using a program,
basically because nobody paid for this function. Any
programmer is free to write such a tool and she/he will even
receive integration support from the KEXI folks. This is how
new features appear in our environment - a matter of need and
choice.</div>
<div>
<div style="font-family:monospace,monospace;font-size:small">Cheers.</div>
</div>
</div>
</blockquote>
<br>
So the export function is guaranteed to work properly if kexi is
installed in KDE, right? If I install KDE in VM Ware, install Kexi
in KDE, and open my DB there, the export function will be sure to
work properly? <br></div></blockquote><div><br></div><div><span style="font-family:monospace,monospace">It works for me <span class="gmail_default" style="font-family:monospace,monospace;font-size:small">(just tested) </span>and a number of other users, so <span class="gmail_default" style="font-family:monospace,monospace;font-size:small">this can work.</span></span><br></div></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>