text:
Find Allied Health Care Professionals & Services Western Australia | Quotes Coupons Reviews
Find out more information about Allied Health Care Professionals & Services, including quotes,... read more
- Risk Management WA
- Personal Training Perth Healthy Glow
- Southern River Occupational Therapy - Pediatric Occupational Therapy Perth
Complete Risk and Safety Solutions – Risk ManagementEllenbrook Perth WA
OH&S Management, Business Security Strategies, Emergency Management Protect your business against the numerous Risks.
Running a business means having a million things to consider, and more than a few risks to consider. Financial risks, Security Risks, Fire Safety, Emergency Managements, and more.
The risks will always be there, but you can manage them optimally.
Complete Risk and Safety Solutions is a 100% Australian-owned and operated Risk Management Solutions orgnisation based out of Western Australia, that provides their clients with a comprehensive range of risk management solutions for companies across all sectors and industries.
Public and Private sectors alike, Complete Risk and Safety Solutions summons their 17 years of combined experience in the area of risk management to provide their clients with a COMPLETE and exhaustive risk management plan tailored to individual business needs. Serving Private and Public Sectors in Australia and Overseas. ...See More
Products: Occupational health & safety, security management, fire safety, emergency management, fire audits, security plans, security audits, security assessments, overseas travel briefs.
Services: Occupational health & safety Ellenbrook, Dianella, Como, Floreat, Kingsley, Perth, North Perth, Subiaco, Fremantle, Yanchep, Bunbury, Broome, Albany, Kalgoorlie and across WA
Healthy Glow - Personal Training Northern Suburbs Perth | Fitness Trainer Woodvale
Healthy Glow Personal Training Studio offers personal training in Perth's Northern Suburbs.
Clients come from the entire area to make use of their expert fitness training services, including Woodvale, Joondalup, Duncraig, Edgewater, Hillarys, and more.
Call today on9309 2532 to find out more.
Northern Suburbs Perth Personal Training | Edgewater | Woodvale | Hillarys
Are you trying to slim down for a big occasion?
Do you want to tone up or increase your overall fitness?
Want to lead a healthy lifestyle, but just need some guidance and encouragement?
Whether you're an athlete, on the path to your desired weight or struggling to get your fitness in order, Healthy Glow is right for you.
Fitness Training Joondalup
Getting you fit, healthy and happy!
Healthy Glow is a personal training studio specialising in weight loss, muscle toning, fitness, body shaping... See More
Products: Motivation, Healthy Lifestyle Support, Body Shaping, Well-Being, Professional Training, Fitness Centre, Fitness Studio, Gym, Weight loss, Muscle Toning, Spray on Tan
Services: Personal Training Northern Suburbs Perth: Woodvale, Joondalup, Duncraig, Hillarys, Edgewater, Cragie, Kingsley, Beldon, Kallaroo, Heathridge, Padbury, Hocking, Perth WA.
Southern River Occupational Therapy -Pediatric Occupational Therapy Perth
Southern River Occupational Therapy in Perth is a pediatric therapist experienced in children's development & learning delays, sensory motor difficulties and concentration problems.
Call now on(08)9490 7569to help give your child the best help possible.
Pediatric Therapist Perth | Gosnells
Is your baby having sleeping problems?
Or not meeting the usual movement milestones?
Southern River Occupational Therapy in Perth has a special interest in pediatric occupational therapy for babies, children and adolescents.
Whether your child is having concentration or balance problems or issues with learning, Southern River Occupational Therapy is devoted to helping find solutions for your most cherished family members.
Concentration Problems | Pediatrics Harrisdale
Dealing with developmental problems can be stressful for the whole family.
But Southern River Occupational Therapy is committed to finding practical solutions for your child.
I have over 20 years of professional experience in pediatric occupational... See More
Products: Pediatric Occupational Therapy, Pediatric Therapist, Therapy - Developmental Delay, Visual Perception, Sleeping Problems, Sensory Motor Problems, Learning Difficulties, Therapeutic Listening, Visual Perception Treatments, Pediatrics, Concentration Problems, Balance & Coordination Problems, Fine Motor Difficulties, Academic Potential Problems, Sensory Processing Disorder, Writing Problems
Services: Perth, Harrisdale, South of River, Southern River, Willetton, Canning Vale, Thornlie, Gosnells.


text:
1992 Oldsmobile Achieva Repair and Maintenance
A guide to problems, costs, maintenance and repair for your 1992 Oldsmobile Achieva
- Air Conditioning Diagnosis $53 - 68
- AC Compressor Replacement $531 - 735
- South Side Auto Service Inc. (718) 305-4810 | 7.91mi
- Ray & Dana's Inman Auto Care (732) 703-7919 | 3.46mi
- Zaloom's Auto Repair (646) 663-5728 | 8.95mi
- Route 1 Sunoco (732) 253-4623 | 8.11mi
- Carracino's Auto & Truck (908) 364-5589 | 8.49mi
1992 Oldsmobile Achieva Problems
A door window may move slowly or stop in mid travel due to a failing power window motor. The affected window may start working again after the motor cools off. Replacing the faulty window motor will commonly correct this concern.
The 2.3L 4 cylinder engine can be prone to head gasket failure. This can result in coolant loss and engine overheating.
An automatic transmission fluid leak may develop from the rubber section of a transmission cooler line. In some cases the rubber section of hose can be replaced. In others, the complete cooler line must be replaced to correct this type of leak.
1992 Oldsmobile Achieva Questions
just need to know the part number so i can replace it!
This is only after engine is warm.
Even worse in Hot/Warm weather.
It is as if the signal is not being sent to tell it that it is a warm engine.
I have cleaned the Massive Air Flow Sensor.
Otherwise it runs fine.
my tail lights and dash lights dont work i have replaced the fuses and that didnt work.
1992 Oldsmobile Achieva Reviews
bought my 92 olds achieva sc 5yrs ago for 600 dollars and it still getting approx 32 mpg. only had to replace the normal wear & tear items since i have owned it. i love that 2.3L quad4 engine lots of power and torque. other than my pontiac sunfire gt 2.4L quad4 its my pride and joy!

subset: commoncrawl


text:
Active Tags
Click tags to the right to narrow your search. Unclick tags to remove.
Mrs. Wentworth is Naughty
— In part ten Mrs. Wentworth is caught losing control.The Seahorse Society Ch. 03
— The event brings Todd's troublesome ex into the picture.The Homeless
— Helping a young woman undo bad decisions.The Summer
— It was the summer I learned SEX.Sittin' On The Cock Of The Boy
— Two young men, a boat and a love story.College Blues
— College days and discoveries.Saving Heroes
— They finally have him back.It Begins...
— Discovering desires.Khoe; A Tale of Sadness & Joy Ch. 05
— What one woman can't have, another doesn't dare to hope for.Planned Force
— Bringing dream girl's fantasy to life.Sailing Away Ch. 03
— A continuation of a romantic sea voyage.The Assassin's Trainee
— Vincent takes his trainee on her first mission.Little One Meets Her One Ch. 03
— Tara begins to grow in her knowledge.What Sandy's Friend Told Ch. 01
— Two US Students in Europe meet two Dutch Girls.Cousin Steph
— Two cousins share a week at the beach.Susie Ch. 21
— Show Time.Sex Ed After Marriage/ Luke's View
— Hubby's take on a sheltered couple's sexual awakening.Sexual Discovery
— Guy learns about sex then about love.Our Massage Parlor Ch. 02
— She learns how to give him a happy ending.The Search and The Discovery Ch. 02a
— Obedience testing and beginning the next step.Alicia & Shelly's Club
— Best friends enjoy their first all female sex party.Alicia, Shelly & Maria
— Two young women and a mature women experiment sexually.Average Joe Ch. 03
— Mary teaches Joey about women. Joey's first time.Instructions Pt. 02
— More learning opportunities.Training Ch. 04
— Bobby learns to eat pussy and is rewarded.Darkroom - Tuesday
— College girls plan to appreciate nice guys in the dark.Serving The Council Ch. 04
— Learing ancestry.The Learning Room Ch. 01
— Two locked in a shipping container.Vocational School Ch. 01
— Sis adores bro's big cock; mom's slave to it.Puppy Love
— Does anyone understand me? I really love her.Maria
— A medical student learns a lesson.Heather Ch. 12
— Suddenly Heather and I have hours together.The Couples Club Ch. 05
— Entering Training / Fornication Fantasies.Sandy
— A grad student moves into a home and seduces.A Touch of Gentleness
— A call girl visit.Teachers Demand Respect
— Mouthy student learns her lesson.Basic Training
— Instructions for the unenlightened.Remote Control
— He controls her in class, and makes sure she learns.Not My Type Ch. 05
— Learning more about Adam proves to be shocking.Alex: Lessons in Submission
— The real training starts.Three On One!
— Nan's first lesson sure is fun.Betsy's Birthday Party
— They celebrate with a threesome,Zindy's Training
— She learns to submit.Nikki's Initiation
— Woman learns about her own sexuality.Motivational Learning Ch. 02
— Rita and Dr. Alta pursue a deeper understanding.Dreams of Submission
— She takes the journey to becoming a submissive.Moving On
— Moving on after death of a SO.On BDSM
— A good submissive is hard to find.Pixie
— Pixie girl is shown what sex is.Jael's Promise Ch. 02
— The journey continues.Den of Iniquity Ch. 02
— Roger returns & witnesses a flogging.Dominique Ch. 01-06
— One girl's submission.Memoirs of a Dreamer Ch. 02
— Lessons & testing begin; changes are made.Active Tags
Click tags to the right to narrow your search. Unclick tags to remove.
Please, separate your tags with comma: anal orgasm, oral sex.
Read the Literotica Story Tag FAQ for more information on these tags.


text:
Tuesday, December 31, 2013
Happy New Year - Mental Health Awareness Retreat
2 comments:
Awesome video. While I'm on a slightly different end then you, this message still rings very true. I will be turning 30, myself, on the 27th of Jan. and such issues have definitely come up in the past couple years within me and my family. I also don't like the term "settling down" as it means (on one level) that you have to get married and do all that stuff in order to be seen as 'mature' - something I greatly disagree with. My boyfriend and I don't care to get married, it's just a piece of paper to us. Yet, we have been together for 12 years. Neither of us is going anywhere, and we don't need a marriage certificate to prove that. But people still say we should get married... why? As for kids, neither of us want any; much to the unhappiness of both sets of parents :P For me, if travel and adventure comes, I'll take it. But, I've lived enough of my life with a scattered (ADD) brain so, right now, I want to be still and relax a bit hehe The future could hold something very different for me, and I am open for that change, but right now I want exactly what I have - to hell with what everyone else thinks! :)
As for goals, I think I'll follow the philosophy of another friend of mine (link below) on that one and not set them. It's about living in the now and not 'in the future', but to each their own - of course! I hope all your plans succeed, and remember, if you ever want to add 'published' as a goal just let me know ;)
Happy New Years and enjoy life your way!


