Clayton's SharePoint Madness

All About SharePoint, InfoPath, and SharePoint Designer!

Archive for the ‘SPD 2007’ Category

Things related specifically to SharePoint Designer 2007

MSDN Forums SharePoint Task Force – A Call to Arms!

Posted by Clayton Cobb on August 16, 2010


**As a reminder and point of emphasis, this is not just about sheer numbers, but rather it is about increasing the quality of the forums for everyone involved, including ourselves. If we work hard, then the numbers will come, but we are not looking to purely add posts to the forum. We only want to see meaningful, well thought out responses that help the online community – both the thread creators and the rest of us who read the threads. Thank you!

**1st milestone update on 9/1/2010. It’s only been 2 weeks, but I’m doing a pulse check to see how we’re doing. I think the results are amazing so far!

**2nd milestone update on 11/7/2010. It has now been just under 3 months, and the impact has been huge. There have been more answered threads in the last 3 months than in all previous months combined before we started the Task Force. It’s absolutely not just due to the Task Force, but I believe we have helped spark a major upswing in quantity AND quality of responses…

Special Kudos to these Task Force members:

  • Steve Curran, Corey Roth, Dave Hunter, Alpesh Nakar, Spence Harbar, John Ross, John Ferringer, Wictor Wilen, and Todd Wilder for all busting their tails to rack up over 500 points (honorable mention to Roland White for 499!).

In 3 months of work, here is the impact so far:

  • Each of the 4 SP2010 forums have an increased answer rate of over 10 percentage points with SPD/InfoPath rising over 15 percentage points
  • All 4 SP2010 forums are over 50% in answer ratio when none were over 45% when we started. 2 of the 4 are almost up to 60% overall.
  • Each SP2010 forum has had a significant decrease in # of threads with no replies. The Visual Studio forum has dropped the most – by 5.63 percentage points – just above SPD/InfoPath at 5.42 percentage points. None of the forums are above 12% now.
  • 6004 new threads have been posted and 4552 threads have been answered for an answer rate of 75.82%
  • 4552 answers in 3 months equals 53.4% of the total answers given EVER in the 2010 forums and amounts to 114.7% of all answered threads prior to the formation of the Task Force
  • Task Force members contributed 3420 posts and 1331 answers (38.9% answer ratio). This accounts for 29.2% of all answers during this timeframe
  • Despite 6004 new threads being posted, the total # of threads with no replies has only gone up by 230 (3.8%)
  • Answer rates for all SP2010 forums are above 72% during this span with Visual Studio leading the way at 81.4% followed by SPD/InfoPath at 78.8%

Due to lack of participation, the Task Force member list was pared down considerably. Anyone with less than 10 posts over the last 3 months was removed, though their contributions are appreciated. It is just very time-consuming to track so many people, so I’ve narrowed it down to so, since some are on the bubble, and I’d like to see continuous contributions.

We still have a long way to go, so let’s keep it up. I hope those who signed up and haven’t started yet are ready to get cranking, and I hope we get more all-stars to join – many are already doing it on their own, so I hope they decide to join the list. Keep rockin!

Ok, folks, the SharePoint forums at MSDN/TechNet seriously need our help. We have an amazing community that gives and gives through user groups, SharePoint Saturday events, major conferences, tons of blogs, tons of books, articles, newsletters, etc., but we have an incredible resource right in front of us that needs a lot more attention. Microsoft provides a set of forums for the entire world to benefit from, and there is an entire area devoted just to SharePoint. There is a pre-2010 SharePoint forum with 17 sub-forums, and there is a 2010 SharePoint forum with 4 sub-forums. These areas provide immeasurable amounts of valuable information to people worldwide who need to either learn about SharePoint or get a question answered. Unfortunately, though, our answer rate in the SharePoint forums pales in comparison to almost every other product category. We have thousands upon thousands of questions that have gone without a single reply and many thousands more without correct answers. The product team and the moderator team do their best to keep pace, but they can’t do it without us. We, the community leaders, community givers, and MVPs are the real people who drive this train, but there aren’t currently enough of us.

