9/29/18

Passed the Security+ SY0-501 Exam



I recently passed the Security+ SY0-501 Exam.

Here are some study materials that I used to pass the exam..
  1. Practice exam questions here.
  2. Transcender exam questions, not free but available for purchase from here.
  3. The CompTia Certification Exam Objectives document available here.
  4. I also purchased ($14.99) a Security+ Practice tests on an iPhone app available here.
The test started with 4-5 simulation type questions that required dragging and dropping list items, the items were similar to these:
  1. Biometric reader
  2. Mantrap
  3. Cable lock
  4. Safe
  5. Locked cabinet
  6. Proximity reader
The simulations displayed diagrams where you could assign the appropriate list items.

One of the simulations involved configuring a wifi setup choosing from items like WPA2, Radius and having to configure the selection.


One showed an office and a data center and had options for things like proximity reader, cctv, biometric reader, etc.

There were a few questions showing log files and asked things like what is the vulnerability in the log file.

One had a help desk ticket with no text data, it just showed it was TCP and port 686 and asked what it pertained to.

One asked what was the best way to sanitize a removable device and had options like low level format, overwrite, etc. it didn't have options like degauss or purge or destroy.

One question asked about netcat and how to connect to ports. Know how to make a connection (nc -4 [host] [port number])

One asked the difference between arp poisoning and mac flooding, one answer was mac flooding works across routers.

These are some of the questions and topics that I remember from the exam, there is such a broad amount of material to study, it makes this exam pretty difficult.

Good Luck!

9/6/18

SharePoint 2019 Public Preview

Follow the link below to read the blog about the preview...

SharePoint 2019 Preview

Links


Download

4/6/17

SPFX Host a SharePoint solution's files in a SharePoint Online Document Library CDN


Introduction 

In my previous post

'SPFX SharePoint Online Responsive Web Part using the SharePoint Framework, Bootstrap, JQuery, JQuery Datatables and Toastr'

I demonstrated using the SharePoint Framework (SPFx) to create and deploy a solution to SharePoint Online (SPO), the solution referenced several JavaScript libraries that once deployed to SPO, would look back to the localhost dev environment for these libraries and other required files. This means that in order for the web part to be added to the page or viewed correctly the Gulp serve command must be initiated before you can successfully access the web part.

To cut this cord and make the solution self sufficient, a Content Delivery Network (CDN) must be provided to enable SharePoint to access the solution resources it needs to correctly render. All of the JavaScript libraries have externally hosted CDN's and these can be added to the project using the  method below for bringing in the libraries.

For example, in the webpart.ts file adding the following lines will allow the web part to reference css and 'js files.

import { SPComponentLoader } from '@microsoft/sp-loader';

SPComponentLoader.loadCss('https://maxcdn.bootstrapcdn.com/font-awesome/4.6.3/css/font-awesome.min.css');
SPComponentLoader.loadCss('https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css');

SPComponentLoader.loadScript('https://cdnjs.cloudflare.com/ajax/libs/jquery/3.1.1/jquery.min.js', { globalExportsName: 'jQuery' }).then((jQuery: any): void => {
SPComponentLoader.loadScript('https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/js/bootstrap.min.js',  { globalExportsName: 'jQuery' }).then((): void => {        
    });
});


But if we are referencing external JavaScript libraries and want these libraries un-bundled during the development process, which I prefer, these references would be included in the config.json file using the method below.

For example, to bring in JQuery and Toastr libraries, the following lines can be added to the config.json file in the externals section.

{
  "entries": [
    {
      "entry": "./lib/webparts/spfx/SpfxWebPart.js",
      "manifest": "./src/webparts/spfx/SpfxWebPart.manifest.json",
      "outputPath": "./dist/spfx.bundle.js"
    }
  ],
  "externals": {
    "jquery": {
      "path": "node_modules/jquery/dist/jquery.min.js",
      "globalName": "jQuery"
    },
     "toastr": {
      "path": "node_modules/toastr/toastr.js",
      "globalName": "jQuery"
    }
   },
  "localizedResources": {
    "spfxStrings": "webparts/spfx/loc/{locale}.js"
  }
}

Then in the webpart.ts file we can reference these external libraries using the following lines.

import * as jQuery from 'jquery';
import * as toastr from 'toastr';