text:
or Find Places Near You
Top 10 Romantic Inns
Allow yourself to be enticed by these spectacular bed & breakfasts and country inns. These previous winners of the most romantic inn award promise a special getaway for you and your sweetheart.
Top 10 Romantic Inns of
Hermann Hill Vineyard & Inn
Hermann, Missouri
Goodstone Inn & Restaurant
Middleburg, Virginia
Made INN Vermont
Burlington, Vermont
Black Dolphin Inn
New Smyrna Beach, Florida
Whitestone Country Inn
Kingston, Tennessee
Maison DMemoire B&B Cottages
Rayne, Louisiana
Cheshire Cat Inn & Spa
Santa Barbara, California
Captain Farris House
South Yarmouth, Massachusetts
The Queen Victoria
Cape May, New Jersey
Three Tree Point Bed & Breakfast
Seattle, Washington
Top 10 Romantic Inns of
Land's End Inn
Provincetown, Massachusetts
HammerSky Vineyards
Paso Robles, California
Fort Lewis Lodge
Millboro, Virginia
A Cowboy's Dream
Alamo, Nevada
Shiloh Morning Inn
Ardmore, Oklahoma
The Inn at Bowman's Hill
New Hope, Pennsylvania
Wye Not Getaway B&B on Wye Lake
Port Orchard, Washington
Bocage Plantation
Darrow, Lousiana
The Sebring Mansion
Sebring, Ohio
Wentworth Mansion
Charleston, South Carolina
Top 10 Romantic Inns of
The High Pointe Inn
West Barnstable, Massachusetts
Foxfield Inn
Charlottesville, Virginia
Eden Vale Inn
Placerville, California
The Villas at Gervasi Vineyard
Canton, Ohio
1906 Lodge
Coronado, California
The Inn at Irish Hollow
Galena, Illinois
Johnson Mill Bed & Breakfast
Midway, Utah
Henderson Park Inn
Destin, Florida
The Inn at Sunrise Point
Lincolnville, Maine
Rosemary Inn Bed and Breakfast
North Augusta, South Carolina
Top 10 Romantic Inns of
Holualoa Inn
Holualoa, Hawaii
Burlington's Willis Graves B&B
Burlington, Kentucky
A.G. Thomson House
Duluth, Minnesota
Cedarcrest Manor at Overlook Farm
Clarksville, Missouri
Inn at 202 Dover
Easton, Maryland
Abbeymoore Manor B&B
Victoria, British Columbia
The Sayre Mansion Inn
ethlehem, Pennsylvania
Mansfield Plantation B&B Country Inn
Georgetown, South Carolina
El Rancho Merlita Ranch House B&B
Tucson, Arizona
Bed & Breakfast on Tiffany Hill
Mills River, North Carolina
Top 10 Romantic Inns of
Hartstone Inn
Camden, Maine
Tyee Lodge Bed and Breakfast
Newport, Oregon
Clarendon Square Inn
Boston, Massachusetts
Chateau Coralini Retreat & Spa
Salinas, California
Honeybee Inn Bed & Breakfast
Horicon, Wisconsin
Whispering Pines Bed and Breakfast
Dellroy, Ohio
Colettes Bed & Breakfast
Port Angeles, Washington
Christopher Place - An Intimate Resort
Newport, Tennessee
L'Auberge Provencale
White Post, Virginia
The Queen Victoria
Cape May, New Jersey
Top 10 Romantic Inns of
MacCallum House Inn
Mendocino, California
Highland Haven Creekside Inn
Evergreen, Colorado
The Towers Bed & Breakfast
Milford, Delaware
Port d'Hiver Bed and Breakfast
Melbourne Beach, Florida
Carriage House at the Harbor
South Haven, Michigan
Fleur-de-Lys Mansion
St. Louis, Missouri
The Edward Harris House Bed & Breakfast Inn
Rochester, New York
The Inn & Spa at Intercourse Village
Intercourse, Pennsylvania
French Quarter Inn
Charleston, South Carolina
Inn at Warner Hall
Gloucester, Virginia
Top 10 Romantic Inns of
Pearson's Pond Luxury Inn & Adventure Spa
Juneau, Arkansas
Garth Woodside Mansion
Hannibal, Missouri
Buhl Mansion Guesthouse & Spa
Sharon, Pennsylvania
The Red Horse Inn
Landrum, South Carolina
The Reluctant Panther Inn and Restaurant
Manchester, Vermont
Songbird Prairie B & B
Valparaiso, Indiana
Ho'oilo House
Lahaina, Hawaii
Run of the River
Leavenworth, Washington
Lake Pointe Inn Bed and Breakfast
McHenry, Maryland
Hydrangea House Inn
Newport, Rhode Island
Top 10 Romantic Inns of
1795 Acorn Inn
Canandaigua, New York
Blair Hill Inn at Moosehead Lake
Greenville, Maine
Glasbern Country Inn
Fogelsville, Pennsylvania
Magnolia Mansion
New Orleans, Lousiana
Rivertown Inn
Stillwater, Minnesota
Adobe & Pines Inn
Taos, New Mexico
Candlelight Inn
Napa, California
Historic Jacob Hill Inn
Providence, Rhode Island
McMillian Inn
Savannah, Georgia
The Place at Cayou Cove
Deer Harbor, Washington
Top 10 Romantic Inns of
Inn at Bowman's Hill
New Hope, Pennsylvania
Santa Ynez Inn
Santa Ynez, California
Adobe Grand Villas
Sedona, Arizona
Brampton Inn
Chestertown, Maryland
Grand Victorian Bed and Breakfast Inn
Belliare, Michigan
Sea Crest By The Sea
Spring Lake, New Jersey
Savory Inn & Cooking School
Vail, Colorado
Bissell House Bed & Breakfast
South Pasadena, California
Washington Plantation
Washington, Georgia
Butler House on Grand
Des Moines, Iowa
Top 10 Romantic Inns of
The Mansion at Judges Hill
Austin, Texas
Cliff Park Inn
Milford, Pennsylvania
Adair Country Inn
Bethlehem, New Hampshire
Alma Del Monte
Taos, New Mexico
The Brumder Mansion
Milwaukee, Wisconsin
The Inn at Vaucluse Spring
Stephens City, Virginia
Mill House Inn
East Hampton, New York
Wine & Roses
Lodi, California
Murchison House
Wilmington, North Carolina
Swann House
Washington, District of Columbia
Top 10 Romantic Inns of
Harbor House Inn
Elk, California
Two Meeting Street Inn
Charleston, South Carolina
The Captain Lord Mansion
Kennebunkport, Maine
Monmouth Plantation
Natchez, Mississippi
White Lace Inn
Sturgeon Bay, Wisconsin
Simpson House Inn
Santa Barbara, California
Melhana The Grand Plantation
Thomasville, Georgia
Cliff House at Pikes Peak
Manitou Springs, Colorado
Columbia Gorge Hotel
Hood River, Oregon
Abigail Stoneman Inn
Newport, Rhode Island
Top 10 Romantic Inns of
Ojai Valley Inn & Spa
Ojai, California
Charles Street Inn
Boston, Massachusetts
The Pillars at New River Sound
Fort Lauderdale, Florida
The Swag Country Inn
Waynesville, North Carolina
Cibolo Creek Ranch
Shafter, Texas
The Willows Historic Palm Springs Inn
Palm Springs, California
Don Gaspar Inn
Santa Fe, New Mexico
Abigail Stoneman Inn
Newport, Rhode Island
The Castle Inn Riverside
Wichita, Kansas
Henderson Village
Perry, Georgia
Top 10 Romantic Inns of
Windham Hill Inn
West Townshend, Vermont
The Cuthbert House Inn B&B
Beaufort, South Carolina
RittenhouseSquare B&B
Philadelphia, Pennsylvania
Cliff House Inn
Manitou Springs, Colorado
Brewery Gulch Inn
Mendocino, California
Savannah, Georgia
Woolverton Inn
Stockton, New Jersey
Columbia Gorge Hotel
Hood River, Oregon
Inn on La Loma Plaza
Taos, New Mexico
Adele Turner Inn
Newport, Rhode Island
Top 10 Romantic Inns of
Melhana Plantation
Thomasville, Georgia
Victorian Treasure Inn
Lodi, Wisconsin
Captain's House Inn
Chatham, Massachusetts
Francis Malbone House
Newport, Rhode Island
Governor's House Inn
Charleston, South Carolina
The Honor Mansion
Healdsburg, California
The King's Cottage
Lancaster, Pennsylvania
Blue Lake Ranch
Durango, Colorado
Hacienda Del Sol
Tucson, Arizona
Agate Cove
Mendocino, California
Top 10 Romantic Inns of
Castle Hill Inn & Resort
Newport, Rhode Island
Ballard Inn
Ballard, California
Greyfield Inn
Fernandina Beach, Florida
Seven Gables Inn
Pacific Grove, California
Litchfield Plantation
Pawleys Island, South Carolina
Graystone Inn
Wilmington, North Carolina
Inn at the Park
Wichita, Kansas
Great Oak Manor
Chestertown, Maryland
The Hope and Glory Inn
Irvington, Virginia
Fairview Inn
Jackson, Mississippi
Top 10 Romantic Inns of
The Queen Victoria
Cape May, New Jersey
Cedar Crest Victorian Inn
Asheville, North Carolina
Whitestone Country Inn
Kingston, Tennessee
Liberty Rose B&B
Williamsburg, Virginia
Sand Hills Lighthouse
Ahmeek, Michigan
Simpson House Inn
Santa Barbara, California
Saratoga Inn
Langley, Washington
Orchard Hill Country Inn
Julian, California
The Inn at National Hall
Westport, Connecticut
Geneva on the Lake
Geneva, New York
Top 10 Romantic Inns of
Monmouth Plantation
Natchez, Mississippi
The Melrose Mansion
New Orleans, Lousiana
Kailua Plantation House
Kailua-Kona, Hawaii
Beaufort Inn
Beaufort, South Carolina
Charlotte Inn
Edgartown, Massachusetts
Casa Europa Inn & Gallery
Taos, New Mexico
White Lace Inn
Sturgeon Bay, Wisconsin
Green Gables
Pacific Grove, California
Greencrest Manor
Battle Creek, Michigan
Spencer House
San Francisco, California
Top 10 Romantic Inns of
Canyon Villa
Sedona, Arizona
Clifton Country Inn
Charlottesville, Virginia
House on Bayou Road
New Orleans, Lousiana
Rabbit Hill Inn
Lower Waterford, Vermont
Chateau du Sureau
Oakhurst, California
Sooke Harbour House Inn
Sooke, British Columbia, Canada
L'Auberge Provencale
White Post, Virginia
Captain Lord Mansion
Kennebunkport, Maine
Hillbrook Inn
Charles Town, West Virginia
1842 Inn
Macon, Georgia
Top 10 Romantic Inns of
The Inn at Depot Hill
Capitola-by-the-Sea, California
Ann Starrett Mansion
Port Townsend, Washington
Maison Fleurie
Yountville, California
Rose Inn
Ithaca, New York
Durham House B&B
Houston, Texas
School House B&B Inn
Rocheport, Missouri
Manor House
Norfolk, Connecticut
L'Auberge Provencale
White Post, Virginia
Mainstay Inn
Cape May, New Jersey
St. James Hotel
Red Wing, Minnesota
Top 10 Romantic Inns of
The Inn at Canoe Point
Bar Harbor, Maine
Lenox, Massachusetts
The Fearrington House
Pittsboro, North Carolina
Kings Courtyard Inn
Charleston, South Carolina
Ravenwood Castle
New Plymouth, Ohio
Vicksburg, Mississippi
Casa Europa Inn & Gallery
Taos, New Mexico
The Inn on Mt. Ada
Avalon, California
The Lost Whale B&B Inn
Trinidad, California
Lahaina Inn
Lahaina, Hawaii
Top 10 Romantic Inns of
Martine Inn
Pacific Grove, California
The Heartstone Inn & Cottages
Eureka Springs, Arkansas
The Keeper's House
Isle Au Haut, Maine
The Inn at Weathersfield
Perkinsville, Vermont
Scofield House B&B
Sturgeon Bay, Wisconsin
The Rhett House Inn
Beaufort, South Carolina
Mainstay Inn
Cape May, New Jersey
Rabbit Hill Inn
Lower Waterford, Vermont
Two Meeting Street Inn
Charleston, South Carolina
The Harbor House Inn
Elk, California


