Problem using OpenOffice Base

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Problem using OpenOffice Base

Anuj Verma
Dear sir,
I am required to use a database software package in the manner written below. In my institution, I use Microsoft Access on WIndows 8/8.1/10. At home, I do not have the package and am using OpenOffice [screenshot of version attached] with Windows 10 and a Java package downloaded using the instructions from your website. I am required to carry out the steps below (in the same order).

1. Import existing CSV files into a database [examples attached: teachers, cars, students]: I normally click on the Insert tab in Access and select Import from text. Then my file is imported as a table in a new database.
2. Edit field names and datatypes: I use the Design view in Access. I need to assign a primary key and change the datatypes of the fields.
3. Edit data: I just type data into a new row at the bottom of the Table View.
4. Create a form and enter data.
5. Create relations: I create one-to-many relations using a Primary key.
6. Generate reports.

I am new to OpenOffice and am unable to do anything beyond creating a blank base file and importing the CSVs into it. [Refer Window Screenshot] Once I double-click on any of the tables and they open in a separate window, I think I should be able to edit them. However, when I try to double-click any cell, single-click and press F2 or single-click and press Delete, nothing at all happens.

I tried to enter the design view by right-clicking on the table and selecting Edit. I do see something similar to the Design View of Access, but again, I cannot edit anything.

As I am unable to carry out tasks 1, 2 and 3, I cannot proceed further with my assignments. Please help me out.


Regards,
Anuj Verma



I request you not to use any of the files for any purpose other than solving my query as I am not the original author and am only licensed to use them. The CSV files are provided with a textbook recommended for the Cambridge IGCSE ICT syllabus.


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

teachers.csv (446 bytes) Download Attachment
cars.csv (6K) Download Attachment
students.csv (8K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Problem using OpenOffice Base

Damjan Jovanovic
Hi Anuj

The OpenOffice database driver for CSV files is read-only. Data cannot be
edited or designed. There are definitely no keys or indexes, JOINs are
performed with table scans.

What you can do is create a separate database in Base and make tables in
it, then copy data from the CSV files into those tables (open CSV in Calc,
select and copy the cells with the data, then paste onto the table in
Base), and then design and edit that database in Base. I admit, it is
something we could really improve.

This is also not the right place for support questions, please use the
users mailing list or the forum.

Regards
Damjan


On Sun, Jun 17, 2018 at 9:14 PM Anuj Verma <[hidden email]>
wrote:

> Dear sir,
> I am required to use a database software package in the manner written
> below. In my institution, I use *Microsoft Access* on *WIndows 8/8.1/10*.
> At home, I do not have the package and am using *OpenOffice* [screenshot
> of version attached] with Windows 10 and a Java package downloaded using
> the instructions from your website. I am required to carry out the steps
> below (in the same order).
>
> 1. Import existing CSV files into a database [examples attached:
> *teachers*, *cars*, *students*]: I normally click on the *Insert tab* in *Access
> *and select *Import from text*. Then my file is imported as a table in a
> new database.
> 2. Edit field names and datatypes: I use the *Design view* in *Access*. I
> need to assign a primary key and change the datatypes of the fields.
> 3. Edit data: I just type data into a new row at the bottom of the *Table
> View*.
> 4. Create a form and enter data.
> 5. Create relations: I create one-to-many relations using a Primary key.
> 6. Generate reports.
>
> I am new to *OpenOffice *and am unable to do anything beyond creating a
> blank base file and importing the CSVs into it. [Refer *Window Screenshot*]
> Once I double-click on any of the tables and they open in a separate
> window, I think I should be able to edit them. However, when I try to
> double-click any cell, single-click and press *F2 *or single-click and
> press *Delete*, nothing at all happens.
>
> I tried to enter the design view by right-clicking on the table and
> selecting Edit. I do see something similar to the Design View of Access,
> but again, I cannot edit anything.
>
> As I am unable to carry out tasks 1, 2 and 3, I cannot proceed further
> with my assignments. Please help me out.
>
>
> Regards,
> Anuj Verma
>
>
>
> I request you not to use any of the files for any purpose other than
> solving my query as I am not the original author and am only licensed to
> use them. The CSV files are provided with a textbook recommended for the
> Cambridge IGCSE ICT syllabus.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]