Google spreadsheet row to columns example

 

This:

ToThis:

Run a script to go from the first spreadsheet to the format of the second see link. The code is a hard to find as it’s embedded a few layers into the document.

See https://developers.google.com/apps-script/guides/sheets#writing for information on how to setup and run this apps script, as it’s bit convoluted.

Download the spreadsheet here.

//takes row data and adds converts to column data

// for every band separate write the names in a new spreadsheet in the following format
// first name , last name, band name
// based off of https://developers.google.com/apps-script/guides/sheets#writing

//Paul Sobczak
//themountainfold.com
//tcmaker.org
//May 2013

function RunMe() {
//name of new spreadsheet
var second_sheet_name = ‘second sheet’;

//get the active spreadsheet
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];

// Get the range of cells that store data data.
var employeeDataRange = ss.getRangeByName(“EmployeeData”);

// For every row of employee data, generate an employee object.
var employeeObjects = getRowsData(sheet, employeeDataRange);
var j =0;
var a =0;
var m = 0;
var k = 0;
var index = 0;

//add keys to new spread sheet
var other = SpreadsheetApp.openById(SpreadsheetApp.getActiveSpreadsheet().getId());
other.getSheetByName(second_sheet_name).getRange(1, 1).setValue(‘First Name’);
other.getSheetByName(second_sheet_name).getRange(1, 2).setValue(‘Last Name’);
other.getSheetByName(second_sheet_name).getRange(1, 3).setValue(‘Band Name’);

// split the comma seperated names into a new array
var band = employeeObjects[a];
var seperatedNamesBand = band.names.split(‘,’);

//for every band seperate write the names in a new spreadshet in the following format
// first name , last name, band name

while(employeeObjects[m] != null)
{
var band = employeeObjects[m];
var seperatedNamesBand = band.names.split(‘, ‘);
k = 0;
while(seperatedNamesBand[k] != null)
{
var seperatedName = seperatedNamesBand[k].split(‘ ‘);
other.getSheetByName(second_sheet_name).getRange(2+k+index, 1).setValue(seperatedName[0]);
other.getSheetByName(second_sheet_name).getRange(2+k+index, 2).setValue(seperatedName[1]);
other.getSheetByName(second_sheet_name).getRange(2+k+index, 3).setValue(band.bandName);
//other.getSheetByName(second_sheet_name).getRange(2+k+index, 4).setValue(m);
//other.getSheetByName(second_sheet_name).getRange(2+k+index, 5).setValue(k);
//other.getSheetByName(second_sheet_name).getRange(2+k+index, 6).setValue(index);
k++;
}
index= index +k;
m++;
}

}

// getRowsData iterates row by row in the input range and returns an array of objects.
// Each object contains all the data for a given row, indexed by its normalized column name.
// Arguments:
//   – sheet: the sheet object that contains the data to be processed
//   – range: the exact range of cells where the data is stored
//   – columnHeadersRowIndex: specifies the row number where the column names are stored.
//       This argument is optional and it defaults to the row immediately above range;
// Returns an Array of objects.
function getRowsData(sheet, range, columnHeadersRowIndex) {
columnHeadersRowIndex = columnHeadersRowIndex || range.getRowIndex() – 1;
var numColumns = range.getLastColumn() – range.getColumn() + 1;
var headersRange = sheet.getRange(columnHeadersRowIndex, range.getColumn(), 1, numColumns);
var headers = headersRange.getValues()[0];
return getObjects(range.getValues(), normalizeHeaders(headers));
}

// For every row of data in data, generates an object that contains the data. Names of
// object fields are defined in keys.
// Arguments:
//   – data: JavaScript 2d array
//   – keys: Array of Strings that define the property names for the objects to create
function getObjects(data, keys) {
var objects = [];
for (var i = 0; i < data.length; ++i) {
var object = {};
var hasData = false;
for (var j = 0; j < data[i].length; ++j) {
var cellData = data[i][j];
if (isCellEmpty(cellData)) {
continue;
}
object[keys[j]] = cellData;
hasData = true;
}
if (hasData) {
objects.push(object);
}
}
return objects;
}

