Thursday, December 19, 2013

Installing Office web Apps 2013 components For SharePoint 2013

Installing Office web Apps 2013 components For SharePoint 2013

Definition:

Office Web Apps was first introduced with SharePoint.  Office Web Apps is an online version of Microsoft Word, Excel, PowerPoint and One Note allowing users to access these applications and their respective documents from any Internet connection and most notable web browsers.  For those running SharePoint 2013, you can deploy Office Web Apps onto your SharePoint farm providing your users with the same functionality as the online version of Office Web Apps.  Deploying Office Web Apps on your SharePoint farms will add the following service applications;

·        Word Viewing Service Application
·        Excel Calculation Service
·        PowerPoint Service Application

will be extending my step by step SharePoint 2013 configuration articles and by the end of this post you will be able to open and edit Office documents from within your web browser without the requirement of having Microsoft Office installed locally.  This is a huge productivity gain for those that might be accessing their SharePoint sites from an Office is usually not available.

·        Pre-Requisites: Follow the Pre-requisite software’s to install OWA 2013.Follow the below mentioned order to avoid errors below.
                                                  
                             
                       
1.      dotNetFx40_Full_setup
2.      Power shell V3 Windows6.1-KB2506143-x64

3.      IIS 7.0 or higher
4.      .Net Frame work 4.5


 Installation:

1.     You can download Office-2013 components for SharePoint-2013 from below MS site.


2.     once the Components are downloaded local, It will download as .IMG file.
3.     We need to have WINRAR in system to Archive and Extract the file.
4.     Click on the setup file
                
                   

5.     Accept Agreements
                                   

6.     Choose the path where you want to locate the files.
7.     Click on Install Now.
8.     Click Close.
                 


Once the Installation is done, Follow the below steps to Connect OWA with SharePoint.

1.   Logon to the OWA server as the account with which you performed the install.
2.   Open Windows Power Shell by right-clicking on it and choose Run as Administrator.
3.   Type the following line and press Enter to load the Office  Web Apps Power Shell cmdlets:

                        Import-Module OfficeWebApps

4.   To create the farm, type the following Power Shell command and press Enter:

 New-OfficeWebAppsFarm –InternalURL http://OWA.contoso.com -AllowHttp–EditingEnabled:$true

5.   Acknowledge yes, that you are enabling this specific functionality, by pressing Enter when
6.   prompted.
7.   When completed, you will receive the OWA summary farm confirmation shown in Figure

                    
         
8.   That completes the installation and configuration of the Office Web Apps farm. From here you need
9.   to bind that farm to whichever host you choose. In this case, the next section steps you through
10. binding the Office Web Apps farm with the SharePoint 2013 farm. You will bind to the SharePoint farm using HTTP.

  The final step is the connection of SharePoint and OWA using HTTP.
1.   Remote desktop to the SharePoint server
2.   Open the SharePoint Management Shell by right-clicking on the icon and run it as an
3.   administrator.
4.   To create a binding between the SharePoint 2013 farm and the new OWA 2013 farm, run
5.   the following command and press Enter:

           New-SPWOPIBinding –Server Name owa.contoso.com –Allow HTTP

                  6. Set up a zone that instructs SharePoint to communicate with OWA 2013:
                  Set-SPWopiZone –zone "internal-http"

          Now SharePoint is ready to take advantage of the Office Web Apps.


Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

The update is not applicable to your computer

  The update is not applicable to your computer                       
                               
 

     Issue: while running  one of pre-requisite, Power shell V3 Windows6.1-KB2506143-x64 to install Office WebApp-2013 components, Got the error” The update is not applicable to your computer”

     Solution: To install the Power shell V3 Windows6.1-KB2506143-x64,we must install “dotNetFx40_Full_setup” as a prior. Once we install .Net 4.0,the power shell V3 will run smoothly. Follow the order.

1.      dotNetFx40_Full_setup
2.      Power shell V3 Windows6.1-KB2506143-x64



Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

Wednesday, December 18, 2013

We are sorry We ran into a problem completing your request

We are sorry We ran into a problem completing your request
                       



 Issue: Once uploaded all the Excel files in the SharePoint site. When we try to open the files in browser gives the error” We are sorry. We ran into a problem completing your request

 Cause: Excel services are not configured in farm to open the Excel sheets.

 Solution: Ensure to follow the below steps to resolve the issue.

· Ensure that the Excel Calculation Services  is in started state.
        Go to Application Management->Manage services on server under service       application
                    
                                      

     · Ensure that the Excel service Application configured and started properly.
      Go to Application Management->Manage services application under service             application
   
                                

Once Both the above steps done properly. Check To open the Excel in site.

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

SharePoint Server 2013 Drag and drop Functionality

SharePoint Server 2013 Drag and drop Functionality

                         


To have the drag and drop feature to SharePoint Server 2013, below are the scenario or requirements of Web browsers.

·         Internet Explorer 10
·         Internet Explorer 9 with Office 2013 Installed
·         Internet Explorer 8 with Office 2013 Installed
·         Firefox latest version
·         Chrome latest version



Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

How to Upload Multiple documents in SharePoint 2013

 How to Upload Multiple documents in SharePoint 2013

The "Upload Multiple" Documents option is deprecated in SharePoint 2013.we can use the below ways to upload multiple documents.

§  Drag-and-Drop functionality.

§  Windows Explorer view 

 Method 1 : Using the drag-and-drop functionality

Microsoft has done an incredible job by adding this feature to the highly popular document libraries. On any document library you can now simply Drag and Drop the document and it will be upload with a quick progress bar.
Simply select multiple document from local and drag it onto the document library. The window will change to “Drop here..”
                                 
                                



You can see the Upload documents Status bar next at the Document Libraries title.
You would see Upload Complete once the upload completes.

Note: Feature will not work with the IE version Internet Explorer version 8.0.6001.18702IC


  Method 2 : Windows Explorer view

To Open Windows Explorer click on Upload Document button as shown in picture below
                           

                

Next in the Add Documents popup click on “Upload Files using windows Explorer Instead”
                                                     


we will expect the following error

                             



To resolve this add the SharePoint site as Trusted in your Browser and Make sure that the Web Client service is running. Follow step below to resolve this.

  Click Start, click Run, type services.msc, and then press Enter.In the list of services, locate the Web Client service, and then make sure that its status in the Status column is set to Started. If its status is not set to Started, double-click Web Client, click Start, and then click OK.

Once done restart the browser and try opening the Windows Explorer again. In the Windows Explorer you can copy and paste Multiple documents as done in earlier SharePoint versions.

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

ShareThis

X