text:
3Qs -Drop Main Return, Backup Drain, Coil Cleaning
Hey Gang-
I would really appreciate your help with my three questions: Q1. I am trying to plan out my mastic duct-sealing project. There are 4four 6" branches off the main supply duct but I cannot get to them because the main return is in the way. I cannot get to them from the opposite side because the main beam is in the way. How easy or difficult would it be for 1 person to temporarily drop and re-install the main return (approx. 20 feet) in sections? Any tips or special tools? http://img842.imageshack.us/img842/7...vacdropduc.jpg http://img526.imageshack.us/img526/7...vacdropduc.jpg Q2: I just noticed that my AC backup drain has been plugged? Shouldn't this outlet be attached to a PVC to dump water on the ground in case the primary drain is plugged up? Since I will not be able to install a floor pan, can I point my new secondary pipe into a small bucket. Should I install a water detection switch? How difficult would it be to install such switch and tie into the system? http://img404.imageshack.us/img404/5...vacdrainpl.jpg Q3: I am not sure when was the last time my coil was cleaned. Can someone tell me if the cover (pictured) contains the coil inside and that I simply need to remove the sheet metal screws, take the cover off and clean my coil? Any special cleaning chemicals I should use? http://img269.imageshack.us/img269/6...vaccoilcov.jpg |
1.) I'd have two people present. Removing those cleats is the correct way.
2.) Easy to install an evaporator float switch into the secondary drain line. It simply screws into where that plug is right now and you connect the two wires from it to one of the wires going to the condenser, putting the switch in line of that one wire. All power by way of breaker, not just the stat, must be off or you can blow a fuse or transformer. 3.) Yes. There are a few screws on the inside that hold the drain pan in place. You'd first need to remove that exhaust pipe out of the way, then the service doors of the coil, remove the inside screws that hold the guts in place and VERY CAREFULLY pull the entire thing out. Carefully so as to not bend the refrigerant lines. |
This is what your upflow evaporator coil will look like.
http://www.handymanhowto.com/wp-cont...6/DSC02682.JPG |
Thanks Doc for the pictures!
I will post a follow up with some pictures. |
Not a problem. :thumbsup:
Also, you're going to need to cut that main drain. I'd cut it after those first two 90 degree turns where there's a few inches of regular pvc pipe on the side of the evaporator so you can reconnect it with a coupling and some glue. You need at least an inch of pvc to stick into the new coupling on each side.
Good luck. |
All times are GMT -5. The time now is 12:39 PM. |


text:
Aleksandra Albu has UFC fight fans very excited after some pictures of her on holiday were released on the Internet via her social media pages. The gorgeous Russian professional mixed martial arts fighter looked breathtaking in photos which showed her wearing various sexy clothing such as a black lace dress that hugged every muscular yet feminine curve of her body.
This picture and several others of her in which she is photographed wearing an orange bikini or jeans shorts and a black crop t-shirt have come to the attention of some fight fans and almost has the same impact as a submission move in that it makes it almost impossible for viewers of the pictures to do anything productive while looking except to smile.
The sexy pictures of the Russian bombshell have brought renewed interest about when she will be making her UFC fight debut as it has been revealed that she still has not received medical clearance for an unknown injury that occurred during training. She was rumoured to have been someone that UFC head Dana White had wanted to include in season 20 of The Ultimate Fighter Challenge which will include fighters of both bantamweights and strawweights classifications and that could have been an intriguing dynamic.
This relatively 'unknown' Russian fighter was initially supposed to compete as a bantamweight but there have been speculation that she is going to drop down to the strawweight division but everything is on 'hold' as fans await her clearance from UFC doctors that she can return to sparring.
When she does return one can only envision the potential viewing ratings that could ensue with her in one of the competitors in a UFC tournament because she brings beauty and toughness to the octagon that could result in her becoming a ratings sensation and help make UFC even more popular both in the United States and Europe.
Aleksandra Albu has the attention of some UFC fans because of her gorgeous looks and fight potential and many hope that her fighting is on par with her looks because if it is than she will be another name who brings fans to UFC events, something that always makes Dana White smile.


text:
This section contains 5,438 words (approx. 19 pages at 300 words per page) |
Critical Essay by Janet V. Haedicke
SOURCE: "'A Population [and Theater] at Risk': Battered Women in Henley's Crimes of the Heart and Shepard's A Lie of the Mind," in Modern Drama, Vol. 36, No. 1, March, 1993, pp. 83-95.
In the following essay, Haedicke compares the depiction of domestic violence in Shepard's A Lie of the Mind and Henley's Crimes of the Heart, asserting that Shepard's postmodernist drama "ignites a politics beyond Henley's modernist drama, which can kindle only kitchen fires."
"The weeping of women who are wives—what is more bitter?"1
Oft-castigated for its preponderance of family drama, American theater seems unprotestingly to cede stature to British theater, which has moved from "kitchen-sink" realism to presumably more universal and political plays. Yet the charge of triviality levelled...
This section contains 5,438 words (approx. 19 pages at 300 words per page) |


text:
- About Scala
- Documentation
- Code Examples
- Software
- Scala Developers
Consistency for parentheses on toString in the Scala library?
Thu, 2011-11-24, 17:00
I use IntelliJ Idea and am grateful for its inspections, one of which
warns about overriding empty-parens methods without parentheses and
vice versa. On toString, however, it is difficult to avoid getting
your code flagged since some library functions use empty-parens (e.g.
FunctionN) and some no parens (e.g. Iterator). The inspections seem to
regard whatever the next parent type does as the law and flag any
aberrations. In general this is a great feature, but for toString the
inconsistency results in a constant guessing game and makes it
impossible to achieve consistency in your own code (say, standardizing
on no-parens because one avoids mutation and side-effects) if you
don't want to be hectored by inspections.
My question is: is there are reason for this apparent inconsistency in
the Scala library, or would it make sense to submit tickets (e.g.
flagging all toStrings that are empty-parens) to help to clean this up
over time?
There is a somewhat related thread on StackOverflow that seems to
point in the direction that in general it may be desirable to
standardize on empty-parens for toString, unless there are special
cases that warrant an exception:


text:
Iraq Publications
Iraq Ten Years Later: A Different Country in a Different Region (Spring 2013)
Apr 16, 2013Senior Scholar Marina Ottaway writes that ten years after the U.S. invasion to overthrow Saddam Hussein, Iraq remains a deeply troubled country, rent by internal dissensions and caught in the maelstrom of the increasingly sectarian politics of the region. more
Economic Lessons from Iraq for Countries of the Arab Spring (Spring 2 2012)
Apr 17, 2012Given that Iraqis have experienced relatively democratic elections, Sassoon analyzes the economic lessons of an Arab country emerging from an authoritarian regime and assesses the pitfalls that other Arab countries might encounter with their nascent democracies. more
The Origins, Conduct, and Impact of the Iran-Iraq War, 1980-1988
Jul 12, 2011A CWIHP-NSA Document Reader compiled for the international conference "The Origins, Conduct, and Impact of the Iran-Iraq War, 1980-1988," Washington, D.C. 19 July 2004 more
287. Regime Change in Serbia and Iraq: What Have We Learned about the Legacy of Autocracies?
Jul 07, 2011Although not an immediately obvious pairing, much can be learned from the fall of Serbia's autocracy that may be applied to Iraq. Both countries were isolated and run for a long time by forcefully imposed autocratic regimes that developed a breed of patriotism which did not allow for dissent. Opportunities for these two countries to cooperate were enhanced by the similar position of the two regimes under international sanctions and fighting for survival against a 'common enemy.' Thus, not only do autocracies act similarly under similar conditions, but they also band together as they attempt to offset the ill effects of international pariah status. The reaction of the public in Serbia to the 1999 NATO campaign and the mind set that allowed for the continuation and at least temporary strengthening of Slobodan Milosevic's rule could have provided many clues, if not a template, for how Iraqis would behave under occupation. Moreover, the difficulties and slow pace of transformation in Serbia offer tips for state-building in Iraq. more
286. The Limits of Lessons for Iraq
Jul 07, 2011Jorge Santayana would be pleased. Nearly every policy proposal on Iraq these days mentions lessons learned from past interventions, such as postwar Germany and Japan, East Timor, Bosnia and Kosovo. In the spirit of Santayana's famous dictum—"those who forget the past are destined to relive it"—analysts have been doggedly culling US state-building experience for lessons learned. more
285. The Impact of the Emerging Role of East Europe in Iraq on NATO
Jul 07, 2011The antagonistic division between 'old' and 'new' Europe, as coined by Donald Rumsfeld, underscores the uncertainty of the transatlantic relationship as well as the ambiguous roles of NATO, its new members and Partnership for Peace (PFP) partners. This antagonism became exacerbated by the war in Iraq and, even as the 'major hostilities' ended in Iraq and the guerrilla counter-insurgency against US-led coalition forces accelerated, significant security rifts persist between 'old' Europe and the US, with 'new' Europe caught in the middle and forced to take sides. more


