Please support Links Corner    



Never bet with anyone you meet on the first tee, who has a deep suntan, a one iron in his bag and squinty eyes. -Dave Marr
Post new topic   Reply to topic     Forum Index -> Course Corner
Course Database CSV dumps View older topic :: View newer topic  
Author Message
Andy
Links Corner Admin
Links Corner Admin


Joined: 03 Sep 2003
Posts: 3547
Location
Winchcombe

PostPosted: Wed Mar 28, 2018 12:51 pm    Post subject: Course Database CSV dumps Reply with quote

.


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 Click to download


.


View user's profile Send private message
sagevanni



Joined: 09 Dec 2016
Posts: 464

PostPosted: Wed Mar 28, 2018 1:25 pm    Post subject: Course Database CSV dumps Reply with quote

Very Cool....!!!!!!!!!!!!!!!!! I like it.

Sage Clap


View user's profile Send private message Send e-mail
gator



Joined: 16 May 2006
Posts: 256

PostPosted: Wed Mar 28, 2018 3:11 pm    Post subject: Course Database CSV dumps Reply with quote

Thank you Andy!

View user's profile Send private message
Paul44



Joined: 03 Nov 2005
Posts: 175

PostPosted: Sun Apr 01, 2018 7:23 am    Post subject: Course Database CSV dumps Reply with quote

Thanks,

Andy.


Paul44

The hardest shot in Golf, is the next one.
View user's profile Send private message
Captain Nemo



Joined: 03 Apr 2014
Posts: 467
Location
Ontario, Canada

PostPosted: Sun Apr 01, 2018 4:16 pm    Post subject: Course Database CSV dumps Reply with quote

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!
View user's profile Send private message
MrMoggie



Joined: 15 Feb 2016
Posts: 69
Location
Bromley, England

PostPosted: Sun Apr 01, 2018 4:29 pm    Post subject: Course Database CSV dumps Reply with quote

I think it's an Excel format

Steve


View user's profile Send private message
Captain Nemo



Joined: 03 Apr 2014
Posts: 467
Location
Ontario, Canada

PostPosted: Sun Apr 01, 2018 4:41 pm    Post subject: Course Database CSV dumps Reply with quote

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!
View user's profile Send private message
grandpabruce



Joined: 25 Mar 2004
Posts: 2969
Location
Northern Minnesota

PostPosted: Sun Apr 01, 2018 4:50 pm    Post subject: Course Database CSV dumps Reply with quote

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
View user's profile Send private message
Captain Nemo



Joined: 03 Apr 2014
Posts: 467
Location
Ontario, Canada

PostPosted: Sun Apr 01, 2018 5:20 pm    Post subject: Course Database CSV dumps Reply with quote

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!
View user's profile Send private message
gator



Joined: 16 May 2006
Posts: 256

PostPosted: Sun Apr 01, 2018 6:00 pm    Post subject: Course Database CSV dumps Reply with quote

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).


View user's profile Send private message
Andy
Links Corner Admin
Links Corner Admin


Joined: 03 Sep 2003
Posts: 3547
Location
Winchcombe

PostPosted: Sun Apr 01, 2018 6:01 pm    Post subject: Course Database CSV dumps Reply with quote

You can open it in Google Sheets if you don't have Excel.

View user's profile Send private message
Captain Nemo



Joined: 03 Apr 2014
Posts: 467
Location
Ontario, Canada

PostPosted: Sun Apr 01, 2018 9:52 pm    Post subject: Course Database CSV dumps Reply with quote

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!
View user's profile Send private message
Andy
Links Corner Admin
Links Corner Admin


Joined: 03 Sep 2003
Posts: 3547
Location
Winchcombe

PostPosted: Sun Apr 01, 2018 10:12 pm    Post subject: Course Database CSV dumps Reply with quote

https://www.google.co.uk/sheets/about/

View user's profile Send private message
gator



Joined: 16 May 2006
Posts: 256

PostPosted: Mon Apr 02, 2018 12:37 am    Post subject: Course Database CSV dumps Reply with quote

For Captain Nemo (and anyone else who needs it) here is an Excel xls version with no formatting - https://we.tl/IbGOlxg91h.

View user's profile Send private message
Captain Nemo



Joined: 03 Apr 2014
Posts: 467
Location
Ontario, Canada

PostPosted: Mon Apr 02, 2018 3:00 pm    Post subject: Course Database CSV dumps Reply with quote

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!
View user's profile Send private message
Display posts from previous:   
View older topic :: View newer topic  
Post new topic   Reply to topic     Forum Index -> Course Corner All times are GMT
Page 1 of 1

 
Jump to:  
 

Swing hard in case you hit it. - Dan Marino