text:
The first turbo E90/E92 M3 build that we know of is underway. There are currently several supercharger kits for the M3′s S65 motor available on the market, but no turbo kits, yet. The S65 makes it difficult to place a turbocharger kit's plumbing, and some tuners are also wary of turbocharging the S65 due to its aluminum construction.
But, South African tuning shop SAVSPEED has taken up the cause and its S65 turbo build is currently in the works. They've decided on a single … CONTINUED
Germany based Prior Design has released its F10 5 Series aerodynamic kit. The entire F10 kit includes:
Package includes:
– Prior-Design PD front add-on spoiler (fits all bmw 5-Series F10 standard models except M5 and models with original M-Sport Package installed)
– Prior-Design PD side skirts (fits all bmw 5-Series F10 models)
– Prior-Design PD rear add-on spoiler (diffusor) (fits all bmw 5-Series F10 standard models except M5)
– Mounting material… CONTINUED
Paul Walker (of the Fast and Furious movies) is an avid and serious auto enthusiast. His track weapon of choice is an E92 M3 coupe, supercharged by AE Performance and Gintani. After 2 successful years of this car being tracked and pushed to its limit (while breaking records), this M3 will be getting a power upgrade.
Gintani was contacted by the AE performance team and have now started on a Stage 3 build for Paul Walker's M3. The Stage 3 build will be documented … CONTINUED
Manhart has revealed their latest creation – the MH3 V8 RS Biturbo Clubsport E92 M3, which features some pretty radical performance and cosmetic upgrades.
In fact, Manhart has done away with the M3′s factory S65 engine altogether and drops in the 4.4L biturbo V8 engine (S63) from the X6M / X5M! Power was then bumped up from the factory 555hp to a whopping 750hp and 671lb-ft torque! To achieve this impressive gain in power, the S63 turbos were modified, air intake replaced, and pistons/rods reinforced. The car's … CONTINUED
Owners of the E82 1 series who want the aggressive looks of the BMW 1M coupe now have a full aero kit package option.
Prior design has released its 1 Series PDM1 Widebody Kit, a full bodykit which gives a standard 1-series the look of the BMW 1M coupe.
The PDM1 package includes:
Prior-Design PDM1-WB front bumper (fits all bmw 1-Series E82 models except 1M)
Prior-Design PDM1-WB side skirts (2X) (fits all bmw 1-Series E82 models except 1M)
This is a most impressive E28 528i to custom E28 M5 CSL build powered by an S38B38 Evolution engine. Full specs:
Body: BMW E28 w/o sunroof, rebuilt to coupé, extended FIA safety rollcage, raceweight aprox ~1100kg with driver. Vented body – 200mm (8″) wider in rear, 160mm (6.3″) wider in front.
Engine: BMW S38B38 (6-cyl 3.8l-24v 365hk/8000rpm)
Gearbox: Getrag 260, shortshifted 5-speed.
Final drive: BMW M3 Group A limited slip, 4 different gear ratios available.
Front brakes: 6-piston aluminum calipers, 330mm (13″) rotors.
Rear brakes: 4-piston aluminum calipers, 303mm (12″) rotors.
Wheels … CONTINUED
The VAC Motorsports E92 M3 with VF Engineering VF620 Supercharger has set the quarter mile bar for all E90/E92 M3s around the world. Running at Atco this past weekend, their supercharged E92 M3 coupe put down a mind blowing 10.690 second run @ 129.38 mph!!
The specs of the car are as follows:
VF Engineering VF620 Supercharger Kit
VAC by Fabspeed catless exhaust
APEX 18×10 ARC-8 rear wheels
Mickey Thompson ET Streets (DOT Approved – street legal!)
AR Design Line Lock
No other mod… CONTINUED
BMW Car Magazine undertakes a fraternal twins rivalry comparison in pitting HP Autowerks' BMW 1M coupe against its tuned 135i coupe.
The tuned 135i coupe is equipped with DCT transmission and tuned to be 400+ HP / 420 lb-ft torque with piggyback tune, intake tubing, M3 suspension arms/bushings, coilovers, and exhaust system.
So do all these upgrades to the tuned 135i make it 'better' than the factory 1M coupe? Read on inside to see how they compare.
VAC Motorsports brings us some sights from the 2011 Professional Motorsport World Show held in Cologne Germany. Lots of high performance parts on display – from professional racing (all the way up to F1) to tuning solutions for the casual racer and tuners like many of our members.
The BMW F10 M5 has joined the stable of G-Power, a BMW tuner which has turned out some of the most potent BMWs in recent years. And they now have their energies directed a BMW M's newest flagship sedan. They've teased their upcoming G-Power F10 M5 with:
It is here: The all new BMW M5 F10 has already arrived at G-POWER
History is repeating itself. Just like with the BMW M3 GTS one can observe that the first drive of the new BMW M5 F10 leads it directly … CONTINUED
Four members of M3POST were gathered recently for an epic photo and video session. The session was particularly unique because of the cars involved. No less than four white M3s were in attendance, each featuring BBS LM wheels and three with ESS superchargers. The result was some spectacular photos and a heart thumping video.
Check out the photos and video inside.
For those of us who take the M3 to the track, I think it would be fair to say that a part of us always wishes that the M3 could just be a little faster, a little lighter, and a little more like a race car.
Unfortunately, it's not as simple as putting racing parts on our street cars — most of us don't rebuild our brake calipers every year, drive on roads without potholes, or have neighbors who can tolerate the unmuffled music from our S65 … CONTINUED