// Returns an Array of normalized Strings.
// Arguments:
//   – headers: Array of Strings to normalize
function normalizeHeaders(headers) {
var keys = [];
for (var i = 0; i < headers.length; ++i) {
var key = normalizeHeader(headers[i]);
if (key.length > 0) {
keys.push(key);
}
}
return keys;
}

// Normalizes a string, by removing all alphanumeric characters and using mixed case
// to separate words. The output will always start with a lower case letter.
// This function is designed to produce JavaScript object property names.
// Arguments:
//   – header: string to normalize
// Examples:
//   “First Name” -> “firstName”
//   “Market Cap (millions) -> “marketCapMillions
//   “1 number at the beginning is ignored” -> “numberAtTheBeginningIsIgnored”
function normalizeHeader(header) {
var key = “”;
var upperCase = false;
for (var i = 0; i < header.length; ++i) {
var letter = header[i];
if (letter == ” ” && key.length > 0) {
upperCase = true;
continue;
}
if (!isAlnum(letter)) {
continue;
}
if (key.length == 0 && isDigit(letter)) {
continue; // first character must be a letter
}
if (upperCase) {
upperCase = false;
key += letter.toUpperCase();
} else {
key += letter.toLowerCase();
}
}
return key;
}

// Returns true if the cell where cellData was read from is empty.
// Arguments:
//   – cellData: string
function isCellEmpty(cellData) {
return typeof(cellData) == “string” && cellData == “”;
}

// Returns true if the character char is alphabetical, false otherwise.
function isAlnum(char) {
return char >= ‘A’ && char <= ‘Z’ ||
char >= ‘a’ && char <= ‘z’ ||
isDigit(char);
}

// Returns true if the character char is a digit, false otherwise.
function isDigit(char) {
return char >= ‘0’ && char <= ‘9’;
}

Teaching Arduino, Soldering, and Source Code

I have been teaching classes on Arduino around the Minneapolis at Twin Cities Maker and at the Mill. There are two coming up in March and April 2012 at the Hack Factory, check the respective websites for more information.

I have also been teaching some soldering classes, more to come in the future, check Twin Cities Maker for upcoming events. Here is a picture of a student holding a genuine Wayne and Layne blinky POV from a class I taught with Adam.

I have been on a pro account on Flickr for 1 year now and have poster over 2,000 images. Most of are Twin Cities Maker. My profile is here.

Finally I updated some of the repositories that I have been working on source code wise, over at the Source Code Page, or on my bitbucket page.

KiCad not loading Libriaries

I tried installing Kicad on Mac and it was not playing nicely, so I switched to Windows and had no problems. So I thought it was a mac thing but later I tried installing on Ubuntu and I got the same errors from the start. KiCad is not loading Libraries.
This was by far the most frustrating part about KiCad, I which that the dependent libraries were included in the build, that would only make sense. Anyways I was lucky enough to have the libraries from the Windows distro that I also installed, as they are a part of the exe.

I uploaded the component libriares into /share/kicad/template where KiCad is already, on my mac and it works.

I have since switched over to Ubuntu for development, and used a tuturial that Wayne and Layne made that also has a solution to download the libraries Wayne and Layne’s blog, and their solution. (outlined below)

bzr checkout lp:~kicad-lib-committers/kicad/library kicad-library.bzr
cd kicad-library.bzr/
mkdir build
cd build/
cmake ../
sudo make install

Depending on if you built KiCad or not and where you did so this should work. If you have problems search through Wayne and Layne’s post and build it the way that they are and it will work. Most likely there is a way to do something similar on the mac but I don’t know.

Observations in Asia