This will cause the web part thats added to SharePoint Online to look back to the localhost 
development machine for these files. To change that, we'll make the following configuration updates.

Prerequisites

  1. SharePoint Online Tenant
  2. SharePoint Online Document Library Location for CDN/Files
  3. SharePoint Online Management Shell - Download

Create a CDN hosted on your SharePoint Online Tenant

Launch the SharePoint Online Management Shell and enter the following commands replacing
contoso with your tenant name.
#Authenticate to your tenant
$creds = Get-Credential
Connect-SPOService -Url https://contoso-admin.sharepoint.com/ -Credential $creds

#Enable Public CDN in the tenant
Set-SPOTenant -PublicCdnEnabled $true

#Create CDN to your SPO document library
New-SPOPublicCdnOrigin -Url "https://contoso.sharepoint.com/siteassets/folder1"

#Verify CDN successfully created
Get-SPOPublicCdnOrigins

Configure SharePoint Solution for CDN

Locate the write-manifest.json file in the config folder of the SharePoint solution
Update the file from this
{
  "cdnBasePath": "<!-- PATH TO CDN -->"
}
To this
{
  "cdnBasePath": "https://contoso.sharepoint.com/siteassets/folder1"
}

Create files for deployment

From the integrated terminal window type the following
Gulp --ship

This will create the files for deployment in the temp - deploy folder

Copy Files to SharePoint Online


Copy all of these files into the CDN folder at - https://contoso.sharepoint.com/siteassets/folder1

The document library should look similar to this
From the integrated terminal window type the following
Gulp package-solution --ship
Deploy the solution to the SharePoint App Catalog - Instructions for this can be found in my
previous post Here
You should no longer need to run Gulp serve for your web part to correctly render.

4/5/17

SPFX SharePoint Online Responsive Web Part using the SharePoint Framework, Bootstrap, JQuery, JQuery Datatables and Toastr

SPFx - Responsive Web Part

Introduction 


In this blog post I'll describe how to get going with the new SharePoint Framework and take an existing SharePoint Add-In detailed in a previous blog post Here and package this up using the recently released SharePoint Framework (SPFx).

This post describes building a SharePoint solution that includes a web part that reads data from a custom SharePoint list and allows full Create Read Update Delete (CRUD) functionality from a JQuery Datatables responsive client side grid. The SharePoint solution defines a custom list which will be provisioned with some default data and deployed to SharePoint using a feature. The responsive grid also uses Bootstrap for styling and modal dialogs presented when adding, deleting, editing and updating list data. In addition Toastr is used to display notifications when items are successfully deleted from the list.

There are some differences between the previous SharePoint Add-Inn and the new SPFx technique, for starters, I had to drop bootstrap-dialog because I could not get this working in the SPFx context. Instead I'll be using the Bootstrap Modal method which looks and feels the same.

The SharePoint Add-In will be modified using the latest tools and development techniques into a web part and deployed to SharePoint Online. A custom list will also be deployed to the SharePoint online site called SpfxFiles, the list will be pre-populated with 5 entries to display in the JQuery DataTables Grid. A SharePoint feature will be used to deploy the custom list.

Prerequisites

  1. Install NodeJS
  2. Install Visual Studio Code
  3. Install Yeoman and gulp
  4. Install Yeoman SharePoint generator
  5. SharePoint Online Tenant
  6. SharePoint Online App Catalog Site
  7. SharePoint Online Developer Site

Download Visual Studio Code Solution - Here

Steps

Create a new folder using Windows Explorer - name: Spfx

Launch Visual Studio Code and open the folder you just created

Open Folder

Select View | Integrated Terminal to allow running NodeJs commands from Visual Studio Code
    View - Integrated Terminal
From the Integrated Terminal Type: Yo to start the Yeoman SharePoint Generator and create a new project for this demonstration. 

Note: This is very similar to selecting File | New Project in Visual Studio, this will create the boiler plate code for getting a SharePoint solution created.
Type: yo
Select @microsoft/sharepoint
Select @microsoft/sharepoint
Enter a solution name: spfx
Enter a solution name: spfx
Select use the current folder for location to put the files
Select current folder
Select No JavaScript web framework
Select No JavaScript web framework
Enter a web part name: spfx
Enter a web part name: spfx

The project will take several minutes to complete, once this process is complete type the following commands - one at a time from the Integrated Terminal command line.

