sharepoint foundation – Cant find azureAD Groups in SP2013

We got AzureAD authentication working on our On premise SP2013 environment using this tutorial: https://docs.microsoft.com/nl-nl/azure/active-directory/saas-apps/sharepoint-on-premises-tutorial

We are able to find AzureAD users inside SharePoint 2013, but we cant find the security Groups We created in AzureAD. We Also used The GUID of the security group in people picker, but still no results

Any idea what the problem could be?

Thx for the support 🙏!

2013 – Steps in a Process & Coloring them (SP2013)

I came across an example of a process with a current stage image (should be attached to the thread).

Sample Workflow

Basically there would be 4 or 5 stages: Initial / Assigned / Being Processed / Completed.

Each of the stages would have (almost like a flowchart diagram) a progress image with an arrow showing the current state and they would be colored.

For example:
Current Stage – White box / Green Outline
Completed Stage – Green Box / Black Outline
Pending – Yellow Box / Gold Outline
Cancelled – Red Box / Red Outline
etc.

As the list item gets updated, the workflow images would get marked and colored for the stages.

How could this be accomplished? Would it be as simple as having a column for each stage? And if so then would the coloring of each stage come from CSS?

Thanks

javascript – How do I add items to a SP2013 list from an HTML form?

I have a knowledge check in HTML form, so I cant inject into CEWP or SP pages. It needs to be JS, CSS, and HTML. How do I populate a list if someone completes a Knowledge Check? It will add the score, module#, name, and date to list ‘JAcerts’ upon completion.

Here is my check: https://jsfiddle.net/Lance_Bitner/6gkL92av/6/

This line needs to be the action where I submit, I think? When the cert taker hits this button I need their info to go to the list, ‘JAcerts’.

 <a id="btn" type="submit" onclick="window.location.href="https://sharepoint.stackexchange.com/#game-over"">Next</a>

Cert picture:

Check out my js in my jsfiddle. I HAVE TRIED so many JS codes but not connecting them correctly.

The list and Knowledge check are in the same site “/sites/OA03/Lists/JAcerts'” for the list and “sites/OA03/JA%20Training/” for Knowledge Check.

sharepoint online – web part giving error in SPO but runs ok in SP2013

During the migration of SP2013 farm to SPO I came across a content editor web part which has linked html file containing the following script

<script type="text/javascript">
    function loadJs(path) {
        document.write('x3Cscript type="text/javascript" src="' + path + '">x3C/script>');
    }
    function loadCSS(path) {
        document.write('x3Clink rel="stylesheet" type="text/css" href="' + path + '">x3C/link>');

    }
    loadCSS(_spPageContextInfo.siteServerRelativeUrl + '/_catalogs/masterpage/Applets/StockTicker/Content/App.min.css');

    loadJs(_spPageContextInfo.siteServerRelativeUrl + '/_catalogs/masterpage/Applets/StockTicker/Scripts/AppletConfig.js');

    loadJs(_spPageContextInfo.siteServerRelativeUrl + '/_catalogs/masterpage/Applets/StockTicker/Scripts/App.js');
</script>


<script  type="text/javascript">
    jQuery(document).ready(function () { SP.SOD.executeFunc("sp.js", "SP.ClientContext", function () { Insite.StockTicker.StockTickerFactory.create(); }); });
 
</script>

When I try to load the web part the console gives me an error that .create method could not be found since Insite.StockTicker.StockTickerFactory is undefined. App.js is the file containing the Insite.StockTicker and all its methods. I did a bit of research and found one similar problem where it was suggested to load these files in the exact order.

<script src="/_layouts/1033/init.js" type="text/javascript"></script>
<script src="/_layouts/MicrosoftAjax.js" type="text/javascript"></script>
<script src="/_layouts/sp.core.js" type="text/javascript"></script>
<script src="/_layouts/sp.runtime.js" type="text/javascript"></script>
<script src="/_layouts/sp.js" type="text/javascript"></script>

I am aware that SPO and SP2013 are different but can someone explain to me why the web part works on SP2013 and not on SPO. Correct me If I’m wrong but as far as I understood those scripts are preloaded in SPO and I only have to reference them where needed – in my case in the linked html file.

Sharepoint Farmname and Federationname in SP2013 on prem

We are trying to connect Azure AD to our Sharepoint 2013 on premise for
SSO.

We have done some research and its looks doable. But one thing we cant find. Can someone help us with questions below?

Question:

In the Identifier box, enter a URL by using this pattern: urn:<sharepointFarmName>:<federationName>.

Where can we find the sharepointfarmname and federationname on our SP2013 on premise?

SP2013 List: Trigger JQuery to run with each list view change or to/from Quick Edit mode

To insert a script that always runs when a view is refreshed

The only right way of injecting JavaScript to SharePoint lists/views is to use the JSLink / Client Side Rendering (CSR). Check out the fantastic article on this by Andrei Markeev.

This is how you run your script reliably, without any script webparts:

  • Install Cisar Chrome extension
  • Navigate to the SharePoint list
  • Click F12
  • Click Cisar tab
  • Click on the “Click here to add a file to the webpart
  • Type a file name of your choice
  • Press Enter:

enter image description here

  • Uncomment the “OnPostRender” function and inject your code here:

enter image description here

enter image description here

SAMPLE CODE

