Tuesday, September 22, 2015

SharePoint App Side loading feature

If you want to develop and test quickly the SharePoint 2013 App model , You can do so by just enabling the "App side loading " feature on your site.

Strictly you can follow this practice for development and testing the third party app on your non developer site.

Powershell command for enabling the app side loading feature.

Enable-SPFeature e374875e-06b6-11e0-b0fa-57f5dfd72085 –url sitename

Friday, September 18, 2015

Access App - SharePoint 2013


Pros: 
  1. Access app can be created within Office 2013 client and pointing to Office 365 or On-Premise site collection 
  1. Can be use two way of authorization (app only permission , app+user permission). 
  1. Can leverage the multi authentication including the OAuth. 
  1. Access App can be created from data sources like SQL , Web Service, Excel and flat files (.txt & CSV) 
  1. App can be saved as "Snapshot" including with data , in order to move the app around all the site collections and tenants. 
  1. Supports the Form kind of operation and compatible with all devices. 
  1. Clear navigation path and multiple app templates available for Look and Feel good. 
  1. Support the Reporting , sorting and filter. 
  1. Can be editable in the Grid View Format (as seen in SharePoint 2013 List) 
  1. Can be used to run the old Access database with all Macro features that gives the business logic implementation. 
  1. built-in search functionalities to search the huge records. 



cons: 

  1. Office WebApp must have installed in all WFEs and involved licensing model. 
  1. No option to trigger the SharePoint Workflow or Item level permission. 
  1. Must have SQL 2012 Enterprise edition installed as Access App uses the SQL table behind the scene. 
  1. Access 2010 and Access 2013 app services must be up and running on the Server, Access 2010 services also required for backward compatibilities. 
  1. SharePoint App configuration (DNS Set up) must be installed and configured on the Server as Access App model relies on the SharePoint App mechanism. 
  1. Often crash as it requires relies on the installed Office Web App in SharePoint server. 
  1. Must have the dedicated Site collection for Access app to manage identical app. 

Wednesday, September 09, 2015

InfoPath 2013 - Full Trust Code

If you are working in InfoPath form with source code, you must elevate your form to "Full Trust" as its required to access the SharePoint server and its files.

On design , Select the file->Form Option->under Security and Trust category, select the "Full trust" security level and save and publish.

Here is the simple entry form with three column,that will insert the item in SharePoint list through C# object model.






public void CTRL5_5_Clicked(object sender, ClickedEventArgs e)
        {
            using (SPSite FormSite = new SPSite("http://win-oq6s840ais1/"))
            {
                using (SPWeb FormWeb = FormSite.OpenWeb())
                {

                    SPList list = FormWeb.Lists["Register"];
                    SPListItem item = list.Items.Add();
                 
                    item["Title"] = GetDomValue("/my:myFields/my:ddlTitle");
                    item["FirstName"] = GetDomValue("/my:myFields/my:txtFirstName");

                    item["LastName"] = GetDomValue("/my:myFields/my:txtLastName");

           
                    FormWeb.AllowUnsafeUpdates = true;
                    item.Update();

                    // Set AllowUnsafeUpdates back to 'false' to prevent further updates to the database.
                    FormWeb.AllowUnsafeUpdates = false;

                }
            }
        }





        private string GetDomValue(string XpathToGet)
        {
            return this.CreateNavigator().SelectSingleNode(XpathToGet, this.NamespaceManager).Value;
        }