Latest User Updates

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

Moderator: kirkm

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

Latest User Updates

Postby kirkm » Tue May 06, 2014 2:07 am

Greetings... I've revamped the dump of user updates to a new format. It now means the process is almost completely automated and just needs a control-v into a msg here! :)

If you've sent an update it should appear here in due course. If anyone wants to apply these to their own spreadsheet, please do but remember to save it! You don't need to send that change back to the website, but it doesn't matter if you do because any changes that are the same are ignored. If you make a change to a change, the newest change is used.
If you spot a change that's incorrect, please advise here. Hopefully that won't be needed !

There will be more additions and alterations in the next ss as a lot of data is added without using the update method. You can also ignore anything here as they'll all be in the spreadsheet anyway. This is more to acknowledge ones sent and for those doing data additions.

Wordwrap may make some hard to read, but a copy-paste into Notepad with wordwrap off correctly displays. And each line of data starts with the spreadsheet field name.

Cheers - Kirk
--
WorkSheet: Britburn
Prefix: 66_262
Submitted: 21 Apr 2014
B-Side Title Field was w UPDATED to Neighbour's Daughter

WorkSheet: Britburn
Prefix: 82_004
Submitted: 22 Apr 2014
A-Time Field was 03 48 UPDATED to 05 08

WorkSheet: Britburn
Prefix: 82_097
Submitted: 22 Apr 2014
A-Time Field was 04 04 UPDATED to 03 27

WorkSheet: Britburn
Prefix: 82_106
Submitted: 22 Apr 2014
A-Time Field was 04 18 UPDATED to 03 34

WorkSheet: Britburn
Prefix: 82_107
Submitted: 22 Apr 2014
A-Time Field was 03 56 UPDATED to 03 20

WorkSheet: Britburn
Prefix: 82_114
Submitted: 22 Apr 2014
A-Time Field was 03 35 UPDATED to 07 07

WorkSheet: Britburn
Prefix: 82_229
Submitted: 22 Apr 2014
A-Time Field was 09 06 UPDATED to 04 17

WorkSheet: Britburn
Prefix: 82_312
Submitted: 22 Apr 2014
A-Time Field was 03 52 UPDATED to 03 45

WorkSheet: Britburn
Prefix: 82_353
Submitted: 22 Apr 2014
A-Time Field was 04 34 UPDATED to 03 28

WorkSheet: Britburn
Prefix: 82_390
Submitted: 22 Apr 2014
A-Time Field was 05 12 UPDATED to 03 24

WorkSheet: Britburn
Prefix: 82_395
Submitted: 22 Apr 2014
A-Time Field was 04 20 UPDATED to 04 13

WorkSheet: Britburn
Prefix: 82_417
Submitted: 22 Apr 2014
A-Time Field was 05 57 UPDATED to 03 22

WorkSheet: Britburn
Prefix: 82_427
Submitted: 22 Apr 2014
A-Time Field was 04 59 UPDATED to 03 30

WorkSheet: Britburn
Prefix: 82_448
Submitted: 22 Apr 2014
A-Time Field was 03 57 UPDATED to 03 10

WorkSheet: Britburn
Prefix: 82_493
Submitted: 22 Apr 2014
A-Time Field was 04 51 UPDATED to 03 55

WorkSheet: Britburn
Prefix: 82_541
Submitted: 22 Apr 2014
A-Time Field was 04 22 UPDATED to 05 40

WorkSheet: Britburn
Prefix: 82_562
Submitted: 22 Apr 2014
A-Time Field was 04 21 UPDATED to 03 28

WorkSheet: Britburn
Prefix: 82_601
Submitted: 22 Apr 2014
A-Time Field was 04 32 UPDATED to 03 44

WorkSheet: Britburn
Prefix: 82_586
Submitted: 23 Apr 2014
B-Side Title Field was Sterile—(So) What For The 80s UPDATED to (So) What For The 80s?—Sterile
B-Time Field was 2:39—2:09 UPDATED to 2:05—2:35
B-Side Composer Field was Dave Bateman/Rebecca Bond—Dave Bateman/Rebecca Bond UPDATED to Dave Bateman—Dave Bateman/Rebecca Bond