text:
What's the Most Delicious Thanksgiving Side Dish? [POLL]
Thanksgiving is creeping up on us quicker than the time it takes to finish your first helping and delve into seconds.
Thanksgiving is creeping up on us quicker than the time it takes to finish your first helping and delve into seconds.
When a fan asked Demi Lovato about the status of her relationship with Miley Cyrus, the 'Really Don't Care' singer cautiously responded.
Congratulations are in order for Justin Bieber, One Direction and Taylor Swift -- they're the three highest-earning artists under 30, according to Forbes.
Keep these five tips in mind in order to get the best coverage without overpaying.
"Sleeping on the job" is a phrase that is not positive. It's often preceded by "He was fired for" and can make you the butt of jokes for years to come. But maybe it shouldn't be such a bad thing.
Hooking up with a delivery nurse should be the furthest thing on a new dad's mind while in the delivery room with his wife who's about to give birth to his child, but that's exactly what this new dad was thinking and wanting to do!
The New York Giants may be immersed in a lost season, but there's a glimmer of hope in electric wide receiver Odell Beckham Jr. The rookie from LSU made a you-have-to-see-it-to-believe-it catch for a touchdown during the G-Men's 31-28 loss to the Dallas Cowboys on Sunday night that some are saying is the best grab ever.
Guess these guys will think twice about where they decide to deal drugs...
Taylor Swift was the first-time recipient of a brand new award at the 2014 American Music Awards tonight (Nov. 23) and her speech was totally killer.
The 2014 American Music Awards are finally here -- check out the full list of winners!
From Sam Smith's perfectly tailored suit to Charli XCX's super vampy black gown, we've got the fashion from the 2014 American Music Awards!
Nintendo's $19.99 Wii U peripheral for Super Smash Bros. has become extremely hard to find and (you guessed it) people online are trying to take advantage.

subset: commoncrawl


