Dynamic Sharepoint Chart without any Coding [ jQuery , Google Chart API, Custom List )

Dynamic Sharepoint Chart without any Coding
Techology used : jQuery , Google Chart API, Custom List

Hi All ,

Here is the orginal post thatClaudio Cabaleyro did:
http://www.endusersharepoint.com/?p=1223.

Last week was very good because I have done lot's R & D on Google Chart API & jQuery and Sharepoint List.One of nice expreince of using jQuery , google chart api and sharepoint List.Without using any out of Box functionality chart is ready in your sharepoint List.Just follow some simple steps and Without any coding chart is ready ..... Just served with smile

Preview of Movie :

Steps :

1.On the list you want to base your chart, create a “Group By” view.
2.Create a new web part page and insert the just created list view.
3.Insert a Content Editor Web Part and paste the code below (remember to use the Source Editor).

Screenshot of Dynamic Chart in Sharepoint 2007 , without any coding



Same way you can also generate multiple pie chart of sharepoint list .Minor Modification in your steps

1. On the List of Sharepoint Create 3 different view using " Group By "
2. Create New web part webpage and add this 3 diffrent View in web part page.
3. All of above add one content Editior webpart and copy and paste below Code.
4. For Tips : If you want to display only your chart then Hide All Other Three views of your custom list.
5 Cheers for life

Screenshot of Dynamic Multiple pie chart in Sharepoint 2007 , No Coding at all Smile ...

Image by Gandhi Pritesh via Flickr

Cheers
Pritesh Gandhi.

Money isn't everything but it sure keeps you in
touch with your children.

AJAX SharePoint picture gallery using Highslide

AJAX Sharepoint Picture Gallery Using Highslide

One of the Best jQuery Implementation in Sharepoint Picture Gallery.Just change css and js class library of HighSlide and Your Picture will display in diffrent style and colors.

Try to implement . Nice work by Thomas Contee ...

Screenshot :

Link : http://blogs.msdn.com/tconte/archive/2009/04/01/ajax-sharepoint-picture-gallery-using-highslide.aspx

Note : Only one limitation of HighSlide with Sharepoint Picture Gallery at one time only one thumbnil is display .So when click on thumbnil remaining image is display using jQuery.But My way Awesome work just change CSS class of Higslide and u get whatever effect u want.Thanks Thomas Contee..

Cheers

Pritesh Gandhi

Beautiful Photos are developed by negatives in a dark room so if you see darkness in your life believe that God is making a beautiful future for u.

Sharepoint Photo Gallery Using jQuery

Title : SharePoint Photo Gallery using jQuery
Desc : Easily created with out of box functionality of shrepoint and nice look and feel.
Link : http://mphacker.spaces.live.com/blog/cns!8040CC624DDC5404!688.entry

Output :

Title :
Lightbox enabled custom webpart, displays images from sharepoint picture library

Link : http://www.fivenumber.com/lightbox-enabled-custom-webpart-displays-images-from-sharepoint-picture-library/

Output :




Cheers
Pritesh Gandhi

AJAX SharePoint picture gallery using Highslide

Title : AJAX SharePoint picture gallery using Highslide

Here is another trick to display picture librabry using jQuery.With Highslide u can display picture library of sharepoint with userfriendly view.

link :
http://blogs.msdn.com/tconte/archive/2009/04/01/ajax-sharepoint-picture-gallery-using-highslide.aspx

Output :



Title : jQuery Webpart for Sharepoint Picture Library

Link : http://httpcode.com/blogs/PermaLink,guid,b61dbc26-20da-49b0-9d31-8e64a09a87ed.aspx

Output :



Title :Free Picture Lightbox Sharepoint Web Part

Link : http://www.amrein.com/apps/page.asp?Q=5740

Output :



Cheers
Pritesh Gandhi.


Tell your heart that the fear of suffering is worse than the suffering itself. And no heart has ever suffered when it goes in search of its dream.

 

ASP.Net Links

ASP.Net Links ..... Let's Rock ......

Title :Staying Alive…Staying Alive
Desc : Sometimes you want your web page to 'stay alive'. That is, if a user is filling out a complicated form, you do not want the session to time out before they are finished. The user could get very angry and rightfully so: You might even get yelled at!
Link : http://www.codeproject.com/Articles/37136/AH-Ah-ah-ah-Staying-Alive-Staying-Alive.aspx