Node Packages/Types (Install these individually)

  1. npm install jquery --save
  2. npm install @types/jquery --save-dev
  3. npm install tether --save
  4. npm install @types/tether --save-dev
  5. npm install bootstrap --save
  6. npm install @types/bootstrap --save-dev
  7. npm install datatables.net --save
  8. npm install @types/datatables.net --save-dev
  9. npm install datatables-select --save
  10. npm install @types/datatables.net-select --save
  11. npm install toastr --save
  12. npm install @types/toastr --save
Verify jquery was installed correctly by expanding the node_modules folder in the spfx folder structure and scrolling down to the jquery folder, inside this folder should be a dist folder and inside that folder should be the file that will be referenced in the config.json file jquery.min.js. The remainder of the downloaded packages can be verified using this same method.


Include Node Packages in solution



Now that all of the required node packages have been installed, alter the web part code to include these packages in the solution.

Modify config.json


Starting with Jquery add the following lines to the config.json file in the config folder - externals section. These two libraries will be bundled separately from the other libraries in the project.

{
  "entries": [
    {
      "entry": "./lib/webparts/spfx/SpfxWebPart.js",
      "manifest": "./src/webparts/spfx/SpfxWebPart.manifest.json",
      "outputPath": "./dist/spfx.bundle.js"
    }
  ],
  "externals": {
    "jquery": {
      "path": "node_modules/jquery/dist/jquery.min.js",
      "globalName": "jQuery"
    },
     "toastr": {
      "path": "node_modules/toastr/toastr.js",
      "globalName": "jQuery"
    }
   },
  "localizedResources": {
    "spfxStrings": "webparts/spfx/loc/{locale}.js"
  }
}

There are multiple methods for including JavaScript libraries and css into a SharePoint solution, 
I'll demonstrate a couple of different ones. The first is to add the external library as a
non-bundled library by including an entry in the config.json externals shown above and then in the 
SpfxWebPart.ts file adding the following entries.

In the project folder structure expand the src folder, expand the webparts folder, expand the spfx
folder. In the spfx folder select the SpfxWebPart.ts file and add the following lines to near the 
top of the file.

import { SPComponentLoader } from '@microsoft/sp-loader';
import * as jQuery from 'jquery';
import * as toastr from 'toastr';

require('node_modules/tether/dist/js/tether.min.js');
require('node_modules/bootstrap/dist/js/bootstrap.min.js');
require('node_modules/datatables.net');
require('node_modules/datatables-select/dist/js/datatables.select.min.js');

SPComponentLoader.loadCss('https://cdnjs.cloudflare.com/ajax/libs/tether/1.4.0/css/tether.min.css');
SPComponentLoader.loadCss('https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/css/bootstrap.min.css');
SPComponentLoader.loadCss('https://cdn.datatables.net/1.10.13/css/jquery.dataTables.min.css');
SPComponentLoader.loadCss('https://cdnjs.cloudflare.com/ajax/libs/toastr.js/latest/toastr.min.css');
The first statement imports the SPComponentLoader which can be used to bring in javascript and css files from external sources.

The import statements above for jquery and toastr will bring in the files referenced in the config.json
externals section.
The second method for bringing in external JavaScript libraries is to use the require statement
used above and this will ensure the node modules that were pulled down earlier will be available
for use within the solution.
for both methods used above the css files will be referenced using the SPComponentLoader shown
above.
The entire SpfxWebPart.ts file will be shown here below
import { Version } from '@microsoft/sp-core-library';
import {
  BaseClientSideWebPart,
  IPropertyPaneConfiguration,
  PropertyPaneTextField
} from '@microsoft/sp-webpart-base';
import { escape } from '@microsoft/sp-lodash-subset';
import { SPComponentLoader } from '@microsoft/sp-loader';
import styles from './Spfx.module.scss';
import * as strings from 'spfxStrings';
import { ISpfxWebPartProps } from './ISpfxWebPartProps';

import * as jQuery from 'jquery';
import * as toastr from 'toastr';

require('node_modules/tether/dist/js/tether.min.js');
require('node_modules/bootstrap/dist/js/bootstrap.min.js');
require('node_modules/datatables.net');
require('node_modules/datatables-select/dist/js/datatables.select.min.js');

