pdanan

Alternate Access Mapping and Sharepoint Search Content Source Crawling

pdanan — Wed, 05 Sep 2012 09:23:57 GMT

If we have Alternate Access Mapping then we should NOT applied URLs from Zone other than Default Zone in Search Content Source setting and in Search Zone setting.

Example:

We have AAM in Intranet zone, like below:

Then in Content Source definition just put the URL in Default Zone, like below:

that also applied in Search Scope, like below:

Note: this is correction for this original post where I stated contrarily. Sorry for that . And don’t worry about this correction cause I’ve proved myself.

From my post in:

http://edanan.wordpress.com/2012/06/05/alternate-access-mapping-and-sharepoint-search-content-source-crawling/

Share this post: | | | |

Custom Display Form and its problem with Search result

pdanan — Mon, 03 Sep 2012 16:38:15 GMT

I came into situation exactly like this http://social.technet.microsoft.com/Forums/en-US/sharepoint2010customization/thread/5461e442-d539-4bc6-b9e8-30db20a62abe/ , where search result still pointing to original display form even it’s been set as not default. Then I followed the suggestion there to input custom display form relative path in Content Type Setting as seen below:

First, It worked, where it actually still pointing the original display form but when it clicked, it redirected to custom display form that’s been set.

But then I tried it to another library, it didn’t work , didn’t know Why.

Another suggestion is to delete original form to leave only one display form then do full crawl. But I don’t want to do that, it’s too risky.

At the end, I came to decision to edit Search Result XSL. Here is my XSL Code :

<xsl:variable name="newurl" select="concat(substring-before(url,'/Forms/'),'/Forms/DispForm.aspx?ID=',substring-after(url, 'ID='))" />

Note ! this is only suited for my case, where :

- original display form’s name is something not DispForm.aspx

- custom display form’s name is DispForm.aspx

And that newurl variable is replacement for the default url variable that’s used to build the hyperlink.

From my post in : http://edanan.wordpress.com/2012/09/03/custom-display-form-and-its-problem-with-search-result-2/

Share this post: | | | |

Custom Display Form and its problem with Search result

pdanan — Mon, 03 Sep 2012 16:26:17 GMT

First, It worked, where it actually still pointing the original display form but when it clicked, it redirected to custom display form that’s been set.

But then I tried it to another library, it didn’t work , didn’t know Why.

Another suggestion is to delete original form to leave only one display form then do full crawl. But I don’t want to do that, it’s too risky.

At the end, I came to decision to edit Search Result XSL. Here is my XSL Code :

<xsl:variable name="newurl" select="concat(substring-before(url,'/Forms/'),'/Forms/DispForm.aspx?ID=',substring-after(url, 'ID='))" />

that newurl variable is replacement for the default url variable.

From my post in http://edanan.wordpress.com/2012/09/03/custom-display-form-and-its-problem-with-search-result/

Share this post: | | | |

Only Inserting non existent in SSIS

pdanan — Fri, 10 Aug 2012 13:06:29 GMT

I am newbie in SSIS. I need to insert Fact Table with only non existent data, and I found this post useful : http://jahaines.blogspot.com/2009/09/ssis-only-inserting-rows-that-do-not.html .

That post told how to do that using Lookup component, the key point is : When Non Matching entries found then redirect to Error Output, then Use the Error Output as Input for Destination component.

Ref: http://edanan.wordpress.com/2012/08/10/only-inserting-non-existent-in-ssis/

Share this post: | | | |

Best way get Sharepoint 2010 data for ETL in SSIS ?

pdanan — Thu, 09 Aug 2012 15:25:22 GMT

What is best way to get Sharepoint 2010 data for ETL in SSIS ?

Some people suggested using this free adapter : http://sqlsrvintegrationsrv.codeplex.com. Some is using Sharepoint Web services.

But for now, I choose Sharepoint Managed Client Object Model, compared with Sharepoint Web services, Client Object Model has several advantages, one that I need is can do Join Query.

How about the above adapter ? I don’t know, I just feel why we used tool from the outside if there is already built-in tool. But if someone has made more depth comparison about that, please share

So. What do you need to do "sharepoint managed client object model” in SSIS SQL 2008 R2, here there are:

1. Install http://www.microsoft.com/en-us/download/details.aspx?id=21786 and this http://www.microsoft.com/en-us/download/confirmation.aspx?id=26624 for Sharepoint SP1.

2. Change .Net framework to 3.5 in Project Properties like this:

Reference: http://edanan.wordpress.com/2012/08/09/best-way-get-sharepoint-2010-data-for-etl-in-ssis/

