Dataview Web Part Sorting

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Windows Services
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Windows 2003 R2 Any changes to WSS in the latest release of Windows 2003 R2? For some reason Microsoft makes mention of it on their page of changes to the OS. I think it is just marketing, but can't confirm. Thanks, Matt W. Eppley Institute http://www.eppley.org Tag: Dataview Web Part Sorting Tag: 39510
  - 2
    - User Names Displayed Twice in Reporting The user names on my WSS sites often display twice in user-level reporting statistics. The Active Directory for the users is called WSS, and when you view my stats you will often see something like john.lastname --stats-- and later on the page see WSS\john.lastname --stats-- Is anyone familiar with this issue and how to resolve it? Tag: Dataview Web Part Sorting Tag: 39509
  - 3
    - The search service is unavailable or access was denied. I have issue with Manage Profile Database page (XXXX Portal > Site Settings Manage Profile Database). The following error appears on this page. "The search service is unavailable or access was denied. Check that the search service is configured properly and running. " I have SharePoint Portal Server 2003 with 2 top level sites. The search seems to be working fine for top level sites, but not for the Portal and People. I know, I had some issues with resetting content password and if that is the case then I'm not sure what needs to be done to fix this issue. Also I could see following warning message in event viewer. Event Type: Warning Event Source: Microsoft SharePointPS Search Service Event Category: Gatherer Event ID: 3036 Date: 12/12/2005 Time: 9:30:00 AM User: N/A Computer: XXXX Description: The content source <sps://xxxxportal.com/site$$$people> cannot be accessed. Context: http://ncmcportal.com/ Application, Portal_Content Catalog Details: The specified address was excluded from the index. The site path rules may have to be modified to include this address. (0x80040d07) For more information visit http://www.microsoft.com/servers/redirect/contentredirect2.asp For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. -- Raj M. Tag: Dataview Web Part Sorting Tag: 39508
  - 4
    - Accessing a SQL Server View in an Data View I have STS 2003 with all the latest patches and service packs. I also have a SQL Server with all the latest patches and service packs. I have created a data view in the past which returned information from a specific SQL Server table. When I go to create a data view and I look at the list of Tables, views or stored procedures, I only see stored procedures and tables. All of the tables are listed as Type table or view. But I only see views there. I originally thought I had a permissions issue, so I tried it as sa and that didn't change anything either. Is there something on my SQL Server that I need to change? Or is there another way that I should be doing this in Front Page (or elsewhere)? TIA for any ideas. Tag: Dataview Web Part Sorting Tag: 39506
  - 5
    - Editing some code Hey All, I have a wss page that has some webparts on it. What I have done is pulled off the webparts in frontpage and pasted each one to its own seperate webpage. When you navigate to a specific link you get a webpage with a single webpart on it. Now what i would like to do is to take away the hyperlinking contained inside the webpart itself. This is simply a standard list with an accompanying webpart view. When you click on the link it takes you to the actual list item. The real goal here is to prevent end users from seeing the WSS back end. By this i mean i really dont want people to even know (besides from the webpart) that the page was created using WSS. I figured, before i started this project, that i would be able to track down the hyperlink fairly easily but upon closer inspection it seems that the links are built dynamically. If you can suggest another way i am open to any ideas you guys and gals have. -- Thanks, Jonathan Finkbiner Tag: Dataview Web Part Sorting Tag: 39505
  - 6
    - Installing Webpart using Wppackager fails I've updated our windows server 2003 last week with servicepack 1. But now i'm unable to install a our webparts. We've created installers with wppackager and all of our installers did work until the servicepack 1 upgrade. I've tried to install on a different windows server 2003 ( clean install + sp1 ) and they do work. So i'm guessing it's a configuration issue, modified by installing servicepack 1. I really don't have a clue what's wrong. Some help would really be appreciated. Thanx in advance! -- Tag: Dataview Web Part Sorting Tag: 39504
  - 7
    - Can not change the language in Calendars Can not change the language in Calendars. I want to change the language in calanders to my own language (Icelandic). How do I do that? Tag: Dataview Web Part Sorting Tag: 39494
  - 8
    - About Web part pages Hello, Because I want my own design and I don't want to mess up with WSS sites, I have taken the habit to create separate Web part pages to display information. My questions: - When I modify such Web part pages in FrontPage - for example to remove the top Navbar - does it unghost the site? - When I modify the page in SharePoint (using "Design this page"), it does not create a new version of the .aspx file. Does it mean that these changes are stored outside the page? Thanks! Tag: Dataview Web Part Sorting Tag: 39485
  - 9
    - Meeting Workspace Link Editing Simple request but probably impossible to solve. How do you edit the link between a meeting in a meeting workspace series and outlook calendar entry? More Detail: We have a meeting workspace that is a series of meetings going back over a year. It used basically as a minutes and decisions type of thing and works brilliantly. The MW was created in WSS but the series was created in Outlook and linked to the WSS. However in August we had to change the machine the WSS site was on (lease was up) and we migrated everything to the new server. It appeared to go very well and everything just carried on working. Unfortunately we changed the name of the server the site is on and this has lead to a big problem now. We needed to change some things with the series so the recurrence was changed slightly in outlook. Problem is the Link to the meeting workspace in outlook is burried somewhere and now none of the calendar entries link to their respective meetings in the series on WSS and any attempt to change anything is no longer reflected on the WSS as the changes are being sent to the old server name and location of the WSS and we are getting a bounce back saying it can't update the meeting workspace. So anyone know how I can fix this? I know someone is going to jump all over this and say it's an outlook issue but I checked the outlook groups on google first and they have woefully little on meeting workspaces and linking to them, other than how you do it. So any help you can give will be greatly appreciated. Tag: Dataview Web Part Sorting Tag: 39480
  - 10
    - Is it possible to create a list with the features below? I need to create a list of news items with the following features: =B7 The author has the option of EITHER typing in an article OR entering a URL to another document/outside link =B7 The list has several fields, but to simplify, it has an article title and a business segment field that the list must be GROUPED BY. =B7 When the end user opens his screen, he sees a list grouped by business segment of article titles. =B7 When he clicks on the article title he is taken either to a view of the article or to a document / outside link. This functionality is very similar to the news functionality; but this list must be grouped. I have come very close to achieving this by: =B7 Adding a calculated field called articlelink in addition to a document/externalLink =B7 The calculation for articlelink: =3DIF([Document/External Link]=3D"","http://portalName/C18/InsideBusiness/Document%20Library/newsdev= read4.aspx?View=3D%7bD5C43636%2d0FE4%2d4B75%2dA6F6%2d224AD894319F%7d&Filter= Field1=3DID&FilterValue1=3D"&ID,[Document/External Link]) The articletitle field is a dynamic hyperlink field containing the result of the calculation for artclelink. It takes you to a view of the list containing just the article that was clicked on. The view is designated by the ID of the list item. The articlelink field has the above calculation in it. It works perfectly until we add a new item and due to the timing of the ID field assignment, the link is not fully updated. I discovered that this is a known problem. I am wondering if anyone has discovered a workaround to this problem or if anyone has any thoughts on how to accomplish my list objective above? Tag: Dataview Web Part Sorting Tag: 39475
  - 11
    - secure site form SPS I want make a link om my sps site through a secure https site (our backoffice system) there is a different logon system. I think I must use single sign on (SSO), it was correctly installed. But after that, how to make a webpart or code which is asking for username and password and will store it to the SSO database? Who can help me? Tag: Dataview Web Part Sorting Tag: 39473
  - 12
    - Error in workflow creation with pre-relase of Microsot windows sharepoint services 3.0 Could I do a question about the beta of WSS 3.0? :) I'm trying the product for my thesis work, installed on my default localhost website (called also "pcmobile"). Seems that all works fine (besides, no installation error) but when i'm trying to follow the instruction published in chapter 4 of "Presentig windows worklow foundation, Beta Edition" by Sams (ISBN: 0-672-32848-8) i receive the following error: Error The file '/_layouts/CstWrkflIp.aspx' does not exist. Infact this file doesn't exist in my virtual website. I'm trying to create a new workflow in sharepoint in this way: 1)Start from the hompage of my website (something similar to http://pcmobile/default.aspx) 2)open "shared document" and then open "document library setting" 3)Open "Workflow setting" 4)Type something in the name of the workflow, leaving the default setting for the other values. 5)Receive the error :) (The file '/_layouts/CstWrkflIp.aspx' does not exist.) I have installed the beta 1.2 of windows workflow foundation and the extension or visual studio. No presentation and comunication foundation are installed on my pc. Thank you in advance Tag: Dataview Web Part Sorting Tag: 39470
  - 13
    - Edit Text in Issue List Hi, We have an issues list with a text box we use to enter free form text describing the issue. When a user comes along later to edit the issue, the description text field is blank. They can enter a new description and save. The audit list of the issue will have the old description, it's just not there when you edit it. Is this by design? or is this a problem? We'd like to be able to edit text without reentering it. Thanks. Tag: Dataview Web Part Sorting Tag: 39469
  - 14
    - Web Parts and Connection String I am working on a project using ASP.NET and Sharepoint services I hv developed web parts using user controls of vb.net. Basically a few forms saving and querying sqlserver 2000 db. I need the below 2 tags to be added into sharepoint web.config file. --------------------------------------------------------------------- <appSettings> <add key="ConnectionString" value="server= svr; User ID = nanda; Password = Nanda; database=rsdb" /> </appSettings> --------------------------------------------------------------------- AND --------------------------------------------------------------------- <identity impersonate="true" /> --------------------------------------------------------------------- How ever the web parts runs fine when i add the connection string in the code behind of the usercontrol page itself. But i need to centralize the connection string to sqlserver as i need to use the same in many web parts Pls let me know where to add the above 2 tags. ie...in which web.config file? Any help will be appreciated. Tag: Dataview Web Part Sorting Tag: 39468
  - 15
    - WSS and InfoPath Hello, Does anyone know if it is possible to publish a InfoPath form to 10 different SharePoint document (form) libraries (different sites), and then collect the input information to a different site? In this case there are 10 WSS sites (each for one store). A person at each store is responsible for data entry (purschase form). Is it possible to then collect the data from the 10 stores to site no. 11 ? Kind regards, Jeff Tag: Dataview Web Part Sorting Tag: 39464
  - 16
    - Limit Date value in Date Time Field ? I have a rather interesting problem. We have a Custom List in WSS used to record Timesheet data which uses several of the regular field types, including a "Date and Time" field to record the date of the Timesheet entry. We would like to restrict the user from entering a date that is greater that eight days ago (i.e. Today-8 Days). This is an attempt to prevent people from entering their weekly timesheet data more than a week after the day in question. Is there a way to do this in the default settings and if not is there a way to hack the code driving the list/form using VS ? Any pointers at all greatly received Thanks in advance for any advise, Al Tag: Dataview Web Part Sorting Tag: 39463
  - 17
    - Please suggest a suitable PC spec...thanks. Hi, I need to run SharePoint as a demo in environments where there is no internet and it must be portable. So I need to run it on a laptop - can people suggest a minimum spec for the laptop? thanks Tag: Dataview Web Part Sorting Tag: 39458
  - 18
    - WSS FAQ changes and additions - 5th - 11th Dec 2005 Note: All of the addresses of the KB / MS / Non-MS Articles below were valid at the time I added them to the WSS FAQ site and to this file. I can't guarantee that they still are. (This is also posted to my blog at (feed) http://mikeswss.blogg.de/rss.xml (site) http://mikeswss.blogg.de) where you'll also find earlier versions) (Items are added to the WSS FAQ throughout the week so you will find new items more quickly by checking at wss.collutions.com or www.wssfaq.com daily.) From 5th December - 11th December 2005 I. KB Articles New http://support.microsoft.com/default.aspx?scid=kb;en-us;910345 Error message when you try to save changes on the Connect to SharePoint Server Web page in Project Server 2003: "There are no site templates installed" 9th December 2005 http://support.microsoft.com/default.aspx?scid=kb;en-us;910354 The Last Modified Time value is updated when you discard the changes when you check in a document in Microsoft Office SharePoint Portal Server 2003 (ver 1.1) 7th December 2005 http://support.microsoft.com/default.aspx?scid=kb;en-us;910764 You cannot create a new area in SharePoint Portal Server 2003 after you install Windows SharePoint Services Service Pack 2 (SPS 2003 only of course) 7th December 2005 Modified http://support.microsoft.com/?kbid=834918 How to upgrade a Beta release of Windows SharePoint Services to the release-to-manufacturing version of Windows SharePoint Services (ver 3.0) 2nd December 2005 http://support.microsoft.com/?kbid=906336 Issues that are fixed in Windows SharePoint Services by Windows SharePoint Services Service Pack 2 (ver 4.0) 30th November 2005 II. MS Articles New http://office.microsoft.com/en-us/assistance/HA100806971033.aspx Service Pack 2 for Windows SharePoint Services and SharePoint Portal Server 2003 (what new things are supported as a result of intalling them) 12th December 2005 (date added) http://www.microsoft.com/office/sharepoint/howtobuy/default.mspx How to Buy (Licensing costs for SPS 2003) - added to the WSS FAQ to give an idea of the cost difference WSS/SPS 12th December 2005 (date added) Modified None III Non-MS Articles New http://www.intranetjournal.com/articles/200512/ij_12_05_05a.html Developing a Custom Web Part, Part 3 5th December 2005 http://msmvps.com/shane/archive/2005/11/29/77181.aspx Full Text Index WordPerfect Documents in SharePoint (Shane Young) 29th November 2005 Modified None IV. WSS FAQ additions http://www.asaris-matrix.com/mvp-walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=539 I.23.3 What is fixed in WSS Service Pack 2? (change of name and two additions to section III) http://www.asaris-matrix.com/mvp-walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=572 VII.05.80 WSS Products - Universal SharePoint Manager (iDevFactory) (seems to also be standalone WSS) http://www.asaris-matrix.com/mvp-walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=573 VII.05.81 WSS Products - Replicator (Syntergy) http://www.asaris-matrix.com/mvp-walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=574 VII.05.82 WSS Products - ADVIS Change My Password v2 (replaces the free/$49 v1) V. WSS FAQ amendments http://www.asaris-matrix.com/mvp-walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=495 I.26 Will WSS work with SQL Server 2005? http://www.asaris-matrix.com/mvp-walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=365 VII.05.29 WSS Products - ONTOLICA for SharePoint (Navigo Systems - Advanced Searching) ver 2.2. (May 2005) (Maybe only SPS 2003) (Note: *This* is the one that probably doesn't work with standalone WSS - see below VII.05.60) http://www.asaris-matrix.com/mvp-walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=524 VII.05.24 WSS Products - Backup Elite SC V 2.0 FR3 (Webfox Inc.) http://www.asaris-matrix.com/mvp-walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=497 VII.05.60 WSS Products - Coveo Enterprise Search for SharePoint SPS and WSS (Note: My mistake it *does* work with standalone WSS) http://www.asaris-matrix.com/mvp-walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=305 VII.09.02 Free (but) WSS Web Parts - ADVIS Change My Password **V2 costs real money** (need site registration) (copyright notice on free version; otherwise ?49) If anyone is lucky enough to have saved a copy of v1 then this item still applies. They've changed the rules for v2 completely. Tag: Dataview Web Part Sorting Tag: 39454
  - 19
    - unusual question about webparts where does microsoft define the default webpart's menu items(ie.minimize,close,modify shared webpart,export and help)?I want to access to the default webpart menu items and translate them to my language. where are they comming from? are they in microsoft.sharepoint.dll or any other dll?another question is about the "up to parent site " tg that i want to change the "up to "expression...any clue or help would be highly appreciated Thanks Tag: Dataview Web Part Sorting Tag: 39453
  - 20
    - Teaching materials (MBA) hello, I teach in MIS in MBA programs, and I'd like to use SharePoint as support for Intranet and collaborative demos. Are there teaching supports available? How could my students work on a WSS/SPS site (for ~2 weeks)? Thanks for your help! Tag: Dataview Web Part Sorting Tag: 39451
  - 21
    - Search XML content Is there a way to search content within a XML file stored in a WSS Form library? Tag: Dataview Web Part Sorting Tag: 39448
  - 22
    - Install WSS, System Error 1057 I've really got a mess here. This may not be a SharePoint install problem, rather it might be Windows domain and firewall issues. I have a 2003 domain controller which also hosts SQL Server 2000 SP4. In the same subnet is another 2003 server that hosts WSS (call it Server1). This was installed with remotesql=yes, I also setup accounts for application pools, granted access in SQL Server. Great, the whole installation works as it should. Now I have to setup another WSS server (call it Server2) in a different subnet. This subnet is our DMZ and the port restrictions have been pretty severe. Sysadmin has opened all the ports we think we need for Active Directory and other Windows domain participation. Server2 used to have WSS with WMSDE (SQL desktop edition). Rather than screw around with modifying config, I removed WSS and WMSDE, then reinstalled WSS with remotesql=yes. Selected "Server Farm" option. Problem #1: it takes literally 3 to 5 minutes for the WSS Admin page to come up. Every time I go to the page "localhost:22234", it takes minutes. I KNOW this is wrong. Then when I try to setup Configurable admin application pool I get Error 1057 if I use a local account with Administrators privileges (and also IIS_WPG and the other, or whatver those are). If instead I use a domain account "MY_DOMAIN\whoever", I get a "cannot authenticate" or somethiing like that - I'm not convinced that our domain participation is fully functional, but does it matter at this stage? Problem #2: On Server1 (the good installtion) I see that SPTimer runs as "MY_DOMAIN\someone". On Server2 it used something else. So I tried to change SPTimer to same domain account, but get the "cannot authenticate" message. So then I tried a local account and now get 1057. So what can I deduce from all this? 1. Domain participation of Server2 is suspect. 2. It takes minutes to load localhost SharePoint admin page, does this have anything to do with domain participation? I can't see how. I'm lost, please help! -- ----- Glenn Nelson in Santa Cruz Tag: Dataview Web Part Sorting Tag: 39447
  - 23
    - Document Workspaces hi, We have the windows sharepoint version when purchased with microsoft small business server 2003. We have tried to use the document workspace functionalities so that a few users can work on a spreadsheet simultaneously. Howver, it seems that only one user can access a document at any one time, when any user tries to edit the file, it will say, the file is locked, can either read only or choose to notify the person who is currently using it. Any suggestions? Any assistance will be greatly appreciated! thanks Alan Tag: Dataview Web Part Sorting Tag: 39432
  - 24
    - sign up i want to develop a sharepoint based website for shopping i want to have the possibility of signing up for visitors of my site i want to have a section in my site where the visitors be able to fill out a form and becomming a user of my site and then having some access rights to some resources of the site. how can i do this? should every new user be registered in Active Directory? is there any other authentication solution for these users? thanks Tag: Dataview Web Part Sorting Tag: 39431
  - 25
    - Persist user information using only out-of-the-box web parts I am looking for a simple way to persistent a couple of pieces of user information (LoginID, ProductID, max. 4-5 pieces of information) on a WSS site. The end result is to produce a series of hyperlinks to a old backend database like this: Show All My Problems - http://server/query.cfm?loginID=[loginID] Show All My Current Project Problems - http://server/query.cfm?loginID=[loginID]&productID=[ProductID]. Using the standard XML web part, I tried to use a simple XML file, like this <UserData> <LoginID>57</LoginID> <ProductID>104</ProductID> </UserData> Then use an XSL to render the dynamic links into HTML like this: Show All My Problems - http://server/query.cfm?loginID=57. Show All My Current Project Problems - http://server/query.cfm?loginID=57&productID=104. This works fine for a single person. I wanted to have each user only change the XML portion of the web part, customize the userinformation to him/her. Thus, he would do this once, and we would persist the user's data in the XML portion of the web part. My limitations that I am working with: Current web pages, html pages, aspx etc and standard out of the box Web parts only. (basically anything I can do with the current SP interface) Can't create a custom web part (real easy to retrieve the user information in the tool pane). Can't change server configuration to enable serverState (don't have access to the server) Links generated will be over 260 characters, so I can't use the links web part. User specific data is not sensitive data, others could see this information if they had to (thinking of a SP List) Does anyone know of an easy way to embed user information into a team site somewhere? Thanks in advance. Tom Tag: Dataview Web Part Sorting Tag: 39426
