|
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! |
|
|
 |
|