SharePoint - Design and Customization Forum

Hiding a Place Holder if it's empty

Tue, 01 Dec 2009 09:48:09 Z

Hi,
We are displaying the page title within some styled DIVs at the top of our pages but some users choose not to supply a title. As a result, on these pages, we still see the styled DIVs but with no content.
Is there some way in which I can add a tag that will only render the place holder if the field has a value? I'm not familiar at all with .NET so I was wondering if this could be done with SPD?

Thanks.

Removing scrollbars from a web part

Tue, 01 Dec 2009 19:10:40 Z

My web parts vary in size and always display both horizontal and vertical scrollbars.

I wish to remove the scrollbars and do not wish to play with the height or wodth of the zone.

These web parts are destined for use in Sharepoint web pages and are created in .net.

I have not come across a defintiive article and code showing how to do this. Can someone give me some guidance on this subject?

Rdegards

Charles

"The data source control failed to execute the update command."

Wed, 02 Dec 2009 10:59:46 Z

Hi,

I've created a document library EditForm.aspx using Custom List form control. It works fine on Save. But, when i try to update any document using that customized form then it generates error.

The data source control failed to execute the update command.

Sohaib Khan | http://muhskhac.spaces.live.com

Using Dataview to input Documents

Wed, 02 Dec 2009 11:46:30 Z

Hi,

I am trying to use a dataview to upload documents. I have created the dataview, but when I try to upload it I get an error message: "The data source control failed to execute the insert command".

Is it possible to use a dataview to upload documents given that I cannot edit the name (which is a required field). Where am I going wrong?

Is it possible to show documents from another Document Library from another site?

Tue, 01 Dec 2009 15:37:07 Z

I am currently working on multiple sites that will need to share documents (e.g. the main site has all the documents in it, whilst the other sites only show the documents that were uploaded to that site). Using WSS 3.0 and SPD 2007 is it possible to share document libraries across sites? I have tried the "Connect to another library" option in the "Data Source Library" window, but I still am unable to see any of the lists from the newly connected site. Below the connected site I only get the following groups: Database Connections, XML Files, Server-side Scripts, XML Web services, Linked Sources.these should include Sharepoint Lists and Sharepoint Libraries, but does not.

Help please.

thanks.

Change behavior after mouseclick

Mon, 30 Nov 2009 15:23:17 Z

I have a sharepoint list with a few items in it.
How can I programmatically change the default behavior if I click on the item?

Do I have to change something in the schema.xml?

How to save the document in a Check-In state through Custom List form of a document library

Wed, 02 Dec 2009 10:20:07 Z

Hi,

I've added a new custom list form in an EditForm.aspx page of a document library. I've removed the default list form. On Check-In, it saves the meta data and the document to the document library but it is saving the document as Check-Out whereas i need to save the document with Check-In state.

I need a solution to resolve this. Any Idea ?

Sohaib Khan | http://muhskhac.spaces.live.com

Database connection table confusion

Tue, 01 Dec 2009 17:42:50 Z

I am connecting a database from another site to this site and am having a bit of trouble with selecting the specific Table/View that I need. I am trying to get specific items/documents to appear in a dataview and cannot seem to find the correct choice on the "Configure Database Conneection" window. Is there a spcific choice that will allow me to select those items? At the moment I can only get the ids to appear and am not even sure what these ids relate to.

How to collapse and expand list headings.

Tue, 01 Dec 2009 09:12:24 Z

Hai,
I have share point site which is created using team site template for HR related tasks. Here My problem is:
I need to create some headings like Time sheets,Leaves etc in quick launch. Those headings should be expandable and collapsible. Under each heading there will be some lists. Once user clicks on a header that header should expand and user should be able to see the lists under that heading. Can we achieve this or any alternative for this? please help me.

Hide the site actions button in a publishing site

Tue, 01 Dec 2009 18:28:58 Z

I realize that this question has been asked elsewhere, but...

I need to hide the site actions menu on a publishing site.

We have been using non-publishing sites for a while but now need to use publishing sites. Before we hid the menu using SPSecurityTrimmedControl however, this doesn't seem to be working for the new publishing site (which was actually a non-publishing site before we enabled the Server Publishing feature). Is there something else I need to do?

Many thanks in anticipation of your replies,

HaydenHaddock