SPComponentLoader.loadCss('https://cdnjs.cloudflare.com/ajax/libs/tether/1.4.0/css/tether.min.css');
SPComponentLoader.loadCss('https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/css/bootstrap.min.css');
SPComponentLoader.loadCss('https://cdn.datatables.net/1.10.13/css/jquery.dataTables.min.css');
SPComponentLoader.loadCss('https://cdnjs.cloudflare.com/ajax/libs/toastr.js/latest/toastr.min.css');

export default class SpfxWebPart extends BaseClientSideWebPart<ISpfxWebPartProps> {

  public render(): void {
    this.domElement.innerHTML = `
    
     <div class="container">
        <h1><span class="label label-primary">SPFX Grid Data Consumed via SharePoint Rest API</span></h1>
        <div id="toolbar">
            <button type="button" value="Files" class="btn btn-info" onclick="Javascript: location.href = '../Lists/SpfxFiles'"><span class='glyphicon glyphicon-upload'></span> File List</button>
            <button type="button" class="btn btn-success addNewFile"><span class='glyphicon glyphicon-plus'></span> Add New File</button>
        </div>
   <p></p>
 <div id="FilesPanel">
 <table style="width: 100%;">
 <tr>
     <td>
        <div id="FilesGrid" style="width: 100%"></div>
     </td>
 </tr>
 </table>
 </div>
  
 <!-- Bootstrap Modal Dialog for new/edit files-->
<div class="modal fade" id="myModalNorm" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <!-- Modal Header -->
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal">
                       <span aria-hidden="true">&times;</span>
                       <span class="sr-only">Close</span>
                </button>
                <h4 class="modal-title" id="myModalLabel">
                    Add New File
                </h4>
            </div>
            <!-- Modal Body -->
            <div class="modal-body" id="modalBody">
                <form role="form" id="fileForm">
                  <div class="form-group">
                    <label>File Title</label>
                      <input class="form-control" id="fileTitle"/>
                  </div>
                  <div class="form-group">
                    <label>File Name</label>
                      <input class="form-control" id="fileName"/>
                  </div>
                  <div class="form-group">
                    <label>File Type</label>
                      <input class="form-control" id="fileType"/>
                  </div>
                     <div class="form-group">
                    <label>Team</label>
                      <input class="form-control" id="team"/>
                  </div>
                  <!-- hidden controls -->
                  <div style="display: none">
                      <input id="etag" />
                      <input id="fileId" />
                  </div>
                  </form>
                  <div class="modal-footer">
                      <button type="button" class="btn btn-danger" data-dismiss="modal" onclick='updateFormLabel();'>
                        Cancel
                      </button>
                      <button type="submit" class="btn btn-primary" id="fileFormSubmit">
                        Submit
                      </button>
                  </div>
            </div>
        </div>
    </div>
</div>
</div>
 <!-- Bootstrap Modal Dialog for delete files-->
<div class="modal fade" id="deleteFiles" tabindex="-1" role="dialog" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <!-- Modal Header -->
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal">
                       <span aria-hidden="true">&times;</span>
                       <span class="sr-only">Close</span>
                </button>
                <h4 class="modal-title" id="myModalLabel2">
                    Delete Confirmation
                </h4>
            </div>
            <!-- Modal Body -->
            <div class="modal-body" id="modalBody2">
                <p>Are you sure you wish to delete this item?</p>
                 <form role="form" id="deleteForm">
                  <!-- hidden controls -->
                  <div style="display: none">
                      <input id="deleteId" />
                  </div>
                  </form>
                  <div class="modal-footer">
                      <button type="button" class="btn btn-danger" data-dismiss="modal" '>
                        Cancel
                      </button>
                      <button type="submit" class="btn btn-primary" id="deleteConfirmationSubmit">
                        Submit
                      </button>
                  </div>
            </div>
        </div>
    </div>
`;
    var RestUrl = "../_api/lists/getbytitle('SPFxFiles')/items";
    $(document).ready(function () {
        PopulateGrid();
        $('#fileFormSubmit').click(function (e) {
            //Check for edit or new and call update or add function
            if ($('#myModalLabel').html() == 'Add New File') {
                addFile($('#fileTitle').val(), $('#fileName').val(), $('#fileType').val(), $('#team').val());
            } else {
                UpdateFiles($('#fileId').val());
            }
        });
        $('#deleteConfirmationSubmit').click(function (e) {
          var restUrl = "../_api/web/lists/GetByTitle('SPFxFiles')/items(" + $('#deleteId').val() + ")";
          jQuery.ajax({
              url: restUrl,
              type: "DELETE",
              headers: {
                  Accept: "application/json;odata=verbose",
                  "X-RequestDigest": $("#__REQUESTDIGEST").val(),
                  "IF-MATCH": "*"
              }
          });
          toastr.success("File Successfully Deleted.", "Success");
          //PopulateGrid();
        });
    });
  
function PopulateGrid() {
    //Clear datatables
    $('#FilesGrid').empty();
    //Get File list items
    $.ajax({
        url: RestUrl,
        method: "GET",
        headers: {
            "accept": "application/json;odata=verbose"
        },
        success: function (data) {
            if (data.d.results.length > 0) {
                //construct HTML Table from the JSON Data
                $('#FilesGrid').append(GenerateTableFromJson(data.d.results));
                //Bind the HTML data with Jquery DataTable
                var oTable = (<any>$('#FilesTable')).DataTable({
                    //control which datatable options available
                    dom: 'Bfrltip',
                    //add select functionality to datatable
                    select: true,
                    //adjust column widths
                    "columns": [
                    null,
                    null,
                    null,
                    null,
                    null,
                    { "width": "8%" }
                    ],
                    //remove sort icon from actions column
                    "aoColumnDefs": [
                    { "bSortable": false, "aTargets": [5] }
                    ]
                });
            } else {
                $('#FilesGrid').append("<span>No Files Found.</span>");
            }
        },
        error: function (data) {
            $('#FilesGrid').append("<span>Error Retreiving Files. Error : " + JSON.stringify(data) + "</span>");
        }
    });
};
//Generate html table values
function GenerateTableFromJson(objArray) {
    var tableContent =
        '<table id="FilesTable" class="table table-striped table-bordered" cellspacing="0" width="100%">' +
            '<thead><tr>' + '<th>ID</th>' + '<th>Title</th>' + '<th>FileName</th>' + '<th>FileType</th>' +
            '<th>Team</th>' + '<th>Actions</th>' + '</tr></thead>';
    for (var i = 0; i < objArray.length; i++) {
        tableContent += '<tr>';
        tableContent += '<td>' + objArray[i].Id + '</td>';
        tableContent += '<td>' + objArray[i].Title + '</td>';
        tableContent += '<td>' + objArray[i].SPFxFileName + '</td>';
        tableContent += '<td>' + objArray[i].SPFxFileType + '</td>';
        tableContent += '<td>' + objArray[i].SPFxTeam + '</td>';
        tableContent += "<td><a id='" + objArray[i].Id + "' href='#' style='color: orange' class='confirmEditFileLink'>" +
            "<i class='glyphicon glyphicon-pencil' title='Edit File'></i></a>&nbsp&nbsp";
        tableContent += "<a id='" + objArray[i].Id + "' href='#' style='color: red' class='confirmDeleteFileLink'>" +
            "<i class='glyphicon glyphicon-remove' title='Delete File'></i></a>&nbsp&nbsp";
        tableContent += "<a id='" + objArray[i].Id + "' href='#' class='confirmListItemDetailsLink'>" +
            "<i class='glyphicon glyphicon-cog' title='Link to List Item'></i></a></td>";
        tableContent += '</tr>';
    }
    return tableContent;
};
// Edit button click event
$(document).on('click', '.confirmEditFileLink', function (e) {
    e.preventDefault();
    var id = this.id;
    var requestUri = "../_api/web/lists/getByTitle('SPFxFiles')/items(" + id + ")";
    $.ajax({
        url: requestUri,
        method: "GET",
        contentType: "application/json;odata=verbose",
        headers: { "accept": "application/json;odata=verbose" },
        success: function (data) {
            $('#fileTitle').val(data.d.Title);
            $('#fileName').val(data.d.SPFxFileName);
            $('#fileType').val(data.d.SPFxFileType);
            $('#team').val(data.d.SPFxTeam);
            $('#fileId').val(data.d.Id);
            $('#myModalLabel').html('Edit File');
            (<any>$('#myModalNorm')).modal('show');
            $("#etag").val(data.d.__metadata.etag);
        }
    });
});
//Link to files list item
$(document).on('click', '.confirmListItemDetailsLink', function (e) {
    e.preventDefault();
    var id = this.id;
    var requestUri = "../Lists/SPFxFiles/DispForm.aspx?ID=" + id;
    window.location.href = requestUri;
});
// Delete button click event
$(document).on('click', '.confirmDeleteFileLink', function (e) {
    e.preventDefault();
    var id = this.id;
    $('#deleteId').val(id);
    (<any>$('#deleteFiles')).modal({
            show: true
        })
});
//Update Model Label
function updateFormLabel() {
    $('#myModalLabel').html('Add New File');
};
//Populate then display modal dialog for add file button clicked
$(document).on('click', '.addNewFile', function (e) {
    $('#myModalLabel').html('Add New File');
    $('#fileTitle').val('');
    $('#fileName').val('');
    $('#fileType').val('');
    $('#team').val('');
    $('#fileId').val('');
    (<any>$('#myModalNorm')).modal('show');
});
//Edit file function
function UpdateFiles(id) {
    var fileTitle = $("#fileTitle").val();
    var fileName = $("#fileName").val();
    var fileType = $("#fileType").val();
    var team = $("#team").val();
    var eTag = $("#etag").val();
    var requestUri = "../_api/web/lists/getByTitle('SPFxFiles')/items(" + id + ")";
    var requestHeaders = {
        "accept": "application/json;odata=verbose",
        "X-HTTP-Method": "MERGE",
        "X-RequestDigest": $('#__REQUESTDIGEST').val(),
        "If-Match": eTag
    }
    var fileData = {
        __metadata: { "type": "SP.Data.SPFxFilesListItem" },
        Title: fileTitle,
        SPFxFileName: fileName,
        SPFxFileType: fileType,
        SPFxTeam: team
    };
    var requestBody = JSON.stringify(fileData);

    return $.ajax({
        url: requestUri,
        type: "POST",
        contentType: "application/json;odata=verbose",
        headers: requestHeaders,
        data: requestBody
    });
}

//Add File function
var addFile = function (fileTitle, fileName, fileType, team) {
    var requestUri = "../_api/web/lists/getByTitle('SPFxFiles')/items";
    var requestHeaders = {
        "accept": "application/json;odata=verbose",
        "content-type": "application/json;odata=verbose",
        "X-RequestDigest": $('#__REQUESTDIGEST').val()
    }
    var fileData = {
        __metadata: { "type": "SP.Data.SPFxFilesListItem" },
        Title: fileTitle,
        SPFxFileName: fileName,
        SPFxFileType: fileType,
        SPFxTeam: team
    };
    var requestBody = JSON.stringify(fileData);
    return $.ajax({
        url: requestUri,
        type: "POST",
        headers: requestHeaders,
        data: requestBody
    });

};
  }
  protected get dataVersion(): Version {
    return Version.parse('1.0');
  }

