[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-31 13:26:29
Message-ID: CAOj7QQ2_jgxeZnuF0CKSKd3_D5rc9Rxnj6=MMo6tpVLgoiE5jQ () mail ! gmail ! com
[Download RAW message or body]
On Thu, 30 Jul 2020 at 23:26, Swarup <dinbandhu@sprynet.com> wrote:
>
>
> On 7/30/20 5:02 PM, Jaroslaw Staniek wrote:
>
>
>
> 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...
>
>
> Are you telling me that if I upgrade, then the export feature will work?
>
My opinion is that it works in 3.2.0 and I worked on this issue for 3.2.0.
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.
> Or are you guessing that it *may* work?
>
> 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.
>
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.
>
>> 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.
>
>
> 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".
>
> 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.
>
> 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.
>
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.
Regarding the migration back, you need general guidance for "how to get
data from SQLite to MS Access".
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.
Cheers.
--
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 23:26, \
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 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 class="gmail_default" \
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 class="gmail_default" \
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 \
class="gmail_default" \
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 class="gmail_default" \
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 class="gmail_default" \
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 class="gmail_default" \
style="font-family:monospace,monospace;font-size:small"><br></div><div \
class="gmail_default" \
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 class="gmail_default" \
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 class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">Cheers.</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