How Sharepoint

SQL Pivot

2019-07-02T02:43:00.005-07:00

SELECT Item, imitdesc, 'Price' as Val,[2018-1],[2018-2],[2018-3],[2018-4],[2018-5],[2018-6],[2018-7],[2018-8],[2018-9],[2018-10],[2018-11],[2018-12],[2019-1],[2019-2],[2019-3],[2019-4],[2019-5],[2019-6],[2019-7],[2019-8],[2019-9],[2019-10],[2019-11],[2019-12]
FROM (
    SELECT 
        Item,
  imitdesc,
  isnull(UPrice,0) as UPrice,
  cast(MYear as varchar) + '-' + cast(Mmonth as varchar) as Mmonth--, 
        --isnull(GRNQty,0)-isnull(IssueQty,0) as Amount 
    FROM #TempCons        
) as s
PIVOT
(
    SUM(UPrice)
    FOR [Mmonth] IN ([2018-1],[2018-2],[2018-3],[2018-4],[2018-5],[2018-6],[2018-7],[2018-8],[2018-9],[2018-10],[2018-11],[2018-12],[2019-1],[2019-2],[2019-3],[2019-4],[2019-5],[2019-6],[2019-7],[2019-8],[2019-9],[2019-10],[2019-11],[2019-12])
)AS pvt

Insert Records to SQl Temp Table

2019-07-02T00:26:00.002-07:00

SELECT * INTO #TempTable
FROM OriginalTable

Remove Line Breaks SQL

2019-06-05T18:39:00.002-07:00

To remove these SQL line breaks, use the SQL Server replace function. Indeed, the CHAR(13) and CHAR(10) specific codes represent the characters of the line breaks,and then replace them with a space or a comma, for example. This time, the copy paste gives us this result.

REPLACE(I.DelAddress,CHAR(13)+CHAR(10),' ')

Find Specific Text on Stored Procedure

2013-05-22T02:36:00.002-07:00

Do you remember we had so many requirements to check a text on stored procedures or a view?

Think that we are going to change a field name of a table or a data type of a field. Or we are going to replace or delete a data table in your database. Database might be so big and there may be hundreds of stored procedures.

We can't open every single stored procedures or a view and check whether they are using the data table we going to delete.

For that,

We can simply find the stored procedures which are using this particular data table or a field. That may help us to reduce the work load more than 80%.

You can use this following query for it.

SELECT *

FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_DEFINITION LIKE '%TableName%'

Microsoft SharePoint 2010 Training Tutorial

2012-11-27T07:50:00.000-08:00

Microsoft SharePoint 2010 Training Tutorial [Sites and Templates]

Microsoft SharePoint 2010 Training Tutorial [Working with Wikis]

Note :credits goes to original uploader

Apply CSS styles to SharePoint Web parts

2012-11-14T21:14:00.000-08:00

In SharePoint we are using various types of web parts. List View web part are one of major type which uses to populate data on the web page from a SharePoint list. By default all the web parts of the page use the styles inherits from the site theme.

Here I explain a simple workout to apply a CSS style to a web part only using out of the box features of SharePoint 2010.

There are only 3 steps for you to follow.

1. Get the ID of web part you wants to apply CSS style

2. Add Content Editor web part

3. Apply CSS style as you required

Step 1

♣ Go to “view source” of the browser you are using and search for the web parts name.

In my scenario, it’s “Emergency”.

♣ Now grab the ID number mentioned there at the end of WebPartTitleWPQ2. “2” is the ID of “Emergency” web part in my web page.

Step 2

♣ Now add a Content Editor Web Part by go to edit mode of the page.
♣ Set the Chrome Type as None of the added Content Editor Web Part.

Step 3

♣ Go to the edit mode of the Content Editor Web Part and click Edit HTML source

♣ Then add the following CSS style and Save the changes

/* === Title bar CSS === */

/* TR - title bar for web part */

#MSOZoneCell_WebPartWPQ2 .ms-WPHeader

{

background-color: pink;

}

/* H3 - Text in title bar of web part */

#MSOZoneCell_WebPartWPQ2 .ms-WPTitle A

{

font-family: "Cambria";

color: black;

font-size: 16pt;

}

/* TD – Left and right corner cells of title bar */