WorkSheet: Britburn
Prefix: 82_506
Submitted: 23 Apr 2014
A-Side Session Field was p/Rupert Hine UPDATED to p/Rupert Hine e/Stephen W. Tayler
B-Side Session Field was p/Rupert Hine UPDATED to p/Rupert Hine e/Stephen W. Tayler

WorkSheet: Britburn
Prefix: 77_452
Submitted: 24 Apr 2014
Artist Field was The Muppets UPDATED to The Entire Cast
Title Field was Muppet Show Theme UPDATED to The Muppet Show Theme
B-Time Field was UPDATED to 02 29

WorkSheet: Britburn
Prefix: 82_517
Submitted: 25 Apr 2014
A-Side Composer Field was Thomas Allen/Harold Brown/Morris Dickerson/Jerry Goldstein/Roy Jordan/Lee Levitin/Charles Miller/Howard Scott/Lee Levitin UPDATED to Thomas Allen/Harold Brown/Jerry Goldstein/Roy Jordan/Howard Scott/Luther Rabb/Lee Oskar
B-Side Composer Field was Sylvester Allen/Harold Brown/Jerry Goldstein/Ronald Hammon/Lonnie Jordan/Lee Oskar/Luther Rabb/Pat Rizzo/Howard Scott UPDATED to Thomas Allen/Harold Brown/Jerry Goldstein/Ronald Hammon/Lonnie Jordan/Lee Oskar/Luther Rabb/Pat Rizzo/Howard Scott

WorkSheet: AlbumCharts
Prefix: LP57_005
Submitted: 28 Apr 2014
All fields match

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

Re: Latest User Updates

Postby kirkm » Sun May 11, 2014 4:23 am

