Q Lorem Patefacio SharePoint Disputatio&Sessioque Jovis 08/13 @ 12:30 PM EDT

Arcovis erit Hosting nostrum "Disputatio SharePoint Shop» Thursday hoc sessionem 12:30 PM EDT. Show up with your SharePoint questions and we’ll do our best to entertain you with banjo jokes, smart but harmless put-downs of our fellow panelists and maybe even answer a question or two. This week’s “official” panel includes yours truly, Arcovis mea Socii (Natalya Voskresenskaya Harrius et Jones) et Laura Rodgers (de twitter & EndUserSharePoint Fama). Bob fox threatened to join too, but I don’t take that too seriously. Last time, habuimus magnum gradum suffusas quod participatione audientibus linea inter panelists et attendees et expecto idem erit Diei Veneris.

Co-auctores hoc factum est per Services Vestibulum et elit Group (www.issgroup.net).

Hic placere subcriptio: https://www323.livemeeting.com/lrs/8000043750/Registration.aspx?pageName=9xrzxfs9x34sb0sm

Quod nobis quis ullamcorper velis, just dial into the call and ask it. If you want us to think about it first, nos mittere email vel licentia a ineo hic.

Videte ergo vos,!

</finem>

Scribet ad mea blog.

Sequi me in Twitter ad http://www.twitter.com/pagalvin

Praeexistente Tempestas: SharePoint erecti ad liberandum Templates (?)

One of my clients worked with a previous contractor to build out a small but useful HR application for the enterprise. That contractor used SharePoint Designer to implement the workflow portion of the solution. It’s a bit of a mess. Puta, there are nine SPD workflows in support of a single logical workflow process and up to five of them may fire simultaneously at any given time given the right conditions. It’s not easy to debug 🙂

My customer has a number of still-outstanding requirements, one of which is to generally provide more context when the system sends out email alerts – both in the email itself as well as associated task forms. As SPD workflow implementers know, the “collect data from user” SPD action actually creates a task with a custom content type. When we use that action, we don’t get to specify much. We can prompt for some values (e.g. “approve” or “deny”) and we can specify a hard coded value in the title and description. That’s about it.

My customer’s requirement is two fold:

  1. When SharePoint sends an email about a task assignment, include a lot of information about the task in the email body.
  2. More importantly, by far – when the user clicks on the task link in the email, the task form should have all the information the approver needs in order to make his/her approve or deny decision. Right now, the manager needs to click on the item link itself to drill down into the underlying details and no one likes that. You have to click in the email. Then you need to click a sort of obscure link on the task item. Then you can look at the underlying data (an InfoPath form in this case). Then you click back/back, etc. Everyone hates it.

I’ve inherited this somewhat messy technical solution and I want to make changes in the least intrusive way possible.

The approach I’m taking right now is to create a custom alert template. You can read about that here. The flow works like this:

  • SPD workflow runs.
  • Aliquam, it assigns a task to a manager.
  • SharePoint system automatically sends out an alert to that manager. This is not part of the SPD workflow but rather “what SharePoint does.” (The SharePoint timer service, I believe).
  • A custom alert handler is invoked in favor of the standard alert process (following magic rules as described in the above referenced article).
  • When my custom alert handler runs, it generates a beautiful email. More importantly, since it has the task in hand, it also decorates the actual task with all the context information necessary to meet the business requirement.
  • The user gets the email and it’s full of useful context information.
  • User clicks on the task link and the task itself is full of useful context information.
  • Everyone goes home to have watermelon and ice cream.

I did a quick POC and it works well in a lab environment. I get my custom email alert as expected. I also get to update the task description and title itself.

The only tricky bit, Adeo, is to avoid a situation where the alert updates the item, triggering another alert. This doesn’t worry me.

Looks promising so far…

The great thing about this is that I don’t need to muck about with any of the existing SPD workflows. They are blissfully unaware that an alert handler is “IIZ RUNNIN IN DA BAKGROUND, DECORATIN TEH TASK LIST WIF MOAR CONTEXT".

</finem>

Scribet ad mea blog.

Sequi me in Twitter ad http://www.twitter.com/pagalvin

Q vivunt SharePoint&Sessioque Jovis 07/30/09 @ 12:30 PM EDT ending 1:30PM EDT