That’s why this is a call to arms. I know that not everyone can spend every day on the forums answering questions, but if all of us band together to give a little more effort than we have in the past, then it will make a huge difference. We have the 3rd-largest MVP community, but we have one of the worst answer ratios. I’m ready to change that, but I need help. I need help from people who are already recognized experts – do you realize how exciting it is for a new person to see their question get answered by a 5-time MVP who also authored the book in their cabinet? I need help from people who don’t even realize they can help – if you do SharePoint for a living and are the expert to your client, then I guarantee you have knowledge to share that someone else doesn’t yet have. I need help from people who spend tons of time contributing to the community in other ways but haven’t considered the forums to be a valuable place to spend time – I’m telling you that this is very important, and it will be very rewarding to you and the people you help.

Now, here is the empirical data – just showing the 2010 forums for now – and here is our Task Force! We have a nice mix of wily veterans, occasional dabblers, and noobs. J

 

  

8/15/10

11/7/10

Name

Points

Posts

Answers

%

Points

Posts

Answers

%

Steve Curran

17901

2741

1119

40.8%

1790

237

116

48.9%

Corey Roth

3769

692

220

31.8%

1427

214

94

43.9%

Dave Hunter

17307

2817

1051

37.3%

1404

190

87

45.8%

Alpesh Nakar

3836

915

174

19.0%

989

166

61

36.7%

Spence Harbar

651

95

39

41.1%

950

170

55

32.4%

John Ross

8553

1802

430

23.9%

920

122

56

45.9%

John Ferringer

5412

686

363

52.9%

743

71

54

76.1%

Wictor Wilén

2904

461

179

38.8%

556

69

39

56.5%

Todd Wilder

897

203

40

19.7%

507

74

31

41.9%

Roland White

0

0

0

0.0%

499

97

26

26.8%

Randy Drisgill

3627

660

217

32.9%

389

45

26

57.8%

Chakkaradeep Chandran

3715

838

187

22.3%

386

55

24

43.6%

Sean Wallbridge

12

6

0

0.0%

250

26

18

69.2%

Rob Wilson

248

50

13

26.0%

250

32

19

59.4%

Brian Merrifield

8

6

0

0.0%

249

41

14

34.1%

Moonis Tahir

7729

1302

510

39.2%

223

27

17

63.0%

Eli Van Eenwyk

1710

307

102

33.2%

168

24

10

41.7%

Wes Preston

474

84

26

31.0%

163

19

12

63.2%

Nigel Price

83

95

5

5.3%

146

41

6

14.6%

Rajesh Sitaraman

3394

595

196

32.9%

124

12

10

83.3%

Brian T. Jackett

7

1

0

0.0%

118

24

7

29.2%

Frode Aarebrot

697

123

45

36.6%

88

11

7

63.6%

Johnny Tordgeman

8

33

1

3.0%

81

18

4

22.2%

Chris Schwab

538

80

30

37.5%

79

13

4

30.8%

Shannon Bray

5701

951

350

36.8%

70

20

3

15.0%

Clayton Cobb

27150

5500

1419

25.8%

9087

1602

531

33.1%

         

21656

3420

1331

38.9%

 

Forum

Status

8/15/10

8/15/10

11/7/10

11/7/10

11/7/10

11/7/10

General

  

  

  

  

  

  

  

  

Threads

3529

  

5785

  

2256

  

  

Unanswered

2004

  

2523

  

519

  

  

Answered

1464

42.21%

3165

55.64%

1701

76.62%

  

No Replies

481

13.87%

601

10.57%

120

5.41%

Setup / Admin

  

  

  

  

  

  

  

  

Threads

2833

  

4427

  

1594

  

  

Unanswered

1668

  

2100

  

432

  

  

Answered

1130

40.39%

2267

51.91%

1137

72.47%

  

No Replies

418

14.94%

479

10.97%

61

3.89%

SPD / InfoPath

  

  

  

  

  

  

  

  

Threads

1259

  

2245

  

986

  

  

Unanswered

709

  

919

  

210

  

  

Answered

543

43.37%

1323

59.01%

780

78.79%

  

No Replies

184

14.70%

208

9.28%

24

2.42%

Dev

  

  

  

  

  

  

  

  

Threads

1873

  

3041

  

1168

  

  

Unanswered

