Go Back   Aural Moon - Progressive Rock Discussion > Prog Rock Discussion > General Discussion/Prog News
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Rate Thread Display Modes
  #21  
Old 02-24-2011, 10:30 AM
mailotron mailotron is offline
Registered User
 
Join Date: Dec 2004
Posts: 1,291
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?
Reply With Quote
  #22  
Old 02-24-2011, 11:56 AM
mariocc's Avatar
mariocc mariocc is offline
Registered User
 
Join Date: Dec 2007
Location: Santiago
Posts: 1,209
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 ?
Reply With Quote
  #23  
Old 02-24-2011, 01:11 PM
VAXman's Avatar
VAXman(Admin) VAXman is offline
progger propellerhead
 
Join Date: Dec 2003
Location: Presently reside in Jackson (southern) NJ (20 miles east of NEARfest 2002 & 2003
Posts: 2,362
Send a message via AIM to VAXman Send a message via Skype™ to VAXman
Re: The Aural Moon "FLAG PROJECT"

Quote:
Originally Posted by mailotron View Post
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?
Yes. OR... let me know and I'll give you an ftp login to upload your effort.
__________________
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.         
Reply With Quote
  #24  
Old 02-24-2011, 01:12 PM
VAXman's Avatar
VAXman(Admin) VAXman is offline
progger propellerhead
 
Join Date: Dec 2003
Location: Presently reside in Jackson (southern) NJ (20 miles east of NEARfest 2002 & 2003
Posts: 2,362
Send a message via AIM to VAXman Send a message via Skype™ to VAXman
Re: The Aural Moon "FLAG PROJECT"

Quote:
Originally Posted by mariocc View Post
I want to do the same..is it possible to send a xls file or doc file ..copy/p ?
DO ME NO FAVORS! Keep anything Micro$oft out of my sight.

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.         
Reply With Quote
  #25  
Old 02-24-2011, 02:41 PM
mailotron mailotron is offline
Registered User
 
Join Date: Dec 2004
Posts: 1,291
Smile Re: The Aural Moon "FLAG PROJECT"

Quote:
Originally Posted by VAXman View Post
Yes. OR... let me know and I'll give you an ftp login to upload your effort.
ok and thx vax
Reply With Quote
  #26  
Old 02-24-2011, 04:52 PM
dnsrees's Avatar
dnsrees dnsrees is offline
SparkDogg
 
Join Date: Jun 2010
Location: Sarasota, Florida
Posts: 40
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.
Reply With Quote
  #27  
Old 03-10-2011, 03:43 PM
Yesspaz's Avatar
Yesspaz Yesspaz is offline
Moderator
 
Join Date: May 2001
Location: Brandon, MS
Posts: 3,134
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.
Reply With Quote
  #28  
Old 07-17-2011, 09:30 AM
Yesspaz's Avatar
Yesspaz Yesspaz is offline
Moderator
 
Join Date: May 2001
Location: Brandon, MS
Posts: 3,134
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!
Reply With Quote
  #29  
Old 07-22-2011, 08:34 AM
Yesspaz's Avatar
Yesspaz Yesspaz is offline
Moderator
 
Join Date: May 2001
Location: Brandon, MS
Posts: 3,134
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!
Reply With Quote
  #30  
Old 07-24-2011, 11:10 PM
emperorken's Avatar
emperorken emperorken is offline
Patron
 
Join Date: Jun 2007
Location: South Bend, Indiana
Posts: 338
Re: The Aural Moon "FLAG PROJECT"

bump
Reply With Quote
  #31  
Old 07-25-2011, 08:28 AM
emperorken's Avatar
emperorken emperorken is offline
Patron
 
Join Date: Jun 2007
Location: South Bend, Indiana
Posts: 338
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;
Reply With Quote
  #32  
Old 07-25-2011, 08:40 AM
emperorken's Avatar
emperorken emperorken is offline
Patron
 
Join Date: Jun 2007
Location: South Bend, Indiana
Posts: 338
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.
Reply With Quote
  #33  
Old 07-31-2011, 02:52 PM
Yesspaz's Avatar
Yesspaz Yesspaz is offline
Moderator
 
Join Date: May 2001
Location: Brandon, MS
Posts: 3,134
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!
Reply With Quote
  #34  
Old 10-27-2013, 10:36 PM
gr8sho92's Avatar
gr8sho92 gr8sho92 is offline
Patron
 
Join Date: Jan 2007
Location: Wellington, FL
Posts: 328
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
Reply With Quote
  #35  
Old 10-30-2013, 05:18 PM
Yesspaz's Avatar
Yesspaz Yesspaz is offline
Moderator
 
Join Date: May 2001
Location: Brandon, MS
Posts: 3,134
Re: The Aural Moon "FLAG PROJECT"

Quote:
Originally Posted by gr8sho92 View Post
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?
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!
Reply With Quote
  #36  
Old 10-31-2013, 08:21 PM
gr8sho92's Avatar
gr8sho92 gr8sho92 is offline
Patron
 
Join Date: Jan 2007
Location: Wellington, FL
Posts: 328
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
Reply With Quote
  #37  
Old 11-01-2013, 08:27 PM
Yesspaz's Avatar
Yesspaz Yesspaz is offline
Moderator
 
Join Date: May 2001
Location: Brandon, MS
Posts: 3,134
Re: The Aural Moon "FLAG PROJECT"

Quote:
Originally Posted by gr8sho92 View Post
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.
Except for how often those databases are inaccurate. I've seen correct country flags changed to incorrect because someone "added" the value in this list by going through it alphabetically, doing them all.

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!
Reply With Quote
Reply


Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump



All times are GMT -5. The time now is 09:42 AM.