South Korea
Soju and the studious/relaxed characters on the bottle
Common places are not heated, feels like Russia
Kim Chi everything (awesome)
kam-sa-ham-ni-da
Sleeping Ondol Style
Currents of stench in Daejeon
Pagodas
Temples atop hills
Beds that are no softer than the ground
Hotel Feel, a typical Love Motel
Escape Rope
Christmas dinner sannakji
Wood flavored tea
Car turn tables
Animal hats
Mirrors
Urinal toys
“Intangible Cnltural Haritage Training Center”
Sweet Potato Cream Sand
Caged golfing
Jjimjilbang
Classic Modern Minimal Oriental Natural Style..
Open Wifi at a Buddhist temple
Overhead gas pumps
Korean barbecue
Mokpo
Dvd bang
PC bang
Gaejangguk
Yoboseyo
Can I have a card(ah)?
My favorite phone booth yet
Delicious sliced rice cakes
Stacked rocks


Japan
Udon
Cuttlefishes legs and Kimchee (you feel like in Korea)
Headphones tons of headphones
Midget II; the car that was so popular in the 60’s
Elephants
Yom Yom
Big Chopsticks for men
Sushi go-round
Wrapped trees
Capsule Hotel
Electrified Spa
Vending machine restaurants
Vending machine fried chicken
Raw horse
Studio Ghibli
Pancake Soda
Red Bean Coughnut
Literate bums reading newspapers on the street
Heated seats
The toilets
Karaoke
Black Wonda
Sugoi!!

Guatemalan/Honduran Observations

2011 Winter Electronics Purchase


I just put in, what has been becoming an annual occurrence,  a winter electronics binge. This years order from Sparkfun:

1 – DSO Nano V2 – Pocket-Sized Digital Oscilloscope
1 – Getting Started with Arduino
1 – Break Away Headers – Straight
1  – Break Away Female Headers
1 – Breakout Board for AD5330 Parallel 8-Bit DAC
1 – Breakout Board for MCP4725 I2C DAC
1  – Solder – 1/4lb Spool (0.032″) Special Blend
1 – Soldering Station Variable Temperature 70W – Digital
1 – Third Hand
1 – Barrel Jack Adapter – USB to 5.5mm
1  – Tweezers – Heavy Duty

Two big items in there the DSO Nano and an actual solder station, that is going to be nice, no more laying the old Radio shack iron on the ground. I have been building some electronics I have another WSG in the works and a pretty big project with my friend Matt of Citizen Analog, more on that as it comes to light.

I found 2009’s order, looking back I should have ordered another 2 or 3 micro usb cords, I haven’t had the best of  luck with them keeping them around so far, but I seem to have at least 10 mini usb cords now.

2009’s order:

USB microB Cable – 2.5 Foot x1
Audio Cable 3.5mm to RCA – 6ft x3
Audio Splitter 3.5mm – 6in x3
Electrolytic Decoupling Capacitors – 100uF/25V x1
SPDT Mini Power Switch x1
Voltage Regulator – 5V x1
Electrolytic Decoupling Capacitors – 10uF/25V x1
Basic LED – Yellow x2
Resettable Fuse PTC x1
Resistor 330 Ohm 1/6th Watt PTH x2
Diode Rectifier – 1A 50V x1
Rotary Encoder x3
Arduino Main Board x1
Basic Breadboard x1
DC Barrel Power Jack/Connector x1
Hook-up Wire – Black x1
Hook-up Wire – Red x1
Jumper Wires Premium 6″ Mixed Pack of 100 x1
Precision Phillips Set x1
Wall Adapter Power Supply – 9VDC 650mA x1
Car Adapter USB Power Supply – 5VDC 650mA x1
Digital Multimeter – Auto-Ranging x1
Wire Strippers 30AWG x1
Brass Sponge x1

Top 10+ 2010

This image is © Wellcome Images, but has been altered into a Derivative Work by Paul Sobczak by cropping.

The Tallest Man on Earth – The Wild Hunt
Crooked Still – Some Strange Country
Shpongle – Ineffable Mysteries from Shpongleland (2009)
Samamadon – I See The Sign
K’naan – Troubadour
Mumford and Sons – Sigh No More
Stars – The Five Ghosts
Zee Avi – Zee Avi (2009)
Michael Franit & Spearhead – The Sound of Sunshine
Horse Feathers – Thistled Spring
The Books – The Way Out
Laura Veirs – July Flame
Langhorn Slim – Be Set Free (2009)
Neko Case – Middle Cyclone (2009)
Ben Harper – Welcome to The Cruel World (1994)
Bob Dylan – Bob Dylan (1962)
Dave Seaman – Global Underground 012: Bueno Aires (1999)