Share this post: | | | |

Meng-Highlight custom Property di hasil pencarian Sharepoint

pdanan — Thu, 09 Aug 2012 14:45:51 GMT

Highlight kata yang dicari di hasil pencarian di Sharepoint terjadi secara otomatis untuk property yang secara bawaan tampil di hasil pencarian.

Tetapi ketika kita ingin meng-highlight custom property yang kita tampilkan di hasil pencarian, maka dibutuhkan beberapa hal yang harus dilakukan sebagai berikut:

1. Tambahkan HitHighLight=”true” di dalam Tag custom property yang ingin di highlight, di Fetched Properties di webpart search result properties:

2. Tuliskan XSL hasil pencarian untuk property yang ingin di highlight sebagai berikut:

<xsl:if test="string-length(customproperty) &gt; 0">
  <xsl:choose>
    <xsl:when test="hithighlightedproperties/customproperty[. != '']">
      <xsl:call-template name="HitHighlighting">
        <xsl:with-param name="hh" select="hithighlightedproperties/customproperty" />
      </xsl:call-template>
    </xsl:when>
    <xsl:otherwise>
      <xsl:value-of select="customproperty" />
    </xsl:otherwise>
  </xsl:choose>
</xsl:if>

Share this post: | | | |

Forbidden access when Edit Item with Taxonomy field

pdanan — Tue, 31 Jul 2012 15:33:04 GMT

Go to http://{site_url}/Lists/TaxonomyHiddenList/ and check its permission. Adjust permission so that Error forbidden not happened again.

Share this post: | | | |

Membuat kustom Picker dan Selector kontrol di Sharepoint

pdanan — Sat, 26 May 2012 09:06:43 GMT

Kita pasti sudah sering melihat kontrol picker dan selector seperti ini di Sharepoint :

Yang kita mungkin tidak tahu adalah kita bisa membuat sendiri kontrol untuk kepentingan kita sendiri, misalnya untuk kontrol picker dan pencarian data di kustom form yang kita buat.

Link ini http://sharepointsolutions.com/sharepoint-help/blog/2009/10/create-a-custom-picker-in-sharepoint-2010/ memuat penjelasan dan contoh lengkap tentang itu (Terimakasih untuk penulisnya Jeremyluerkens)

Saya sendiri sudah bisa membuat berdasarkan contoh diatas. Yang perlu diingat adalah kita harus mendaftarkan webcontrols tersebut sebagai <safecontrol> di web.config, melalui editor manifest package seperti ini:

English Version: http://edanan.wordpress.com/2012/05/26/create-custom-picker-control-in-sharepoint/

Share this post: | | | |

Cara menambahkan assembly di

pdanan — Fri, 25 May 2012 15:08:03 GMT

Klik 2x package di visual studio, dan klik Manifest di bawah package. dan tambahkan assembly dengan menuliskan di situ, berikut gambarnya:

Share this post: | | | |

Error “The URL provided is invalid …” ketika melakukan Export-SPWeb

pdanan — Mon, 21 May 2012 13:47:12 GMT

Kemungkinan kita pernah mengalami Error berikut ini ketika melakukan Export-SPWeb :

Export-SPWeb : The URL provided is invalid. Only valid URLs that are site collections or sites are allowed to be exported using stsadm.exe.

masalahnya bisa jadi ada di isian parameter itemUrl, yakni ada/tidaknya karakter “/” di depan,

Maksudnya, untuk kondisi tertentu karakter “/” tidak boleh ada di depan seperti ini :

export-spweb http://spvm1/sites/site1 -ItemUrl "Lists/list1" -path "C:\list1.cmp"

Namun untuk kondisi lain justru harus ada di kasus seperti ini :

export-spweb http://spvm1.edanan.com -ItemUrl "/Lists/list1" -path "C:\list1.cmp"

Dari pengalaman saya, hal tersebut tergantung site URL nya, silakan rekan-rekan menebak dari 2 contoh diatas, kondisi mana yang harus ada “/” dan yang sebaliknya (tidak boleh ada “/”)

Reference: http://edanan.wordpress.com/2012/05/21/export-spweb-the-url-provided-is-invalid/

Share this post: | | | |

SPView dan Joins

pdanan — Sun, 29 Apr 2012 17:00:48 GMT

Selain SPQuery, Joins juga ada di SPView.

Di contoh ini , saya coba aplikasikan CAML Joins sebelumnya: http://edanan.wordpress.com/2012/04/28/sample-caml-joins-for-more-than-2-lists/

