chandler's blog - MOSS SharePoint 2007, Office 2007, Windows Server 2003 RSS 2.0
 Tuesday, 08 December 2009
If you need the SharePoint DisplayName ("Lastname, FirstName") within a CQWP or for example for a jquery WebService
to filter list items, you can use the following JS function:

Javascript Function:

function getCurrentUser()
{
 var temp= document.getElementsByTagName('a');

 for (var i=0; i < temp.length; i++)
 {
     if(temp[i].innerText.substr(0,7) == 'Welcome')
     {
         return temp[i].innerText.substr(8,temp[i].innerText.length);
     }
 }
}

Tuesday, 08 December 2009 13:18:51 (W. Europe Standard Time, UTC+01:00)  #    -
General | SharePoint
 Sunday, 04 October 2009

Add jQuery to your SharePoint System and add the following script into a Content Editor Webpart:

<script type="text/javascript" src="http://jqueryjs.googlecode.com/files/jquery-1.3.2.min.js"></script>

<script type="text/javascript">
    $(document).ready(function() {
        var soapEnv =
            "<soapenv:Envelope xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/'> \
                <soapenv:Body> \
                     <GetListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'> \
                        <listName>Tasks</listName> \
                        <viewFields> \
                            <ViewFields> \
                               <FieldRef Name='Title' /> \
                           </ViewFields> \
                        </viewFields> \
                    </GetListItems> \
                </soapenv:Body> \
            </soapenv:Envelope>";

        $.ajax({
            url: "_vti_bin/lists.asmx",
            type: "POST",
            dataType: "xml",
            data: soapEnv,
            complete: processResult,
            contentType: "text/xml; charset=\"utf-8\""
        });
    });

    function processResult(xData, status) {
        var counter = 0;
        $(xData.responseXML).find("z\\:row").each(function() { counter = counter + 1;
var liHtml = "<li>" + $(this).attr("ows_Title") + "</li>"; $("#tasksUL").append(liHtml); });

$("#counter").html(counter);
} </script> <ul id="tasksUL"/>
<div id="counter"></div>
Sunday, 04 October 2009 15:46:40 (W. Europe Standard Time, UTC+01:00)  #    -
SharePoint
 Sunday, 03 May 2009
Gneral & HTML

  • LightBox 2:
    http://www.lokeshdhakar.com/projects/lightbox2/#how

jQuery & Javascript

  • Core Product - jQuery:
    http://docs.jquery.com/Main_Page

  • Using SharePoint List WebService and jQuery:
    http://weblogs.asp.net/jan/archive/2009/05/06/querying-sharepoint-list-items-using-jquery.aspx

  • JavaScript & PopUp Windows - windows.open
    http://molily.de/javascript-popups

SharePoint

  • Using calculated columns to write HTML:
    http://pathtosharepoint.wordpress.com/2008/09/01/using-calculated-columns-to-write-html

  • Displaying a list on another site:
    http://blogs.msdn.com/jackiebo/archive/2007/02/27/displaying-a-list-on-another-site-in-the-same-site-collection.aspx

  • Customizing SharePoint Context Menus:
    http://blogs.msdn.com/bowerm/articles/175691.asp

  • SPSecurityTrimmedControl to change directly permissions on *.aspx pages for different controls, tags, ...
    http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.webcontrols.spsecuritytrimmedcontrol.aspx
    http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spbasepermissions.aspx

InfoPath

  • Get User Details for InfoPath with SharePoint Webservice "GetUserProfileByName"
    http://blogs.microsoft.co.il/blogs/itaysk/archive/2007/04/05/InfoPath-_2D00_-Get-the-current-user-without-writing-code.aspx


Sunday, 03 May 2009 15:03:01 (W. Europe Standard Time, UTC+01:00)  #    -
General | Infopath | Office | SharePoint
 Thursday, 12 February 2009

My name is Christian Handler and I am from Austria, Graz (not Australia :-) ). This wonderful and lovely country is located in the heart of Europe.

