A free JavaScript image gallery framework for image galleries used in SharePoint

A free JavaScript image gallery framework for image galleries used in SharePoint.
Go to SharePoint Site -> Doc1 -> ImageSlider Folder and upload few images as shown below..

Go to Site Assets Library and upload JS files into Library.

Go to any page -> Edit Page -> add content editor web part (CEWP ) and add below script to web part.

<!DOCTYPE html>

<html lang="en" xmlns="http://www.w3.org/1999/xhtml">

<head>

    <meta charset="utf-8">

    <title></title>

    <style>

        html, body {

            background: #222;

            margin: 0;

        } 

        body {

            border-top: 4px solid #000;

        } 

        .content {

            color: #777;

            font: 12px/1.4 "helvetica neue",arial,sans-serif;

            width: 620px;

            margin: 20px auto;

        } 

        h1 {

            font-size: 12px;

            font-weight: normal;

            color: #ddd;

            margin: 0;

        } 

        p {

            margin: 0 0 20px;

        } 

        a {

            color: #22BCB9;

            text-decoration: none;

        } 

        .cred {

            margin-top: 20px;

            font-size: 11px;

        } 

        #galleria {

            height: 320px;

        }

    </style>

</head>

<body>

    <!--<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.5.1/jquery.min.js"></script>

    <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jquery.SPServices/2014.02/jquery.SPServices-2014.02.min.js"></script>-->

    <script type="text/javascript" src="/SiteAssets/jquery.min.js"></script>

    <script type="text/javascript" src="/SiteAssets/jquery.SPServices-2014.02.min.js"></script>
<script language="javascript" type="text/javascript">

        $.noConflict();

        var varListName = "Doc1";

        var folderName = "/Doc1/ImageSlider";

        var folderName1 = "/Doc1/ImageSlider/";

        //var folderName = "/sites/dev/Doc1/ImageSlider"; //for Site Collection

        //var folderName1 = "/sites/dev/Doc1/ImageSlider/"; //For Site Collection

        jQuery(document).ready(function ($) {

            $().SPServices({

                operation: "GetListItems",

                async: false,

                webURL: "https://sreekanth5.sharepoint.com/",

                //webURL: "https://sharepointonline01.sharepoint.com/sites/dev/", //for Site Collection

                listName: varListName,

                CAMLViewFields: "<ViewFields><FieldRef Name='LinkFilename'/></ViewFields>",

                CAMLQueryOptions: "<QueryOptions><Folder>" + folderName + "</Folder></QueryOptions>",

                completefunc: function (xData, Status) {

                    $(xData.responseXML).find("[nodeName='z:row']").each(function () {

                        var liHtml = $(this).attr("ows_LinkFilename");

                        console.log(liHtml);

                        $("#galleria").append("<a href='" + folderName1 + liHtml + "'><img src='" + folderName1 + liHtml + "', data-big='" + folderName1 + liHtml + "' data-title='' data-description=''></a>");                     

                    });

                }

            });

            loadGalleria()

        });

    </script>

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1/jquery.js"></script>

<script src="https://cdnjs.cloudflare.com/ajax/libs/galleria/1.4.7/galleria.min.js"></script><script src="https://cdnjs.cloudflare.com/ajax/libs/galleria/1.4.7/themes/classic/galleria.classic.min.js"></script>

<script>

        function loadGalleria() {

            Galleria.run('#galleria');

        }

</script>

    <div class="content">

        <div id="galleria"></div>

    </div>

</body>

</html>

Save page and check the result as shown below. 

The custom code in the form cannot be run This functionality may be deactivated on the server InfoPath Issue in SharePoint

"The custom code in the form cannot be run. This functionality may be deactivated on the server. For more information, contact the server farm administrator.
Click OK to resume filling out the form. You may want to check your form data for errors."

This is the below issue.

Problem is "Microsoft SharePoint Foundation Sanboxed Code Service" is stopped.

Restart the "Microsoft SharePoint Foundation Sanboxed Code Service".

Then check InfoPath now. I hope it should work.

Get ListItem Attachments using Iterating Large SharePoint Lists with PowerShell

Get ListItem Attachments using Iterating Large SharePoint Lists with PowerShell.

$SPAssignment = Start-SPAssignment

$webUrl = "http://sharepointurl:1234/"   

$listname = "ListDisplayName"  

$destinationfolder = "c:\backupfiles"    

$site = new-object Microsoft.SharePoint.SPSite($webUrl)   

$web = $site.OpenWeb()        

$list = $web.Lists[$listname] 

$spQuery = New-Object Microsoft.SharePoint.SPQuery

$query = '<Where><IsNotNull><FieldRef Name="ID" /></IsNotNull></Where>'

$spQuery.ViewAttributes = "Scope = 'Recursive'"

$spQuery.Query = $query

$spQuery.RowLimit = 2000

Write-Host "    ItemCount: " $list.ItemCount

do

