|
|
| Author |
Message |
Andy
Links Corner Admin
Joined: 03 Sep 2003
Posts: 3558
Location
Winchcombe
|
 Posted: Wed Mar 28, 2018 12:51 pm Post subject: Course Database CSV dumps |
 |
|
.
I thought it might be of interest to some members to release the Links Corner Course Database as a .csv file.
Some of the field entries that are not obvious to the eye are listed here.
Type
R Real
F Fictional
I Imaginary
U Unknown
Release
A Alpha
B Beta
D Demo
F Final
Style
D Desert
W Woodland
O Ocean
P Parkland
L Links
H Heathland
M Mountain
T Tropical
U Unclassified
Availability
f AvailableFree
d Discontinued
c Converted (MS)
o Offsite (P2P)
Here is dump file of the database as it stands today.
Download here 
.
|
|
|
|
  |
 |
sagevanni
Joined: 09 Dec 2016
Posts: 578
|
| Posted: Wed Mar 28, 2018 1:25 pm Post subject: Course Database CSV dumps |
|
|
Very Cool....!!!!!!!!!!!!!!!!! I like it.
Sage 
|
|
|
|
 |
|
gator
Joined: 16 May 2006
Posts: 279
|
| Posted: Wed Mar 28, 2018 3:11 pm Post subject: Course Database CSV dumps |
|
|
Thank you Andy!
|
|
|
|
|
|
Paul44
Joined: 03 Nov 2005
Posts: 189
|
| Posted: Sun Apr 01, 2018 7:23 am Post subject: Course Database CSV dumps |
|
|
Thanks,
Andy.
|
|
Paul44
The hardest shot in Golf, is the next one. |
|
|
|
Captain Nemo
Joined: 03 Apr 2014
Posts: 475
Location
Ontario, Canada
|
| Posted: Sun Apr 01, 2018 4:16 pm Post subject: Course Database CSV dumps |
|
|
What is a .csv data base? Downloaded file, which auto opened in Notebook and was a pile of unformatted junk. Guessing I need to somehow affiliate it with a database program. I use Open Office which has one. Will that work?
Thanks CN
|
|
How many Microsoft Programmers does it take to replace a light bulb? Just one.
However, you will be installing updates for all eternity! |
|
|
|
MrMoggie
Joined: 15 Feb 2016
Posts: 71
Location
Bromley, England
|
| Posted: Sun Apr 01, 2018 4:29 pm Post subject: Course Database CSV dumps |
|
|
I think it's an Excel format
Steve
|
|
|
|
|
|
Captain Nemo
Joined: 03 Apr 2014
Posts: 475
Location
Ontario, Canada
|
| Posted: Sun Apr 01, 2018 4:41 pm Post subject: Course Database CSV dumps |
|
|
Thanks Steve:
Good to know. So it's not really a database. it is data base type info input into Excel.
Open Office Calc is the equivalent of Excel, and I seem to remember it handles basic Excel formats and formulas OK. I will give it a try.
Cheers Dave
|
|
How many Microsoft Programmers does it take to replace a light bulb? Just one.
However, you will be installing updates for all eternity! |
|
|
|
grandpabruce
Joined: 25 Mar 2004
Posts: 3009
Location
Northern Minnesota
|
| Posted: Sun Apr 01, 2018 4:50 pm Post subject: Course Database CSV dumps |
|
|
| MrMoggie wrote: | I think it's an Excel format
Steve |
It may be, but it is no Excel file extension that I have ever seen.
|
|
Life is good!
GrandpaBruce
Vietnam Vet - 1970 - 1971 |
|
|
|
Captain Nemo
Joined: 03 Apr 2014
Posts: 475
Location
Ontario, Canada
|
| Posted: Sun Apr 01, 2018 5:20 pm Post subject: Course Database CSV dumps |
|
|
Google Search informs me that .csv stands for Comma Separated Value. These "data list" text files are viewable in many text viewing programs, but supposedly only Excel and Open Office Calc can dilineate the comma separations and show them in a logical format. Unfortunately my version of Calc only stacks the data in one very very long finite column starting with the Alphabetical List of course names.
|
|
How many Microsoft Programmers does it take to replace a light bulb? Just one.
However, you will be installing updates for all eternity! |
|
|
|
gator
Joined: 16 May 2006
Posts: 279
|
| Posted: Sun Apr 01, 2018 6:00 pm Post subject: Course Database CSV dumps |
|
|
I hope it's OK with Andy. Here it is in Excel (xlsx) format - https://we.tl/uFE6qouNit.
I froze and bolded the header row, expanded the fields using Andy's key, and the date is in M/D/YYYY format.
(The link is good for 7 days).
|
|
|
|
|
|
Andy
Links Corner Admin
Joined: 03 Sep 2003
Posts: 3558
Location
Winchcombe
|
| Posted: Sun Apr 01, 2018 6:01 pm Post subject: Course Database CSV dumps |
|
|
You can open it in Google Sheets if you don't have Excel.
|
|
|
|
|
|
Captain Nemo
Joined: 03 Apr 2014
Posts: 475
Location
Ontario, Canada
|
| Posted: Sun Apr 01, 2018 9:52 pm Post subject: Course Database CSV dumps |
|
|
What is Google Sheets?
Sounds like a supplier Casper the Friendly Ghost would be affiliated with. :)
PS: Downloaded the Excel file but it froze in Open Office Calc and then on exit crashed my PC.
PC rebooted OK, but still, not a happy camper!
|
|
How many Microsoft Programmers does it take to replace a light bulb? Just one.
However, you will be installing updates for all eternity! |
|
|
|
Andy
Links Corner Admin
Joined: 03 Sep 2003
Posts: 3558
Location
Winchcombe
|
|
|
|
|
|
gator
Joined: 16 May 2006
Posts: 279
|
| Posted: Mon Apr 02, 2018 12:37 am Post subject: Course Database CSV dumps |
|
|
For Captain Nemo (and anyone else who needs it) here is an Excel xls version with no formatting - https://we.tl/IbGOlxg91h.
|
|
|
|
|
|
Captain Nemo
Joined: 03 Apr 2014
Posts: 475
Location
Ontario, Canada
|
| Posted: Mon Apr 02, 2018 3:00 pm Post subject: Course Database CSV dumps |
|
|
Thanks gator. Opened OK in Calc and was able to expand various columns as required for viewing and then re-saved in odc format.
Cheers.
|
|
How many Microsoft Programmers does it take to replace a light bulb? Just one.
However, you will be installing updates for all eternity! |
|
|
|
|
|