Web Part and Custom List on one .Aspx page using Sharepoint Designer

Wed, 02 Dec 2009 07:39:04 Z

Question1: Is it possible to customize an .aspx page, by importing list 'A' web part and list 'B' data view onto one page using SPD?

Background: I am running an approval workflow on list 'B' and the plan is to customize the new item form. By keeping information of List A by importing its webpart.

Question2: Similarly is it possible to customize workflow approval page using SPD?

---

Any help or assistance, will be highly appreciated.

Thanks & Best Regards,
Fake Steve Jobs

How to Customize the DVWP to receive the Current User 'or' another condition

Tue, 21 Jul 2009 13:47:53 Z

1)I have a current User Web part on a page.
2) I have a list which determines which Account Codes a User is associated with.
3) There is another list of transactions, for which each has a single account code, and has created-by fields which contain user names.

I want to show the Current User only those transactions
1. which they created OR
2. for accounts they are associated with.

Now I have the Current User Web Part connected to a DVWP [2] which shows only the accounts associated with current user.

I can connect a [3] DVWP of transactions based on the account code chosen in [2] via connections, but in order to provide the 'OR' condition of created-by, I have to use parameters, right?

How can this be accomplished?

George W

Content is overlapping with Footer in Internet Explorer-7 in MOSS 2007 site

Wed, 02 Dec 2009 06:19:19 Z

We have a MOSS 2007 site with dynamic contents in a page. When we are using Internet Explorer-6, the content is not overlapping with Footer and when we are using Internet Explorer-7, the content is overlapping with Footer.

We have tried by replacing the height with min-height 100% in CSS file and this is working fine only when the Explorer is in Maximized mode and content is very less. But, when we re-size the window, the content again overlaps with Footer.

Customization of Content Query WebPart (CQWP)

Tue, 01 Dec 2009 10:48:38 Z

Hi,

I am using a CQWP to show the contents from a list. But I want to change its default styles, like, font family, size, color, bullets. So is it possible to customize the default style of CQWP ?

Any kind of help would be appreciated.

Thanks in Advance,
Saurabh Mathur

Updating existing Site Content Type

Tue, 01 Dec 2009 11:19:40 Z

Gurus,

I have a situation where I need to modify existing Content Type which is used across various list definitions.
Can you please guide me about the implications of modifying content type?

Will there be any affect on the existing lists which hold quite a few records already.

Best regards,
Uday Takbhate

Restricting attaching file while editing list items

Tue, 01 Dec 2009 19:56:27 Z

Hi,

I need to restrict users from attaching new files or delete any existing attachment while editing a Tasks list item. Is there some way to do this non-programmatically?

I appreciate any inputs on this

Thanks

Sandeep

User entry for custom view of sharepoint list

Wed, 02 Dec 2009 01:05:35 Z

I have a sharepoint list that was a spreadsheet import with approx 40 columns. I would like to build a quick entry form where a user could input a value which will only pull those values associated for the rows within the sharepoint list. So if a user types in 1234 - the returning results will only show the rows of data that relate to column X - where 1234 is the associated value.
Nothing fancy - or complex -
Many thanx

Filter and Grouping in Dataview

Tue, 01 Dec 2009 21:15:45 Z

Hi there,

I've got multiple calendar list. I've created a dataview using all these calendar list as a linked data source. The dataview has 2 date/time columns, 1 people field, 1 text field and the last field is the path of the list. The people filed column has xslt expression to show only the user's name and is formatted as Text only. The Path field also has xslt expression to show certain info instead of showing a long url and is formatted as text field. So far everything is okay.

Dataview properties, I enabled "Show toolbar with options for Filter, Sort, Group". Now here's how the data view web part behaves.

Filter:
- If I try to use Filter, it's available for each column except for the People field column. If I create a standard view in the browser, there's no problem filtering people field column
- Also, for the text field columns, duplicate text shows up in filter option. So, for example, there are 2 records in the text column as "Room 1". In the filter option for this column, "Room 1" will show up twice even though they are spelled same way

Sort:
- Seems to be working fine but cannot sort by the column containing value from People field

Group:
- Same issue as Filter and Sort. People field column is not available for grouping
- One of the field is the List's PATH. I had used xslt substring function to show necessary info only. But, when I do the grouping, the full list url shows as the group header. How can I apply the same xslt transformation to the group heading? I can fix this by creating another column in each list with default value and then hiding it from the users. But I would prefer not to create a separate column in each lists, if I don't have to.

