Wednesday, September 21, 2011

Look up columns problem with List Templates.

When we try to recreate the lists with look up columns from one site to another site, we lose the look up connection.

For example if have two sites 

A and B

A has list called A1 which has a look up column referring List AL1

If you want to take a copy of list A1 and recreate it in site B as B1 with look up referring to BL1.

Follow these steps

  1. Save List A1 as template (.stp).
  2.  Go to site collection settings.
  3. open the list template gallery.
  4. Save the A1's template in your computer.
  5. Go to the .stp file saved in you computer.
  6. change its extension to .cab 
  7. open the ziped file and extract the files in it to a folder.
  8. Open the manifest.xml file in notepad (or any other text editor).
  9. search for the GUID of list AL1 and replace it with GUID or BL1.
  10. save the manifest.xml file
  11. open command prompt and type the command "makecab manifest.xml template1.stp".
  12. It creates the template1.stp file.
  13. Upload template1.stp to the site collection of B site.
  14. create the list B1 using template1.stp.
  15. If you have multiple look up fields repeat the step 1 to 14 for all those fields.



If this is post is helpful, please leave a comment. Thanks.

Thursday, May 5, 2011

JQuery Script to Move View Selecting Menu to left side.

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.min.js"></script>

<script type="text/javascript">

$("td.ms-toolbar:last").insertBefore($("td.ms-toolbar[width='99%']"));

</script>

Friday, April 29, 2011

Copying and Moving SharePoint Designer (2007) Workflows....

Hi,

        This is a common challenge for every one who works on SharePoint Designer Workflows.

       In the working environment, after developing a workflow on a list using SharePoint Designer. There is no Out-of the -Box option to assign that workflow to other List in same server or in other server.

Here is the a simple work around for that

NOTE:- You should have the same column names in both lists. Atleast you should have the columns that you used in rules or actions of the workflow. However, the workflow can be moved eventhough if you dont have the common columns. But the problem is after moving the workflow, the columns that are not present in new list will be listed as blank in workflow. Don't worry you will understand after starting working on it.


Here are the steps.

1) open the WorkFlows folder in SharePoint Designer
2) Expand the workflow that you want to move
3) open <your workflow name> .xoml.wfconfig.xml file.
4) In the Association tag replace the listid with your new list id *.
5) save and close that file.
6) open you workflow xoml file and click finish.
 Thats it you are done.

* In order to find the List ID of your New List open the list setting. In url you can find the list id.
( Replace %7B with {, %7D with }, %2D with -).

Post Comments if you have any trouble doing this.


Please leave a comment if this post is helpful to you.

Thursday, April 21, 2011

No Incoming Email feature in Office 365

Hi,

Two days back i got access to my Office 365 SharePoint site. It is so amazing. I am really excited with this new cloud computing feature. I started using it for my new business.

However it has a drawback. That is, lack of a feature which i expected to have. That is Incoming Email for Lists and Libraries.

Monday, April 18, 2011

Hotfix for Time-Based SPD07 Actions (Pause for, Pause till)

Hi,

If you are using Sharepoint 2007. You will face the problem with Time Based actions in SharePoint Designer Workflow. They are

1) Even if the timer is done the next action will not be processed
2) The cooments field of workflow doesnt update the time remaining to go for next action
3) The workflow will be freezed at pause action forever.

Here is the Hotfix for that problem


http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6096ce0f-d21e-47ac-afe2-d4e1c2fce670&displaylang=en

Thursday, March 24, 2011

Thursday, February 17, 2011

Simple CSS code to hide Time on the top of each entry in Calendar View.

Hi,

In the Calendar View, by default the time will showed on top of each entry.

If you are entering time at the time of new item creation thats fine. But if you are using only Date field then it shows you as 12:00 AM for each entry. In order to hide that in Month and Week view:

1) Site Actions -> Edit Page-> Add WebPart -> Content Editor WebPart.
2) Modify Shared WebPart -> Source Editor.
3) Paste this code


"style

td.ms-cal-monthitem A NOBR {display:none;}

a.ms-cal-dayitem NOBR {display:none;}

/style"
NOTE: style are HTML tags.
.

Done.


Please Leave a comment if this post is helpful to you. Thanks.

Thursday, February 3, 2011

Two Useful links to configure SSL in WSS 3.0 and Windows Server 2003 IIS 6.0

Steps to setup SSL in Windows Server 2003 (IIS 6.0)

http://www.petri.co.il/configure_ssl_on_your_website_with_iis.htm

Steps to setup SSL for WSS 3.0 Web Application

http://volcane.blogspot.com/2008/05/setting-up-ssl-for-windows-sharepoint.html









Wednesday, February 2, 2011

To open a link in new Window.

Usually we use Anchor tag  to add a link in our webpage.

It opens the link in same page. If you want to open the link in a new window

Add the parameter to you Anchor tag

that is

target="_Blank".

The way to Add dataview webpart with the content form other site.

Hi,

If you are in a situation to display the list in your ASPX page which is from the other site. It is very easy . Only thing you have to do is creating a connection to the site which is having that list.

Here you go,


1) Open the site where your aspx page is.
2) open the page.
3) In the right site tool bar open Data Sources Library tool bar.
4) In the bottom you can see a link "Connect to another Library".
5) Click on it.
6) Click on add button in Manage Library window.
7) Type the url of site in which the list is sitting.
8) Give some name for your identification and click ok.

Done. Now you can see all the lists and libraries of that site. And you can create a data view webpart with those lists content.

The way to Display Richtext box content with out HTML tags in Data View Webpart.

Hi,

If you are trying to display your list which has a Rich Text Box field in dataview webpart. It shows the content of that field with the html tags like
etc...

To avoid those tags and show the text in a regular style.

1) Open that page in Sharepoint Designer in Slit View.
2) Click the cell that has the rich text box content in the dataview webpart.
3) In the Code part it highlights an XSL tag.
4) In that tag add the parameter "Disable-Output-escaping" with its value as "Yes".

Done. Click on the design view. You will see the content with proper styling.