[prev in list] [next in list] [prev in thread] [next in thread]
List: kexi
Subject: Re: Importing tables into Kexi
From: Jaroslaw Staniek <staniek () kde ! org>
Date: 2020-08-06 17:22:28
Message-ID: CAOj7QQ16PATBBVknMfFrVcPGi0N9ec2dThiV6==HRoVBEoLh8w () mail ! gmail ! com
[Download RAW message or body]
On Thu, 6 Aug 2020 at 19:14, Swarup <dinbandhu@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@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>
[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, 6 Aug 2020 at 19:14, \
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 8/6/20 12:54 PM, Jaroslaw Staniek
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div style="font-family:monospace,monospace;font-size:small">Hi
Swarup</div>
<div style="font-family:monospace,monospace;font-size:small">KEXI
can import individual tables from CSV at the moment. </div>
</div>
</blockquote>
<br>
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. \
<br></div></blockquote><div><br></div><div><div class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">"External Data -> \
Import Data from file" supports CSV.</div><div class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">"External Data -> \
Import tables" supports TSV which is a special tab-based subset of CSV \
formats.</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>
<br>
<blockquote type="cite">
<div dir="ltr">
<div style="font-family:monospace,monospace;font-size:small">Also I
wanted to point out that the CSV format:</div>
<div style="font-family:monospace,monospace;font-size:small">-
does not define representation of multiple tables</div>
<div style="font-family:monospace,monospace;font-size:small">- does
not define constraints like the permitted characters </div>
<div style="font-family:monospace,monospace;font-size:small"><br>
</div>
<div style="font-family:monospace,monospace;font-size:small">This
is all application defined. MDB defines it so it could be
useful for the import.</div>
<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, 6 Aug 2020 at 17:14,
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> Hi there, <br>
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.<br>
<br>
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?<br>
<br>
Thanks,<br>
Swarup<br>
</div>
</blockquote>
</div>
<br>
</blockquote>
<br>
</div>
</blockquote></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>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic