[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 16:54:24
Message-ID: CAOj7QQ2DE6TktJZG7Cf7NjHfCKaem9W7P2VfxNQDb009QUjt5A () mail ! gmail ! com
[Download RAW message or body]

Hi Swarup
KEXI can import individual tables from CSV at the moment.  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 class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">Hi Swarup</div><div \
class="gmail_default" style="font-family:monospace,monospace;font-size:small">KEXI \
can import individual tables from CSV at the moment.   Also I wanted to point out \
that the CSV format:</div><div class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">- does  not define \
representation  of multiple tables</div><div class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">- does not define constraints \
like the permitted characters  </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">This is \
all application defined. MDB defines it so it could be useful for the \
import.</div><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 17:14, \
Swarup &lt;<a href="mailto:dinbandhu@sprynet.com">dinbandhu@sprynet.com</a>&gt; \
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 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>




[prev in list] [next in list] [prev in thread] [next in thread]