Time for a TN sort?

Make suggestions and report problems.
User avatar
DRT
Fonseca 1966
Posts: 15149
Joined: 23:51 Wed 20 Jun 2007
Location: Chesterfield, UK
Contact:

Post by DRT » 22:54 Tue 16 Oct 2007

Conky wrote:My head hurts!
Is that because of the cheap Auzzie plonk you've been drinking or was it caused by the gratuitous use of the word "unix" in a public forum?

Derek
"The first duty of Port is to be red"
Ernest H. Cockburn

Conky
Fonseca 1980
Posts: 1770
Joined: 23:51 Wed 20 Jun 2007

Post by Conky » 22:55 Tue 16 Oct 2007

It's when you techies get on a roll...

User avatar
KillerB
Taylor Quinta de Vargellas 1987
Posts: 2424
Joined: 22:09 Wed 20 Jun 2007
Location: Sky Blue City, England

Post by KillerB » 09:08 Wed 17 Oct 2007

I will send something later in my other guise
Port is basically a red drink

User avatar
DRT
Fonseca 1966
Posts: 15149
Joined: 23:51 Wed 20 Jun 2007
Location: Chesterfield, UK
Contact:

Post by DRT » 15:42 Sat 27 Oct 2007

Has this happened yet?
"The first duty of Port is to be red"
Ernest H. Cockburn

User avatar
jdaw1
Cockburn 1900
Posts: 20435
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

No.

Post by jdaw1 » 16:32 Sat 27 Oct 2007

No.

User avatar
DRT
Fonseca 1966
Posts: 15149
Joined: 23:51 Wed 20 Jun 2007
Location: Chesterfield, UK
Contact:

Post by DRT » 16:37 Sat 27 Oct 2007

:evil:

KillerB, could you please supply the data to Jdaw1 as promised.

Thanks

Derek
"The first duty of Port is to be red"
Ernest H. Cockburn

User avatar
KillerB
Taylor Quinta de Vargellas 1987
Posts: 2424
Joined: 22:09 Wed 20 Jun 2007
Location: Sky Blue City, England

Post by KillerB » 22:29 Sat 27 Oct 2007

Be aware that I have to do the majority of the work for this. I am happy to do it once per month but it takes time for me to download the data, convert it into spreadsheet form, select the right data, do the formatting and masking, determine the reference data, and now restrict the columns and give it headings that Julian likes to use. Whereupon, he takes that data and sticks some presentation code around it.
Port is basically a red drink

User avatar
DRT
Fonseca 1966
Posts: 15149
Joined: 23:51 Wed 20 Jun 2007
Location: Chesterfield, UK
Contact:

Post by DRT » 23:56 Sat 27 Oct 2007

KillreB,

If there is anything I can do to share the load of fullfilling jdaw's excessively demanding requirements please let me know.

...and I think once per month is more than adequate.

Derek
"The first duty of Port is to be red"
Ernest H. Cockburn

User avatar
jdaw1
Cockburn 1900
Posts: 20435
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Alternative suggestion: let me do both parts.

Post by jdaw1 » 01:11 Sun 28 Oct 2007

Alternative suggestion: let me do both parts. It will make the job, in total, easier and quicker.

User avatar
KillerB
Taylor Quinta de Vargellas 1987
Posts: 2424
Joined: 22:09 Wed 20 Jun 2007
Location: Sky Blue City, England

Post by KillerB » 15:13 Sun 28 Oct 2007

I have now simplified my side of the procedure. I have now got direct access to the database and have written some SQL which gets me the data much more easily than before.

I can do this on a much more regular basis now.

Very pretty Excel spreadsheet now on its way to Julian.
Port is basically a red drink

User avatar
jdaw1
Cockburn 1900
Posts: 20435
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Spreadsheet is far superior, but there is one small problem

Post by jdaw1 » 18:30 Sun 28 Oct 2007

