patmartin / dex Goto Github PK

Dex : The Data Explorer -- A data visualization tool written in Java/Groovy/JavaFX capable of powerful ETL and publishing web visualizations.

Home Page: https://dexvis.net

License: Apache License 2.0

CSS 2.33% JavaScript 65.56% Shell 0.01% HTML 14.51% Makefile 0.01% C 15.40% CoffeeScript 0.05% R 0.01% Processing 0.04% Java 0.70% Groovy 1.35% PHP 0.04% SourcePawn 0.01% C++ 0.01% Batchfile 0.01% Ruby 0.01% Dockerfile 0.01%

data-science data-visualization visualization data-analysis data-mining java javafx d3 dataviz datavis

dex's People

Contributors

Stargazers

Watchers

Forkers

myndworkz mwang27 wbuchanan chiralbehaviors vipyami lochaowei martinstuga kavetifun cybernetics konglingyuan onasusweb vincent-chenxl yinxx altair-albert examyes icming amitsjain sunflowersofjava nomstradamus lisir mstrdev sherpic blake2002 zhongfuqiang aplayer oldeye liuxiaoqiang jxjhill koval-jan kevinkelley scoldfield mayankti rushidesai1 changjiashuai rivagti dfparker2002 szulijun running-fish faisal-w rainee007 robertotang bryanshubo wtest helllma jimsow hellozhxy linghushaoxia taoguan chenarthur socube kaaha zouyanjian antnewman ronaldzhao tomjie diamondbigdata ooccoob hhy5277 leifeitian snowluliang liaocong amous-th audreychao jolesen java89757 cymbidum imxtyler wpeiguang xiaogang150805 bjcaoyz preformiostudios h-hao fanzk rperezs biggie-wu victaie wuchaoup shute001 jbravo shu1jia1 desaetiis spartajet dmwlei endlesshh goglexun seakingii gnahz-eh lyyybz zhangjunqiang mplearning luckyyuandm nickimpro zhiweicoding newsky adriantse lin0x felicityrooting what1sc0de oneplus7 alainlompo

dex's Issues

Slow performance for multiples in Firefox

Having adapted one of the examples on dexvis.net, multiple c3 area charts are loading from a large dataset much more slowly in Firefox versus Chrome (57 seconds, versus 16 seconds)

Where is the TMI groovy script?

Looking for the referenced TMI groovy script in the source. The .classpath file refers to an external Eclipse project. Cannot seem to find the com.dexvis.tmi.* source.

Exceptions on start in OSX

when starting on OSX

java -version
java version "1.8.0_51"
Java(TM) SE Runtime Environment (build 1.8.0_51-b16)
Java HotSpot(TM) 64-Bit Server VM (build 25.51-b03, mixed mode)

I receive these errors:

Available Processors: 8
*** Searching for Dex Task inside your classpath...
Found Task: 'com.dexvis.dex.task.base.WebDriverTask'
--- Creating Property Sheet()
-- TASK: com.dexvis.dex.task.base.WebDriverTask@1f2830a3
  ** NEW CATEGORY: 'Web View'
PUT: 'Web View'
Found Task: 'com.dexvis.dex.task.base.WebTask'
java.lang.InstantiationException: com.dexvis.dex.task.base.WebTask
    at java.lang.Class.newInstance(Class.java:427)
    at com.dexvis.dex.Dex.getTasks(Dex.java:557)
    at com.dexvis.dex.Dex.init(Dex.java:222)
    at com.dexvis.dex.Dex.start(Dex.java:672)
    at com.sun.javafx.application.LauncherImpl.lambda$launchApplication1$159(LauncherImpl.java:863)
    at com.sun.javafx.application.LauncherImpl$$Lambda$70/505862938.run(Unknown Source)
    at com.sun.javafx.application.PlatformImpl.lambda$runAndWait$172(PlatformImpl.java:326)
    at com.sun.javafx.application.PlatformImpl$$Lambda$47/355629945.run(Unknown Source)
    at com.sun.javafx.application.PlatformImpl.lambda$null$170(PlatformImpl.java:295)
    at com.sun.javafx.application.PlatformImpl$$Lambda$49/453908573.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at com.sun.javafx.application.PlatformImpl.lambda$runLater$171(PlatformImpl.java:294)
    at com.sun.javafx.application.PlatformImpl$$Lambda$48/1915503092.run(Unknown Source)
    at com.sun.glass.ui.InvokeLaterDispatcher$Future.run(InvokeLaterDispatcher.java:95)