  protected getPropertyPaneConfiguration(): IPropertyPaneConfiguration {
    return {
      pages: [
        {
          header: {
            description: strings.PropertyPaneDescription
          },
          groups: [
            {
              groupName: strings.BasicGroupName,
              groupFields: [
                PropertyPaneTextField('description', {
                  label: strings.DescriptionFieldLabel
                })
              ]
            }
          ]
        }
      ]
    };
  }
}
Eventually I will split out the javascript code into a separate module that I reference so it will clean up this file greatly but for now I'm just trying to get the demonstration working and published.

Adding the SharePoint List

For this demonstration to work, a custom list needs to be provisioned with some default data so the jquery datatables grid will render some content.

In Visual Studio Code from the project explorer right click below the last file name displayed and select New Folder.

Name the folder sharepoint. Right click on the sharepoint folder and create another folder called assets. Right click on the assets folder and select new file, name the first file elements.xml and the second file schema.xml.



Open the Elements.xml and paste the following code into the file, this code defines 3 custom field types a content type that groups these field types and a list instance. The list instance that will be the actual instantiation of our list will include some default sample data shown in the <Data> node.

<?xml version="1.0" encoding="utf-8"?>
<Elements xmlns="http://schemas.microsoft.com/sharepoint/">

    <Field ID="{060E50AC-E9C1-4D3C-B1F9-DE0BCAC300F6}"
            Name="SPFxFileType"
            DisplayName="File Type"
            Type="Text"
            Required="FALSE"
            Group="SPFx Columns" />

    <Field ID="{943E7530-5E2B-4C02-8259-CCD93A9ECB18}"
            Name="SPFxFileName"
            DisplayName="File Name"
            Type="Text"
            Required="FALSE"
            Group="SPFx Columns">
    </Field>
    <Field ID="{943E7530-5E2B-4C02-8259-CCD93A9ECB19}"
            Name="SPFxTeam"
            DisplayName="Team"
            Type="Text"
            Required="FALSE"
            Group="SPFx Columns">
    </Field>

    <ContentType ID="0x010042D0C1C200A14B6887742B6344675C8B" 
            Name="SpfxFiles" 
            Group="SPFx Content Types" 
            Description="Sample content types from web part solution">
        <FieldRefs>
            <FieldRef ID="{060E50AC-E9C1-4D3C-B1F9-DE0BCAC300F6}" /> 
            <FieldRef ID="{943E7530-5E2B-4C02-8259-CCD93A9ECB18}" />
            <FieldRef ID="{943E7530-5E2B-4C02-8259-CCD93A9ECB19}" />
        </FieldRefs>
    </ContentType> 

    <ListInstance 
            CustomSchema="schema.xml"
            FeatureId="00bfea71-de22-43b2-a848-c05709900100"
            Title="SPFxFiles" 
            Description="SPFx Files"
            TemplateType="100"
            Url="Lists/SPFxFiles">
            <Data>
                <Rows>
                    <Row>
                    <Field Name="Title">Autoexec</Field>
                    <Field Name="SPFxFileName">Autoexec</Field>
                    <Field Name="SPFxFileType">bat</Field>
                    <Field Name="SPFxTeam">Microsoft</Field>
                    </Row>
                    <Row>
                    <Field Name="Title">Config</Field>
                    <Field Name="SPFxFileName">Config</Field>
                    <Field Name="SPFxFileType">sys</Field>
                    <Field Name="SPFxTeam">EMC</Field>
                    </Row>
                    <Row>
                    <Field Name="Title">Hosts</Field>
                    <Field Name="SPFxFileName">Hosts</Field>
                    <Field Name="SPFxFileType">exe</Field>
                    <Field Name="SPFxTeam">Dell</Field>
                    </Row>
                    <Row>
                    <Field Name="Title">Bootstrap</Field>
                    <Field Name="SPFxFileName">Bootstrap</Field>
                    <Field Name="SPFxFileType">js</Field>
                    <Field Name="SPFxTeam">EMC</Field>
                    </Row>
                    <Row>
                    <Field Name="Title">Startup</Field>
                    <Field Name="SPFxFileName">Startup</Field>
                    <Field Name="SPFxFileType">css</Field>
                    <Field Name="SPFxTeam">Dell</Field>
                    </Row>
                </Rows>
            </Data>
    </ListInstance>
