<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<br>
<br>
<div class="moz-cite-prefix">On 8/7/20 4:25 AM, Jaroslaw Staniek
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAOj7QQ1JmnnoBynXnKjrstQqeLc2aes4UMmQM-iVCKGau97gVQ@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 Fri, 7 Aug 2020 at 00:22,
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 6:03 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 21:40, 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 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
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
style="font-family:monospace,monospace;font-size:small"><br>
</div>
<div
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>
</div>
</blockquote>
<div><br>
</div>
<div><span style="font-family:monospace,monospace"><span
class="gmail_default"
style="font-family:monospace,monospace;font-size:small">-
e</span>xtra columns <span class="gmail_default"
style="font-family:monospace,monospace;font-size:small">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</span></span><br>
</div>
<div><span style="font-family:monospace,monospace"><span
class="gmail_default"
style="font-family:monospace,monospace;font-size:small">-
Max Length property can be altered in KEXI's table
designer at any time i.e. can be done after import</span></span></div>
</div>
</div>
</blockquote>
<br>
Re extra columns, ok-- that is clear. I will do it in a spreadsheet
like Excel because MSA has limited number of permitted characters in
cell (255), and will truncate all my data.<br>
<br>
Re max length: If I import and then do the alteration, it will
destroy/remove all my date when I go to save the new table design.
So I think, as you seem to have indicated earlier, that it needs to
be before the import. And the procedure fo that is not clear to me.
Please give some guideline about this.<br>
<br>
Also: Is there a limit to what the max length can be set at?<br>
<blockquote type="cite"
cite="mid:CAOj7QQ1JmnnoBynXnKjrstQqeLc2aes4UMmQM-iVCKGau97gVQ@mail.gmail.com">
<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
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">
<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>