The Aural Moon "FLAG PROJECT"

[VAXman(Admin)]

Originally Posted by dnsrees

The "A" bands are complete. I'm going to start working on the "B" bands unless someone else has already done so. Please advise if you have.

Thanks...

Wow! I think we all owe Dennis a huge kudos for all for work he's done.

Thanks. At this rate, I'll have to begin the recoding of the "request" stuff for country sorting sooner than I'd expected.

BTW, I don't know if you're keeping the list too. A quote was missing on Afroskull. You might want to amend it. If not, it's amended in the compete listing in the second post here.

[dnsrees]

Originally Posted by VAXman

Wow! I think we all owe Dennis a huge kudos for all for work he's done.

Thanks. At this rate, I'll have to begin the recoding of the "request" stuff for country sorting sooner than I'd expected.

BTW, I don't know if you're keeping the list too. A quote was missing on Afroskull. You might want to amend it. If not, it's amended in the compete listing in the second post here.

Thanks Vax - I am keeping the list I work on just as a backup so I will fix that one entry - never know when that could come in handy

[VAXman(Admin)]

Originally Posted by dnsrees

Thanks Vax - I am keeping the list I work on just as a backup so I will fix that one entry - never know when that could come in handy

I have several copies scattered about. This is too much effort to leave to chance of being lost.

[dnsrees]

