The RIGHT way...

Discuss the database features

The RIGHT way...

Postby TheNamelessPoet » Wed Feb 03, 2021 5:04 pm

OK so I reached out last year (viewtopic.php?f=9&t=101679) but now I am trying to do it the right way.

1st thing though. Can I copy and paste the data directly into the database? Each tournament I am in (at least 10-20 a day) has about 100+ columns with 330ish lines each.

I am going to take the data from those sheets and output it in some usable way, and in some cases apply formula's. I started watching some youtube video's on how/what to do, but each situation seems like they go about it differently.

Also I am getting an error saying OpenOffice requires a Java Runtime Environment please install. I have installed Java Version 8 Update 281 so i am not sure what that is about should I be concerned?
I am using Apache 4.1.6
TheNamelessPoet
 
Posts: 4
Joined: Sat Apr 18, 2020 3:33 pm

Re: The RIGHT way...

Postby Villeroy » Wed Feb 03, 2021 6:54 pm

100+ columns and lots of tables? No, databases do not work like this. I just added a simple real-world example Simple turnament database [Soccer, German Bundesliga]

There is one Club table with all the club names.
There is one Seasons table with year numbers of seasons.
There is one table mapping clubs and seasons to each other.
There is one "main table" named "Matches" with all venue data for all seasons and all clubs.

At first you create a valid relational database strictly following the design patterns of https://en.wikipedia.org/wiki/Database_normalization
Then you may transform some spreadsheet, so its columns and rows follow the exact same rules. Then you will be able to paste some sheet cell ranges into the given structure of a database.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29726
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: The RIGHT way...

Postby UnklDonald418 » Wed Feb 03, 2021 10:11 pm

Apache Open Office requires 32 bit JAVA
Select Tools>Options>OpenOfiice>Java to select an installed version.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.8 & LibreOffice 6.4.7.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1396
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA


Return to Base

Who is online

Users browsing this forum: No registered users and 4 guests