Edward Sharpe and The Magnetic Zeros – Up From Below (2009)

Con ts; a poem and an alternative manifistation.

Cold left Cold
Sharps and rocks
Jen
laughing
and all with others
subtractive music
a massive extinction
brean malleable
worst pollen that I have ever tastes.
best bridge that I have ever slept on.
reddest room that I have ever seen
Kitchen ware storage
Is that it then I that how
I that how
Is that how
Is that It
then
Is that how
Rocky
The earth is made of rock
take and make
ride
ants
slim Jim.

Top 10 2009

This image is © Wellcome Images, but has been altered into a Derivative Work by Paul Sobczak by cropping, removing and adding content


1. Iron And Wine – Around The Well
2. Tallest Man on Earth – Shallow Grave (2008)
3. Bela Fleck – Throw Down Your Heart
4. Decemberists – Hazards of Love
5. Varius Artists – Dark Was the Night
6. William Elliot Whitmore – Animals in the Dark
7. Amy Milan – Masters of the Burial
8. Antony and the Johnsons – The Crying Light
9. The Pines – Tremolo
10. Ben Frost – By The Throat

Audio for Past Shows

tmf

I know the audio for the past shows is lagging; I have most of the files but I need to upload them. Before I do that I need to attack all of the audio that I have posted in the past the has fell victim to the weird right left pulsating audio effect. Most of all the older show pre-2008 are good. I was never able to figure out what was causing the issue in the recordings.

What I am doing to fix them is importing the stereo file and covering it to 2 channel mono, by grabbing one of the channels and copying it to the other. I know this does not totally alleviate the problem but sonically is sound a lot better and is virtually indistinguishable, from what it sound like when it was aired on the radio. The whole process takes a long time because I have to import the whole 100+Mb file into an audio program, then to the manupilation and save it all again, then upload, and link each one. So it will be awhile before I get around to it, but it is planned for the future.

February 20th 2010 Update: I have lost my hosting for all of the audio files, they were hosted at North Dakota State University, and in 2009 they decided to change their sever. I have made the decision to not to re-upload the files, I will maintain a physical archive, if you want one then ask me.

Top 10 2008

This image is © Wellcome Images, but has been altered into a Derivative Work by Paul Sobczak by cropping, removing and adding content

2008 Top 10+

1. Jim White – Transnormal Skiperoo
2. Bon Iver – For Emma, Forever Ago
3. Hanne Hukkelberg – Rykestraße 68
4. Roma di Luna – Casting the Bones
5. Jeffrey Lewis – 12 Crass Songs
6. My Brightest Diamond – A Thousands Sharks Teeth
7. Matt Bauer – The Island Moved in The Storm
8. Herman Dune – I Wish That I Could See You Soon Ep
9. Bowerbirds – Human Hands
10.Why? – Alopecia

the almosts:
Astronautalis – Pomegranate
Various – Anthology of Noise & Electronic Music, Vol. 5
Antony and the Johnsons – Another World EP
Ane Brun – Changing of the Seasons
Man Man – Rabbit Habbits
Various – Art of Field Recording, Vol. 2 * would most likely be on the list but I have not purchase it yet.

Hobo Convention Mini-Documentary

[kml_flashembed movie="http://www.youtube.com/v/XvphjCd0CeY" width="425" height="350" wmode="transparent" /]

There it is, Britt Hobo Days as documented by Bill Geist of CBS news.

I was there and I was just as awesome as this video leads it to be. I am in a few of the frames but none really to speak of as you can’t really see my face in any.

Check my earlier post of for more info.

L.I.V.E @ The Plains in Fargo

L.I.V.E

L.I.V.E at the Plains Sep 11/12 2008

I will have my Down The Line piece exhibited at the Plains Art Museum in Fargo on 9/12/08. Come check out the other events as well.

Sep 11th

