SharePoint Cross Site Word Document Properties

Recently I had a project where I was using SharePoint columns as document property fields in MS Word.  This is pretty straight forward when you have one library and some files but when you have a central repository of master files that are then pushed out to different sites across your farm it makes it a little more interesting.  We built our content types and columns in Visual Studio which were deployed on all sites and thus had the same contenttypeid’s and column guids.  One thing I noticed was that in the master library the document field would work correctly but once the file was copied to another site the document field would no longer work.  I was unable to find anything on the web about this scenario which is why I’m posting my findings here.

First thing I did was to open the copied file in one of the non-master sites and fix the field.  I just deleted the old one and re-added it and everything was fine.  Next I renamed both the fixed document and the master document to have a .zip extension.  This enables me to extract the contents of the word file so I could examine the differences.  What I found was that in the word\document.xml file where the document fields were inserted they had different GUIDs for the ns3 namespace attribute (see on line 21).  Also check out the xpath statement on line 23 and then notice how the namespace (ns3) for our document field (ProjectName) is the namespace where we have different GUIDs between the two documents.

<w:sdt>
	<w:sdtPr>
		<w:rPr>
			<w:b/>
			<w:smallCaps/>
			<w:snapToGrid w:val="0"/>
			<w:sz w:val="18"/>
		</w:rPr>
		<w:alias w:val="Project Name"/>
		<w:tag w:val="ProjectName"/>
		<w:id w:val="-1780325992"/>
		<w:lock w:val="sdtContentLocked"/>
		<w:placeholder>
			<w:docPart w:val="1BC5893A50C54E06B3DBC32132B17E14"/>
		</w:placeholder>
		<w:showingPlcHdr/>
		<w:dataBinding 
			w:prefixMappings="xmlns:ns0='http://schemas.microsoft.com/office/2006/metadata/properties' 
			xmlns:ns1='http://www.w3.org/2001/XMLSchema-instance' 
			xmlns:ns2='http://schemas.microsoft.com/office/infopath/2007/PartnerControls' 
			xmlns:ns3='b5fc2735-42dd-40f0-a521-255c535f6692' 
			xmlns:ns4='cb6c538f-4b29-4910-832a-74df7c62e784' " 
			w:xpath="/ns0:properties[1]/documentManagement[1]/ns3:ProjectName[1]" 
			w:storeItemID="{59580BC9-FAD5-4EB7-BF24-59B00B2B217C}"/>
		<w:text/>
	</w:sdtPr>
	<w:sdtEndPr/>
	<w:sdtContent>
		<w:r w:rsidR="00556E42" w:rsidRPr="00920EC6">
			<w:rPr>
				<w:rStyle w:val="PlaceholderText"/>
			</w:rPr>
			<w:t>[Project Name]</w:t>
		</w:r>
	</w:sdtContent>
</w:sdt>

So following a hunch I looked up the SPWeb.ID and sure enough, it was the same GUID as ns3.  So, when copying documents from one site to another, the document field xml data from SharePoint must be tied to the GUID of the site it came from.  I was able to verify this by looking at the customXml\item1.xml file (it’s always makes things a lot easier to be able to view your xml data when working with xpath queries) which showed all of my document fields coming from SharePoint and they all had a namespace of the SPWeb.ID GUID.

Since the namespace will be changing every time I copy the file I decided to update the xpath query to ignore the namespace.  Changing it from:

w:xpath="/ns0:properties[1]/documentManagement[1]/ns3:ProjectName[1]"

to:

w:xpath="/ns0:properties[1]/documentManagement[1]/*[local-name() = 'ProjectName'][1]"

This xpath trick will query only based on the name of the element and exclude any namespaces.  Sure enough, once I updated the file in my master site and did another copy down to a non-master site, the field updated correctly in word and everything was happy.  You can update the document.xml file using any text editor you’d like, and then just zip all of your files back up, and then rename the file to be a .docx and it should open correctly in word.

Microsoft Band 2 vs Fitbit Surge

