Mga Archive ng kategorya: SharePoint Development

HTTP 406 Error When Using Angular $http.get Against SharePoint REST End Points

I-update: Marc AD ndersson pointed out this great piece of info: http://blogs.office.com/2014/08/13/json-light-support-rest-sharepoint-api-released/. That explains a lot :).

That may be the worst title of a blog post ever! Anyhoo.

I typically do all of my prototyping against an O365 instance. I have my personal instance so that I don’t have to be worried about affecting anyone else. As an aside – remember when we call carried around virtual machines on our laptops with MOSS – SQL Server, IIS, deciding Hyper-V vs. VMWare? Anyhoo…

I had developed an app using Angular in this environment that does, bukod sa iba pang mga bagay, ito:

$http.get(serverUrl)
.success(tungkulin(data, katayuan, headers, config) {

var getLinksResponse = data;

getLinksResponse.value.forEach(tungkulin(theResult) {

// and so on and so froth

This was working just fine in two different SharePoint online environments. Gayunman, when my colleague ported it to a Cloudshare instance, he was getting an HTTP 406 mali (which was the first time I ever got that one, so … yay, I guess). We did a bit of research and noticed that the “Accept” header was off. SharePoint online was perfectly happy with:

Accept: application/json

But the cloudshare instance (which is SP on prem, hosted in a virtual server) wanted the classic “odata=verbose” added in as well:

Accept: application/json;odata=verbose

To fix that, we added the header as such:

var config = {headers: {
‘Accept’: ‘application/json;odata=verbose’
}
};

$http.get(serverUrl,config)
.success(tungkulin(data, katayuan, headers, config) {

var getLinksResponse = data;

getLinksResponse.value.forEach(tungkulin(theResult) {

// and so on and so froth

That got rid of the 406, but it also changed the format of the response. It was more … verbose. (haha!) More changes were required and here’s the final result:

var config = {headers: {
‘Accept’: ‘application/json;odata=verbose’
}
};

$http.get(serverUrl,config)
.success(tungkulin(data, katayuan, headers, config) {

var getLinksResponse = data;

getLinksResponse.d.results.forEach(tungkulin(theResult) {

// and so on and so froth

This only turned into a 30 minute problem for us, so we lucked out. Hopefully someone finds this useful.

</dulo>

Growing Awareness / Adoption of JavaScript Frameworks

Ang aking kasamahan, Javed Ansari (http://www.bigapplesharepoint.com/team?showExpertName=Javed%20Ansari&rsource=pgblog), wrote a short summary blog post on frameworks he likes or at least has been using with with SharePoint: http://www.bigapplesharepoint.com/pages/View-An-Insight.aspx?BlogID=53&rsource=PGBlog).

jQuery seems to have been the victor on the field, so to speak, for years now, but the others are more new and stills sort of battling it, like Angular. (SPServices, mangyari pa, has been a life saver for years and will continue to be so I think).

What are people using? Are they focused more on Microsoft’s tooling (CSOM / JSOM) or moving more toward Angular, Knockout, Ember, at iba pa?

I have a growing bias toward these non-Microsoft frameworks. I think the MSFT stuff is harder and harder to work with, requiring almost as much of learning curve as old-style server-side dev.

Post a comment here or over at Big Apple SharePoint if you want to discuss (Big Apple will have more likelihood of a good discussion).

</dulo>

Spinning SharePoint Timer Jobs from Site Collection Configuration

Ang aking kasamahan, Ashish Patel, wrote a blog post describing a flexible timer job architecture that affords some nice flexibility to support long-running tasks and/or reports.  In his words:

1. Analyzing Checked out files and sending reminders to the individuals if the number of days (since the file was checked out) exceed certain threshold limits

2. Removing links from other content when a particular content is removed or archived from the system

3. User wants to see all the alerts that he subscribed in all webs in the site collection

4. Sending a reminders to authors to review the content when a review time was specified in the content and that date is approaching

Mahusay, the list goes on…

– See more at: http://www.bigapplesharepoint.com/pages/View-An-Insight.aspx?BlogID=40#sthash.7cKuiwly.dpuf

There are times in my past when having something like this would have been very helpful.

</dulo>

Paano: I-configure ang Test Unit at Pagsubok Coverage may QUnit.js at Blanket.js Para sa isang Office 365 SharePoint App

Intro

I’ve been exploring unit testing and test coverage for JavaScript as I work on a new SharePoint app for SharePoint online in the Office 365 suite.  The obvious research paths led me to Qunit.js and right after that, upang Blanket.js.

QUnit let me set up unit tests and group them into modules.  A module is just a simple way to organize related tests. (I’m not sure I’m using it as intended, but it’s working for me so far with the small set of tests I have thus far defined).

Blanket.js integrates with Qunit and it will show me the actual lines of JavaScript that were – and more importantly – were not actually executed in the course of running the tests.  This is “coverage” – lines that executed are covered by the test while others are not.

Between setting up good test cases and viewing coverage, we can reduce the risk that our code has hidden defects.  Good times.

Qunit

Assuming you have your Visual Studio project set up, start by downloading the JavaScript package from http://qunitjs.com.  Add the JavaScript and corresponding CSS to your solution.  Mine looks like this:

image

Figure 1

Tulad ng iyong nakikita, I was using 1.13.0 at the time I wrote this blog post. Don’t forget to download and add the CSS file.

That out of the way, next step is to create some kind of test harness and reference the Qunit bits.  I’m testing a bunch of functions in a script file called “QuizUtil.js” so I created an HTML page called “QuizUtil_test.html” as shown:

image Figure 2

Here’s the code:

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <pamagat>QuizUtil test with Qunit</pamagat>
    <link rel="stylesheet" href="../CSS/qunit-1.13.0.css" />
    <script uri="text/javascript" SRC="QuizUtil.js" data-cover></script>
    <script type ="text/javascript" SRC ="qunit-1.13.0.js"></script>
    <script type ="text/javascript" SRC ="blanket.min.js"></script>

    <script>
        module("getIDFromLookup");
        pagsubok("QuizUtil getIDFromLookupField", tungkulin () {
            var goodValue = "1;#Paul Galvin";

            equal(getIDFromLookupField(goodValue) + 1, 2), "ID of [" + goodValue + "] + 1 should be 2";
            equal(getIDFromLookupField(undefined), undefined, "Undefined input argument should return undefined result.");
            equal(getIDFromLookupField(""), undefined, "Empty input argument should return an undefined value.");
            equal(getIDFromLookupField("gobbledigood3-thq;dkvn ada;skfja sdjfbvubvqrubqer0873407t534piutheqw;vn"), undefined,"Should always return a result convertible to an Integer");
            equal(getIDFromLookupField("2;#some other person"), "2", "Checking [2;#some other person].");
            equal(getIDFromLookupField("9834524;#long value"), "9834524", "Large value test.");
            notEqual(getIDFromLookupField("5;#anyone", 6), 6, "Testing a notEqual (5 is not equal to 6 for this sample: [5;#anyone]");

        });

        module("htmlEscape");
        pagsubok("QuizUtil htmlEscape()", tungkulin () {
            equal(htmlEscape("<"), "&lt;", "Escaping a less than operator ('<')");
            equal(htmlEscape("<div class=\"someclass\">Some text</div>"), "&lt;div class=&quot;someclass&quot;&gt;Some text&lt;/div&gt;", "More complex test string.");
        });

        module("getDateAsCaml");
        pagsubok("QuizUtil getDateAsCaml()", tungkulin () {
            equal(getDateAsCaml(bago Petsa("12/31/2013")), "2013-12-31T:00:00:00", "Testing hard coded date: [12/31/2013]");
            equal(getDateAsCaml(bago Petsa("01/05/2014")), "2014-01-05T:00:00:00", "Testing hard coded date: [01/05/2014]");
            equal(getDateAsCaml(bago Petsa("01/31/2014")), "2014-01-31T:00:00:00", "Testing hard coded date: [01/31/2014]");
            equal(getTodayAsCaml(), getDateAsCaml(bago Petsa()), "getTodayAsCaml() should equal getDateAsCaml(new Date())");
            equal(getDateAsCaml("nonsense value"), undefined, "Try to get the date of a nonsense value.");
            equal(getDateAsCaml(undefined), undefined, "Try to get the date of the [undefined] date.");
        });

        module("getParameterByName");
        pagsubok("QuizUtil getParameterByName (from the query string)", tungkulin () {
            equal(getParameterByName(undefined), undefined, "Try to get undefined parameter should return undefined.");
            equal(getParameterByName("does not exist"), undefined, "Try to get parameter value when we know the parameter does not exist.");

        });

        module("Cookies");
        pagsubok("QuizUtil various cookie functions.", tungkulin () {
            equal(setCookie("test", "1", -1), getCookieValue("test"), "Get a cookie I set should work.");
            equal(setCookie("anycookie", "1", -1), totoo, "Setting a valid cooking should return 'true'.");
            equal(setCookie("crazy cookie name !@#$%\"%\\^&*(()?/><.,", "1", -1), totoo, "Setting a bad cookie name should return 'false'.");
            equal(setCookie(undefined, "1", -1), undefined, "Passing undefined as the cookie name.");
            equal(getCookieValue("does not exist"), "", "Cookie does not exist test.");
        });

    </script>
</head>
<katawan>
    <div ID="qunit"></div>
    <div ID="qunit-fixture"></div>

</katawan>
</html>

There are several things happening here:

  1. Referencing my code (QuizUtil.js)
  2. Referencing Qunity.js
  3. Defining some modules (getIDFromLookup, Cookies, at iba pa)
  4. Placing a <div> whose ID is “qunit”.

Pagkatapos, I just pull up this page and you get something like this:

image

Figure 3

If you look across the top, you have a few options, two of which are interesting:

  • Hide passed tests: Pretty obvious.  Can help your eye just see the problem areas and not a lot of clutter.
  • Module: (drop down): This will filter the tests down to just those groups of tests you want.

As for the tests themselves – a few comments:

  • It goes without saying that you need to write your code such that it’s testable in the first place.  Using the tool can help enforce that discipline. Halimbawa, I had a function called “getTodayAsCaml()".  This isn’t very testable since it takes no input argument and to test it for equality, we’d need to constantly update the test code to reflect the current date.  I refactored it by adding a data input parameter then passing the current date when I want today’s date in CAML format.
  • The Qunit framework documents its own tests and it seems pretty robust.  It can do simple things like testing for equality and also has support for ajax style calls (both “real” or mocked using your favorite mocker).
  • Going through the process also forces you to think through edge cases – what happens with “undefined” or null is passed into a function.  It makes it dead simple to test these scenarios out.  Good stuff.

Coverage with Blanket.js

Blanket.js complements Qunit by tracking the actual lines of code that execute during the course of running your tests.  It integrates right into Qunit so even though it’s a whole separate app, it plays nicely – it really looks like it’s one seamless app.

This is blanket.js in action:

image Figure 4

image

Figure 5

(You actually have to click on the “Enable coverage” checkbox at the top [see Figure 3] to enable this.)

The highlighted lines in Figure 5 have not been executed by any of my tests, so I need to devise a test that does cause them to execute if I want full coverage.

Get blanket.js working by following these steps:

  1. Download it from http://blanketjs.org/.
  2. Add it to your project
  3. Update your test harness page (QuizUtil_test.html in my case) as follows:
    1. Reference the code
    2. Decorate your <script> reference like this:
    <script uri="text/javascript" SRC="QuizUtil.js" data-cover></script>

Blanket.js picks up the “data-cover” attribute and does its magic.  It hooks into Qunit, updates the UI to add the “Enable coverage” option and voila!

Buod (TL; DR)

Use Qunit to write your test cases.

  • Download it
  • Add it to your project
  • Write a test harness page
  • Create your tests
    • Refactor some of your code to be testable
    • Be creative!  Think of crazy, impossible scenarios and test them anyway.

Use blanket.js to ensure coverage

  • Make sure Qunit is working
  • Download blanket.js and add it to your project
  • Add it to your test harness page:
    • Add a reference to blanket.js
    • Add a “data-cover” attribute to your <script> tag
  • Run your Qunit tests.

I never did any of this before and had some rudimentary stuff working in a handful of hours. 

Happy testing!

</dulo>

undefinedMag-subscribe sa aking blog.

Sundin ako sa Twitter sa http://www.twitter.com/pagalvin

Lists.asmx, GetList at "VALUE ay hindi maaaring maging null”

Natuklasan ko na ngayon ang GetList() pamamaraan sa lists.asmx web serbisyo ay upang matawag napaka mabuti o ito ay madaling kapitan ng sakit upang ihagis ng isang mahiwaga "Halaga ay hindi maaaring maging null" sa pagbubukod (at na ipagpalagay na maaari kang makakuha ng nakalipas na ang kahit na mas masahol pa generic na mensahe ng error, “Exception of type ‘Microsoft.SharePoint.SoapServer.SoapServerException’ ay itinapon. ")  Tiyakan, Nakita ko na hindi ka maaaring magbigay ng anumang uri ng unlapi sa GetList pamamaraan.  Ang mga sumusunod na snippet jQuery ay naglalarawan ng point:

image

Kung gagawin mo na, web mga serbisyo ay tumutugon sa "Halaga ay hindi maaaring maging null" bilang per ito fiddler-ibinigay HTTP transcript:

<?xml version="1.0" encoding="utf-8"?>
  <sabon:Sobre
     xmlns:sabon ="
http://schemas.xmlsoap.org / sabon / sobre /"    
     xmlns:xsi = "
http://www.w3.org/2001/XMLSchema-instance"
     xmlns:xsd ="
http://www.w3.org/2001/XMLSchema">

  <sabon:Katawan>
    <sabon:Kasalanan>
      <faultcode>sabon:Server</faultcode>
      <faultstring>
        Exception of type ‘Microsoft.SharePoint.SoapServer.SoapServerException’ ay itinapon.
      </faultstring>
      <detalye>
        <error string xmlns ="
http://schemas.microsoft.com / sa sharepoint / sabon /">
Halaga ay hindi maaaring maging null.
        </errorstring>
      </detalye>
    </sabon:Kasalanan>
  </sabon:Katawan>
</sabon:Sobre>

Talaga, malamang na hindi nais na magdagdag ng "S0" prefix sa iyong sariling, ngunit ang ilang mga tool ay madaling kapitan ng sakit na gawin ito (tulad ng Eclipse).

Ito ay ang lahat ng mga mas nakalilito / nakakadismaya dahil ang iba pang mga pamamaraan tiisin prefixes.  Halimbawa, ang GetListCollection pamamaraan ay hindi tututol kung ito ay nai-prefix, kahit na may mga bagay na walang kapararakan prefix tulad ng "xyzzy":

image

Ang "halaga ay hindi maaaring maging null" tila medyo pangkaraniwan sa lists.asmx kaya sana ito ay makakatulong sa isang tao out sa hinaharap.

</dulo>

Mag-subscribe sa aking blog.

Sundin ako sa Twitter sa http://www.twitter.com/pagalvin

Endlessly Nesting <div> Tag at jQuery

Ito tila tulad ng isang paksa oddball, Hindi ako sigurado ito ay talagang nagkakahalaga ng pag-blog tungkol sa, ngunit na hindi kailanman tumigil sa akin bago, kaya dito kami pumunta ngiti

Ako nagtatrabaho out sa isang proyekto kung saan ako kumukuha ng ilang mga data mula sa isang paghahanap, packaging up ito sa isang XML mensahe at pagkatapos ay na XML sa huli ay transformed sa HTML sa pamamagitan ng XSLT.  Mayroong maraming mga jQuery kasangkot, isa bit na kung saan ipinapatupad ng ilang mga pag-andar tabbing.  Kapag nag-click ka sa isang tab (talaga, isang <div>), jQuery invokes. itago() at. palabas() sa iba't-ibang mga divs (ang paunang pag-load ng pahina Dina-download ang lahat ng mga nilalaman sa gayon walang mga postbacks sa kasong ito).

Ang isang grupo ng mga oras ang nakalipas, ang tab paglipat logic nagsimulang kumilos erratically at hindi ito ay magpapakita ng isa sa aking mga tab.  Ako sa huli sinubaybayan ito pababa sa ang katunayan na ang internet explorer (kahit) naisip na ang <div> mga tag nested malayo, malayo mas malalim kaysa intended.The developer toolbar ay magpapakita ng:

-<div id = "Tab1Content">
  -<div>
    -<div>
      -<div id = "Tab2Content">
        -<div>
           ..............................
                   </div>  <-Sa wakas ay nagpapakita ng ito ay sarado ang lahat ng paraan ang down dito!

Kaya, kung ginawa ko ang isang $("# Tab1Content").itago(), Gusto ko ring itago Tab2 at hindi ko maaaring magpakita Tab2 kung hindi ko ring ipakita Tab1.  Ako kopyahin at ilagay ang code hanggang sa visual studio at ito ay nagpakita ng lahat ng lining ang div up ni mabuti, tulad lang nila na ipagpalagay na paggawa, naghahanap ng ganito:

-<div id = "Tab1Content">
  +<div>
  +<div>
-<div id = "Tab2Content">
  +<div>
  +<div>

Matalo ko ang aking ulo laban sa mga pader para sa isang habang at napansin na sa aktwal na code ng HTML ay bumubuo ng maraming laman <div> mga tag, katulad:

<katawan>

  <div id = "Tab1Content">

    <div id = "ROW1" />
    <div id = "ROW2" />

  </div>

  <div id = "Tab2Content">

    <div id = "ROW1" />
    <div id = "ROW2" />

  </div>

</katawan>

(Sa itaas ay waaaaaaaaaaaay oversimplified.  Ang walang laman div tag ay lubos wastong. Ang ilan sa aking <div> mga tag ay puno ng mga nilalaman, ngunit marami pa ay hindi.  Ako ay dumating sa pagtanto na ang aking <xsl:para sa-bawat> mga kautusan ay nagpapalabas ng mga short-form na tag div kapag ang xsl:para-sa-bawat ay hindi 'makahanap ng anumang data.  Pinilit ako ng isang HTML komento sa output, tulad ng ipinapakita:

image

 

Pagkatapos kong gumawa niyan, lahat ng div ay ang naka-linya up mabuti at ang aking tab Paglipat nagsimula nagtatrabaho.

Tulad ng nakasanayan, Umaasa ako na ito ay tumutulong sa isang tao sa isang pakurot.

</dulo>

Mag-subscribe sa aking blog.

Sundin ako sa Twitter sa http://www.twitter.com/pagalvin

Isa Dahilan para sa "Ang mga tagalikha ng kasalanan na ito ay hindi tukuyin ang isang Dahilan.”

Ko na na-paggawa ng maraming trabaho sa SharePoint paghahanap kani-kanina lamang at partikular ang KeywordQuery na klase, katangian at mga pamamaraan.

Kung nais sa iyo resulta ang itakda upang bumalik ang mga resulta sa itaas at lampas ang mga dati suspects (makikita dito), mong idagdag ito sa koleksyon SelectedProperties, tulad ng sa:

myKeywordQuery.SelectProperties.Add("xyzzy");

Maraming salamat at isang dulo ng sumbrero sa Corey Roth at ito sobrang sobra helpful post ng blog (http://www.dotnetmafia.com/blogs/dotnettipoftheday/archive/2008/02/19/how-to-use-the-moss-enterprise-search-keywordquery-class.aspx)

Sa aking kaso, "Xyzzy" ay hindi talagang isang pinamamahalaang mga ari-arian.  Kapag idinagdag ko ito sa mga SelectedProperties pa rin, SharePoint threw isa sa aking paboritong kailanman runtime eksepsiyon:

"Ang lumikha ng kasalanan na ito ay hindi tukuyin ang isang Dahilan."

Gusto ko lalo na ang capital "R" sa Dahilan.  Ito iyan sa akin tulad ng. NET na katumbas ng "Mayroon akong walang bibig, at dapat ko mapasigaw."

</dulo>

Mag-subscribe sa aking blog.

Sundin ako sa Twitter sa http://www.twitter.com/pagalvin

Madaling gamitin Reference: Mga default Resulta mula sa KeywordQuery Search

Kapag pakiusapan mo ang Ipatupad() paraan sa isang KeywordQuery, Maaari kang lumikha ng isang ResultTable batay sa ResultType.RelevantResults.  Ang code snippet na ito ay naglalarawan kung ano ang ibig sabihin ko:

ResultTableCollection resultsTableCollection = myKeywordQuery.Execute();

ResultTable searchResultsTable = resultsTableCollection[ResultType.RelevantResults];

Ang resultang talahanayan ay ang mga sumusunod na hanay ng impormasyon: 

WorkId
Ranggo
Pamagat
May-akda
Laki
Landas
Paglalarawan
Sumulat
SiteName
CollapsingStatus
HitHighlightedSummary
HitHighlightedProperties
Contentclass
IsDocument
PictureThumbnailURL
ServerRedirectedURL

Nakuha ko ito mula sa listahan ng SharePoint 2010 kapaligiran, enterprise edition.  Sana ito ay maging madaling-magamit na sa isang tao sa hinaharap.

</dulo>

Mag-subscribe sa aking blog.

Sundin ako sa Twitter sa http://www.twitter.com/pagalvin

Isa Dahilan para sa: "Nabigong kunin ang taksi file sa solusyon”

Habang nagtatrabaho sa isang visual na proyekto na bahagi ng web ng talyer ngayon, Ginawa ko ang isang menor de edad na re-org ng ilang mga file ay ilagay sa folder _layouts bilang bahagi ng proseso ng pagpa-andar. Tiyakan, Pangalanan ko ng isang js file mula sa "TypeAhead.js" sa "TypeAhead(luma).js "  Plano ko upang maalis ito sa lalong madaling panahon ng kanyang kahalili sa "TypeAhead.js" nagpapatunay tama.  Ito ay tumingin tulad nito:

image

Ito agad sanhi ng isang problema sa visual talyer kapag sinubukan ko upang lumawak ang proyekto:

Error occurred in deployment step ‘Add Solution’: Nabigong kunin ang taksi file sa solusyon.

Ito ay lumiliko out na hindi ka dapat maglagay ng panaklong sa mga pangalan ng file.  Inalis ko ang mga parens at na malutas ang problema.

</dulo>

Mag-subscribe sa aking blog.

Sundin ako sa Twitter sa http://www.twitter.com/pagalvin