Caused by: java.lang.NoSuchMethodException: com.dexvis.dex.task.base.WebTask.<init>()
    at java.lang.Class.getConstructor0(Class.java:3082)
    at java.lang.Class.newInstance(Class.java:412)
    ... 13 more

and some more later....

any hints ? using latest version from git: SHA 02f24cd

Dex 0.8.0.8 - java.util.concurrent.RejectedExecutionException

Add Read CSV task (pick data/presidents.csv)
Hit Execute (all seems ok)
When finished close the dialog with Cancel
Hit Execute again and you get errors:

OSX:

sw_vers
ProductName: Mac OS X
ProductVersion: 10.11.5

BuildVersion: 15F34

java version "1.8.0_51"
Java(TM) SE Runtime Environment (build 1.8.0_51-b16)
Java HotSpot(TM) 64-Bit Server VM (build 25.51-b03, mixed mode)

Available Processors: 8
*** Searching for Dex Task inside your classpath...
Found Task: 'com.dexvis.dex.task.base.WebDriverTask'
  ** NEW CATEGORY: 'Web View'
Found Task: 'com.dexvis.dex.task.base.WebTask'
Found Task: 'com.dexvis.dex.task.database.CreateJdbcTable'
  ** NEW CATEGORY: 'Database'
Found Task: 'com.dexvis.dex.task.database.QueryJdbc'
Found Task: 'com.dexvis.dex.task.info.CompareDatasources'
  ** NEW CATEGORY: 'Info'
Found Task: 'com.dexvis.dex.task.info.DescribeData'
Found Task: 'com.dexvis.dex.task.input.FileInput'
  ** NEW CATEGORY: 'Input'
Found Task: 'com.dexvis.dex.task.input.JarInspector'
Found Task: 'com.dexvis.dex.task.input.MultiFileInput'
Found Task: 'com.dexvis.dex.task.input.ReadCsv'
Found Task: 'com.dexvis.dex.task.input.TextInput'
Found Task: 'com.dexvis.dex.task.output.GroovyOutputTemplate'
  ** NEW CATEGORY: 'Output'
Found Task: 'com.dexvis.dex.task.output.WriteCsv'
Found Task: 'com.dexvis.dex.task.prg.GroovyScript'
  ** NEW CATEGORY: 'Programming'
Found Task: 'com.dexvis.dex.task.prg.JavaScript'
Found Task: 'com.dexvis.dex.task.prg.JythonScript'
Found Task: 'com.dexvis.dex.task.prg.P5Script'
Found Task: 'com.dexvis.dex.task.prg.RScript'
Found Task: 'com.dexvis.dex.task.prg.TMIScript'
Found Task: 'com.dexvis.dex.task.tablemanipulation.AddColumn'
  ** NEW CATEGORY: 'Table Manipulation'
Found Task: 'com.dexvis.dex.task.tablemanipulation.AddRowNumber'
Found Task: 'com.dexvis.dex.task.tablemanipulation.ColumnFilter'
Found Task: 'com.dexvis.dex.task.tablemanipulation.GroupColumns'
Found Task: 'com.dexvis.dex.task.tablemanipulation.ReplaceAll'
Found Task: 'com.dexvis.dex.task.tablemanipulation.SelectColumns'
Found Task: 'com.dexvis.dex.task.tablemanipulation.SplitColumns'
Found Task: 'com.dexvis.dex.task.tablemanipulation.TrimColumns'
Found Task: 'com.dexvis.dex.task.utilities.DataRecorder'
  ** NEW CATEGORY: 'Utilities'