Here's another update. Just a note about these - I realise they make pretty dry reading and it's not necessary to apply them (they'll all be in the next spreadsheet). They're here mainly to acknowledge what's been received and applied. If you sent an update through you may want to confirm it's here.

Cheers - Kirk
--
Worksheet: Britburn
Prefix: 56_076
Submitted: 07 May 2014
B-Side Session Field was empty UPDATED to m/Kismet

Worksheet: Britburn
Prefix: 60_175
Submitted: 07 May 2014
B-Side Session Field was p/George Martin UPDATED to p/George Martin a/Ken Jones

Worksheet: Britburn
Prefix: 60_175
Submitted: 07 May 2014
A-Side Session Field was a/Ken Jones UPDATED to p/George Martin a/Ken Jones
B-Side Session Field was p/George Martin UPDATED to p/George Martin a/Ken Jones

Worksheet: Britburn
Prefix: 64_022
Submitted: 07 May 2014
B-Side Session Field was empty UPDATED to p/Mickie Most

Worksheet: Britburn
Prefix: 64_086
Submitted: 07 May 2014
A-Side Session Field was empty UPDATED to p/Mickie Most
B-Side Session Field was empty UPDATED to p/Mickie Most

Worksheet: Britburn
Prefix: 83_239
Submitted: 08 May 2014
Comment for Cell J11873 was
See Also
83_240b
UPDATED to
See Also
83_240b
80_006a

Comment for Cell O11873 was
See Also
83_240a
UPDATED to
See Also
83_240a
80_006b


Worksheet: Britburn
Prefix: 83_240
Submitted: 08 May 2014
Comment for Cell J11874 was
See Also
83_239b
UPDATED to
See Also
83_239b
80_007a

Comment for Cell O11874 was
See Also
83_239a
UPDATED to
See Also
83_239a
80_007b


Worksheet: Britburn
Prefix: 80_006
Submitted: 08 May 2014
Comment for Cell J9501 was
See Also
80_007b
UPDATED to
See Also
80_007b
83_239a

Comment for Cell O9501 was
See Also
80_007a
UPDATED to
See Also
80_007a
83_240a


Worksheet: Britburn
Prefix: 80_007
Submitted: 08 May 2014
Comment for Cell J9502 was
See Also
80_006b
UPDATED to
See Also
80_006b
83_240a

Comment for Cell O9502 was
See Also
80_006a
UPDATED to
See Also
80_006a
83_239a


Worksheet: Britburn
Prefix: 82_391
Submitted: 08 May 2014
B-Time Field was 05 12 UPDATED to 03 24

Worksheet: Britburn
Prefix: 66_461
Submitted: 08 May 2014
B-Time Field was empty UPDATED to 02 14

Worksheet: Britburn
Prefix: 66_444
Submitted: 08 May 2014
A-Time Field was 02 11 UPDATED to 02 16
B-Time Field was empty UPDATED to 02 31

Worksheet: Britburn
Prefix: 77_377
Submitted: 09 May 2014
Title Field was Super Band UPDATED to Super Band
A-Time Field was 04 53 UPDATED to 05 56
A-Side Session Field was p/Kool And The Gang UPDATED to p/Kool And The Gang a/Kool And The Gang
B-Time Field was empty UPDATED to 08 48
B-Side Session Field was p/Kool And The Gang UPDATED to p/Kool And The Gang a/Kool And The Gang
B-Time Field was 03 48 UPDATED to 08 48

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

Re: Latest User Updates

Postby kirkm » Thu May 15, 2014 3:41 am

Another two. (In the album comment only track B5 was changed)

Worksheet: Britburn
Prefix: 77_377
Submitted: 11 May 2014
Title Field was Super Band UPDATED to Super Band
A-Time Field was 04 53 UPDATED to 05 56
A-Side Composer Field was Kool And The Gang UPDATED to Kool & The Gang
A-Side Session Field was p/Kool And The Gang UPDATED to p/Kool & The Gang a/Kool & The Gang
B-Time Field was empty UPDATED to 08 48
B-Side Composer Field was Kool And The Gang UPDATED to Kool & The Gang
B-Side Session Field was p/Kool And The Gang UPDATED to p/Kool & The Gang a/Kool & The Gang

Worksheet: AlbumCharts
Prefix: LP57_005
Submitted: 11 May 2014
Comment for Cell J20 was
HIGH SOCIETY - Original Soundtrack - Capitol LCT 6116
All tracks composed by Cole Porter

A1. MGM Studio Orchestra – High Society (Overture) 3:28
A2. Louis Armstrong & His Band – High Society Calypso 2:10
A3. Bing Crosby – Little One 2:27
A4. Frank Sinatra & Celeste Holm – (Who Wants To Be) A Millionaire 2:04
A5. Bing Crosby & Grace Kelly – True Love 3:03
B1. Frank Sinatra – You're Sensational 3:50
B2. Bing Crosby – I Love You, Samantha 4:25
B3. Bing Crosby & Louis Armstrong – Now You Has Jazz 4:14
B4. Bing Crosby & Frank Sinatra – Well Did You Evah? 3:44
B5. Frank Sinatra & Mind If I Make Love To You 2:21
UPDATED to
HIGH SOCIETY - Original Soundtrack - Capitol LCT 6116
All tracks composed by Cole Porter

A1. MGM Studio Orchestra – High Society (Overture) 3:28
A2. Louis Armstrong & His Band – High Society Calypso 2:10
A3. Bing Crosby – Little One 2:27
A4. Frank Sinatra & Celeste Holm – (Who Wants To Be) A Millionaire 2:04
A5. Bing Crosby & Grace Kelly – True Love 3:03
B1. Frank Sinatra – You're Sensational 3:50
B2. Bing Crosby – I Love You, Samantha 4:25
B3. Bing Crosby & Louis Armstrong – Now You Has Jazz 4:14
B4. Bing Crosby & Frank Sinatra – Well Did You Evah? 3:44
B5. Frank Sinatra - Mind If I Make Love To You 2:21

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

Re: Latest User Updates

Postby kirkm » Mon Jun 23, 2014 5:52 am

If anyone was wondering why no User Amendments lately - there are 126 pending.
A new system for handling them is being developed - and I'm holding off so these can be used for testing.

They'll be posted here soon (as a text file link because it's not gripping reading) for those who want it to download.

If all goes as planned the next spreadsheet will be able to Import this file and apply any changes automatically. There will always be new data not be in the amendments (and other improvements) so keep getting each new spreadsheet.

Another new feature is a Lyrics update option. If you correct a lyric (and are online and have the option selected) your fix will reach Terry who will add it in the next lyrics update)

Cheers - Kirk


Return to “The Spreadsheet”

Who is online

Users browsing this forum: No registered users and 2 guests