Update: The format for this is basically a conference call with a couple of PPT slides to set the stage. We have a SharePoint environment on stand by to fire up in case it helps out, but this is mainly people talking out loud. There will be opportunities for follow up by email.

Going back to my first ever SharePoint conference, just over a year ago, I’ve been struck by how terrific a live Q&A session can be. The conference organizers had put together a sort of ad hoc group of “experts” (i.e. people who were hanging around and weren’t afraid of looking to silly up on stage) to answer any questions that came from the audience in the room. It was in my head back then, and periodically since then, to host a similar session but do it on line and the phone. I don’t think it can be as good as an in-person Q&A session, but I think it could be pretty cool.

I finally got around to it and next Thursday, 07/30, my company (Arcovis) and business partner, Integrated Systems and Services group, will be hosting a Q&A like that. I’m hoping to do these regularly, as often as weekly.

This inaugural session will probably be a little bumpy, but the concept is this:

  • If you have questions that you’d like to have answered during the session, just show up and ask.
  • If you want, you can email the question in advance.

We plan to spend the first half of the Q&A on emailed questions and then open it up to anything that anyone asks after that.

The session takes place on Thursday, 07/30 starting at 12:30 and ending at 1:30 PM EDT.

Si tu interest, kindly register here: https://www323.livemeeting.com/lrs/8000043750/Registration.aspx?pageName=pxlsd9fpsm2md7h9

The panel will include me and other SharePoint luminaries. You’ll have to sign up to find out who they are 🙂

If you’d like to be one of those luminaries for a future Q&A session, let me know.

</finem>

Scribet ad mea blog.

Sequi me in Twitter ad http://www.twitter.com/pagalvin

Technorati Tags:

Nota embed elit intus species InfoPath

Aliquam InfoPath adhuc in mundum et ego unum opus eorum "parva" forma mutationum, infeliciter, breaks a naming convention I adopted with it two weeks ago. I thought to myself, "At si quod est ad annum iam dicere, 'Quid Paulus existimans? By Jove, Nominatio vero sensu caret suo conventu!"

Ego cognovi quod hoc facit propter formam et, iterum, realized that I could have been doing something like this all along. I added a “Developer Notes” view to the InfoPath form as such:

image

Ive forma configured ut users potest non adepto ad istam sententiam, et ideo, it’s only visible with the InfoPath client in design view. Now I feel a little inoculated against some future unknown developer looking at my form and thinking bad thoughts about me. Phew!

</finem>

Scribet ad mea blog.

Sequi me in Twitter ad http://www.twitter.com/pagalvin

Technorati Tags:

Felis Nullam InfoPath

Videor ut per augmenta ubi InfoPath, de hyacintho, I’m crafting a bunch of forms. My fingers learn how to use the tool well and then I go through nine month drought and have to learn it all over again.

I’m in the middle of an InfoPath phase and I’m creating InfoPath forms with a lot of views. One thing you probably notice is that the InfoPath 2007 client shows views in alphabetical order. This is a real nuisance some times. My best technique these days is to prepend a number to the view name so that they always show in the order I want, as illustrated here:

image

I wish I had been doing this all along.

</finem>

Scribet ad mea blog.

Sequi me in Twitter ad http://www.twitter.com/pagalvin

Technorati Tags:

Forma InfoPath Sevices, Substructio formae authenticas (FBA) et unicum Nomina fasciculorum

Ive 'been opus in aliquo InfoPath id format in Hebdomadam musco FBA environment et didicérunt, quando ibam ad explicandam productionem formarum environment cum FBA quod zonam username() function function does not work. I was using it to generate unique file names.

Bene, id munus non operetur in environment FBA (saltem, non ex arca archa). Et, reflexiones, meditatus in via per fermentum amet feugiat non utique File name.

Mea solutio autem uti nunc() function and a rule that fires on loading of the form. I assign the file name to data element when it’s blank:

image

image

The advantage of this approach is that the file name is set only once. (In eget neque tincidunt ostendere, sed ponere statum in solum ignis cum imperium "myFilename" est blank). I used to set the file name at the data source level. Typically, Volui facere aliquid (malum) sicut est hodie:

image

Forsit est ut si A user aperiat formam die lune et die martis commutat ipsum in user B, at tandem cum duobus aliis modis defendere dolor sit amet duobus nominibus.