Found Task: 'com.dexvis.dex.task.utilities.Documentation'
Found Task: 'com.dexvis.dex.task.utilities.Environment'
Found Task: 'com.dexvis.dex.task.utilities.ExecuteProcess'
Found Task: 'com.dexvis.dex.task.utilities.Google'
Found Task: 'com.dexvis.dex.task.utilities.GroovyFilter'
Found Task: 'com.dexvis.dex.task.utilities.Group'
Found Task: 'com.dexvis.dex.task.utilities.ViewData'
Found Task: 'com.dexvis.dex.task.vis.c3.AreaChart'
  ** NEW CATEGORY: 'Visualization:C3'
Found Task: 'com.dexvis.dex.task.vis.c3.BarChart'
Found Task: 'com.dexvis.dex.task.vis.c3.LineChart'
Found Task: 'com.dexvis.dex.task.vis.c3.LineChartMultiples'
Found Task: 'com.dexvis.dex.task.vis.c3.Scatterplot'
Found Task: 'com.dexvis.dex.task.vis.c3.StackedAreaChart'
Found Task: 'com.dexvis.dex.task.vis.c3.StackedBarChart'
Found Task: 'com.dexvis.dex.task.vis.c3.StepChart'
Found Task: 'com.dexvis.dex.task.vis.d3.CircularHeat'
  ** NEW CATEGORY: 'Visualization:D3'
Found Task: 'com.dexvis.dex.task.vis.d3.ClusteredForce'
Found Task: 'com.dexvis.dex.task.vis.d3.CoOccurrence'
Found Task: 'com.dexvis.dex.task.vis.d3.Force'
Found Task: 'com.dexvis.dex.task.vis.d3.IndentedTree'
Found Task: 'com.dexvis.dex.task.vis.d3.NodeLinkTree'
Found Task: 'com.dexvis.dex.task.vis.d3.PartitionLayout'
Found Task: 'com.dexvis.dex.task.vis.d3.Sankey'
Found Task: 'com.dexvis.dex.task.vis.d3.StackedRadar'
Found Task: 'com.dexvis.dex.task.vis.d3.SteamGraph'
Found Task: 'com.dexvis.dex.task.vis.d3.TensionMap'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.BarChart'
  ** NEW CATEGORY: 'Visualization:Dex Charts'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.C3Player'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.Chord'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.ChordMultiples'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.ClusteredForce'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.Dendrogram'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.DendrogramMultiples'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.DygraphLineChart'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.ForceDiagram'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.MotionBarChart'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.MotionChart'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.MotionCircleChart'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.MotionLineChart'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.Network'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.OrbitalLayout'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.ParCoor2Chord'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.ParCoor2Dendrogram'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.ParCoor2Table'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.ParallelCoordinates'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.RadarChart'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.RadialTree'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.Sankey'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.SankeyParticles'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.ScatterPlot'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.Sql2ParCoord'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.Sql2Table'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.SqlQuery'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.Sunburst'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.TitledTreemap'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.Treemap'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.dygraphs.LineChart'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.google.AreaChart'
  ** NEW CATEGORY: 'Visualization:Google'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.google.DiffBarChart'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.google.DiffPieChart'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.google.Timeline'
Found Task: 'com.dexvis.dex.task.vis.dexcharts.google.WordTree'
Found Task: 'com.dexvis.dex.task.vis.javafx.JavaFXBarChart'
  ** NEW CATEGORY: 'Visualization:JavaFX'
Found Task: 'com.dexvis.dex.task.vis.javafx.JavaFXBubbleChart'
Found Task: 'com.dexvis.dex.task.vis.javafx.JavaFXPieChart'
Found Task: 'com.dexvis.dex.task.vis.javafx.JavaFXXYChart'
Found Task: 'com.dexvis.dex.task.vis.nvd3.BarChart'
  ** NEW CATEGORY: 'Visualization:NVD3'
