Focal Point
[SHARING] WF8201 New D3 Visualizations - Data Tables now part of 8201

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1437042686

April 26, 2017, 03:35 PM
tomatosauce
[SHARING] WF8201 New D3 Visualizations - Data Tables now part of 8201
The following are the new D3.js visualizations being added to 8201 as WF Extensions.

Surprised to see Data Tables in the list.

Arc
Calendar
Cartogram
Chord
Cluster
Datatables
liquid Gauge
Org chart
Sankey
Sunburst
Timeline


https://github.com/ibi/wf-extensions-chart

It would be interesting to see whether IBI can create a market place for these plugins where any user can create his own d3 visualizations as a extension and share with the community.

This message has been edited. Last edited by: FP Mod Chuck,


Tharun Katanguru
SBOX- 8205 DEV/TEST/PROD : 8105 8205
Linux, All Outputs
April 26, 2017, 05:43 PM
Waz
That is very interesting.

We are using datatables here with some reports.

I wonder if its all of it or just a component.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

April 27, 2017, 10:43 AM
FP Mod Chuck
Hi Tomatosauce

The beauty about D3 is that even though there are some provided as you have documented but you can add any D3 chart to use. You are not limited to the ones provided. Below is a helpful link that explains how to add your own.

https://github.com/ibi/wf-extensions-chart/wiki


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
April 27, 2017, 10:49 AM
FP Mod Chuck
In additon Focal Point is the perfect place to advertise D3 charts you have enabled


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
April 27, 2017, 06:32 PM
CoolGuy
Happy day!

Great to see DataTables.js being used by so many now, and that IBI is officially supporting it as an extension that will be compatible with WebFOCUS moving forward.

A royal Git'R Done!! is deserved! Pass the bubbly! ;-)

Thanks for letting us all know tomatosauce!


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
April 30, 2017, 02:47 AM
Neelima
Hi,

can we use D3.js Extension in WF81 series?


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
May 01, 2017, 08:20 AM
tomatosauce
quote:
Originally posted by Neelima:
Hi,

can we use D3.js Extension in WF81 series?


No Neelima, These extensions are currently limited to WF8200 and Above


Tharun Katanguru
SBOX- 8205 DEV/TEST/PROD : 8105 8205
Linux, All Outputs
July 24, 2017, 09:10 AM
Shingles
Are they all working for you folks? Some of them aren't working for me. DataTables for example throws up errors even if I'm not using it (I've enabled via the JSON file, but that's all).


WebFOCUS 8201, SP 0.1, Windows 7, HTML
July 24, 2017, 10:04 AM
BabakNYC
What kind of error does it throw? What GEN are you running?

I have this working.
-*Do not delete or modify the comments above
ENGINE INT CACHE SET ON


-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';

-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE ibisamp/car
-* Created by Info Assist for Graph
SUM CAR.BODY.SALES
BY CAR.ORIGIN.COUNTRY
BY CAR.COMP.CAR
BY CAR.CARREC.MODEL
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET ARGRAPHENGIN JSCHART
ON GRAPH SET EMBEDHEADING ON
ON GRAPH SET VZERO OFF
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET LOOKGRAPH EXTENSION
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT

setPieDepth(0);
setPieTilt(0);
setDepthRadius(0); 
setCurveFitEquationDisplay(false); 
setPlace(true); 

*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $
TYPE=DATA, COLUMN=N1, BUCKET= >row, $
TYPE=DATA, COLUMN=N2, BUCKET= >row, $
TYPE=DATA, COLUMN=N3, BUCKET= >row, $
TYPE=DATA, COLUMN=N4, BUCKET= >measure, $
*GRAPH_SCRIPT

setReportParsingErrors(false);
setSelectionEnableMove(false);
*GRAPH_JS_FINAL
"pieProperties": {
"holeSize": "0%"
},
"chartType": "com.ibi.datatables",
"agnosticSettings": {
"chartTypeFullName": "com.ibi.datatables"
}

*END
ENDSTYLE
END

-RUN





WebFOCUS 8206, Unix, Windows
July 24, 2017, 03:47 PM
Shingles
Thanks for the reply... I copied that text into a new procedure and ran it.

The datatable displayed for a split second, and then was immediately replaced with the following text:

ERROR
----------
TypeError: Object doesn't support property or method 'renderComplete'

If I hit F12 in IE11, the console says:

SCRIPT5007: Unable to get property 'style' of undefined or null reference
File: datatables.min.js, Line: 80, Column: 196

Have any of you had to mess around with the JS files to make these work?

I tried removing that stylesheet (commented out that INCLUDE statement), but I still get the same result.

I also tried creating a datatables report using cars.mas, and right after I select datatables I get a script error window in AppStudio:

Line: 370
Char: 3
Error: Object doesn't support property or method 'renderComplete'
Code: 0
URL: http://devibi/ibi_apps/webcons...om.ibi.datatables.js

This message has been edited. Last edited by: Shingles,


WebFOCUS 8201, SP 0.1, Windows 7, HTML
July 24, 2017, 03:55 PM
BabakNYC
It seems to work in Chrome but not in IE. I got the same error in IE11.


WebFOCUS 8206, Unix, Windows
July 24, 2017, 04:00 PM
Shingles
Oh... Frowner

So how do you folks deal with that? Do your clients/users only use Chrome?


WebFOCUS 8201, SP 0.1, Windows 7, HTML
July 24, 2017, 04:07 PM
BabakNYC
I just tested this in Edge and it works. Most shops I've worked with allow Firefox or Chrome. If that's not available, usually Microsoft Edge is on the machine. See if that works and suggest they use Edge instead of IE.


WebFOCUS 8206, Unix, Windows
July 25, 2017, 08:57 AM
Shingles
Hmmm... alright... thank you.


WebFOCUS 8201, SP 0.1, Windows 7, HTML
July 25, 2017, 09:03 AM
Tony A
I can run it fine within WF 8.2.01M using IE version 11.0.9600.17728.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
August 01, 2017, 05:20 AM
Tony A
Just for information, it is worth returning to GitHub if you experience problems with an extension to see if the issue has been reported and whether a fix is available.

For instance, I was experiencing data duplication on resize of a window when using DataTables. This was fixed in May 2017 and downloading the latest version, clearing the cache using Admin console and also browser cache, fixed the problem.

I would recommend that you make a temporary backup of the extension(s) before overwriting with a new download. Just in case ....

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
August 01, 2017, 11:06 AM
CoolGuy
I second Tony A to return to GitHub and investigate via the Issues tab. I add that if there isn't an issue for said found bug, please submit an issue with anything you can give that will make the bug reproducible if possible. I submitted the issue on what Tony found with the resize way back in May, and within the next few days the developer had a fix in place. GIT R DONE!


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
August 17, 2017, 09:11 AM
Shingles
I opened a ticket with the IBI folks.


WebFOCUS 8201, SP 0.1, Windows 7, HTML
March 01, 2018, 05:14 PM
Siva1925
How to use accordion in the data tables chart


webFOCUS 8206
Windows 10
March 01, 2018, 05:50 PM
CoolGuy
Siva1925,

The extension used here is based on a JavaScript library known as DataTables.js; and can be found here: http://www.datatables.net

Upon searching therein, you'll find the following:

https://datatables.net/examples/api/row_details.html

This message has been edited. Last edited by: CoolGuy,


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.