All posts by Alexander Bautz

SPJS Charts v7 BETA 7

I have fixed a few issues and have released a new BETA.

You find information about SPJS Charts v7 and a link to download it here: http://spjsblog.com/2018/04/29/spjs-charts-v7/

Please report back any issues you might have with this release – and if I don’t get any new bug reports I’ll get a prod release out later this week.

Alexander

SPJS Charts v7 BETA 3

I have fixed an issue with BETA 2 where I accidentally left a user group in the variable spjscharts_restrictAddNewChartToGroup in the SPJSCharts_loader.html like this:

var spjscharts_restrictAddNewChartToGroup = "TestGroup1";

This would prevent the add new chart button from showing. The default value here should be like this:

var spjscharts_restrictAddNewChartToGroup = "";

I have also removed a call to get the user profile for the current user because this failed in SP foundation where the user profile is not accessible.

You find information about SPJS Charts v7 and a link to download it here: http://spjsblog.com/2018/04/29/spjs-charts-v7/

Alexander

SPJS Charts v7

Last updated: May 12, 2018

I have upgraded SPJS Charts for SharePoint to use REST queries to load data. This means the loading is now asynchronous and therefor the page will be more responsive while the the charts are loading.

Please note that this new version does not support SP 2007 and SP 2010.

You find the BETA here. Follow the installation instruction for v6 to set it up.

Functionality

Most of the functionality is the same as in v6, but I have added one new feature for advanced users.

Custom datasource

Query for data

In the “Basic setup” tab you no have two options for Datasource. The “SharePoint list” option is the same as before, but the new “Custom datasource” option lets you load the data-source with a custom JavaScript function.

This way you can for example combine two or more queries to build one chart in a page. I’ll describe this functionality below.

When selecting the “Custom datasource” radio button, you will see a new textarea for the configuration of “Datatable fields” and the function name to use to query for the data:

This example chart is set up with a custom datasource built with the below configuration.

This is an example of the “Custom datasource” configuration:

{
 "type":"function",
 "functionName":"getChartCustomDatasource",
 "columns":[
 {"fin":"Date","label":"Date","type":"DateTime","dataType":"date","role":""},
 {"fin":"Madagascar","label":"Madagascar","type":"Text","dataType":"number","role":""},
 {"fin":"Bolivia","label":"Bolivia","type":"Text","dataType":"number","role":""},
 {"fin":"Ecuador","label":"Ecuador","type":"Text","dataType":"number","role":""}
 ]
}

The function name getChartCustomDatasource must be available in the page. Either by adding it to a custom js file loaded trough the “Load external JS or CSS” tab, or by adding it to a script editor web part in the page.

The below example shows a basic query to get the dataset from a SharePoint list:

function getChartCustomDatasource(chartId){
 var deferred = jQuery.Deferred();
 spjs.charts.getItemsREST({
 "listId":"{5ebb17fb-eb6d-4a01-ac86-a241458ff8f2}",
 "listBaseUrl":"/SPJSCharts",
 "select":["Date","Madagascar","Bolivia","Ecuador"],
 "expand":[],
 "filter":"",
 "rowLimit":""
 }).done(function(data){
 deferred.resolve(data);
 }).fail(function(err){
 // console.log(err);
 });
 return deferred.promise();
}

You can however user any sort of query you can run with JavaScript from within SharePoint, as long as the dataset returned from the query is in this format:

[{
 "Bolivia": "165",
 "Ecuador": "938",
 "Madagascar": "522",
 "Created": "2014-03-24T21:41:00Z"
}, {
 "Bolivia": "135",
 "Ecuador": "1120",
 "Madagascar": "599",
 "Created": "2014-03-24T21:41:08Z"
}, {
 "Bolivia": "157",
 "Ecuador": "1167",
 "Madagascar": "587",
 "Created": "2014-03-24T21:41:08Z"
}, {
 "Bolivia": "136",
 "Ecuador": "691",
 "Madagascar": "629",
 "Created": "2014-03-24T21:41:08Z"
}, {
 "Bolivia": "139",
 "Ecuador": "0",
 "Madagascar": "615",
 "Created": "2014-03-24T21:41:08Z"
}, {
 "Bolivia": "139",
 "Ecuador": "1110",
 "Madagascar": "615",
 "Created": "2016-04-02T22:18:55Z"
}, {
 "Bolivia": "345",
 "Ecuador": "456",
 "Madagascar": "429",
 "Created": "2016-04-03T07:11:10Z"
}, {
 "Bolivia": "333",
 "Ecuador": "22",
 "Madagascar": "555",
 "Created": "2016-04-03T14:58:45Z"
}]

Manually supply data

You can also add the data for the chart manually in the textarea like this:

{
 "type":"manual",
 "columns":[
 {"fin":"Status","label":"Status","type":"Text","dataType":"SplitInSeries","role":""},
 {"fin":"Department","label":"Department","type":"Text","dataType":"string","role":""}
 ],
 "data":[
 {"Department":"North","Status":"Not started"},
 {"Department":"North","Status":"In progress"},
 {"Department":"South","Status":"In progress"},
 {"Department":"South","Status":"Completed"}
 ]
}

Not backwards compatible

Because of the changed query method, v7 is not unfortunately not backwards compatible with v6 and you must rebuild the charts in v7.

To make the upgrade process easier, the two versions can both be installed in the same site, but you cannot load both versions in the same page.

License

If you have an existing license for v6 you can use the same license code in v7.

Comments or feedback

Please post any feedback in the forum or in the comments below.

Alexander

CommentBox for SharePoint v3.x

I have brushed up my CommentBox solution to use REST queries instead of the old web-service queries. I have rewritten the entire solution and brushed up most of the functionality.

What is this solution

You can add a CommentBox to any page in your SharePoint site to enable the users to post comments and discuss topics. You can have rich text or plain text comments with attachments, and multi level replies. It has paging and subscription to comments by email.

Please note that the new version only supports SP 2013 and above. If you use SP 2010 or SP 2007 you must stick with the old version.

Check it out and let me know if you have any questions.

Alexander

SPJS Charts for SharePoint updated to v6.1.5.13

I have published a new version of SPJS Charts for SharePoint with a few minor layout changes and a fix for an error when adding a chart to a page and getting an error related to “ZoneId”.  You find the change log here and you can download the files here.

As mentioned when publishing the last update back in December 2017 I have worked on a new version that uses REST to query the datasource. This version will also be able to use a custom datasource built from a query or a static JSON object. This version will soon be published in BETA.

Please post any questions in the forum.

Alexander