Skip to main content

Blog

Go Search
Home
Blog
Publications
Contact
  

Kathy Hughes, MVP > Blog
All things SharePoint, Office and Technical

 ‭(Hidden)‬ Content Editor Web Part

SharePoint survey not able to export to spreadsheet
A colleague recently approached me to ask why they couldn't save the survey results from one of their external SharePoint 2010/hosted sites. So, I did some digging...
 
Scenario:
 
You attempt to use the 'Export to Spreadsheet' option from your SharePoint survey Actions toolbar:
 
 
 
When prompted to open or save the IQY file, you click either Save or Open - let's assume you choose the 'open' option for now. Excel fires up and then you receive the error dialog which tells you that you don't have adequate permissions to modify this list (you receive the same error if you save the IQY file locally and then attempt to open it):
 
 
 
 
Your initial thoughts tell you that the error has something to do with either the Office client version currently installed - perhaps it's incompatible with the current version of SharePoint - OR it has something to do with the current mode of authentication - OR client integration features in SharePoint (either in the permission level or in the current list or library) are disabled; OR your user account has insufficient permissions.
 
To troubleshoot, you verify that (1) client integration features are indeed enabled and that you have full rights to the site/list; (2) you receive the same error in both Office 2007 and Office 2010; (3) you check the authentication method currently being used - BINGO! The server is configured with BASIC!
 
 
My colleague needed the results now, so - a quick and dirty fix... I saved the survey as a list template (.STP) with content and then imported it into one of my dev environments configured with NTLM; created a new list from the template and successfully exported the data out to Excel.
 
 
 
Australian Community SharePoint Conference – it’s a wrap for Year 2010 – but...
[Long post!]
 

Two weeks ago, the conference I’d been helping organize came to fruition and was held here in Sydney over two days – 16th and 17th June. The conference has since been referred to by many as one of the best and most successful SharePoint conferences ever held! The conference, in its first year here in Australia, had in excess of 600 attendees, it attracted speakers like Arpan Shah from Microsoft in Redmond, Todd Bleeker from Mindsharp (USA), Michael Noel (USA and author of the upcoming SharePoint Server 2010 Unleashed book by SAMS) and numerous other well known and respected international and national SharePoint experts and speakers. Delegates who attended the event travelled from all around Australia, including Perth, Melbourne, Brisbane, Adelaide and Canberra.

Debbie Ireland – SharePoint MVP from New Zealand (SPEvents) – was at the helm of organizing the Australian (and New Zealand) event/s – this year also saw the second New Zealand conference, held over in Wellington the week prior to the Australian conference, and which saw a 25% increase in attendance on last year’s conference! Debbie, and her team from New Zealand, did an absolutely outstanding job in organizing the conference, conference logistics and behind the scenes project management – it was a pleasure to meet and work with them – and I look forward to working with them and supporting them in future like endeavours. It was also a pleasure to work alongside the other conference organizers (both Australian and New Zealand), including James Milne (Brisbane), Mark Orange (NZ) and Brendan Law (Melbourne).

We had a fantastic line-up of sponsors – we also received favourable feedback from delegates on our conference sponsors, including the fact that exhibitor stands were easily accessed throughout the conference and session breaks. See the conference sponsors page here: - http://www.sharepointconference.com.au/sponsors.htm. Plus, a huge thank you to those sponsors who provided the prize draw prizes for both Day 1 and Day 2.

So, what made the conference a success? I believe the fact that (1) we (the key organizing team) all worked as a team – with a shared vision - from the outset and throughout the 6-7 month period leading up to the event; (2) we are all SharePoint experts (or SharePoint subject matter experts and actively working with (and in) SharePoint 2007 and SharePoint 2010 and related technologies), so we had a good feeling for the market and what people would be interested in, and we carried out market research from the outset; (3) we had a good assortment of topics and allocation of speakers; (4) we included a number of tracks to suit all audiences, including business, technical, Voice of the customer (real-life implementation scenarios) and vendor-specific sessions – this attracted a diverse group of people – many from the same company/ies who saw having the multiple tracks of real benefit - including System admins, developers, designers, business analysts, project managers, CTO’s and CIO’s and other business stakeholders – having such a diversity of tracks and people allowed for cross-pollination and sharing of information all at once!; (5) it was a ‘community focussed’ event and we had the SharePoint community behind us who greatly promoted the event and provided support throughout the two days, with the likes of a User Group Community Booth (the go-to spot for SharePoint questions and post-session follow-up) which was manned by the Australian and New Zealand SharePoint community throughout the entire conference; (6) We had Microsoft’s full support, both as a sponsor and as a community-focussed supporter, from the outset; (7) the venue – the Hilton Hotel – was the perfect venue, in terms of location, rooms and comfort – I constantly heard very positive feedback about the food – FOOD is an important part of any IT event! (8) The sponsor/exhibition area was well laid out and easily accessible to delegates throughout the conference; (9) the Ask the Experts panel – this was a great way of winding up the conference on the final day and we encouraged several international and local speakers to get involved and to include a good cross-section of SharePoint skills – including admin, developer and infrastructure.

