Dell Latitude XT2 - Tablet PC
Fick äran att låna en Dell Latitude XT2 från Tankbar - Webbyrån i Nyköping (www.tankbar.com) och det resulterade i ett tekniktest som jag verkligen kan rekommendera er tekniknördar att läsa.
Läs inlägget på SN här
Backup all databases in SQL Server Express editions
I have been searching and wanting a good but simple backup solution for all my SQL Server 2008 and SQL Server 2005 databases in the free Express edition. There is as you know no maintainance plans in the express editions and they are not backed up correctly by server software built in your server os. So finally I did stumble upon a really great solution which I modified a bit and will share here for all my friends and others to use.
The whole idea is to backup all databases inside a named instance and also to keep track on how many days you want to save the backed up files.
I use this for my local SharePoint backups and also three servers with SQL Server. Fantastic!
My folderstructure looks like above and you can ofcourse name files and scripts and folders the way you want it.
I have a folder on my root drive or data drive on my server called sqlbackup. Inside that folder I have the above structure setup. I also have a subfolder called dbfiles and in that folder all my backups will be stored.
backupscript.sql
First of all we create the backupscript.sql file and it should look like the below file contents.
DECLARE @dateString CHAR(12), @dayStr CHAR(2), @monthStr CHAR(2), @hourStr CHAR(2), @minStr CHAR(2)
--month variable
IF (SELECT LEN(CAST(MONTH(GETDATE()) AS CHAR(2))))=2
SET @monthSTR=CAST(MONTH(GETDATE()) AS CHAR(2))
ELSE
SET @monthSTR= '0' + CAST(MONTH(GETDATE()) AS CHAR(2))
--day variable
IF (SELECT LEN(CAST(DAY(GETDATE()) AS CHAR(2))))=2
SET @daySTR=CAST(DAY(GETDATE()) AS CHAR(2))
ELSE
SET @daySTR='0' + CAST(DAY(GETDATE()) AS CHAR(2))
--hour variable
IF (SELECT LEN(DATEPART(hh, GETDATE())))=2
SET @hourStr=CAST(DATEPART(hh, GETDATE()) AS CHAR(2))
ELSE
SET @hourStr= '0' + CAST(DATEPART(hh, GETDATE()) AS CHAR(2))
--minute variable
IF (SELECT LEN(DATEPART(mi, GETDATE())))=2
SET @minStr=CAST(DATEPART(mi, GETDATE()) AS CHAR(2))
ELSE
SET @minStr= '0' + CAST(DATEPART(mi, GETDATE()) AS CHAR(2))
--name variable based on time stamp
SET @dateString=CAST(YEAR(GETDATE()) AS CHAR(4)) + @monthStr + @dayStr + @hourStr + @minStr
--=================================================================
DECLARE @IDENT INT, @sql VARCHAR(1000), @DBNAME VARCHAR(200)
SELECT @IDENT=MIN(database_id) FROM SYS.DATABASES WHERE [database_id] > 0 AND NAME NOT IN ('TEMPDB')
WHILE @IDENT IS NOT NULL
BEGIN
SELECT @DBNAME = NAME FROM SYS.DATABASES WHERE database_id = @IDENT
/*Change disk location here as required*/
SELECT @SQL = 'BACKUP DATABASE '+@DBNAME+' TO DISK = ''c:\sqlbackup\dbfiles\'+@DBNAME+'_db_' + @dateString +'.BAK'' WITH INIT'
EXEC (@SQL)
SELECT @IDENT=MIN(database_id) FROM SYS.DATABASES WHERE [database_id] > 0 AND database_id>@IDENT AND NAME NOT IN ('TEMPDB')
END
Remember to change the path c:\sqlbackup\dbfiles in the script above if you change your path!
So the sqlscript will backup all databases in a named instance and save them to the dbfiles folder marked with date and time.
Now we will create the clearbackup.vbs script that will delete backup files older than x days in the dbfiles folder.
clearbackup.vbs
On Error Resume Next
Dim fso, folder, files, sFolder, sFolderTarget
Set fso = CreateObject("Scripting.FileSystemObject")
'location of the database backup files
sFolder = "c:\sqlbackup\dbfiles"
Set folder = fso.GetFolder(sFolder)
Set files = folder.Files
'used for writing to textfile - generate report on database backups deleted
Const ForAppending = 8
'you need to create a folder named “scripts” for ease of file management &
'a file inside it named “LOG.txt” for delete activity logging
Set objFile = fso.OpenTextFile("c:\sqlbackup\LOG.txt", ForAppending)
objFile.Write "================================================================" & VBCRLF & VBCRLF
objFile.Write " DATABASE BACKUP FILE REPORT " & VBCRLF
objFile.Write " DATE: " & FormatDateTime(Now(),1) & "" & VBCRLF
objFile.Write " TIME: " & FormatDateTime(Now(),3) & "" & VBCRLF & VBCRLF
objFile.Write "================================================================" & VBCRLF
'iterate thru each of the files in the database backup folder
For Each itemFiles In files
'retrieve complete path of file for the DeleteFile method and to extract
'file extension using the GetExtensionName method
a=sFolder & itemFiles.Name
'retrieve file extension
b = fso.GetExtensionName(a)
'check if the file extension is BAK
If uCase(b)="BAK" Then
'check if the database backups are older than 5 days
If DateDiff("d",itemFiles.DateCreated,Now()) >= 5 Then
'Delete any old BACKUP files to cleanup folder
fso.DeleteFile a
objFile.WriteLine "BACKUP FILE DELETED: " & a
Else
objFile.WriteLine "BACKUP FILE IS STILL CURRENT: " & a
End If
End If
Next
objFile.WriteLine "================================================================" & VBCRLF & VBCRLF
objFile.Close
Set objFile = Nothing
Set fso = Nothing
Set folder = Nothing
Set files = Nothing
Change the x number of days to match you wishes!
log.txt
Create a textfile called log.txt in the folder so that the script can append logs to it. The logfile will contain the log for backing up files and deleting old backup files.
Now we will create the command batch file that we can schedule on the server to execute whenever we feel neccessary.
runsqlbackups.cmd
The file will look like below.
REM Run TSQL Script to backup databases
sqlcmd -S AKVIBY\SQLEXPRESS -E -i"c:\sqlbackup\backupscript.sql"
REM Run database backup cleanup script
c:\sqlbackup\clearbackup.vbs
Remember to change instance and path to match your settings!
So schedule your runsqlbackups.cmd and it will backup all your files and store them in dbfiles folder which you can make sure is backed up on regular times by your server backup system.
When you run the scheduled task you will se a command prompt like below.
If everything is setup okey you will also find all backups inside the dbfiles folder.
Like my local backups you can see above I then mark the dbfiles folder as an Live Mesh folder and all backed up.
That’s all folks!
How to send Mail from Outlook to SharePoint
I will start a step by step tutorial here which will learn you how to send e-mails from Microsoft Outlook to SharePoint.
Until then you can test the product that we made to accomplish this in real life.
Try it for free, goto www.spapi.com and the Downloads section.
The tutorial will start on the 16th of october, next week.
Beta testers for Outlook to SharePoint application is wanted!
Last week me and my new work announced the first Beta of MailDropper for SharePoint. We are now looking for beta testers all around the world from single users to large corporate organizations.
We will provide you with the software, instructions and a testpaper that you will have to fill out (Only one page!).
So mail me at andreas@bestpromotion.se or ak@gkviby.com and I will contact you and send you the software.
For thoose of you that do not know what MailDropper do take a look at www.spapi.com for more information and screenshots.
SharePointCommunity nere idag!
Jag hade missat att förlänga abonnemanget på eget domän på NING Networks och idag slutade det att fungera.
Men nu är det förlängt ett tag till så nu hoppas jag att den nya plattformen kommer till liv under oktober.
Jag ber om ursäkt!
MailDropper for SharePoint just hit the planet!
MailDropper for SharePoint is finally out for testing on the market and the interest is very high. With the help of MailDropper for SharePoint it will be easy to send one or more e-mails from Microsoft Outlook into SharePoint.
MailDropper allows you to configure lists you want to send emails to and save these settings as favorites.
MailDropper also takes the entire original message including attachments and formatting and stores it as an attachment to each item in SharePoint.
This means that anyone can search, view and open email messages in SharePoint sent from Microsoft Outlook.
The configuration files can be distributed by Group Policy tools for larger organizations, including the license keys. MailDropper for SharePoint is a unique product that is easier and faster than those on the market. Simplicity and speed is our motto and in MailDropper, we have combined these things and managed to build a stable software that many have requested.
Another important thing to MailDropper for SharePoint is that we will only sell it through resellers. We are now looking for retailers who want to offer their customers this product and are interested in working with a product that offers functionality that your customers do not have and want, and margins that make the deal very interesting.
October Offer reads as follows:
Buy 5-pack for only $ 1.240 from a reseller near you.
Buy UNLIMITED USERS license and install within your organization on all computers for as little as $ 15.600 from a reseller near you.
Go to www.spapi.com for more information on MailDropper for SharePoint and contact us directly if you want to become a retailer. All retailers get free access to customized versions that have the retailer's logo and contact information in the product.
Best regards
Andreas Kviby
.NET consultant looking for work
Well it was not one of the posts I planned to write when the new year bells told everyone it’s 2009! But here I am, just got canned due to lack of work. Love the company Human Data and wish them my best in the future and maybe our roads will cross once again sometime in the future.
I have never got canned before in my life so this is new to me. I have always made a choice to move on, to upgrade my CV or just try to make the world a better place :)
When you get canned you must suddenly plan for your future between 8 and 5 working days, strange feeling huh?
I just realized that I am made to carry out smaller and shorter projects within ASP.NET, ASP.NET MVC, C#, VB.NET, SQL Server or other technologies like Windows Forms development or even development of a new application for Windows Mobile. I am fast and accurate in those kind of projects but I am not made for long term projects. So anything between 20 and 150 is my kind of case.
My knowledge is deep and wide, I have been developing apps for the Microsoft world ever since VB got released on diskettes a while ago :) I have spent my whole life with VB and speak and write VB and VB.NET fluently.
I now work almost fluent in both C# and VB.NET and have focused a couple of years now on SharePoint development. Just started to make some stuff in ASP.NET MVC and with my Ruby on Rails background I can tell you folks, it rocks!
If you need a consultant anywhere in the world, send me an e-mail (ak@gkviby.com) and you will get my CV back and my pricelist.
I take on jobs from the 1st of august 2009.
Missa inte årets SEF!
SharePoint och Exchange forum, seforum! Missa inte årets upplaga som både innehåller nördspår och vanliga spår.
Lär mer på www.seforum.se!
Passa på att anmäla er innan den sista juni och spara pengar.
Use SharedView to collaborate in smaller teams
SharedView is another small and neat freeware from Microsoft. It allows you to start a session with maximum of 15 attenders and share what window you like. You can even upload handouts to the people.
My first idea is ofcourse to start using this for the work with SharePoint Community Sweden and also to be able to arrange online classes. I think this is a great tool and I hope that we will see to cool testing of here soon.
http://connect.microsoft.com/site/sitehome.aspx?SiteID=94
Running JavaScript and CSS inside your Web Parts
I have been struggling with this task for a while in my development projects. The task is how to include JavaScript and CSS files in your Web Part project. There are tons of quick and dirty solutions but I decided to find a smoother way to include them.
This is my solution.
I created a new class in Visual Studio 2008 and found these two excellent functions. RegisterCSS and RegisterScript. It wasn’t invented by me but I still feel I have to share this because I know that a lot of people find this hard to do.
So from my Web Part code I just call the RegisterCSS and send in the path to the CSS file and the this object to make sure the code gets added to the right Web Part.
When I run this code inside any Web Part project it will add and put the CSS and the JavaScript at the right place and it all works like a charm.
If you would like to extend this you should ofcourse make it a Web Part Editable setting where to find the CSS and the JavaScript and my recommendation is to use a standard Document Library to store them in and then let the user choose Document Library and then the particular file. Neat!
Thanks for this time!
SharePoint Journal gratis!
Tillsammans med Understanding SharePoint Journal har jag glädjen att ge bort senaste eller valfritt nummer till 10 medlemmar på SharePoint Community Sverige.
I del tre av SharePoint Journal går författaren igenom den egentillverkade fälttypen SPTags. Det är till och med 90 minuters video med.
Helt hysteriskt bra material för den inbitne!
För att vinna en gratis kod värd 14,95 USD skickar du en motivering på Engelska varför just du behöver SharePoint Journal och en kort text varför du tycker SharePoint Community är en bra plats. Skicka detta inklusive länken till din medlemssida på communityportalen.
För till kvarn gäller så skriv på och mejla mig andreas[at]humandata[.]se.
I am developing you a free Sharepoint product!
So here is my challenge for all you SharePoint nerds out there.
I want to get your suggestions on SharePoint products missing or that be done better than the existing ones.
It can be webparts, features, custom fields or whatever. Send all your crazy and wild ideas to me at my workmail below and you could win your product.
I will choose one of them each month and develop it and give it away for free as a ready to install SharePoint product to the one who tipped me.
I do this because I need to be challenged and I trust all you out there have ideas you would like to see alive.
andreas[at]humandata[.]se
See you soon!
SPTags explained on 107 pages
Have you ever thought about custom fields in SharePoint? Then here is your ride to success. Everything explained in details and with videos as well. You will even get to know how to present the results in various ways in webparts.
It is just amazing that you actually buy a complete class, education or you can even call it a small book for only 14,95 USD per issue.
I has my doubts in the beginning about buying material this way but now I am more than convinced. I am thrilled!
Issue 1 and 2 was great and now Issue 3 is like past issues on steroids!
Grab your own issue right now, right here!
Understanding SharePoint Journal Issue 3 – SPTags explained!
Remote Document Library Viewer
So it is finally time for some serious testing of my new WebPart for SharePoint. Made for both WSS and MOSS Document Libraries and now with even more functionality missing in standard SharePoint.
What you see in the imabe above is a Document Library displayed with my DocPart WebPart. The Document Library is located in the the Root Site and named Docs. My Webpart is displaying that Document Library on a subsite with no problems.
It even displays the remote document library’s Views and when you select a View it will also show you thoose columns marked for display in that particular view.
All columns supports ordering.
You can also see it supports icons for document types and even folders. What makes my WebPart different from the built-in webpart is when you click a folder.
When clicked you will see folders and items inside the clicked folder as in the image above. BUT! You also see the Up… Icon which will make it easy to browse your document libraries folders.
You can display Document Libraries from any Site within the same Web Application!
Want to testdrive this app? Want to participate the betaprogram? Send an e-mail to me at andreas[at]humandata[.]se.
SharePoint 14 goes SharePoint 2010
It’s official. Today Microsoft announced that the official name of SharePoint “14” is SharePoint 2010.
Read more
SharePoint Community nu fler än 200 medlemmar
Jag kan inte beskriva den glädje jag har när jag ser att vi har fått in över 200 medlemmar på communitysajten. Det känns helt suveränt, det ska bli extra kul när vi kan börja visa upp den nya plattformen som kommer erbjuda ännu mer kommunikationsmöjligheter inom communityns medlemmar.
Tack alla ni som gjort detta möjligt!
Speciellt Tack går till Zimmergren, Wilén, Bugday och Husman!
Write Iron Python in Workflow activities
As a CodePlex follower I just looked into a new project which enables you to write scripting code as a SharePoint Workflow activity. Nice!
Read more!
Visio Symbols for SharePointnerds
So I found some great symbols for Visio when designing applications targetting SharePoint.
Thank you Microsoft!
Download them here!
SharePoint & Exchange Forum
The dates are set and they are accepting registrations now!!!
Limited seats available.
Go to this link
Smart solutions from Mimosa for SharePoint
When your SharePoint farms keep getting bigger and bigger and data, documents and other stuff you share and store is growing in a pace your storage and backup guys can’t handle. What do you do?
Well, you could create a lot of PowerShell scripts to make sure the backups and rolling. You could talk to AvePoint and their products and several other suppliers as well with smart backup and archiving utilities.
Or, you can check out Mimosas product that has gotten support for the SharePoint platform.
Read more
SharePoint with 3D navigation system live!
Hi there everyone!
Last week I got the oppertunity to be a Betatester on the BumpTop Desktop Experience. This is great and I truly believe it will change the way children will use their computers in the future. BumpTop together with Microsoft Surface is just amazing.
I am a SharePointNerd as you know and therefore I just had to get SharePoint and BumpTop falling in love with each other and they did. How cool isn’t it to navigate your Document Libraries in 3D and stick your Image Libraries to your walls in the office look-a-like BumpTop environment.
Check out the movie where I play with a big Document Library!
Watch it and enjoy! Need more info? Email me!
The movie was made by connecting to a SharePoint document library and then assigning it a letter. Then I can Bump that folder into my 3D office. How cool is that?
Document Library WebPart released
So, you have a Document Library somewhere on your SharePoint and then on a deep down subsite you want to display documents and folders from that Document Library.
Is this possible? Actually not in this way it isn’t without this WebPart.
With this WebPart called DocPart you can set which Site and which Document Library you want to get files and folders from and then you set two different filters to filter the documents which are shown.
Let’s say you have created some META data fields like Department and TAGS in your Document Library. On the subsite you want to show all documents where the field Department matches the value HR. So all HR documents will be shown and available on that subsite thanks to DocPart.
As you see in the above image we can set the filters very easy as the fields are populated when you choose a Document Library.
Watch my video which shows you the WebPart in action.
Don’t you dare complain on my nervous voice, this is the first video I make with Jing Pro and their YouTube addin.
Workflow binder tool for free
Hi, just stumbled upon a nice post about a tool to bind workflows to content types. It’s free on Code Plex.
Read the post here!
Fantastiskt bra verktyg för er som kör Outlook
För som kör Outlook har jag ett coolt tips här. Jag har länge önskat mig ett verktyg där jag kan skjuta upp leveransen av mejl för att kunna arbete ifred.
Nu finns det på Office Labs tillsammans med en hög andra coola saker som de gör.
http://www.officelabs.com/projects/emailprioritizer/Pages/Default.aspx
The future in retail! What about SharePoint?
I just saw the great video from soapbox and Microsoft titled Retail Future Vision. I adore the idea which is shown in the video and by todays technology this kind of stores should already be a reality.
What about the future vision of SharePoint?
I often try to imagine the next version of SharePoint inside my head. I am trying to image how it can be used for other stuff than the enterprise content portal market. What about me and my family, How are we going to use SharePoint in our daily life?
How is retail and stores going to use SharePoint and how can I as a consumer connect to that retails SharePoint. Can I choose to synk my personal shoppinglist so that I can see in a RSS feed the list of groceries and pricing? Can I send my store an email with the subject QUERY:PRICE and then type in MILK RED 1 LITRES in the body and I will get an email back with the pricing. If that would be possible I would be glad because I could email all stores the same shopping list and in seconds I would have all their pricing right in front of me.
I would like to handle all incoming mail through my personal WSS server so that all bills and letters got scanned and stored inside my SharePoint. This way I could relax and read mail whereever I am and whenever I want to read it.
What is your future vision of SharePoint?
SharePointReviews.com is supergreat!
I believe this site will grow extremely fast in 2009 and if they do their cards right it will for sure be the number one site for searching and reading reviews on SharePoint related products.
It’s a great work done by the people behind it, thanks Inna for bringing this to our attention!
So if you want, sign up and become a contributor to SharePointReviews.com!
Interesting post on how to create your MOSS VPC
I find lesson 20 really interesting which is new to a newbie in virtualisation issues.
Go to post here
Skrattretande om Windows 7 versionerna
Alla som hoppats på ett mindre antal versioner av Windows 7. Knappast troligt alls, kolla denna bild som kommer från ett stort förlag som skriver om detta.
Hur ska detta kunna bli mindre förvirrande för slutkonsumenten?
Så nu undrar jag vilken version mina föräldrar kommer skaffa, vilken tror du?
Start your workflow from code!
For me this has been a great and difficult journey. I have asked the best SharePoint consultants available, I have posted on several forums with no luck what so ever.
What do I want to accomplish?
Well I want to be able to start a named workflow on a particular list or a particular item, from my C# code.
How can I do this?
It is a lot of tricky bits according to me but when they all are in place it rocks! It works! It’s beautiful!
The image shows you all the code which starts the workflow on a particular listitem. You can see my String ListItemID first and this string holds the listitems unique ID.
You can also see SPURL, SPListName, SPWorkflowName and you understand you will have to define these or replace them with your values.
We loop through items which is stupid I admit when we only return one record but I hadn’t the time to swoop the code before posting.
They we will hook up WorkflowManager and loop through the Associations to find the named workflow. You can see the if statement in the middle comparing the name of the workflow with our string SPWorkflowName.
If you want a bigger picture of this, click the image :)
Hope you enjoy this post! I love it!
Remote Deploy of WSP packages and more
Last night the people at Portal Solutions released a new project on CodePlex called WssDeploy.
This project is übercool folks. Install it as a addin to your local Visual Studio 2008 environment. Install the WssDeploy Windows Service on your target WSS or MOSS machine.
Make sure you provide a user account which is a local admin.
After this has been done you can now remote deploy WSP files to your MOSS and several more functions is built in. Me like!
http://www.codeplex.com/WssDeploy
SharePoint User Account Control
I just say wow and because of things on a sunday I will just give you the link over to CodePlex but please, you will need this!
http://www.codeplex.com/spuac
Visual Studio 2010 with SharePoint stuff!
So we are all hoping that you can do more and design more in Visual Studio 2010 than you can now. It seems we are all going to be pleased.
Check out this recently released screenshots.
This images are ripped from the original post which is linked below!
Here you can see a applicationpage in VS 2010. Looking good right!
And the server explorer. Wow, there is a lot of stuff on the left hand pane folks!
Read more at the original post: http://blogs.msdn.com/somasegar/archive/2009/02/19/sharepoint-tools-support-in-visual-studio.aspx
Use your SkyDrive as a local drive!
Finally I did it! I found a supreme software which will connect Amazon accounts, SkyDrive, Google Docs and Google Picasa and make them usable as local drives.
Chek it out!
www.gladinet.com
SenseNet from Hungary seem extremely similar to SharePoint
I just walked through some features of the current release and some more on the upcoming release of the SenseNet system. It is opensource, created in .NET and it seems like a superduper great system.
![18[1]](http://itbloggen.se/cs/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/diaznet/181_5F00_thumb_5F00_06DD6A27.jpg "18[1]")
Click the image to see the full size image!
I want all you Sharepointers comments on this competitor as soon as possible. Can we learn something from their features? Can we create a comparison chart between this one, SharePoint and IBMs platform?
I feel a little bit sick though after walking through their mindmap-alike feature flashenabled webpage… whoa! My office is spinning around like a rollercoaster now.
http://www.sensenet.hu/
SharePoint List Association Manager – SLAMMED!
So I just got of the MSN Messenger with Allan Wellenstein at AW Systems. He wanted to follow up how I feel about my new friend SLAM. So I thought I would post my latest feelings about SLAM to you all.
First of all I will tell you this, with SharePoint Slamified and my SharePoint lists Slammed into standard read-only tables I can create anykind of website or application working with read-only SharePoint data without the need of any front-end SharePoint solutions. How about that?
The installation process and our testing samples
I am installing SLAM now and in the end you wanna see this!
After this is done make sure you goto http://www.codeplex.com/SLAM/Wiki/View.aspx?title=Getting%20Started and read it. I did not today but Allan kindly reminded me about it and thank you for the greatest support Allan!
Make sure you get the SLAM.DUMMY.CONFIG file from the folder /resources in your virtual directory of your SharePoint and drop a copy of it in the root of that virtual directory and rename it to SLAM.CONFIG.
After installation is done just goto Site Settings in your SharePoint installation and activate the feature.
So activate it and then magic starts to happen…
Activated and ready to configure your SLAM? How do I know if I am?
You will see the SLAM Control Panel inside Site Settings menu Site Collection Administration. Click on it!
You will get an nasty error now telling you that the SQL Server cannot be found… if you didn’t follow the instructions in the readme.txt or the online guide which you find by clicking the link above in this post.
So… like me… huh! Forgot to create the database. Let’s do that now!
We created an empty database named slam and now we will open up the slam.config file and edit the connectionstring inside.
Edit the ConnectionStrings, type in your serveraddress and instance if you have an instance. Enter db name SLAM (if used) and your credentials. SAVE!
When you edit some stuff in your SharePoint environment you might need to grab your command console and enter the magic word IISRESET and it will be a little nightmare moment without SharePoint. SharePoint will now have to work it’s way up to the surface again and it can be (read will be) a bit slow for a while.
When everything in this configuration steps is done you can click again on SLAM Control Panel and you will see the screen below. NO ERRORS!
So let’s enter a relationsship between my lists in my development environment. My new slam.config looks like below.
Click the image to view full size image.
If everything is good you can go into the SLAM control panel and you will get this.
So look at that! Relations created in SLAM and what the heck are going to do now to get something cool out of this SLAMMER?
Let’s open up the SQL Management Studio now and create a query against the newly created tables. Tables should have been created now like below.
If we take a look inside our Tasks table it should look like the image below.
So you see all the data here from your SharePoint lists, or at least all the data from the fields that you decided to SLAM.
This means that relations created in SLAM and SLAMMED fields and tables will get stored syncronized outside SharePoint in a SQL Server.
So this is awesome as hell boys and girls! I just SLAMMED four of my SharePoint lists and then created an ordinary WebSite Application within Visual Studio 2008. Connected to my SQL Server which holds the SLAMMED tables fully syncronized from SharePoint. Created some views and pages that present data and information from SharePoint on a thin website application. What about that? I just imitate the OLW commercial, CHESUS!!!
I am extremely impressed of SLAM and what stuff you can do with your SharePoint SLAMIFIED as to say all SharePoint content SLAMMED into standard read-only tables.
This product will not just (as of today) be the 12th most popular on CodePlex. It will for sure be a popular product all over the Internet among us SharePoint Nerds!
Thanks a lot to Allan for all support and tips when testing this awesome software.
www.codeplex.com/slam/ – Let’s SLAM IT!
SenseNet from Hungary seem extremely similar to SharePoint
I just walked through some features of the current release and some more on the upcoming release of the SenseNet system. It is opensource, created in .NET and it seems like a superduper great system.
![18[1]](http://itbloggen.se/cs/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/diaznet/181_5F00_thumb_5F00_175AE2E1.jpg "18[1]")
Click the image to see the full size image!
I want all you Sharepointers comments on this competitor as soon as possible. Can we learn something from their features? Can we create a comparison chart between this one, SharePoint and IBMs platform?
I feel a little bit sick though after walking through their mindmap-alike feature flashenabled webpage… whoa! My office is spinning around like a rollercoaster now.
http://www.sensenet.hu/
SharePoint List Forms Extensions Feature
When you create and use your SharePoint list forms for editing and creating new items you have always had this wet dream on displaying different fields depending on which user is logged in and using the form, am I right?
If you nick, nod or scream yes of frustration this post will make you happy and joyful. The team at KWizcom have released their List Forms Extensions and this version adds this functionality for your forms. Yes, oh yes you can manage which form fields get displayed or not using their extensions.
Go to the productpage here
Strangely it seem that all Sharepointers miss this forum or?
I am confused now, I am the co-moderator of the forums at www.sharepointcommunity.com and it is a lazy task. How come there are no more Sharepointers using this forum?
What forums do you all use? If you miss one click the link above, register and go posting.
Head to Head SharePoint Development – Swedish Post!
Äntligen måste jag säga efter snart 10 års uppehåll som lärare inom utveckling. Förr i tiden utbildade jag dryga 300 personer inom klassisk ASP och så vitt jag vet var kurserna mycket populära och alltid fullsatta.
Tillsammans med LabCenter arrangeras nu utbildningen Head to Head SharePoint Development. Det är en grundkurs i SharePointutveckling som lär dig det mesta om de möjligheter som finns inom SharePoint.
Läs mer här
www.labcenter.se
Announcing SharePoint Conference 2009
WHOA!
This very night Microsoft announced the SharePoint Conference details. It will go down at the Mandalay Bay Events Center in Las Vegas, Nevada between October 19-22.
For all the sweat details visit www.MSSharePointConference.com!
SharePoint External Tasks ready for sale!
The new SharePoint CommandLine Tool called External Tasks brings a new way of executing WorkFlows in a much smarter manner than possible before.
With this CommandLine Tool you can type in arguments and just use the Windows Task Scheduler to add a schedule to this tool whenever you need to run it.
CommandLine Arguments
-help Will print instructions
-SITEURL http://maverick
-SITERELURL /Docs
-LISTNAME Documents
-VIEWNAME ExpiresToday
-WORKFLOWNAME SendReminders
-USERNAME administrator
-PASSWORD xxxxxxx
-DOMAINNAME maverick
Inside your document library where your organisation stores all world wide contracts you will have a ReminderDate and this date tells the system that this day we need to start renegoiate the terms and so on… bla bla bla!
The problem is that you will do this by using a WorkFlow and that WorkFlow will trigger when new or updated in this list. So when you add a new contract it will calculate a ReminderDate value and then it will tell the WorkFlow to Wait until… and the WorkFlow remains in memory on your server.
I think this is a waste of memory and the WorkFlows created for thoose twothousand pile of documents and contracts.
From this day I just schedule this little CommandLine tool with credentials and the URL of the site and all the stuff mentioned above.
The possabilities are endless and if you are interested before the other geeks gets this software please send me an e-mail of it and I will contact you for pricing and when we can deliver the Software.
Mail: andreas@humandata.se
SharePoint QuickLaunchExtender released on CodePlex
Ever wanted to have thoose sexy panels like in Explorer in Windows? Well now you can modify the quicklaunch easier than ever.
Nice effect and very userfriendly way to use the space better. This is a must have for intranets using the quicklaunch.
read more
Javascript libs for SharePoint 2007 released on CodePlex
More and more stuff gets released on CodePlex targeting SharePoint which makes us all a bunch of happy puppies here.
So now you can use JQuery to query lists, add, update, delete and even modify the new and edit forms with this cool JavaScript library.
read more
Sharepoint Workflow Migrator released on CodePlex
So finally there is a working tool to move workflows and content types between site collections. Winform app that got released on CodePlex now.
read more
SharePoint List Association Manager! UPDATE!
I just want to give you an update on the SLAM product. I have been sitting with Allan at AW Systems today and found some minor errors in their setup software so their leed developer is fixing this issues and hopefully it will be done tonight so I can test it later on this night.
I will post a full review of SLAM here with instructions on how to use for thoose who still does not know when to SLAM your SharePoint.
Live Search Web Slices for Internet Explorer 8
Microsofts Brandon LeBlanc today announced the new cool feature of IE 8 called Web Slices. When a webpage has a webslice on it IE 8 will show you a green little icon like the RSS feed icon. When you add that webslice to your IE 8 it will show up in the favourites bar like the image below shows you.
It’s a supercool feature and my idea is ofcourse when do we see the first SharePoint WebSlice code or WebParts which will be WebSlice compatible.
How cool wouldn’t it be to have parts of your MOSS intranet accessible from the bar in IE 8 like that weather above?
Rock N Roll, I just gotta have some time over to test this… Time is my enemy!
SharePoint Management PowerShell scripts
PowerShell scripts for SharePoint work. I don’t need to tell you more about this than it has been updated with more scripts and together with the iLoveSharePoint guys WebPart that can actually run a PowerShell script inside the WebPart things just got a bit more sexier today.
http://www.codeplex.com/SharePointPSScripts
SharePoint List Association Manager – SLAM!
So we all have gone really mad sometimes about the none existing ways to make relations between SharePoint lists right? Any SQL database application you ever built have had complex relations in some way right?
Well these guys or girls at the AW Systems company have just released an open source project on CodePlex (www.codeplex.com/SLAM/) which will give you this kind of relations you have wished in SharePoint but never where able to create.
This could be a breakthrough application for your development projects inside SharePoint. I haven’t tested this on any application yet, just read the API (http://www.awsystems.com/SLAM/API/) from their homepage (http://www.awsystems.com/SLAM/) and understand that this might just be what I have been looking for in severals applicationprojects during the last years.
Head on to any of the links above and please, report back to me what you think about this new way of handling relations in SharePoint lists.
SharePoint Explorer should be any SharePoint Admins first choice IE Addin
I just went through some SharePoint slides and then I watched one written by our great Swede Tobias Zimmergren. On one of the slide Tobias lists some recommended tools for all SharePoint Developers and admins and I decided to see thoose I didnt already have on my machine.
So I then was about to test the SharePoint Explorer tool from Dot Net Factory. WOW! The installation takes less than 5 minutes and then what? Suddenly a new toolbar appears in my Internet Explorer with my local MOSS structure listed. I can browse and switch views and stuff in a second with this great addin.
Thank you Tobias for that inspiring page in your slides!
Download it now!
The SharePoint Podcasting Toolkit
The Podcasting Toolkit has been around for a while but todays guest blogger has an extreme knowledge inside this plattform. Everyone interested in earning some about this pod casting toolkit you better head on to this link.
GetSharp is the real external implementation of the SharePoint Podcasting kit so download and start to play.
Connecting With Excel Services in Microsoft Office SharePoint Server 2007 to Create a Controller Workspace
The Controller Workspace is a portal designed for the Financial Controller enabling him/her to oversee the close processes in one location. It brings together data from several accounting and compliance systems providing real-time status.
This is a great thing for financial people and SharePoint consultants that have their customers in this field.
Watch the movie, download the summary.
Watch the high resultion movie here
Or just go to the page where they speak about it, click here.
Chris Johnson rocks at PDC 2008 with his SharePoint session
I just sat down in my big nice soft chair and watched the recorded session where Chris Johnson the program manager at Microsoft which work within the SharePoint Services Team shows off on stage.
I am just thrilled over this kind of sessions and I am grateful that they have been recorded for us to see in our own space and speed at home.
You can learn a lot from this session, like how he deploys a new theme through activating it as a feature. He is switching designs with a click of a button. SilverLight Charting, special field definitions and so much more. You can join Chris in this recording for more than an hour.
A true SharePoint nerd watches SharePoint recordings together with Samantha Who and some icecream, some snacks and my wife…
See it now!
Full PowerShell power in your WebParts and in SharePoint
You just gotta see the new PowerEventRecievers made by the crazy guy at iLoveSharePoint. This guys just throws a lot of superamazing stuff for free, downloadable from CodePlex.
But the new stuff now is the PowerEventReciever which will give you full blown PowerShell scripting in events inside SharePoint.
This would make it possible to actually trigger PowerShell scripting capabilities when for an example adding records to a SharePoint list. Making it possible to handle all kinds of cool stuff when things happen on our SharePoint lists.
So get your mouse in the palm of your hand and click this link now!
News WebPart for SharePoint in SilverLight
Really cool News aggregator for SharePoint announcements built with SilverLight. Even if you do not want a news aggregator on your SharePoint site you will learn how to build SilverLight solutions on SharePoint and how to configure your SharePoint for SilverLight usage.
Get it from CodePlex here.
Make use of roles with the OwnerEventHandler just released
Another post to CodePlex, the developerheaven for sure nowadays. I am just thrilled of all the projects you can find on this site and more and more gets posted everyday.
Project Description
EventHandler for WSS3 that allow modify security permission when add elements in sharepoint libraries or custom lists
With this solution you can control permissions in list elements or document libraries elements in sharepoint.
This solutions contains an EventHandler "OwnerEventHandler" in the "OwnerItemEventReceiver".
You can register the ItemAdded event with Event Handler Explorer.
Read all of it at CodePlex
Pimp your SharePoint with Features from GraceHunt
There is a bunch of features released on CodePlex (www.codeplex.com) from GraceHunt which I really start to like. Not that I need to hide the quicklaunch menu so often or in desperate need to add various links to Site Settings pages and so on… BUT!
There samples and solutions shows me how to do all kinds of stuff just with features. I think I have to start learning more and more about features.
Check them out on CodePlex, click here!
Jian Suns post on FBA was really helpful
So I went on stumbling around Jian Sun for a while and then I just found that the latest post about configuring FBA for SharePoint was really helpful. I didn’t for instance now that if you did FBA this way you could use the FBA Tools from CodePlex in the way Jian Sun does.
You gotta read this
All kinds of tricks and stuff for STSDEV Users
I stumbled upon a post that linked to this place for information about STSDEV and I am sorry to say that I gave that up when the new Extensions arrived but I now several people use STSDEV for all their projects.
So Jian Suns blog is worth reading if you use STSDEV.
Click here
Data Privacy Day at Microsofts Website
Interesting information and movie, watch it online. Click here!
SharePoint Community Sverige is here!
After a long period of internal braindamage and thinktanks this week was the startingpoint for SharePoint Community Sverige. I am not alone in this project, almost everyone at my work HumanData is involved in the project and my new SharePoint friend Wictor Wilén is also heavily involved as one of the main persons in this project.
We hope that all of you living in Sweden or outside speaking Swedish will head to the site right away and signup for an free account.
Go to www.sharepointcommunity.se and register now! The first 50 members will be invited to a special event in Stockholm in the near future.
Let your SharePoint Fire keep burning by visiting the community site daily. We will write articles, blogs, upload instructional videos and more to the site and we all hopa you will enjoy your stay with us.
TechDays in Västerås 17-18 march 2009
So this event seem to be a must have event for all us geeks. We all want to the the geeks in their 48-hour show when they are supposed to put together a whole functional infrastructure for a company from zero to working state in two days.
I am also looking forward to see the new online services with SharePoint Online Services which is in my interest so to say.
I am going to suck up to my boss now and I hope to see all of you there.
TECHDAYS
Nothing about SharePoint in this post!
Today one of the most popular night club scenes went on fire. They have been threaten since december and this was the fourth attempt to set the club on fire. Today they succeeded and I feel sorry for all those people who likes to go there and the owners who have put in a lot of time and effort in making this a great night club.
Measure HardDrive Size and FreeSpace in a WebPart
So I wrote last week on my upcoming post on this subject. Here it is, my Performance Part for displaying available space and total size on any drive on your server. The idea is to add more and more webparts so that you can monitor and check performance inside SharePoint.
First out is the one that will give some data about the drives in your system. You can set the driveletter yourself inside the propertypane with this WebPart.
private double getHDDSize(string drive)
{
//check to see if the user provided a drive letter
//if not default it to "C"
if (drive == "" || drive == null)
{
drive = "C";
}
//create our ManagementObject, passing it the drive letter to the
//DevideID using WQL
ManagementObject disk = new ManagementObject("Win32_LogicalDisk.DeviceID=\"" + drive + ":\"");
//bind our management object
disk.Get();
//return the HDD's initial size
return Convert.ToDouble(Math.Round(((((double)Convert.ToDouble(disk["Size"]) / 1024) / 1024) / 1024), 2));
}
So the above will get the DriveSize for us and the code below will get the FreeSpace in the drive.
private double GetHDDFreeSize(string drive)
{
ManagementObject disk =
new ManagementObject("win32_logicaldisk.deviceid=\"" + drive + ":\"");
disk.Get();
return Convert.ToDouble(Math.Round(((((double)Convert.ToDouble(disk["FreeSpace"]) / 1024) / 1024) / 1024), 2));
}
So with these two functions using the WMI inside Windows we will get the data we need to populate the rest of our webpart using Microsoft Charting components.
Here is the complete code for you to use anyway you want.
Code for WebPart
Microsoft Web Platform Installer
Microsoft is on it for real and they also release the Microsoft Web Platform Installer on their site. With this tool even users with Windows XP and Windows 2003 server can use the installer go get all the neccessary files and software to start developing cool web applications.
This is by far the best stuff I have seen in a long time regarding the hazzle it can be to get all the right stuff installed just to try the .NET Environment.
Goto Microsofts site and download it now!
Microsoft Web Application Installer!
So finally they did release it, the Microsoft Web Application Installer is out in Beta. With this magic installation kit you can install osCommerce, phpBB, DotNetNuke, Grafitti CMS, Drupal or more just with some clicks and everything else will be delt with by the installer.
With a slick and smooth interface it will help you fullfil your installation dreams. I installed DotNetNuke in a minute and it rocks!
Goto Microsofts Site
10 STEPS TO A SUCCESSFUL MANAGED DEPLOYMENT WITH SHAREPOINT
1. Consistency of platform, browsers, collaboration and enterprise search
strategy.
2. Manage as centrally as possible with a tight team with fewer people more focused on tha task. They can then report to the rest of the staff.
3. Have a killer backup strategy that meets the needs of your business and
make sure it works. If you need help doing this contact mikael@humandata.se who can assist you in getting a kickass backuproutine for your SharePoint.
4. End-user training and education in addition to good content and
search is the key to end user adoption. A lot of training in small groups is always a good point and will help to kickstart employees usage of the SharePointsystem.
5. Have a Governance and Information Management Plan. Branding
consistency with a corporate style guide and consistent taxonomy.
Make approved master pages available in site galleries for consistency
which will inform users they are on the corporate Intranet. Never break this point, it will kill your intranet in 6 months if you do!
6. Enforce workflows and approval on document centers and pages where
official documentation comes together. Leverage version history and
version control to maintain a history and master document that all can
refer to. Always print-out the “Created-By” and “Modified-By” on all pages in the footer.
7. Life cycle managed site collections, and document libraries with
information management policies such as content types with auditing
and expiration. This will help you create a living SharePoint that actually lives and not just a static archive with expired content irritating employees when they search for fresh documents.
8. Properly secure corporate assets. Sites with personally identifiable
information should be appropriately flagged and secured and audited.
9. A corporate browse and search strategy for the enterprise will ensure
you are making the most out of your intranet assets as well as
encourage culture change, best practices and adoption.
10. Platform Usage Policies and development and test environments ensure
only the code you want to introduce follows corporate guidelines and
will ensure the environment is supportable and able to maintain any available service level agreements in your organisation.
This is a perfect list for a successful SharePoint implementation. Thanks to Microsoft for handing the points to us. Not originally written by me but I have added and rewritten some stuff according to my experiences.
Office 14 for the web – A little movie from Channel 9
This is a awesome video that all you nerds need to watch! Especially the view of the new onlineversion of OneNote.
Just awesome, just awesome!
SharePoint Online Services Whitepaper
So finally I got the time to find the Whitepaper I have been longing for since the end of december I think. It’s a 33 pager and I have just completed to read it. I am a little bit frustrated about this one because it only outlines the stuff that will be available but it does not mention enough I think being a developer and nerd but what the hell.
The sign in application is kind a cool and it will let you to have a single-sign-on application to all your online services such as e-mail, live conferences through live meetings and ofcourse the main thing, “My Company Portal” aka SharePoint Online Services.
SharePoint Online Key Features are displayed in the table below which I just copied from the document.
| Feature | Description | |
| Storage | 250 megabytes (MB) per user account |
| Site storage quotas | 50 gigabytes (GB) per site collection
1 terabyte (TB) per company |
| Site collections | Up to 20 per company |
| 2007 Microsoft Office system integration | Office Access 2007
Office Excel® 2007
Office InfoPath® 2007
Office Outlook® 2007 | Office PowerPoint® 2007
Office SharePoint Designer 2007
Office Word 2007 |
| Browser support | Internet Explorer 6
Internet Explorer 7 | Firefox 2
Firefox 3
Safari 3.1.2 |
| Mobile device support | Nokia E series and N series devices
Apple iPhone 3G |
So what do we think of 250 megs of storage per user account? Will it really be enough or is it like other new services, in a quarter it will be 10 gigs per user account if you pay a shitload of dollars per user account. Like a plusmeny at mc donalds but SharePointified so to say.
I am more happy about site collection limits and the company limit of 1 terrabyte. Finally they also got support for Firefox and Safari, or… Oh no they did not, they state that some functions and actions will not work in thoose browsers. I really do not care anymore, I just use Firefox at home when using the kitchen pc but all other hours IE is my mistress.
The mobile device support is quite interesting though, support for Nokia and IPhones. But as you have seen Microsoft have actually even released some software for the IPhone plattform for free so they see it as a big market and then they need to reach thoose users. I am still curious why Microsoft haven’t been able to create and deliver a much more innovative and better operating system for mobiles than Windows Mobile 6 but like all other stuff I guess they will.
ForeFront Virus Scanning built in and we like that as well as blocked files from the online services so we just won’t be able to get some malicious files inside our new online company web. All site collections and content backed up every 12 hour feels great and I really hope that the services will be so stable that this won’t be used.
So what am I looking forward to in SharePoint Online? Well I want to know how can I develop WebParts that will be installed in the online version. How can I offline sync the online SharePoint to my users Outlook or Groove/Mesh kinda softwares?
I am SharePointified and I am looking forward to read the developer guidance whitepaper soon.
Gah! Why hasn't this been promoted more?
Have you seen the WSS Workflow Tools? I just went through some SharePont tagged posts here and at Daniel2Point I found a post about WSS Workflow Tools which you can find at http://www.codeplex.com/wss3workflow.
Have anyone here tried it out? I sometimes need to create nicer forms than the OOB forms for registrering things into SharePoint and this set of tools seem to make that rock smooth together with the inbuilt Workflow inside WSS.
Please post back if you have tried it and share your feelings about it.
If you are bored some rainy day check out the movies they have stored on Codeplex for this project. Great and long instructional videos.
When is Workflows going to work the way they should
So I create a workflow which depends on when a new record gets inserted into my SharePoint list called Bills. The workflow I run here just checks when the paydate equals today - 5 working days. When there is a match it will send me an e-mail with the text "Don't forget to pay the bill to VattenFall AB with the amount of 2354,00 which is due for payment in 5 days.". This is a great tool for me in my private intranet to keep sending me stuff that I otherwise would have forgotten.
Now to the problem with workflows (as far as my knowledge reaches!). When I set the workflow to Paus the workflow will stand still for about 15-25 days on my server and keep using my precious memory on the server. When I add like 30 bills it becomes a problem which is making my SharePoint environment slower and slower and I have more than a billsystem on that poor machine.
So why the hell can't Microsoft create some kind of Workflow Engine that resides on my server just to check in on my lists once in a while or when I say it should check in. Why? This seem to be a problem for a whole lot of users out there.
Is there any kind of product available to solve this, is there any third party tools available to solve this the pro way? I have created my own but it is not ready for publishing yet but I guess there must be a whole lot of tools like this. Please send me the links and I will review them and write a blogpost about them.
Wanted for SharePoint!!!
So I am sitting at home and the kids are sleeping. I am a SharePoint Nerd so I start to brainstorm with myself and dream about stuff that just don't exist. You all know the sentence "It's always greener on the other side...". So what am I wanting now?
I want Office Communication Server to handle all telephone and communications at my company and inside our SharePoint Intranet I want a webpart when I can select IN/OUT/MEETING/VACATION and select start and end with date and time. This webpart should be connected through OCS and then to Exchange Server to that everything gets connected.
So you OCS Nerds out there, is this available? If it is, tell me!
Just a taste on something I am writing about
So webparts are cool and charting might be even cooler inside a webpart. I just started to play around using Microsoft Charting together with the WMI interface on the server itself. Why?
I am creating what I call Performance Parts for SharePoint and this set of webparts are ment to display all kinds of performance points from the server itself. They can measure the usage on drives, memory usage, processor load, size of the content database, active users and more. These kinds of data is useful for administrators and they are not so hard to create.
The picture below is just a taste on my WMI WebPart that shows a snapshot on drive usage.
It shows my three serverdrives in different charttypes but still kind of a cool thing.
My request for you is the following, what kind of stuff do you want to measure and show like this from your system? Please send thoose as comments or mail me.
Microsoft Charting inside .NET Framework just rocks!
So Dundas got sold to Microsoft and nothing more happend? Well now it just did, I found the DataVisualization stuff a couple of weeks ago stumpling upon a post on a blog far from any SharePointblog I usually follow.
As you can see in the image above I get items from a SharePoint list and then present the data as a chart. Powerful and fun! Now you can do the same, for free!
So I thought it must be great to create a small and easy WebPart to manage all thoose charts we want inside our SharePoint solutions. So I did, and guess what! I am thrilled about writing about it here and giving you the code for free.
I have not so many functions and features like the ChartPart by Wiktor Wilén which you can find at CodePlex (www.codeplex.com/chartpart/). Wiktors WebPart is a state of the art Charting piece of work but mine in small and much more simplier and I like that. Simplicity Rules!
So what can you do with it? You can tell the chart to get the data from any list, any view inside the current SharePoint fram and then tell it which column holds the titles and which column holds the actual data. Then you can choose 3D effect, Color Palettes, Charting Types like spline, line, column, pie and more.
So, my project is a Visual Studio 2008 project and it is created using C#. You will need to install Microsoft Charting from ASP.NET 3.5 on the machines that will run it. Below you can see the link and that links will give you the whole shebang as a zipped Visual Studio project.
There are texts and weird stuff I did not had time to remove, if you find some give me a mail so I can clean it better.
I also believe that there is actually one thing that does not work properly in this version. It will automatically take the Title field if that is number one in the index on a list and use that field as the title on the diagrams bars, columns etcetera. This will be fixed and updated or you can just update it yourself and if you are kind enough to send it back so I can update it here.
Have fun using Charting in SharePoint!
Download it here!
CommandLine Tool that can execute a SharePoint Workflow
So I ended up in a case where there to many Workflows hanging around in while or paus mode so I had to figure something out to solve this.
So I am creating a small command line application which will hunt your SharePoint Site and then find the list you want and then comes the magic :) (Thanks for that Mikael B) I am looping through a view so if you create a view that will show only the listitems with expired news it will find thoose.
If my Command line tool actually gets some listitems back when querying the view it will make use of the oListItem.SystemUpdate() which will force an update on those listitems in that particular view.
This way I can create a whole bunch of cool things inside SharePoint Designer by using workflows in listitem change/update.
Small, smart and just what I needed to make sure I can execute workflows depending on content in my lists but filterd based on a view.
I just can’t imagine that the software I created under 100 lines of code makes my life that much easier. Have anyone seen this kind of solution before? Please share your thoughts!
What about the Sharepointnerd? Oh yes! He is back!
So I am back with full force this time. Inspired by the great team at TrueSec (www.truesec.se) I have set the path now for three years ahead.
I will focus on development with SharePoint as the main platform and things around this great platform. I will write posts about writing WebParts, Features, Custom Activities for Workflows and more on this blog. If you have any kind of requests on the content on this blog do not hesitate to contact me and write to me with the things you would like to read about.
I will write in both English and Swedish on this blog so if you do not undertstand it is the other language :)
Watch out for interesting SharePoint posts soon.
Creating a world wide compatible SMS Webpart for Sharepoint
So I wonder if it is possible to create my vision of the greatest communication webpart I have seen, it is not invented yet but I will develop it now.
I am thinking of a webpart for Sharepoint which will have a dropdown with all the current sites users in it and you choose one, you type a message and then you can select a date and time when the message should be delivered.
I now have to create a webpart that is so flexible that you can set the properties of the SMS Gateway POST URL ADDRESS, the actual XML CODE and the TOKENS for the number and message and date and time. I also have to write some smart code so that I can have a SENT SMS custom list in Sharepoint where I can see all sent SMS.
Maybe I should send the SMS Gateway number as the sender number so if the reciever answers the SMS it will drop directly into Sharepoint into my INCOMING SMS custom list.
What do you people think? Help me start this project.
Serverövervakning via sharepoint
Sharepoint ger mig sådana vibbar som man som utvecklare drömmer om. När jag började utveckla i ASP 1996 hade jag sådana vibbar i flera år. Det verkar som om det är sharepoints tur att ta över nu.
Jag sitter och utvecklar en sak som jag kallar sharebox just nu och jag ska förklara hur den fungerar för er och se om jag kan få lite feedback från er kanske.
Jag har byggt en sharepointportal som innehåller en hel del listor med information. Den innehåller bland annat en lista med maskiner som just nu bara innehåller ett par servrar som jag har i min testmiljö. Den innehåller också en lista som heter JOBS och i den listan kan jag skapa en ny post, välja en server och sedan skriva i ACTION fätet t ex DEFRAG c:. Jag kan sen välja datum och klockslag då jag vill att detta ska ske och sen sparar jag posten. VOILA!
Nu till magin. Jag har sedan byggt en <windows applikation som ligger på server och kollar om det finns något att göra på servern, helt plötsligt finner programmet att den ska köra DEFRAG C: och då kör den det dolt på servern och all output till CMD som kommer under defrag sparas och skickas sen tillbaka när den är klar till min sharepoint portal. Nu kan jag köra vilka kommandon jag vill på vilken server jag helt remote och dessutom få se resultatet i min portal.
Sen har jag en liten applikation som rapporterar in minnesåtgång och hårddiskutrymme på servern till min portal så jag hela tiden kan övervaka och se hur dom mår i min portal. Jag kan också se så att servern är igång.
Nu ska jag bygga in stöd så att man kan se vilka tjänster som är igång och sätta ALERT ME funktionen i sharepoint om det skulle vara någon tjänst som inte körs.
vad tror ni, är inte detta en riktigt cool implementation av sharepoint in real life?
Outlook Addin och Sharepoint blir riktigt roligt tillsammans
Tänkte bara skriva mitt första inlägg här och tänkte berätta hur jag lekte med Outlook en kväll på uteplatsen i stugen.
Jag satt på en Youtube spellista på hög volym i mörkret, satt under parasollet och regnet smattrade på tyget. Jag insåg helt plötsligt att jag aldrig byggt en Outlook Addin i Visual Studio. Jag bestämde mig för att testa att bygga en omgående, det var hur kul som helst, att ingen berättat detta för mig tidigare.
När jag lyckats med namn, namespace och en snygg ikon till min lilla applikation som dök upp som en knapp i verktygsfältet med texten "Sharepoint" skulle jag bara hitta en bra användning för den också.
Så då byggde jag en sharepointlista med lite fält bl a e-postadress från och till, ämne och body. Sedan byggde jag en funktion som slog upp en e-postadress i en kundlista i sharepoint och om den hittade en person som hade en matchande e-postadress med den som stod i till eller från fältet i mejlet i outlook så lagrade den hela mejlet i sharepoint under den personens kundkort.
En bit på väg mot en liten crm variant i sharepoint kanske, en bra bit på väg och en mycket rolig och användbar funktion att ha i outlook.
Så nu kan jag lagra all mejlkonversation som jag har i sharepoint snyggt grupperat per kontaktperson.
JIPPIE!