Last year I was debating between the Microsoft Band or the upcoming Fitbit Surge.  After trying on the band at the Microsoft Store, I was not happy with how it felt on my wrist so I decided to go with the Surge.  I’ve been using a Fitbit Surge everyday for most of the past year.  For a fitness tracker with GPS, the Surge has been fantastic but I wanted some smartwatch features as well.

After trying on the new Microsoft Band 2 at the Microsoft Store, I decided to get that one to replace my Surge.  Here are my current thoughts on the Band 2 compared to the Surge.

Phone Compatibility

The Band 2 works with Android, iOS and Windows Phone but the Cortana (voice) integration isn’t available on Android and iOS,only on the Windows Phone and the onscreen keyboard isn’t available on iOS.

View Time and steps (secondary display item is configurable)

I have been using it with my Lumia 950 Windows Phone (see post here).  The Fitbit Surge also works on Android, iOS and Windows Phone but some things didn’t work on the Windows Phone like phone/text notifications and music controls.  I used my Surge mainly on a Windows Phone but my wife has been using it on her iPhone recently.

 

Same features as Fitbit Surge

Heart rate monitor

 

  • Displays the time and date
  • Tracks steps, calories burned, distance, floors, heartrate
  • GPS tracks runs
  • Tracks other workouts with heartrate like the elliptical
  • Alarms, timer, stopwatch

Pros over Fitbit Surge

  • More notifications

    See full text messages, email partials, and my upcoming calendar

    • Phone (Improvement for Windows Phone only)
    • Text (Improvement for Windows Phone only)
    • Email
    • Facebook
    • Facebook Messenger
    • Calendar Reminders
  • Control music (Improvement for Windows Phone only)
  • Reply to texts and phone calls
    • Up to 4 quick responses (with automatic detection of a question and showing yes and no as additional quick responses)

      The small keyboard used to reply to texts works surprisingly well

      The small keyboard used to reply to texts works surprisingly well

    • Small keyboard to reply to text messages, which works surprisingly well (Windows Phone and Android only)
    • Cortana voice dictation to reply to text messages (Windows phone only)
  • See weather, news, and calendar
  • Use Cortana to initiate reminders, texts, calls, etc. (Windows phone only)
    • I can even ask questions like “How old is j-lo” and the answer shows up on the band screen.

      Cortana - "How old is J Lo?"

      Cortana – “How old is J Lo?”

  • See last exercise and sleep
    • On the fitbit this was only available to view using the app or the website, not on the watch itself
  • Sleep cycle alarm to wake you up, up to 30 mins before scheduled alarm
  • Prettier design and user interface
    sleep

    A lot better sleep stats compared to Fitbit

    • Lots of people have mentioned that the Band 2 is a MUCH prettier watch than the fitbit surge.
    • The fitbit surge is large and looks big on my wife where the band 2 would look fine on a male or a female
    • The fitbit surge had a basic black and white interface whereas the band 2 is colorful and dynamic.
  • Less bulky
    • Fitbit would get caught when tucking in my shirt, taking off my jacket, or putting on my backpack
  • Auto detected sleep mode or manual
    • Manual is nice because it also turns off watch mode and notifications other than the watch alarms.
    • Tracks how long it takes to go sleep.
  • Watch mode
    • Off
    • Always on
    • Rotate
  • Lots more settings right on the watch, the fitbit had very few settings on the watch itself and was mostly configured using the app or website.
    • Vibrate
    • Dim

      Turning my wrist over turns on the low power watch mode for a few seconds

  • Tile and color settings using phone
    • I can even create my own background pictures or download some to the device using additional apps
  • More info can be seen while during an activity
    • The fitbit displayed a few pieces of data but that data wasn’t customizable.  Any additional data I had to swipe through at the bottom of the screen.
    • The band 2 allows me to configure what data I see on the main screen while during an activity and then it provides a single swipe right to see the rest of the data which I configured to be shown.
  • More analytics on the website and app
    More exercise stats compared to Fitbit

    More exercise stats compared to Fitbit

    • Vo2 max
    • Max and mins (heart rate, elevation, etc)
    • Recovery time
  • UV sensor tells me how long I was exposed to sunlight
    • Considering it’s currently winter, I haven’t had a chance to use this a lot yet.