#MSOZoneCell_WebPartWPQ2 .ms-wpTdSpace

{

background-color: green;

width: 30px !important;

}

/* web part check box of right side */

#MSOZoneCell_WebPartWPQ2 .ms-WPHeaderCbxHidden

{

display: none;

}

/* === Web part background CSS === */

/* TD - background for all except the title bar of web part */

.s4-wpcell#MSOZoneCell_WebPartWPQ2

{

border-bottom: 5px dashed;

border-left: 5px dashed;

background-color: lightgreen;

border-top: 5px dashed;

border-right: 5px dashed;

}

/* TD - paging area at the bottom */

#MSOZoneCell_WebPartWPQ2 .ms-bottompaging TD

{

background-color: yellow;

}

/* hide the gray line above "add new" link */

#MSOZoneCell_WebPartWPQ2 .ms-partline

{

display: none;

}

/* selected (clicked) web part background */

.s4-wpActive#MSOZoneCell_WebPartWPQ2

{

border-bottom-color: red;

background-color: fuchsia;

border-top-color: red;

border-right-color: red;

border-left-color: red;

}

/* === Column headings === */

/* color for sortable column headings */

#MSOZoneCell_WebPartWPQ2 .ms-vh-div A

{

color: red !important;

}

/* color for non-sortable column headings */

#MSOZoneCell_WebPartWPQ2 .ms-vh-div

{

color: red !important;

}

/* === List text CSS === */

/* item description text */

#MSOZoneCell_WebPartWPQ2 .ms-vb2

{

color: red !important;

font-size: 12pt;

}

#MSOZoneCell_WebPartWPQ2 .ms-vb-user A

{

color: red !important;

font-size: 12pt;

}

#MSOZoneCell_WebPartWPQ2 .ms-vb-title A

{

color: red !important;

font-size: 12pt;

}

/* TR - alternating rows of web part */

#MSOZoneCell_WebPartWPQ2 .ms-alternating

{

background-color: Tan;

}

</style>

Note: Do the changes as you prefer. This will also useful for site branding and design attractive websites using SharePoint rather than using Themes.

Finally it will show like this

CodeProject

CodeProject

SharePoint Number Column Without Commas

2012-09-22T18:55:00.000-07:00

Avoiding thousand separator(Comma) in SharePoint Number field

SharePoint number fields having thousand separators(Comma) which may not want us to need every time. But there are no possibility to avoid the thousand separator(Comma) in the number fields.

To avoid this comma we can do a small workout as following..

Suppose our Number field named as "Student No."

Create another Calculated column and name it as "Student Number"

Then you have to type the formula according to the following format

= TEXT( Number_Column_Name, "0")

And click Save
In our scenario it will show as =TEXT([Student No],"0")

Note : If the Student No field will empty, the value will be shown as "0".... Or if you want to keep it blank you have to adjust the formula as

=IF( [Student No] <>"",TEXT( [Student No] ,"0"),"")

Create SharePoint New Site in FOUR steps

2012-09-03T04:28:00.000-07:00

Step One :

Go to the SharePoint site collection you want to create the new site.
And click Site Action button to drop down the Site Action menu.
The select New Site in Site Action menu

Step Two :

Select the type of the site template you want to create. Team Site template is the most popular template among those

Step Three :

Enter the Title of the site you are going to create and the URL of it

(If you are planning to manage the permission uniquely, click More Option rather than Create)

Step Four :

Enter the Site Title and the URL you are going to create.
Then select Use unique permission to introduce a different permission structure which not use in the parent site of this newly creating site
Click Create button to create the new site.

That's ALL......!

Raising a Button Click event programmatically

2012-07-04T01:36:00.003-07:00

