SharePoint Excel Data Refresh with O365 Pro Plus

My environment:
– SharePoint on-prem 2013
– Office Online Server
– Excel Office Pro Plus (2016)
– Data source = SharePoint list

Problem Description:

One day I wasn’t anymore able to auto refresh my SharePoint embedded charts that pulled data from SP lists.
I had to do some research until I found that it’s a combination of my new Excel version and the Office Online server. Due to changes in the security model, the standard settings didn’t work anymore.

Solution:

  1. Enable “From OData Data Feed (Legacy)” in the Excel options on the “Data” tab
  2. In Excel on the Data tab click on “Get Data – Legacy Wizards – From OData Data Feed (Legacy)
  3. Connect to your site adding /_vti_bin/listdata.svc to your URL
  4. on the next page select the list where you want to pull data from
  5. now on the last wizard page it’s very important, that you use a stored account instead of Windows authentication (create on in “Secure Store Service” – Link)

Now you can go on creating your charts and then embed it in SharePoint with the Excel web part.

Have fun!

If that still doesn’t work, some other things to check:
– check, if the SecureStoreService is set to type “Individual”
– In the members section add the FQDN$ (if on-prem) of the OOS servers
– in OOS configuration make sure -AllowHttpSecureStoreConnection is set to TRUE
– in the c2wtshost.exe.config (under path C:\Program Files\Windows Identity Foundation\v3.5\) make sure, that following line is NOT commented:
<add value=”NT AUTHORITY\Network Service” />
(restart OOS service)
– make sure, all BIServers are registered in OOS
New-OfficeWebAppsExcelBIServer –ServerId YourSQLServer\POWERPIVOT

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

Javascript to create Link incl. DYNAMIC DATE

Problem Description:

Some services might use special parts in the URL, that are dynamic.
So is my case, where the link must include today’s date.
I found some resources on the web that gave me an idea and here is my final piece of code.
I added it to a SharePoint site, so users are able to click from there including login and this dynamic date.

Solution:

<div id=’dynLink’> </div>

<script type=”text/javascript”>
window.onload = function(){
var date = new Date();
var y = date.getFullYear();
var m = date.getMonth() + 1;
if(m < 10){m = ‘0’ + m;}
var d = date.getDate();
if(d < 10){d = ‘0’ + d;}
var date = d + “.” + m + “.” + y;

var finalURL = ‘<a target=\”_blank\” href=\”https://first part of the link’ + date + ‘second part of the link\”>Link</a>’;

document.getElementById(‘dynLink’).innerHTML=finalURL;
}
</script>

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Create clickable Icon in SharePoint Lists

Problem Description:

Sometimes design is very important and therefore a usual link may not be enough. So I searched for a way to create a column in SharePoint and add a clickable icon.

Resolution:

  1. upload a icon picture to your site
  2. create a new column of type “Multiple lines of text”;
    ensure you have “Enhance rich text…” selected and set the “Number of lines for editing to 1
  3. now you can add usual links to that column or do it – like in my case – automatically by a workflow on item created event.
    <a href=” &Source=/sites/yoursite”><img border=”0″ alt=”Info” src=”/sites/yoursite/library/info.png”>
  4. enjoy!
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Meine Wiederladedaten .38 Special

Nachdem ich meine 9mm Luger (Link)  Laborierung schon mal geteilt habe, hier auch noch meine Zusammensetzung der .38 Special.

Pulver: 6.0 gn Vihtavuori N340
Geschoss: LOS 158 gn .357
Zünder: S&B Small Pistol

Ebenfalls auf 25m ausgetestet und alles bestens mit der S&W 686 sowie mit einem S&W Model 21

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 3.50 out of 5)
Loading...

SharePoint Solution Deployment stucks in Retract / Deploy State

Problem Description:

I tried to deploy / retract a solution on a SharePoint farm, but the process never finishes. It stucked in “Deploying / Retracting” state forever.
In my case this was caused by disabled timer service instances.

Workaround:

I deployed the solutions with the parameter -Local on each server.

Final Solution:

$farm = Get-SPFarm
$disabledTimers = $farm.TimerService.Instances | where {$_.Status -ne “Online”}
foreach ($timer in $disabledTimers)
{
$timer.Status = [Microsoft.SharePoint.Administration.SPObjectStatus]::Online
$timer.Update()
}

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...