SharePoint 2013 integration to Outlook

SharePoint 2013 supports connection to MS Outlook application in order to collaborate and coordinate activities and projects and to improve business efficiency and productivity, especially if you work offline and don’t have instant access to your SharePoint sites all the time.

You can synchronize information in two directions for items in Contacts lists, Calendars, Tasks lists.

But you should keep in mind that, unlike Contacts and Calendars, syncing SharePoint Tasks with Outlook relies on the installation of Exchange Server 2013 within your organization.

SharePoint Server 2013 and Exchange Server 2013 must both be installed in the same environment. Otherwise, you will not be able to accomplish this, in spite of the “Sync to Outlook” button will still be active.

How to: Create and publish InfoPath 2013 template to a SharePoint 2013 Enterprise site

This article will give you a walk-through for the process of creating and publishing an InfoPath 2013 template to a SharePoint 2013 Enterprise site.
  1. Run the Microsoft InfoPath Designer 2013.
  2. Go to the File tab, click SharePoint Form Library located at the New tab and click Design Form at the right side.
    How_to_create_and_publish_InfoPath_2013_template_to_a_SharePoint_2013_1
  3. Create an InfoPath template or you can open an existing InfoPath template that you want to publish to your SharePoint site.
    How_to_create_and_publish_InfoPath_2013_template_to_a_SharePoint_2013_2
  4. Go to the File tab and choose Publish form to a SharePoint Library by clicking at the SharePoint Server icon located at the Publish tab.
    How_to_create_and_publish_InfoPath_2013_template_to_a_SharePoint_2013_3
  5. Type the URL of the SharePoint 2013 site where you want to publish the Info Path template and click Next.
    How_to_create_and_publish_InfoPath_2013_template_to_a_SharePoint_2013_4
  6. Type your credentials and click OK. Please make sure that you have all required permissions to publish template at the SharePoint 2013 site.
  7. Choose the required configuration and click the Next button.
  8. You can choose an existing library to publish your InfoPath template or create a new library for the publishing your InfoPath template.
    How_to_create_and_publish_InfoPath_2013_template_to_a_SharePoint_2013_5
  9. If you have selected “Create a new library” complete the required fields with the name and the description of the new InfoPath library and click the Next button.
    How_to_create_and_publish_InfoPath_2013_template_to_a_SharePoint_2013_6
  10. Add columns if required or just skip this step by clicking the button Next.
  11. Verify the form information and then click Publish.
    How_to_create_and_publish_InfoPath_2013_template_to_a_SharePoint_2013_7
  12. When your InfoPath form template is published click at the Open this form in the browser link and then Close.
    How_to_create_and_publish_InfoPath_2013_template_to_a_SharePoint_2013_8
  13. Click the floppy icon to save your template at the SharePoint library.
    How_to_create_and_publish_InfoPath_2013_template_to_a_SharePoint_2013_9
  14. Type the name of your InfoPath template and click the Save button.
    How_to_create_and_publish_InfoPath_2013_template_to_a_SharePoint_2013_10
  15. You can see your InfoPath template at your SharePoint site.
    How_to_create_and_publish_InfoPath_2013_template_to_a_SharePoint_2013_11

Exchange Server 2016 overview

Since email remains a key element in every business, it is vital to use the most up-to-date and secure tools for business communications. The developers have improved Exchange Server 2016 integration with other Office products; cloud technologies, additional recovery functions and other elements have also been added.makes document sharing easier and eliminates version control problems. For example, in Outlook 2016 or Outlook browser version, you can now attach a document as a link to SharePoint 2016 or OneDrive for Business instead of a traditional attachment. Developers have also substantially improved Outlook web experience, by adding new features, such as Sweep, Pin, Undo, inline reply, a new single-line inbox view, improved HTML rendering, new themes, emoticons and more.

Improved search architecture delivers more accurate and complete results. Outlook 2016 is optimized to use the power of the Exchange 2016 backend to fasten search process. An intelligent search tool provides search suggestions, search refiners, people suggestions, and the facility to search events scheduled on your calendar.

Exchange 2016 has a reformed eDiscovery tool, with reliability improved by a new, asynchronous architecture, which spreads the work across multiple servers. It lets you search, hold, and export content located in public folders.

The developers has gained growth of overall productivity and stability, which come along with automated repair improvements and the Microsoft Exchange Server 2016 architecture characteristics, which simplify the process of planning hybrid and on-premises deployments.

“Site storage exceeded” error (part 2)