text:
Some time ago I blogged about my intentions of uploading files to a SharePoint Document Library site from a local folder using some kind of Web service. After doing some research and some tests, I found a very easy way to do that and now I want to share with you the approach I followed since you might find it useful as well.
To build this solution, you need to install Office SharePoint Portal Server 2003 and follow the next steps:
To install the Web service:
To consume the Web Service:
I can tell you it works, just keep in mind the download is a code sample.
I am currently developing an application that will help my team (Office Developer Documents) to manage all the metadata associated with the publishing process in MSDN. The name of the tool is Rawhide and it's a Web-based application. I am really excited of developing this tool because I am working with Whidbey, ASP.NET 2.0, SQL Server, Windows Sharepoint Services, and a cool set Office development features. Soon I will start adding Office "12" enhancements such as Excel Services and Windows Sharepoint Services "v3". I can't wait!
I am learning a lot from my peers about how interesting it is to publish content in MSDN and I hope this tool will improve our working experience and become a great source of code snippets that I can share with the community.
Today I was reading the newsgroups and I was looking at lots of posts where developers are looking for code that will help to upload programmatically files to a SharePoint library. I was surprised to see that there are lots of developers struggling with this issue. I am too :). One of Rawhide's features is to submit our articles, code samples, and art to a SharePoint Library.
I found two great articles that are helping me out to accomplish my mission. I know there are many ways of doing that, but this is the recommended one by Microsoft and I love it because it has just what I needed and it has code in C# and VB.NET:
Uploading a File to a SharePoint Site from a Local Folder
I also found this page that has all the information I need to work with the SPFileClass.
And finally, I found this interesting blog entry at Bill Simser's blog where he talks about the Syncronization of Office Document Properties with WSS Document Libraries. I haven't tested this yet, but apparently, if you create the following properties in a Sharepoint library or list:
Subject Author Manager Company Category Keywords Comments Hyperlink base "The MS/Office documents that are upload inherit such corresponding custom MS/Office properties : "Subject0 Author0 Manager0 Company0 Category0 Keywords0 Comments0 As soon as I complete my "upload files to SharePoint" features in Rawhide, I will keep you posted with the outcome.
Every file created by a Microsoft Office application supports a set of built-in document properties. In addition, you can add your own custom properties to an Office document either manually or through code. You can use document properties to create, maintain, and track information about an Office document such as when it was created, who the author is, where it is stored, and so on. To get or set the properties you can use automation to extract the Microsoft Office application properties.
Take a look at the following links for samples:
But what happens if you are working with a Web-based application and you want to avoid the use of automation in a Web server…
I found a nice workaround to extract Office document properties without using automation. You can use the Dsofile, an in-process ActiveX component that allows you to read and to edit the OLE document properties that are associated with Microsoft Office files, such as the following: • Microsoft Excel workbooks• Microsoft PowerPoint presentations• Microsoft Word documents• Microsoft Project projects• Microsoft Visio drawings• Other files without those Office products installed
If you are working with a managed application follow the next steps:
You can also extract custom properties using the DSOFile control. Have a peek and enjoy!
This is a common task for ASP.NET developers. You have a Web application where you expose data from a database, Web service, or third-party API and you need an "Export to Excel" button. I have used different approaches to export to Excel from a Web application. Here's some options and guidance of when to use each one.
Note: I can't stop to mention the big no-no… using the Excel PIA to generate a spreadsheet server-side. This is not a good practice and it's not recommended or supported, so let's forget about this one.
Now, for those of you who are working with any of the first three approaches, you may have seen the prompt of file format differ each time you export to Excel.
You get this message because you are opening a file in Microsoft Office Excel 2007 that contains content that does not match the files extension.
I am not very annoyed about this, but I know some people are. By default, a user can decide whether to open the file when the warning message is displayed, but you can control user-notification either:
Here's a KB article that provides detailed steps for both options: When you open a file in Excel 2007, you receive a warning that the file format differs from the format that the file name extension specifies.
Here's a quick code sample in C# for approach 3 (Export from GridView) that you can use to export to Excel. I changed my registry following the steps explained in the previous article and it worked like a charm. No prompt!
Happy Friday!
So you are looking for a component/technology/solution to help you generate Office files (documents, workbooks, and presentations) using a server-side application, and of course, using managed code.
I can tell you that this need has been brought to my attention at some conferences, questions in DLs, customer feedback, and as a common customer requirement when I was working as a consultant. You know that using automation and interop is definitely not an option. However, the Office XML File Formats are a great option.
You can build a server-side application using Visual Studio to generate data-rich documents using the Office XML File Formats and the .NET Framework 3.0 (aka Microsoft WinFX ). Here's how...
In my previous blog entry I demonstrated how to build and Word 2007 template and connect an item in the data store. You built a customer letter document template with content controls that map to an XML file. In this blog entry, I will show you how to create a server-side data-driven document generation application that will allow you to select a company name to generate a custom letter. The application will retrieve customer data from a SQL Server database and use the customer letter document template to build a new document that displays customer data based on a user selection. The document will display the following information:
To create a server-side application that pulls data from a SQL Server database and generates a new Word 2007 document
You can create a Web-based application that enables users to select a company name and generate a custom letter. The Web-based application retrieves customer data from a Microsoft SQL Server database, opens the customer letter document template, and creates a new document that displays customer data based on a user selection. This application does not require the use of Word 2007 or VBA. You can use your favorite managed code (Microsoft Visual Basic .NET or C#) language to build this application. To build this application, do the following:
The following sample shows how to bind to a Microsoft SQL Server database to retrieve data based on a customer selection and create a new document based on the CustomerLetterTemplate.docx.
Learn how to manipulate Microsoft Office system documents using the Microsoft Office Open XML Formats without the 2007 release. Work through scenarios involving programmatically manipulating documents using the Microsoft Office Open XML Formats.
Last week I had a chance to write some interesting code samples. I missed coding a lot, and I felt a little rusty after working in different projects. But I had a lot of fun and I want to share with you one of the samples I wrote: A simple ASP.NET 2.0 solution that retrieves data from SQL Server and generates a Word 2007 document using the Office XML File formats, WinFX, and XML Mappings in Word 2007.
One of the most common requirements for applications that work with data is "data-driven document generation." No matter what the data source is -could be an Access database, SQL database, Web service, SharePoint list, Excel spreadsheet, XML file, Word document, or multiple sources. The typical "export data and create Word documents" feature is a common need.
How to do it? Two simple steps:
Word 2007 allows you to build data-driven document generation solutions. You can create a document template with a custom XML part and use Content Controls to bind to custom XML data using XML Mapping. Next, you can create a managed application to build a new document based on the template. The managed application will open the document template, retrieve data from a SQL Server database to build a new custom XML part, replace the template's custom XML part , and save it as a new document.
This little sample will show you how to build a document template from scratch and create a server-side application that generates documents that display data stored in a SQL Server database. How did I learn to do this, well, believe it or not, I watched the following Office Dev Con session:
CD305—Word 2007 XML Programmability: Data/View Separation and Rich Eventing for Custom XML Solutions
Presenter: Tristan Davis; 59 minutes (180 MB) In this session, we introduce new XML capabilities, then dive into the functionality of the Office XML data store and how it can be leveraged to build solutions that will strongly tie Word documents to your business processes.
..and then asked Tristan Davis some questions related with XML Mapping.
Business Scenario: Custom Customer Letter
To demonstrate how to build and Word 2007 template and connect an item in the data store to a SQL Server database, you will first build a customer letter document template with content controls that map to an XML file. Next, you will create a server-side data-driven document generation application that will allow you to select a company name to generate a custom letter. The application will retrieve customer data from a SQL Server database and use the customer letter document template to build a new document that displays customer data based on a user selection. The document will display the following information:
To create a Word template and define the XML Mappings for each content control.
Use the following steps to create a Microsoft Office Word 2007 template.
1. Open Word 2007.
2. Create a document.
3. Create content controls to bind to a node in the data store.
What are content controls? Content controls are predefined pieces of content. There are several types of content controls, including text blocks, drop-down menus, combo boxes, calendar controls, and pictures. You can map these content controls to an element in an XML file. Using XPath expressions, you can programmatically map content in an XML file to a content control. This enables you to write a simple and short application to manipulate and modify data in a document.
4. Set the XML mapping on the content control.
XML mapping is a feature of Word 2007 that enables you to create a link between a document and an XML file. This creates true data/view separation between the document formatting and the custom XML data. To load a custom XML part, you must first add a new data store to a Document object by using the Add method of the CustomXMLParts collection. This appends a new, empty data store to the document. Because it is empty, you cannot use it yet. Next, you must load a custom XML part from an XML file into the data store, by calling the Load method of the CustomXMLPart object, using a valid path to an XML file as the parameter.
XML mapping is a feature of Word 2007 that enables you to create a link between a document and an XML file. This creates true data/view separation between the document formatting and the custom XML data.
To load a custom XML part, you must first add a new data store to a Document object by using the Add method of the CustomXMLParts collection. This appends a new, empty data store to the document. Because it is empty, you cannot use it yet. Next, you must load a custom XML part from an XML file into the data store, by calling the Load method of the CustomXMLPart object, using a valid path to an XML file as the parameter.
5. Add four plain text content controls in the following order.
6. Save the template document as C:\CustomerLetterTemplate.docx.
To set an XML mapping on a content control
Note In this procedure, you map the content control to a sample custom XML file. You will create a valid custom XML file, save it to your hard drive, and add a data store to the document that contains the information to which you want to map.
1. Create a text file and save it as c:\CustomerData.xml.
2. Paste the following into the text file and save it:
3. Now, map each content control to bind to the <CompanyName>, <ContactName>, <ContactTitle>, and <Phone> and nodes of the previous custom XML part.
4. Open the Visual Basic editor and run the following VBA code to add a data store to your template document.
This sample code demonstrates how to attach an XML file to a document, so that it becomes an available data store item.
To create an XML mapping, you use an XPath expression to the node in the custom XML data part to which you want to map a content control. After you add a data store to your document (and the data store points to a valid XML file), you are ready to map one of its nodes to a content control. To do this, pass a String containing a valid XPath to a ContentControl object by using the SetMapping method of the XMLMapping object (via the XMLMapping property of the ContentControl object).
5. Open the Visual Basic editor and run the following VBA code to bind content controls to items in the data store.
You have your template file and you are ready to start your document generation application. I love ASP.NET and I created a server-side application to show you how to generate documents on the server using the Office XML File Formats. You can build a document generation application using Win Forms, a console application, a shared Add-in or your preferred application depending of your business needs.
If you want to learn more about Word 2007 and document templates, read this article:
This blog entry is too long already, so I will split it here and leave you with the intrigue of what part 2 will bring. Stay connected and you will soon know the happy ending for this walkthrough.
If you are building a .NET application and you are struggling to find a way to host Word documents, Excel spreadsheets, Visio drawings, Project files, or PowerPoint presentations, you might consider using the Visual C++ ActiveX Control for hosting Office documents. I learned about this download resource and I was shocked to see how you can add it to your solution and start working with Office applications in less than a minute. You can open Office applications, format content, update documents, save changes, print, and more inside your application. The Office Framer Control is an Active X control written in C++. The download includes source code to extend the functionality and sample code to use it inside Visual Basic 6 and HTML pages. You can also enable and disable specific functionality by using a full set of properties, methods, and events exposed for customization.
You can also host the control inside managed applications following these simple steps:
One of my favorite features in Microsoft Excel is AutoFilter. I love to manage lists of data in Excel where I can organize, sort, and filter my information in different columns.
Filtering is a quick and easy way to find and work with a subset of data in a range. A filtered range displays only the rows that meet custom filter criteria defined in a search query or fitler specified for a column. Microsoft Excel provides two commands for filtering ranges: AutoFilter and Advanced Filter. Unlike sorting, filtering does not rearrange a range. Filtering temporarily hides rows you do not want displayed. When Excel filters rows, you can edit, format, chart, and print your range subset without rearranging or moving it. You can learn more about autofiltering here: All About AutoFilter.
The best part is that you can programatically generate autofiltered lists from your managed applications thanks to the extensibility offered by the Microsoft Excel Primary Interop Assembly. You can use the Range.AutoFilter method to filter a list using AutoFilter. The following code sample (C# Console Application) generates an autofiltered list of all the directories and files that belong to given directory path. You can modify the code and send any path that you need.
Run this application and give it a try!
If you are into technology, you are mostly going to find documentation in English. However, if you speak another language, it's always useful to find documentation in your own language. I am from Mexico and I am always pleased to find technical documentation in Spanish.
Here is a list of international resources related to Office development that you might enjoy reading…
Parlez-vous Français?…
Office system 2007, c'est bien sûr une avalanche d'innovations, dont une nouvelle interface utilisateur qui facilite la découverte des fonctionnalités. Mais Office system 2007, c'est aussi une plateforme de collaboration et de gestion de contenus, avec laquelle vos applications métiers peuvent interagir.
MSDN: Centre de développement Office et XMLhttp://www.microsoft.com/france/msdn/office/default.mspx
Non parlo italiano, ma potreste
2007 Microsoft Office system è una soluzione avanzata che comprende applicazioni client e server, servizi e strumenti. Costruita sul formato XML e su una serie di tecnologie estendibili, ti consente facilmente di sviluppare applicazioni, dal business content management alla business intelligence, fino al project management e alla collaborazione in tempo reale.
MSDN: Developer Center Microsoft Officehttp://www.microsoft.com/italy/msdn/risorsemsdn/office/default.mspx
Community italiane
Sprechen Sie Deutsch?
Microsoft Office in der Version 2007 bringt einige revolutionäre Neuerungen, z.B. in der Benutzeroberfläche - aber auch in der Art und Weise, wie Entwickler eigene Anwendungen unter dem Dach des weit verbreiteten Office Systems spielen lassen und dabei auf eine reichhaltige Fülle von Funktionen und Funktionalität zurückgreifen können.
MSDN: Developer Center - Office Developmenthttp://www.microsoft.com/germany/msdn/office/default.mspx
Entwickler Communities:
を利用した開発に慣れていない方には、このスクリーンキャストシリーズをお勧めします。Office 開発者 スクリーンキャスト バーチャル ツアーでは 2007 Microsoft Office System を利用した開発を始めるのに必要な学習教材を提供します。
Office Online:http://office.microsoft.com/ja-jp/default.aspx
Viva el Español!
Microsoft Office System es una visión tecnológica que esta conformada por un conjunto de elementos totalmente integrados como: Programas, Servidores, Soluciones y Servicios, que permiten a los desarrolladores construír soluciones de negocios para conectar a la organización y a las personas con la información y los procesos de negocios rápida y fácilmente sobre una plataforma familiar.
Acabo de darme el gusto de escribir algo en español en mi blog. Con todo gusto para la gente que habla español, ahí les van unas ligas que les pueden ser de utilidad:
Artículos interesantes sobre desarrollo con Office: http://www.microsoft.com/spanish/msdn/articulos/architectema/tema/prog_off.mspx
Comunidad Office System
Office Onlinehttp://office.microsoft.com/es-es/default.aspx
Por favor lean este artículo de Luis acerca de colaboración con SharePoint:http://sharepointmx.mvps.org/blogs/ldusolier/archive/2006/06/20/23.aspx
Other worldwide resources:
You can find more worldwide sites and international DLs here:
International Discussion Groups:http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
MSDN Worldwide Sitehttp://msdn2.microsoft.com/en-us/worldwide/default.aspx
Office Online Worldwide sites:http://office.microsoft.com/en-us/worldwide.aspx
I am planning to update this blog entry on a regular basis once I learn more about other resources. If you know about good international Office developer blogs and Web sites, please let me know and I will be glad to trackback.
I have to say it, I had a lot of fun writing this blog entry :).
A couple of weeks ago I blogged about the treasure map for Office developers that we were building and I am glad to announce that we finished two weeks ago the poster version and it's ready to download! This is the third poster of the 2007 Office System Document: Developer Posters download family.
The Developer Map for the 2007 Microsoft Office system helps developers visualize the different programs, servers, services and tools that will help them build solutions. You can drill down to each product and technology and learn about new features, objects, Web services, namespaces and schemas requiered to extend Office. There are more than 50 persons who worked to make this possible with the motivation of building a cool tool to evangelize Office. Based on the fact that Office 2007 is more than you think, we thought this was a great way to help developers understand the bigger picture and learn how Office products and technologies relate to each other.
The goals of this poster are:
BTW, if you have plans to attend Dev Connections in Las Vegas or Tech Ed Barcelona, you should visit the Office booths. We are sending nicely printed copies of this poster. I encourage you to get one (or more) b/c there's a lot of text and it looks better if you print it on a bigger piece of paper.
I can't describe how happy I am because of this poster. I enjoyed working with all the people who made this possible, but what makes me happier is that I know this will help other developers understand quickly what took me months to figure out.
Cheers to Office and the whole galaxy of developer technologies it represents!
Office has a deeper integration with XML technology and developers are always looking for tips and tricks to work with XML documents. Office provides support to work with XML and you might be one of those developers that is programmatically generating Word documents (using WordprocessingML) , Excel spreadsheets (using SpreadsheetML), PowerPoint slides (using PresentationML), or Visio diagrams using (DataDiagrammingML). I think it always comes handy to have a list of tips and tricks to work with XML, and today I will share with you three simple ways of indenting an XML file/document.
Indenting XML files might sound as one of those netpick or nice-to-have enhancements that you don't really need when you are working with XML. However, lots of applications and tools generate programmatically XML files and it always comes handy to open a nice and readable indented XML file instead of a "how can I edit this!" single line of eternal XML elements.
For managed applications:
For any platform:
Happy Office XML programming!
To view the list of Office "12" bloggers from my previous blog entry you must have Microsoft® Internet Explorer 5.01 Service Pack 2 (SP2) or later and the Microsoft Office 2003 Web Components.
For those of you that have a different browser here's the list:
While being at Tech Ed, a lot of people were interested in finding a way to programmatically generate documents without Interop. Some of the business scenarios contemplated generating over 5,000 documents and some IT professionals were interested in finding the best option. A great option to solve this business need is: The Open XML File Formats.
Some people have been following the news and are even ahead of most of us already building solutions to generate documents using the Open XML File Formats. Some other people are not familiar with this technology and want to learn more about this, so here is a quick introduction for those of you who want to learn more about: What is it, and how you can get started. I have to warn you that this is going to be a long blog entry, but I promise it's worth the reading.
What is it?
The new formats improve file and data management, data recovery, and interoperability with line-of-business systems. They extend what is possible with the binary files of earlier versions. Any application that supports XML can access and work with data in the new file format. The application does not need to be part of the Microsoft Office system or even a Microsoft product. Users can also use standard transformations to extract or repurpose the data. In addition, security concerns are drastically reduced because the information is stored in XML, which is essentially plain text. Thus, the data can pass through corporate firewalls without hindrance.
The new Open XML File Formats take advantage of the Open Packaging Conventions, which describe the method for packaging information in a file format and describe metadata, parts, and relationships. The new Open XML Format, with a few minor exceptions, is written entirely in XML and is contained in a .zip file. This creates significant advantages over the old binary file format:
The old binary file format was created when priorities in software differed from the priorities of today. Back then, the ability to transfer a Word document from computer to computer using a floppy disc ranked very high, and the tight structure of a binary format worked well. As software advanced, other priorities became clear, such as the ability to write code against a file format and make it as robust as possible. XML is a clear solution.
Microsoft began to address this issue in previous versions of Microsoft Office by introducing SpreadSheetML and WordprocessingML. However, only now, with the 2007 release of Microsoft Office, have the goals that were conceived as far back as 1999 been accomplished fully. By including the XML File Format inside a ZIP container, the benefit of a small compressed file format is also realized. Excel 2007 and PowerPoint 2007 share this new file format technology, described by the Open Packaging Conventions. Together, the shared formats are called the Microsoft Office Open XML Formats. The new Word 2007 XML Format is the default file format, although the old binary file format is still available in the 2007 Microsoft Office system.
An easy way to look inside the new file format is to save a Word 2007 document in the new default format and then rename the file with a .zip extension. By double-clicking the renamed file, you can open and look at its contents. Inside the file, you can see the document parts that make up the file, along with the relationships that describe how the parts interact with one another. However, it is important to note that, with a few exceptions defined within the Open Packaging Conventions, the actual file directory structure is arbitrary. The relationships of the files within the package, not the file structure, are what determine file validity. You can rearrange and rename the parts of an Word 2007 file inside its .zip container if you update the relationships properly so that the document parts continue to relate to one another as designed. If the relationships are accurate, the file opens without error. The initial file structure in a Word 2007 file is simply the default structure created by Word. This default structure enables developers to determine the composition of Word 2007 files easily.
How can I get started?
The easiest way to modify a Word 2007 XML file programmatically is to use the System.IO.Packaging class in the Microsoft® Windows® Software Development Kit (SDK) for Beta 2 of Windows Vista and WinFX Runtime Components. Using this technology, you can easily update header and footer files programmatically across numerous Word 2007 documents stored on a server.
We published recently some resources that might be of your interest if you are trying to learn more about the Open XML File Formats:
Open XML Snippets Open XML: Get OfficeDocument Part: Given an Open XML file, retrieve the part with the http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument relationship type. Microsoft Office Excel Snippets Excel: Add Custom UI: This snippet adds a custom UI Ribbon part to a given workbook. Excel: Delete Comments by a specific User: This snippet deletes all comments from a given user from a given workbook. Excel: Delete Worksheet: This snippet deletes the specified worksheet from within a given workbook and resets the selected worksheet to the next one on the list. Returns true if successful, false if failure. Excel: Delete Excel 4.0 Macro sheets: This snippet deletes all the Excel 4.0 Macro (XLM) sheets from a given workbook. Excel: Retrieve hidden rows or columns: This snippet returns a list of hidden row numbers or column names from a given workbook and worksheet. Excel: Export Chart: Given a workbook and title of a chart, this snippet exports the chart as a Chart (.crtx) file. Excel: Get Cell Value: Given a workbook, worksheet and cell address, this snippet returns the value of the cell as a string. Excel: Get Comments as XML: Given a workbook, this snippet returns all the comments as an XmlDocument. Excel: Get Hidden Worksheets: This snippet returns a list containing the name and type of all hidden sheets in a given workbook. Excel: Get Worksheet Information: This snippet returns a list containing the name and type of all sheets in a given workbook. Excel: Get Cell for Reading: Given a workbook, worksheet and cell address, this snippet demonstrates how to navigate to the cell to retrieve its contents. The cell must exist for the function to find it. Excel: Get Cell for Writing: Given a workbook, worksheet and cell address, this snippet demonstrates how to navigate to the cell to set its value. If the cell does not exist, the snippet creates it. Excel: Insert Custom XML: Given a workbook and a custom XML value, this snippet inserts the custom XML into the workbook. Excel: Insert Header or Footer: Given a workbook, worksheet and text to insert and a header or footer type, this snippet inserts the header or footer with the given text into the worksheet. Excel: Insert a Numeric Value into a Cell: Given a workbook, worksheet, cell address and numeric value, this snippet inserts the value into the cell. Excel: Insert a String Value into a Cell: Given a workbook, worksheet, cell address and string value, this snippet inserts the value into the cell. Excel: Set Recalc Option: Given a workbook and a RecalcOption, this snippet sets the recalculation property to the new option. Microsoft Office PowerPoint Snippets PowerPoint: Delete Comments by User: Given a presentation and a user name, this snippet deletes all comments by that user. PowerPoint: Delete Slide by Title: Given a presentation and slide title, this snippet deletes the first instance of a slide with that title (titles are not unique). PowerPoint: Get Slide Count: This snippet returns the number of slides in a given presentation. PowerPoint: Get Slide Titles: Given a presentation, this snippet returns a list of the slide titles in the order presented. PowerPoint: Modify Slide Title: Given a presentation, old slide title, and new slide title, this snippet changes the first instance of a slide with the given title to the new value. The snippet returns true if successful, false if not successful. PowerPoint: Reorder Slides: Given a presentation, an original position, and a new position, attempt to place the slide from the original position into the new position within the deck. If the original position is outside the range of the number of slides in the deck, use the last slide. If the new position is outside the range of slides in the deck, put the selected slide at the end of the deck. The snippet returns the loctation wher the slide was placed, or -1 on failure. PowerPoint: Replace Image: Given a presentation, slide title and image file, this snippet replaces the first image on the slide with the given image. PowerPoint: Retrieve Slide Location by Title: Given a presentation and a slide title, this snippet returns the 0-based location of the first slide with a matching title. Microsoft Office Word Snippets Word: Accept Revisions: Given a document and an author name, this snippet accepts the revisions by that author. Word: Add Header: Given a document and a stream containing valid header content, add the stream content as a header in the document. Word: Convert DOCM to DOCX: Given a macro-enabled document (.docm), this snippet removes the VBA project and converts the file to a macro-free Word Document (.docx). Word: Remove Comments: Given a Word Document, this snippet removes all the comments. Word: Remove Headers and Footers: This snippet removes all headers and footers from a given Word document. Word: Remove Hidden Text: This snippet removes any hidden text in a given document. Word: Replace Style: Given a document and valid header content, this snippet adds the content as a header in the document. Word: Retrieve Application Property: Given a document name and an app property, this snippet returns the value of the property. Word: Retrieve Core Property: Given a document name and a core property, this snippet returns the value of the property. Word: Retrieve Custom Property: Given a document name and a custom property, this snippet returns the value of the property. Word: Retrieve Table of Contents: Given a document name, this snippet returns a table of contents as an XmlDocument. Word: Set Application Property: This snippet sets a property's value given a document name, application property and value. The snippet returns the old value if successful. Word: Set Core Property: Given a document name, a core property, and property value, this snippet sets the property value. Word: Set Custom Property: Given a document name, a custom property, and a value, this snippet sets the property's value. If the property does not exist, create it. Returns true if successful, false if not. Word: Set Print Orientation: Given a document name, this snippet sets the print orientation for all sections in the document.
Open XML Snippets
Microsoft Office Excel Snippets
Microsoft Office PowerPoint Snippets
Microsoft Office Word Snippets
Download them here!
Finally, if you want to stay current with new resources to work with the Open XML File Formats, go to the XML in Office Developer Portal. We launched this portal recently to create a special section of the MSDN Office Developer Center where you will find bloggers, technical articles, code samples, developer documentation, and multimedia presentations on working with XML in Office.
The Open XML Format allows you to generate, manipulate, or pull data from Word 2007, Excel 2007, and PowerPoint 2007 files. If you are working with Microsoft-based solutions, you can generate, manipulate, and pull data from documents using the following tools and technologies:
Note: If you are working with Java or PHP/Linux/Unix/Solaris, you can also find plenty of resources here and here.
Anyway, today I want to focus on a couple best practices for getting started with coding for Open XML Format SDK 2.0.
For the last couple of months I have been working with some Open XML gurus: Zeyad Rajabi, Linda Lanqing Brownell, Eric White, Joel Krist, and Ken Getz. We are working together on a new set of Visual How-tos for the Open XML Format SDK 2.0 and a set of 50+ code snippets for Visual Studio 2008 to be released soon on MSDN.
Quite frequently I hear from most of them a couple best practices that I'd like to share with you today: If you plan to build a solution using the Open XML Format SDK 2.0…
The very first thing we recommend you to do before you start writing code for a document solution, is to create the template. Depending on what kind of solution you want to build, you can use Word 2007, Excel 2007, or PowerPoint 2007 to create a template.
Imagine that you own a software company and you sent all your developers and consultants to the great Office and SharePoint sessions at TechEd this year. The end of the fiscal year is coming soon and you need expense data from each conference attendee ASAP. Developers and consultants plan to spend this weekend on New Orleans, so you ask them to fill out a Web-based Expense Report form that sends data to your company's accounting database. Your accountant loves Excel 2007 and she asked you to export all expenses per/employee to Excel spreadsheets so she can review details before approving. CSV export won't do this time because your accountant wants it all pretty and styled. You want to figure out a way of programmatically generate the Expense Report spreadsheets by pulling data from your accounting database. You need styles and formatting as well. After evaluating lots of tools and technologies, you decide that you want to build this solution using the super cool Open XML Format SDK 2.0. Now what?
The very first thing we recommend you to do before you start writing code is create the template using Excel 2007. You may ask your accountant to design the Expense Report template using Excel 2007, or you can always download tons of great templates from Office Online. Here's my sample expense report template:
Open the template using Excel 2007 and add some dummy data. Don't forget to save the template as Excel Workbook file (.xlsx). Now that you have a template to start with, you can start coding the solution.
The Open XML Format SDK 2.0 download ships with a set of tools that facilitate the process of building document solutions using the SDK. One of this tools is the DocumentReflector. This tool has the ability to open an existing Open XML document and dynamically generate C# source code that uses the Open XML SDK 2.0 typesafe classes to create the document parts. Exploring the source code created by DocumentReflector is a great way to become familiar with the Open XML SDK 2.0 classes and the Office document formats. Zeyad refers to this tool as the "Macro Recorder on vitamins" and I can tell you it rocks! The main idea is that once you have a solution template, you open it using the DocumentReflector and you get a set of autogenerated classes that you can later modify with Visual Studio 2008.
To illustrate using the DocumentReflector to create the base code for the Expense Report solution, follow the next steps:
At this point the code generated by DocumentReflector can be copied and pasted into the Visual Studio solution for reuse and learning purposes.
For testing purposes, you can create a Console application in Visual Studio 2008. Here are some generic steps:
6. Select the code for all of the methods inside of the GeneratedClass class from the DocumentReflector code window then copy and paste the code as methods of the Program class in the Program.cs file in the Visual Studio project.
7. Change the copied CreatePackage method to be private static so it can be called from the static Main method.
The AddParts method creates all the parts that you need in the Expense Report spreadsheet.
The GenerateSharedStringTablePart1() method contains the code that you need to create values for the table on the Expense Report. You can modify this code to iterate through the accounting database. You can pull expense report data by employee and replace the dummy data you entered.
7. Modify the Main method and add a call to the CreatePackage method.
Opening the workbook with Excel will display a workbook that looks just like the ExpenseReport.xlsx workbook created previously.
If you are looking for more end-to-end solutions using the Open XML Format SDK 2.0, you must see this articles:
Also, as mentioned before, Brian's/Zeyad's blog and Eric's blog are always a great resource for Open XML code samples.
Coming soon the set of Open XML Format SDK 2.0 VHTs and code snippets for Visual Studio 2008!
Have you ever thought about all the data that is stored in Microsoft Office Excel workbooks around the world? Excel workbooks are an extraordinary data store, but they also offer great potential as a resource of dynamic information that can move across data-management workflows and business processes.
The previous paragraph was stolen from my last column. Of course, when I wrote this article I was not thinking about some other cool and interesting data that you can store in Excel workbooks. My mind is set to think about Office programs as work-related applications and I am always thinking about ways that will help developers discover cool features (such as SpreadsheetML) to solve business problems. I sometimes forget about all the fun that applications like Excel can provide.
The 2006 Fifa World Cup is starting this month, and some people are starting to create Excel templates that can help you keep track of the results of the game matches for you.
You can download the 2006 World Cup Tracker. An Excel template published recently on Office Online (English version).
I am also attaching a very cool Excel workbook (Mundial 2006) that my friend Juan Balmori from Mexico shared with me. This Excel workbook helps to track game statistics and is a great option if you are looking for a template in Spanish.
Also, Franck Halmaert, the Office PM in France, sent me this great link for a French version.http://blogs.microsoft.fr/franckha/archive/2005/12/26/16932.aspx
Have fun watching the games and forget about work for a while :).
Videos are great eye candy for Web sites and blogs are the latest .com most popular content. So now imagine having them together. According to WIKIPEDIA, a blog that includes video is better known as Vlog and vlogging is the latest trend in blogging.
The reason is simple: a lot of people love videos. It's a pleasure watching something funny or learning tricks while watching and listening to a demo. You are seeing and listening to the world and it's just taking what you can read somewhere a step further.
Watching Webcasts, trying out Virtual Labs or downloading Screencasts will help you to reduce your learning curve for new technologies and MSDN is on top of it. The same happens with blogs. If you post code samples to your blog, you might consider trying to record a demo as a video and post it. Readers will get a better experience because they will get to see what the code is doing.
I have been doing some research and here are some tips I want to share in case you are interested in exploring the concept.
To start creating my own videos and I needed two things:
I just got my license for Camtasia (and I promise nobody is paying me for the free marketing). I did my benchmark exercise to evaluate this software along with some others, and Camtasia offered the features I needed. You can consider it as a good option if you are planning to start recording demos. Of course once you record the video, you need to post it to a server so everyone can watch it.
So here's the deal. You can have different video formats, such as:
I am interested in working with WMV files and using Windows Media Player client to embed videos into Web pages. Fortunately, there's and ActiveX control (WMPlayer.OCX) that you can use through script. Bad news is some blog sites will not allow you to run scripts and you will be limited to use HTML. One thing you can do is create an html page, host it in a different server (a lot of bloggers do the same with images) and use an IFrame to pull the video page to your blog. Here is some sample code that you can use to embed videos into HTML pages:
If you use the previous code and an IFrame, videos in your blog can look like this:
This KB article has code samples to embed videos using VBScript or Jscript and here are some useful resources for working with the Windows Media Player object model and downloading the latest version:
Happy Vlogging!
We have great news for all Open XML developers who have waited so patiently for the fully supported release of the Open XML Format SDK 1.0. Today we published the final bits and online documentation on MSDN. You can get the SDK from the following locations:
I talked about this before in previous blog entries, but for those of you who are not familiar with this SDK, here's a brief intro.
The Open XML Format SDK Technology Preview simplifies the task of manipulating Open XML packages. The Open XML Application Programming Interface (API) encapsulates many common tasks that developers perform on Open XML packages, so you can perform complex operations with just a few lines of code. Using this API, you can programmatically generate and manipulate Word 2007 documents, Excel 2007 spreadsheets, and PowerPoint 2007 presentations. The programming model uses managed code, so it's safe for server-side scenarios.
The Open XML Format SDK also provides how-to articles and reference documentation that can help you get started with Open XML programming.
The Open XML Format SDK 1.0 contains the changes described below:
Renames the Microsoft.Office.DocumentFormat.OpenXml dll to DocumentFormat.OpenXml
Renames the Microsoft.Office.DocumentFormat.OpenXml.Packaging namespace to DocumentFormat.OpenXml.Packaging
Renames the Microsoft.Office.DocumentFormat.OpenXml namespace to DocumentFormat.OpenXml
Adds support for validating by using the XmlSchemaSet object
If you have written code using previous CTP releases, keep in mind that the first three are breaking changes. You need to delete the current reference to the Microsoft.Office.DocumentFormat.OpenXml.dll and replace it with DocumentFormat.OpenXml.dll. Also, you need to change the namespace references to DocumentFormat.OpenXml.Packaging and DocumentFormat.OpenXml.
The last change has to do with a common ask from developers. Previous releases of the CTP allowed you to validate the contents of a part in an Open XML Package against a single schema file. However, it was not possible to validate against a collection of schemas. The Open XML Format SDK 1.0 provides an overloaded method of the ValidateXml method that allows you to validate a document part against a specific XmlSchemaSet object. The following sample code shows you how to validate the XML content of the MainDocumentPart part of a WordprocessingDocument package by calling the ValidateXml method of MainDocumentPart part. You pass a list of schemas to the ValidateXml method as an input parameter.
While looking at the class diagram, I noticed that the latest version includes support for a new MailMergeRecipientDataPart. You can find detailed info about this new part here. Some other minor object model changes are documented at the readme.htm file of the download.
Finally, we significantly improved the comments/descriptions of all the members included in the class reference documentation and Intellisense file. It's easier to learn how to use an API when the comments and member descriptions are in good shape.
The Open XML API Version 1.0 is included with the Open XML Format SDK 1.0 and only contains the Open XML Packaging API. Open XML API Version 2.0 releases should contain all of the Open XML API components, including the Open XML Packaging API with further updates. In the next months, the Open XML Format SDK product team will be releasing CTPs of the Open XML API Version 2.0.
As I mentioned earlier, the latest version has some breaking changes, so the MSDN team is also planning to update the code and content of the Open XML Format SDK related articles such as:
I recommend that you continue to monitor the following blogs for more news about the Open XML Format SDK:
More code samples: OpenXmlDeveloper.org site
You can also watch Zeyad's and Eric's interview to learn more about the future of the Open XML Format SDK.
Please continue to use the following two resources to ask questions to the product team and provide feedback :
It all started with a few bloggers a little before Beta 2. People started blogging about the Ribbon, the cool ASP.NET 2.0 platform and WSS 3.0, Excel Services, the Office Open XML File Formats and InfoPath Forms Services. Lots of great features to build solutions using Office as a platform!
Office development blogs are quite active and inviting for developers trying to learn what's new with the Microsoft Office system and diving more into specific products and technologies. When all this started, I added RSS feeds every week to Outlook until it became just a joke to have so many bloggers added to my RSS feed. There's hundreds if not thousands of people blogging about Office development and every day new blogs are born. I built a new list of Office development bloggers and a few days before launch, my list adds up to 70!
Blog Name
#region /* mads's thoughts */
[XaMaLa] - Le poste de travail, un gisement de productivité encore peu exploité
A discussion of what's new in Access 2007
About OneNote
Andrew May's WebLog
Andy Simonds Blog
Arpan Shah's Blog
ArtLeo's WebLog
Bill Morein's Weblog
Brian Jones: Open XML Formats
Building Office Business Applications
Chris Castillo's WebLog
Chris Pratley's OneNote Blog
Chris's unofficial Office Live developer blog
Clint's Access blog
Coding for Office Small Business Accounting
Cum Grano Salis
doncampbell's weblog
Doug Mahugh
Erika Ehrli
Evil Doctor PorkChop
Fabulous Adventures In Coding
frice's WebLog
InfoPath Team Blog
Jan Tielens' Bloggings
Jensen Harris: An Office User Interface Blog
Joe Friend: Microsoft Office Word
John R. Durant's WebLog
Julie's Blog
Kevin Boske - Office Development
Larry's Project Dev Blog
LauraJ's Weblog
Microsoft Excel 2007 (nee Excel 12)
Microsoft Office PowerPoint
Microsoft Office Project 2007
Microsoft SharePoint Products and Technologies Team Blog
Microsoft Small Business Applications
Microsoft Visual Studio Tools for the Microsoft Office System
Microsoft Visual Studio Tools for the Microsoft Office System, Version 2003
MikeKelly's WebLog
Misha Shneerson
Murray Sargent: Math in Office
Office Rocker!
Office SharePoint Document Services (ECM)
On Microsoft Publisher and more
Outlook 12
Owen Braun: OneNote 12
Pashman's InfoPath Goldmine
Patrick Smith: Office Programmability
Patrick Tisseghem's Blog [MVP SharePoint]
Project Programmability
Project Server 201
Rob Mauceri's FrontPage Blog
Ryan's Look at Outlook Programmability
search.subscribe.share in outlook 2007
SGriffin's [MSFT] WebLog
SharePoint Content and Resources
SharePoint Products and Technologies - Pointing to Share the Knowledge
SharePoint Unplugged
Tasks and Time Management in Outlook
The Microsoft Office Word Team's Blog
The wonder that is the Microsoft Office system
Third Of Five - just another voice in the Collective
Visio 12 - Eric Rockey
Westin's Technical Log
Windows Sharepoint Services etc.
Wouter van Vugt
When I started posting lists of bloggers someone suggested that I should build an OPML list of Office Development Bloggers, so I did. You can download the OPML file here:
You can use Outlook, Windows Live or other OPML readers to open this file and add your favorite RSS feeds.
MSDN blogs: pending to add!
How could I leave them out: Kathleen McGrath, Paul Stubbs, and the new Microsoft SharePoint Designer Team Blog
Pranav's blog: You should check this one out, I hate me for not finding Pranav's blog before: This blog is all about Office Automation, VSTO, InfoPath and other programming stuff and the thing i believe on is "Real Stuff is Out Of The Box."
New blogs:
Make sure you check out Rob Barker's: Where in the "OBA" am I? and his first post.
I am sure there's more blogs out there that I didn't list here. If you have an Office development blog or know of great bloggers that talk about VSTO, SharePoint, WSS or anything else related with Office, please let me know so we add them to the list. You don't need to have an MSDN or TechNet blog, you only need to be passionate about development with Office products and technologies. The list keeps growing every day.
Community blogs: pending to add!
Steve Ballmer announced yesterday the business availability of Vista, Office and Exchange. This means that businesses can deploy and start developing solutions that integrate these three products. You can read the executive e-mail here and you can watch the Webcast here. In case you are wondering, the consumer launch is scheduled for 1/31/2007. Microsoft also launched the Vista + Office PowerTogether site.
So you have the products and it's always useful to find information that can help you get started. I compiled my top ten 14 list of resources for architects and solution developers that plan to start building solutions using the 2007 Microsoft Office system (including SharePoint of course) and VSTO.
Overwhelming? Yes, can be a lot of information if you are just entering the Office development zone. But once you start diving every site and hunting for resources you'll see it's not enough. We still have lots of code samples to build and technical articles to write. Lots of fun stuff is still scheduled in our queue.
You should check this out! Imtiyaz Mubarak (a developer, Microsoft Parter, and friend from India) along with Chris Castillo from the Visio team created and published a component that provides a Visio Add-In and a Project Add-In that integrates Visio 2003, Project Server and MS SharePoint Server. This component allows you to:
This component is published in GotDotNet and it's really cool. This is the kind of stuff that solves business needs and I love that it integrates different Office technologies. I am sharing with you the link where you can download the solution along with source code and a document that explains the architecture and code.
This is good stuff!
We have been saying everywhere that "the Microsoft Office System is a complete set of client applications, servers, and services that provide organizations with the means to create, manage, and enhance business solutions." We have also published a full load of content for every product since Beta 2. Yet, we realize that as a developer, sometimes it's hard to understand the big picture and how all the little pieces (features and product specifics) can work together to help you build a real-world solution.
Office is a huge family of products and technologies and we have been working with all product teams to create an overall map that helps developers to visually understand how all the pieces of the puzzle relate to each other, but more important, provide information of where on MSDN you can find technical documentation related to specific features. We want to go deep to namespaces, class members, and schemas for each product to list them all together on a single place.
As you can imagine, space is a huge limitation. While trying to put all this together, I happen to agree with the "Microsoft 2007 Office system – It's more than you think" slogan. Office is HUGE and there's limited space to place all PIA objects, namespaces, web services, product features, schemas, names, descriptions and relationships for more than 25 products and technologies. However, we have found a great way to summarize the most relevant ideas and make it fit all together.
I can share with you that I have found the exercise to be fascinating. Just imagine how much fun we've had having on a single meeting room PMs for all product teams + Developer Platform Evangelism + Marketing + Office Developer Documentation group and work together as a team to build the treasure map.
We are about to conclude this project, but in the meantime, I just couldn't wait to share with you a small version of our treasure map. I built this conceptual diagram using PowerPoint 2007 and then generated an image map that provides links to places on MSDN and Microsoft.com. You can hover the map and drill-down to find detailed information for each product and technology. Of course, this is a petite version, but soon, you'll get the complete treasure map.
So here goes...
If you are interested in learning about Microsoft Office Excel 2007 features that affect XLL add-ins and enable new XLL functionality, as well as changes to the XLL C API itself, we just published a great article by Steve Dalton that will help you get started.
The intended audience for this article consists of Microsoft Visual C and Microsoft Visual C++ developers who already have experience developing Microsoft Office Excel add-ins, or XLLs. This article is not an introduction to XLL development although a brief overview is included. To make the most of this article, readers should be familiar with:
Read the article here: http://msdn2.microsoft.com/en-us/library/aa730920.aspx
We are glad to announce that the Open XML Format SDK April CTP is available!
You can download the new SDK from here:
You can also find and online version of the SDK on the MSDN Library:
Also, you can find permanent links to both the download and online version at the XML in Office Developer Portal and at the Office Open XML Formats Resource Center.
For those of you who are not familiar with this SDK, here's a brief intro.
For those of you that have been working with the June 2007 CTP, here's a brief list of what's new with the April CTP:
Product names and editorial changes
1. The name of the SDK is "Open XML Format SDK" instead of "Microsoft SDK for Open XML Formats."
2. We changed all references of "Open XML object model" to "Open XML Application Programming Interface (API)."
API Changes
This release also includes support for cool C# 3.0 and VB.NET 9.0 features, such as LINQ Annotations.
If you want to see more detailed information, see What's New in the Open XML Format SDK April Technology Preview.
The Open XML API will release in two versions. Open XML API Version 1.0 is the updated version of the CTP in June 2007 and will only contain the Open XML Packaging API. Open XML API Version 2.0 will contain all of the Open XML API components, including the Open XML Packaging API with further updates. It will enforce validity of the content either in the original Open XML documents or being generated through this API. The purpose of this plan is to give out the long awaited Go-Live license of the existing Open XML Packaging API to external developers.
The April 2008 CTP release has improvements based on customer feedback provided by the field and MVPs.
For the May 2008 release of the Open XML API Version 1.0, we also plan to incorporate customer feedback to improve the SDK. If you have comments about the API or documentation, please use the following two resources:
I recommend you monitor the following blogs for more news about the Open XML Format SDK:
Have fun with the April CTP!
The Office Developer Documentation group has published over 270 articles since the RTM of the 2007 Microsoft Office system. The team has also published 152 downloads, and 153 videos. That is a lot of content! The MSDN Office Developer Center has many portal pages that help promote these content items by product or by content type. It really is challenging to add so much content to a portal! With all that new content, one of the biggest challenges is making sure we keep promoting Office 2003 content.
Coming from the field, I really understand that lots of companies are still using Office 2003, and as a developer, you may be faced with the need to find Office 2003 developer resources. The MSDN Office Developer Center has multiple Office 2003 resource pages organized by product and by content type. I thought you might enjoy having an interactive site map with links to all Office 2003 content resource centers on MSDN, so I built one for you:
I almost forget about Project 2003! Here are the links:
Speaking of interactive maps, you should check out the new interactive map with free Christmas images build by the Office Online Clip Art team.
Another cool blog to check out is the new Microsoft SharePoint Developer Documentation team blog.
I gathered a list of common Open XML questions related to programmability:
When you are trying to create a document assembly solution and you are want to understand how you can use the Open XML File Formats to generate a document programmatically, you may be faced to some of the previous questions. All this questions have been answered in multiple MSDN articles, SDKs, blogs, trainings, forums, and newsgroups. However, I am the kind of person that loves end-to-end documentation and code samples that take you from zero to a working solution. We all have limited time to learn new technologies and walkthrough articles and code sample downloads are always a nice option.
Some time ago I tried to do the same thing and I blogged to show you how to generate a document using a document template, content controls, and XML mapping. I also created a little video and article that shows how to bind custom xml to a document template. This approach is great when you are trying to replace placeholder data in document templates like an invoice or contract. However, your business needs may be different and you may want to have more control over document content and formatting. In that case a better approach would be to manipulate the WordProcessingML content stored in different document parts.
I wrote a new article that helps answer the Open XML questions listed in this blog entry. I split the article in two parts and a code sample download. I start by discussing all the theory and basic concepts you need to learn to work with the Open XML File Formats. For example, I talk about Open XML Package Architecture, WordprocessingML basics, the Open XML object model, and the conceptual architecture of a document integration solution.
The second part explains all the coding that needs to happen to generate a simple sales document from scratch. I show you how to deal with images, tables, styles, and formatting. I also show how to create a helper class that pulls data from your line of business systems (in this case the AdventureWorks sample database to keep the LOB piece as simple as possible), and a helper class that uses the Open XML object model and WordprocessingML to create a document.
You can find the articles and code samples here:
Many thanks go to Doug Mahugh, Wouter van Vugt, and Frank Rice for sharing all their knowledge and helping me put this together. I hope this helps you get started with custom document generation with Open XML.


