WSS v2 SP2: Custom formula column for file extension

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
    - Conditional formatting of SQL data in sharepoint I am creating a sharepoint site using Microsoft Sharepoint designer 2007 beta with SQL data in it. I need to put conditional formatting on the table so when the system time is greater than a record's time (a string field which has time inputs in the format of 00:00), the record will turn red. So I need to fill in an advanced filter in sharepoint that will get the system time in the format of 00:00 and return a true result if the system time is greater than the time field. thanks Richard Ashdown Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49272
  - 2
    - FrontPage and soap:Server Exception of type Microsoft.SharePoint.SoapServer.SoapServerException was thrown Hi, I didn't find a solution to this problem when searching google groups, so I'll post my solution. When editing the default.aspx home page through Front Page 2003 I received the error- soap:Server Exception of type Microsoft.SharePoint.SoapServer.SoapServerException was thrown. A Web Part or Web Form Control on this Web Part Page cannot be displayed or imported because it is not registered as safe on this site. You may not be able to open this page in an HTML editor that is compatible with Microsoft Windows SharePoint Services, such as Microsoft Office FrontPage. To fix this page, contact the site administrator to have the Web Part or Web Form Control configured as safe. You can also remove the Web Part or Web Form Control from the page by using the Web Parts Maintenance Page. If you have the necessary permissions, you can use this page to disable Web Parts temporarily or remove personal settings. For more information, contact your site administrator. When browsing to the page through IE, all was fine. This is a development server, so natually developers will play around and things start to fall apart. What I did was 1. Remove webpart that I thought was causing problem through stsadm -o deletewppacks xxxxxx.cab 2. In the web page using IE, Edit page-->Modify Shared Web Parts-->Browse web parts 3. In Web Part Page Gallery (gallery containing all closed web parts for page), there existed several webparts with ERROR! as their name. 4. Drag ERROR! web part on page and then delete. 5. Remove all ERROR! web parts. Once this is done, I was able to edit the default.aspx home page with no problems. Unfortunately FrontPage 2003 can't handle pages with error web parts that well. Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49271
  - 3
    - Sharing outlook Calendar without exchange Hi All, Hope you can help me. Is it possible to use Sharepoint Services to share outlook calendars even if the users aren't using exchange? Is this easy to setup? Many thanks Adam Smith Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49270
  - 4
    - How to replicate site content on another SPS server? Hi, I need to move all my portal and site content as is from my development SPS 2003 server to a staging server. How can i achive this? I have to secure all the document and list info without loosing a single item. Thanks, Jeev Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49254
  - 5
    - Sharepoint and InfoPath Hello, SBS 2003 with Windows SharePoint and Infopath on clients. I installed successfully the employee timesheet and scheduling package. A few questions: 1) I do I set permissions so employees can only view their timecards or other forms? 2) How do I make timecards submittable to me? Thank, Tom Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49253
  - 6
    - Adminstrator Restrictions 2 Administrators. 1 creates his own personal folder, removing everyone else from access. Is there no way to prevent the other Admin from seeing the folder contents? Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49250
  - 7
    - Document page doesn't load completely When I click on a link to view a set of documents, the page loads as far as the PWA menu bar, but then stops. This only happens when I'm viewing the site from the extranet; internally, the links work fine. I'm running Project 2003 Server and Sharepoint Services 2.0 sp2. Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49248
  - 8
    - Sharepoint Search feild? Hello, I've recently just installed Sharepoint and thanks to some previous help here, things are moving along pretty well. I've seen some screen shots of default WSS sites with a search field. I don't have that. Is this something that needs to be added? I don't see it in Web Parts?? Does it indeed search the entire WSS database as I'm guessing? Thanks for any direction. -- Steve Project-43 http://soundclick.com/project43 http://www.project-43.com/ "If you choose not to decide, you still have made a choice." Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49243
  - 9
    - Sharepoint Designer 2007 i have downloaded the beta for sharepoint designer 2007 on a client pc (not the server hosting the sharepoint site). is it possible to get it integrated with the sharepoint site? how do i do this? i believe there was a way to integrate frontpage with sharepoint, but i never used frontpage.... i am evaluating sharepoint designer now... my only purpose would be to use it for sharepoint... so that's why i was wondering if i need to integrate it or link it to my sharepoint site somehow. thanks Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49240
  - 10
    - alerts for expiration date In my company we have this requirement: we want to notify by email of the expiration of the date written in a column of a custom list of sharepoint. Is there a simple way to implement it in sharepoint? Thank you Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49239
  - 11
    - Companyweb prompting for password Hi all- I had reload and reinstall Sharepoint on a SBS 2003 premium server and now it is prompting some users for ausername and password. Does not seem to be prompting for administrators...where would I fix this? Thanks!!! Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49237
  - 12
    - Sharepoint V3 Product Description Where can I find a comprehensive description of the new features that will be available in the new version of Sharepoint including the Content Management Server integration with this new release? We use WSS and SPS 2003 and my staff wants specifics on the new features and functions. Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49236
  - 13
    - WSSv3 Search Stopped Updating Index We've been using WSSv3 for a couple weeks, and just last week, the Search service stopped updating the index -- I can search and find stuff indexed previously, but at a certain point, the index is no longer getting updated (for any site). I've restarted the WSSv3 Search service, made sure there were no apparent problems with the Search database, and even restarted the WSSv3 server. My WSSv3 server is connecting to a separate box running SQL Server 2000. Through Central Administration, I've confirmed the Search service is configured correctly, and that the content database is correctly configured to use the search service on the WSSv3 server. I'm seeing the following two event log entries occasionally: Event Type: Error Event Source: Windows SharePoint Services 3 Search Event Category: Search service Event ID: 10038 Date: 6/12/2006 Time: 7:04:07 AM User: N/A Computer: SPTESTFRONT Description: Query machine '.' has been taken out of rotation due to this error: The system cannot find the file specified. 0x80070002. It will be retried in 15 seconds. Component: SPTESTFRONT Event Type: Error Event Source: Windows SharePoint Services 3 Search Event Category: Search service Event ID: 10040 Date: 6/12/2006 Time: 7:04:07 AM User: N/A Computer: SPTESTFRONT Description: The last query machine has been taken out of rotation. Check previous event logs to determine cause. Propagation may be necessary. Component: SPTESTFRONT Anyone have any ideas? Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49235
  - 14
    - SharePoint Portal Search I would like to know if it would be possible to use SharePoint Portal Services to index and search for folders across different non-SharePoint Servers. We have a number of File Servers distributed in remote sites and would like to have a way of indexing and easily searching for folders/documents and we are hoping that SharePoint Portal can do that. Thanks in advance... Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49232
  - 15
    - Replacing the "All Items" view from a List or Library. I saw some similar questions but not exactly what I need. The default "All Items" view is a Standard mode view, so to display it in Datasheet mode you have to select "Edit in Datasheet Mode" each time you go in and out of the "All Items" view. Since you can not change the "All Items" view to datasheet mode, can I create a new "All Documents" view in datasheet view and delete the All Items view without crashing the list? I ask because a few times in the past, I have deleted "default" items like "reader" and replaced them with another only to crash the list, library, or the whole installation. So I am very careful now before just deleting any default item. Thanks Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49231
  - 16
    - does content web editor support INCUDES hi Guys I was trying to use the source editor portion of the CWE to insert an html page or file. is this possible with the content web editor web part, also i do know about the page viewer but unfortunately it doesnt do what is needed. Please help me out on this one thanks in advance.. Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49230
  - 17
    - Adding Active Directroy properties to a contact list Hi: I have a contact list that includes by default some properties of the Active Directory, and I want to add another one. Can you tell me how to do it? Regards Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49228
  - 18
    - Custom groups cannot view webparts Hello: Can anybody tell me why if I create a Custom group with the same permissions of a default group, the members of it cannot view webparts? Regards Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49216
  - 19
    - Custom groups cannot view webparts Hi: Can anybody tell me why if I create a custom gruop with the same permission of a Default group, the members of it cannot view webparts? Regards Rak Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49215
  - 20
    - Windows Sharepoint Hi I have a problem with my Sharepoint portal, the problem is that when people not on our site but other places. EIther they have their own domain or are just in a workgroup. They login to the portal , no problem but when they try to open up a document on a document library they are asked to login again if they do the document opens up but I want to get rid of this second login. I have no idea, I've already looked at the IIS settings and it is set to Windows Authentication only nothing else. Anyone have any idea? Thanks. Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49212
  - 21
    - Sharepoint v3 Compatible Applications Out of the box you cannot use the "New" button in a sharepoint document library that has a template for an application that is not a Microsoft Office app. I need to create a document library for AutoCAD drawings with a template that includes the border. Is there any way to get this done? If not Sharepoint is almost useless for me, we do this in Lotus Domino all the time. Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49209
  - 22
    - Permissions Question Is it possible to configure SharePoint Services so that the user is not prompted to log in? I am looking to use this to update our organization's intranet and would like to know if I can set SharePoint to allow access based on the credentials of the user that is logged into the machine rather than prompting them to enter a username and password. Thanks in advance, Chanda Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49208
  - 23
    - Picture Library issues Hi, I have two questions on Picture library and I would appreciate if anybody can help me with these two questions. 1) How can I print individual pictures with their metadata only? (I do not want to print screen) 2) How can remove all the check marks on my photos? Regards, Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49207
  - 24
    - Document Template in Custom Doc Lib I have a strange behavior that I can't seem to pinpoint what is going on. I have created my own custom site defintion with 2 new additional document libraries. For each doc library, they have their own respective document templates. One Doc Library called "Design", the document templates are template1.dgn and template2.dgn. The other doc library called "Drawing", the document templates are template1.dwt and template2.dwt. When I go to the explorer view of the Design doc lib, and inspect the forms folder for the the file sizes of the two document templates are 20&30KB and when I drag and drop them to my desktop they are the 20&30KB respectively. However, when I go to the explorer view of the Drawing doc lib, and inspect the forms folder for the the file sizes of the two document templates. They are 30Kb and 25KB respectively. This is correct as well. But, when I drag and drop them to my desktop, they become 1KB each. Why is the file size changing. This is causing errors whereby I am trying to create a new document with the document template from sharepoint. Any ideas? Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49205
  - 25
    - Problem with _layout links Hello, We're running a Sharepoint Portal Server SP2 and encounter a strange problem ... About once a week all links on the portal that have _layout in them (all links pointing to 60 hive) stop working and give a 404 error. Performing an iisreset doesn't solve the problem, rebooting the machine does. Anyone an idea what could be the cause of this behaviour ? I don't know where to start looking. Could it have anything to do with regional settings ? Some admin pages keep switching from dutch to english sometimes too ... Fred Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49202