Found Task: 'com.dexvis.dex.task.vis.nvd3.BubbleChart'
Found Task: 'com.dexvis.dex.task.vis.nvd3.CrossFilter'
Found Task: 'com.dexvis.dex.task.vis.nvd3.DonutChart'
Found Task: 'com.dexvis.dex.task.vis.nvd3.LineChart'
Found Task: 'com.dexvis.dex.task.vis.nvd3.MultiBarChart'
Found Task: 'com.dexvis.dex.task.vis.nvd3.MultiHorBarChart'
Found Task: 'com.dexvis.dex.task.vis.nvd3.PieChart'
Found Task: 'com.dexvis.dex.task.vis.nvd3.StackedAreaChart'
Found Task: 'com.dexvis.dex.task.vis.prefuse.PrefuseGraphView'
  ** NEW CATEGORY: 'Visualization:Prefuse'
Found Task: 'com.dexvis.dex.task.vis.prefuse.PrefuseRadialGraphView'
Found Task: 'com.dexvis.dex.task.vis.prefuse.PrefuseStarburst'
Found Task: 'com.dexvis.dex.task.vis.prefuse.PrefuseTreeView'
Found Task: 'com.dexvis.dex.task.vis.table.BlueTable'
  ** NEW CATEGORY: 'Visualization:Table'
Found Task: 'com.dexvis.dex.task.vis.table.DataTable'
Found Task: 'com.dexvis.dex.task.vis.table.Grid'
Found Task: 'com.dexvis.dex.task.vis.table.SearchableTable'
Found Task: 'com.dexvis.dex.task.vis.uml.ClassDiagram'
  ** NEW CATEGORY: 'Visualization:UML'
Found Task: 'com.dexvis.dex.task.vis.uml.SequenceDiagram'
Found Task: 'com.dexvis.dex.task.vis.vis.AnimatedGraph3D'
  ** NEW CATEGORY: 'Visualization:Vis'
Found Task: 'com.dexvis.dex.task.vis.vis.BarChart'
Found Task: 'com.dexvis.dex.task.vis.vis.HierarchicalLayout'
Found Task: 'com.dexvis.dex.task.vis.vis.Network'
Found Task: 'com.dexvis.dex.task.vis.vis.Timeline'
Mouse Click Detected: 1
Mouse Click Detected: 1
Mouse Click Detected: 1
Mouse Click Detected: 2
Execute Workflow: 
Jul 17, 2016 11:16:13 AM com.sun.javafx.css.StyleConverterImpl getInstance
SEVERE: StyleConverterImpl : converter Class is null for : com.sun.javafx.scene.layout.region.CornerRadiiConverter
Jul 17, 2016 11:16:13 AM com.sun.javafx.css.StyleConverterImpl readBinary
SEVERE: could not deserialize com.sun.javafx.scene.layout.region.CornerRadiiConverter
could not deserialize com.sun.javafx.scene.layout.region.CornerRadiiConverter
Running: Read CSV
Execute Workflow: 
java.util.concurrent.RejectedExecutionException: Task java.util.concurrent.FutureTask@46895d8 rejected from java.util.concurrent.ThreadPoolExecutor@1a89e426[Terminated, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 1]
    at java.util.concurrent.ThreadPoolExecutor$AbortPolicy.rejectedExecution(ThreadPoolExecutor.java:2047)
    at java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:823)
    at java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1369)
    at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:112)
    at java.util.concurrent.Executors$DelegatedExecutorService.submit(Executors.java:678)
    at com.dexvis.dex.wf.SerialJob.execute(SerialJob.java:232)
    at com.dexvis.dex.wf.DexJobScheduler.execute(DexJobScheduler.java:14)
    at com.dexvis.dex.Dex.executeWorkflow(Dex.java:476)
    at com.dexvis.dex.Dex.lambda$15(Dex.java:262)
    at com.dexvis.dex.Dex$$Lambda$194/1000224704.handle(Unknown Source)
    at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
    at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
    at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
    at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
    at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
    at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
    at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
    at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
    at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
    at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
    at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
    at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
    at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
    at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
    at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
    at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
    at javafx.event.Event.fireEvent(Event.java:198)
    at javafx.scene.Node.fireEvent(Node.java:8390)
    at javafx.scene.control.Button.fire(Button.java:185)
    at com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(ButtonBehavior.java:182)
    at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:96)
    at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:89)
    at com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(CompositeEventHandler.java:218)
    at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:80)
    at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
    at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
    at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
    at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
    at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
    at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
    at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
    at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
    at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
    at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
    at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
    at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
    at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
    at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
    at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54)
    at javafx.event.Event.fireEvent(Event.java:198)
    at javafx.scene.Scene$MouseHandler.process(Scene.java:3758)
    at javafx.scene.Scene$MouseHandler.access$1500(Scene.java:3486)
    at javafx.scene.Scene.impl_processMouseEvent(Scene.java:1762)
    at javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2495)
    at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:350)
    at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:275)
    at java.security.AccessController.doPrivileged(Native Method)
    at com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$350(GlassViewEventHandler.java:385)
    at com.sun.javafx.tk.quantum.GlassViewEventHandler$$Lambda$387/1752046680.get(Unknown Source)
    at com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:404)
    at com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:384)
    at com.sun.glass.ui.View.handleMouseEvent(View.java:555)
    at com.sun.glass.ui.View.notifyMouse(View.java:927)