Would you be able to advise on this?

Editing the default page of your site

Tue, 01 Dec 2009 17:12:30 Z

Hello, I am wanting to edit the default page of my publishing site, but it seems that when I go to edit it in SPD, it's taking me to the masterpage layout. I only want to edit the default page of my site, not all of the layouts of "article page with body"

I'm just looking to make a few changes to my homepage basically. I don't want to change the masterpages at all.

Thanks!

Changing the color of one of the links in the top nav bar

Tue, 01 Dec 2009 17:15:46 Z

Is it possible to change the color of one of the parent links in the top nav bar?

I seem to only be able to select the entire nav bar in SPD and can't single out one of the parent links.

Thanks

Sharepooint Designer

Tue, 01 Dec 2009 15:58:06 Z

I have modified a form with Sharepoint Designer and now all the labels are not visible in the form or for any form in the site. Can this be fixed? I don't see any errors, but the view all site content link, is not there...I'm thinking this might be permenant... Please tell me I'm wrong!

Calendar view customization

Tue, 01 Dec 2009 13:54:27 Z

Hi guys,
I need to customize Calendar View for a one day so it will have 3 sections. E.g. I have 3 kinds of events and I want a column for each type of event in my calendar view. It should looks like 2 vertical lines which will make 3 parts of calendar and I also need a name for each column.
What's the best way to do it?

Audience Targetting with DVWP

Tue, 01 Dec 2009 12:10:24 Z

Hi,
I have a CQWP that retrieves Event items - six in total - and then applies audience filtering. So the CQWP almost always actually displays less than six items.
Ideally I'd like it to always display six items to whoever is visiting the site.
I thought about using the DVWP to retrieve twenty items and then filtering them down in the XSL. Does anyone know how I would go about this in XSL? Or have a better idea of how to implement this?

Thanks.

SharePoint Custom Survey

Tue, 01 Dec 2009 10:43:48 Z

Hi,
I have created a customized survey in MOSS. I am creating multiple chocie question allowing user to select multiple answers (A,B,C,D).
User1 selected A,B and user2 selected B,C. Now when I am displaying graphical view I am getting the result like following:
A 0%
B 0%
C 0%
D 0%
A,B 50%
B,C 50%
and so on

My requirement is that I want the output in the following way:
A 50%
B 100%
C 50%
D 0%

Any pointers to achieve the same.

Thanks
Parveen

dynamically filter data in a lookup column?

Tue, 01 Dec 2009 19:24:27 Z

so there are dozens of articls about cascading drop down lists but I have a question regarding the same concept

we have a list of contracts. a given contract has an associated status. The status is a lookup from a contract status list.

we also have a set of rules for which state a status can be, so ive created a secondary list which has a relationship. basically two columns, both lookups for contract status. One is labelled start state and the other is labelled end state.

basically i need to be able to filter only the coordinating items.... i.e... if a contract is "approved" then it can go to any of the status's that have a start state of approved.

hopefully this makes sense and maybe im going about this the wrong way so please advise if so.

Thanks,
Brian

Disabling the nodes using hidden fields

Tue, 01 Dec 2009 04:27:50 Z

Hi,
I have got a problem with treeview.. my task is to disable all the nodes accept the selected one. How can this disabling be done using hiddenfield in master pages?

Thanks in advance

Inserted images incorrectly positioned and not saved when using WYSIWYG editor

Thu, 26 Nov 2009 00:15:49 Z

When I try to insert an image into publishing pages in SharePoint using the WYSIWYG editor the image sometimes appears in the very top left corner of the website (rather than in the PublishingContent area that it should appear in). If that happens and I hit "Save as Draft" or "Publish" the image won't be saved. The image also does not show if I "Edit the HTML Source" directly.

Sometimes it works fine, but the majority of times the WYSIWYG editor throws the image into the top left corner and it won't work.

I cannot figure out for the life of me why this is happening and how to fix it. I have got access to SharePoint Designer, etc. to fix it, if there is a way. I could even enter the <img> tag manually, which I am doing at the moment, but I cannot expect all the other Contributors to be able to do the same.

Is there any fix for this?

