|
#21
|
|||
|
|||
Re: The Aural Moon "FLAG PROJECT"
i decided today to help the project. i began with the initial Z bands . unfortunately when i reached the Zodiac band name , a single keyboard mistake kicked me out of this message box and all the work done was lost .. Does it work if I work on a' word sheet 'then copy and paste it in the message box?
|
#22
|
||||
|
||||
Re: The Aural Moon "FLAG PROJECT"
I want to do the same..is it possible to send a xls file or doc file ..copy/p ?
|
#23
|
||||
|
||||
Re: The Aural Moon "FLAG PROJECT"
Quote:
__________________
VAXman -- Watcher of the moon, watcher of all. ----------------Mopper of the moon, mopper of all. -------------------- Aural Moon's Janitorial Services ---------------------and Restroom Supplies, and Techno-patsy -- Cogito ergo iMac. |
#24
|
||||
|
||||
Re: The Aural Moon "FLAG PROJECT"
Quote:
Plain *TEXT* with the SQL. Text!!! not something that looks like text.
__________________
VAXman -- Watcher of the moon, watcher of all. ----------------Mopper of the moon, mopper of all. -------------------- Aural Moon's Janitorial Services ---------------------and Restroom Supplies, and Techno-patsy -- Cogito ergo iMac. |
#25
|
|||
|
|||
Re: The Aural Moon "FLAG PROJECT"
ok and thx vax
|
#26
|
||||
|
||||
Re: The Aural Moon "FLAG PROJECT"
Vax - can you post the latest set? Would be a shame if someone started working on a portion that is already complete.
|
#27
|
||||
|
||||
Re: The Aural Moon "FLAG PROJECT"
UPDATE samdb.songlist set lyrics="RU" where artist="Dreams of My Sky";
UPDATE samdb.songlist set lyrics="CA" where artist="Saga"; UPDATE samdb.songlist set lyrics="US" where artist="Gak Omek, The"; UPDATE samdb.songlist set lyrics="IT" where artist="Filoritmia"; UPDATE samdb.songlist set lyrics="HU" where artist="Solaris"; UPDATE samdb.songlist set lyrics="GB" where artist="Voyager Project"; UPDATE samdb.songlist set lyrics="FR" where artist="Ponty, Jean-Luc"; UPDATE samdb.songlist set lyrics="GB" where artist="Wishbone Ash"; UPDATE samdb.songlist set lyrics="CA" where artist="True Myth"; UPDATE samdb.songlist set lyrics="DE" where artist="Kraan"; UPDATE samdb.songlist set lyrics="US" where artist="Wood, Mark"; UPDATE samdb.songlist set lyrics="JP" where artist="Mr. Sirius"; UPDATE samdb.songlist set lyrics="GB" where artist="Citizen Cain"; UPDATE samdb.songlist set lyrics="GB" where artist="Motiffe"; UPDATE samdb.songlist set lyrics="DE" where artist="Passport";
__________________
Feels like I'm fiddling while Rome is burning down. Think I'll lay my fiddle down, take a rifle from the ground! Last edited by Yesspaz : 03-10-2011 at 11:26 PM. |
#28
|
||||
|
||||
Re: The Aural Moon "FLAG PROJECT"
UPDATE samdb.songlist set lyrics="IT" where artist="Luz Escondida";
UPDATE samdb.songlist set lyrics="GB" where artist="Powell, Cozy"; UPDATE samdb.songlist set lyrics="US" where artist="Tunnels"; UPDATE samdb.songlist set lyrics="FR" where artist="Sandrose"; UPDATE samdb.songlist set lyrics="US" where artist="Deluge Grander"; UPDATE samdb.songlist set lyrics="US" where artist="Chroma Key"; UPDATE samdb.songlist set lyrics="GB" where artist="Wally"; UPDATE samdb.songlist set lyrics="GB" where artist="Mostly Autumn"; UPDATE samdb.songlist set lyrics="US" where artist="Scofield, John & Pat Metheny"; UPDATE samdb.songlist set lyrics="US" where artist="Zappa, Frank"; UPDATE samdb.songlist set lyrics="EE" where artist="Kaseke"; UPDATE samdb.songlist set lyrics="NA" where artist="Flairck"; UPDATE samdb.songlist set lyrics="NO" where artist="Ericksen, Mats";
__________________
Feels like I'm fiddling while Rome is burning down. Think I'll lay my fiddle down, take a rifle from the ground! |
#29
|
||||
|
||||
Re: The Aural Moon "FLAG PROJECT"
UPDATE samdb.songlist set lyrics="US" where artist="House of Usher";
UPDATE samdb.songlist set lyrics="US" where artist="McLuhan"; UPDATE samdb.songlist set lyrics="US" where artist="Thanatopsis"; UPDATE samdb.songlist set lyrics="US" where artist="Pentwater"; UPDATE samdb.songlist set lyrics="IT" where artist="Trama"; UPDATE samdb.songlist set lyrics="GB" where artist="Random Hold";
__________________
Feels like I'm fiddling while Rome is burning down. Think I'll lay my fiddle down, take a rifle from the ground! |
#30
|
||||
|
||||
Re: The Aural Moon "FLAG PROJECT"
bump
|
#31
|
||||
|
||||
Re: The Aural Moon "FLAG PROJECT"
UPDATE samdb.songlist set lyrics="US" where artist="Macalpine, Tony";
UPDATE samdb.songlist set lyrics="AT" where artist="MacHacek; UPDATE samdb.songlist set lyrics="AT" where artist="Machacek, Alex; UPDATE samdb.songlist set lyrics="BE" where artist="Machiavel; UPDATE samdb.songlist set lyrics="JP" where artist="Machine And The Synergetic Nuts; UPDATE samdb.songlist set lyrics="ES" where artist="Macìa, Manoel; UPDATE samdb.songlist set lyrics="GB" where artist="Mackay, Duncan; UPDATE samdb.songlist set lyrics="AU" where artist="Mackenzie Theory; UPDATE samdb.songlist set lyrics="IT" where artist="Macro Marco; UPDATE samdb.songlist set lyrics="IT" where artist="Mad Crayon; UPDATE samdb.songlist set lyrics="AU" where artist="Madder Lake; UPDATE samdb.songlist set lyrics="SE" where artist="Made In Sweden; UPDATE samdb.songlist set lyrics="BE" where artist="Madelgaire; UPDATE samdb.songlist set lyrics="DE" where artist="Madrigal; UPDATE samdb.songlist set lyrics="DK" where artist="Mads Vinding Group; UPDATE samdb.songlist set lyrics="US" where artist="Madsen, Bernie; UPDATE samdb.songlist set lyrics="GB" where artist="Mae, Vanessa; UPDATE samdb.songlist set lyrics="US" where artist="Maelström Percussion Ensemble; UPDATE samdb.songlist set lyrics="GB" where artist="Maestoso; UPDATE samdb.songlist set lyrics="JP" where artist="Magdalena; UPDATE samdb.songlist set lyrics="US" where artist="Magellan; UPDATE samdb.songlist set lyrics="US" where artist="Magellan Music; UPDATE samdb.songlist set lyrics="GB" where artist="Magenta; UPDATE samdb.songlist set lyrics="GB" where artist="Magenta w/Annie Haslam; UPDATE samdb.songlist set lyrics="IT" where artist="Maggiore, Giorgio; UPDATE samdb.songlist set lyrics="US" where artist="Magic Elf, The; UPDATE samdb.songlist set lyrics="NO" where artist="Magic Pie; UPDATE samdb.songlist set lyrics="JP" where artist="Magical Power Mako; UPDATE samdb.songlist set lyrics="FR" where artist="Magma; UPDATE samdb.songlist set lyrics="FR" where artist="Magnesis; UPDATE samdb.songlist set lyrics="IT" where artist="Magnetic Sound Machine; |
#32
|
||||
|
||||
Re: The Aural Moon "FLAG PROJECT"
UPDATE samdb.songlist set lyrics="US" where artist="Macalpine, Tony";
UPDATE samdb.songlist set lyrics="AT" where artist="MacHacek"; UPDATE samdb.songlist set lyrics="AT" where artist="Machacek, Alex"; UPDATE samdb.songlist set lyrics="BE" where artist="Machiavel"; UPDATE samdb.songlist set lyrics="JP" where artist="Machine And The Synergetic Nuts"; UPDATE samdb.songlist set lyrics="ES" where artist="Macìa, Manoel"; UPDATE samdb.songlist set lyrics="GB" where artist="Mackay, Duncan"; UPDATE samdb.songlist set lyrics="AU" where artist="Mackenzie Theory"; UPDATE samdb.songlist set lyrics="IT" where artist="Macro Marco"; UPDATE samdb.songlist set lyrics="IT" where artist="Mad Crayon"; UPDATE samdb.songlist set lyrics="AU" where artist="Madder Lake"; UPDATE samdb.songlist set lyrics="SE" where artist="Made In Sweden"; UPDATE samdb.songlist set lyrics="BE" where artist="Madelgaire"; UPDATE samdb.songlist set lyrics="DE" where artist="Madrigal"; UPDATE samdb.songlist set lyrics="DK" where artist="Mads Vinding Group"; UPDATE samdb.songlist set lyrics="US" where artist="Madsen, Bernie"; UPDATE samdb.songlist set lyrics="GB" where artist="Mae, Vanessa"; UPDATE samdb.songlist set lyrics="US" where artist="Maelström Percussion Ensemble"; UPDATE samdb.songlist set lyrics="GB" where artist="Maestoso"; UPDATE samdb.songlist set lyrics="JP" where artist="Magdalena"; UPDATE samdb.songlist set lyrics="US" where artist="Magellan"; UPDATE samdb.songlist set lyrics="US" where artist="Magellan Music"; UPDATE samdb.songlist set lyrics="GB" where artist="Magenta"; UPDATE samdb.songlist set lyrics="GB" where artist="Magenta w/Annie Haslam"; UPDATE samdb.songlist set lyrics="IT" where artist="Maggiore, Giorgio"; UPDATE samdb.songlist set lyrics="US" where artist="Magic Elf, The"; UPDATE samdb.songlist set lyrics="NO" where artist="Magic Pie"; UPDATE samdb.songlist set lyrics="JP" where artist="Magical Power Mako"; UPDATE samdb.songlist set lyrics="FR" where artist="Magma"; UPDATE samdb.songlist set lyrics="FR" where artist="Magnesis"; UPDATE samdb.songlist set lyrics="IT" where artist="Magnetic Sound Machine"; Corrected. Disregard porevious. |
#33
|
||||
|
||||
Re: The Aural Moon "FLAG PROJECT"
UPDATE samdb.songlist set lyrics="SE" where artist="Brighteye Brison";
UPDATE samdb.songlist set lyrics="US" where artist="Gleeson, Patrick"; UPDATE samdb.songlist set lyrics="AU" where artist="Dead Letter Circus"; UPDATE samdb.songlist set lyrics="FR" where artist="Nemo"; UPDATE samdb.songlist set lyrics="GB" where artist="Seventh Wave"; UPDATE samdb.songlist set lyrics="US" where artist="Tuner"; UPDATE samdb.songlist set lyrics="SE" where artist="Larrson, Lalle"; UPDATE samdb.songlist set lyrics="SE" where artist="De Gladas Kapell"; UPDATE samdb.songlist set lyrics="SE" where artist="Brighteye Brison";
__________________
Feels like I'm fiddling while Rome is burning down. Think I'll lay my fiddle down, take a rifle from the ground! |
#34
|
||||
|
||||
Re: The Aural Moon "FLAG PROJECT"
A few questions. First, is the methodology described in this thread still the latest way to get things updated in the database?
Second, was Dale involved in any of this? My memory is a bit fuzzy but I thought he was involved in some mass update. Third, can a pull be done from the database to show which artists are flagless? And finally, is there an editor to proof submissions if one choses to participate?
__________________
Cheers, Carl |
#35
|
||||
|
||||
Re: The Aural Moon "FLAG PROJECT"
Nice call on three for sure.
__________________
Feels like I'm fiddling while Rome is burning down. Think I'll lay my fiddle down, take a rifle from the ground! |
#36
|
||||
|
||||
Re: The Aural Moon "FLAG PROJECT"
Judging by the amount of songs being played without a flag, I'm guessing the list is going to be fairly large.
BTW, if there was a public database with an API or SPI to access data like country of origin, I'm sure a neat program could be written to actually populate the missing values.
__________________
Cheers, Carl |
#37
|
||||
|
||||
Re: The Aural Moon "FLAG PROJECT"
Quote:
My MO, back when I worked on it, was when I saw an artist without a flag play, I wrote it down. When I had twenty or so I did those. I may have to get back to that a bit.
__________________
Feels like I'm fiddling while Rome is burning down. Think I'll lay my fiddle down, take a rifle from the ground! |
Thread Tools | |
Display Modes | Rate This Thread |
|
|
All times are GMT -5. The time now is 09:42 AM. |