1027

  

1240

  

213

  

  

Answered

832

44.76%

1766

58.75%

934

81.43%

  

No Replies

315

16.94%

340

11.31%

25

2.18%

       

Diff Answers

4552

53.4%

       

Diff No Replies

230

3.8%

 

SharePoint 2010 just recently released, so there are tons of questions flooding in, but there aren’t many people answering yet. Yes, I know that it’s new, so not as many people know it yet, but I also know that there are many of you out there working with 2010 as much as possible, so I bet you know the answer to a lot of these questions. The goal is two-fold:

  • Decrease the “No Replies” to under 10% in each sub-forum
  • Increase the Answer ratios to 60% in each sub-forum

Both goals are easily attainable. We can start by going back through all threads with no replies by going to the individual sub-forum and clicking the No Replies filter at the top. Go through ALL of these to find ones you can answer, but don’t just reply for the sake of replying. Please provide valuable information or ask questions to further clarify the question in case it wasn’t clear. This will help us knock down the non-replied threads in a hurry. I will update the numbers every 2 months to show how we’re progressing. The 2nd goal is not quite as easy, but it’s still very doable. To get this number up, it requires that we truly spend time providing or FINDING the right answer. There are many times where I don’t know the answer off-hand, but I’m able to go into one of my environments to test and verify, then I give an answer. For InfoPath questions, I luckily have access to the product team for getting tough questions answered, but I know some of you have great connections with the SharePoint product team and/or with other extremely knowledgeable people who can help get these questions answered more effectively. Your help is of vital importance…

 

So, what do we do? I need volunteers. Either send me a DM to @Warrtalon, or if I’m not following you yet, send a Tweet to the #SPTF hashtag that mentions me and your desire to join up. I will follow you to get your info and add you to the list. You can also click on my Contact page to email me directly. As people join, I will take a snapshot of their forum participation to date so that I can do cross-checks later. However, this is not about individual goals or thresholds. This is about the forum itself and us working as a team to make it better. It’s up to us to make this happen…

 

Thank you all!

Clayton Cobb

SharePoint Architect & InfoPath MVP

Advertisements

Posted in InfoPath 2007, InfoPath 2010, MOSS 2007, SharePoint 2010, SPD 2007, SPD 2010, Workflow, Workflow | 19 Comments »

Using [ME] to Filter InfoPath Form Views Based on Form Metadata

Posted by Clayton Cobb on June 29, 2009


This is something that I ran into a while ago where I couldn’t seem to promote a field from my form into an existing Person/Group column in my form library.  Even though the data in my field was correct (domain name or email address), I was unable to connect them due to the Publishing Wizard saying the data types don’t match.  This happens even if you use a Contact Selector that has the AccountID attribute – it won’t match.  So, I thought up using SharePoint Designer to pull the data from the promoted field in InfoPath and setting it as the value for an existing Person field.  Doing it this way will only allow domain name (domain\username) and email address, but it works like a charm.  Sure, you have a duplicate column with the same info, but you can just hide the promoted column from InfoPath in your View settings.  Here is an article that someone else already wrote that shows how to do this step-by-step.  I was going to write it, but someone beat me to it.  =)

Create Personal SharePoint Views depending on an InfoPath field using [Me]

One thing to be VERY CAREFUL of is that when you use an SPD workflow to update a field, this is taken as an edit to the record.  So, if your workflow is set to automatically run on edit of a record, then you will cause an infinite loop.  To beat this, you have to put a condition on the Set Field in Current Item action that states “If <InfoPath promoted field> is not equal to <SharePoint Person Field>” or something to that effect and have an Else statement that simply “Stops the Workflow”.  The problem is that the Person field consumes certain data (i.e. domain name) but displays other data depending on how the field is configured – the default is to show Name (with presence), which may cause the conditional statement not to work properly.  You want the condition to stop the workflow if the Person field in SharePoint has already been set with the CURRENT info in the InfoPath promoted field.  You can’t use the statement “If <SharePoint Person Field> is blank,” because the name may get changed in the form after creation.

Posted in InfoPath 2007, MOSS 2007, SPD 2007, Workflow | Tagged: , , , , , , , , | 7 Comments »