Migrating Custom SharePoint Column nightmare

Well I had to migrate custom columns from one SharePoint 2010 environment to another, thanks to the following post, I was able to script it and migrate.

http://get-spscripts.com/2011/01/export-and-importcreate-site-columns-in.html?showComment=1297294835163#c1161922080422697705

Easy right, not so fast, went to check my columns out and got this great error when accessing site columns under site settings

Field type  is not installed properly. Go to the list settings page to delete this field.

Turns out I made a typo and left a column type blank. after scouring the internet, i came across somebody brave enough to delete from the content database.

So I looked in the contenttypes table in the Content DB, found the offending record, deleted it and SharePoint started to work again.

I hope this helps.

Advertisements

Auto Refresh SSRS Reports in SharePoint 2010

Thank you Brian Keay for your post

http://briankeaybi.wordpress.com/2011/02/21/auto-refresh-ssrs-in-sharepoint-2010/

If you happened to find this post and were pulling your hair head like I was when you copied and pasted Brian’s code snippet and it did not work, try deleting the single and double quotations and retyping them in, stupid fonts. If you did not find Brian’s post I have included his code snippet below

<script type=”text/javascript”>
// The time out value is set to be 60,000 milli-seconds (or 60 seconds)
setTimeout(‘document.location=document.location’ ,60000);
</script>

Couple additional things to note.

1. you can save this script into a text file, store in a document library and point your content editor -> content link to the txt file

2. you can also type the script directly into the Content Editor HTML Editor, click in the content editor in edit page mode. You will see the Content Editor Ribbons. On the Format Text Ribbon there is a Markup section where you will find an option to edit HTML, type the script there.

Wait 60 seconds and voila, refresh

A giant thanks again to Brian

SharePoint 2010 Theming

Have you ever wanted to re theme the Horizaontal Navigation section of SharePoint. 2010

below are the styles that can be modified in COREV4.css
found here (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\LAYOUTS\1033\STYLES\Themable)

body #s4-topheader2

.s4-tn li.static > .menu-item

.s4-toplinks .s4-tn a.selected

.s4-toplinks .s4-tn a.selected:hover

.menu-horizontal .menu-item-text

Please let me know if I have missed anything major.