Cons/current issues

  • Health app
    • No weight tracking – Now available in February Update
    • No food tracking
      • The fitibit app is fantastic at tracking food
      • I used this functionality for a little bit with my fitbit to get an idea but it wasn’t something I did all the time.
    • Not Universal Windows Platform and supporting continuum like the Fitbit app (WTH MS, can’t even utilize your own tech?)
  • Weird how different types of activities are grouped together
  • Best feel is wearing on bottom of wrist which feels kind of weird at first but I’ve gotten used to it.
  • The clasp took a little bit to get used to but it seems pretty solid
  • Battery life
    • Fitbit is 5 days
      • I would put it on the charger while taking a shower, giving the kids a bath, and while at the climbing gym

        View from the top of my wrist shows the clasp with integrated battery and the UV sensor.

      • On climbing trips typically I would charge while driving to the location and that was usually enough to last the whole trip
    • Band 2 is 24-48 hours
      • I’ve been charging mine nightly when I am sitting down to watch TV (it’s usually around 50% when I start charging)
      • Unsure how this is going to work when i am on climbing trips.  I might have to forgo sleep tracking just to maintain a charge.

Conclusion

I’ve really enjoyed the Band 2.  It’s been really handy when playing with my kids. I can put my phone down near by and glace at my watch when receiving texts from my wife or seeing emails come through.  It beats trying to dig my phone out of my pocket only to see the text was from Chick-fil-a telling me about some deal they are running. I’ve also really enjoyed being able to text my wife or reply to texts from my wrist while playing with the kids or during other activities where my phone isn’t easily accessible. I wish the app was better and the battery life was a lot better but compared to the advantages, I can get over those things pretty quickly.

What I like and dislike about Windows 10 Phone

IMG_0062

Lumia 950 – 5.2″ Quad HD (AMOLED, 2560 x 1440), 6-core 1.8 Ghz proc, 3 GB of RAM, 32 GB storage with up to 200 GB expandable with microSD, Dual SIM, 20 MP Camera

So if you are new to Windows Phone, you can refer to my post here on why I like Windows Phone better than iOS.  I recently have been playing around with Windows 10 Mobile on a Lumia 640 and a Lumia 950.  This post is mainly my running list of what has improved in Windows 10 Mobile over Windows Phone 8.1 and listing what current cons and issues I have.

Pros over Windows Phone 8.1

  • Hey Cortana with learn my voice or use any voice
    • Hey Cortana was only on select Windows Phone 8.1 devices
    • Learn my voice is new in Windows 10 Phone
  • Continuum (See video demonstration here)
    • Connect to a TV or monitor as a second larger screen to do work on

      Windows Hello - Iris Recognition

      Windows Hello – Iris Recognition

    • Use phone as mouse and keyboard or connect usb/bluetooth devices
  • Mouse support
  • Windows Hello (Only on some devices)
    • Iris recognition instead of typing a pin number
  • Outlook for email
    • Attach any files on device to emails
    • Attach from onedrive
  • Better organized settings
  • Keyboard joystick
    • Dot near z and x to easily move the cursor around
  • Notification text and facebook inline reply
  • Voice dictation built into keyboard
  • Don’t forget when powering off
    • Displays a reminder of your next appointment when you power off the device

      Notification inline reply, keyboard joystick, voice dictation easily accessible on keyboard

      Notification inline reply, keyboard joystick, voice dictation easily accessible on keyboard

  • Call Recording
  • Fast USB-C charging (only on some devices)
    • 50% in 30 mins