L.I.V.E. Lecture:
Henry Gwiazda, renowned local new media artist, musician, and professor of music, presents a snapshot of art being created around the world by artists using technology as their medium and often as their tool for exhibiting their work. Free

Sep 12th

Circuit bending with Beatrix* Jar:
Circuit bending gives recycled toys a new life as unique new musical instruments. A direct result of experimentation and play, circuit bending requires very little technical know-how to get started, giving everyone the opportunity to experience making electronic music, young or old. 22 dollars BYOT (Bring Your Own Toy (to bend))

Music from the following artists:
BEATRIX* JAR (Minneapolis, MN)
THE PUSH (Minneapolis, MN)
KENDALL STATION (Minneapolis, MN)
TURBODAZE (Sioux Falls, SD)
LAVA-PROOF BOOTS (Fargo, ND)

Mixed Media Artists:
HENRY GWIAZDA
BRENT BRANIFF
PAUL SOBCZAK (that’s me!)
NATE BOOTH
free.

Pictures coming soon!

108th Annual HOBO days in Britt Iowa

HoboWhile living in Iowa this summer I was glad to stumble upon the great Hobo Days. The events was located in Britt, Iowa and the lasted form August 6 to 10th.

The Convention has been held since 1900, marking this the 108th year. Each night there was music at “The Jungle” where all of the HOBO’s stayed.

Below you will find some of the songs that were performed, alongside some pictures. For more information on the convention check the following links.

HOBO.com | HOBO days FAQ

Click on the plus sign to listen to the audio:

Boomer Bob and Mama Pipes – Let Me Ride Your Train

Jeff – Train Slowing

I deleted the songs lost server space… sorry.
(when I was trying to find the title of this song, google found this, click the audio button) ((looks like the song takes some inspiration from Psalm 122:1))

*note I am not sure about the titles and artist of these songs, the Rose Tattoo song only features two of the members fixed, is is boomer bob and his wife Mama Pipes, but I am not sure of the name of the song so I took some liberty in naming it. Jeff was what he was called onto stage with, and he did not title his song. Also “The Newly Weds” is not a band name I lost their name in the Hobo Jungle, but they did get married at the convention so that is how they are identified here. Fixed they are West Hill Jack and Cherokee.

Dancing round the Fire

Music

Music Music

Rose Tattoo

My Exigent Eyes

Over the course of one week my eye care got quite out of hand. I received corneal transplant surgery on my right eye and a new type of hard contact (scleral lens) in the left.Below you can see all of the drops and auxiliary equipment used to keep my eyes  together.

exigent eyes

Starting in the Front, Left to Right: contact case, tape for eye patch, different tape for eye patch, large eye plunger for scleral lens insertion, small suction cup in case for removal of scleral lens, eye patch worn at night to prevent sleep eye scratching,

Back Row, Left to Right: Soap, preservative free* saline, conditioning solution, cleaning solution, backup cleaning solution, synthetic tears, steroid, antibiotic, and finally protein solution.

Yea!

Fargo Zombie Pub Crawl 2008

Zombie Pub Crawl


The Fargo Zombie Pub Crawl is coming on May 10th!!

So grab your zombie costume or make one and come on out.

The initery is as follows

2:00 -3:00 Gathering in Island park (around the gazebo)
3:00 Duffy’s
4:00 Sports Bar
5:00 Rooters
6:00 Sidestreet
7:00 the Bismarck
8:00 the Empire
9:00 Dempsey’s
10:00 the Aquarium

Zombie Pub Crawl Concludes with:

Lucha Libre Label Release Party with
~Green Green Yellow Blue
~Manchester Buldge
~OKFox
~the Blue Fairy Godmothers
~Console Enemy
~Lava Proof Boots
~GhostHandPunch

21+ ID
Cost : ZOMBIES GET IN FREE!!
(everyone else $3)
show starts at 9:30 at the Aquarium

Check out ZombieFargo.com for more info and other stuff like a picture of George Bush sucking the brains out of a child.

SXSW 2008

Well its a little bit late but here is my mini-overview/walk through of what was awesome about SXSW 2008 in Austin, TX.

Day One: Wednesday