how to sort CSV Input by some columns ?

I have browsed through docs and did not find it, any link please ?

Dex not compatible with OpenJDK 8?

Hi,

When I try to start Dex I encounter this error using OpenJDK 8's runtime environment but when I use Oracle's JDK 8 there is no error and Dex starts without any problem.

(Dex) > bash startDex.sh 
Error: Could not find or load main class com.dexvis.dex.Dex
(Dex) > java -version
openjdk version "1.8.0_171"
OpenJDK Runtime Environment (build 1.8.0_171-8u171-b11-1~deb9u1-b11)
OpenJDK 64-Bit Server VM (build 25.171-b11, mixed mod

Great tool by the way,
cheers.

Word Tree not displaying

Hi,

I cloned the Dex repo and followed the tutorial videos. However, on the visualization demo, for the word tree using the AnnabeiLee.dex, the word tree graph is not displayed and when I look at the terminal output, I get this message:
'No GUI definition for: 'Word Tree' : Add getGuiDefinition() function to 'web/google/wordTree.gtmpl'

I tried this both on Windows 10 and Ubuntu 16.04. I get the same issue and message.

Any suggestion on how I can overcome this?

VARCHAR2 Error for MariaDB.

when I run create jdbc table for mysql it troughs error for VARCHAR2.

Not running on java 1.8.0_101

java.lang.RuntimeException: ControlsFX Error: ControlsFX 8.40.10 requires at least Java Version 8 Update 40

This is actually bug in controlsfx, https://bitbucket.org/controlsfx/controlsfx/issues/675/jdk-180_101-180_40#comment-29330543

please update version of dependent lib.

Browse button now working

when opening project with "incorrect path" (see #5) in the Read CSV pane
user is not able to change the path with browse button.

Clicking on Browse will not open dialog but throw and do nothing visible to user:

java.lang.IllegalArgumentException: Folder parameter must be a valid folder
at com.sun.glass.ui.CommonDialogs.convertFolder(CommonDialogs.java:238)
at com.sun.glass.ui.CommonDialogs.showFileChooser(CommonDialogs.java:190)
at com.sun.javafx.tk.quantum.QuantumToolkit.showFileChooser(QuantumToolkit.java:1496)
at javafx.stage.FileChooser.showDialog(FileChooser.java:416)
at javafx.stage.FileChooser.showOpenDialog(FileChooser.java:350)
at javafx.stage.FileChooser$showOpenDialog$2.call(Unknown Source)
at com.dexvis.dex.task.input.ReadCsv.open(ReadCsv.groovy:154)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.dexvis.javafx.event.ReflectiveActionEventHandler.handle(ReflectiveActionEventHandler.java:80)
at com.dexvis.javafx.event.ReflectiveActionEventHandler.handle(ReflectiveActionEventHandler.java:1)
at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
at javafx.event.Event.fireEvent(Event.java:198)
at javafx.scene.Node.fireEvent(Node.java:8390)
at javafx.scene.control.Button.fire(Button.java:185)
at com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(ButtonBehavior.java:182)
at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:96)
at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:89)
at com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(CompositeEventHandler.java:218)
at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:80)
at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54)
at javafx.event.Event.fireEvent(Event.java:198)
at javafx.scene.Scene$MouseHandler.process(Scene.java:3758)
at javafx.scene.Scene$MouseHandler.access$1500(Scene.java:3486)
at javafx.scene.Scene.impl_processMouseEvent(Scene.java:1762)
at javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2495)
at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:350)
at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:275)
at java.security.AccessController.doPrivileged(Native Method)
at com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$350(GlassViewEventHandler.java:385)
at com.sun.javafx.tk.quantum.GlassViewEventHandler$$Lambda$387/1712298388.get(Unknown Source)
at com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:404)
at com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:384)
at com.sun.glass.ui.View.handleMouseEvent(View.java:555)
at com.sun.glass.ui.View.notifyMouse(View.java:927)