Cons/Current issues

  • NTLM passwords aren’t saved in Edge
  • Can’t connect to NTLM auth OneNote
  • Excel, PowerPoint and Word can’t connect to on-prem NTLM SharePoint
  • Airwatch blocks SD card – Confirmed bug with airwatch
  • Airwatch doesn’t install cert chain – Maybe fixed with a newer build
  • Cannot open EML attachment in email
  • Continuum
  • Option to only try Windows Hello when unlock is needed
    • Right now Hello will get locked out from too many attempts because of notifications (email, text, etc)
  • Facebook app needs additional features and bug fixes
    • Live tile not working – Better in 10.2.1.0
    • Pinned pages don’t show notifications on live tile
    • Some types of content don’t display correctly
      Windows Hello tries too much and ends up locking itself out

      Windows Hello tries too much and ends up locking itself out

      • Memories
      • Birthday rollups
  • Battery life
    • Better after installing 10586.63
  • Dual Sim
    • No Visual voicemail on dual sim devices
    • Should be a way to hide 2nd sim when not used in dual sim
    • No vibrate on answer on dual sim devices
  • OneDrive doesn’t connect to on-prem SharePoint
  • Live lock screen app from 8.1 isn’t available
  • Edge does not change to desktop user agent when used on continuum
    • Whatever screen the tab is opened in is the user agent that will be used
  • Random reboots (a lot less after 10586.63)
    • Seemed to happen a lot more at my office.  The following things are potentially different at my office vs at home.
      • Bluetooth devices
      • AT&T Microcell – Often after it reboots it says that my carrier has changed my SIM settings and I need to restart again.
      • Wireless charging
    • Kids corner (Fixed since 10586.71)
      • Since 10586.63, I’ve tried going to kids corner several times from the lock screen and the phone will freeze and eventually reboot.  I have since figured out if I don’t try to hold it up to my face and let windows hello to attempt to sign me in, then I can go into kids corner successfully.  It seems to be the combination of windows hello attempting to read my iris’s while I’m going to kids corner which locks it up.

Why I like Windows Phone better than iOS

Customizable live tiles showing unread counts and information

Customizable live tiles showing unread counts and information

The goal in the post is for me to document my running list of why I like Windows Phone better than iOS (iPhone/iPad).

  • Customizable home screen with three different tile sizes.  This enables users that have a hard time seeing small text or hitting small buttons can make them bigger.
  • Live tiles show more information when not using the small size which shows alerts directly on the home screen whereas iOS only shows the number of notifications.
  • Swipe right enables viewing all installed apps with search and jump by alpha.  Unlike iOS where every app installed has to be in a home page somewhere
  • Can have a combined tile for all email, separate tile for each email address or link several mailboxes together such as Gmail and Hotmail can be linked together as a personal inbox and keep work inbox separate

    Swiping right shows all apps with easy to find by alpha or using search

    Swiping right shows all apps with easy to find by alpha or using search

  • Can combine tiles into a tile folder
  • Driving mode
    • Reads texts to you over bluetooth
    • Can dictate responses over bluetooth
    • Does not popup or sound notifications for anything except phone and text
      • Can also turn off phone and/or text as well
  • Kids corner
    • Swipe right to show a start screen that you configured just for your kids and the apps they are allowed to use
    • Need PIN to get back into normal phone mode.
    • No longer can your child send your boss an email by accident.
  • Gadgets app
    • Run apps when accessories connect
    • Find accessory by seeing on a map where you last disconnected the accessory
  • Near Field Communication (NFC) can be used for more things than just payments like in iOS

    The Glance Screen is like a low powered notification screen.

    The Glance Screen is like a low powered notification screen.

  • Wireless charging in some models
  • Standard USB charging cable (micro or newer type c)
  • Full desktop class browser which can switch from mobile user agent to desktop one
  • Social integration with contacts so when you get a new friend in Facebook or twitter they can show up as a contact
  • Glance screen
    • Low powered screen that shows the time, date, next appointment and notification count.
  • Expand storage with SD cards
  • Battery Saver
    Wi-Fi can automatically turn back on

    Wi-Fi can automatically turn back on

    • Turns off checking for email and other background tasks to help save battery
    • Can automatically turn on at 20% battery
  • Configure apps from within the app instead of needing to leave and go to settings
  • When turning off WiFi, option to turn back on based on a time frame or when at a favorite place such as home
  • Cortana – Personal Digital Assistant with voice recognition
    • Quiet Hours
      • Inner circle can break through
    • Collection of news and other information that is important to you
    • Reminders
      • Place
        • Cortana is your personal digital assistant. Here she is giving me a run down of my interests.

          Cortana is your personal digital assistant. Here she is giving me a run down of my interests.

          Remind me to buy print cartridges next time I’m at the Best Buy off Rea road

        • Remind me to pick up groceries when I leave work
        • Remind me to start laundry when I arrive home
      • Person
        • Remind me to ask my Mom how her cat is doing next time I’m in contact with her (phone, email, text)
      • Time
    • Text message with nicknames
      • Text message my wife on my way
      • Text message my manager I’m running late