Cheers
Pritesh Gandhi

We Make Them Cry Who Care For Us.We Cry For Those Who Never Care For Us.And We Care For Those Who Will Never Cry For Us.This is The Truth Of Life.It's Strange But True.......

Moss 2007 Administration Links

Moss 2007 Administration Links

Title :Inside SharePoint Maintaining Security Account Credentials
Desc : Frequently changing farm credentials and security account passwords are important measures for keeping a Microsoft Office SharePoint Server (MOSS) farm secure. Yet for administrators, these tasks are tedious and repetitive. The tools are difficult to use, the underlying processes are complex, good documentation is hard to find, and there is a certain risk of corrupting the server farm even when following all of the proper procedures.
Link :http://technet.microsoft.com/en-s/magazine/2009.02.insidesharepoint.aspx

=================================================

Cheers
Pritesh Gandhi

"A little foolishness, enough to enjoy life, and a little wisdom to avoid the errors, that will do." - Osho

 

Sharepoint Picture Gallery using jQuery

Hi ,

One of Nice blog to Using jQuery with Picture Gallery of Sharepoint.Nice Post and also awesome look and feel of picture Library.

Screenshot

Link : 

Sharepoint Picture Gallery using jQuery

Cheers

Pritesh Gandhi.

Stop thinking the way people think, and start thinking what you think..!!!

