Import data from Excel

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
    - Lost Central Administration Web? So I was trying to get something to work and went to the Central Admin Web, Services on Server and thought I'd to a Restart (stop/start) on the WSS Service. I clicked stop, The page came back as not found, then in IIS Manager, the Central Administration Web vanished. it was set up as a specific port and now there are no webs with that port or the old name. So I created a new Web, with the same port, and pointed it to the WSS Virtual Directory and its not letting me see the pages. Gives a 403, Forbidden. Help! Other sites seem to work fine. Thanks, Scott<- Tag: Import data from Excel Tag: 59153
  - 2
    - Installing top-level WSS 2.0 application template Hey all, I've done this many times before but I think I'm missing a crucial step and it is really frustrating me. I'm trying to install Microsoft's freebie template (Employee Activities) as a top-level WSS 2.0 site template. The template file is saved on the SPS server under C: \EmployeeActivities_Custom.stp. My command line command looks like this: C:\Program Files\Common Files\Microsoft Shared\web server extensions \60\BIN> stsadm.exe -o addtemplate -filename <C: \EmployeeActivities_Custom.stp> -title <Employee Activities Custom> [- description <Custom Employees Activities>] When I hit enter, the command line says "The system cannot find the file specified". What am I doing wrong?? Tag: Import data from Excel Tag: 59152
  - 3
    - How do I split up a single WSS site into many WSS sites? Hi, I'm running an upgrade project to upgrade from WSS 2.0 to WSS 3.0, and as part of it I've been asked to split a single site into many smaller ones. The setup at the moment is we've got (amongst other ones) a Virtual Server with one site (with loads and loads of subsites) of 40GB (!) in one database which I would like to have on WSS 3.0 in at least two web applications with many top-level sites in each. Is there a tool for doing this? I've looked at WSS_Split, but that seems to be for moving top-level sites between content databases. The only way I can think of doing it at the moment is to manually move all the data to a new structure, which would be a little labourious! Thanks in advance, Tom. Tag: Import data from Excel Tag: 59151
  - 4
    - Installing WSS3 on Windows Server 2003 SP1 in 32 bit Emulation Mode We have 64 Bit Server running Windows Server 2003 SP1, we had to amend the IIS to run in 32 bit emulation mode so that our ASP.Net 2 Applications would run on the server. The problem is that now we cannot install WSS 3 on the server, the only way I can get WSS 3 on the server is to switch the IIS back to 64 bit and install the 64 bit edition of WSS . However, then our exisiting 32 bit ASP.NET Applications will not run. At present I cannot see how to install/run both WSS 3 and Asp.Net applications in 32 bit mode. It seems strange as all the other applications such as reporting services will run n 32 bit mode. Has anyone had the same issue or does anyone know if there is any way to get this configuration to work. Otherwise we might as well get rid of the 64 bit windows server 2003. Any help, insights or advice would be much appreciated, Thanks Tag: Import data from Excel Tag: 59144
  - 5
    - Custom Software Development iTechArt Group - Custom Software Development and Offshore outsourcing Company http://www.itechart.com/ Offshore custom software development company iTechArt - Web site and Content Management Solutions development, CMS consulting: Ektron, Drupal and DotNetNuke iTechArt Group provides high quality custom software development services and offshore software development. On December 2006, iTechArt Group became an authorized Microsoft Certified Partner. This means that our company has been recognized by Microsoft for our vast expertise and authorized to custom software development; provide IT service consulting and custom business solutions. Custom Software Development and Offshore outsourcing Company iTechArt has worked together since 2003 to design build and deliver .NET Web Content Management software solutions that help clients meet their strategic objectives. We are agile oriented development partner able to consistently deliver solid results. iTechArt software development team assemblies specialists in the development of custom software applications and offshore software outsourcing services. Working concepts of our company are based on proven approaches and international standards used for custom software development such as Capability Maturity Model Integration for Software Engineering (CMMI- SW). In the same breath we have our own standpoint on software development process management which is fully effective and comprehensible for our clients. iTechArt offers software development in the next main directions: 1. Custom Software Development (Offshore outsourcing for worldwide based software development companies.) 2. Software Development for Digital Signage (Media content development and remote displays / information kiosks Web-based software application management.) 3. Web Site Development (E-commerce solutions, CMS/DotNetNuke/Ektron/ Drupal, Web 2.0/PHP/MySQL/AJAX, Flash/Action script/Flex and many more.) 4. Offshore Development Center (Dedicated development team of software developers. Our offshore development centers operate as an extension to clients' existing software engineering business.) Contact iTechArt ( http://www.itechart.com/ )about custom software development, end-to-end software solutions, outsourcing software development, custom DotNetNuke module development, DotNetNuke consulting, dotnetnuke hosting, first class Java and .Net developers, software application design, software testing, Quality Assurance, functionality testing and defect analysis, performance and stress testing, usability testing, Microsoft Media Services and Adobe Media Flash Server solutions, digital signage solutions and custom development, Ektron CMS400.NET developers, CMS, .NET Web Content Management software solutions Web: http://www.itechart.com/ http://www.itechart.com/Pages/ProductsServices/HowWeWork.aspx http://www.itechart.com/Pages/ProductsServices/BusinessModels.aspx http://www.itechart.com/Pages/ProductsServices/CustomSoftwareDevelopment.aspx http://www.itechart.com/Pages/ProductsServices/DotNetNukeModuleDevelopment.aspx Tag: Import data from Excel Tag: 59138
  - 6
    - sharepoint designer looping workflow anyone knows if its possible to create a looping workflow in sharepoint designer ? Tag: Import data from Excel Tag: 59136
  - 7
    - WSS FAQ additions and changes - 7th - 13th May 2007 Note: All of the addresses of the KB / Articles - 2007 Products / 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 http://mikewalsh.bilsimser.com) (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 7th May - 13th May 2007 I 2007 KB Articles (*now only one section for WSS and MOSS*) New http://support.microsoft.com/default.aspx?scid=kb;en-us;936759 E-mail notifications for alerts are not sent when content in a migrated list or in a migrated document library changes after you perform a database migration to upgrade to Windows SharePoint Services 3.0 (ver 1.2) 10th May 2007 http://support.microsoft.com/default.aspx?scid=kb;en-us;936760 The URLs of alerts in e-mail notifications that you receive are incorrect after the URL of a Web application for a site in Windows SharePoint Services 3.0 or in SharePoint Server 2007 changes 10th May 2007 http://support.microsoft.com/default.aspx?scid=kb;en-us;932118 Persistent cookies are not shared between Internet Explorer 7 and Office applications in Windows Vista 7th May 2007 http://support.microsoft.com/default.aspx?scid=kb;en-us;928754 Excel Services does not support asynchronous queries 3rd May 2007 http://support.microsoft.com/?kbid=934793 Description of the SharePoint Server hotfix package: April 12, 2007 3rd May 2007 http://support.microsoft.com/?kbid=920278 Custom SharePoint task list columns may not appear in Outlook 2007 (ver 1.2) 25th April 2007 [SharePoint Designer 2007 follow] http://support.microsoft.com/default.aspx?scid=kb;en-us;927151&sd=rss&spid=11677 How to create a custom Index Server search page by using ASP in SharePoint Designer 2007 9th May 2007 Modified http://support.microsoft.com/default.aspx?scid=kb;en-us;935504 Error message when you click "New" to create a new item in a list or when you click an existing item in SharePoint Server 2007 or in Windows SharePoint Services 3.0: "Invalid page URL" or "An unexpected error has occurred" (ver 1.1) 11th May 2007 (Title changed as well) http://support.microsoft.com/default.aspx?scid=kb;EN-US;888041 How to make Windows SharePoint Services use a pre-existing database as the content database (ver 4.0) 4th May 2007 (version 3.0 was marked as a v2 KB article - now moved to v3 [it covers both]) http://support.microsoft.com/?kbid=898631 Supported and unsupported scenarios for working with custom site definitions and custom area definitions in Windows SharePoint Services, in SharePoint Portal Server 2003, and in Office SharePoint Server 2007 (ver 3.0) 4th May 2007 (version 2.0 was marked as a v2 KB article - now moved to v3 as renamed [it covers both]) http://support.microsoft.com/?kbid=925189 Error message when you try to use an existing site template to create a new SharePoint Server 2007 site: "Failed to apply template" (ver 2.0) 3rd May 2007 http://support.microsoft.com/?kbid=926062 Error message when you try to upgrade Windows SharePoint Services 3.0: "Failed to detect if this server is joined to a server farm" (ver 2.0) 3rd May 2007 http://support.microsoft.com/default.aspx?scid=kb;EN-US;934838 How to change the password of service accounts in SharePoint Server 2007 and in Windows SharePoint Services 3.0 (ver 2.1) 2nd May 2007 http://support.microsoft.com/?kbid=929072 Error message when you use Forefront Security for SharePoint: "ERROR: Unable to connect to service." (ver 2.0) 1st May 2007 http://support.microsoft.com/?kbid=929073 Error message when you start Forefront Server Security Administrator: "ERROR: Unable to connect to service" (ver 2.0) 1st May 2007 II. Articles - 2007 Products (no longer with all links to articles for other Office 2007 and other 2007 Products) New A. Office 2007 Server Products http://blogs.msdn.com/joelo/archive/2007/05/11/sharepoint-rss-ttl.aspx SharePoint RSS TTL [Time to Live tag] (MS Blog - Joel Oleson) 11th May 2007 http://msdn2.microsoft.com/en-us/library/bb466172.aspx Upgrading an MCMS 2002 Application to SharePoint Server 2007 (Part 1 of 2) 10th May 2007 (date added) http://msdn2.microsoft.com/en-us/library/bb466171.aspx Upgrading an MCMS 2002 Application to SharePoint Server 2007 (Part 2 of 2) 10th May 2007 (date added) http://www.sharepointblogs.com/zimmer/archive/2007/05/09/simple-excel-services-step-by-step-publishing-a-spreadsheet-to-sharepoint-2007.aspx Simple Excel Services - Step by step, publishing a spreadsheet to SharePoint 2007 (Blog - Tobias Zimmergren) 9th May 2007 http://www.microsoft.com/downloads/details.aspx?familyid=7ea93b92-07c1-4de6-9c74-be48df443a0f&displaylang=en&tm SharePoint Server 2007 Demo: Add a Library to a Records Center Site 9th May 2007 http://www.microsoft.com/downloads/details.aspx?familyid=c910a323-164d-4fad-8646-64872ffe4c46&displaylang=en&tm SharePoint Server 2007 Demo: Configure a SharePoint Server 2007 Site to Receive E-Mail http://www.microsoft.com/downloads/details.aspx?familyid=29e28ae2-0b3f-4e5d-9d34-a1452968703c&displaylang=en&tm SharePoint Server 2007 Demo: Enable Excel Services and Data Connections for a SharePoint Team Site 9th May 2007 http://blogs.technet.com/wbaer/archive/2007/05/08/database-management-concepts-for-large-and-growing-content-databases.aspx Database Management Concepts for Large and Growing Content Databases (Blog - William Baer) 8th May 2007 http://download.microsoft.com/download/A/A/1/AA13E922-FFA3-4EB1-BA3D-D177AB058746/SP_Users_Guide.doc Forefront Security for SharePoint - User's Guide 8th May 2007 (date added) http://www.appliedis.com/Library/MOSS%202007%20as%20an%20Ap%20Dev%20Platform%20vfweb.pdf MOSS 2007 as an Application Development Platform (Applied Information Sciences Inc. white paper - Vishwas Lele) 8th May 2007 (date added) http://blogs.msdn.com/sherder/archive/2007/05/07/excel-services-saving-workbooks-back-to-the-server.aspx Excel Services: Saving Workbooks back to the Server (MS Blog - Sherman Der) 7th May 2007 http://www.microsoft.com/downloads/details.aspx?familyid=c5480d57-6a0b-4a65-a17f-8bea296c0402&displaylang=en&tm Office SharePoint Server 2007 Guide: Setting up the Role-Based My Site Template for Sales Account Managers 7th May 2007 http://www.microsoft.com/downloads/details.aspx?familyid=d69da344-d4e2-49ef-bd44-4c9e8ef761bf&displaylang=en&tm Office SharePoint Server 2007 Guide: Setting up the Role-Based My Site Template for Controllers-Financial Analysts 7th May 2007 http://www.microsoft.com/downloads/details.aspx?familyid=b2da1095-faba-44b0-9935-a00dceeca0f3&displaylang=en&tm Windows SharePoint Services 3.0 Demo: Tour a Windows SharePoint Services 3.0 Site 7th May 2007 http://www.sharepointblogs.com/mossman/archive/2007/05/07/how-to-add-a-button-the-html-editor-control-in-sharepoint.aspx How to Add a Button to the HTML Editor Control in SharePoint (Blog - MOssman - based on and adding to the MSDN article of the same name) 7th May 2007 http://www.sharepointblogs.com/yeon/archive/2007/05/06/how-to-create-2-step-approval.aspx How to create 2 step approval using SPD 2007 without VS2005 (Blog - Yeon) 6th May 2007 http://www.sharepointblogs.com/pholpar/archive/2007/05/06/hunting-the-encoding-problem-in-content-deployment-part-2.aspx Hunting the encoding problem in content deployment - part 2 (Blog - Péter Holpár) 6th May 2007 http://www.projectservergurus.com/adnan/Lists/Posts/Post.aspx?ID=5 Best Practices for Project Server 2007 Deployment in a Large Server Farm with Office SharePoint Server 2007 (Blog - Syed Adnan Ahmed) 5th May 2007 http://www.sharepointblogs.com/pholpar/archive/2007/05/05/hunting-the-encoding-problem-in-content-deployment-part-1.aspx Hunting the encoding problem in content deployment - part 1 (Blog - Péter Holpár) 5th May 2007 http://weblogs.asp.net/soever/archive/2007/05/03/sharepoint-features-elements-scope-and-other-info.aspx SharePoint Features - elements, scope and other info (Blog - Serge van den Oever) 3rd May 2007 http://blogs.msdn.com/sherder/archive/2007/05/01/excel-services-snapshot-vs-open-in-excel-what-the-diff.aspx Excel Services: Snapshot vs Open in Excel - What's the diff? (MS Blog - Sherman Der) 1st May 2007 http://blogs.msdn.com/sherder/archive/2007/04/09/excel-services-only-let-them-see-what-you-want-them-to-see.aspx Excel Services - Only let them see what you want them to see (MS Blog - Sherman Der) 9th April 2007 http://www.u2u.info/Blogs/Kevin/Lists/Posts/Post.aspx?ID=8 Showing list items from another site (Blog - Kevin DeRudder) 3rd April 2007 http://blogs.msdn.com/sherder/archive/2007/03/13/excel-services-welcome-to-the-future-of-spreadsheets.aspx Excel Services: Welcome to the future of spreadsheets (MS Blog - Sherman Der) 13th March 2007 http://udayakumarethirajulu.blogspot.com/2007/02/creating-publishing-infopath-form-using.html Creating and Publishing an InfoPath Form using Form Services in Moss 2007 (Blog - Uday) 21st February 2007 http://www.thelineberrys.com/default-category/hosting-multiple-unique-sharepoint-sites-on-a-single-server-2.html Hosting Multiple unique SharePoint Sites on a single server (Blog - Steve Lineberry) 17th January 2007 B. Other Office 2007 products (selected few only since 1.1.2007) http://www.microsoft.com/downloads/details.aspx?familyid=fc2ca984-e9c3-451c-a225-b1a5812722db&displaylang=en&tm InfoPath 2007 Demo: Convert a Word Document into an InfoPath 2007 Form Template 9th May 2007 http://www.microsoft.com/downloads/details.aspx?familyid=821c81df-ffcf-4116-ac35-288a177a0a60&displaylang=en&tm InfoPath 2007 Demo: View the Business Logic in an InfoPath 2007 Form Template 9th May 2007 http://www.microsoft.com/downloads/details.aspx?familyid=aeeaec61-2dfc-4ee3-aaa0-5bf007f3d697&displaylang=en&tm InfoPath 2007 and Outlook 2007 Demo: Use InfoPath E-Mail Forms to View Data in Outlook 2007 9th May 2007 C. Other New 2006/2007 Products (selected few only since 1.1.2007) http://sambbiblog.spaces.live.com/blog/cns!794708049C7AE9C2!762.entry Add "minibars" to your SQL Server Reporting Services Reports (Blog - Sam Sam Batterman) 11th May 2007 http://www.microsoft.com/downloads/details.aspx?familyid=d6266f43-549f-492a-b1ab-70c5ac6b213b&displaylang=en&tm Visual Studio 2005 Team System Training Videos 10th May 2007 http://www.foxitsoftware.com/pdf/ifilter/ Foxit PDF IFilter (free) 8th May 2007 (date added) http://www.microsoft.com/downloads/details.aspx?familyid=2e575633-e357-4ee7-aaff-34138f00e830&displaylang=en&tm Hands-on Labs for Windows Workflow Foundation in C# and VB.NET 7th May 2007 http://www.microsoft.com/downloads/details.aspx?FamilyID=6096ce0f-d21e-47ac-afe2-d4e1c2fce670&displaylang=en A Microsoft Windows Workflow Foundation timer does not resume correctly after reloading a workflow (relevant to solving SPD 2007 workflow problems) 12th April 2007 Modified None Deleted None III WSS v3 FAQ New http://www.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1059 I.35 What (main) Excel 2007 features are not available in Excel Services http://www.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1060 III.54.06 Templates: (Any that use Project Tracking features): Why aren't fields showing up in the new or edit item pages? http://www.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1061 III.54.07 Templates: Bug Database Template: Problems? http://www.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1064 V.48 Programming Excel Services (Pro Developer) (MS Press - Alvin J. Bruney) http://www.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1055 VI.33 Tzunami Deployer (commercial - Tzunami) http://www.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1056 VI.34 Tzunami Designer (commercial - Tzunami) http://www.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1057 VI.35 ComplianceBuilder / SharePoint Edition (commercial - Vital Path) http://www.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1058 VI.36 Scanning Enabler 2007 (commercial - darkblueduck) http://www.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1063 VI.37 WSS Cross Site Search (commercial - KWizCom) http://www.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1065 VI.38 DSP Performance Canvas 2007 (commercial - DSPanel) http://www.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1062 X.56 .STP Language Converter (free - KWizCom) Modified http://www.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/EditForm.aspx?ID=958 I. What issues are fixed in fix packs to MOSS 2007? http://www.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=983 VI.15 Nintex Workflow 2007 (commercial - Nintex) --------------------------------------------------------------------------- IV WSSv2 KB Articles (plus SPS 2003 Hot fixes) New None Modified http://support.microsoft.com/default.aspx?scid=kb;EN-US;835559&FR=1 You cannot access portal sites or Web sites, certain areas of SharePoint Portal Central Administration display the incorrect server name, and e-mail notifications contain incorrect URLs after you rename the server (ver 5.5) 2nd February 2007 V. MS Articles for WSSv2 New None Modified None VI Non-MS Articles for WSSv2 New None Modified None VII WSSv2 FAQ New None Modified None Tag: Import data from Excel Tag: 59135
  - 8
    - show a list view in a customized web part Hi I am writing a web part where I want to show a contact list but use one of the views define for that contact list. I do not want to use the list view web part but basically want to write my own list view web part with some UI in addition to what the list view will show. Can anyone tell me how I can display a view associated with a list in a customized web part. Thanks Tag: Import data from Excel Tag: 59129
  - 9
    - SPCAP - SharePoint Capacity Planning Tool released! Hey everyone, Having had to struggle through the confusing documentation for SharePoint capacity planning myself, I figured that it would be great if there was a tool that automated the process. I looked around and found nothing like that existed, so a couple of weekends later, I had created one. :-) Of course there are many variables to the equation, but the tool reduces a lot of overhead and saves a lot of time for simple guidance on server farm requirements. If you or anyone you know needs to do capacity planning for SharePoint, please do pass this on to them. http://www.cjvandyk.com/blog/Lists/Posts/Post.aspx?ID=100 Also, please leave any comments or feedback you may have on the blog comments page. It is always much appreciated. -- Thanks C Blog: http://www.cjvandyk.com/blog RSS: http://feeds.feedburner.com/cjvandyk SPCAP - SharePoint Capacity Planning Tool http://www.cjvandyk.com/blog/aspx/SPCap.aspx Tag: Import data from Excel Tag: 59128
  - 10
    - controlling the toolbar types of web parts on the homepage My scenario. Using WSS 3.0, I adjusted the toolbar type and border of list web parts on the homepage. I also defined some custom views as the default views for list web parts on the homepage. I saved the site as an .stp. I created a new site based off of my .stp. The homepage of my newly created site reverts back to the the full toolbar for my web parts and it doesn't display my default views for the web parts that I specified in originally configured site. I know that in WSS 2.0, I never had any issues configuring and keeping the configuations when creating sites based off of a backed up .stp files. Does this not work in 3.0? I also tried to define a toolbar type and view for the list web parts on the homepage using my custom List Features but could not find a way to do this using Features, onet, or default.aspx either. Any suggestions? Thanks in advance, Jeremy Tag: Import data from Excel Tag: 59120
  - 11
    - Searching pages in the WIKI We have a WSS 3.0 install and have created a WIKI site. I added a number of WIKI pages. The search always comes up as No results found. Is there something that has to be done to manually kick of the indexing process? Thanks Tag: Import data from Excel Tag: 59118
  - 12
    - Replacing default website on SPS 3.0 I want to replace the default website for an SPS 3.0 installation with a custom site defined template. If I go into Create a site the only option is to create one under the http://default/sites/enternewnamehere. I have done so once before, but for some reason can't seem to do so now. I am clearly going to the wrong options to perform this function. my http://default site is not in existence at the moment because yesterday i deleted it, and replaced it, then deleted again to tweak the custom definitiion, but for some reason i guess i forgot overnight... or something is really squirrley here... how can i do this? Tag: Import data from Excel Tag: 59117
  - 13
    - MOSS 2007 Workflow copy error Hi, I have a form document library which contains an Infopath 2007 web form template that a user fills out and submits to the library. There is a workflow in place that once the forms have had content approval they are to be copied to another form document library. The issue I am having is that the workflow is stopped once a document has been approved due to the following error and the form does not get copied: User ID: System Account Description: Error copying a list item Outcome: Unknown Error The System Account has been given Full Control on both the start and destination document libraries. I was wondering if there is something I am over looking here as I have used workflows to copy documents before on another site and did not come across this issue. I checked the settings on both the sites where it has worked before and the site I am encountering the error on and there are no differences. Thanks in advance! Tag: Import data from Excel Tag: 59116
  - 14
    - Can WSS3 with WID coexists on the same web server with SSEE used for other web applications? My apologies if this question has been asked before. Our installation of WSS3 is using the default Windows Internal Database. WSS3 is located on our dedicated web server for IntRAnet/Extranet purposes. This dedicated web server also hosts our corporate .com web site and FTP site. I would like to develop some ASP.net 2.0 applications and also host them on this same web server. We don't have a full blown DB like SQL, I would like to install SSEE on this same web server. Can WSS3 with WID coexists on the same web server with SSEE used for other ASP.NET 2.0 web applications? Thanks. Tag: Import data from Excel Tag: 59111
  - 15
    - Unable to export a WSS 3.0 list to an Excel XP spreadsheet I'm having trouble exporting a list of any kind from WSS 3.0 into Excel XP. When I attempt to click Actions > Export to Spreadsheet within the list it gives me the error "You must have supported spreadsheet software to export a list." Are there Active X controls that are required to be able to perform this function? I believed that to be the case but the IE 6 browser isn't prompting me to download any Active X controls. Others in the office are able to export just fine to Excel XP but I'm not able too. Any Ideas? Tag: Import data from Excel Tag: 59109
  - 16
    - Unable to View WSS 3.0 Alerts in Outlook 2007 Hi We use Outlook 2007, Exchange 2003 and WSS 3.0. I am unable to open and view Sharepoint alerts in the Outlook client - I know there is a hot fix, anybody know where I can get it? Tag: Import data from Excel Tag: 59108
  - 17
    - Sharepoint Custom WebService wsdl/disco problem Using the "Walkthrough: Creating a Custom Web Service" whitepaper I have been able to make my Web Service discoverable. The problem is the .disco and .wsdl files cannot be found when attempting either: http://server/_vti_bin/CustomWebService.asmx?disco http://server/_vti_bin/CustomWebService.asmx?wsdl Can someone tell me what is causing this problem? Thanks, AJL Tag: Import data from Excel Tag: 59107
  - 18
    - Need to remove broken link from quick launch wss v2 I have a WSS v2 team site that has a broken link to a document library on the quick launch bar that has been deleted. Does anyone know of a way to fix this without using Frontpage 2003? We don't want the site to become unghosted from the template which as I understand is what happens when the site is modified in Frontpage. Normally when you delete a document library it will also remove it from the quick launch bar but it did not do so in this case. Any help is much appreciated. Thanks, Marty Tag: Import data from Excel Tag: 59106
  - 19
    - Cancel ItemUpdating event problem! Hi! I wan't to cancel an ItemUpdating event with a graceful custom message, instead i get an ugly ASPX message. In ItemDeleting the same code shows a graceful message in the browser. Code used: properties.Cancel = true; properties.ErrorMessage = "some error"; Why the cancel of two different events generate two different behaviors? How can i have a greceful behavior in cancel ItemUpdating? Thanks! Tag: Import data from Excel Tag: 59096
  - 20
    - updating SharePoint Hello I'm working in company where I should create web form login system to SharePoint services. There should be loxin.aspx and other files that manage login in Local_Drive:\\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS but I can't find that folder on my computer. I suspect that it is because our version of SharePoint is 2.0 (came with Windows server 2003 R2) and the files belongs to SpaePoint 3.0. So if I update to SharePoint 3.0 do I get these files? There are alredy 250 sites managed by SharePoint so is this update going to mix up these and how should I do it? Nicka Tag: Import data from Excel Tag: 59085
  - 21
    - Change Wording for Toolbar in Survey Template Does anyone know how to change the wording for "Respond to this survey" inside of the standard survey template in Windows Sharepoint Services 3.0? I've tried using Sharepoint Designer to make the changes without any luck. I would simply like to use this template as a voting module and would like to change the text to say "Vote Now", instead of "Respond to this survey. Any help would be greatly appreciated. Tag: Import data from Excel Tag: 59078
  - 22
    - Forms Based Authenticatiuon - WSS3 - Roles? So after Following: http://blogs.msdn.com/sharepoint/archive/2006/08/16/configuring-multiple-authentication-providers-for-sharepoint-2007.aspx and http://weblog.vb-tech.com/nick/archive/2006/06/14/1617.aspx I have Forms Based Authenticatiuon mostly working on a seperate AAM URL for my WSS Site. I'd like to be able to use Roles. It does not seem to work for me, or I'm not understanding what Roles are. I've created my Users and Added them to Roles. I go into the WSS site and I can see the User Names in search, though I cannot see any of the roles that I entered. I've added the Following to the WebConfig: <roleManager enabled="true" defaultProvider="AspNetSqlRoleProvider"> <providers> <remove name="AspNetSqlRoleProvider" /> <add connectionStringName="AspNetSqlProvider" applicationName="/" description="Stores and retrieves roles data from the local Microsoft SQL Server database" name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> </providers> </roleManager> I've gone into the ASP.Net Configuration Settings in IIS Manager and made sure that the Roles is enabled and that AspNetSqlRoleProvider is selected. When I enter in the Roll name for the user, it says it cant find any matches. Scott<- Tag: Import data from Excel Tag: 59077
  - 23
    - WSS v3 stsadm lock/unlock sites WSS v3 not MOSS. The SQL DBs are being backed up using Symantec BE SQL Agent, but I have also been backing up all sites individually using stsadm (we don't have many sites and the sites are not large). I just read sites should first be locked before backing up using stsadm and then unlocked after, and about the new getsitelock and setsitelock command parameters for WSS v3. Which of course I have not been doing, oops. So, is this what batch file should look like?: stsadm.exe -o setsitelock -url <url of site> -lock noaccess stsadm.exe -o backup -url <url of site> -filename <file> -overwrite stsadm.exe -o setsitelock -url <url of site> -lock none for each site backed up? And when/why would I use getsitelock in batch file? Is that for returning the current lock condition of site? e.g. If getsitelock = none then setsitelock to noaccess ? Thanks, not much info on these 2 new commands I could find. Just want to be sure I am on right track. jremmc Tag: Import data from Excel Tag: 59076
  - 24
    - Restore a Full Backup with Differentials Hello, Does anyone know how to restore a backup that has differentials that were backup up during the week? We are using WSS 3.0 & SQL 2005. We are trying to determine our plans for backups. We know you can use the STSADM tool to backup the whole farm and also backup using the differential switch. Is there a way to backup the full and the differentials? Thanks, Paul D. Tag: Import data from Excel Tag: 59075
  - 25
    - unable to upload files larger than 30 mb Hi, We are using WSS 3.0 and are unable to upload files larger than 30 mb. We get a non descriptive error message or a time out message when we upload a file 30 mb or greater both in upload file window or using the explorer mode. When we use the upload multiple documents window we get an error prompting that the error has occurred while stsupld.dll was running. We can upload smaller files using all the three upload methods but cannot upload large files. I have seen a couple blogs that talk about this issue but did not see a resolution for this. Any help will be greatly appreciated, Sudha Tag: Import data from Excel Tag: 59074
- Next
  - 1
    - custom web service for sharepoint HELP! I'm using the microsoft "Walkthrough: Creating a Custom Web Service" white paper to test out this scenario and I have come across a snag. When I try and run disco.exe to create the .disco and .wsdl files I get the error: Could not load the file or assembly 'SharepointCustomLibrary, Version 1.0.0.0, Culture=neutral, PublicKeyToken=986c3ed4d8aaa298 or one of its dependencies. the system cannot find the file specified. I run disco.exe locally and the site is hosted on the sharepoint server. The server displays the Microsoft .net framework 1.1 configuration admin tool but not the 2.0 config tool. When I try to add my assembly to the GAC through the 1.1 admin tool it says it can't because it does not have a strong name (even though it really does). I can add it however if I just drop it into the %windows%\assembly directory. Does anyone know what the problem might be here? Thanks. Tag: Import data from Excel Tag: 59072
  - 2
    - new column added to list does not appear in new/ edit views Hi, I am trying to extend the Service Request list in the IT Team Workspace application template. I added a new column to the list definition. It appears in the list view but it does not appear in the New or Edit form view. Is there a way to make it appear in these views? thanks Tag: Import data from Excel Tag: 59066
  - 3
    - How can I sort a list on a field with Multiple values? Hello - Im looking for a solution that will allow me to sort a list on a field that has multiple values. I am open to microsoft and 3rd party solutions. Thanks -- Dave Tag: Import data from Excel Tag: 59065
  - 4
    - Usage analysis processing - WSS 3.0 in the help for Usage Analysis processing, it states : "In the Number of log files to create box, type a value for the number of log files to keep per Web application. When that number of log files are reached, no more files are created until some are deleted." Does this mean I have to manually delete the log files (or automate with a scheduled task) or else logs won't be gathered? I find that hard to believe, but I don't know. I'm also disappointed to read that stats are only kept for 3 months! I guess it's a space issue, but that doesn't sound like that much to me. Tag: Import data from Excel Tag: 59064
  - 5
    - IE6 Crashes When Opening List/Library in WSS3 We have a few users that are seeing this problem where IE crashes when they try to access a list or library in a WSS 3 site. It doesn't seem to happen when navigating from site to site or within a list or library - only when trying to initially access a list or library in a site. To further compound things, it doesn't happen all the time - for example - the user may see the problem at 10am, but then an hour later no problem at all (there doesn't seem to be a discernible pattern - ie only in the afternoon). Has anyone else seen this or does anyone have any idea on how to trouble shoot it? Thanks Mark Tag: Import data from Excel Tag: 59063
  - 6
    - V3 Top Link Bar Simply. In WSS V3, how does one add that nice little arrow to a Top Link Bar tab where the site has a subsite? I've seen it several times. CW Tag: Import data from Excel Tag: 59062
  - 7
    - Apply new site definition/template? Hi all, I have just migrated a Share Point 2001 site to WSS 2.0. I have noticed it appears to have adopted a default site definition/template, which isn't in line with the look and feel of the rest of our WSS 2.0 environment. If possible i would like to apply an alternative (existing) site definition/template to this migrated site to bring it inline with our current look and feel. Can i do this? How do i go about it? Would appreciate any help! Cheers, Adam Tag: Import data from Excel Tag: 59061
  - 8
    - Remove ermission Inheritance (again) This is already documented i n a previous thread, however, uinless you're actually searching for them, no one will see the question. I have a problem using V3. I created 3 sites: Main site - Should be no access [http://servername/default.aspx] Subsite1 - Unique (accidentally kept "inherit permissions from parent") [http://servername/subsite1/default.aspx] Subsite2 - Unique (accidentally kept "inherit permissions from parent") [http://servername/subsite2/default.aspx] I thought that, later, one would be able to change permission inheritance as in V2 but it is not available anywhere, and yes I know where it should be and have seen it and used it many times in V2. There is no "Manage Permission Inheritance"I can see in V3. I remove a person from the main and he has no access to the main or subsites. I remove him completely and no access anywhere. Good. (in fact the option is "Delete Users from site Collection). I add him in a sub site and he has access to subsite, and main site. Not Good. So, I figured out the "Team Site Members" group permissions (for entire collection) vs "Contributor Group" site specific permissions was part of my problem (albeit not the most intuitive thing). Still can't remove permission inheritance though as it's not available in site settings. Any suggestions? Tag: Import data from Excel Tag: 59060
  - 9
    - "The Form was customized not working with attachment" on a custom I created a custom list form using Sharepoint Designer and now I am not able to use the attachment upload feature. We I try to use it I get the "The Form was customized not working with attachment." I need to be able to upload attachments using this form. Help? J Tag: Import data from Excel Tag: 59059
  - 10
    - WSS3: How to edit homepage layout Hi, I am looking for a way to modify the layout of the homepage of a WSS3 site. I am stuck with the two default columns ... I want to change this layout to have one 100% large cell and than two columns under it. That is to say three Web-Part containers! Is there a way ? I already tried Frontpage XP and Frontpage 2003 (and "Modify this page") Thanks, Arka Tag: Import data from Excel Tag: 59044
  - 11
    - Soap request Custom Dll causes That assembly does not allow partially trusted callers Errors Hi, I am using Addy Santo's WSSDAL (Sharepoint Web Services Alternative http://blogs.msdn.com/asanto/archive/2005/03/02/383939.aspx) but trying to send a request to the service results in the following error: <?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/ XMLSchema"><soap:Body><soap:Fault><faultcode>soap:Server</ faultcode><faultstring>Server was unable to process request. ---> That assembly does not allow partially trusted callers.</ faultstring><detail /></soap:Fault></soap:Body></soap:Envelope> Now, after a lot of research, people would probably say that the web application is not set to FullTrust. The Sharepoint site is in FullTrust mode unfortunately... However, also read another post that mentioned that the error can also be caused by the DLL's (WssDAl's) are compiled in a previous version. Well, this seems more of the issue as the DLL's are compiled for .Net 1.1 and the Sharepoint Site is running on .Net 2.0. I have tried to recompile the source (this comes with the WssDal package) yet, there seems to be some missing config files or other files and the conversion/compile fails. So my questions are: 1) Is there anyway to get the earlier compiled DLL's to be "fully trusted" or 2) Has anyone got a version of WssDal for .NET 2 or 3) Has anyone got an alternative to WssDal (apart from MS's version) or 4) Anyone have any other ideas. Thanks in advance, Robert Tag: Import data from Excel Tag: 59043
  - 12
    - Lock a field for certain users Hi All, I have a custom list (WSS 2) with several fields. 3 fields are for internal use of the department while other are for all users to fill. Can I restrict those 3 fields so only specific users can fill? Thanks a lot in advance Tag: Import data from Excel Tag: 59042
  - 13
    - want to override layout of newform.aspx/dispform.aspx and editform.aspx Hi, I have a custom list, so i want to override the layout of newform.aspx, dispform.aspx and editform.aspx. I have created a template (custom) [ascx control] and deployed that in 12\template\ControlTemplate. But i am not able to hide the default toolbar buttons present in pages. And also i want to add "sava and Close" button, want to save that item after some validation. So plz let me know the best way to achieve this. Thanks, Abhi Tag: Import data from Excel Tag: 59040
  - 14
    - assign value to hidden field in custom list, Hi, I have created a custom list based on a custom content type. Custom content type has several fields, in which 2 r required, and rest 2 are hidden fields. So I want to assign some value to those hidden fields according to value entered by user in newform.aspx while creating item for that custom list. In newform.aspx, according to my requirement, only 2 fields are available for user. Based on those values, i want to do some validation and then want to assign some values to HIDDEN fields before creating ITEM. please let me know how it can be done. Thanks and Regards, Abhi Tag: Import data from Excel Tag: 59039
  - 15
    - Issue Status field in Issue Tracking list not visible in edit form Hi all I've created a standard issue tracking list in a WSS3 site. THe issue status field is visible in the list view however it's not visible in the edit form of an issue item. Is this field controled by sharepoint or can it be editied manually?? Thanks George Tag: Import data from Excel Tag: 59031
  - 16
    - Trying to create a vehicle reservation site in WSS 2.0 Running WSS 2.0 on SBS 2003 Premium with Exchange, SQL, WSUS, ISA 2004, 2 NIC's and a router, dynamic IP, DDNS service through dyndns.org, Symantec Backup Exec 11d. ======================== I'm a real newbie to WSS. I'm trying to modify the Room and Equipment Reservation - Custom template from Microsoft so I can set up a reservation system for our vehicles. (Every warm season we get a bunch of grad students in to help with the research seaason; always a pain allocating vehicles. I'm hoping WSS will help us out.) My problem is I can't quite get everything modified for what I want. Would someone give me some hints? What I want: from the main page, they should see a list of vehicles (all), a list of available vehicle (those not reserved) [this item is not critical, so I can do without it, if need be], and a list of reserved vehicles that tells us who has it, and the start & end times they'll have it. I'd really like to enable a calendar view to show all vehicles reserved for the given time-frame (month, week, or day). -- Mike Webb Platte River Whooping Crane Maintenance Trust, Inc. a 501 (c)(3) conservation non-profit organization Tag: Import data from Excel Tag: 59027
  - 17
    - Site Templates - For new Top Level Sites? So I've create a WSS3 site: template.domain.com I want to create new sites based on this site. project1.domain.com project2.domain.com etc... I would like all of the content of site: template.domain.com to be in the new sites. How do I go about saving site: template.domain.com so I can use it to create the new sites? Thank you, Scott<- Tag: Import data from Excel Tag: 59026
  - 18
    - WSS V2 question We have a public WSS site and another group wishes to pull an active events web part element that resides on the public WSS site and place it in another public web site. Anyone know if this is possible? Jim Tag: Import data from Excel Tag: 59025
  - 19
    - Consuming WSS Web Services with Form Based Authentication Hello! I am using Form based Authentication in my WSS 3.0 site....i want to use SharePoint Web Services but authorization is not granted with Form Based Authentication. I can only consume "Authentication" web service.... Access on all other web services is Denied.... What to do??? Can anybody tell me some solution With Regards Omer! Tag: Import data from Excel Tag: 59022
  - 20
    - [WSS 3] - Searching parent and all children Hi, Is it possilble with just WSS3 to set the search scope to search parent sites and all child sites within. For example Parent 1 | ----------------- | | Child 1 Child 2 Each of the sites are a subsite from Parent 1. When searching (default settings) from Parent 1 you can get results of everything below, when searching Child1 you only get results from Child1 and any subsites below. Can this be changed, also I would like the search box to be the only component displayed removing the drop down. Regards Timothy Merridew Tag: Import data from Excel Tag: 59021
  - 21
    - Web Part AUthentication Request Hi, I am very new to WSS and need some help! I have used the web part for viewing a web page to view an online version of a public calendar which is held on the exchange server. This works great, however, it asks for authentication. Is there a way to stop this either by hard coding authentication into the web part or any other way? Or is their another way to view the public calendar? If any of this is possible could you let me know how? Thanks, -- Chidge Tag: Import data from Excel Tag: 59015
  - 22
    - Consuming wss web services from asp Hi, I need to access wss objects via web services from asp (not .net) pages. Do you think is it possible? Some one has an example code? Thanks Tag: Import data from Excel Tag: 59013
  - 23
    - Errors in upgrade.log when upgrading from WSS 2.0 to WSS 3.0 I am doing a test upgrade from WSS 2.0 to WSS 3.0 and have run into a problem. I ran prescan on my WSS 2.0 server, and it finished with the line: 05/03/2007 11:27:52 Scan finished without failure. I have then performed the database migration version of the upgrade. I finally get to the addcontentdb bit of it, and the upgrade log has got 449 errors, all of which seem to be the same and none of which I can make sense of. I can post the whole file if anyone wants it, but the line in question is: [SPWebTemplateSequence] [ERROR] [5/9/2007 9:58:20 AM]: Template STS#0: SPSite Id=205e375a-c478-478f-99fe-e9005f1c1bf6 could not be accessed due to exception. Skipping SPWeb Id=2a9af305-3878-427b-9afd-908d1497409a for template upgrade. Exception: System.IO.FileNotFoundException: The site with the id 205e375a-c478-478f-99fe-e9005f1c1bf6 could not be found. at Microsoft.SharePoint.SPSite..ctor(Guid id, SPFarm farm, SPUrlZone zone, SPUserToken userToken) at Microsoft.SharePoint.SPSite..ctor(Guid id) I'm not quite sure what this means, so any help would be very much appreciated. Thanks in advance, Tom. Tag: Import data from Excel Tag: 59011
  - 24
    - notifications not working Notifications on wss our has suddenly stopped working and we are having problems finding the problem. We get no errors in the eventlog and would like some help about how to find the problem. Any suggestions? Tag: Import data from Excel Tag: 59010
  - 25
    - migrate the sharepoint DB/content/sites to another SQL and SPP servers Hi...We are in process of retiring one Sharepoint Portal 2003 server and one SQL 2000 server into new SPP and SQL 2005 servers. Can you point out what is the steps and documentation to do so? Can I use SQL backup and restore to migrate the configuration and content databases, and using Sharepoint's backup / restore tool to move the sites? Thanks, fshguo Tag: Import data from Excel Tag: 59008

I have a form library in Sharepoint set up which uses an Infopath
form. The data which will be stored in the form library will
initially is currently loaded in an excel spreadsheet.

Is there any way to load the data from the spreadsheet into the form
library without inputting it manually?

Top