vba - Graphically displaying linked data -


i'm researching on way graphically display linked items within database. have list of screens on hmi scada system , i'm trying take list of screens links other screens can show chart representing how each screen linked another. screens can link several screens via navigation buttons.

what thinking doing through ms access build database , use visio build it, thought ask here see if might have idea easier want without me having design scratch.

i have 1 master table such this:

id           screen 1            home 2            page1 3            page2 4            page3 5            page4 6            page5 7            page6 8            page7 9            page8 10           page9

then have table holds links. id primary key , mid (master id) , lid (link id) linked id in master table.

id           mid          lid 1            1            2 2            1            3 3            1            4 4            1            5 5            2            1 6            2            6 7            3            1 8            3            4 9            3            7 10           3            8 11           3            9 12           3            10

from here, want build chart of kind draw screen names in boxes , show lines link boxes together.

any ideas improve this? open other programs if make easier. preferably free programs.

also, can code in vba, python, , started learning java if information help.

it sounds need graph visualizer, screens nodes , connections edges.

first find graph visualizer want use, figure out how store data based on that.

since said know python, maybe should check out 1 of libraries in this question. i've seen excel plugins graph visualization, imagine aren't cheap.


Comments

Post a Comment

Popular posts from this blog

javascript - RequestAnimationFrame not working when exiting fullscreen switching space on Safari -

request animation frame stops working when exiting fullscreen clicking on original space's safari window. fine if fullscreen mode canceled escape key or calling cancelfullscreen(). steps reproduce: open https://dl.dropboxusercontent.com/u/769042/prezi/safari-fullscreen.html click "draw raf", kittie appears click "fullscreen", go fullscreen click "draw raf", kittie appears go space original safari was, showing "click exit fullscreen mode", click anywhere, out fullscreen click "draw raf", nothing happens what handling click calling: window.requestanimationframe(draw); which draws on canvas context: function draw() { ctx.drawimage(img, math.random()*500|0, math.random()*400|0, 100, 100); } i checked .hidden , .visibilitystate, updated correctly. tested on osx 10.9.3, safari 7.0.4 (9537.76.4). has workaround/solution other switching old settimeout? this sounds webkit bug 88940 : using reque
Read more

Python ctypes access violation with const pointer arguments -

i have api i'm trying wrap in python (2.7.6 on win7) code using ctypes. here's api: client_dllfunc bool clientapi search_exporttoclipcopy(clienthsearch handle, int channel, lpctstr filename, const time_t& from, const time_t& to, const bool* cameras, int length, bool usepassword, lpctstr password, bool includetextin = false, bool excludeplayer = false); the issue i'm having cameras argument; , i've had issue other const pointer arguments well. here's how i'm wrapping api: def search_exporttoclipcopy(self, hsearch, csearch, filename, tfrom, tto, cameras, length, usepassword, password, includetextin=true, excludeplayer=false): exporttoclipcopy = self.sdkdll.search_exporttoclipcopy exporttoclipcopy.argtypes = [c_int, c_int, c_wchar_p, c_long, c_long, pointer(c_bool), c_int, c_bool, c_wchar_p, c_bool, c_bool] exporttoclipcopy.restype = c_bool exporttoclipcopy(hsearch, csearch, filename, tfrom, tto, cameras, length, usepassword, pass
Read more