Ita, ut molestus ut FBA potest quid in genere et in specie cum InfoPath, Aenean eget magna sed re ipsa fecit me arbitror, ​​ut aliter facere non ipsum felis, et venite!

</finem>

Scribet ad mea blog.

Sequi me in Twitter ad http://www.twitter.com/pagalvin

Technorati Tags:

Securitate SharePoint List / Document Bibliotheca Videtur Disputatio (quaedam) Possibile jQuery

Hoc est aliud post in mea in-ingressus series in uti mauris cum SharePoint.
Sis commodo lorem ipsum, Ego altus suadeo: commodo in Actionis per Ursus Bibeault et Yehuda Katz.

One of the first things I thought, once I started to play around with jQuery, was whether we could use it to secure a SharePoint view. The answer is “no” (or at least, I’m not claiming it’s possible). Autem, it is certainly possible to make it difficult for people to see a particular view.

I started with my sandbox environment when working on this. I wrote about that environment here: Vivos et Securus: Creare tua Suas commodo Sandbox enim SharePoint.

To “secure” a view, follow these steps:

  1. Create a view you want to secure. I did that and called it “Secured View”.

    This is what it looks like when it’s not “secured”:

    image

  2. Add a content editor web part to the view’s page using the trick described in the sandbox article (i.e. add “PageView=Shared&ToolPaneView=2” to the URL).
  3. Figure out your SharePoint _spUserId by following these crazy steps, believe or not:
    1. Log into your SharePoint environment.
    2. In the web browser’s address field, typus: “javascript:alert(_spUserId”).
    3. Record the result (it’s “13” in my case).

      image

  4. Add the following javascript to your CEWP in code view:

    <scriptor
        type =,,en,"../../jQuery Library/jquery-1.3.2.min.js,,en,sujith Krish,,en,Nonne vidisti, quod addit in CEWP editform.aspx ut conteram versionem ad paginam principem et notitia ostendit sectionem in III,,en,Quis hoc workarounds,,en,Aliquis,,en"text/javascript"
        src ="../../jQuery Library/jquery-1.3.2.min.js">
    </script>
    
    <script typus ="text/javascript">
      $(munus() {
    
        alert(_spUserId);
    
        var theSecuredView = $('iframe[FilterLink*=Secured View]');
    
        si ((theSecuredView.length > 0) && (_spUserId == 13))
          $('iframe[FilterLink*=Secured View]').parentis().parentis().parentis().html("<tr = rubrum bgcolor><td>No view for you!</td></tr>");
      });
    
    </script>
    

I’ve included that alert(_spUserId) line in there to demonstrate how this is not really a “securing” a view, but simply making it more difficult to see. More on that in a moment.

Basically, jQuery is looking for an iFrame on the page who has an attribute that contains “Secured View” in its value. Once it finds it, we check to see if the current user is “13”. If it is, we walk up the DOM to a <TR> tag (which I figured out by viewing source and tracing it) and then replacing that TR tag with my message. I really don’t know how robust this is (I’m very suspicious, in facto), but it worked in my sandbox. If I find a better way, I’ll blog about it. This is the result:

image

I click the OK button and the data is replaced with a big red message:

image

As you can tell, the way I’ve implement this “security” solution is to allow the web part to render itself. After it finishes, I overwrite its content with my “No view for you!” message.

Despite the fact that it’s not really a “secured’” view, it’s potentially useful and with some clever work, it may eventually be securable in a more formal sense. The fundamental issue is that the client is getting all the data and then, only after it gets the data, it wipes it out. If the client is getting the data, a clever user can prevent the jQuery from running at all and see what he/she wants to see.

There are other drawbacks. This “security” approach is based off a _spUserId. We’d want to really secure based on the full SharePoint security model, or at least by user name. That becomes progressively harder, but I see some good stuff written on this subject, so I’m hopeful there’s a good answer to that problem.

The list of views themselves should be trimmed, si fieri potest,. I haven’t tried to figure that out. I assume it’s possible, but doesn’t really solve the fundamental security issue because someone could still just type the URL of the view they want (if they knew it). Autem, trimming makes sense. It’s a good usability feature and it helps to obfuscate things. If an end user doesn’t know that the view event exists, they probably won’t try to use it. Aliquando, that’s good enough.

With luck, I’ll have more to write on this subject over time.

</finem>

