SharePoint surveys and the order of the questions during export to Excel
I noticed some interesting, and in my case not desirable behaviour when I was exporting the results from a SharePoint survey to Excel: the order of the questions in Excel differed from the order in SharePoint.
Some further analysis showed the following:
When you export to Excel, the order is determined by the creation time of a question, so the questions that were create first appear before the others. This even happens after you reordered your questions in your survey, which was what I did.
To give an example:
I create a survey with 3 questions in the order 1,2,3:
I then reorder them to 3,1,2:
If I export them now to Excel, the order of the columns however is still 1,2,3:
So in case you need to export to Excel and don't want to reorder your columns there afterwards, make sure you got the order right when you create your survey questions.
I updated my iPhone yesterday to OS 3.0, no problems so far, the whole process went very smooth. First I had to update iTunes to 8.2, afterwards it asked me immediately if I want to update the iPhone. The download took a short while (my internet connection at home has been a bit slow sometimes in the past few weeks), the updating itself was done within a few minutes.
All settings were kept, all programs that I started so far are running without any problem, and even my open tabs in Safari were still open
I haven't tested most of the new features yet, saw no need to send a MMS yet, e.g.
Since last night 1AM Singapore time, Apple's 3.0 update for the iPhone OS is available. While I haven't updated it yet (I was asleep, and after waking up went to work
), others already tried it successfully.
An overview of the newest features and a guide on how to install the update can be found on Apple's website.
Also, there's an interesting article that explains "How To Use The Best 40 Features of iPhone 3.0".
Blog entries could not be found in search engines
I discovered that my blog entries could not be found in the various search engines (Google, Microsoft Bing, Yahoo), however the main blog site could be.
In the Lifetype forums (my blog software) I learned that under certain circumstances the person/bot/client/etc accessing a blog entry gets redirected through the error page (error.php), which will send a 404 Error (file not found) first and then redirect to the corresponding correct location (or at least deliver the content).
This means: everyone was able to access the blog entries here without any problem, however in the background they always showed up as non-existant to the browser/other software. Thus, the search engines didn't crawl any further and treated the links to the individual blog entries as dead links.
I changed the URL generation method from custom url to apache mod_rewrite, which basically changes all the individual urls for the blog entries, but the benefit now is that all pages appear now as existant!
So dear search engine bots, please come again and reindex the blog :)
As it can be seen in the Tripit info-box on the left-hand side, I plan to travel quite a lot in the next few months, all possible thanks to budget airlines, and the financial crisis (which resulted in a drop in passenger numbers for most airlines, so that they offer some relatively cheap flights).
The first trip will be 4 days to Haikou (海口) in the Hainan province in Southern China, I'll travel alone. Flight is operated by Tiger Airways.
One month later, in August, I'll go to Taiwan for 10 days, flight in and out will be to/from Taipei (台北) with Singapore Airlines. This time, I'll most likely travel with a few people, definite number not confirmed yet. The current plan is to travel around more or less the whole of Taiwan via car.
The last trip in September is to Guangzhou (广州) in the Guangdong province. Yes, that's the Guangzhou I've already been to in January 2008. The one where I saw my first real panda(s) and hugged the white tiger!
I'll go there with my company's intern. Initially we planned to go for 2 days only, but after we booked the flights with Tiger Airways, they changed the return flight shortly after, so that we will now come back to Singapore on Monday instead of Sunday.
One other trip might still come up, however not for holiday, but for work. That will be to Bangkok, Thailand, but the date isn't confirmed yet.
Microsoft Bing - Weird Search Result
I was just testing Microsoft's newest search site, Bing. One of the first things people usually are looking for is themselves, and so did I. But the search for 'rene modery' did return one relatively weird search result. The second site Bing suggested is my blog here, however it gave it a weird title:
A rough translation of 'Das Kilo von Rene Zum Abspecken' for all non-German speakers: "The Kilo Of Rene For Slimming"
What The...? I have no idea how they come to that title?! I never ever wrote about losing weight/slimming, and my recent blog posts were about the swine flu, tax, the iPhone, SharePoint, and Singapore.