Is there any reason why you can't have both an XSLT filter and column header filter on a dataview?

Tue, 01 Dec 2009 21:03:39 Z

Is there any reason why you can't have both an XSLT filter and column header filter on a dataview?

I just confirmed that removing the XSLT filter along with the parameter, textbox webpart and webpart connector that was driving the XSLT filter and now the column header filters are working again.

I readded the simple webpart form, parm and webpart connection without coding out the xslt filter, but now column filters just ask if I want to clear filters without populating them.

Thanks for any help or information.

XSLT Filter - FormatDate?

Tue, 01 Dec 2009 16:39:26 Z

I have this filter on a DataView in sharePoint Designer. It's allowing me to filter on partial match from a parameter on several columns. It works for all columns except date columns. In addition to text, I'd like the operator to be able to enter partial strings for example "12/1" and "/1999"

[contains(translate(concat(' ',@Entity,@Name,@SurgeryDate,' '),'ABCDEFGHIJKLMNOPQRSTUVWXYZ','abcdefghijklmnopqrstuvwxyz'),translate($Search,'ABCDEFGHIJKLMNOPQRSTUVWXYZ','abcdefghijklmnopqrstuvwxyz'))]

I've tried these two, the first gives me a syntax error and the second does not work.

(FormatDate(string(@SurgeryDate) ,1033 ,1)),

(string(@SurgeryDate))

Currently that date data looks like this on screen

12/1/1999
12/1/2005

and looking at the XSL code for the dataview, the row data is formated as such:

<xsl:value-of select="ddwrt:FormatDate(string(@SurgeryDate) ,1033 ,1)"/>

Thanks.

How to add icon to title bar of sharepoint webpart

Tue, 01 Dec 2009 15:57:13 Z

How do I add an Image/icon in title bar(Place where title/text of web part is shown) ?

Titlebar becomes as hyperlink when
<DetailLink> tag is present example.

DetailLink>Lists/Announcements/AllItems.aspx</DetailLink>

What I need to do is.... show a icon in front of title text in title bar, and on click of that icon div will be displayed showing information about that webpart.

Please advice and let me know in case of any further clarifications required.
Thanks in advance

how do I apply new master page after making copy of old one?

Wed, 25 Nov 2009 20:52:45 Z

I want to create a custom master page that I can use on a set of custom webpart pages I made. I copied my default.master and renamed it custom.master. I then opened up one of my webpart pages (in SP Designer). I thought to apply the new one all I would need to do is change the MasterPageFile attribute in the Page directive like so: MasterPageFile="~masterurl/custom.master" . But when I try to access my page via the browser after doing this I get an error. Can someone please tell me how to apply me new master page to already existing pages? Also, I expect to make a few more of these custom pages. Is there a way to apply this new master page at the creation of the custom webparts page?

SharePoint custom Web Part

Wed, 18 Nov 2009 19:01:04 Z

We have a requirement to create a web part that displays bunch of services (service title with image). Each service has menu and submenu items with links to other webpages/emails. These menu items need to be populated dynamically a popup when user click on the service link.
At the same time we need to make this web part maintenance free to SharePoint team, even for adding/deleting service links or menu items. ours is MOSS 2007 environment fyi.

All ideas are welcome and appreciated.

Thanks,

No item exists error when I click edit link in DataView

Fri, 26 Oct 2007 02:56:49 Z

I modified my Customers DispForm.aspx to include a CustomerOrders

and CustomerReservations DataView. Both of my DataViews show the

edit and delete links for the Orders and Reservations related to a Customer.

Both of the DataViews work fine, except for one strange problem in

CustomerReservations DataView. When I open Customer Item that

has an id of 300 or less, I can click edit and delete and I see the expected results.

EDIT RESERVATION ITEM FAILS WHEN THE CUSTOMER ID > 300

When I open Customer Item with id greater than 300, I click delete on the CustomerReservation DataView

and it works. However, when I click edit on a CustomerReservation Item, I get this error.

No item exists at http://site/subsite/Lists/Customers/DispForm.aspx?ID=450. It may have been deleted or renamed by another user.

So I copy and paste the http://site/subsite/Lists/Customers/DispForm.aspx?ID=450 link on IE and

it displays the Customer Item with no problem.

Now is this a SharePoint bug, or is there something wrong with the way I added