I went down there with KNDS 105.9 in Fargo, 5 others and myself all packed into a truck/van vehicle. We made it down in 24 hours, just enough time to see Jeffrey Lewis do his thing along side the Jitters.

Jeffrey Lewis and the Jitters SXSW ‘08

Jeffery Lewis and The Jitters.

Later that day I got to see some more bands…imagine that.

Bowerbirds SXSW ‘08

Bowerbirds

Some Noise Band

Some Noise Band

The Black Keys SXSW ‘08

The Black Keys

That finished off Wednesday, Jeffery Lewis was by far the highlight of the day, I got to see his History of Commuinism Part III, I have seen part I before. Oh and he also did Creeping Brain, I wish he would release that track on an album. Bowerbirds was pretty good, worth seeing, the noise band was ehhhh, and The Black Keys was not that good in my opinion expescially because I was standing in the crowd for about an hour before they stepped on stage.

Day Two: Thursday

Day two started off awesome as well. Imagine walking down a street looking for something to eat with your friends when you pass a venue and see a that Akron/Family is now just getting on stage…What??? I guess in all of the madness I didn’t get a good picture of them, sacrifices must be made. 🙂

Other stuff later that day:

Jim Noir @ SXSW 2008

Jim Noir @ the Current Show case (free ice cream!)

03132008468.jpg

Some headless fronted band

Shout Out Louds @ SXSW 2008

The Shout Out Louds (Sweden We Have a problem!)

Kimya @ SXSW 2008

A (great?) shot of Kimya playing at the Anit-War Showcase.

SXSW 2008

The Islands

Not the best shot but this is The Islands preforming “Where There’s a Will There’s a Whalebone” The track on their album features Busdriver doing a rap about half way through, and as you can see (perhaps not) Busdriver jumped out on the stage and unleashed his rhymes completely unannounced and then he left with out mention, it was mind blowing, that type of thing is not suppose to happen.

ohh and then The Islands got pissed that they didn’t get thier 40 minutes on stage so they got the OK to play 2 more songs, they finish the first one then launched into thier track “Swans” which is over 9 minutes long.. and then this happened.

[kml_flashembed movie="http://www.youtube.com/v/QoYrSrs4ctg" width="425" height="350" wmode="transparent" /]

And then…

The Octopus Project @ SXSW 2008

The Octopus Project

They were amazing!!! In the picture above one member is playing a Moog theremin… Yea, and that concludes day 2.

Day 3: Friday

Start another day off right with Man Man!

Man Man @ SXSW 08

These Guys were a little too crazy to start the day off with but it was great. Vimby.com was there doing video of the show, I am in a few shots wearing a bright neon green hat.

Video Here

The Watson Twins @ SXSW 08

The Watson Twins

Clare and the Reasons @ SXSW

Clare and the Reasons

Cryptacize @ SXSW 2008

My Brightest Diamond

This was one of the best shows, I think it was my favorite of all SXSW. I really love the music she makes and her performance was amazing, too bad the picture sucks. She has a new album coming out soon on Asthmatic Kitty, I think its will be phenomenal. Also I recorded the performance so you can look forward to that post in the future.

not sure

C-mon & Kypski

What these guys were beyond awesome. The Drummer/Turntablist was scratching and Drumming at the same time it was crazy .

[kml_flashembed movie="http://www.youtube.com/v/CWIMrILeGQo" width="425" height="350" wmode="transparent" /]

Then at the end of the night on 6th street around 2:30 am we stumbled upon this:

[kml_flashembed movie="http://www.youtube.com/v/ttjyiLW48wc" width="425" height="350" wmode="transparent" /]

Austin impromptu drum performance.

Day 4: Saturday

Day four started off with Team Clermont and Home Tapes Records, and It was another awesome start to a day.

Home Tapes

Pattern is Movement

Slafferland SXSW 2008

Slaraffenland

These guys were great, the drummer also provided his voice for the Danish version of my “I can Eat Glass” project, that I will post in the near future.

Bear in Heaven SXSW 2008

Bear in Heaven

I love these guys, (their Album more than their live show).

Megafaun @ SXSW 2008