text:
Author: jess sconé
Attention Austin: Vida Vegan Meetup this Thursday at The Liberty!
Hello, hello! Team Vida Vegan HQ returned from Vegas less than two weeks ago, and as usual, we've been hard at work, seriously inspired and sketching out the next three years on our calendar (er, smartphones and Google docs). There is so much in store! It's no secret that we're looking at a few very special cities for the much-anticipated Vida Vegan Con III, and that's in addition to our other events. Read up on this post from way back when, aka last summer, for a reminder on just what those may be: Team Vida Vegan's Always Cooking Something Up!
It's also no secret that we adored our first location scouting trip to Austin last February, and with the local vegan community and dining scene growing to epic proportions, including the Capital City storefront, Mr. Natural's brand-new new vegan brunch, and the new Wheatsville location, we're coming back in mere days!
Location: The Liberty & Eastside King 1618 1/2 E. 6th St
Date: Thursday, February 6, 2014
Time: 5:00pm-7:00pm
Janessa, Michele and myself will all be there — coats, potential scarves and requisite sunglasses in tow — to hear your ideas for Vida Vegan Con III. We'd also like to know just what else you'd like to see and attend, and frankly, where we should get all those dang vegan tacos. All are welcome!
We do have a ton of appointments at event venues booked around the Austin area already, and are totally open to more suggestions. Please contact us with any tips!
And if you'd like to see more about our Vegas location scouting, check out the hashtag #VidaScoutsVegas. We'll have a post up detailing the experience and a few of our favorite locations and meals up soon enough, have no doubt.
Vegan Drinks next week in Las Vegas at Bar & Bistro!
This sums it up nicely:
Will you be in the Vegas area on January 16th?
Get ready: Janessa, Michele and myself, your friendly Vida Vegan organizers, will be doing some location scouting and vegan eating this winter across the US, and coming to a city* near you!
First up, we're hitting Las Vegas, NV and wherever we go, we want to get to know the local vegan community. It's what our growing series of events are all about, and for. If you'd like to talk about being vegan in Vegas, the internet, how to throw your own vegan events and festivals, where you'd like to see upcoming Vida Vegan events, or even where to get the best vegan tacos in town, come meet us for a 'Vegan Drinks'-style Meetup on Thursday, January 16 at Bar & Bistro.
Vegan Drinks is a social, networking event held in various cities, and while Las Vegas' is temporarily on hold, we wanted to host a "pop-up" Vegan Drinks evening, if you will, while we're in town.
Here's the official Meetup event (though please feel free to come if you don't have an account) and more details:Location: Bar & Bistro 107 East Charleston Boulevard #155, Las Vegas, NV Date: Thursday, January 16, 2014 Time: 5:00pm-7:00pm in the lounge area
Bring an appetite, some cash (this is not a hosted event), maybe some business cards of at least your Twitter and Instagram handles, check out the Vegan Menu and we'll see you there!
*Okay, two cities within North America, so far. Many, many more to come. We're open to suggestions!
Holiday Blogging Ideas!
It's that special time of year, where it seems like every other blog popping up on your reader is showing off the latest holiday gift guide. If not that, it's talking about what cookies they love to make this holiday season, links of tried-and-true recipes in tow. These are both great ideas for seasonal blog posts, but there's plenty more to talk about, and to make your own.
Here at Vida Vegan Headquarters, we've put together a list of 15 holiday-themed blogging suggestions to inspire you to inspire others, this winter:
15 Ideas to Get You Blogging This Holiday Season
- Veganize family favorites and share the recipe and the memories.
- Homemade gifts ideas. That's right, go get fabulously lost on the DIY Xmas Gifts-land that is Pinterest this morning.
- Holiday meal planning: the classics and the brave new dishes.
- Kindness. Spread the cheer & pay it forward.
- DIY decorating: Hello, Snowman fridge.
- Winter picnics with chocolate chip cookies and mugs of mulled cider or peppermint candy cane vodka-infused hot cocoa.
- Speaking of mugs…… 'Tis the season for warm drinks.Winter picnics with chocolate chip cookies and mugs of mulled cider or peppermint candy cane vodka-infused hot cocoa.
- A new round-up of the best soups in town.
- Tips on throwing a themed holiday party…Festivus, anyone?
- Wool-less winter looks.
- Sharing New Year's resolutions that will seriously help the world: organize a sanctuary work party; join in the Worldwide Vegan Bake Sale; vow to compost, etc.
- Vegan nog-off (or hot chocolate-off) It's a tough job, but…
- Eco-wrapping. One more intense round of Pinterest to explore.
- Talk about your favorite nonprofits (Holiday season is also tax write-off season — find out who's got fund-matching!)
- Life lessons: share your vegan-through-the-family-holidays survival guide.
Or….Screw the seasons! Keep doing what you do!
Got something great in the works? Instagram it in-progress, giving a nice behind-the-scenes, authentic look at what you've got in store. If you've been posting about the holidays, we'd love to read about it. Leave a comment with a link and share your plans in the comments!
Vegan Thanksgiving at Vida Vegan Headquarters: Feast Ideas & Portland Dining Options
Like every other friend we talk to lately, we've got homemade holidays on the collective brain at Vida Vegan Headquarters, and brainstorming and recipe testing for our upcoming Holiday Hors D'oeuvres & How-Tos! (aka our holiday entertaining class & cocktail shindig) is only making it that much more difficult to contemplate meals without grated nutmeg and cranberry.
Here are some last-minute, vegan Thanksgiving recipes and ideas catching your friendly organizers' eyes, and some from our own archives and memories, for the fast-approaching Thanksgiving….Thanksliving…..Thanksgivukkah…..Thursday eats, whatever you'd like to call it.
Janessa's favorite picks:
Chive Mashed Potatoes I've made this recipe from Tal Ronnen the past three years. The secret is the cashew cream that adds an unbelievably rich creaminess.
Green Bean Casserole This recipe from Susan at the excellent Fat Free Vegan blog is an excellent base for that Thanksgiving classic. I usually fatten it up by adding those awful & delicious canned fried onions and cooking with lots of wine.
Artisan Bread Grant Butler recently posted this recipe on Oregon Live. It's so easy and turns out the most delicious golden loaves of bread I've seen.
Parsnip Ribbons Vegetarian Times published this recipe in its November issue. They're simple, tasty, and add an elegant touch to your mashed potatoes. I omitted the paprika and added dried sage for an even more Thanksgiving-y flavor.
Lava Lamp The Lava Lamp is my favorite seasonal bubbly drink.
1 bottle sparkling wine
1-2 pomegranates' worth of seeds
12 oz pomegranate juice
Pour bubbles into a tall champagne flute. Add half dozen to a dozen pomegranate seeds, and top with a splash of pomegranate juice. The seeds bounce up and down in the bubbles, creating a Lava Lamp-esque effect.*Makes 4-6 Lava Lamps.
Jess' tried-and-true picks:
Bryanna Clark Grogan's definitive vegan pumpkin pie
For a twist, I made a last minute, straw-decorated, Thai Iced Tea version a couple of T-days ago that I just fell in love with (which can happen with pie, of course).
- Pumpkin Cheddar Biscuits, Vegan Crunk via Panda with Cookie
My mom's Sweet Potato Pie Casserole via New York Newsday. My late mother had a clipping of this recipe from the newspaper, and the aroma of it coming out of the oven is my oldest and fondest culinary memory. Besides the mashed potatoes, it was the one dish at holiday gatherings I can actually remember eating, and looking forward to, year after year. (Coincidentally, I have bourbon infusing for this very flavor right now).
Chickpea Cutlets, The PPK. New classics. It's no gravy, but I sure like these with a smokey BBQ sauce.
- Cranberry Kir Royale, The Chew…because yes, I often watch The Chew, happened to soak fresh cranberries in cherry brandy and ginger the other day, and really, really want to make these this holiday season (or tomorrow).
Savoury Turkey Seitan Roast from Brian P. McCarthy via Everyday Dish. A few years ago, I slept through most of a Thanksgiving feast and having missed out, decided to make this baked seitan first thing the next day, and it was a brilliant, delicious decision.
- And if you're doing a classic Tofurky or seitan roast, I would like to recommend using sparkling apple cider or a hoppy beer, along with sliced garlic, shallots and fresh herbs, in that marinade. It's where it's at.
- If you're looking for something different or simply finger food-orientated, perhaps the first-ever documented Totsgiving can inspire.
Michele's cozy picks:
While I'm just as likely to make pizza or pasta, here are some more traditional holiday dishes:
Manifest Vegan's cranberry upside down cake works for dessert, but leftovers for breakfast might be even better.
A veganized version of the Astro Weenie Christmas Tree will do for any gathering.
Vegan Dad's nugget recipe is my go-to for seitan cutlets of all shapes and sizes.
Some of my favorites for which I've never had recipes are stuffin' muffins (stuffing made in muffin tins), crispy baked chickpeas, roasted sweet potatoes, and any ol' hunk of bread with roasted elephant garlic and parsley butter.
Vegan Thanksgiving in Portland & Beyond
And if you're staying in, how about mixing things up and putting together a special Korean dolsot bibimap, Papa Tofu Loves Ethiopian spread (from Vida Vegan Con alumnae Kittee Berns) or even picking up take-out from a vegan-friendly restaurant, grocery store or caterer open in your neighborhood? There's often something extra fun about breaking tradition, and most importantly, creating your own.
If you're in the Portland area like us, here are some suggestions:
Blossoming Lotus is taking reservations for a Family Style Thanksgiving Feast
Downtown's Vegetarian House seems to be open normal hours.
Papa G's is taking special orders for both dine-in and carry-out vegan feasts
Native Foods is also offering a special holiday take-away and dine-in (reservations seems recommended) menu, including Native Wellingtons and stuffing.
Whole Foods offers online and in-store ordering for their 4-person Vegan Thanksgiving set, which includes a Wild Rice, Yam & Pear Roast, Vegan Mushroom Gravy, Pumpkin Pie and 5 other holiday dishes.
- Back to Eden is taking special orders
- Sweetpea Baking Co pre-ordering information
- Petunia's Pies & Pastries ordering information
The incredibly well-attended, 10th Annual NorthwestVeg Compassionate Thanksgiving Potluck is also happening on November 24th at Benson High School. Registration here.
Outside of Portland?
Lazy Smurf's Vegan Thanksgiving round up
Super Vegan did a New York City round up last year
Red Tricycle's Vegetarian and Vegan Thanksgiving spots in Los Angeles
Vegan Thanksgiving dinner menus at Upstairs on the Square in Boston
We'd love to hear about your own very special, traditional or otherwise, American Thanksgiving plans (or Canada's earlier this year!) and tried and true recipes.
Do feel free to let us know of any other spots open in your neighborhood.
Happy Feasting!
Stay tuned for more from our Vida Vegan holiday guides & news on our holiday events.
The early bird discount for our upcoming holiday celebration ends next week!
Catching up with Vida Vegan Alumni: Q & A with Leigh-Chantelle
My, how time flies! We started this Q & A series at Vida Vegan Headquarters heading into September's VeganMoFo, and since we received such great feedback and responses from our alumni, we're excited to continue with a few more final installments. These special interviews offer a glimpse into our past alumni's upcoming projects, summer shenanigans and reveal what they really learned at VVC2013. They're sharing which class sticks out in their minds so many months later, and just what they'd like to see more and less of in vegan blogging, a question that's always on our own minds.
Our next interview is with one of our furthest traveling guests for Vida Vegan Con, (mostly) Australian-based author, international speaker, activist and blogger, Leigh-Chantelle of Viva La Vegan! and the Green Earth Group.
What were you up to this Summer? I travelled to the USA for my Australian Winter. I spent 9 weeks in America, travelling all over the country for vegan/Animal Rights events, visiting friends and, one of my favourite things – road trips. When I was in the USA I had an interview with CHRY105.5FM in Toronto, Canada and had a lovely article written about me in the Examiner.
Talks, Panels & Workshop Videos:
- Vida Vegan Con panels: Ethics Beyond the Plate, International Activism and Vegan Invasion: Community Building.
- Talks at the Anti-Fur Society Conference: Australia's Progresses & Challenges and Promoting Veganism.
- Workshop on Staging Effective Events & Engaging Volunteers at the Critical Animal Studies conference.
- Engaging Abroad panel at the Animal Rights Conference.
I then spent a month in Cambodia, specifically Phnom Pehn, Battambang and Siem Reap before coming to Indonesia. I spent the last few weeks in Magelang, Central Java and then Surabaya, East Java before returning to my beloved Ubud, Bali where I'll be until the beginning of October when I return home to Brisbane, Australia for aunty duties. I did a lot of media interviews when I was in Java – you can view the articles on my blog, FaceBook or Google+. One of the articles is online – use Google Translate for English. (see the photo attached – Focus Jateng) I've just launched 3 new vegan dessert e-books and 1 raw recipe e-book. I've completed the text for my upcoming recipe book due out the end of the year and am now compiling my vegan athletes interview book. As always, I have many different projects going.
Why did you decide to attend Vida Vegan Con II?
VVC is my favourite vegan event – and I've been to a great deal of vegan/AR events. I was asked to speak again for the second year, immediately accepted and was excited about the new topics I'd be speaking about.
Looking back, what was the most memorable class? I really enjoyed being a part of the Ethics Beyond the Plate panel and had a lot of great feedback about it. I thought 5 people on the panel was too many, but Jason did a great job of directing questions and keeping the topics on track. It's biased, but I always love hearing my close friends Jasmin and Mariann from Our Hen House as well as Ryan Patey from TOFU Magazine speak.
What would you like to see more or less of in (vegan) blogging? One of the things I say in just about every talk I give – especially here in SE Asia – is that veganism is not a diet and it's not a religion. Diet in particular seems to be the main focus for a lot of blogs. I'd like to see more people write about the fact that veganism isn't the first and last step towards compassion and living ethically. We are here on this earth to learn and there's just so much to absorb. I also don't like reading about how veganism is a "cure all" for all of the diseases and environmental catastrophes we are experiencing – it's a massive help, but it's not the be all and end all.
You can follow along with Leigh-Chantelle's travels and vegan journey by following her Youtube channel, VivaLaVeganDotNet, Twitters, @VivaLVegan & @leighchantelle and Pintetest page, Viva La Vegan.
Stay tuned for the final installments of our Q & A series and some vegan-friendly entertaining tips for the holiday season here at Vida Vegan Headquarters.
What a Month!
It's been swell looking back on what we've all been up to since the workings of the very fist Vida Vegan Con in 2011 during our Month of Memories for VeganMoFo, and catching up with alumni, speakers and sharing some behind the scenes secrets.
Our Q & A series will continue into Autumn as all three VVC organizers begin, continue and end their separate travels, gathering inspiration for their own endeavors and Vida Vegan-land, alike.
Thank you all for being a part of the Vida Vegan family, and we hope to see you at our next happening, whatever neck of the woods it may be in!