This post is by no means the first, or only, post-conference write up. We’ve (the organizers) received numerous congratulatory e-mails and feedback; I’ve included a couple of links below:

Craig Bailey (@craigbailey) – convenor of the popular ‘Sydney Business and Technology user group’ and who attended the conference - provided a great post conference review - http://www.craigbailey.net/australian-sharepoint-conference-review/ (thanks, Craig)

IDM – our media sponsor and partner throughout the conference – also wrote a good post-conference review - http://idm.net.au/article/007910-australia-sharepoint-conference-schedule-return-2011 - interestingly, this article cites the percentage of female conference attendees at 25% - a vast (and welcomed) contrast to that number usually seen at IT events.

Also, a big thank you to Rose Stamell, Microsoft, for organizing the wrap-up networking drinks for MVPs and Speakers at The Hilton – it was a nice way for the conference speakers to reflect on the conference and discuss SharePoint goodness. Plus, a big thank you to Emantra Hosting Solutions (Australia) – and Mark Rhodes – for providing and hosting the main MYSPC SharePoint 2010 site used throughout the conference and provisioning and hosting the individual delegates trial SharePoint (server) 2010 sites.

Well, what about next year’s event? We hear you and planning is already underway for next year’s (2011) Australian SharePoint Conference. Thank you to all those conference attendees who completed the preferred conference location survey during (and post) the conference – even those who cheekily completed the survey multiple times! J At this stage, Sydney is the favoured location. In terms of next year’s conference dates, based on feedback received from this year’s event from Microsoft, sponsors and delegates, next year’s conference looks to be 8th and 9th March, 2011, at The Hilton Hotel. Keep an eye on the conference site – http://www.sharepointconference.com.au for further updates. Now is the time to start planning to attend!  Also, if you are interested in attending next year’s New Zealand event, then keep an eye on the New Zealand conference site – http://www.sharepointconference.co.nz – for updates, including dates and location.

If you are interested in speaking at next year’s conference, then initial speaker interested is being captured via http://spevents.co.nz/AUSPC2011/default.aspx - simply visit the site and complete the Speaker Registrations survey by clicking on the link in the left-hand column. Similarly, if you are interested in speaking at next year’s New Zealand SharePoint conference, then visit http://spevents.co.nz/NZSPC2011/default.aspx and complete the Speaker Registrations survey.

Hungry for more SharePoint information now? In terms of other SharePoint events happening between now and next year’s SharePoint conference, here’s a list of some of the events happening here in Australia:

SharePoint Saturdays Australia: Sydney (7th August - http://www.sharepointsaturday.org/sydney); Canberra (18th September - http://www.sharepointsaturday.org/canberra); Melbourne (16th October - http://www.sharepointsaturday.org/melbourne) – they are FREE but you need to visit the registration sites shown in order to register for each event.

SharePoint Saturdays globally (some of these happen as online events!) – see http://www.sharepointsaturday.org for a full listing of SharePoint Saturday locations.

TechEd Australia – will include a number of Office and SharePoint tracks - http://australia.msteched.com/ - up on the Gold Coast again this year (2nd year running at the same location!). Don’t forget about user group registration discounts for TechEd AU - if you are involved in a UG then you should ask your UG leader for further details. Unfortunately, I will not be attending this year’s TechEd due to a number of existing Sydney-based commitments.

Office DevCon, Sydney (will include both Office and SharePoint tracks) – http://www.officedevcon.com.au  – FREE plus a two-day weekend event – but you must visit the registration site in order to register for the event so we can properly cater for all for both food and space.

Australian SharePoint user groups – see http://www.sharepointusers.org.au/default.aspx - for a user group location near you. SharePoint user groups are a great place for meeting other SharePoint enthusiasts and experts!

SharePoint MVP online chats hosted by Microsoft – these chat sessions happen on a monthly basis (as of writing this blog post) – see details of the latest chat session -  http://blogs.msdn.com/b/sharepoint/archive/2010/06/17/live-chats-to-learn-more-about-sharepoint-with-the-mvp-experts.aspx – and are a great place to ask your SharePoint questions, ranging from administration, development, infrastructure and design.

SharePoint 2010 MSDN forums – a great place for asking (and answering) SharePoint 2010 questions - http://social.msdn.microsoft.com/Forums/en/category/sharepoint2010.

SharePoint 2007 MSDN forums – questions and answers specific to the SharePoint 2007 versions - http://social.msdn.microsoft.com/Forums/en-AU/category/sharepoint

PLUS, Microsoft has announced their SharePoint 2011 conference, happening over in Anaheim, California, in October, 2011 -  http://blogs.msdn.com/b/sharepoint/archive/2010/06/08/save-the-date-sharepoint-conference-2011.aspx.  

2010 – it’s a wrap!

 

SBTUG SharePoint 2010 Prep presentation available
Thanks to everyone who attended last night's SBTUG meeting at Microsoft in Sydney, Australia. I'm glad to see keen interest in SharePoint 2010. We also had Matt Moore present a session on how to make technology sexy, which was an ideal precursor to my SharePoint 2010 presentation, which you can download from this site, SharePoint 2010 Preparedness, or view on SlideShare, http://www.slideshare.net/kathyhughes.
 
A few interesting questions and comments raised during the presentation:
 
SQL 2008 R2 Express is 10GB, as opposed to the 4GB limit in earlier Express versions - thanks Victor Isakov for pointing that out
 
You will need to install Office 2010 Professional PLUS to also install InfoPath Designer 2010 - thanks Nick Rayner for pointing that out
 
During the discussion around Access Services, Visio Services, InfoPath Forms Services, and other, Andrew Coates reminded us about Word Services - also part of SharePoint Server 2010 Enterprise version. If you are attending the Australia SharePoint Conference (16 and 17 June, Sydney, Australia) Andrew will be presenting a session on "Creating and manipulating documents with Word Services and Open XML" - see http://www.sharepointconference.com.au for additional details.
Trivia: Interesting SharePoint Tag Cloud Properties
Here's something you don't see when adding the SharePoint 2010 Tag Cloud Web Part via the Web interface - exposed via SharePoint Designer 2010. I'm glad to see the tag 'kangaroo' included!
 
 
 
SharePoint Workflows and Visio 2010 which Version
Today, when I installed the Visio 2010 RTM product, I was struck with the decision around which version to use. I had two keys - one for Visio Professional and the other for Visio Premium. I didn't recall seeing those options while working with the Visio Release Candidate.
 
I received my answer from the MSDN Visio blog - http://blogs.msdn.com/visio/default.aspx - which includes a useful matrix of functionality between Visio 2010 versions Standard, Professional and Premium. If you plan on using Visio 2010 for creating and working with SharePoint workflows, then you'll need to install Visio *PREMIUM* 2010, which includes the option for SharePoint Workflow Template.
 
SharePoint Designer 2010 RTM 32Bit Benign Error during Installation
Scenario: You attempt to install the SharePoint Designer 2010 RTM 32-bit (x86) on a Windows 7 x64-bit operating system and the installation fails, with the dialog shown below:
 
 
 
The Windows application event log shows the following error:
 

Product: Microsoft Office Office 64-bit Components 2010 -- Error 1731. The source installation package for the product Microsoft Office Office 64-bit Components 2010 is out of sync with the client package. Try the installation again using a valid copy of the installation package 'Office64WW.msi'.

Resolution: Ensure you have removed *ALL* earlier Beta and Release Candidates from your machine, including Office 2010 and Visio 2010. In my case, I still had Visio 2010 32-bit Release Candidate installed on my machine. Once I completely removed it, the SharePoint Designer 2010 RTM 32-bit installed successfully.
 
 
 
 
 
 
Making Technology Sexy; SharePoint 2010 Prep

We have an exciting line-up for next week’s SBTUG meeting at Microsoft here in Sydney, Australia. First off, Matt Moore will intrigue us with discussion on how to make technology sexy (including SharePoint!). Immediately following Matt’s session, I’ll discuss some key considerations around planning for SharePoint 2010.  This is a great session for those considering upgrading from SharePoint 2007 or starting afresh with SharePoint 2010. We plan on making the session as interactive as possible, including discussion on new key features and features that have and haven’t changed since SharePoint 2007.

I’ll also provide an update on the Australia SharePoint Conference (http://www.sharepointconference.com.au ) and, on that point; we have an exciting giveaway – one free ticket to attend the conference!

For further information, see the SBTUG site at http://sbtug.com or visit the group’s Facebook page - http://www.facebook.com/event.php?eid=111040542264221  - to register and post questions relating to SharePoint 2010 that you’d like to cover/discuss on the nite.

And, for those of you who have been asking, I’ll provide an update on my new book, SharePoint Designer 2010 Unleashed (http://www.amazon.com/SharePoint-Designer-Unleashed-Kathy-Hughes/dp/0672331055/ref=sr_1_16?ie=UTF8&s=books&qid=1271914256&sr=1-16 ) and show a sneak preview of my final ToC!

Update: Australia SharePoint Conference, Sydney, Australia
Aussie SharePoint Conference 2010
 

http://www.sharepointconference.com.au

16th and 17th June, 2010, The Hilton Hotel, Sydney, Australia

With the pending public release of SharePoint 2010 (http://blogs.msdn.com/sharepoint/archive/2010/04/16/sharepoint-2010-reaches-rtm.aspx ), things in the SharePoint world are really heating up.

Conference planning is well underway and I’d like to share some exciting updates, as follows:

Conference keynote delivery by Arpan Shah, Director at Microsoft Corporation (Redmond, WA) who owns Technical Product Management for SharePoint Products and Technologies.

An array of great speakers, including our very own Todd Bleeker from Mindsharp, USA, among top notch international and local speakers - http://www.sharepointconference.com.au/speakers.htm

A great line-up of sessions, ranging from business to technical, and covering SharePoint document management, social and collaborative features, business intelligence, design and workflow -  http://www.sharepointconference.com.au/agenda-business.htm

SharePoint deployment case studies - http://www.sharepointconference.com.au/agenda-voice.htm  

Vendor sessions provided by conference sponsors - http://www.sharepointconference.com.au/sponsors.htm - covering product demonstrations - http://www.sharepointconference.com.au/agenda-vendor.htm

A community hosted SharePoint user group booth where you can mingle and network with SharePoint community minded folks and SharePoint MVPs and ask your SharePoint questions, and learn about the SharePoint community throughout Australia and how to get involved.

Free hosted SharePoint Server 2010 site for conference attendees – thanks goes to Emantra Hosting Solutions Australia (http://www.emantra.com.au/ ) and to Mark Rhodes (http://www.msexperts.org/blogs/mark/ ) for making this possible

A chance to win a free ticket to the conference by attending the upcoming SharePoint 2010 launch event - http://www.sharepointusers.org.au/MOSSIG/Wiki/SPOLaunch.aspx

Finally, you can read further about the conference in the latest online conference article, featured in IDM - http://idm.net.au/article/007775-sharepoint-australia-conference-preview.

 
Debbie Ireland
 
 
SharePoint Conference 2010 Sydney, Australia
16th and 17th June, 2010, The Hilton, Sydney, Australia
 
Don't miss the Australian SharePoint Conference for 2010, proudly sponsored by Microsoft and leading partners, and organized by members of the Australian and New Zealand SharePoint community. For details and registration, visit the following site:
 
 
 
 
Data and Content Crunching with SharePoint 2010
Presenting at Sydney SharePoint User Group, Tuesday 16th February, 2010, from 5:30pm onwards.
 
Come along to discover the capabilities of how to work with data sources and discover some tips and tricks on how to make your SharePoint sites come alive!
 
Further details and registration at http://www.sharepointusers.org.au/Sydney/default.aspx
 
 
1 - 10 Next

 ‭(Hidden)‬ Admin Links