Thank you for your patience as we've added several hundred new TNs to the PP Tasting Notes Database.
A few things you'll notice from the old version:
1- The date format has been changed to yyyy-mm-dd (2006 05 09). This will allow you to sort by year/month/day rather than Tues, Weds, Thurs as it was previously.
2- You can also sort by wine type - Colheitta, Vintage Port, etc.
3- Some of the wine names may have changed, as we did a massive data normalization project in preparation for our integration with Vinfolio and Cellartracker. This resulted in much more consistent naming conventions for the wines.
4. Finally - If you come across any typos, errors, or anything else, please copy the WHOLE tasting note, and email it to admin@fortheloveofport.com and I'll fix it. We spent a lot of time cleaning this data, so hopefully you won't find any!
Thanks for your patience as we've updated this part of the site.
Enjoy.
Stewart
PP Tasting Notes Back Up
Moderators: Glenn E., Roy Hersh, Andy Velebil
PP Tasting Notes Back Up
Last edited by Guest on Wed May 23, 2007 9:29 am, edited 1 time in total.
- Derek T.
- Posts: 4080
- Joined: Wed Sep 14, 2005 5:02 pm
- Location: Chesterfield, United Kingdom - UK
- Contact:
Re: PP Tasting Notes Back Up
Stewart,
Good work my boy
Derek
Good work my boy
Did it involve electrodes and unknown drugs administered by Nurse Ratchetadmin wrote: we did a massive normalization project in preparation for our integration with Vinfolio and Cellartracker.
Derek
- Derek T.
- Posts: 4080
- Joined: Wed Sep 14, 2005 5:02 pm
- Location: Chesterfield, United Kingdom - UK
- Contact:
Stewart,
With reference to another thread relating to Forumite TN's, are you willing to reveal the format of your data structure for the TN database. I want to create my own TN database and would like to follow the format, constraints and convensions that you have used so that at some future date you could upload these to FTLOP.
I would be happy to create a spreadsheet or MS Access database that could be used by Forumites in the short term bt it would make sense to make this as close as possible to the format you already use.
Derek
With reference to another thread relating to Forumite TN's, are you willing to reveal the format of your data structure for the TN database. I want to create my own TN database and would like to follow the format, constraints and convensions that you have used so that at some future date you could upload these to FTLOP.
I would be happy to create a spreadsheet or MS Access database that could be used by Forumites in the short term bt it would make sense to make this as close as possible to the format you already use.
Derek
- Andy Velebil
- Posts: 16634
- Joined: Tue Aug 02, 2005 4:49 pm
- Location: Los Angeles, California, United States of America - USA
- Contact:
Stewart
Andy Velebil Good wine is a good familiar creature if it be well used. William Shakespeare http://www.fortheloveofport.com
Field for TNs
I've basically broken up the TN fields into their individual components:
Vintage (i.e. 1994 or NV)
Producer
Wine Name (including any designations, Reserva, etc.)
Type (i.e. Port, Madiera, or Douro Wine)
Note
Tasting Date (Format yyyy-mm-dd)
Score
All of the other fields are specific to our review component, so you wouldn't need to worry about maintaining those in your spreadsheet.
Vintage (i.e. 1994 or NV)
Producer
Wine Name (including any designations, Reserva, etc.)
Type (i.e. Port, Madiera, or Douro Wine)
Note
Tasting Date (Format yyyy-mm-dd)
Score
All of the other fields are specific to our review component, so you wouldn't need to worry about maintaining those in your spreadsheet.
No constrants
They ultimately all get converted to text format, so it doesn't really matter what format your fields are in your spreadsheet. No character limitations on the fields.