Importing tables into Kexi

[Jaroslaw Staniek]

On Fri, 7 Aug 2020 at 00:22, Swarup <dinbandhu at sprynet.com> wrote:

>
>
> On 8/6/20 6:03 PM, Jaroslaw Staniek wrote:
>
>
>
> On Thu, 6 Aug 2020 at 21:40, Swarup <dinbandhu at sprynet.com> wrote:
>
>>
>>
>> On 8/6/20 3:20 PM, Jaroslaw Staniek wrote:
>>
>>
>>
>> On Thu, 6 Aug 2020 at 20:04, Swarup <dinbandhu at sprynet.com> wrote:
>>
>>>
>>>
>>> On 8/6/20 1:22 PM, Jaroslaw Staniek wrote:
>>>
>>>
>>>
>>> On Thu, 6 Aug 2020 at 19:14, Swarup <dinbandhu at sprynet.com> wrote:
>>>
>>>>
>>>>
>>>> On 8/6/20 12:54 PM, Jaroslaw Staniek wrote:
>>>>
>>>> Hi Swarup
>>>> KEXI can import individual tables from CSV at the moment.
>>>>
>>>>
>>>> If that is the case then why is the .csv file I browse to greyed out in
>>>> the import window. The import function is not permitting me to select the
>>>> file of type .csv for import.
>>>>
>>>
>>> "External Data -> Import Data from file" supports CSV.
>>> "External Data -> Import tables" supports TSV which is a special
>>> tab-based subset of CSV formats.
>>>
>>>
>>> Ok, I see how it works-- that is very good.
>>>
>>> Now: If I want to make adjustments in the parameters of the table, say,
>>> increasing the number of columns beyond the number currently in the .csv
>>> file, and increasing the number of characters permitted in a cell, do I do
>>> that before or after carrying out the import procedure?
>>>
>>>
>> Before because altering table in-place is not supported at the moment.
>>
>>
>> But the table doesn't exist in Kexi until I import the .csv file. There
>> is no table for which to go into design view and alter the parameters. Upon
>> importing the .csv, the table gets created. So before importing the
>> .csv,where is the table in which I would go into design view and add more
>> columns, and increase the number of characters permitted per cell?
>>
>
> That would be a good extra feature of the importer. I think it was not
> planned because it is easier to envision one the table altering feature
> that servers all the needs. Unfortunately that altering has not been
> delivered yet.
>
> One feature (altering) would be also less things to manage.
>
>
> Sure, that is a good idea going forward.
>
> But I need to understand what you meant by "Before because altering table
> in-place is not supported at the moment." Kindly let me know how to do it
> "before".
>
>
- extra columns need to be entered into the CSV file directly prior to
import, you can do that e.g. using a spreadsheet or in MS Access, by
importing+editing+exporting
- Max Length property can be altered in KEXI's table designer at any time
i.e. can be done after import

>
>
>>>
>>>>
>>>>
>>>> Also I wanted to point out that the CSV format:
>>>> - does not define representation of multiple tables
>>>> - does not define constraints like the permitted characters
>>>>
>>>> This is all application defined. MDB defines it so it could be useful
>>>> for the import.
>>>>
>>>>
>>>> On Thu, 6 Aug 2020 at 17:14, Swarup <dinbandhu at sprynet.com> wrote:
>>>>
>>>>> Hi there,
>>>>> So I have installed KDE Neon on my system using VM Ware, and by
>>>>> installing kexi there found that the export function worked and I was able
>>>>> to export my table from kexi, as a file of .csv format, which is perfect.
>>>>>
>>>>> I would like to now important that .csv table back into kexi, this
>>>>> time adding more columns and increasing the number of permitted characters
>>>>> per cell. So I brought the .csv file over to my Ubuntu OS, and in Ubuntu I
>>>>> opened Kexi and opened the import function. However when I browse to the
>>>>> folder where the .csv file is located, everything is grayed out including
>>>>> the .csv file. Can Kexi import tables of type .csv, or does the file have
>>>>> to be of type .mdb?
>>>>>
>>>>> Thanks,
>>>>> 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>
>>
>>
>>
>
> --
> 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>
>
>
>

-- 
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/20200807/90e42cfc/attachment.htm>