SP.SOD.executeFunc("clienttemplates.js", "SPClientTemplates", function() {

  function getBaseHtml(ctx) {
    return SPClientTemplates("_defaultTemplates").Fields.default.all.all(ctx.CurrentFieldSchema.FieldType)(ctx.BaseViewID)(ctx);
  }

  function init() {

    SPClientTemplates.TemplateManager.RegisterTemplateOverrides({      
      OnPostRender: function(ctx) { 
        $("#js-listviewthead-WPQ2").find('tr>th').each(function(){
            if($(this).find('div').attr("displayname")=="Prev Month")
            {
                    $(this).find('a:first').text("Prev EOM 03-31-2021");
            }
         });
        },
      ListTemplateType: 100

    });
  }

  RegisterModuleInit(SPClientTemplates.Utility.ReplaceUrlTokens("~siteCollection/Style Library/ViewScript.js"), init);
  init();

});

You can also add the JS Link manually.

  • Edit the page
  • Go to the webpart properties
  • Specify the JSLink like so:

enter image description here

2013 – Migrate Dataview webparts in Sp2013

I’m trying to migrate the Dataview webparts which are in one of the sub site page to another subsite in same site collection through export and import option and the data is pointing to the root site list, but I’m getting the message “List does not exist. The page you selected contains a list that does not exist.It may have been deleted by another user” when adding the imported webpart.

Any suggestions/help?

sharepoint online – Approval Workflow SP2013 Not Sending Approval Email

So I have created the following workflow.

When a person creates a new list item, the variable Approval Status is by default Pending. So once the list item is created, it send an email to who created the request letting them know that it has been submitted for approval.

Next, the workflow will create a Task to send to HR to either approve or reject the employees leave request. If accepted, I have it showing on a calendar view, and if not it doesn’t show up on the Calendar.

Everything up to that works just fine.

For some reason, when it is changed to approved or rejected from Pending, it will not send either of the emails I have created to notify the employee of his/her approval rejection. Why is this

enter image description here

2013 – SP2013 – Usage report showing zero values

I had this same problem in an on-prem 2016 farm. In my case, the Usage Service Application was installed and configured correctly, the Proxy was running, and .usage log files were being generated, but the timer jobs that are supposed to import and process the logs were not running. (In troubleshooting I learned that none of the below timer jobs had ever run in the farm.)

Usage Service Application timer jobs

As a result, I was seeing all zeros in the Usage reports, and I was also not able to see Search Service Health reports, either.

The issue for me ended up being that the Usage Service Application instance was disabled on both of my front-end servers. I used the below PowerShell to enable them. The next day, I was able to run usage reports successfully, and I could see in the logs that overnight it had imported some ~90GB of old usage reports into the WSS_Usage DB.

# Get the service instance of "Usage and Health Data Collection Service Application"

$c = Get-SPServiceApplication | Where-Object {$_.Typename -eq "Usage and Health Data Collection Service Application"}

$c.ServiceInstances | Format-List Server, Tynename, Id, Status

The result of the above command:

Server : SPServer Name=CONTOSO-SP-WEB Id :
0b20c83a-7d2d-48f7-9dbc-af316b63fc72 Status : Disabled

Server : SPServer Name=CONTOSO-SP-APP Id :
25d7427a-b95e-4489-9530-fe20a1e07187 Status : Disabled

The next step is to Get each instance by its ID and run its provision() method, which is pretty much the “On” switch.

$c.ServiceInstances.Id | % { 
   $instance =  Get-SPServiceInstance $_
   $instance.Provision()
}

Afterwards, I ran Format-List again on $c.ServiceInstances and this was the result:

Server : SPServer Name=CONTOSO-SP-WEB Id :
0b20c83a-7d2d-48f7-9dbc-af316b63fc72 Status : Online

Server : SPServer Name=CONTOSO-SP-APP Id :
25d7427a-b95e-4489-9530-fe20a1e07187 Status : Online

This post on TechNet (from October 2018) led me to find this solution: SharePoint 2016 Analytics – Usage reports not showing data

2013 – SharePoint 2016 – Search Service Application: Error while upgrade SP2013 Search Admin Database to SP2016

We are upgrading SharePoint 2013 site to SharePoint 2016 via the database attach approach, All things went good but during the Search Service Admin Database upgrades to SharePoint 2016 we are getting the below exception. Although we followed the Microsoft approach for creating database backup of SharePoint Search Service Application i.e. stop crawl, make database read-only.
Restore-SPEnterpriseSearchServiceApplication -Name “” -applicationpool ” -databasename ” -databaseserver ” -AdminSearchServiceInstance ”

Exception:
Microsoft.SharePoint.Upgrade.SPUpgradeException: Action 16.0.47.0 of Microsoft.Office.Server.Search.Upgrade.SearchAdminDatabaseSequence failed. —> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint ‘PK_MSSManagedProperties’. Cannot insert duplicate key in object ‘dbo.MSSManagedProperties’. The duplicate key value is (UniqueID, 0). Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command, SqlInfoMessageEventHandler handler)
at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command)
at Microsoft.Office.Server.Search.Administration.OOTBSchemaDefinition.InstallManagedProperty(Property p, Boolean exists, Boolean upgrade)
at Microsoft.Office.Server.Search.Upgrade.UpdateUniqueIDPropertyFlags.Upgrade()
at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade() –
— End of inner exception stack trace —