From kexi Fri Aug 07 08:25:38 2020 From: Jaroslaw Staniek Date: Fri, 07 Aug 2020 08:25:38 +0000 To: kexi Subject: Re: Importing tables into Kexi Message-Id: X-MARC-Message: https://marc.info/?l=kexi&m=159678878915098 MIME-Version: 1 Content-Type: multipart/mixed; boundary="--000000000000bf08de05ac455b08" --000000000000bf08de05ac455b08 Content-Type: text/plain; charset="UTF-8" On Fri, 7 Aug 2020 at 00:22, Swarup wrote: > > > On 8/6/20 6:03 PM, Jaroslaw Staniek wrote: > > > > On Thu, 6 Aug 2020 at 21:40, Swarup wrote: > >> >> >> On 8/6/20 3:20 PM, Jaroslaw Staniek wrote: >> >> >> >> On Thu, 6 Aug 2020 at 20:04, Swarup wrote: >> >>> >>> >>> On 8/6/20 1:22 PM, Jaroslaw Staniek wrote: >>> >>> >>> >>> On Thu, 6 Aug 2020 at 19:14, Swarup 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. >>> >>> >>> Ok, I see how it works-- that is very good. >>> >>> 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? >>> >>> >> Before because altering table in-place is not supported at the moment. >> >> >> 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? >> > > 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. > > One feature (altering) would be also less things to manage. > > > Sure, that is a good idea going forward. > > 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". > > - extra columns 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 - Max Length property can be altered in KEXI's table designer at any time i.e. can be done after import > > >>> >>>> >>>> >>>> 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 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 >> >> >> > > -- > 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 > > > -- 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 --000000000000bf08de05ac455b08 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Fri, 7 Aug 2020 = at 00:22, Swarup <dinbandhu@spr= ynet.com> wrote:
=20 =20 =20


On 8/6/20 6:03 PM, Jaroslaw Staniek wrote:
=20

On Thu, 6 Aug 2020 at 21:40= , Swarup <dinbandhu@sprynet.com> wrote:


On 8/6/20 3:20 PM, Jaroslaw Staniek wrote:


On Thu, 6 Aug 202= 0 at 20:04, Swarup <dinbandhu@sprynet.com> wrote:


On 8/6/20 1:22 PM, Jaroslaw Staniek wrote:


On Thu, 6 Aug 2020 at 19:14, Swarup <dinbandhu@sprynet.com&g= t; wrote:


On 8/6/20 12:54 PM, Jaroslaw Staniek wrote:
Hi Swarup
KEXI can import individual tables from CSV at the moment.=C2=A0

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 T= SV which is a special tab-based subset of CSV formats.

Ok, I see how it works-- that is very good.

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?


Before because altering table in-place is not supported at the moment.

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?

Th= at 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=C2=A0servers all the needs. Unfortunately that altering has not been delivered yet.
On= e feature (altering) would be also less things to manage.

Sure, that is a good idea going forward.

But I need to understand what you meant by "Before because alterin= g table in-place is not supported at the moment." Kindly let me know how to do it "before".


- extra columns need t= o 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
- Max Length property can be altered in KEXI's table designer= at any time i.e. can be done after import
=C2=A0


Also I wanted to point out that the CSV format:
- does=C2=A0not define representation=C2=A0of multiple tables
- does not define constraints like the permitted characters=C2=A0

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 -=C2=A0kexi-project.org=C2=A0calligra.org/kexi



--
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 -=C2=A0kexi-project.org=C2= =A0calligra.org/kexi=



--
regards, Jaro= slaw Staniek

KDE:
: A worldwide network of software engineers, ar= tists, writers, translators
: and facilitators committed to Free Softwar= e development - kde.orgKEXI:
: A visual database apps builder -=C2=A0kexi-project.org=C2=A0calligra.org/kexi
<= /div>
--000000000000bf08de05ac455b08--