Archive for October, 2010
Transparent CSS Sprites – Smashing Magazine
If you are familiar with CSS Sprites, you should be able to grasp this twist relativ
WhatTheFont! « MyFonts
Awesome tool which allows you to upload a sample image containing text, and the site will try to figure out what font was used!
Changing the data type of a meta field in SiteFinity
Posted by shawson in SQL Server, Telerik SiteFinity CMS on October 15, 2010
We have a site finity site which was nocked together by a designer who has since left- unfortunatly one of the meta field we had on the news articles “ViewCount” was set to ShortText instead of Integer, meaning we couldn’t do anything “numbery” with it– like sort it correctly (being text it sorted like 999- 998- 90- 899- 898- 80 for example!), which was kind of crippling the “Most Popular” box on the homepage.
I read up that this is a simple matter of updating the entry for this meta field in the web config- easy enough (in the web.config under telerik > cmsEngine > metaFields);
<!--<add key="News.ViewCount" valueType="ShortText" visible="True" searchable="True" sortable="True" defaultValue=""/>--> <add key="News.ViewCount" valueType="Integer" visible="True" searchable="True" sortable="True" defaultValue="0"/>
But unfortunly, this only applies to any data inserted after that change has taken place, and i had 6000 or so records already in the database as text. Having dug around in the database I found the solution- meta data seems to be held in a table called sf_GCMetaData so having gradually built up a query which isolated my ViewCount fields i set about writing an update statement;
UPDATE
sf_GCMetaData
SET
ValueType = 3,
IntegerValue = CAST(ShortText AS Integer)
WHERE
(Application = '/News') AND (KeyValue = 'ViewCount') AND (ValueType = 0)
GO
UPDATE
sf_GCMetaData
SET
ShortText = null
WHERE
(Application = '/News') AND (KeyValue = 'ViewCount') AND (ValueType = 3)
A few notes- ValueType 0 is Shorttext, 3 is Integer- i figured this out by looking at other known meta fields. So i move the data out of Shorttext and put it into IntegerValue field (using a cast to actually convert the data) then in a subsequent update i wipe out the shorttext data, incase this some how messes it up!
So conversion complete and nothing broke– try this at your own risk though and make sure you backup your databases first!!
PhoneGap – Deselecting All Items from the tab bar!
Posted by shawson in iPhone, Javascript on October 5, 2010
Doing a bit of iPhone development at the mo and needed to remove a highlight from a tab bar when i moved to another page- In your javascript on your page put;
window.uicontrols.selectTabBarItem('');
Telerik Sitefinity- Retrieving a page by it’s URL or GUID- or finding a page’s GUID from its URL!
Posted by shawson in .net, C#.net, Telerik SiteFinity CMS on October 4, 2010
I recently started work at my new job, and here we use Telerik Sitefinity as the CMS for some websites. I was recently tasked with writing some code which involved supplying the end url for a page, and then matching this against the corresponding record in the CMS- after much searching I found nothing and eventually got a response from their support so figured i would blog it!
var url = "~/test2.aspx";
var Manager = new CmsManager();
int totalRows;
List conditions = new List();
CmsSiteMapNode node = (CmsSiteMapNode)SiteMap.Provider.FindSiteMapNode(url);
// here is the GUID for the page
var pageId = new Guid(node.Key);
conditions.Add(new CmsQueryCondition("ID", Nolics.ORMapper.Base.QueryCondition.EQ, pageId));
// and here is the page
var result = Manager.GetPages(0, 0, string.Empty, System.ComponentModel.ListSortDirection.Descending, conditions, out totalRows);
-
You are currently browsing the archives for October, 2010
Flexicoder Blog- Freelancing – Work Sources January 9, 2013Now that I’ve started thinking more about my life as a freelancer I’ve been looking at where my work comes from and what sort of skills I’m being asked to use. The following is a simple breakdown of that data from Jul 09 to Dec 12. But first a brief bit of history… I’ve been […]
- Contract or Freelance – PROS/CONS January 2, 2013Here are my small nuggets of wisdom regarding contract/freelance (as I see them) Contracting – PROS It should be relatively easy to find a contract if you have a good skill set, look at jobserve.com or cwjobs.co.uk – the rates do vary quite a bit Once you have a contract its guaranteed income for the […]
- WWDC 2012 Songs June 16, 2012Here is a list of the songs that I heard in between sessions at the WWDC No You Girls – Franz Ferdinand – Houdini – Foster The People – Someone Great – LCD Soundsystem – 11th Dimension – Julian Casablancas – Man On Fire – Edward Sharpe & The Magnetic Zeros – My Doorbell – […]
- WWDC 2012 – Post Mortem June 16, 2012WWDC As always at the WWDC there is a lot going on and a lot of information to try to digest to make the trip worthwhile. But this year there also appeared to be a lot more attendees than the last 2 times I’ve been, which lead to a lot of queuing! It took a […]
- WWDC2012 – How Did My Predictions Score June 16, 2012Before I went to WWDC I came up with the following wish list of improvements/features that were hopefully going to be announced this year… Ability to run apps on the Apple TV and use your iOS device as a controller, including multiple devices at the same time Open up Siri to 3rd party apps, although […]
- WWDC 2012 – Apple TV Apps May 10, 2012I’m lucky enough to be attending the WWDC this year, as it reaches closer to the “day of the long queue” my thoughts are turning to what I hope will be announced at the conference. So here they are in no real order (apart from the first one) Ability to run apps on the Apple […]
- Freelancing – Work Sources January 9, 2013