text:
Updated 12/20/2013
After 18 years performing in the kitchens of others, acclaimed chef Christian Morrisset opened one of the best restaurants in the Old Town of Antibes, on the site of what was formerly La Jarre. It is in a contemporary setting with dark wood tables and is gorgeously shaded by a 40-year-old fig tree and a canopy of vines—the shady street is one of the most picturesque in town. The former chef of Juana has kept his prices democratic at lunchtime, when a meal costs around
€20; you can easily spend twice as much at dinner. Typical of his style, which focuses on local ingredients, is a saddle of lamb from the Alpilles cooked in a crust of Vallauris clay with gnocci and truffles, zucchini, eggplant, and thyme jus.
14 rue Saint-Esprit, Antibes, 06600, France
Website: www.christianmorisset.fr
Restaurant Details:
Updated 12/20/2013


text:
#GamerGate Victory Conditions, and an Update on #TheSarkeesianEffect
I wanted to get my thoughts out there on #GamerGate, as well as to address some concerns regarding The Sarkeesian Effect.
I wanted to get my thoughts out there on #GamerGate, as well as to address some concerns regarding The Sarkeesian Effect.
Even Beethoven didn't write his first great symphony until he was in his 30s, and music is the sort of endeavour which can be focused on exclusively, it doesn't require a breadth of life experience – just a lot of time. Politics, meanwhile, demands a wide set of experiences, a familiarity with the human condition, an awareness of your own dark nature, and a broad understanding of the various philosophies and ideologies which govern human society. There are no savants in politics; and for a teenager to be awarded this medal demeans the medal, as well as the recipient.
The issue is not whether or not Miss Sarkeesian fabricated anything – the issue is that game journalism, as well as mainstream journalism, took her at face value and never investigated her claims.
The San Francisco PD would like to know to whom Sarkeesian made the report about the death threats she's been receiving; they deny ignoring her, as she claims.
The enemies of civilization only argue to create distractions. They have no honesty or integrity to their words, they're numb to beauty, and whenever possible they resort to underhanded personal attacks. They sow the seeds of discord wherever they go, and when we fight amongst ourselves we're doing their own work for them.
Hope is frightening; it implies the potential for failure. Hope is demanding; it provides an objective to work towards. Hope is humbling; it makes you realize that your own weaknesses are your worst enemy. Living without Hope leads to failure, but it's a comforting sort of failure. It's the root of all addiction.
Getting back into the swing of things… Video by TJ Sotomayor here.
I cannot overstate what a terrible, terrible thing the Prisoner's Dilemma is. It is Objective Reality run amok. It is Cthulhu's maw gaping for our souls. It is an eternal hall of mirrors squeezing in on you, until the glass shatters and tears through your eyes, and into your soul.
We are all prisoners of this world, all of us locked into this psychopathic trust game with one another, and the only sane answer is – each and every time – to defect, to sell out your co-conspirator, and to hope to God that they're just a robotic simulacrum that sold you out first.
If questioning the orthodoxy of Climate Change will get a man fired, than the insidious, indirect effects of politicized science are going to be ten times more powerful.