- Next
  - 1
    - Users with unwanted permissions Hello, I'm running Sharepoint Services 2.0. Just deployed it here at work for about 80 users. All is going pretty well so far. However, I have two users who are set to 'reader' only, but when visiting the Sharepoint site, they have Admin permissions. They get the 'modify page' links and other functionality they should not have. I have verified they are indeed in the 'reader' group only. Is there some other setting that could be overriding those permissions? Thanks for any help, -- Steve Project-43 http://soundclick.com/project43 http://www.project-43.com/ "If you choose not to decide, you still have made a choice." Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49187
  - 2
    - Import web page Hello all, I'm new to Sharepoint Services. Just installed about a week a go and I'm in the middle configuring it for an Intranet here at work. We'll have about 80 users visiting the site. The installation went fine and seems to be operating as designed. I'm wondering if there is a way to 'import' an existing HTML page so that when a link is clicked, the page displays in the existing site instead of opening up a new window and showing only that page and it's layout. I have some very plan information pages I would like to load in the middle web part when a link is clicked. Additionally, I've done all my editing either in the Sharepoint interface or using Notepad. What's the best XML editor to use for Sharepoint pages? I'd prefer to stay away from FP if that is feasible. I do have a lot of experience with HTML, CSS etc. Sharepoint and XML are new to me. Thanks for any assistance you can offer. -- Steve Project-43 http://soundclick.com/project43 http://www.project-43.com/ "If you choose not to decide, you still have made a choice." Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49186
  - 3
    - Problems with Swedish character in filename Hi Have problems with one customer that have problems with swedish characters (Ã¥Ã¤Ã¶) in filename. They cannot upload document that have filenames with characters (Ã¥Ã¶Ã¤). Have Windows Sharepoint Services 2 SP2, language pack SP2 and SQL 2000 SP4 Best regards, Dalibor Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49184
  - 4
    - Reusable content editor web part Hey Community I was hoping someone could point me in the right direction. Also let me know if this post would be better in another Group. So my question is is it possible to to have a Content Web Editor part that you could save to a LIST page for use later like the announcements part. Currently when you close the webpart all the content it held is gone. The reason why i ask I have a company that would like to use this to create a newletter but they dont want to display on the CWE parts in teh production page till someone reviewss the articles. If you were able to lets say create a content web editor web part name and save it on a Doc Lib then have the person responsible can then create a Page through the create menu in site setting or use an existing one and just drag and drop the parts in the layout/order he sees fit without worrying which article are displayed to the public without being checked first. If this cant be done out the box does anyone know if there is a product/website/blog providing the solution. I would reallly appreciate all input. Thanks in advance guys Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49182
  - 5
    - office save website view something very strange i open a word (office document) document from a document library at wss when i want to save it back at the wss at the save or save as dialogbox ,dont show me the website view , only all the others views . when i try to change the view , it shows me it for one second and then disapear in all the others views it shows me the document libraries as "doclib1" doclib2.... . and shows me the internal folders as "forms " "list " ..... any clue.... marcelo saied Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49181
  - 6
    - WSS v3 - Improved surveys? Hiya, In WSS version 2, I found a lot of weeknesses when it came to surveys. The one and most important: You are not able to create views. We want to sort the answers monthly. Is this possible in the new version? Any other improvements when it comes to surveys? Br, Hanna Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49180
  - 7
    - WSS v3 CreateSite error "Value does not fall within the expected range" Hi, Recently I have created a web application that could create new sites. After installing WSS v3 I keep on receiving the "Value does not fall within the expected range" error from Microsoft.Sharepoint.SoapServer.SoapServerException. I can reach the admin web service, I've added the web reference, created a new instance of the Admin class. This is how I try to create a new site: wsAdmin.Admin wssAdminService = new wsAdmin.Admin(); wssAdminService.CreateSite("http://xx.xx.xx.xx/Test02", "Test02", "Test02", 1033, "STS#0", "DOMAIN\\Name", "Name", "someone@somewhere.com", "", ""); Does anyone know this error and can tell what I'm doing wrong? (Other functions from my web application still work without a problem) Thanks in advance, Victor Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49178
  - 8
    - Changed name of W2K3 server --> Cannot connect to the config db I had to change the name of the W2K3 server that hostes a test-verion of WSS. When I try to connect to WSS I get the following error : Cannot connect to the configuration database. For tips on troubleshooting this error, search for article 823287 in the Microsoft Knowledge Base at http://support.microsoft.com None of the options in the KB solved my problem. I can't check method 3 since I don't have a Microsoft SQL server option under Programs. I think it is because I work with the MSDE-version. I found that under WSS-configuration the old name of the server is specified for the server that holds the config-database. However when I change that name I again recieve an error. ??? Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49177
  - 9
    - Templates for WSS v3.0 Will Microsoft provide templates for WSS 3.0? Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49175
  - 10
    - 'List' permissions question I think if someone is able to answer this question it will solve my problem. What permissions would a group have that would be able to contribute to a sharepoint list, but NOT be able to modify any of the views of the list? For example, they would not be able to modify any of the Filters of any view. And would those be setup under 'Manager Users' or somewhere else? thank you, Sal Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49173
  - 11
    - A SharePoints Documents Question NOTE: I first posted this question in windows.server.sbs - I know that cross-posting is frowned upon, but then I discovered this site which seems more appropriate to my question. I apologize if this offends anyone. We are now just beginning to play around with SharePoint, starting with General Documents. Here is my understanding from what I've done so far. On the sbs server, we have lots of work files in a folder named 'Public' which everyone shares. We would like to have 3-5 users be able to access those files, both while in the office and from home. To try out SharePoint I created a folder under General Documents called 'Shared' and copied some test files from 'Public' over to 'Shared'. And as expected, those files were accessible remotely. I only copied a few test files over because of two concerns: One, the duplicating of existing files - and secondly, the doubling of space used. -- However, when I went to the server and did a search for the files, all of them still resided in the original 'Public' folder. So, my understanding is that files copied from within SharePoint to a new folder in General Documents aren't really copied, but are only linked. Is this true? If it is true, this will work nicely for us. Thanks, Leon Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49172
  - 12
    - Access o.k. to portal but not to wss Hi - I've a user who authenticates fine to access our sharepoint Portal but whose same AD account denies her access to a WSS. I've deleted & re-added her to the WSS user site collection but that resolved nothing. Please, please help! I'm confused. Thx ... c Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49171
  - 13
    - Office 2007 / Sharepoint Office 2007 comes with Office Sharepoint Designer 2007 in my beta pack, there is also Office Server software, which includes Office Sharepoint Server 2007. what is Office Sharepoint Server? how does it differ from WSS version 3? how do office 2007 and office server 2007 work together? and how do they work with WSS version 3? finally, if i upgrade to WSS version 3, but don't upgrade to Office 2007 and Office Server 2007, what will i miss out on? Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49165
  - 14
    - Can't get Search configured/running under WSS 3.0 Beta 2 Hi all, any help with this one would be appreciated... I have a WSS 2.0 site running on the same system with SQL Server 2005. The site is/was working flawlessly. I installed WSS 3.0 beta 2 and chose to do an upgrade of the existing site. Everything works great after the upgrade... except for Search. I get to the Central Admin page to configure Search on my web application, and fill out the form... when I try to hit OK, I get an error page that states "Error" as the title and "Unknown error" as the subtext. Not very helpful. :) The event log shows that some part of the process was trying to log into SQL Server and apparently the login failed. Following this is an error: "Unknown SQL exception 2812 occurred. Could not find shared procedure dbo.proc_MSS_GetConfiguration_Property." If I manually remove the Search table from SQL Server using the SQL Server Manager and then manually create the table, then go and try to configure search, I can see event log entries indicating schema elements being added to the table successfully etc, then the above error. Odd part is: the credentials with which I am trying to set up Search are the Domain Admin user/pass, and these are both known to be correct and known to work properly for pretty much everything else in the site, including creating/deleting/manipulating the table in SQL. If anyone has any clues on this one I'd be *very* grateful! Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49164
  - 15
    - site template and security I made a site with several libraries and different permissions. When exporting the site as a template I got a stp file. I use stsadm.exe for adding this template, no problem so far. When creating a site I can choose the template and the site is made with all libraries, but all permissions are set to default. Is it possible to export a site as a template including the permissions? Second question I must made a lot of sites. Is it possibele with commandline and batching? Thanks in advance, Jabalili Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49163
  - 16
    - Automatically deleting forms in a Form Library Hi, Is it possible to automatically delete a form in a Form Library? What I am trying to do is; I have created a form via InfoPath and saved it in Library 1. Once someone has updated the form it needs to be move to Library 2. The only way I know of doing this is to open the form, update it then choose the 'Save As' option and save it in Library 2, I would then have to go back to Library 1 and delete it from there. Is there another way? Either through code that would allow me to automatically move the form from Library 1 to Library 2? Thanks for anyhelp you guys can give me. socaprice Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49158
  - 17
    - Default the Title for an Event Is there a way to determine the Title for a new event by default when it is entered, based on a value in another field of that table? I know that I can set the default to static text, but I'd like to be able to make the title default to a value that is selected from a drop-down list in the detail area of the event. Thanks, Chanda Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49154
  - 18
    - Office Communicator status Hi: I have these two questions for you, I hope you can help me: - How do i add the Microsot Communicator status into a contact list?.....Iâ??ve seen that in a document list appears an icon of the Office Communicator status (like in de Modify by column) and I want to have the same in a contact list. - In my portal I have like 40 users, two of them appear with this format â??domain/usernameâ?? while the others appear like â??usernameâ??â?¦.i can see these difference in all the documents they have uploaded, in the Modified by column. Best regards. Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49152
  - 19
    - NEED HELP: How to write SPQuery CAML to search ATTACHMENTS to List items??? Greetings all, I have a very interesting SPQuery/CAML Challenge for everyone: 1. I have a custom Sharepoint List living in a WSS (non-portal) site. 2. Each item in the list has 1 or more attached files. 3. I want to use the SPQuery object to formulate a CAML query that searches not only all the standard list fields (columns), but ALSO the FULLTEXT of each of the attached files. 4. The CAML query will be passed to the SPList.GetItems(strMyCAMLQuery) method, and return a SPListItemCollection, which I will transform to a DataTable, bind to a DataGrid, and all will be right with my world... Q1 - DOES anyone know if this IS possible (otherwise attaching files is useless)? Q2 - CAN anyone provide me with a solid online reference for doing this in CAML? Q3 - CAN anyone provide me with a working code snippet (no guesses, thank you)? TIA, - Mark Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49151
  - 20
    - Installed WSS on Certificate Services Server Hello, I had a server running Certificate Services on the default web site. Then I installed WSS and now cannot access my Certificate Authority through http. Apparently WSS overwrote my CA and now is the default web site. I am however, able to access the CA through Administrative Tools / Certification Authority tool and see all my certificates. I just can't create new certificates or get to the CA page like I use to, using http://ca-server. The WSS server was moved off the default site to it's own space and is working fine (second install of WSS), but the first install of WSS still shows the WSS Team Web Site when I try to access via http://ca-server. Does anyone know how to remove the WSS from the default site and get my CA working again? Thank you for any help. Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49146
  - 21
    - Problem with adding/browsing for WebParts on Sharepoint site Hello, When I try to add a WebPart to a Sharepoint homepage (via Modify Shared page - Add web parts - Browse) I get a "Cannot find server or DNS Error". This problem occurs on our WSS dev and production site. I have admin rights to both environments. For other users this works fine. I don't seem to have any other problems on these sites. Does anyone know what could cause this problem? Many thanks, Christian Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49145
  - 22
    - Basic vs Custom WSS Templates Hello, Can someone tell me the gist between the _Basic and _Custom WSS templates that Microsoft provides. Specifically the IT Developer one? Thanks, Greg Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49144
  - 23
    - Date format to = month Is there a way to change the format of a date to equal just the month. For example, the current date format is dd/mm/yyyy. I would like it to be just 'mmm' so todays date (13/06/2006) will become 'June' Thanks for your help, Dietmar Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49143
  - 24
    - Web part for customizing a database directly from the web Looking for a web part for administration of a customer directory (database in SQL Server 2005) and a customer view of that database via Sharepoint. What I want the web part to do is very generic: Enable me to via Sharepoint, take out a customer database from SQL Server, list all variables in all tables in the database and let me create a customer view by selecting which variables from that database to show in the customer view, which fields should be editable, what values can be assigned to the different variables, etc. I.e. say I have a customer database for a company that sales cars and I want to create that kind of searchable and editable, customized consumer view of that database. In the administration interface, I would then select relevant variables for the sales force to view and edit in the contacts with consumers such as registration number, adress information, when was the car repaired, etc. etc. As accessing a database via an administration interface over the web to configure a view of that database sounds very generic, I was wondering if anyone of you knows of any third-party or Microsoft web parts that could do that trick? I found a web part on the Microsoft web parts gallery site that sounded promising ("Customer Directory" in "Great Plains") but the detail page link for that web part is broken unfortunately. Big thanks in advance if someone has any good suggestions!! Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49137
  - 25
    - Windows Share Point services Problems in Small Bisiness Server 200 I have posted the same question in WSS Development area but I realized it wasn't the proper area so I'm re-posting here. Well here goes : Hello all. I have the following case and any reply would be appreciated. I have a client who has an SBS and everything installed and running. Everything includes AD , Exchange , SQL , ISA and WSS. This server was installed on a disk array with no redundancy and his back up suite cannot backup files that are open by the time of the backup operation. The controller of the server failed the other day and the array of the disk was destroyed. The client , prior to any call to me , rebuilt the array , re-installed SBS ( clean installation ) , imported the system state back up and tried to bring back all the other aplications. This is when he called me. Exchange and SQL wouldn't start so , after a lot of work , I reinstalled Exchange ( I had to remove a number of Exchange objects and services in the domain ) and also reinstalled SQL. In any case the wss site would start because he couldn't access SQL. I installed sp2 of wss and began trying to resolve his problem with wss. The problem is : As I can unserstand , IIS metadata haven't been backed up neither by the system state way nor by their suite. I have the actual files of the original installation of wss and the SQL databases. With this in mind I uninstalled and reinstalled the wss to re-create the sites almost from scratch. But there were problems occuring with it telling me that the Frontpage 2002 extensions aren't installed ( although I have upgraded the site ) , the site couldn't start and so on. I went further and removed wss and removed/re-installed IIS but to no avail. Bottom line is : Having the site files and the SQL databases of the original sites , can I import the original site in IIS and make it workable again ? If not is there any other way , making a clean wss installation , to restore the old wss data ? What the client is more interested in is the actual files he had stored in the wss sites not the sites and locations themselves. Tag: WSS v2 SP2: Custom formula column for file extension Tag: 49136

Hi all,
i would like to create a custom column in a Windows Sharepoint Services V2
SP2 document library, to extract the file extension using a formula.

Is it possible to create a formula using built-in functions like
substring/indexof, substr/charindex, or InStr/Mid based on the falue of the
FileName column of a document library without creating custom WebParts?

regards

Joris

Top