the DataView on SharePoint Designer?

Any insight into this matter is greatly appreciated.

is there a way to remove columns that display in ViewEdit.aspx?

Tue, 01 Dec 2009 00:18:52 Z

Being new to SP, I created some columns initially in my list, that I no longer want. I've deleted them from Content Types (Item) in listedit.aspx, but I they still show up in the editing page for my views (viewedit.aspx) . Is there a way to delete them there?

Right way to create a customized Site - Site Definition or Site Template

Tue, 01 Dec 2009 13:03:22 Z

What we want to do:
Create a site using STS#0 (Team Site), add a Blog and Wiki sub-site and apply customizations to the Shared Documents.

What we tried:
- Create a Feature Receiver, based on the site creation, to add the sub-sites and other functions. We used a Custom Site Template because we can tailor the site and store it for usage. Then we found out Feature Staples only trigger Feature Receivers for Site Definitions, not Site Templates (who thought that was a good idea?!).
- Copy the STS#0 Site Definiton to Custom#0 Site Definition and Staple to that. One concern is upgrade-path compliance.

Questions:
- If we build a custom definition based on the STS#0 Site Definition, what happens to it during upgrades?
- Is there a way for a Feature to detect that a site it's been activated against has been 'created' from the template?

Thank you.

sharepoint tag for html editor in content editor webpart

Fri, 20 Nov 2009 09:56:25 Z

Hi,

I need sharepoint tag for html editor in content editor webpart for content administrator

for ex: I found this Code for Rich TextBox Editor,In the same way I need HTML Editor code Please help me

<table>
  <tr>
   <td class="ms-pagetitle" style='width: 100%'>
   Brand Basic Page</td>
   <td class="ms-propertysheet" nowrap="true">
   <SharePoint:BpScript runat="server"/></td>
  </tr>
</table>
<script>
var navBarHelpOverrideKey = "wssmain";
</script>
<SharePoint:RssLink runat="server"/>
<SharePoint:ScriptLink language="javascript" name="bpstd.js" runat="server"/>
<style>
Div.ms-titleareaframe {
  height: 100%;
}
.ms-pagetitleareaframe table {
  background: none;
}
</style>

In the same way I need HTML Editor code Please help me

Thanks
Naresh

Redirect user after adding item to a list

Tue, 01 Dec 2009 08:50:20 Z

Hi guys,

I have a calendar list and I want users to be redirected to site page not calendar list list after user added item to this list. So it should look like

User clicks Add button
Inputs some data
Clicks on OK button
Get redirected Site start page

So basically I need to set a redirection for one exact button in exact list. Is there a way to do this?

How to set master page of personalized view in sharepoint

Sun, 29 Nov 2009 06:48:20 Z

Hi,

I need to make few changes in my organization's intranet site master page. I changed the same by going to _catalog\masterpage. Now the change is getting reflected in all the shared pages but not in personalized page.

Please help...

Regards

Srila

How to force fixed values to an item field when a list item is created

Wed, 25 Nov 2009 13:34:18 Z

Hello,

I have the following scenario.
We have a team site and within this team site we are using various web part sites to create different views for different scopes of the team.
For example there is a web part site called "Corporate Identity" which shows only documents an disussions which have the value"corporate Identity" in the self created meta data field "scope" used in the team disussion and the document library of the team site. Now I am searching for an solution to force a value for the self created meta data field "scope" if an item for example a new discussion item is created within the web part site "Corporate Identity" so that the "scope" value is set automaticly to "Corporate Identiy".
I tried to create a InfoPath form but I was not able to select the "text body" field within the data connection.

Has anyone any idea how this is solved or an alternative way?

Help is appreciated.

Thanks.

Ten Themes For Sharepoint

Tue, 01 Dec 2009 08:35:30 Z

Firstly, apologies for being such a newbie.

I have installed Microsoft's "Ten Themes for Sharepoint" successfully, and have created one of my sharepoint sites based on the Contoso theme using Visual Studio 2008. I've changed the theme.css and the images and the result is great. All good!

The problem lies in the fact that I would like again use the Contoso theme to deploy to a different site on the same server (again modifying the CSS and images), but cannot work out for the life of me how to rename the previously modified Contoso theme. I'm sure it's very simple, but obviously so am I.

Any help or pointers would be much appreciated!!

Herman