<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<br>
<br>
<div class="moz-cite-prefix">On 8/6/20 6:03 PM, Jaroslaw Staniek
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAOj7QQ0c4Ln_05OuL7zHJuE3j6_oj8ysQMvLonYouEmrwfRjCA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<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 21:40,
Swarup <<a href="mailto:dinbandhu@sprynet.com"
moz-do-not-send="true">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 3:20 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, 6 Aug 2020
at 20:04, Swarup <<a
href="mailto:dinbandhu@sprynet.com"
target="_blank" moz-do-not-send="true">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 1:22 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,
6 Aug 2020 at 19:14, Swarup <<a
href="mailto:dinbandhu@sprynet.com"
target="_blank" moz-do-not-send="true">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
style="font-family:monospace,monospace;font-size:small">"External
Data -> Import Data from file"
supports CSV.</div>
<div
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>
<br>
Ok, I see how it works-- that is very good. <br>
<br>
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?<br>
<br>
</div>
</blockquote>
<div><br>
</div>
<div
style="font-family:monospace,monospace;font-size:small">Before
because altering table in-place is not supported
at the moment.</div>
</div>
</div>
</blockquote>
<br>
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?<br>
</div>
</blockquote>
<div><br>
</div>
<div class="gmail_default"
style="font-family:monospace,monospace;font-size:small">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.</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">One
feature (altering) would be also less things to manage.</div>
</div>
</div>
</blockquote>
<br>
Sure, that is a good idea going forward.<br>
<br>
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".<br>
<br>
<blockquote type="cite"
cite="mid:CAOj7QQ0c4Ln_05OuL7zHJuE3j6_oj8ysQMvLonYouEmrwfRjCA@mail.gmail.com">
<div dir="ltr">
<div class="gmail_quote">
<div class="gmail_default"
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>
<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>
<blockquote type="cite">
<div dir="ltr">
<div class="gmail_quote">
<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"
moz-do-not-send="true">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>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr">
<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"
moz-do-not-send="true">kde.org</a><br>
KEXI:<br>
: A visual database apps builder
- <a
href="http://kexi-project.org/"
target="_blank"
moz-do-not-send="true">kexi-project.org</a> <a
href="http://calligra.org/kexi" target="_blank" moz-do-not-send="true">calligra.org/kexi</a></div>
<div> <a
href="https://twitter.com/kexi_project"
target="_blank"
moz-do-not-send="true">twitter.com/kexi_project</a> <a
href="https://facebook.com/kexi.project" target="_blank"
moz-do-not-send="true">facebook.com/kexi.project</a> <a
href="https://t.me/kexi_project" target="_blank" moz-do-not-send="true">t.me/kexi_project</a><br>
Qt Certified Specialist:<br>
: <a
href="http://www.linkedin.com/in/jstaniek"
target="_blank"
moz-do-not-send="true">linkedin.com/in/jstaniek</a></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</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"
moz-do-not-send="true">kde.org</a><br>
KEXI:<br>
: A visual database apps builder - <a
href="http://kexi-project.org/"
target="_blank" moz-do-not-send="true">kexi-project.org</a> <a
href="http://calligra.org/kexi"
target="_blank" moz-do-not-send="true">calligra.org/kexi</a></div>
<div> <a
href="https://twitter.com/kexi_project"
target="_blank" moz-do-not-send="true">twitter.com/kexi_project</a> <a
href="https://facebook.com/kexi.project"
target="_blank" moz-do-not-send="true">facebook.com/kexi.project</a> <a
href="https://t.me/kexi_project"
target="_blank" moz-do-not-send="true">t.me/kexi_project</a><br>
Qt Certified Specialist:<br>
: <a
href="http://www.linkedin.com/in/jstaniek"
target="_blank" moz-do-not-send="true">linkedin.com/in/jstaniek</a></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<br>
</body>
</html>