User Updates

Autoplay, reporting, all those clever things it does. Discuss.

Moderator: kirkm

Platinum Record (Admin)
Platinum Record (Admin)
Posts: 694
Joined: Wed Mar 07, 2007 8:50 am

User Updates

Postby kirkm » Mon Apr 21, 2014 7:45 am

Some of you may have spotted the Send User Update feature in the spreadsheet and wondered what it was and how it works.

So here's an overview:
If you change or add something in the spreadsheet, you should also run User Config-Update Backend Row (and of course, save the workbook). But this doesn't give anyone else that change or correction, it's only in your copy.

Now as you update the backend a prompt asks if you want to send this to Britburn. You need to be on line and the only data sent is the one sheet line you've edited. It doesn’t use email but
directly uploads the data.

As this arrives at the Britburn website an email is sent to britburn& advising there's a new update and your data is appended to a local file.

You can see this file here.

The last entry starts with MAIL: and a datestamp
Line 2 is the sheet name and the Line number for the line you sent.

What follows is your information for that entry. It's base64 encoded because some of the characters can be lost in the transfer and this preserves them. It's easily decoded - PM me if you want more info (or Google Base64 decoder).

When run, a macro in Excel loads that file back, decodes it and compares the contents with each cell in that line. Any differences are verified, and added to what will become the next spreadsheet release.

There's no way to acknowledge receipt back to whoever made it... well, there is, but I felt it was a bit intrusive. So apart from browsing 'receivedMail.txt' any corrections will be documented here in the forum. Probably in batches of 10 or so.

There’s a few there already so the results will be here soon.

And – any additions you make will be gladly received! There’s a lot of empty cells and missing data. Even updating the duration of one track on an LP (in the balloon comment) will be sent. So TIA to anyone so inclined !! :D

Cheers - Kirk

Platinum Record (Admin)
Platinum Record (Admin)
Posts: 694
Joined: Wed Mar 07, 2007 8:50 am

Re: User Updates

Postby kirkm » Mon Apr 21, 2014 12:25 pm

Here is the first update :

All fields match

AlbumCharts:J2454 -- Comment
A STAR IS BORN - Original Soundtrack - CBS 86021
A1. Kris Kristofferson – Watch Closely Now (Kenny Ascher, Paul Williams) 03:40
A2. Barbra Streisand – Queen Bee (Rupert Holmes) 03:49
A3. Barbra Streisand – Everything (Kenny Ascher, Paul Williams) 03:41
A4. Kris Kristofferson – Lost Inside Of You (Leon Russell, Barbra Streisand) 02:53
A5. Barbra Streisand – Hellacious Acres (Kenny Ascher, Paul Williams) 02:49
A6. Barbra Streisand – Love Theme From "A Star Is Born" (Evergreen) (Barbra Streisand, Paul Williams) 03:04
B1. Barbra Streisand – The Woman In The Moon (Kenny Ascher, Paul Williams) 03:45
B2. Barbra Streisand – I Believe In Love (Alan Bergman, Marilyn Bergman, Kenny Loggins) 02:55
B3. Kris Kristofferson – Crippled Crow (Donna Weiss) 03:31
B4. Barbra Streisand – Finale: With One More Look At You / Watch Closely Now (Kenny Ascher, Paul Williams) 07:12
B5. Barbra Streisand & Kris Kristofferson – Reprise: Love Theme From "A Star Is Born" (Evergreen) (Barbra Streisand, Paul Williams) 01:46

Britburn:M4534 -- -- To -- p/John Schroeder
Britburn:R4534 -- -- To -- p/John Schroeder

All fields match

Britburn:O3513 -- w -- To -- Neighbour's Daughter

Return to “The Spreadsheet”

Who is online

Users browsing this forum: No registered users and 1 guest