Basic Questions

Fri Jul 31 23:14:17 BST 2020

On Fri, 31 Jul 2020 at 22:25, Swarup <dinbandhu at sprynet.com> wrote:

>
>
> On 7/31/20 9:26 AM, Jaroslaw Staniek wrote:
>
>
>
> On Thu, 30 Jul 2020 at 23:26, Swarup <dinbandhu at sprynet.com> wrote:
>
>>
>>
>> On 7/30/20 5:02 PM, Jaroslaw Staniek wrote:
>>
>>
>>
>> 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...
>>
>>
>> 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.
>
>
> 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?
>

It works for me (just tested) and a number of other users, so this can work.

-- 
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/20200801/1ea0eb87/attachment.htm>