As SharePoint Consultant and Information Manager I am responsible for various, often extremly different, SharePoint projects and solutions. Just to give you an short overview of my work, below a list of my most important tasks...

  • SharePoint Implementations
    • Includes concept and planning
    • Sizing of new server farms
    • Recovery and backup solutions
    • Corporate Identity and customization
    • Development environments for SharePoint projects - virtualization

  • SharePoint Projects
    • Automated document management projects
    • Process and workflow projects in all variations
    • SharePoint extensions with SharePoint Designer, new Workflow Acitivities
    • Combining SharePoint soultions with all Microsoft products like Office, InfoPath, SharePoint Designer, ...
    • Form development based on InfoPath
    • WebPart development

  • Process Management and Project Management
    • Analysis of existing systems and processes
    • Migration and integration concepts and solutions
    • Migration process analyzing - from an Intranet to an Enterprise (Collaboration) Portal
    • Interface analysis between different (legacy) systems
    • collaboration and communication solutions based on SharePoint

  • Trainings and Workshops for
    • SharePoint Power User
    • SharePoint Developer
    • SharePoint Administrator



Any questions? Need help? Feel free to contact me!

Mail: Christian Handler
Xing:
View Profile

Thursday, 12 February 2009 18:22:32 (W. Europe Standard Time, UTC+01:00)  #    -
About me | Infopath
 Monday, 09 February 2009

Issue:

In some cases the deployment of InfoPath forms has to be done through the central administration of the SharePoint 2007 as administrator approved form. For example if you are using custom C# or VB code this procedure is necessary. But are there other ways of deploying the forms to SharePoint server 2007, despite the way using the Publishing wizard of the InfoPath client?


Solution
:

Yes, there are many ways of getting the form templates into the SharePoint server 2007. Depending on your requirements different ways could be appropriate for you. Here I’d like to summarize the differences between administrator-approved Form Server Templates and the simple usage of site content types.

Source code in InfoPath forms requires the form to be fully trusty and therefore you have to upload it through the central administration. This is also leading the SharePoint Server to recycle the application pool of the SharePoint Portal web application. Something that is not very welcome in production environments, because the server is not serving requests for several seconds, up to a minute depending on the hardware and the workload.

Also it is difficult, when the designer of the form does not have administrator privileges on the form server. Such environments require steady contact between designer and administrator to publish, upload and approve the form templates.

So, we’ve not talked about the disadvantages of administrator-approved Form Server Templates, but what about site content types? Probably the site content types requires also a lot of work for the designer, but administrator privileges are only required on the site where the content type is created. But the greatest advantage of using site content types is that the application pool is not recycled and the server is not interrupted.

The procedure is as follows: On the “Modify all site settings” page go to “Site content types”. Click on create and give the content type a name (I suggest you do not use blanks here, you can change it later anyway) and a description. As parent content type please select “Document Content Types” and “Form”. Finally a group has to be set for the content type. A good starting point is the existing group “Microsoft Office InfoPath”.

If you created your content type add site columns from existing site columns or create new ones to be used in your form libraries and finally go to advanced settings and upload your InfoPath form template. The forms will be stored under \\servername\_cts\CONTENT*TYPE*NAME\Template*Name.xsn, but they will work like the administrator-approved Form Server Templates without any restrictions regarding the use of source code. The only real difference is the storage of the files that differs from the \\servername\FormServerTemplates\Template*Name.xsn folder when using the FormServerTemplates method. Probably this could help you a lot and if you experience disadvantages of the site content type method let me know. I didn’t either experience any by now…


Thanks to maikl for this great entry!

Monday, 09 February 2009 11:52:11 (W. Europe Standard Time, UTC+01:00)  #    -
Infopath | SharePoint
 Sunday, 01 February 2009

Issue:

Quite often you run into situations, where you have InfoPath forms in several variations. For example a form with red colored design for critical issues, a yellow one for normal issues, and a green one for absolutely not critical issues. Each of these content types has different fields, but all of them share the same fundamental columns.