Megafaun

ll

Tristan Perich

This guy is cool stuff, he is a part of Loud Objects and he also does this thing called One Bit Music where he programs an Atmel microchip and wires it up with a battery and a headphone jack and throws it in a CD case.

This is what it looks like:

www.onebitmusic.com

It’s a pretty cool Idea, there are still some available, I think he made around 100 or so, not sure. And I also think after listening to the “Disc?” there is a cover of a Fischerspooner track on there. Can anybody confirm that?

Furthermore during this performance he put up an old 8 bit game that my friend Mat got to play, video Below:

[kml_flashembed movie="http://www.youtube.com/v/ARlPQmIyz6o" width="425" height="350" wmode="transparent" /]

Hanne @ SXSW

Hanne Huckleberg

I love her, her music is too good! I got a chance to pick up her latest album at the show as well, and yea it’s amazing. Oh and She is from Jar, Norway (Where ever Jar is?)

Jason Collete

Jason Collett

Bound Stems @ SXSW

Bound Stems

I got to see the wonderful Hannah from Spectre Promotions at this show. I love that girl!

And the final show Gil Mantera’s Party Dream, featuring Snook Legs!

Gil at SXSW two thousand and eight

Gil Mantera’s Party Dream

Ohh we finished up the night with several impromptu preferences by Soft Snook who is Robert Rameriez Jr., Trash Pants The Charlie, and Raisin The Rocks here is one short video shot on the street of Autsin. Yea!!!!

[kml_flashembed movie="http://www.youtube.com/v/F-7-kg7c8Mk" width="425" height="350" wmode="transparent" /]

Soft Snook 16 seconds of greatness!

Konsonans Retro: Klezmer Music Live in Helsinki December 2007

Konsonans Retro: Klezmer Music Live in Helsinki December 2007

To everybody who attended on of the free shows in downtown Helsinki, and for everybody that did not, this is for you. You now can experience The Konsonas Retro in all of their Helsinki free show glory.

You can purchase the Kosonas Retro Cd here.

From their CD Baby Site:
Konsonans Retro are a pretty old wedding brass band from Odessa region, Ukraine, and possibly the coolest and freshest new world music act to come out of Eastern Europe. For generations – and through countless hot nights – the Baranovsky family and their in-laws have been passionately playing the wild and sweet wedding music of Podolia, a powerful and soul-stirring blend of Moldavian, Ukrainian and unique Jewish tunes. And they sing – everywhere they are. That you have to hear for yourself…

Somewhere in 2005, the band met Berlin-based master clarinetist Christian Dawid (some think it was in Vienna). Soon plans were made – since then, the new Konsonans Retro have been performing for thousands of listeners at the Krakow Festival of Jewish Culture, at Vienna’s excellent Klezmore festival and have been touring through Germany, Switzerland and Ukraine.

Konsonans Retro have received enthusiastic response from audiences and fellow musicians alike. Illustrous artists like Steve Bernstein (Sex Mob), SoCalled, Lorin Sklamberg (The Klezmatics) or DJ Gurzhy (Russendisko) are raving about the band. Cosmopolitan cult singer Alec Kopyt (Poza, Amsterdam Klezmer Band) even called them ‘the best klezmer band in the world’. Not necessarily thinking of themselves as a klezmer band, they certainly party on every stage they play. Davai!

I have a few mp3’s of the show and three videos that I have combined into one longer one. Enjoy and feel free to comment. The files are below, click the + button to play the media in your web browser.

[kml_flashembed movie="http://www.youtube.com/v/c2DeOYo3pMM" width="425" height="350" wmode="transparent" /]

Download Audio 1

Download Audio 2

There are 5 more videos of the show that I found on YouTube, you can find them here.

The National Live in Oslo (12/2/07)

Picture by Flickr user mucow altered by Paul Sobczak

The National Live in Oslo (12/2/07)

Sorry I don’t have this one split up into tracks like the other ones, mainly because I am not that familiar with their catalog. If you have or know the track listing feel free to send it to me in chronological order and I will break it up for you.

Download The National Live in Oslo (12/2/07)