</Elements>

Open the Schema.xml file and paste the following code into the file. The schema file will define the custom list including the content type defined above and the fields to be included in the default view.

<List xmlns:ows="Microsoft SharePoint" Title="Basic List" EnableContentTypes="TRUE" 
FolderCreation="FALSE" Direction="$Resources:Direction;" Url="Lists/Basic List" 
BaseType="0" xmlns="http://schemas.microsoft.com/sharepoint/">
  <MetaData>
    <ContentTypes>
      <ContentTypeRef ID="0x010042D0C1C200A14B6887742B6344675C8B" />
    </ContentTypes>
    <Fields></Fields>
    <Views>
      <View BaseViewID="1" Type="HTML" WebPartZoneID="Main" 
      DisplayName="$Resources:core,objectiv_schema_mwsidcamlidC24;" 
      DefaultView="TRUE" MobileView="TRUE" MobileDefaultView="TRUE" 
      SetupPath="pages\viewpage.aspx" 
      ImageUrl="/_layouhttps://devofficecdn.azureedge.net/sharepointdocumentation/images/generic.png" Url="AllItems.aspx">
        <XslLink Default="TRUE">main.xsl</XslLink>
        <JSLink>clienttemplates.js</JSLink>
        <RowLimit Paged="TRUE">30</RowLimit>
        <Toolbar Type="Standard" />
        <ViewFields>
          <FieldRef Name="LinkTitle"></FieldRef>
          <FieldRef Name="SPFxFileName"></FieldRef>
          <FieldRef Name="SPFxFileType"></FieldRef>
          <FieldRef Name="SPFxTeam"></FieldRef>
        </ViewFields>
        <Query>
          <OrderBy>
            <FieldRef Name="ID" />
          </OrderBy>
        </Query>
      </View>
    </Views>
    <Forms>
      <Form Type="DisplayForm" Url="DispForm.aspx" SetupPath="pages\form.aspx" WebPartZoneID="Main" />
      <Form Type="EditForm" Url="EditForm.aspx" SetupPath="pages\form.aspx" WebPartZoneID="Main" />
      <Form Type="NewForm" Url="NewForm.aspx" SetupPath="pages\form.aspx" WebPartZoneID="Main" />
    </Forms>
  </MetaData>