Following up the previous post, published in our blog last week, regarding the “Site storage exceeded” error, where two-stage SharePoint 2013 recycle bin origin was indicated as possible reason of running out of storage space on SharePoint 2013 site, we would like to point out another potential cause of such behavior. Version history enabled for the SharePoint list or library may lead to over occupation of storage space.

The version history contains information about when the item or file was changed, who changed it, and information about what was changed. In libraries, the version history might also contain comments written by the people who made changes. Which is very useful functionality for users’ collaboration, but also it can bring inconveniences with site storage management, since every version saved occupies actual file size on the site.

So, to free up some space on your SharePoint site, you should review version history for the “heaviest” files first to remove unnecessary and outdated versions.

Using MySQL database as a Datasource

How to connect to MySQL database from PowerPivot

One of the supported data sources that you can use to connect to your workbooks and create PowerPivot reports is MySQL database. But before creating such connection you need to make sure that the following requirements are fulfilled:

  • Make sure your MySQL server is binded on public IP address and accept traffic from PlexHosted`s SharePoint app server where your site is deployed, on default port 3306 (port 3306 used for demonstration purposes in this case).
  • You have a user that have read only permissions to required databases (root user is used for demonstration purposes in this case) GRANT ALL ON employees.* TO root@11.22.33.44′ IDENTIFIED BY ‘verysecurepassword’; or GRANT ALL ON employees.* TO root@’%’ IDENTIFIED BY ‘verysecurepassword’; (if you have a firewall)
  • Your Desktop machines which are building excel reports must have permissions to connect to your MySQL server using public IP address.
  • The MySQL Connector/ODBC has been installed on the machine from which you are going to connect to MySQL. You can download and install it from [here].
Creating a connection to MySQL database
  1. Open the Excel workbook you would like to connect to the database and go to the PowerPivot tab. In the PowerPivot tab click Manage.
    How_to_connect_to_MySQL_database_from_PowerPivot-1
  2. When the PowerPivot for Excel window opened, click on From Other Sources button in the Get External Data section.
    How_to_connect_to_MySQL_database_from_PowerPivot-2
  3. Choose Others (OLEDB/ODBC) option.
    How_to_connect_to_MySQL_database_from_PowerPivot-3
  4. Type the name for your connection and enter the connection sting using the pattern below:
    Provider=MSDASQL.1;Persist Security Info=True;Extended Properties=”DRIVER={MySQL ODBC 5.3 ANSI Driver};UID=readonlyuser;Server=11.22.33.44;Database=employees;Password=verysecurepassword;Option=3DRIVER={MySQL ODBC 5.3 ANSI Driver}”;Server=11.22.33.44;Database=employees;Option=3;”;
    Where:
    UID=<user with permissions to connect to your database>
    Password=<your user password>
    Server=<your MySQL server public IP address>
    Database=<your database name.
    After entering the connection string click on Test Connection button.
    How_to_connect_to_MySQL_database_from_PowerPivot-4 
  5. Click OK in the connection status window.
    How_to_connect_to_MySQL_database_from_PowerPivot-5
  6. Click Next.
    How_to_connect_to_MySQL_database_from_PowerPivot-6
  7. In the Table Import Wizard choose the option Write a query that will specify the data to import and click Next.
    How_to_connect_to_MySQL_database_from_PowerPivot-7 
  8. Enter the query to import the required data from the database and click Validate. Once you query is validated click Finish.
    How_to_connect_to_MySQL_database_from_PowerPivot-8
  9. The Table Import Wizard will start importing data from your database to the PowerPivot model. Once the status of the wizard changes to Success click Close.
    How_to_connect_to_MySQL_database_from_PowerPivot-9
     
  10. You can see the data imported to the model and can start creating your PowerPivot reports by clicking on the PowerPivot table button.
    How_to_connect_to_MySQL_database_from_PowerPivot-10

“Site storage exceeded” error

You are 100% sure you should have free space on your SharePoint 2013 site, but still getting “Site storage exceeded” error, when trying to upload some new content. Is this situation familiar to you?Let’s analyze what might be the cause of such behavior.

Make sure you have considered two-stage SharePoint 2013 recycle bin origin, as soon as files moved to recycle bin occupy the storage of the site, as if they were present in an ordinary SP library. Since the Recycle Bin in SharePoint 2013 provides two-stage protection against accidental deletions, you should delete files not only from the site’s recycle bin, but site collection’s recycle bin also.
To completely remove a file or an item from SharePoint site, check site collection’s recycle bin under Site Settings -> Site Collection Administration -> Recycle bin and clear up both locations:
– “End user recycle bin items”
– “Deleted from end user Recycle Bin”.
Try to upload new content then.