Spreadsheet is far superior, but there is one small problem.
[url=http://www.theportforum.com/viewtopic.php?p=5293#5293]Here[/url] jdaw1 wrote:So what I really want from you is a simple four-column table containing:
  • User number (I have a private table of initials);
  • Post number (the number of the first post; not the thread number);
  • Unix time of that post;
  • Thread title.
You’ve put the thread number in your spreadsheet, not the post number. I don’t have that, I have only the post number, so I can’t cross reference between then two and delete the things I already have. Instead I’m going to have to tidy the names, all of them, by hand, again. Please could I have the post number?

User avatar
KillerB
Taylor Quinta de Vargellas 1987
Posts: 2424
Joined: 22:09 Wed 20 Jun 2007
Location: Sky Blue City, England

Post by KillerB » 20:08 Sun 28 Oct 2007

Hokkay
Port is basically a red drink

User avatar
jdaw1
Cockburn 1900
Posts: 20435
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Any chance of the UNIX time?

Post by jdaw1 » 22:03 Sun 28 Oct 2007

Better, thank you.

Any chance of the UNIX time?

User avatar
KillerB
Taylor Quinta de Vargellas 1987
Posts: 2424
Joined: 22:09 Wed 20 Jun 2007
Location: Sky Blue City, England

Re: Any chance of the UNIX time?

Post by KillerB » 22:05 Sun 28 Oct 2007

jdaw1 wrote:Better, thank you.

Any chance of the UNIX time?
A Unix is a single Twix, isn't it? In which case probably about 3PM with a cup of tea.
Port is basically a red drink

User avatar
KillerB
Taylor Quinta de Vargellas 1987
Posts: 2424
Joined: 22:09 Wed 20 Jun 2007
Location: Sky Blue City, England

Post by KillerB » 22:14 Sun 28 Oct 2007

I take it that you actually mean the time field for the topic. Don't you want me to split out the year then? I've been doing that all along. It's the most annoying bit.
Last edited by KillerB on 22:18 Sun 28 Oct 2007, edited 1 time in total.
Port is basically a red drink

User avatar
jdaw1
Cockburn 1900
Posts: 20435
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

UNIX time, etc

Post by jdaw1 » 22:16 Sun 28 Oct 2007

KillerB wrote:I take it that you actually mean the time field for the topic.
Great. Technically for the post, but they should usually be the same (unless the thread was created by moving posts).
KillerB wrote:I will also give you the poster id.
Isn’t that “topic_poster†? So I already have it.

KillerB wrote:
jdaw1 wrote:Better, thank you.

Any chance of the UNIX time?
A Unix is a single Twix, isn't it? In which case probably about 3PM with a cup of tea.
Thank you — excellent. No sugar, no milk.

User avatar
KillerB
Taylor Quinta de Vargellas 1987
Posts: 2424
Joined: 22:09 Wed 20 Jun 2007
Location: Sky Blue City, England

Post by KillerB » 22:19 Sun 28 Oct 2007

No milk? You've defintiely gone native.
Port is basically a red drink

User avatar
jdaw1
Cockburn 1900
Posts: 20435
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Time as in time of posting, not not vintage in UNIX format

Post by jdaw1 » 22:26 Sun 28 Oct 2007

KillerB wrote:I take it that you actually mean the time field for the topic. Don't you want me to split out the year then? I've been doing that all along. It's the most annoying bit.
Time as in time of posting, not not vintage quoted in UNIX time. Splitting out the vintage is very helpful. Please just add another column containing the time of posting, in Snickers format.
KillerB wrote:No milk? You've defintiely gone native.
No, always been like that.

And I’ve got to go, so will resume this task in about four hours.

User avatar
KillerB
Taylor Quinta de Vargellas 1987
Posts: 2424
Joined: 22:09 Wed 20 Jun 2007
Location: Sky Blue City, England

Post by KillerB » 22:32 Sun 28 Oct 2007

Do you want me to just give you the threads after the last load?
Port is basically a red drink

User avatar
jdaw1
Cockburn 1900
Posts: 20435
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Spreadsheets, again

Post by jdaw1 » 03:36 Mon 29 Oct 2007

1. New spreadsheet had the time, but the old thread ID not the new first post ID! Still, I’ve been able to splice the datasets together. It’ll be easier next time, I hope. Now working on name-tidying, which won’t be done this evening.

2. Yes please. Only posts since last index are needed.

Names:
  • Quinta do Bragào? Quinta do Bragão? Which?
  • Poças? Pocas? Which?
  • Gran Cruz? Cruz? Which?
  • Vista Allegre? Quinta da Vista Allegre? Which?
  • Is “Taylor Quinta do Vargellas Vinha Velha† the same as “Taylor Quinta do Vargellas†?
Last edited by jdaw1 on 19:04 Mon 29 Oct 2007, edited 3 times in total.

User avatar
AHB
Quinta do Noval Nacional 1962
Posts: 11778
Joined: 13:41 Mon 25 Jun 2007
Location: Berkshire, UK

Post by AHB » 15:48 Mon 29 Oct 2007

Pocas should have the cedilla included. The lack of a cedilla probably reflects ignorance or a lack of time to investigate which ASCII code has to be used on the keyboard to generate the ç character (135).

That was about the only bit of the exchange I understood between Al-K and jdaw1. I didn't even realise that Twixes went well with vintage port. I would have thought that they needed a tawny port or a colheita to match that caramel and shortbread.

I think I need a nice cup of Earl Grey to help soothe my nerves now...
Top Port in 2017 (so far): Graham Stone Terraces 2015 and Quinta do Vesuvio 1994
2016 Port of the year: Cockburn 1908

User avatar
jdaw1
Cockburn 1900
Posts: 20435
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

You don’t get a new index until I get answers!

Post by jdaw1 » 14:12 Wed 31 Oct 2007

You don’t get a new index until I get answers!
jdaw1 wrote:Names:
  • Quinta do Bragào? Quinta do Bragão? Which?
  • Poças? Pocas? Which?
  • Gran Cruz? Cruz? Which?
  • Vista Allegre? Quinta da Vista Allegre? Which?
  • Is “Taylor Quinta do Vargellas Vinha Velha† the same as “Taylor Quinta do Vargellas†?
The answers don’t even have to be right, they just have to be blamable on somebody else.

Conky
Fonseca 1980
Posts: 1770
Joined: 23:51 Wed 20 Jun 2007

Post by Conky » 14:29 Wed 31 Oct 2007

I would suggest someone answers Julian. His OCD can become quite severe at this time of year!

User avatar
KillerB
Taylor Quinta de Vargellas 1987
Posts: 2424
Joined: 22:09 Wed 20 Jun 2007
Location: Sky Blue City, England

Post by KillerB » 14:30 Wed 31 Oct 2007

Is “Taylor Quinta do Vargellas Vinha Velha† the same as “Taylor Quinta do Vargellas†?
No - different beast. Nothing to do with me, but I know this one. And it is 'de' not 'do'.
Port is basically a red drink

User avatar
DRT
Fonseca 1966
Posts: 15149
Joined: 23:51 Wed 20 Jun 2007
Location: Chesterfield, UK
Contact:

Re: You don’t get a new index until I get answers!

Post by DRT » 14:31 Wed 31 Oct 2007

jdaw1 wrote:You don’t get a new index until I get answers!
jdaw1 wrote:Names:
  • Quinta do Bragào? Quinta do Bragão? Which?
  • Poças? Pocas? Which?
  • Gran Cruz? Cruz? Which?
  • Vista Allegre? Quinta da Vista Allegre? Which?
  • Is “Taylor Quinta do Vargellas Vinha Velha† the same as “Taylor Quinta do Vargellas†?
The answers don’t even have to be right, they just have to be blamable on somebody else.
Quinta do Bragào
Poças
Gran Cruz
Quinta da Vista Allegre
No, it is different

Now blamable on me.
"The first duty of Port is to be red"
Ernest H. Cockburn

Post Reply