UPDATE samdb.songlist set lyrics="US" where artist="B Hansen";
UPDATE samdb.songlist set lyrics="SE" where artist="Baby Grandmothers";
UPDATE samdb.songlist set lyrics="US" where artist="Babylon";
UPDATE samdb.songlist set lyrics="BR" where artist="Bacamarte";
UPDATE samdb.songlist set lyrics="US" where artist="Bach & Leonard Overdrive";
UPDATE samdb.songlist set lyrics="IT" where artist="Bacio Della Medusa, Il";
UPDATE samdb.songlist set lyrics="US" where artist="Bad Alchemy";
UPDATE samdb.songlist set lyrics="US" where artist="Bad Dog U";
UPDATE samdb.songlist set lyrics="UK" where artist="Badger";
UPDATE samdb.songlist set lyrics="FR" where artist="Bag";
UPDATE samdb.songlist set lyrics="US" where artist="Bagsby, David";
UPDATE samdb.songlist set lyrics="US" where artist="Bagsby, Steve";
UPDATE samdb.songlist set lyrics="IR" where artist="Bahari, Agah";
UPDATE samdb.songlist set lyrics="CA" where artist="Baird, Ken";
UPDATE samdb.songlist set lyrics="DE" where artist="Bairy, Herbert F.";
UPDATE samdb.songlist set lyrics="DE" where artist="Baja";
UPDATE samdb.songlist set lyrics="UK" where artist="Baker, Ginger";
UPDATE samdb.songlist set lyrics="RO" where artist="Balanescu Quartet, The";
UPDATE samdb.songlist set lyrics="US" where artist="Baliset";
UPDATE samdb.songlist set lyrics="RS" where artist="Balkan Horses Band";
UPDATE samdb.songlist set lyrics="IT" where artist="Balletto Di Bronzo, Il ";
UPDATE samdb.songlist set lyrics="NL" where artist="Balloon";
UPDATE samdb.songlist set lyrics="IT" where artist="Banco Del Mutuo Soccorso";
UPDATE samdb.songlist set lyrics="US" where artist="Banda Elastica";
UPDATE samdb.songlist set lyrics="US" where artist="Bandhada";
UPDATE samdb.songlist set lyrics="IT" where artist="Banfi, Baffo";
UPDATE samdb.songlist set lyrics="US" where artist="Banyan";
UPDATE samdb.songlist set lyrics="JP" where artist="Baraka";
UPDATE samdb.songlist set lyrics="IT" where artist="Barbati E Maiozzi";
UPDATE samdb.songlist set lyrics="UK" where artist="Barbieri, Richard";
UPDATE samdb.songlist set lyrics="UK" where artist="Barclay James Harvest";
UPDATE samdb.songlist set lyrics="UK" where artist="Bardens, Pete";
UPDATE samdb.songlist set lyrics="FR" where artist="Bardin, Didier";
UPDATE samdb.songlist set lyrics="US" where artist="Barefoot";
UPDATE samdb.songlist set lyrics="IT" where artist="Baricentro, Il";
UPDATE samdb.songlist set lyrics="UK" where artist="Bark Psychosis";
UPDATE samdb.songlist set lyrics="SE" where artist="Barr";
UPDATE samdb.songlist set lyrics="IT" where artist="Barrock";
UPDATE samdb.songlist set lyrics="NL" where artist="Barstool Philosophers, The";
UPDATE samdb.songlist set lyrics="IQ" where artist="Basim, Al";
UPDATE samdb.songlist set lyrics="UK" where artist="Bass Communion";
UPDATE samdb.songlist set lyrics="IT" where artist="Battiato";
UPDATE samdb.songlist set lyrics="US" where artist="Battles";
UPDATE samdb.songlist set lyrics="UK" where artist="Baumgartner, Eric";
UPDATE samdb.songlist set lyrics="US" where artist="Beane, Phil";
UPDATE samdb.songlist set lyrics="US" where artist="Bear, Jeff";
UPDATE samdb.songlist set lyrics="DE" where artist="Bearded Project, The";
UPDATE samdb.songlist set lyrics="SE" where artist="Beardfish";
UPDATE samdb.songlist set lyrics="US" where artist="Beastie Boys";
UPDATE samdb.songlist set lyrics="US" where artist="Beat Circus";
UPDATE samdb.songlist set lyrics="UK" where artist="Beck, Jeff";
UPDATE samdb.songlist set lyrics="US" where artist="Beddia, Scott";
UPDATE samdb.songlist set lyrics="PT" where artist="Beduinos a Gasoleo";
UPDATE samdb.songlist set lyrics="DE" where artist="Beethoven, Ludwig Van";
UPDATE samdb.songlist set lyrics="IT" where artist="Beggar's Farm";
UPDATE samdb.songlist set lyrics="UK" where artist="Beggar's Tail";
UPDATE samdb.songlist set lyrics="UK" where artist="Beggars Opera";
UPDATE samdb.songlist set lyrics="YU" where artist="Begnagrad";
UPDATE samdb.songlist set lyrics="US" where artist="Belew, Adrian ";
UPDATE samdb.songlist set lyrics="US" where artist="Belew, Adrian Power Trio";
UPDATE samdb.songlist set lyrics="PL" where artist="Believe";
UPDATE samdb.songlist set lyrics="US" where artist="Bellador";
UPDATE samdb.songlist set lyrics="JP" where artist="Bellaphon";
UPDATE samdb.songlist set lyrics="US" where artist="Benjamin, Alan";
UPDATE samdb.songlist set lyrics="FR" where artist="Bensusan, Pierre & Didier Malherbe";
UPDATE samdb.songlist set lyrics="US" where artist="Bergamini, Joe";
UPDATE samdb.songlist set lyrics="HU" where artist="Bergendy";
UPDATE samdb.songlist set lyrics="CA" where artist="Bériau, Robert";
UPDATE samdb.songlist set lyrics="US" where artist="Berry, Robert";
UPDATE samdb.songlist set lyrics="DE" where artist="Between";
UPDATE samdb.songlist set lyrics="SE" where artist="Between Interval";
UPDATE samdb.songlist set lyrics="US" where artist="Betz, Alfy With The Imaginar..";
UPDATE samdb.songlist set lyrics="US" where artist="Beyond Infinity";
UPDATE samdb.songlist set lyrics="US" where artist="Bezar, Emily";

[Yesspaz]

Okay, not to be TOO nitpicky, but let's check with what's already done before doing more. Some are getting redone and changed from correct to incorrect. Also, be careful in spelling and punctuation. These are cut and paste from the master list above:

UPDATE samdb.songlist set lyrics="US" where artist="Album Leaf, The";
UPDATE samdb.songlist set lyrics="IS" where artist="Album Leaf, The";

and

UPDATE samdb.songlist set lyrics="AU" where artist="Allen, Daevid";
UPDATE samdb.songlist set lyrics="US" where artist="Allen, David";