Sankey doesn't work properly

Hi Patrick,
I'm trying to display Sankey diag from CSV data.
import CSV is OK
view table data is OK
but the sankey doesn't link the previous target to new source line.
See my capture screen:

and

As you can see, "Job Applications" target should be the source from the next lines ...
"Responded" as well ...
So, what's wrong ? thx

edit: this is the data from https://observablehq.com/@mbostock/flow-o-matic

Fix download link for `Dex 0.8.0.8`

http://dexvis.com/doku.php?id=Download
download link for Dex 0.8.0.8 is

http://dexvis.com/downloads/Dex-0.8.0.8.zip

wonderful tool, thank you~:)

sample projects, absolute vs relative paths

I'm trying to run some of the projects in ./projects folder

however it seems they contain ABSOLUTE PATHS.

Is it possible to specify project relative paths somehow ?

project/ConnectedWords.dex:            <fileText>C:\dex2ws\Dex\data\PrimeMinisters.csv</fileText>
project/MurderRateByState.dex:            <fileText>C:\dex2ws\Dex\data\CrimeStatebyState.csv</fileText>
project/OrbitalLayout.dex:            <fileText>C:\dex2ws\Dex\data\presidents.csv</fileText>
project/Player_BirthsAndDeaths.dex:            <fileText>C:\dex2ws\Dex\data\BirthsAndDeaths.csv</fileText>
project/Player_World.dex:            <fileText>D:\backup\dexciti-2015.11.10\dex2ws\Dex\data\world\health\e5b0ce31-5150-4f0a-a56d-46bbf38f73a4_Data.csv</fileText
project/VisGCBarChart.dex:            <fileText>C:\dex2ws\Dex\data\gc.csv</fileText>
project/VisNetwork.dex:            <fileText>C:\dex\data\thrones.csv</fileText>
project/VisTimeBarChart.dex:            <fileText>C:\dex2ws\Dex\data\gc.csv</fileText>
project/VisTimeline.dex:            <fileText>C:\dex\data\presidents2.csv</fileText>
project/VisTimeline_Complaints.dex:            <fileText>C:\dex\data\ConsumerComplaints.csv</fileText>
project/addrownum.dex:            <fileText>C:\dex\data\Census2014.csv</fileText>
project/c3_line_multiples.dex:            <fileText>C:\dex2ws\Dex\data\CrimeStatebyState.csv</fileText>
project/cars.dex:            <fileText>C:\dex\data\cars04.csv</fileText>
project/census.dex:            <fileText>C:\dex\data\Census2014.csv</fileText>
project/colleges.dex:            <fileText>C:\dex\data\colleges\Most+Recent+Cohorts+(Treasury+Elements).csv</fileText>
project/createAccred.dex:            <fileText>C:\dex\data\colleges\Accreditation_2015_09.csv</fileText>
project/dbinit.dex:            <fileText>C:\dex2ws\Dex\data\presidents.csv</fileText>
project/dend1.dex:            <fileText>C:\dex2ws\Dex\data\presidents.csv</fileText>
project/dend2.dex:            <fileText>C:\dex2ws\Dex\data\presidents.csv</fileText>
project/desc.dex:            <fileText>data\bank-data.csv</fileText>
project/drwho.dex:            <fileText>C:\dex2ws\Dex\data\drwho.csv</fileText>
project/gc.dex:            <fileText>C:\dex2ws\Dex\data\gc.csv</fileText>
project/meeks.dex:            <fileText>C:\dex2ws\Dex\data\presidents.csv</fileText>
project/network.dex:            <fileText>C:\dex2ws\Dex\data\PrimeMinisters.csv</fileText>
project/p5.dex:            <fileText>C:\dex2ws\Dex\data\gc.csv</fileText>
project/par.dex:            <fileText>C:\dex\data\Census2014.csv</fileText>
project/presidents.dex:            <fileText>C:\dex2ws\Dex\data\presidents.csv</fileText>
project/processing.dex:            <fileText>C:\dex2ws\Dex\data\gc.csv</fileText>
project/radar.dex:            <fileText>C:\dex2ws\Dex\data\sales.csv</fileText>
project/sequencediagram.dex:            <fileText>C:\dex\data\thrones.csv</fileText>
project/sqllite.dex:            <fileText>C:\dex2ws\Dex\data\football.csv</fileText>
project/state.dex:            <fileText>C:\dex2ws\Dex\data\presidents.csv</fileText>
project/thrones.dex:            <fileText>C:\dex\data\thrones.csv</fileText>
project/timestamp.dex:            <fileText>C:\dex\data\timestamps.csv</fileText>
project/uml.dex:            <fileText>C:\dex\data\thrones.csv</fileText>
project/uml.dex:            <fileText>C:\dex2ws\Dex\data\drwho.csv</fileText>
project/viewref.dex:            <fileText>data\gc.csv</fileText>