Programmatically(C#) Adding, Deleting, Copying and Downloading Attachments in SPList

ADDING AN ATTACHMENT TO AN ITEM IN SPLIST :

private void AddNewAttachment(int NodeID)
{
try
{
SPList myList = SPContext.Current.Web.Lists["Item List"];
SPListItem myNewItem = myList.GetItemById(NodeID);

if (fileUpload.PostedFile != null && fileUpload.HasFile)
{
Stream fStream = fileUpload.PostedFile.InputStream;

byte[] contents = new byte[fStream.Length];
fStream.Read(contents, 0, (int)fStream.Length);
fStream.Close();
fStream.Dispose();

SPAttachmentCollection attachments = myNewItem.Attachments;
string fileName = Path.GetFileName(fileUpload.PostedFile.FileName);
attachments.Add(fileName, contents);

myNewItem["Attached FileName"] = fileName; // store the name of the file in a column for future requirements
myNewItem.Update();
}
}
catch (Exception eAdd)
{
string errAdd = eAdd.Message;
}
}


DELETING AN ATTACHMENT FROM SPLIST :

private void DeleteAttachment(int NodeID)
{
try
{
SPList myList = SPContext.Current.Web.Lists["Item List"];
SPListItem delItem = myList.GetItemById(NodeID);
SPAttachmentCollection atCol = delItem.Attachments;
if (delItem["Attached FileName"] != null)
{
string strFileName = delItem["Attached FileName"].ToString();
delItem["Attached FileName"] = string.Empty;
atCol.Delete(strFileName);
delItem.Update();
}
}
catch (Exception eDel)
{
string errDel = eDel.Message;
}
}

DOWNLOADING THE ATTACHMENT :

Find the download link first then reedirect to another aspx page so that the response ending on the current page does not affect the functionalities on this :-

private void DownloadAttachment(int NodeID)
{
try
{
string AttachmentURL = string.Empty;
SPList myList = SPContext.Current.Web.Lists["Item List"];
SPListItem attItem = myList.GetItemById(NodeID);
if (attItem["Attached FileName"] != null)
{
AttachmentURL = “/Lists/Item%20List1/Attachments/” + NodeID.ToString() + “/” + attItem["Attached FileName"].ToString();

System.Web.HttpContext.Current.Session["FileName"] = attItem["Attached FileName"].ToString();
System.Web.HttpContext.Current.Session["Attachment"] = AttachmentURL.Trim();
}
else
{
lblReport.Text = GetMessage(110);
}
if (AttachmentURL != string.Empty)
Page.Response.Write(”");
}
catch (Exception eDwn)
{
string errDwn = eDwn.Message;
}
}
At the aspx page you need to run the code as :

if(System.Web.HttpContext.Current.Session["Attachment"] != null)
{
string strName = System.Web.HttpContext.Current.Session["FileName"].ToString();
string sbURL = System.Web.HttpContext.Current.Session["Attachment"].ToString();
System.Web.HttpResponse response;
response = System.Web.HttpContext.Current.Response;
System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;
response.AppendHeader(”Content-disposition”, “attachment; filename=” + strName);
response.AppendHeader(”Pragma”, “cache”);
response.AppendHeader(”Cache-control”, “private”);
response.Redirect(sbURL);
response.End();
}

Now set these sessions to null.

COPYING AN ATTACHMENT FROM ONE ITEM TO ANOTHER IN SPLIST :

private void CopyAttachment(int FromID, int NodeID, string AttachedFile)
{
try
{
SPList myList = SPContext.Current.Web.ParentWeb.Lists["Item List"];
SPListItem myItem = myList.GetItemById(NodeID);
SPListItem myPrevItem = myList.GetItemById(FromID);

SPAttachmentCollection attColl = myPrevItem.Attachments;

SPFile attFile = myPrevItem.ParentList.ParentWeb.GetFile(myPrevItem.Attachments.UrlPrefix + AttachedFile);
string fileRead = myPrevItem.Attachments.UrlPrefix.ToString() + AttachedFile;

StreamReader fsReader = new StreamReader(attFile.OpenBinaryStream());
Stream fStream = fsReader.BaseStream;

byte[] contents = new byte[fStream.Length];
fStream.Read(contents, 0, (int)fStream.Length);
fStream.Close();
fStream.Dispose();

myItem.Attachments.Add(AttachedFile, contents);
myItem.Update();
}
catch (Exception eCopy)
{
string errCopy = eCopy.Message;
}

}

Download File

Reference URL :

http://nehasinha.wordpress.com/2008/05/23/programmticallyc-adding-deleting-copying-and-downloading-attachments-in-splist/


Cheers
Pritesh Gandhi

Everyone is gifted - but some people never open their package

jQuery Rich TextArea Editor Links

Dear All ,

jQuery Rich Text Area Editor Links

Title : 15+ Excellent jQuery Plugins To Enhance HTML Forms
Desc : Quick Select , ComboBox , CheckBox, Range Selector , Date Picker , Modal Preview All basic control for HTML Forms
Link : http://webdeveloperplus.com/jquery/15-excellent-jquery-plugins-to-enhance-html-forms/

------------------------------------------------------------------------------

Title : jQuery TextAre Editor
Desc : Markeit jQuery Text Editor Nice One for Content Related Pages
Link : http://markitup.jaysalvat.com/examples/
http://batiste.dosimple.ch/blog/posts/2007-09-11-1/rich-text-editor-jquery.html
http://www.textarearich.com/demo.php
http://webscripts.softpedia.com/scriptDownload/Free-Rich-Text-Editor-Download-14379.html

------------------------------------------------------------------------------

Title : Dynamic Drive Website for Animation , Marquee ,Menus , Mouse and Cursor
Desc : Welcome to Dynamic Drive, the #1 place on the net to obtain free, original DHTML & Javascripts to enhance your web site!
Link : http://www.dynamicdrive.com/

------------------------------------------------------------------------------

Cheers
Pritesh Gandhi.

The Race is not over...... Because I haven't WON yet.....

jQuery Useful Links , Description

jQuery Useful Links , Description

Dear All,

Title : 100 Popular jQuery Examples, Plugins and Tutorials
Desc : jQuery Examples like Context Menus , Tree File ,Image Manipulartion , TRANSITION EFFECTS,jQUERY CAROUSEL,COLOR PICKER,LIGHTBOX,FORM ELEMENTS AND VALIDATION etc...
Link : http://www.templatelite.com/100-popular-jquery-plugins/

------------------------------------------------------------------------

Title : Basic AJAX Tutorial: Smooth Scrolling Text Marquee with a jQuery plugin
Desc : jQuery Marqueee Plugin and how to implement Marquee Plugin
Link : http://www.seangw.com/wordpress/index.php/2009/01/basic-ajax-tutorial-smooth-scrolling-text-marquee-with-a-jquery-plugin/

------------------------------------------------------------------------

Title : AJAX DADDY
Desc : Very Good Site for Implement AJAX , jQuery Related Example
Link : http://www.ajaxdaddy.com/

------------------------------------------------------------------------

Title : Masked Input Plugin
Desc : This is a masked input plugin for the jQuery javascript library. It allows a user to more easily enter fixed width input where you would like them to
enter the data in a certain format (dates,phone numbers, etc). It has been tested on Internet Explorer 6/7, Firefox 1.5/2/3, Safari, Opera, and Chrome. A mask is defined by a format made up of mask literals and mask definitions. Any character not in the definitions list below is considered a mask literal. Mask literals will be automatically entered for the user as they type and will not be able to be removed by the user.
Link : http://digitalbush.com/projects/masked-input-plugin/

------------------------------------------------------------------------

Title : Highslide JS [ JavaScript Thubnil Viewer ]
Desc : Highslide JS is an open source image, media and gallery viewer written in JavaScript.•Single click. After opening the image or HTML popup, the user can scroll further down or leave the page without closing it.
Link : http://highslide.com/
http://highslide.com/index.htm

------------------------------------------------------------------------

Title : iBox LightWeight
Desc : iBox is a lightweight script that lets you overlay images and documents in a small dialog without a page reload. It's built to be easy to install and use, while offering great flexibility. The quick start shows example code and explains how to use it.
Link : http://www.ibegin.com/labs/ibox/

------------------------------------------------------------------------

Title : James Podesky Website
Desc : Nice Website for HTML , JavaScript and jQuery
Link : http://james.padolsey.com/

------------------------------------------------------------------------

Title : jQuery Collection of Examples
Desc : jQuery Collection of Examples
Link : http://roshanbh.com.np/category/jquery

------------------------------------------------------------------------

Title : jQuer WikiPedia
Desc : jQuery is a lightweight JavaScript library that emphasizes interaction between JavaScript and HTML. It was released in January 2006 at BarCamp NYC by John Resig. Dual-licensed under the MIT License and the GNU General Public License, jQuery is free, open source software.
Link : http://en.wikipedia.org/wiki/JQuery

------------------------------------------------------------------------

Title : jQuery Marquee Demo
Desc : jQuery Marquee Demo
Link : http://remysharp.com/demo/marquee.html
http://www.maaki.com/thomas/SmoothDivScroll/runningTicker.htm
http://www.maaki.com/thomas/SmoothDivScroll/scrollingText.htm

------------------------------------------------------------------------

Title : jQuery Plugins
Desc : jQuery Plugins [ official jQuery Site ]
Link : http://plugins.jquery.com/

------------------------------------------------------------------------

Title : jQuery User Interface
Desc : jQuery UI provides a comprehensive set of core interaction plugins, UI widgets and visual effects that use a jQuery-style, event-driven architecture and a focus on web standards, accessiblity, flexible styling, and user-friendly design. All plugins are tested for compatibility in IE 6.0+, FF 2+, Safari 3.1+, Opera 9.0+, and Google Chrome..
Link : http://jqueryui.com/demos/

------------------------------------------------------------------------

Title : ThickBox 3.1
Desc : ThickBox is a webpage UI dialog widget written in JavaScript on top of the jQuery library. Its function is to show a single image, multiple images, inline content, iframed content, or content served through AJAX in a hybrid modal.
Link : http://jquery.com/demo/thickbox/

------------------------------------------------------------------------

Title : Top 10 Jquery Examples with Live Demos
Desc : Top 10 Jquery Examples with Live Demos
Link : http://www.myphpdunia.com/2009/04/19/top-10-jquery-examples-with-live-demos/

------------------------------------------------------------------------

Title : Rich Text box Editior of jQuery
Desc : Javascript rich text editor has ease our life when we need to edit articles, post or even documents online. Most of the editors allow user to edit the content straight away (What You See Is What You Get - WYSIWYG), it just like editting a document with microsoft office. Nowadays, I think all of the content management system, blog systems are using rich text editor. So, here are the 10 RTEs that I can find online. From the most basic support of font formatting to advanced features such as image upload, table creation, ajax support and so on. Be sure to drop me a comment if you know other RTE that is not listed below. Enjoy.
Links : http://www.queness.com/post/212/10-jquery-and-non-jquery-javascript-rich-text-editors
http://developer.yahoo.com/yui/editor/
http://www.codeplex.com/rte


------------------------------------------------------------------------

Title : Pausing up-down Scroller
Desc : As its name suggests, this is a up-down scroller that pauses between each message! The look of the scroller is completely styled using external CSS, including the dimensions. Easily create a single line scroller just by adjusting the scroller's height appropriately!
Link : http://www.dynamicdrive.com/dynamicindex2/crosstick.htm

Cheers
Pritesh Gandhi.

Be grateful that you don't have everything you want, because that means you still have an opportunity to be happier tomorrow than you are today.