ke view bernama “JoinView” yang sudah saya buat sebelumnya dengan tampilan standar. Tentunya dengan masih memakai list yang sama dengan artikel sebelumnya tersebut yaitu clients, cities, dan countries. Dan hasilnya adalah seperti berikut :

Yang saya tidak mengerti kemudian adalah Ribbonnya menjadi tidak aktif . Jika ada yang tahu, silakan ..

Untuk langsung mencoba berikut full sourcenya : SPVIEW.zip . Jangan lupa untuk membuat list-list (clients, cities, and countries) dengan kolom2 sesuai artikel sebelumnya tersebut ditambah view bernama “JoinView” sebelum mulai men-deploy solusinya (*.wsp)

Terimakasih

Share this post: | | | |

Contoh Join List pakai CAML

pdanan — Sat, 28 Apr 2012 18:08:11 GMT

Setelah beberapa kali mencoba akhirnya saya berhasil membuat contoh program sederhana untuk Join List.

Di sini saya memakai 3 lists: clients, cities, dan countries, seperti berikut ini:

Dan program diatas bertugas menampilkan clients yang presiden negaranya adalah “sby”, dan hasilnya seperti berikut:

Berikut code nya:

XmlDocument camlDocument = new XmlDocument();
   camlDocument.LoadXml(
       @"<Where>
           <Eq>
               <FieldRef Name='clientpresident' />
               <Value Type='Text'>[User]</Value>
           </Eq>
         </Where>".Replace("[User]", @"sby"));

   string siteURL = "http://dnpsps2010/SitePages/Home.aspx";
   using (SPSite site = new SPSite(siteURL))
   using (SPWeb web = site.OpenWeb())
   {
       SPList contact = web.Lists["clients"];
       SPQuery query = new SPQuery();
       query.Query = camlDocument.InnerXml;
       query.Joins =
           @"
            <Join Type='LEFT' ListAlias='cities'>
               <Eq>
                   <FieldRef Name='city' RefType='Id'/>
                   <FieldRef List='cities' Name='ID'/>
               </Eq>
            </Join>
            <Join Type='LEFT' ListAlias='countries'>
               <Eq>
                  <FieldRef List='cities' Name='country' RefType='Id'/>
                  <FieldRef List='countries' Name='Id'/>
               </Eq>
            </Join>
            ";
       query.ProjectedFields =
           @"
           <Field Name='clientareacode' Type='Lookup' List='cities' ShowField='areacode' /> 
           <Field Name='clientpresident' Type='Lookup' List='countries' ShowField='President' /> 
           ";
       query.ViewFields = @"<FieldRef Name='Title' /><FieldRef Name='city' /><FieldRef Name='clientareacode' /><FieldRef Name='clientpresident' />";
       SPListItemCollection items = contact.GetItems(query);
       foreach (SPListItem itm in items)
       {
           string str1 = string.Empty;
           string str2 = string.Empty;
           if (itm["city"] != null)
           {
               SPFieldLookupValue slv1 = new SPFieldLookupValue(itm["city"].ToString());
               str1 = slv1.LookupValue;
           }
           if (itm["clientareacode"] != null)
           {
               SPFieldLookupValue slv2 = new SPFieldLookupValue(itm["clientareacode"].ToString());
               str2 = slv2.LookupValue;
           }
           Console.WriteLine(itm["Title"] + "; " + "; " + str1 + "; " + str2);
       }
   }

Yang perlu diperhatikan adalah tidak semua tipe kolom bisa dijadikan ProjectedFields, hanya tipe kolom berikut:

Calculated (treated as plain text)
ContentTypeId
Counter
Currency
DateTime
Guid
Integer
Note (one-line only)
Number
Text

Yang ingin source code lengkapnya bisa diunduh disini : CAMLJoins.zip.

Semoga manfaat.

Referensi:

http://edanan.wordpress.com/2012/04/28/sample-caml-joins-for-more-than-2-lists/

http://msdn.microsoft.com/en-us/library/ee539975.aspx,

Share this post: | | | |

Cara menyembunyikan kolom di Sharepoint Form

pdanan — Fri, 18 Nov 2011 04:27:51 GMT

1. PowerShell . Ref: http://howtosharepoint.blogspot.com/2010/11/hide-columns-in-sharepoint-new-edit-and.html

2. Programmatically, dengan membuat custom form di ascx/aspx

3. Content Type, dengan cara seting kolom sebagai Hidden.

4. jQuery. Contoh :

<script type="text/javascript">
$(document).ready(function() {
    $('nobr:contains("Completion time")').closest('tr').hide();
});
</script>

Share this post: | | | |

Error di Webpart Page: No item exists at http:// …/mywebpartpage.aspx?id=999. It may have been deleted or renamed by another user

pdanan — Mon, 14 Nov 2011 07:05:00 GMT

Error No item exists at http:// … /mywebpartpage.aspx?id=999. It may have been deleted or renamed by another user

yang terjadi di webpart page dimana disitu ada webpart/visual webpart yang kita bangun,

dikarenakan konflik pemakaian parameter id. Karena itu jangan memakai parameter id di webpart/visualwebpart yang kita bangun, karena parameter itu dipakai oleh sistem Sharepoint. Selain id ada beberapa

parameter yang di-reserve oleh Sharepoint, selengkapnya adalah :

FeatureId
ListTemplate
List
ID
VersionNo
ContentTypeId
RootFolder
View
FolderCTID
Mode
Type
PageVersion
IsDlg
Title
_V3List_

Reference : http://blogs.technet.com/b/stefan_gossner/archive/2009/01/30/querystring-parameters-you-should-not-use-in-your-sharepoint-application.aspx

Share this post: | | | |

Dua Cara membuat WCF Client di Sharepoint page

pdanan — Thu, 10 Nov 2011 15:13:00 GMT

Dua Cara membuat WCF Client di Sharepoint page :

1. Seting binding dan endpoint disimpan di web.config :

Caranya seperti yang biasa dilakukan yaitu dengan melalui Add Service Reference. Setelah itu Seting binding dan Endpoint yang ada di app.config (dibagian dalam <system.serviceModel> ) copy-kan ke web.config (juga dibagian dalam <system.serviceModel> ) . Keuntungan cara ini adalah bila diperlukan perubahan seting binding atau endpoint tinggal mengedit file config-nya. Kerugiannya kalau banyak webservice yang berarti banyak seting yang harus ditambah di web.config. Supaya tidak terlalu banyak baris, seting binding dan endpoint bisa disederhanakan dengan menghapus yang tidak perlu, sebagai contoh:

<system.serviceModel>

</basicHttpBinding>

</bindings>

<endpoint address="http://192.168.1.23/services/mysvc.asmx"

binding="basicHttpBinding" bindingConfiguration="WebService1Soap"

contract="TarkService.WebService1Soap" name="WebService1Soap" />

</client>

</system.serviceModel>

2. Seting binding dan endpoint dideklarasikan di code :

Keuntungan dan Kerugian cara ini adalah lawan dari cara 1) yaitu kerugiannya untuk merubah seting binding dan endpoint harus merubah code dan keuntungannya tidak perlu merubah web.config.