</List>

In the config folder open the package-solution.json file and paste the following code in the file. The package-solution file defines the solution and the feature that will be used to provision the custom list defined above. In the paths node the output directory is defined where the packed solution (.sppkg) file will be outputted.

{
  "solution": {
    "name": "spfx-client-side-solution",
    "id": "08244525-0fcd-4651-bef4-41aedba1dc47",
    "version": "1.0.0.0",
     "features": [{
      "title": "spfx-2-client-side-solution",
      "description": "spfx-2-client-side-solution",
      "id": "523fe887-ced5-4036-b564-8dad5c6c6e25",
      "version": "1.0.0.0",
      "assets": {        
        "elementManifests": [
          "elements.xml"
        ],
        "elementFiles":[
          "schema.xml"
        ]
      }
    }]
  },
  "paths": {
    "zippedPackage": "solution/spfx.sppkg"
  }
}

Package the solution 

Before packaging the solution select the Save All button, notice in the upper left corner the file icon with a 3 indicates there are 3 files that have been modified but not saved.



From the Integrated Terminal window type Gulp bundle

From the Integrated Terminal window type Gulp package-solution


Note - look for any red text when these commands are executed that indicate errors and ensure that Gulp bundle is executed before Gulp package-solution because Gulp bundle creates the dist folder with the bundle.js and other files that Gulp package-solution require.