and

UPDATE samdb.songlist set lyrics="GB" where artist="Anderson, Bruford, Wakeman, Howe";
UPDATE samdb.songlist set lyrics="UK" where artist="Anderson, Bruford, Wakeman, Howe";
UPDATE samdb.songlist set lyrics="UK" where artist="Anderson, Ian ";
UPDATE samdb.songlist set lyrics="GB" where artist="Anderson, Ian";
UPDATE samdb.songlist set lyrics="US" where artist="Anderson, Jon";
UPDATE samdb.songlist set lyrics="GB" where artist="Anderson, Jon";
UPDATE samdb.songlist set lyrics="US" where artist="Anderson, Laurie";
UPDATE samdb.songlist set lyrics="UK" where artist="Anderson, Laurie";

and

UPDATE samdb.songlist set lyrics="US" where artist="dc Talk";
UPDATE samdb.songlist set lyrics="US" where artist="dcTalk";

and

UPDATE samdb.songlist set lyrics="AU" where artist="Ilium";
UPDATE samdb.songlist set lyrics="US" where artist="Ilium";

and

UPDATE samdb.songlist set lyrics="GB" where artist="Iommi, Tommy";
UPDATE samdb.songlist set lyrics="UK" where artist="Iommi, Tommy";
UPDATE samdb.songlist set lyrics="UK" where artist="Iona";
UPDATE samdb.songlist set lyrics="GB" where artist="Iona";



... for the record, The Album Leaf and Ilium are both US bands.

[VAXman(Admin)]

Originally Posted by Yesspaz

Okay, not to be TOO nitpicky, but let's check with what's already done before doing more. Some are getting redone and changed from correct to incorrect. Also, be careful in spelling and punctuation. These are cut and paste from the master list above:

UPDATE samdb.songlist set lyrics="US" where artist="Album Leaf, The";
UPDATE samdb.songlist set lyrics="IS" where artist="Album Leaf, The";

and

UPDATE samdb.songlist set lyrics="AU" where artist="Allen, Daevid";
UPDATE samdb.songlist set lyrics="US" where artist="Allen, David";

and

UPDATE samdb.songlist set lyrics="GB" where artist="Anderson, Bruford, Wakeman, Howe";
UPDATE samdb.songlist set lyrics="UK" where artist="Anderson, Bruford, Wakeman, Howe";
UPDATE samdb.songlist set lyrics="UK" where artist="Anderson, Ian ";
UPDATE samdb.songlist set lyrics="GB" where artist="Anderson, Ian";
UPDATE samdb.songlist set lyrics="US" where artist="Anderson, Jon";
UPDATE samdb.songlist set lyrics="GB" where artist="Anderson, Jon";
UPDATE samdb.songlist set lyrics="US" where artist="Anderson, Laurie";
UPDATE samdb.songlist set lyrics="UK" where artist="Anderson, Laurie";

and

UPDATE samdb.songlist set lyrics="US" where artist="dc Talk";
UPDATE samdb.songlist set lyrics="US" where artist="dcTalk";

and

UPDATE samdb.songlist set lyrics="AU" where artist="Ilium";
UPDATE samdb.songlist set lyrics="US" where artist="Ilium";

and

UPDATE samdb.songlist set lyrics="GB" where artist="Iommi, Tommy";
UPDATE samdb.songlist set lyrics="UK" where artist="Iommi, Tommy";
UPDATE samdb.songlist set lyrics="UK" where artist="Iona";
UPDATE samdb.songlist set lyrics="GB" where artist="Iona";



... for the record, The Album Leaf and Ilium are both US bands.

Hmm... It would appear that the sort/merge on Linux isn't as good as the sort/merge on VMS. I have been sorting on column 52 through the end and I've requested the removal of duplicates. Apparently, this is not happening. I'll be sure to sort/merge this on the better OS in the future.

"dc Talk/dcTalk" is in SAM's database that way. If you want to correct that, please do so with SAM. I think you still have station access.

"UK" should be "GB", I'll fix those. I've addressed the "Andersons" too.