Infopath 2010, Append Comments

OK – so for some reason, I am doing another IT related post.  This relates to Infopath 2010, with Sharepoint 2010 – and appending comments to the infopath form.

The past couple of days I have been beating myself up trying to fix this problem.  I have an infopath 2010 form that populates a sharepoint list.  Inside the form is a comments section (yes you guessed it – it’s an IT Helpdesk system) that has a read only repeating section in it, so the the IT guy can add a comment to the helpdesk task/job and it records it for the future.  I created this exact mechinism in the HR system I build in sharepoint, so I know it’s pretty simple.  However, the repeating section kept being overwritten by the comment, and not appending to the form.  So I checked the HR infopath form – and yes, everything identical, then trolled on the internet – and found people saying that you had to do it with code, or workflow etc…  But I know that I didn’t do it with code or workflow in my HR system, so it had to be in the frontend somewhere.

I played around with different ways to do it in infopath, and then thought I’d better check the settings of the column in the list.  Checked the column settings, and yes – “append” had been checked, so that was fine.  Spent “far too much time” mucking around, then went back to the column settings, and decided to “refresh” the check box – by turning off the appending, and then turning it back on again.  And wouldn’t you know it – it threw up an error telling me I had to have versioning on to append text.

d’oh!

At the time, I was thinking – I am such a DOOFUS!!!!  Turned on versioning – and now the infopath form allows appending of history…

On reflection, what a stupid thing to have to do to allow this, so tomorrow – I am going to play around with the versioning settings and see if an append means an unlimited amount of versions are required.

Is it just me – or is this another one of those – “why did they do that” moments..?

PNG Bloggers

Since we have been of this journey – of ‘trying’ to move to Papua New Guinea, we have done shitloads of research on both PNG as well as Port Moresby, and of course my new employer.

I thought it was really important to post about a few of the places, that not only provided me research matter, but also have enabled me to keep a connection to a place that I am desperate to get to.  A lot of these are blogs, but you’ll have to excuse me if The list is small – I will add to it as I remember websites.

The PNG hot list:

http://www.pngbd.com

A fantastic resource – with lots of forum posts.  The people that setup this website have shared a lot.  Basically the first place to go for information – although some of it goes back to 2002

http://www.skerah.com

The new breed of social media driven information.  Skerah has recently setup a real estate website, is very active on Facebook and tweets as well.

http://michie.net/pnginfo/index.html

Another website with lots of resources (although lots that are old) but well worth a visit.

http://educatingwendy.blogspot.com

Dr Wendy is an American Expat living in Lae.  Beware, Wendy has all the tact of a pissed off crocodile, and plays the sarcasm card far too well for it to be unnoticeable… However, I read Wendy’s blog just about every day – she is witty, smart and full of life.  Once you get hooked – you’ll get disappointed when her Internet is out… Again!

http://andersonsportmoresby.blogspot.com

The Andersons are recent arrivals to Port Moresby and it’s been interesting reading how they have gradually swung into PNG life.  Blog posts only happen every couple of weeks, but cover the whole two weeks.  They are now living in Era Dorina – which is the compound that we would love to live in, but have almost no chance of getting into.

http://halfadayaway.wordpress.com