From the Integrated Terminal window type Gulp serve. This command will start the local web site that will be accessed by SharePoint Online to render the web part. Note - If Gulp serve is not running before the web part is added to the page or viewed an error will be displayed.

Deploy Web Part to SharePoint Online

Because this solution relies on a SharePoint hosted list, running the web part in the local SharePoint Workbench tool will not work. I may change this later to add mock SharePoint list data when running the solution locally but for now I'll just deploy the solution to SharePoint Online.

Now that the Gulp package-solution command has been executed a sppkg file will be created in the sharepoint | solution directory.



For this demonstration ensure you have an application catalog site created in SharePoint Online and navigate to that site and select Apps for SharePoint

Drag and drop the spfx.sppkg file into the Apps for SharePoint library. Select Deploy to trust the solution and deploy it into SharePoint.


Verify the solution displays that the app package is valid and it is deployed

Launch a separate browser session or tab and access your SharePoint Online Developer site. From the top toolbar select the gear icon and Add an App.

Select From Your Organization to filter the list of apps and select spfx-client-side-solution.

The Site Contents page will be displayed and the spfx-client-side-solution will display and "We're adding your app" message. This will take a few minutes to complete.

Once the "We're adding your app" message disappears the app installation is complete, refresh the page and if the list is deployed successfully a SPFxfiles list will be included in the site contents. Notice that under the list title 5 items is displayed, this verifies that the data specified in the list definition was successfully provisioned.

Go back to the home page of the developer site and select the gear icon | Edit Page. Select the Insert Tab | Web Part | Under Development Category | spfx | Add.



The web part should be correctly displayed on the page, select Save.


Test the Web Part

Select the Add New File Button, fill out fields and select Submit


Select the pencil (Edit) icon on the newly added item in the grid, alter one of the fields and select Submit.

Select the X (Delete) icon on the newly added item in the grid, a confirmation dialog will appear, select Submit to delete the item from the list. The item should be removed from the list.


A File Successfully Deleted Toast will be displayed in the upper right corner.
This completes the SPFX Solution demonstration.

Please take a look at my follow up post Here for instructions on hosting solution files via a CDN from a SharePoint Online document library. With this in place you will no longer need to run Gulp serve to correctly view the web part.