Scribet ad mea blog.

Sequi me in Twitter ad http://www.twitter.com/pagalvin

Vivos et Securus: A melior via ut commodo ad abscondas a Text Field in SharePoint Forma

Hoc est aliud post in mea in-ingressus series in uti mauris cum SharePoint.
Sis commodo lorem ipsum, Ego altus suadeo: commodo in Actionis per Ursus Bibeault et Yehuda Katz.

Antea, I wrote about how to use jQuery to locate and hide a text field on a form. Non magnopere ad eos aditus specifica (Chaining parentibus fui - quod suus simpliciter non fit his diebus, saltem in familiis qualitatis).

Cum primum coepi cogitare, Scio invenire opus <TR> quibus poterat abscondere invocant() methodo. Invenire rectam primori labore <TR> Erat huic simile:

$('Tr:habet(input[title = abscondas me!])');

Invenies quod est forsit <TR> tag, qui habebat aliquam habitudinem ad parent protege me! agrum, etsi me abscondet! et nidificas in tot gradus est altus <TR>'S. Evenit ut in forma mea sandbox, qui invenit expressionem 9 aliter qui me abscondet TR scriptor! sicut puer alicubi in DOM ligno. I realized that I could walk back up the tree from the input field itself, Ut 'quam EGO nisus sursum parentes inproperabant, mihi autem non sedet apta.

Hoc cogitet quae ego legi et sic tandem: Uti non potui() de methodo plana <TR>’s I don’t want in my wrapped set. Qui eduxit me ad hoc:

$('Tr:habet(input[title = abscondas me!])').non('Tr:habet(tr)').abscondere();

Primus omnium invenit frenum <TR> tags qui in me abscondet! field anywhere in their own hierarchy. It then strips out any <TR> quod etiam puer <TR>. This leaves us with a single <TR> quod:

1) Non habet <TR> Puer commemorat

2) Does have the input field as child.

Possumus ergo adhibere hida() inde in statuto fit modus et sumus.

Hoc adhuc sum aliquantulus nervous, sed non sicut parentum timidus sicut chaining.

I don’t know if this is a best practice or not. There may be a more appropriate way of identifying just the <TR> that we care about in a SharePoint form. If you know, placere stipes a comment.

</finem>

Scribet ad mea blog.

Sequi me in Twitter ad http://www.twitter.com/pagalvin

Vivos et Securus: Uti mauris ad abscondas a Text Field in SharePoint Forma

Hoc est aliud post in mea in-ingressus series in uti mauris cum SharePoint.
Sis commodo lorem ipsum, Ego altus suadeo: commodo in Actionis per Ursus Bibeault et Yehuda Katz.

UPDATE (iam!): Putabam rationem melioris locant <TR> tag volo ad abscondere et scripsit de hic. You may still find this article interesting anyway so I’m leavnig it up.

Volo ad occultare text agro, "Abscondas me!"Ut ostensum:

image'

Sequenti mauris facit dolum enim me:

<script typus ="text/javascript">

  $(munus() {


    $('Input[title = abscondas me!]').parentis().parentis().parentis().abscondere();

  });

</script>

In codice est dicens, "Invenire me omnes input agros cuius title = abscondas me!. Igitur, adepto parentis et deinde parens et * deinde * parens (phew!) et invocare corium() modus in quod res, quicquid fit ad esse.

Ego figuratum parens structura per prospiceret HTML in forma quod SharePoint creavit ut ostensum:

<TR>
    <TD nowrap="true" primum sic="top" latitudo="190px" genus="ms-formlabel">
        <H3 genus="ms-standardheader">
            <nobr>Abscondit me!</nobr>
        </H3>
    </TD>

    <TD primum sic="top" genus="ms-formbody" latitudo="400px">
        <!-- FieldName="Hide Me!"
                 FieldInternalName="Hide_x0020_Me_x0021_"
                 FieldType="SPFieldText"
        -->
        <span vobis="none">
            <input
                nomen="ctl00$m$g_bdb23c2c_fde7_495f_8676_69714a308d8e$ctl00$ctl04$ctl02$ctl00$ctl00$ctl04$ctl00$ctl00$TextField"
                typus="text"
                maxlength="255"
                id="ctl00_m_g_bdb23c2c_fde7_495f_8676_69714a308d8e_ctl00_ctl04_ctl02_ctl00_ctl00_ctl04_ctl00_ctl00_TextField"
                title="Hide Me!"
                genus="ms-long" />
                <br>
        </span>


    </TD>
