Using Sharepoint’s GetListCollection

GetListCollection is one of web service functions which are provided in Microsoft Windows Sharepoint Services. GetListCollection is used to retrieve listname and its respective attributes. Thus, its similar when you browse sharepoint site using [sitename]/_layouts/viewlsts.aspx.

About base64

Taken from http://www.centricorp.com/papers/base64.htm Base 64 literally means a positional numbering system using a base of 64. It is the largest power of two bases that can be represented using only printable ASCII characters. This has led to its use as a transfer encoding for email among other things. All well-known variants of base 64 use […]

About filtering Sharepoint List’s view by user group and user

I hope this short guide useful for you. Consider this case: suppose you want to filter a view in Sharepoint based on user group (example: a group of reviewer) AND user (example: requestor), then you will need to implement this trick. Step 1: open your view page (.aspx) using Sharepoint Designer. Step 2: find a […]

CSV parser using javascript

The following is javascript code which is used to read CSV file. I wrote the code starting from opening CSV file, loading to memory, parsing (into lines and then into fields), and finally displaying as a table.

Decimal Limiter using javascript

I just have completed a simple code to limit decimal number into specific digits. Simple code, but useful.

MOSS2007: The data source control failed to execute the insert command

When I was trying to initiate workflow from MOSS2007 to a list, an error page: The data source control failed to execute the insert command is appearing. This was upseting me, since previously there was nothing wrong with my workflow. Then I asked uncle Google to get answer of my problem, and I found this […]

Number Speller (Bahasa & English)

I have created a number speller using javascript which enable you to: Convert number into words in Bahasa or English, Automatically add currency (Bahasa=Rupiah, English=Dollar), Automatically add ‘cent’, if fraction is found (max 2 digits) Note: You must ensure that your browser’s javascript is switched on, You can use this code freely, as long as […]

Updating chart series’s source

The following VB script code is a simple example on how to modify the data source of a series using array. Let’s say you have already created a chart in a sheet which its name is “Sheet1”. Dim srs As Series Dim yval() As String Dim xval() As Integer Set srs = Sheets(“Sheet1”).ChartObjects(1).Chart.SeriesCollection(1) Dim v […]