Importing Excel 2007 into Windows SharePoint Services 2

Tuesday, 8 January 2008

In WSS 2.0, there’s an option to create a new list by importing an Excel Spreadsheet.

I’ve got Excel 2007 installed, and so after selecting the cell range of an .xls file I got this error message:

Method ‘Post’ of object ‘IOWSPostData’ failed

Searching for this gave me a possible solution

Because this particular SharePoint is still version 2.0, I figured that lVer = 2 was appropriate, and the good news is it worked.

Your Account is deleted (part 2)

Tuesday, 8 January 2008

Looks like it wasn’t just us affected by having our website deleted. This is the response I got to my email:

Dear Mr. David,

We really apologize for this issue. Our developer has been accidentally released the wrong version of the billing system that deleted your account.

Our support team is now working to restore your website and emails. They have setup your account as active so you can login to your control panel to raise support ticket while we are restoring your application. Due to high traffic of restoring task, please give us another 24-48 hours to bring your website up again. If you have your own backup at your side, you are pleased to restore it on your own to speed up the time.

Also, you are pleased to create support ticket to ask for your website restoring status.

Please let me know if you still face any issue. Best Regards James Sullivan SeekDotNet Sales Team

Well James, I’m not pleased to create a support ticket, but since my site is still not restored, I think I will anyway.

Someone really needs to proofread their emails :-(

Your Account is deleted

Sunday, 6 January 2008

Amongst other things, I’m the webmaster for the Australian Carnivorous Plant Society.

I just received this email from seekdotnet, the company we have been using to host our website for the last few years:

Dear Mr/Mrs [NewLine] Your Account is deleted due to non-activating more than 1 month. [NewLine] Thank You.

(Yes, that is an exact copy of the text, including the questionable grammar and the [NewLine] string).

And they aren’t kidding - browsing to the website results in a 404 File not found error. Eeeek!

No warnings, no nothing. Just deleted like that after being in continuous good financial standing. If you want to keep your customers, you don’t just delete all their info if there’s suddenly a problem with payments. You might at least attempt to let them know there’s a problem so they can fix it before it goes too far.

I’ve contacted the company, and I’m hoping commonsense will prevail. We’ll see.

How to rip audio from a DVD to Audio CD

Sunday, 30 December 2007

Paul videoed Sevenfold’s recent performance and created a really nice DVD for all the band members.

Jane doesn’t have a DVD player however, so I used these instructions to burn her an audio CD.

Additional comments 2nd Jan 2008

Things didn’t go as smoothly as I’d hoped. My DVD burner came bundled with ULEAD Burn.Now. I wanted to add CD-TEXT track info which Burn.Now supports. However after I burned the CD and tested it, I discovered that some of the tracks had been messed up. The track times were correct, but the content had been messed up. Jumping to track 4 played the content that was actually half-way through track 2. Very weird.

I read that WinAmp supports CD-TEXT, but after trying it out, discovered that it only supports reading CD-TEXT, not writing it.

As a last resort, I grabbed iTunes, and it did the job, though it could only add CD-TEXT for each individual track - I didn’t see a way to add info about the album as a whole.

Passed 070-528

Monday, 17 December 2007

This morning I sat the Microsoft .NET Framework 2.0 - Web-based Client Development exam, and am pleased to report I passed with a score of 824. Yippee :-)

There were a few questions that were a bit tricky. One in particular had me wondering if it had an error in it, the possible answers didn’t seem to make sense to me.

Not to worry, I’m now a Microsoft Certified Technology Specialist .NET Framework 2.0 Web Applications.

Unlike some previous exams I’ve taken, I didn’t study for this one at all. It just goes to show what Rob says, if you know you’re stuff then you can pass these exams just relying on your experience.

Next stop is 70–547 and I’ll have have my Microsoft Certified Professional Developer (MCPD): Web Developer.