{

    $spListItemCol = $list.GetItems($spQuery)

    $spQuery.ListItemCollectionPosition = $spListItemCol.ListItemCollectionPosition        

       foreach ($listItem in $spListItemCol)

       {

              Write-Host "    Item ID: " $listItem.ID      

              if (!(Test-Path -path $destinationfolder))       

              {           

                     $dest = New-Item $destinationfolder -type directory         

              }

              foreach ($attachment in $listItem.Attachments)   

              {       

                     $file = $web.GetFile($listItem.Attachments.UrlPrefix + $attachment)       

                     $bytes = $file.OpenBinary()               

                     $path = $destinationfolder + "\" + $listItem.ID + "_" + $attachment

                     Write "Saving $path"

                     $fs = new-object System.IO.FileStream($path, "OpenOrCreate")

                     $fs.Write($bytes, 0 , $bytes.Length)   

                     $fs.Close()   

              }

       }

}

while ($spQuery.ListItemCollectionPosition -ne $null)
Stop-SPAssignment $SPAssignment

Export SharePoint List to Excel

Export SharePoint List to Excel

go to ExportToExcel.ascx add below code.

<%@ Assembly Name="$SharePoint.Project.AssemblyFullName$" %>

<%@ Assembly Name="Microsoft.Web.CommandUI, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%@ Register Tagprefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%@ Register Tagprefix="asp" Namespace="System.Web.UI" Assembly="System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" %>

<%@ Import Namespace="Microsoft.SharePoint" %>

<%@ Register Tagprefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="ExportToExcel.ascx.cs" Inherits="ExportToExcel.ExportToExcel.ExportToExcel" %>

<table>

    <tr id="trExportToExcel" runat="server">

        <td>

            <asp:Button ID="btnExcel" runat="server" Text="Export to Excel" OnClick="btnExcel_Click" />

        </td>

    </tr>

    <tr>

        <td>

            <asp:Label ID="lblError" runat="server"></asp:Label>

        </td>

    </tr>

</table>

go to ExportToExcel.ascx.cs add below code.

using Microsoft.SharePoint;

using System;

using System.ComponentModel;

using System.Data;

using System.IO;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts; 

namespace ExportToExcel.ExportToExcel

{

    [ToolboxItemAttribute(false)]

    public partial class ExportToExcel : WebPart

    {

        public ExportToExcel()

        {

        } 

        protected override void OnInit(EventArgs e)

        {

            base.OnInit(e);

            InitializeControl();

        } 

        protected void Page_Load(object sender, EventArgs e)

        {

        } 

        protected void btnExcel_Click(object sender, EventArgs e)

        {

            try

            {

                trExportToExcel.Visible = true;

                SPWeb oWeb = SPContext.Current.Web;

                SPBasePermissions perms = SPBasePermissions.ViewListItems;

                if (oWeb.DoesUserHavePermissions(SPBasePermissions.EnumeratePermissions))

                {

                    SPList oList = oWeb.Lists["test"];

                    SPUser oCurrentUser = oWeb.CurrentUser;

                    bool hasPermission = oList.DoesUserHavePermissions(oCurrentUser, perms);

                    if (hasPermission)

                    {

                        if (oList != null)

                        {

                            SPQuery qrylegalcases = new SPQuery();

                            qrylegalcases.Query = "<Where><IsNotNull><FieldRef Name='ID'/></IsNotNull></Where>";

                            SPListItemCollection itemslegalcases = oList.GetItems(qrylegalcases);

                            try

                            {

                                DataTable dt = new DataTable();

                                if (itemslegalcases.Count > 0)

                                {

                                    dt = itemslegalcases.GetDataTable();

                                }

                                ExportToExce(dt);

                            }

                            catch (Exception ex)

                            {

                                lblError.Text += " ## " + ex.Message + " # " + ex.StackTrace;

                            }

                        }

                        else

                        {

                            lblError.Text += "List deos not exist.";

                        }

                    }

                    else

                    {

                        lblError.Text += "You don't have permission to list.";

                    }

                }

                else

                {

                    lblError.Text += "You don't have permission to site.";

                }

            }

            catch (Exception ex)

            {

                lblError.Text += " ## " + ex.Message + " # " + ex.StackTrace;

            }

        } 

        private void ExportToExce(DataTable dt)

        {

            GridView GridView1 = new GridView();

            GridView1.AllowPaging = false;

            GridView1.DataSource = dt;

            GridView1.DataBind(); 

            HttpContext.Current.Response.Clear();

            HttpContext.Current.Response.Buffer = true;

            HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=ExportToExcel.xls");

            HttpContext.Current.Response.Charset = "";

            HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";

            StringWriter sw = new StringWriter();

            HtmlTextWriter hw = new HtmlTextWriter(sw);

            for (int i = 0; i < GridView1.Rows.Count; i++)

            {

                GridView1.Rows[i].Attributes.Add("class", "textmode");

            }

            GridView1.RenderControl(hw);

            string style = @"<style> .textmode { mso-number-format:\@; } </style>";

            HttpContext.Current.Response.Write(style);

            HttpContext.Current.Response.Output.Write(sw.ToString());

            HttpContext.Current.Response.Flush();

            HttpContext.Current.Response.End();

        } 

    }

}

deploy code and check.