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.
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 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?
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.
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.
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.
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 Ports in 2023: Taylor 1896 Colheita, b. 2021. A perfect Port.
2024: Niepoort 1900 Colheita, b.1971. A near perfect Port.