Time for a TN sort?

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

Conky · Post by **Conky** » 22:55 Tue 16 Oct 2007

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

KillerB · Post by **KillerB** » 09:08 Wed 17 Oct 2007

I will send something later in my other guise

Post by **DRT** » 15:42 Sat 27 Oct 2007

Has this happened yet?

Post by **jdaw1** » 16:32 Sat 27 Oct 2007

Post by **DRT** » 16:37 Sat 27 Oct 2007

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

Thanks

Derek

KillerB · 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.

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

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.

KillerB · 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.

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 ﬁrst 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?

KillerB · Post by **KillerB** » 20:08 Sun 28 Oct 2007

Hokkay

Post by **jdaw1** » 22:03 Sun 28 Oct 2007

Better, thank you.

Any chance of the UNIX time?

KillerB · 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.

KillerB · 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.

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.

KillerB · Post by **KillerB** » 22:19 Sun 28 Oct 2007

No milk? You've defintiely gone native.

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.

KillerB · Post by **KillerB** » 22:32 Sun 28 Oct 2007

Do you want me to just give you the threads after the last load?

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†?

Post by **Alex Bridgeman** » 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...

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

KillerB · 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'.

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.

ThePortForum.com

Time for a TN sort?

No.

Alternative suggestion: let me do both parts.

Spreadsheet is far superior, but there is one small problem

Any chance of the UNIX time?

Re: Any chance of the UNIX time?

UNIX time, etc

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

Spreadsheets, again

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

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