When developing windows (C#) forms, as developers we are very much concerning about speedup data entering of users. Minimizing use of mouse, use of tab key to move courser from one text box to another, etc. are main methods can increase data entering speed.

Other than that use shortcut key for button operations is also speed up the data entering.

As an example thinks that we can assign F2 key for data saving and F3 for deleting addition to having Save and Delete buttons.

According to our common practice we are write the code to save the record under button click event of “Save” button.

private void btnSave_Click(object sender, EventArgs e)

{

//The code goes here

}

private void btnEdit_Click(object sender, EventArgs e)

{

//The code goes here

}

To execute same method for F2 key press event, we have to override inherited method of the form which called ProcessDialogKey.

Parameters

keyData

One of the Keys values that represents the key to process.

Return Value

true if the key was processed by the control; otherwise, false.

Remarks

This method is called during message preprocessing to handle dialog characters, such as TAB, RETURN, ESCAPE, and arrow keys. This method is called only if the IsInputKey method indicates that the control is not processing the key. The ProcessDialogKey simply sends the character to the parent'sProcessDialogKey method, or returns false if the control has no parent. TheForm class overrides this method to perform actual processing of dialog keys. This method is only called when the control is hosted in a Windows Forms application or as an ActiveX control. (Source)

protected override bool ProcessDialogKey(Keys keyData)

{

//The code goes here

}

To call the Click event of save button we have to call PerformClick method of it like btnSave.PerformClick().

protected override bool ProcessDialogKey(Keys keyData)

{

if (keyData == Keys.F2)

{

btnSave.PerformClick();

return true;

}

else if (keyData == Keys.F4)

{

btnEdit.PerformClick();

return true;

}

else

{

return base.ProcessDialogKey(keyData);

}

Suppress field in Crystal Reports

2012-06-25T08:53:00.002-07:00

When implementing a system we are normally inserting default value for the fields in Database rather than inserting NULL values. But when we retrieving data from the database and visualize them from a report, all the default values come to the report.

To overcome the situation we can use two methods. One method is mention that default value on a report and says consider it as default value to that relevant field.

The other method is use the Suppress option given by the Crystal report engine.

To use that option, first you have to create the report in the normal way.

Then select the field you have to suppress and right click on it.

Then you have to select Format Object menu item from the popup menu.

Then it will open Format Editor window which will enable to do formatting.

Now navigate to Common tab of the window.

Now check the Suppress check-box and click the button in front of the suppress check box.

Then Formula Workshop window will open.

In here you have to provide a Boolean value . based on it the value of the field will visible in the crystal report. If the provided statement gives true, then the field value will display. If the statement gives false, then the field value wan't appear.

In this scenario, the default value is 1901/01/01. To suppress this, I wrote a formula which check whether the value of the field is 1901/01/01 or not.

Use of Information Rights Management (IRM) in SharePoint

2012-05-16T22:22:00.000-07:00

SharePoint is a Collaborating web platform provider which helps us to share documents and other information with the users of the SharePoint site.
Information security is a main concern when sharing documents with various people. Information Right Management server facilitate to overcome the information right violation and restrict the access of the documents.

Followings are the main advantages of IRM which mentioned on Microsoft.com site

1. Helps to prevent an authorized viewer from copying, modifying, printing, faxing, or copying and pasting the content for unauthorized use

2. Helps to prevent an authorized viewer from copying the content by using the Print Screen feature in Microsoft Windows

3. Helps to prevent an unauthorized viewer from viewing the content if it is sent in e-mail after it is downloaded from the server

4. Restricts access to content to a specified period of time, after which users must confirm their credentials and download the content again

· Helps to enforce corporate policies that govern the use and dissemination of content within your organization

IRM protection can applied at the library level or the list level.

Here are the main steps you have to follow to apply IRM on your SharePoint server

Navigate to SharePoint Central Administration Web site and click on Security menu in the Quick Launch
Click on the Configure information rights management under the Information Policy section
It will direct you to the Information Rights Management page
Select one form the following option

· Do not use IRM on this server - Stop using Right Management server on your SharePoint server

· Use the default RMS server specified in Active Directory - If there any Right management server in the Active Directory Domain service(AD DS) of your organization you can select this option.

· Use this RMS server If there is a Right Management server, you can give the URL of it to apply Rights management to the SharePoint server

Then Click OK

Information Right Management - SharePoint 2010

2012-05-15T07:43:00.000-07:00

Applying Information Right management (IRM) policy to your document library in SharePoint 2010

Set IRM policy
Create a SharePoint group and set permission level
Stop permission inheritance from the parent site
Allow newly created group to access the document library which you want to apply IRM policy
Add users to the group

1.
Go to the Document library which you want to apply information Right Management server (IRM server)Click the Library tab

Then you have to click on the Library Settings icon of the Library tab

You can see the following interface under the Library settings

Then select Information Right Management under Permissions and Management which will open IRM Policy creation page

Permission Policy Title: Give a title to identify the policy you will create. (Give a meaningful name for it)

Permission Policy Description: Give a short description to the policy

Allow Users to print documents: If you check this, user can print the documents. By unchecking you can restrict taking printouts of the documents in this document library

Allow users to access content programmatically: By unchecking this, user cannot copy the content by clicking Ctrl+C or using Snipping Tool or using Print Screen or another mechanism

Users must verify their credentials every ____ days: By checking this and set the number of days IRM server checks user credentials every given time period. If you set it as 30days IRM system check user credentials every 30days.

Stop restriction permission to documents in this library on ____: This will allow you to stop restrictions from a specific day

After setting the IRM policy details click OK and save it.

Now again go to Library settings page and select Permissions for this document library under Permissions and Management

You can see the current user groups which are allow to access this document library by inheritance.

In the yellow strip you can see This Library permissions from its parent. (Your site name)

Click on the site name (in my scenario it’s Training Docs), that will redirect to Group settings page which allow you to create User Groups

Click Create Group to create a new SharePoint user group using following steps and set Group Permission as Restricted Read

Then you have to Stop inheriting the permission from the parent site to this document library

Remove other unwanted user groups as you want (Tip: Don’t remove Owner group from the list.)

Now the Newly created user group is ready to add new users. Go to the Group and click Add Users to add new users to the group

Having Content Types with Document Templates when using "New Document”

2012-02-09T01:28:00.000-08:00

If you have document library with more than one content type with a document template in there and you use the “New Document” button to create new documents you might run into some unexpected behavior.

In order to explain what happens I created two content types ContentType1, and ContentType2. Both have the Enterprise Keywords field added to it, so they have something to show in the document panel later on, but this doesn’t have anything to do with the unexpected behavior. Both content types also have a document template, the document template for ContentType1 is DocumentTemplate1.dotx and is saved in a Document Templates library in the same site, the document template for ContentType2 is DocumentTemplate2.dotx and is saved in the same library. For adding the document templates I used the “Enter the URL of an existing document template” option.

I have a document library called Shared Document where I added both the content types. I can now add documents to the library by using the “New Document” button and choosing on of the content types.

I don’t add any special content to the document, I just create a new document and save it back to the library. If the SharePoint site you’re on is not in your trusted sites you will have to “Enable Editing” because Word will detect that the template you are opening is stored on an internet site. Also be aware that Word will try to save the document to wherever you last saved a document. So it won’t automatically select the library you were working in for you, you might have to browse to that library yourself.
As you can see from the image below both document have the Document content type attached to them, instead of the ContentType1 and ContentType2 content types that I selected when I created the documents. So regardless of what content type you use to create the document, SharePoint will pick a content type for you to save the content type as. This doesn’t have to be the “Document” content type, or the default content type of the library you’re working in. SharePoint will just pick the wrong content type for you.

As far as I’m concerned this is a bug. However there is a workaround…

I’m going back into the content type and I’m going to add the document templates again, but this time I will use the “Upload a new document template” option. I can select the document to upload either from my harddisk, or from the Document Templates library I used earlier. I can also use the same template for both content types, this doesn’t affect the workings.

After you saved the changes to the content type the link to the document template will be displayed like this:

If I now create new documents the same way I did before, by using the “New Document” button and selecting a content type from the list, the documents will be saved with the correct content types.

Create Summary view of SQL Datatable

2012-01-20T00:11:00.000-08:00

Combine two rows into one row with same ID

Go through the following SQL table named[EmployeeSales]. Think that you have to create a summary table of monthly sales against each employee ID.

EmpID	Year	Month	Sales
0001	2012	May	0.5
0001	2012	June	0.8
0001	2012	July	0.7
0002	2012	May	1.1
0002	2012	June	0.9
0003	2012	May	0.4
0003	2012	June	0.5
0003	2012	July	0.5

[EmployeeSales] Table

For that You can write a SQL query as follows.
In that Query I have filter sales records relate to year 2012 and sord according to EmpID.

SELECT EmpID
, MAX(CASE WHEN [Month] = 'May' THEN [Sales] ELSE NULL END) AS [May]
, MAX(CASE WHEN [Month] = 'June' THEN [Sales] ELSE NULL END) AS [June]
, MAX(CASE WHEN [Month] = 'July' THEN [Sales] ELSE NULL END) AS [July]
FROM EmployeeSales WHERE [YEAR] = 2012
GROUP BY EmpID
ORDER BY EmpID

EmpID	May	June	July
0001	0.5	0.8	0.7
0002	1.1	0.9	Null
0003	0.4	0.5	0.5

[Result] Table

SharePoint 2010: Customize SharePoint Add/Edit/Display Form

2012-01-10T00:10:00.000-08:00

When you create a SharePoint list the default SharePoint add/edit/display form get its looks by its own. For example the fields appears in the add/edit/display form based on the sequence you added the fields. Also by default all fields of the list are shown in the forms. Sometimes you may need to give a hand to customized that look and feel. I’ll try to give some light on how you can customize the default add/edit/view form of SharePoint list.

Enable Content type Management First

To customize the List forms you need to enable ‘content type management’. You can do so from List settings Page and then click ‘Advance Settings’. Then select yes for “Allow management of content types” as shown below:

Figure 1: Enable content type management.

Once you have enabled the content type for a list you will find a available content types associated with the lists under ‘content types’ section of list settings page as shown below:

Figure 2: Content type management section in list settings page

Hide fields from add/edit/display form

Sometimes you may want to hide some fields from add/edit/display form. Scenario might be you don’t want users to edit the field directly, rather the hidden field’s data will be populated differently (maybe from event receiver or timer job). To do so click on the Content Type (usually Item) and then you will be landed in a page as shown below:

Figure 3: Item Content Type editing page

As you see from figure 3, the content type page is showing all my field but only Product Name (internally the field name is Title) is coming from Item content type. Other fields are added by myself. Now let’s say you want to hide the launchDate field from add/edit/view form. To do so click the field link ‘Launch Date’ and you will be taken to a page as shown below. From that page you can hide a field.

Figure 4: Hide fields if needed

For your information, the hidden field will not appear in add/edit/display from but you can still access the field in list views.

Reorder Fields in add/edit/display form

You can reorder how the fields will appear in the list add/edit/display from. To do so take a look a the figure 3. You will find a link “Column Reorder” at the bottom of the item. Click the link and you will be moved to a page as shown below where you can reorder the presence of the fields in add/edit/display form.

Figure 5: Reorder fields in add/edit/view forms

Want more customization?

If you are not even happy you can create your own custom add/edit/display from as described my another post. Also you can even edit the add/edit/display from in infopath. To do so open the site in IE browser and the navigate to list settings page. And then click “Form Settings” as shown below:

Figure 6: From settings option in list settings page.

Clicking on the form settings page, you will be navigated to a page as shown below:

Figure 7: Form settings page.

Clicking ok in the page as shown in figure 7, you will be asked to open the page in InfoPath editor as shown below. However you need to use IE browser to open the InfoPath editor directly from browser:

Figure 8: Edit form in InfoPath.

I’m not going to bring InfoPath in today’s discussion as this can be more complex. However If I get chance I’ll come back to you with a post on “how to use InfoPath to edit the form”.

Source : http:// ranaictiu - technicalblog.blogspot.com/

SharePoint 2010: Approve/Reject dialog customization, show changed values

2012-01-10T00:06:00.000-08:00

SharePoint provide rich support for approval process. You can maintain version of changes, you can use built-in workflows or develop your own for approval process. You can even create custom workflow activities and use it in SharePoint Designer to create your own approval workflow. Unfortunately, SharePoint doesn’t provide a nice UI where approver can get a snapshot of what’s changes he’s going to approve/reject.
What we are familiar with the following UI:

Figure 1: Very generic UI to approve/reject

What if we could have a dialog as shown below:

Figure 2: Custom Approve/Reject dialog with modification highlighted
As shown in figure 2, the approver will have the better look of what’s the changes he’ll approve/reject. As shown in figure 2, the person who will approve/reject, can get a snapshot of what changes are waiting for his/her approval.

What’s the cost of custom approve/reject dialog?

Now the question comes what’s the development cost of such a custom approve/reject dialog? I’ve just developed few classes for returning a list of items with three fields (Field Name, Old Value and new Value) which can be bound to a grid. I’ve already provide the source code in here. But the development process is described below:
Create a custom action menu: You can hide the custom approve/reject menu or you can keep it in place. What I’ve done is included a new custom action menu ‘Approve/Reject Single’ as shown in the image below.

Figure 3: Custom action menu (Approve/Reject Single)

Create custom Application Page: Next you need to develop a custom application page which will be shown in the dialog when the custom action menu (show in figure 3) will be clicked. The custom application page will show the changes (field name, old value and new value) as shown in figure 2.

Download and test the code

If you have downloaded my last code from blog “Approve/Reject Multiple Items” please uninstall the solution first. Either you may find conflict as I’ve used the source code from that post and modified for this post. You can download the code for this post from my MSDN code gallery http://archive.msdn.microsoft.com/SP2010ApproRejectExt. Then from download tab download the second file “SharePoint.ApproveRejectTestWithVisual”.

Conclusion

The provided code is not something that you can just download and deploy in production. The code is just for can-do sample which shows such a nice view of changed items possible.

Source : http:// ranaictiu- technicalblog.blogspot.com/search/label/Ribbon%20UI

SharePoint 2010 Slideshow out-of-the-box webpart

2012-01-07T17:02:00.000-08:00

An easy to use out-of-the-box webpart, for creating a slideshow, was missing in SharePoint 2007 but don’t worry SharePoint 2010 is here.

The webpart is easy to use. You have to create a picture library and upload some pictures. You can also create view that you want to show in the webpart. Click on the ‘Edit hero button’ and the site opens in edit mode. Click on ‘Insert’ and ‘Web Part’. Go to the category ‘Media and Content’ and select the slideshow webpart. The settings of the webpart looks like this:

You can choose from the following settings:

Duration to Show Picture (seconds)The amount of seconds before a new picture will appear.

Picture librarySelect the picture library that you want to use.

Library viewSelect the view that you want to use.

Picture Display ModeDo you want to show the pictures in random or sequential order?

Display withThe pictures can be shown with the title and description.

Show toolbarA toolbar can be shown for selecting the next or previous picture or to stop the slideshow.

The cool thing about this webpart is the ‘Library View’ option. You can use one picture library for all your pictures and use metadata for instance ‘Category’ and apply that to the pictures. You can now use multiple slideshow webparts for the same picture library but with different pictures by using the views.

I also want to point out a negative aspect of the webpart…you can only use the webpart with the picture library from the same site…that is a shame. But this can solved by a smart developer ;)

ps.

I have one tip:

Try to use pictures with the same size because otherwise the webpart can stretch the size of the site.

Original Post find from here: http ://blog .wortell.nl/jasper/sharepoint-2010-slideshow-webpart/

How to upload a browser-enabled InfoPath form template to SharePoint

2012-01-05T08:24:00.000-08:00

I was trying to upload an InfoPath form to a SharePoint server, when I got this error message when trying to verify the form:

"This form template has not been correctly published to be browser-enabled. Open the form template in InfoPath Design mode, and click Publish Form Template in the Design Tasks task pane. Follow the steps in the Publishing Wizard to republish the form template, and then try again."

If you're like me and don't have that much InfoPath experience, you'll probably be stuck for a few minutes. So I made this list of steps (using Office 2010) with what you need to do in order to publish an InfoPath form to a SharePoint server:

Open the InfoPath form in Design mode (right-click the file and choose Design).
In InfoPath, go to File > Publish > Publish form to a SharePoint Library.
Type the URL of the site and press Next.
Make sure Enable this form to be filled out by using a browser is checked.
Choose Administrator-approved form template (advanced) and press Next.
Save the file to your drive or to a network share.
Either copy the file to the SharePoint server or make sure the network share is accessible.
Open Central Administration and go to Application Management > Upload form template (under InfoPath Forms Services).
Choose your file and press Verify to make sure it doesn't have any errors.
Once it is verified you can upload your form template.
After uploading the form template, you have to activate it to a site collection. Click on the context menu of the uploaded form and select Activate to a site collection. Choose your site collection (make sure the Form Services feature is activated at the site collection level) and you're done.

Force the InfoPath form to open in the browser
Another issue that I had was that the form was opening in the Office InfoPath client instead of the browser. An article about this has already been written at Force InfoPath browser-enabled form to open in the browser, but I'll summarize the steps here:

Make sure your Form Library is configured to display the forms as a web page:

Go to your Form Library (e.g. /FormServerTemplates) settings.
Click on Advanced Settings.
Under Browser-enabled Documents make sure the option Display as a Web page is selected.

Check the InfoPath Forms Services configuration in Central Administration:

Open Central Administration.
Go to Application Management > Configure InfoPath Forms Services (under InfoPath Forms Services).
Make sure the option Render form templates that are browser-enabled by users is selected.

Source : http://www.broculos.net/

SharePoint Online

2012-01-05T07:59:00.000-08:00

SharePoint Online

Share documents and information

SharePoint Online makes the power of the cloud work for your business. As part of Office 365, SharePoint Online lets you create sites to share your documents and information, making it easy to work together with colleagues and customers.

Office 365 Features & Benefits

Explore the features and benefits of Office 365, and stay up-to-date on the latest Office 365 information and buzz. Check out the Office 365 site.

Try Office 365 Now

Explore the new features of Exchange Online, SharePoint Online, Lync Online and Office Web Apps. Try it now

Copying/Moving SharePoint 2010 Designer Workflows

2012-01-02T22:43:00.000-08:00

Most often, we required moving or copying a workflow that is created using SharePoint designer between sites or site collections. This was straight forward in SharePoint Designer 2007. You just need to copy the content of the workflow’s config(workflow.xoml.wfconfig.xml) file and the rules file & replaced the list GUID’s. But in SharePoint Designer 2010, there is a little tweak associated with it.

There was an option in SharePoint Designer, Export to Visio which exports your workflow as a .vwi file, and can be imported in to another site using the option Import from Visio. But when you try that option, you will get the below message.

This workflow cannot be imported because it was created in SharePoint Designer for a different site, or the original workflow has been moved or deleted. To move a workflow between sites, use Save as Template (.wsp file) instead of a Visio workflow drawing.

So, to achieve the same follow the steps below.

In the first(source) site, create the required workflow and publish it.
Now select Export to Visio option which allows you to save the workflow with a .vwi extension. (Refer this workflow hereafter as source workflow).
Now go to the destination site where you want the workflow to be copied, and create a new workflow with the same name as the previous one & publish it.
Now select Export to Visio option which allows you to save the workflow with a .vwi extension. (Refer this workflow hereafter as Destination workflow).
Now you will be having two .vwi files (one of source workflow’s – SourceWorkflowName.vwi and other of the destination workflow’s – DestinationWorkflowName.vwi). Now add .zip extension to both the files. Now your files names should be SourceWorkflowName.vwi.zip & DestinationWorkflowName.vwi.zip.
Now open both the zip files, copy workflow.xoml.wfconfig.xml from destination workflow to source workflow. (Its destination to source and not source to destination).
From now on, we will not use the file DestinationWorkflowName.vwi.zip. So ignore that file.
Remove the .zip extension from SourceWorkflowName.vwi.zip which gives you the SourceWorkflowName.vwi file.
Now, go to the destination site, open workflows and click Import from Visio and browse to theSourceWorkflowName.vwi file.
That’s it and your workflow is copied. You can publish the workflow and run it.

PS : In case if your list’s GUID’s (for those lists that you have used in workflow – tasks list, history list or any other lists used in workflow steps) have been changed from source & destination site, you may need to update those steps in the workflow.

Source : http://chanakyajayabalan.wordpress.com/2012/01/02/copyingmoving-sharepoint-2010-designer-workflows/

Error with iLove SharePoint - Lookup Field with Picker

2012-01-02T22:39:00.001-08:00

iLove SharePoint - Lookup Field with Picker..
http://ilovesharepoint.codeplex.com/

Error : "Only PickerDialog types can be used with the dialog. The type should be configured as a safecontrol in this site."

To solve this problem I have add following safecontrol statement to the web.config file.

STEP 1
Go to : C:\Inetpub\wwwroot\wss\VirtualDirectories\

STEP 2
Open the "web.config" file and find the place which safecontrol tag starts.

STEP 3
Add the following statement within safecontrol Tags

SafeControl Assembly="iLoveSharePoint.Fields.LookupFieldWithPicker, Version=1.0.0.0, Culture=neutral, PublicKeyToken=c8ecfa5d637948fe" Namespace="iLoveSharePoint.Fields" TypeName="*" Safe="True"

* add "<" at the start of the above statement and add "/>" at the end of the statement

SharePoint 2010 JQuery Slideshow with image fade

2011-12-23T01:03:00.000-08:00

1. Download the following Javascript

http://www.sendspace.com/file/b0jujl

2. Upload those(Jquery.js and jquery.innerfade.js) to your SharePoint site any document library

3. Copy the URL of each Javascript files

4. select the appropriate Image files and upload them in to another image library of your SharePoint site

4. Now go to your SharePoint site home page and add Content Editor web-part

5. Then click Edit Web-part in the down arrow in right side and click Edit HTML in menu bar

6. Add following scripts in to HTML body of the web-part (replace red color parts appropriately with the URLs of JavaScript s and URLs of Images)

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

</script>

$(document).ready(

function(){

$('#news').innerfade({

animationtype: 'slide',

speed: 750,

timeout: 2000,

type: 'random',

containerheight: '1em'

});

$('#portfolio').innerfade({

speed: 'slow',

timeout: 4000,

type: 'sequence',

containerheight: '220px'

});

$('.fade').innerfade({

speed: 'slow',

timeout: 1000,

type: 'sequence',

containerheight: '1.5em'

});

}

);

</script>

</ul>

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

Sharepoint Form Validation using Javascript

2011-11-07T01:42:00.000-08:00

1.First open the Newform.aspx which you want to validate.(go to list and go to "New item" page)

2.then add ?PageView=Shared&ToolPaneView=2 part at the end of the urlEx: http://mysite/Lists/job/NewForm.aspx
http://mysite/Lists/job/NewForm.aspx?PageView=Shared&ToolPaneView=2
3. Add "Content editor web part " and modify this web part with source editor option
4. Add following javascript which use to validate start date & due date

5. Now use it...

6. If you want to use javascript to validate other field just put following script and modify it as you wish..

<Script language="javascript">
function PreSaveAction()
{
//add your JavaScript code here and return true / false
}

</Script>

Get Client Machine name from web app

2011-11-07T01:37:00.000-08:00

If you want to get the client PC name, you can use the following code block.

string computer_name;
string[] Host_Name = System.Net.Dns.GetHostEntry(Request.ServerVariables["REMOTE_HOST"]).HostName.Split(new Char[] { '.' });
computer_name = Host_Name [0].ToUpper();

Run-time XAML code compiler

2011-11-06T07:38:00.000-08:00

XAML(Extensible Application Markup Language) is a declarative markup language. As applied to the .NET Framework programming model, XAML simplifies creating a UI for a .NET Framework application. You can create visible UI elements in the declarative XAML markup, and then separate the UI definition from the run-time logic by using code-behind files, joined to the markup through partial class definitions.

In both WPF and Silverlight interfaces designing use XAML.

In this post I'll show how to execute and display user entered XAML code at the runtime.

first you have to create a silverlight application
add a text box to take the user inputs (editingTxt)
add a text box to display error messages (statusTextBlock)
add a border controller to display the output (output)
add a button control and put the following code in to button click event

object obj;

try

{

obj = XamlReader.Load(editingTxt.text);

}

catch (XamlParseException exc)

{

statusTextBlock.Text = exc.Message.ToString();

string ccode = str;

string[] lines = Regex.Split(ccode, "\r\n");

int lineCount = lines.Length;

statusTextBlock.Foreground = errorBrush;

editingTxt.Foreground = errorBrush;

return;

}

if (obj == null)

{

statusTextBlock.Text = "NULL object";

editingTxt.Foreground = errorBrush;

return;

}

statusTextBlock.Text = "OK";

editingTxt.Foreground = okBrush;

if (obj is UIElement)

{

output.Child = obj as UIElement;

}

else

{

TextBlock txtblk = new TextBlock();

txtblk.Text = obj.GetType().ToString();

output.Child = txtblk;

}

Demo Download : http://www.sendspace.com/file/xxbfb6