text:
Hi all graphistas out there,
And happy new year! I hope you had an excellent start, let's keep this year rocking with a spirit of graph-love! Our Rik Van Bruggen did a lovely blog post on how to import data into Neo4j using spreadsheets in March last year. Simple and easy to understand but only for Neo4j version 1.9.3. Now it's a new year and in December we launched a shiny new version of Neo4j, the 2.0.0 release! Baadadadaam! So, I thought better provide an update to his blog post, with the spirit of his work. (Thank you Rik!)
You can still use the Neo4j CSV batch-importer (Now for 2.0.0) from Michael Hunger, or look at other Data Import Options.
If you simple want to use Cypher, Rik's way is much easier. That's why I have updated Riks Cypher statements old statements in a new spreadsheet that shows how how to import to Neo4j 2.0.0.
How does it work?Open the spreadhsheet.
The sheet is composed of two parts:
columns A, B and C: these contain the data for the Nodes of our graph, using a custom "id", a "name", and a "gender" as properties.
columns F, G and H: these contain the data for the Relationships of our graph, having a "from-id" (where the relationship starts), a "to-id" (where the relationship ends), and a "relationship type". Columns F and G reference the nodes and their id's in column A.
And then comes the secret sauce: how to create Cypher statements from this nodes and relationship information.
For this we use very simple statements that leverage the columns mentioned above, the cypher syntax and string concatenation. Look at the columns D and I:
We just use this formula to create the cypher statement.
="MERGE (meetup:Event {id:'"&A3&"', name:'"&B3&"'})"
(instead of create we will use merge who is a new feature in 2.0.0 it will create if the node not exist otherwise it will not create a new node. You can read more about it here in the Neo4j Manual. Output for row 3:
MERGE (meetup:Event{id:'153602002', name:'Meetup Malmö'})
If we check the next row, we will see a change, since we know that all attendees of the meetup will attend our meetup, we can create the whole relationship too. So we combine the creation of the "Person" Node with connecting it to the meetup node we just created.
="MERGE (_"&A4&":Person {id:'"&A4&"', name:'"&B4&"', gender:'"&C4&"'}) -[:ATTENDS]->(meetup)"Output for row 4:
MERGE (_2:Person {id:'2', name:'Donald Duck', gender:'man'})-[:ATTENDS]->(meetup)
As you can see, it takes that id, name and gender properties from columns A, B and C, and puts these into a "MERGE" Cypher statement.