Sadly, the bloggers here have had a SHIT time in Port Moresby, but yet also had an awesome time.  Very disappointed that as I write this, they are packing up to leave PNG :(. Hopefully you get to read their blog – as it is very entertaining

http://expatsinpng.wordpress.com

A family with 3 kids who have only been in PNG for a month or so, we have been in contact with them prior to their arrival, and hope that we can get together once we are up there.

http://theadventuresofben.com

Ben has been up in PNG for a year or so, he seems to be always doing exciting things (do you ever work Ben?) and although an errant blogger, is another blog I always check.

Well – those are my starters, I will add more – but please, if you have a PNG blog (that isn’t political etc) or enjoy reading some, or know of websites, please – leave a comment!

Aaron

Infopath 2010, Sharepoint 2010, IE8 to IE9 Bug

Wow – yup, it’s me, posting about a gotcha/bug/quirk/random/issue relating to our Sharepoint 2010 installation, infopath 2010 and IE8 vs IE9.

So I have an everlasting problem with my desktop at work, in that it is BSOD me once or twice (sometimes more) a day since Thursday.  It started after I got infected with some Windows 7 Security spyware, and then did a restore to a previous restore point on the PC.  Too busy to really fix it – until today, when I updated via Windows Update – and decided “to hell with the devil” and installed IE9.

If you know me – then you know that I love Sharepoint, so the first things I did once IE9 was installed, was to test drive it through both our WSS3 site and our Sharepoint 2010 site.  Everything seemed to be working… until…  I opened an infopath filler form published in our Sharepoint 2010 environment and recieved the following error:

Error

There has been an error while loading the form.
Click Try Againto attempt to load the form again. If this error persists, contact the support team for the Web site.Click Close to exit this message.
Hide error details
This form template is not enabled for viewing in the browser.

Correlation ID:2271a4f0-8cf4-4ae8-8fc0-6d4dda0987eb

How very odd – it worked in IE8.  So I went to our WSS3 site and tried an Infopath 2007 and 2010 Filler form – and it worked fine.  So I busted my arse hunting down the problem, tested with IE8 – which still worked fine, and then spotted that under the context menu for an existing form – that I could open it in either a browser or filler form.  Tried it in the filler form – and it worked – sweet.  So, into the > library settings > advanced settings > Opening Documents in the Browser

Here you have three options for the default open behavior for browser-enabled documents:

  1. Open in the client application
  2. Open in the browser
  3. Use the server default (Open in the browser)

And – yes, ours was set to: 3.  Use the server default (Open in the browser)

Changing this setting to: 1. Open in the client application  – of course, fixes the behaviour… however – it doesn’t explain why IE8 user behaviour opens it in the client application, when it should open in the browser…  very strange, and a gotcha if you are using Infopath 2010 Filler Forms, Sharepoint 2010 and IE8 – and then upgrade to IE9 and wonder why your users can’t open forms anymore…

Port Moresby is a long way away

It’s been a good few weeks since my last post – and unfortunately I thought I would be prepping my bags and *leeeeeeaving…. on a jeeeet planeeeee* in the next week or so, however I still haven’t got our Visa info back from PNG, so still haven’t submitted to the High Commission here.  Frustrated?  Yup – just a little.

As yet, I still have a house full of stuff, two cars, and all the normal everyday stuff you need – whilst living in Dunedin during the winter.  If it was summer – wouldn’t be too much of a problem, but winter….  You never know when you need the 4×4..!

In my last post I had a list of things I would miss – here’s the list again, but this time – I am going to scratch out a few things – cause we are still here!

1. I’m going to miss my wife and kids – who will be coming up maybe 6-8 weeks later   OK – the kids are driving us all around the bend!
2. I’m going to miss friends and family  Nigel No Mates, and the family have only visted once in 6 months, miss them?
3. I’m going to miss my uncles 60th birthday – sorry Kev!  Kev’s Birthday is soon!  Pity he is too slack to organise a party…
4. Rugby World Cup! Bugger  OK Super 15 almost gone, NPC to go :)
5. The opening of the Forsyth Barr Stadium  Might get there after all
6. All Blacks v Fiji – the official and definite last test match at Carisbrook  Might get to this too
7. Election 2011 and the banter with my National Member Boss. Can’t wait to rub in NZ First back in parliament :)  Boss is on holiday, but now not too early
8. My job, yes – I shouldn’t miss it, but I know I will…  ahh yes – I want to get stuck into my new role!!
9. Winter – I do enjoy the cold  stuff this – give me some heat!
10. Kids sport :( . Soccer/Hockey  Yup damn cold on the soccer field
11. My dog – even though he is already gone :(  Yup – still miss Jack :(
12. My truck – going to have to sell it soon  OK – so this might turn into an issue – if I can’t sell it
13. Internet :(  Still have it!
14. Yeah – I could go on and on and on…..  Yeah – I could go on and on and on…..