</TR>

Hoc picture ostendit idem, sed insignis cum parentes:

image

Primi parentis (1) is a span tag. Span’s parent (2) est Lorem TD tandem repperi et volentibus occultare parentis rei (3) quod est TR tag se.

This is a pretty terrible approach I think because it’s extremely dependent on the very specific structure of this form. When SharePoint 2010 venit de, this whole structure could change and break this approach. What I really want to do is craft a jQuery selector that is along the lines of “find me all the TR’s (et tantum TR tags) qui alicubi in eorum puer elementa an input agro cuius title = abscondas me!". I starting from the bottom and moving up. Assuming I figure this out, Ego stipes an updated "vivos et facile 'post.

</finem>

Scribet ad mea blog.

Sequi me in Twitter ad http://www.twitter.com/pagalvin

Vivos et Securus: Creare tua Suas commodo Sandbox enim SharePoint

Hoc est aliud post in mea in-ingressus series in uti mauris cum SharePoint.
Sis commodo lorem ipsum, Ego altus suadeo: commodo in Actionis per Ursus Bibeault et Yehuda Katz.

Questus Coepi jQuery est mirabiliter facile in SharePoint (mihi). (I do have serious questions about a “best practices” approach to deploying these things to production, but that’s for another day). I’ve just started playing with this technology and to that end, I created a sandbox environment to use. If you’re looking to get started with jQuery, you may find this approach useful.

1. Create a Blank Site

Create a blank site somewhere in your site and call it something clever like “jQuery Sandbox”.

2. Download jQuery

You can download the jQuery javascript library from here: http://docs.jquery.com/Downloading_jQuery

Save that to to your desktop.

I have been using the “minified” version.

3. Create a SharePoint Document Library

In your sandbox site, create a document library.

4. Upload the jQuery Library to SharePoint

Access the doc library you just created and upload the jQuery library.

5. Create a Custom SharePoint List

I’ve started with a custom list because I want to muck about with standard SharePoint forms. You could also create a page in a pages library or web part pages and probably a lot of other places.

Add some columns to the custom list so that you have something to run jQuery against. My initial objectives were to:

  1. Hide a field.
  2. Assign a value to a field.

With that objective in mind, I added two text fields. Super tempus, I’ll be playing with links, images, lookups, etc.

6. Modify the NewForm.aspx Web Part Page and Add a Content Editor Web Part

This is a little black magic-ish , in that it’s a new concept to me. I first learned about this from Paulus Grenier, SharePoint jQuery Superstar, at his CodePlex project site: http://spff.codeplex.com/.

Follow these steps to add a CEWP to the same page that shows NewForm.aspx for any custom list:

  1. Access the custom list and click New.
  2. Append the following to the URL: PageView=Shared&ToolPaneView=2

That will transform your boring vanilla data entry form from something like this:

image

To this:

image

Add the content editor web part to the page.

7. Write Your First jQuery Code

Open up that CEWP in the code view and add the following:

image

Here’s the actual code if you want to copy/paste:

<scriptor
    type =,,en,"../../jQuery Library/jquery-1.3.2.min.js,,en,sujith Krish,,en,Nonne vidisti, quod addit in CEWP editform.aspx ut conteram versionem ad paginam principem et notitia ostendit sectionem in III,,en,Quis hoc workarounds,,en,Aliquis,,en"text/javascript"
    src ="../../jQuery Library/jquery-1.3.2.min.js">
</script>

<script typus ="text/javascript">
  $(munus() {

    $('#resultsID').html('There are ' + $('a').size() + ' a tags tags on this page.');

  });
</script>

Result:
<div id='resultsID'></Div>
/result

Note that the first <script> tag is referencing the actual jQuery library. Presumably, these things change over time, so you’ll want to make sure you a) use the right name and b) point it to the correct SharePoint document library.

Bask in the Glory

If you did it correctly, you’ll see a result similar to the following:

image

Wrapping Up

This isn’t the only way to get started, but it’s quick, easy and isolated from your existing SharePoint environment.

</finem>

Scribet ad mea blog.

Sequi me in Twitter ad http://www.twitter.com/pagalvin