Archive

Archive for June, 2010

Chrome OS just installed!

June 9th, 2010

Just finished the long old process of building Chrome OS, and the moment of installing the image on a dev machine is awaiting me tomorrow; if all goes well!

So far it’s taken around 6 hours to install all the prerequisits, sync & build the code and create an image. The actual build took just over two hours on a 64bit single core virtual machine. Next time I will add a few extra cores in aid of speeding the process up; the project is very active so I will need to do this fairly regularly.

I’m going to be interested in seeing the speed of the system first hand. The official videos demonstrate the boot sequence taking 7 seconds from the power button being pressed to the login screen appearing; something I’m finding a little hard to comprehend seeing as the bios load normally takes longer than this on most machines. Hopefully I can get my own video done too.

Anyway, it will be fun to have a look at the new concepts, and start developing some apps for it.

Will keep you all posted!

Techie

SQL Import tool Fails with converted OpenOffice Documents

June 8th, 2010

The ‘SQL Server Import and Export Wizard’ can fail when trying to import a spreadsheet which was originally created by Open Office and converted by Excel into an Excel format.

Symptom

Symptoms of this problem can be seen when you edit mappings within the Wizard there are always 255 columns with the extra columns being prefixed with an ‘F’.

Even though these extra columns are not selected for import, you will get a violation of a datatype for the first column.

Solution

If this is the case, simply copy and paste the data from one document to a new blank document created by Excel.

Versions

Microsoft SQL Server Management Studio 10.0.2531.0
SQLServer 2008
Excel 2007
OpenOffice

Techie ,