text:
Change Location:
New Customers: 1-877-279-7585
Existing Customers: (562) 423-0973
Up to 10% Off
& Half Off First Month †
Free Moving Truck with Rental
Call for availability
Office & Service Hours:
Monday-Friday: 9:30 AM-6:00 PM
Saturday: 8:30 AM-5:00 PM
Sunday: 11:00 AM-3:00 PM
Storage Gate Hours:
Monday-Sunday: 6:00 AM-10:00 PM.
Choose from small, medium, large, and parking spaces; no credit card required.
Can't find the size you're looking for? Try one of these nearby locations:
5951 Firestone Blvd
South Gate, CA 90280
3 Parking Spaces Available
5.8 Miles from Current Selection
1305 N. Gaffey Street
San Pedro, CA 90731
2 Parking Spaces Available
9.57 Miles from Current Selection
December 12, 2014
I'm from Canada. Shipped my motorcycle to CubeSmart. Awesome service.. They accommodated all my needs in a timely and efficient way.. These guys rock....
November 26, 2014
Very pleased with this location, been a customer with them for years. Service is beyond my expectations, and I am very happy.
October 5, 2014
Best price in my area for a 10'x10', great customer service
October 3, 2014
Today I received great customer service from Lance, Laterra, and edith today. Thank you
May 15, 2014
The location is whats best, in my opinion. The gates remains open late. The Area is well lit, although the lighting should be upgraded to really illuminate the darkest areas. All in everything the facilities are up to par with all my personal needs. Thanks.
May 13, 2014
Staff is friendly and accommodating. I've had my stuff in storage for a year now. Everything is safe and sound.
February 8, 2014
Great experience so far. I have been treated very friendly by managers and staff. Thank you for giving me peace of mind that my storage area is safe!
October 30, 2013
I recently received a rate increase notice from CubeSmart effective November 2013. In talking with the General Manager, Teresa "Reese" Whitten, she went to bat for me & got the rate increase cancelled. I have been a customer for only 15 months & I appreciate Reese going that extra mile for me. The staff at the West Artesia Blvd. location is very accommodating & good to their customers. Thank you, Reese. From a loyal l& happy customer, Maria Maguire, Space S004 at the Long Beach, CA CubeSmart storage location.
September 22, 2013
Sales associates were very helpful and friendly. Larry made sure we got our unit and got the complementary truck when we need to move into the storage unit. and rental price is very reasonable compared to other locations.
July 21, 2013
nice costumer service nice place next to the freeway
July 2, 2013
Feature 1 - Free Use of Truck to Move your Belongings Feature 2 - Insurance options/costs disclosed Upfront Feature 3 - No Hidden Fees Feature 4 - High Quality Locks Provided at Low Prices Feature 5 - Green Business Process - nearly paperless
This Long Beach storage facility is servicing the following areas:
Rancho Dominguez
The CubeSmart storage building located at 198 West Artesia Boulevard, Long Beach offers storage solutions for the following service areas:
90221 Storage · 90805 Storage · 90220 Storage · 90223 Storage · 90224 Storage view all
90723 Storage · 90222 Storage · 90746 Storage · 90807 Storage · 90262 Storage · 90711 Storage · 90712 Storage · 90714 Storage · 90810 Storage · 90059 Storage · 90706 Storage · 90707 Storage · 90248 Storage · 90280 Storage · 90242 Storage ·
Find All Storage Facilities Located Closest to Long Beach, CA:
Compton Storage · Paramount Storage Units · Storage Facilities in Carson · Lynwood Storage · Lakewood Self Storage view all
Storage in Los Angeles · Bellflower Storage Facilities · Gardena Storage · South Gate Storage Facilities · Storage Facilities in Downey · Torrance Self Storage · Self Storage in Bell · Wilmington Storage Facilities · Self Storage in Bell Gardens · Huntington Park Storage · Self Storage in Mount Wilson · Self Storage in Verdugo City · Industry Self Storage · Norwalk Storage · Storage in Harbor City ·