Langkah-langkahnya:

1. Buat Proxy dengan svcutil.exe yang ada di visual studio 2010 Command Prompt. By default dia akan membuat file config yang berisi seting binding dan endpoint, karena kita ingin seting binding dan endpoint ada di code sehingga tidak diperlukan file config, maka bisa kita beri opsi /noconfig supaya tidak membuat file config.

Contoh : SvcUtil http://192.168.1.23/services/mysvc.asmx /out:C:\SvcProxy.cs /noconfig

2. Selanjutnya lakukan deklarasi binding dan endpoint, dan akses webservice di code.

Contoh :

BasicHttpBinding Binding = new BasicHttpBinding();

EndpointAddress endpointAddress = new EndpointAddress("http://192.168.1.23/services/mysvc.asmx");

WebService1SoapClient oWebSvc = new WebService1SoapClient(Binding, endpointAddress);

int itemID = 999999;

string teks= trk.GetText(itemID).InnerXml;

Sumber : Buku Programming WCF Services oleh Juval Lowy

Share this post: | | | |

pdanan

Alternate Access Mapping and Sharepoint Search Content Source Crawling

Custom Display Form and its problem with Search result

Custom Display Form and its problem with Search result

Only Inserting non existent in SSIS

Best way get Sharepoint 2010 data for ETL in SSIS ?

Meng-Highlight custom Property di hasil pencarian Sharepoint

Forbidden access when Edit Item with Taxonomy field

Membuat kustom Picker dan Selector kontrol di Sharepoint

Cara menambahkan assembly di

Error “The URL provided is invalid …” ketika melakukan Export-SPWeb

SPView dan Joins

Contoh Join List pakai CAML

Cara menyembunyikan kolom di Sharepoint Form

Error di Webpart Page: No item exists at http:// …/mywebpartpage.aspx?id=999. It may have been deleted or renamed by another user

​Dua Cara membuat WCF Client di Sharepoint page

Dua Cara membuat WCF Client di Sharepoint page