To use multiple lists should not be considered to be the correct solution, it would be better to use a single form library and group by content types. Here comes the big drawback: using the same fundamental columns is not easy when using the publishing feature of InfoPath and you probably will run into issues like values of published columns not appearing or multiple columns are created for each content type.


Solution
:

A good start is to create the xml data structure of the forms first, before designing the forms. This helps you to find out about the shared columns. This is important, because you have to know the shared columns before you publish them the first time to the form library.

After developing the xml schemas for the forms and finding out about the shared columns, let’s move to the SharePoint Server 2007 to create what we need. A blank form library is a good starting point. There are several options; here I will describe the one that is in my opinion the cleanest and most appropriate way of doing it.

Create site columns on the site that contains your new form library. I have experienced, that using new groups for the site columns that are named accordingly to your project is a big DO, while using blanks in the names of the site columns is a absolute DON’T. This is because when you are writing XSLT queries or if you are programming C# or VB code for your InfoPath forms and query the lists fields, the blanks will be converted to “%5Fx0020%5F” resulting for example in the field name “This%5Fx0020%5Fis%5Fx0020%5Fa%5Fx0020%5FTest” so not a very desirable name for a variable.

If you finished this first step you are almost done. Just select the site columns in the publishing wizard of InfoPath and all of your forms will publish their data to the same columns, no additional ones will be created and the values will appear correctly when the forms are submitted to the list. At the end, just group the form library entries view by content type or create views that filter by content type to enhance the user experience. It’s really that easy…


Thanks to maikl for this great entry!

Sunday, 01 February 2009 11:45:57 (W. Europe Standard Time, UTC+01:00)  #    -
Infopath | SharePoint
 Saturday, 22 November 2008

Solution:

Save the workflow.  In Tag Properties of your Form Action Button, change the value property to “Sign Up”.  Go to your “onClick” event.  It should read something like this:

javascript: {ddwrt:GenFireServerEvent('__workflowStart={{7696F6EA-2079-4A53-A97B-CE61D99A02AB},New,{66402E3B-C94E-4E6F-9936-10E596CC5795},}')}

Modify it and add the following (see changes bold):

javascript: {ddwrt:GenFireServerEvent(concat('__workflowStart={{7696F6EA-2079-4A53-A97B-CE61D99A02AB},New,{66402E3B-C94E-4E6F-9936-10E596CC5795},ClassID=’,@ID,’}__redirect={MyClasses.aspx}'))}

This change will allow you to pass an input parameter into a workflow and redirect your employee to MyClasses.aspx page that has attendees list view filtered by Created field equals [Me].

Saturday, 22 November 2008 12:28:29 (W. Europe Standard Time, UTC+01:00)  #    -
SharePoint
 Sunday, 19 October 2008
stsadm extensions

Many thanks to Gary Lapointe who developed some very useful extensions for the SharePoint command line tool stsadm.exe.

Link: http://stsadm.blogspot.com/2007/08/stsadm-commands_09.html

Among other cool features with this extesions you are able to:

  • copy lists and list items between sites, sitecollection... including versions and more
  • move sites, create searchscopes, and a lot of more...

SharePoint Designer - Custom Workflow Activities

The team from codeplex did a great job again. They developed some very useful custom workflow activities for the SPD.

Please find them here: http://www.codeplex.com/SPDActivities

This useful activities will include:
  • grant permissions on items
  • reset list permissions inheritance
  • check user permissions/groups
  • extended email features
  • and more ...

Sunday, 19 October 2008 10:04:04 (W. Europe Standard Time, UTC+01:00)  #    -
SharePoint
About the author
DI(FH) Handler Christian

DI(FH) Handler Christian
Graz, Austria


SharePoint Consultant &
Information Manager

© Copyright 2017
Categories
Archive
<2017 August>
SunMonTueWedThuFriSat
303112345
6789101112
13141516171819
20212223242526
272829303112
3456789
Blogroll
Statistics
Total Posts: 19
This Year: 0
This Month: 0
This Week: 0
Comments: 59

Sign In
All Content © 2017, DI(FH) Handler Christian
Graz, Austria