2015 Climbing Goals Recap

Onsight of Tricks for You (5.12a)

Onsight of Tricks for You (5.12a)

Erica does a year in review for her climbing goals (click here for her’s) so I decided to document mine as well.  Below were some of my goals for 2015 and other thoughts on how the year went.

I really liked Erica’s 12 5.12’s in 2012 goal a few years ago (see post on cragmama here) so I decided to try to send 15 5.12’s in 2015.  It doesn’t have the same ring to it but I ended up surpassing the goal with sending (excluding repeats) 20 5.12’s in 2015.

DSC05395

Left El Shinto (5.12b)

Ten Sleep helped a lot with this goal because I sent 6 5.12’s there with all of them being 2 goes except for one which I onsighted (Tricks for You 5.12a).  By September I had achieved my goal with my 15th send of the year when I sent Fine Motor Control (5.12a).

After having some luck in the 5.12b range this year I was hoping to send a 5.12c at some point.  I worked on Hard Rock Café (5.12c) several times but walked away with only a one hang.  I had picked out what seemed like a perfect 5.12c for me in Ten Sleep called Left El Shinto.  Unfortunately, others also felt like it was too perfect and in the recently released latest guidebook, the route had been downgraded to 5.12b.  I did send the route but ended up giving myself a 5.12b credit for it.

Techman (5.12c)

Techman (5.12c)

After I sent Freaky Stylee (5.12a) earlier this year I decided to get on Techman (5.12c) with Erica this fall.  Techman is a V5/6 boulder problem into some hard 5.11 climbing and shares the same 5.12a crux finish with Freaky Stylee.  It ended up taking me 3 attempts to send and the send was epic.  I almost fell off at crimpy crux and at two of the hard 5.11 moves later.  What I was really excited about was the Freaky Stylee crux which I fell at so many times in the spring and in the past few years I did without any issues both times I tried it that day.

2015-12-30_8-58-32I use 8a.nu to track my sends and I really enjoy their ranking system.  I set out a goal for my all time score to be equal to my yearly score.  What this basically means is that the top 10 sends of my life happened this year.  I wasn’t sure it was going to happen because I needed to have 10 of at least the following:  5.12b, 5.12a second go, 5.11d flash, 5.11b/c onsight.  While at Ten Sleep I was able to accomplish this goal.  Here’s a link so see how I did for the year.

Gangsta (5.12a)

Gangsta (5.12a)

I have bouldered well at the gym by getting a lot of V5’s and V6’s (including a stray V7 and V8).  I was hoping to have an outside send of at least a V5 this year but it didn’t happen.  We didn’t boulder outside at all this past year.  My birthday bouldering bash was rained out in January, Hound Ears was postponed and since we were so ropes focused because of our Ten Sleep trip, we just didn’t make it a priority.  Hopefully next year.

Check Your Grip (5.12a)

Check Your Grip (5.12a)

Lastly, it felt great to get redemption on a few routes that gave me issues last year.  Freaky Stylee (5.12a) took me a total of 9 attempts and Gangsta (5.12a) took me a total of 16 attempts to send.  I was also excited to get several sends that are steeper such as Lost Souls (5.12a) and Check your Grip (5.12a).  Other memorable moments were sending three 5.12’s in a single weekend (Freaky Stylee (5.12a) on a Saturday and then Fired For Sandbagging (5.12a) and Michelin Man Original Finish (5.12b) on Sunday) and onsighting Tony The Tiger (5.11c).