Help please
-
footysystems
- Posts: 165
- Joined: Thu May 09, 2013 5:57 pm
I have a CSV or files that collect each day with a rating i created for inplay football which i download daily the CSV is now huge cumbersome to say the least is there another way i can collect the data ??? and make it do stuff i want ??? now tried Access today and it done my head in.... any help ?
-
spreadbetting
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
Your post is a bit confusing as you say you download the data and then ask us if there's another way to collect the data when we have no idea where it's from.
At the end of the day CSV is fine for small data files but if it's now unmanageable you'll have to learn to use some database program to handle it all. The good thing is there's plenty of free databases so plenty of help available and all can easily import CSV files. Your best bet is to bite the bullet and either learn to use Access or much better to use one of the free SQL databases. Once you get started they're not as hard to use as you'd imagine
At the end of the day CSV is fine for small data files but if it's now unmanageable you'll have to learn to use some database program to handle it all. The good thing is there's plenty of free databases so plenty of help available and all can easily import CSV files. Your best bet is to bite the bullet and either learn to use Access or much better to use one of the free SQL databases. Once you get started they're not as hard to use as you'd imagine
-
footysystems
- Posts: 165
- Joined: Thu May 09, 2013 5:57 pm
Done my head in all day tbh here an xls file with yesterdays data..When i went to school you had a timex watch you was doing well 
You do not have the required permissions to view the files attached to this post.
-
footysystems
- Posts: 165
- Joined: Thu May 09, 2013 5:57 pm
The main data has 20k goal in it after 15 days so i have copied and pasted it into all one CSV its all over the place.
Averages times and ratings i am after % fhg and so on
As Spreadbetting says, sounds to me you're at that stage when you realise you need a proper database.
I went with SQL Server.
Installing SQL Server shouldn't be difficult. Designing a database and writing programs to populate it, is difficult.
What's the advantage of all that effort?
The ability to examine (query) all that data with SQL (the dominant data query language). So you can look at stuff by course, horse, jockey...or whatever data you've decided to store in the database.
But it's a step by step process, so go for it.
I went with SQL Server.
Installing SQL Server shouldn't be difficult. Designing a database and writing programs to populate it, is difficult.
What's the advantage of all that effort?
The ability to examine (query) all that data with SQL (the dominant data query language). So you can look at stuff by course, horse, jockey...or whatever data you've decided to store in the database.
But it's a step by step process, so go for it.
-
footysystems
- Posts: 165
- Joined: Thu May 09, 2013 5:57 pm
I have a program that i had written 12 months ago its world class and just talking to my programmer now that maybe able to come too a solution. its all inplay data which i have from an API i no have the CSV daily export wanted to build a data base of the stats and get some firm markers the markers i have are good but want too tighten it right up..greenmark wrote: ↑Thu Jan 30, 2020 8:48 pmAs Spreadbetting says, sounds to me you're at that stage when you realise you need a proper database.
I went with SQL Server.
Installing SQL Server shouldn't be difficult. Designing a database and writing programs to populate it, is difficult.
What's the advantage of all that effort?
The ability to examine (query) all that data with SQL (the dominant data query language). So you can look at stuff by course, horse, jockey...or whatever data you've decided to store in the database.
But it's a step by step process, so go for it.