- Next
  - 1
    - Customizing home page layout I am the administrator of a Sharepoint team website, thus I have the administrator role assigned to myself. When I try to go into customizing the home page layout and move some columns around I get this error (which is very vague, but I believe it's got something to do with security). Error Unable to change homepage layout An error occurred while trying to save the changes to the homepage. Please try again. If this problem persists, please contact your administrator. Troubleshoot issues with Microsoft SharePoint. If I go to the server itself and log in as Administrator I can successfully change the layout. What can I do to make it possible to be able to change the web page layout myself? I have subwebs for the different departments, and the department heads are all administrator to their own pages - they need to be able to do this as well. Tag: Dataview Web Part Sorting Tag: 39421
  - 2
    - 'New Document' button not working for some users We use Office 2000 in our company. I can use the "New Document" button in the document library and it opens Word and is fine. A co-worker, however gets this error: "'New Document' requires a Windows SharePoint Services-compatible application and Microsoft Internet Explorer 5.0 or greater. To add a document to this library, click the 'Upload Document' button.". We are both using the same version of Word (v 2002) and IE 6. Are there any settings in IE that might cause this error? Thanks, JM Tag: Dataview Web Part Sorting Tag: 39419
  - 3
    - The page cannot be found page I've installed sharepoint services, been experiencing with it, been impressed with it. It has been working pretty good except for 2 errors I get and cannot find the cause. 1- When trying to upload a document, "the page cannot be found" page appears at the end. The document gets successfully uploaded. When I refresh the page i can see it has been added. 2- When trying to design a page, add web parts ... the same message appears. How can I get information to diagnose the source of these problems ? Any IIS logs, event logs, logs in the database ... ? Should I simply re-install ? Thank u for ur help ! Tag: Dataview Web Part Sorting Tag: 39415
  - 4
    - Authentication from different trusted domain I have a WSS server in an external AD domain. I want to enable my internal AD Domain users to access sharepoint sites on the WSS server. I've set up the trust relationship between the two forests, and all is well. I have been able to assign a user from my internal domain to the user list for a Sharepoint site, and the user is able to log in to the site, but have not been able to assign a security group from my internal domain to the Sharepoint site. I can assign the group, but users in that group can not log in to the site. Is this working as designed? If I'm assigning rights to a sharepoint site from a different AD Domain, does it have to be at the user level, not at the group level? Tag: Dataview Web Part Sorting Tag: 39407
  - 5
    - File MetaData and Views Hello all, I want to organise our company's documents using metadata. My goals are: 1. Upload - Create documents into one or more Document Libraries (I don't mean multiple copies, just making clear that what follows will have to apply to more than one library). 2. Assign metadata to these documents, most of the time using lookup lists. Good examples are `Customer` metadata (i.e. a list of our customers and each document would be related to one - or more - customer) and document type (i.e. a document can be of type `Order`, while this could be a Word document, PDF etc). 3. Different libraries will have different `mandatory` metadata, while all libraries will share the same lookup lists (i.e. the `orders` library will require the `customer` metadata but `presentations` library will not require `customer` but `product` metadata and so on) 4. I want the users to be able to view those documents through (pre-designed) views, depending on the metadata, no matter the location (library) of the document. Now, I managed to get all 1,2 and 3 in a document library but I can't get to 4. There is now way I can see in one view documents from more than one library. Is this thing possible in STS? There is an obvious but un-acceptable solution: Put everything in one library. But there are several issues with this approach: a. Permissions. If I use one library, I have one permissions' set for all users and all documents. b. Efficiency. As I know, there is a limit on how many documents and folders (if I use folders, but I'd prefer not to) a library can hold. c. Mandatory fields. I will have to either require all metadata or leave all metadata optional. Any advice on how to accomplish 4 or how to address issues a,b,c will be most helpfull... Thanks in advance, -- Anastasios Papadopoulos a.k.a. Cascader, Athens - Greece Tag: Dataview Web Part Sorting Tag: 39404
  - 6
    - Lookup colum has duplicates Does anyone know how I could filter the duplicates in a lookup colunm. I am looking up the company name from a contacts webpart but it shows every entry for the comapny's name. I only want it to show one occurance of the company's name. Tag: Dataview Web Part Sorting Tag: 39399
  - 7
    - Wow how do you do that? !! Hi, What you read below is really trying to ask YOU just 1 question which is: What "stuff" or "things" have you seen (link please) or set-up which people have seen and gone Wow? I am looking to make some client facing sites and I'm sure we all know how much people like little gimmicks and gadgets - sure when you understand what is going on behind the scenes these enhancements become less impressive - but most users do not know what is going on behind the scenes and they are the ones who will be using these sites i have to set-up Essentially I have a bit of time on my hands and am looking on the net for easy to do (i'm no coder) impressive WSS site enhancements - you know the kind of things which might spin, glisten and generally catch the eye - stuff that is fun but also useful - cool stuff. static WSS sites are ok but there must be one or 2 widgets out there which really take a WSS site to a different level...i am not referring to linking to dynamic data e.g. data-driven web sites but just something or some idea - maybe a way of using linked web-parts for producing value not usually seen - anything at really but especially stuff that some of your users may have looked at and gone "wow that's cool - how did you do that?!!" I look forward to reading your collective replies over the next few days... Best Wishes, Steve Tag: Dataview Web Part Sorting Tag: 39397
  - 8
    - Wow how do you do that? !! Hi, What you read below is really trying to ask YOU just 1 question which is: What "stuff" or "things" have you seen (link please) or set-up which people have seen and gone Wow? I am looking to make some client facing sites and I'm sure we all know how much people like little gimmicks and gadgets - sure when you understand what is going on behind the scenes these enhancements become less impressive - but most users do not know what is going on behind the scenes and they are the ones who will be using these sites i have to set-up Essentially I have a bit of time on my hands and am looking on the net for easy to do (i'm no coder) impressive WSS site enhancements - you know the kind of things which might spin, glisten and generally catch the eye - stuff that is fun but also useful - cool stuff. static WSS sites are ok but there must be one or 2 widgets out there which really take a WSS site to a different level...i am not referring to linking to dynamic data e.g. data-driven web sites but just something or some idea - maybe a way of using linked web-parts for producing value not usually seen - anything at really but especially stuff that some of your users may have looked at and gone "wow that's cool - how did you do that?!!" I look forward to reading your collective replies over the next few days... Best Wishes, Steve Tag: Dataview Web Part Sorting Tag: 39396
  - 9
    - Weird Web Folder behavior - Cannot Copy <filename>: The File Exists Hi I'm having a strange problem with WSS Web Folders. Some of my users have problems copying documents to and from Web Folders (WebFldr.aspx view) - "Explorer View" . Whenever they try to copy, either using Ctrl+c and Ctrl+V, or use the menu "Copy this file" they consistently get the error: Cannot copy <filename>: The file exists. We're using kerberos authentication. When I check the event log it doesn't display any problems, and all authentications are kerberos based. What I find strange is the fact that it works for some users and not for others. A hint: It seems that the users with problems have upgraded from Office XP to 2003 - but even that is not 100% consistent. I tried to repair Office - didn't help. Help very much appreciated Morten Tag: Dataview Web Part Sorting Tag: 39384
  - 10
    - Disaster Recovery (SQL Server May Not Be Running) This isn't so much a question as a point I wanted to make as it helped us greatly. It's mostly to say thanks to Dustin Miller as I know he reads these and one of his posts was a HUGE help in us remedying the problem. We recenetly ran into a little problem during a system restore which was giving an error saying "SQL Server may not be running". In case any of you have this problem I figured I'd quickly share our experience with it: What Triggers It: When creating a site that has a list, and a post to that list. For example if you tried to create a Team Site - this site has an announcements list and a post created in that list. This triggers the problem - the "posting part". The reason: The reason is due to the accounts trying to create it. The 'underlying reason' is due to the SID (Security ID) getting mixxed up and not matching up. The solution: Dustin Miller had a script posted that would go down through and get the proper SID's for you to match up again. It worked wonders and we we able to get to the bottom of the problem using this method. So again, this is more to say thanks to Dustin. (don't know the URL of the script offhand but I'm sure he could shed some light on it) Tag: Dataview Web Part Sorting Tag: 39378
  - 11
    - Help on SharePoint Certifications Are 70-132 / 70-133 beta certifications ? Can any one help me with the course contents ? Thanks, Kailas Tag: Dataview Web Part Sorting Tag: 39376
  - 12
    - Calendar View Hi, I once posted a message regarding this, but I still could not do anything about this, so here I go again. I need an alternative to the standard Microsoft calendar view, wich would allow me to size the control as needed. Thanks in advance Eduardo Hill Tag: Dataview Web Part Sorting Tag: 39374
  - 13
    - Site administrator receiving access denied. Hello, I am a recent user of Sharepoint and had a question: I have taken interest in SharePoint Portal Server 2003 that was installed and running fine. When I go to the toplevel domain (say: http://mysite.com) >> Site Settings >> Manage users and add a domain user (say: mydomain\mynewuser) as an administrator (site administrator), the user is added as expected. After that, if the local machine's administrator created a site under toplevel (say: http://mysite.com/sites/colleges), site administrator (mydomain\mynewuser) is not able to access/administer this new site (college). Why? Is this by design? Should mynewuser be added as an administrator on (college) site exclusively? Will "college" site not inherit administrative rights of site user "mynewuser"? Toplevel (mynewuser is administrator; can create a new site) | | college (created by local computer administrator; mynewuser has no privileges here. why?) Thank you very much. Sincerely, Chirag Shukla Tag: Dataview Web Part Sorting Tag: 39373
  - 14
    - Business Intelligence for SharePoint web hosting Howdy, I've been tasked with creating reports for a hosting environment of several thousand sites with Windows SharePoint Services on Windows Server 2003 and MS-SQL 2000. I don't think I'll need to get too far off the beaten path with this--looking for stuff like sites near or at storage quota, which files are taking the most space (by extension or file type (e.g. video)), are any sites or subsites dark (no traffic for X months), etc. The SQL Server Report Pack for SharePoint Portal Server (http://office.microsoft.com/en-us/assistance/HA012305181033.aspx) seems to go a long way toward my end except for the Portal Server requirement. Can I set up a 'reporting server' with SPS 2003 and SQL 2000 Reporting Services and run reports off the data from the Data Extraction Program? Or would I have to have SPS on the servers hosting the WSS sites? If SPS is a requirement on the hosting servers, is there something analogous to the Report Pack for WSS environments? (I think we do have some SharePoint Portal Server installations around, but licensing costs make it desirous to keep the main hosting strictly Windows SharePoint Services.) Also my bosses have been mentioning Business Intelligence and specifically MS's Business Scorecard Manager (http://office.microsoft.com/en-us/FX012225041033.aspx). Most of what I've read on BI concerns areas such as sales force automation and supply chain management. Are there any white papers or examples of applying BI or concepts such as the data warehouse matrix (http://www.intelligententerprise.com/db_area/archives/1999/990712/webhouse.jhtml) to web hosting? All our customers are internal, so we're not (currently) looking into areas such as sales and billing. We just want better reports on what's going on with the hosting environment. Any information on reporting or business intelligence for web hosting would be great. Anything specific to SharePoint hosting (with or without SQL Reporting Services) would be greater. TIA =) Sean G Tag: Dataview Web Part Sorting Tag: 39366
  - 15
    - onet.xml description I am working on a document. In the glossary I want to define the ONET.XML file. I am struggling with that. I have modified it a few times, but I really don't know how to define it or exactly what its function is. Can anyone help with a link or explanation? Tag: Dataview Web Part Sorting Tag: 39360
  - 16
    - Unable to download a large file. I was able to upload a this file test1.mpg files size 181MB, but I'm not able to download it. If I just select the file the video plays. Any idea's as to what could be causing this problem. Emmett Tag: Dataview Web Part Sorting Tag: 39358
  - 17
    - This Web Part Page has been modified since you opened it Greetings, I am currently getting this error: "You receive a "This Web Part Page has been modified since you opened it" error message when you click a command on the Modify Shared Page menu after you upgrade your server farm to SharePoint Portal Server 2003 Service Pack 1" according to the KB article (892348) I need to adjust the network load balancing on the server. Currently the server my WSS sites are on is not load balanced. But the network load balancing component is installed, but not enabled on the servers NIC. Do I need to enable and and change the setting, or just uninstall it? This is a production server so I can just go and test it myself =) Thanks, Patrick Tag: Dataview Web Part Sorting Tag: 39350
  - 18
    - How to make custom frontpage theme available in Sharepoint? I've customized a default theme that was packaged with Frontpage 2003, and I've been using that theme on a Sharepoint team site. We are using Sharepoint Portal Server 2003. I would like to make this theme publicly available for all portal users. Is there a straightforward way to do this? Tag: Dataview Web Part Sorting Tag: 39349
  - 19
    - Saving a list as a template with content I am attempting to save a created list as a template - including content - for use on various sites. I keep getting the following error message: The specified gallery is not available for this Web site collection. How can I fix this issue? Tag: Dataview Web Part Sorting Tag: 39347
  - 20
    - capture a date field and keep it Hi, I want to create a calculated field that captures a date and keeps it. For example, I will have two fields in a sharepoint list, one called 'Commit Date', the other 'Original Commit Date'. The user will fill in Commit Date with a date, Original Commit Date will capture it and not change, even if the user changes Commit Date. It was easy to capture the Commit Date, all I did was set Original Commit Date to a calculated field =[Commit Date]. But every time the user changes Commit Date, Original commit Date changes too. Tag: Dataview Web Part Sorting Tag: 39346
  - 21
    - Disabling anonymous access I have Anonymous access disabled on my SharePoint Portal Server (running v2, sp1), but I am seeing in the Security log that SharePoint is attempting to log in every so often (about 5-10 times every 10 minutes). I think this may be partially related to the search crawl, that is why I have posted to both the WSS and SPS newsgroups. These are the errors I am getting: Event Type: Failure Audit Event Source: Security Event Category: Logon/Logoff Event ID: 529 Date: 12/8/2005 Time: 12:00:00 PM User: NT AUTHORITY\SYSTEM Computer: SHAREPOINT Description: Logon Failure: Reason: Unknown user name or bad password (Sometimes, this will say "Account locked out") User Name: Guest Domain: SHAREPOINT Logon Type: 8 Logon Process: Advapi Authentication Package: Negotiate Workstation Name: SHAREPOINT Caller User Name: spsadmin Caller Domain: IDA Caller Logon ID: (0x0,0x17D7D) Caller Process ID: 6536 Transited Services: - Source Network Address: - Source Port: - For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Event Type: Failure Audit Event Source: Security Event Category: Account Logon Event ID: 680 Date: 12/8/2005 Time: 12:00:00 PM User: NT AUTHORITY\SYSTEM Computer: SHAREPOINT Description: Logon attempt by: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0 Logon account: Guest Source Workstation: SHAREPOINT Error Code: 0xC000006A For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Tag: Dataview Web Part Sorting Tag: 39341
  - 22
    - Multiple Event (Calendar) Web Parts I am trying to add multiple event (calendar) webparts to a team site and I need them all to be different. (For example, one for sceduling the Aspen Staffing Room, one for scheduling the Cottonwood Staffing Room, etc) However, when I add multiple events webparts to the first page of the site and change something in one, the change is reflected on every one. Is there a way to get around this? -- You want me to do what?!?! Tag: Dataview Web Part Sorting Tag: 39337
  - 23
    - Customized Discussion List Hi, I need to have a discussion board in my portal, but the portal is being used on the "internet". Internet users have the option of registering with the portal (in which case their details are stored in a separate SQL Server database). There are some custom webparts in the portal that are accessible only if the user is registered in this second database. How do i get the Sharepoint discussion board working with my set of users. I had one approach in mind but wasn't sure how to go about it. 1) I can make the discussion board anonymous technically. 2) Then i can treat my posted by "username" as just a field in the discussion list "post". For this i will have to create a webpart that inherits from "List" and uses the Discussion Board template. 3) In this new web part when a "save" happens, i will have to put in the "username" from a session into the field. This session variable would have been created when the user logged in using my login page which links to MY database. Has anyone done anything similar? How would such a solution be implemented? Tag: Dataview Web Part Sorting Tag: 39336
  - 24
    - Anybody know training in Northern Virginia? Everything I am seeing is a flight away from me, particularly in Vegas. Any recommendations for hands-on SP training in the Sterling, Chantilly, Reston, Fairfax, Virginia areas? TIA - Brian.ONeil@MCDean.com Tag: Dataview Web Part Sorting Tag: 39323
  - 25
    - Customised List WebPart ? Hi, I need to have a discussion board in my portal, but the portal is being used on the "internet". Internet users have the option of registering with the portal (in which case their details are stored in a separate SQL Server database). There are some custom webparts in the portal that are accessible only if the user is registered in this second database. How do i get the Sharepoint discussion board working with my set of users. I had one approach in mind but wasn't sure how to go about it. 1) I can make the discussion board anonymous technically. 2) Then i can treat my posted by "username" as just a field in the discussion list "post". For this i will have to create a webpart that inherits from "List" and uses the Discussion Board template. 3) In this new web part when a "save" happens, i will have to put in the "username" from a session into the field. This session variable would have been created when the user logged in using my login page which links to MY database. Has anyone done anything similar? How would such a solution be implemented? Tag: Dataview Web Part Sorting Tag: 39317

Hello All,

I created a data view web part from a View setup in my SQL database.
When I turn on Sorting in the dataview web part one of the columns is
missing from the sort options drop down.

Is this a bug? Can I manually add this option to the drop down list?

Has anyone else encountered this type of issue?

Thanks,
Jeff

Top

Re: Dataview Web Part Sorting by Engelbert

Engelbert
Mon Dec 12 23:27:46 CST 2005

I doubt if it's a bug. There's a reason for this field not being included in
the (sort list) options but without actually seeing both your database and
your web part there's no way to work out what it could be.

Look again but this time based on the fact that it's not a bug and there is
an explanation...

Engelbert

"Jarf" <jeff.paine@gmail.com> wrote in message
news:1134402501.367499.92910@o13g2000cwo.googlegroups.com...
> Hello All,
>
> I created a data view web part from a View setup in my SQL database.
> When I turn on Sorting in the dataview web part one of the columns is
> missing from the sort options drop down.
>
> Is this a bug? Can I manually add this option to the drop down list?
>
> Has anyone else encountered this type of issue?
>
> Thanks,
> Jeff
>

Top