RejectedExecutionException - add task, remove task and hit Execute

Hello there, I'm playing with your tool and after few quick clicks I get this.

I have added some tasks, then removed them all and clicked execute,
do not know if this is intended behavior, but I would expect bit more readable output.

Sorry if this is 'bad' bug report.

java.util.concurrent.RejectedExecutionException: Task java.util.concurrent.FutureTask@6f8550a rejected from java.util.concurrent.ThreadPoolExecutor@1cc4e93e[Terminated, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 1]
at java.util.concurrent.ThreadPoolExecutor$AbortPolicy.rejectedExecution(ThreadPoolExecutor.java:2047)
at java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:823)
at java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1369)
at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:112)
at java.util.concurrent.Executors$DelegatedExecutorService.submit(Executors.java:678)
at com.dexvis.dex.wf.SerialJob.execute(SerialJob.java:232)
at com.dexvis.dex.wf.DexJobScheduler.execute(DexJobScheduler.java:14)
at com.dexvis.dex.Dex.executeWorkflow(Dex.java:443)
at com.dexvis.dex.Dex.lambda$15(Dex.java:229)
at com.dexvis.dex.Dex$$Lambda$194/535657287.handle(Unknown Source)
at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
at javafx.event.Event.fireEvent(Event.java:198)
at javafx.scene.Node.fireEvent(Node.java:8390)
at javafx.scene.control.Button.fire(Button.java:185)
at com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(ButtonBehavior.java:182)
at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:96)
at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:89)
at com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(CompositeEventHandler.java:218)
at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:80)
at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54)
at javafx.event.Event.fireEvent(Event.java:198)
at javafx.scene.Scene$MouseHandler.process(Scene.java:3758)
at javafx.scene.Scene$MouseHandler.access$1500(Scene.java:3486)
at javafx.scene.Scene.impl_processMouseEvent(Scene.java:1762)
at javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2495)
at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:350)
at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:275)
at java.security.AccessController.doPrivileged(Native Method)
at com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$350(GlassViewEventHandler.java:385)
at com.sun.javafx.tk.quantum.GlassViewEventHandler$$Lambda$387/1183809541.get(Unknown Source)
at com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:404)
at com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:384)
at com.sun.glass.ui.View.handleMouseEvent(View.java:555)
at com.sun.glass.ui.View.notifyMouse(View.java:927)

Is this project "retired"?

Hi.... I don't have a lot of experience with this tool yet, but long story short, I'm very interested both personally and professionally. It looks like commits have stopped and your new website is no longer accessible. Just wondering if you've stopped development here and have moved onto something else?