<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">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">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">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 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">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">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>
</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>