Importing tables into Kexi

[Jaroslaw Staniek]

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.


>
>
> 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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kexi/attachments/20200806/74631bd7/attachment.htm>