Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "metadata": {
- "name": "E2GXF",
- "type": "Excel to Graphviz Exchange Format",
- "version": "1.0",
- "user": "Jeffrey Long",
- "date": "2020-11-04",
- "time": "15:25:06",
- "os": "Windows (32-bit) NT 10.00",
- "excel": "16.0",
- "filename": "Relationship Visualizer - ERD Example.xlsm"
- },
- "content": {
- "data": [
- {
- "row": 2,
- "hidden": false,
- "height": 15
- },
- {
- "row": 3,
- "hidden": false,
- "height": 15,
- "item": "node",
- "styleName": "Table"
- },
- {
- "row": 4,
- "hidden": false,
- "height": 15,
- "item": "edge",
- "styleName": "One To Many"
- },
- {
- "row": 5,
- "hidden": false,
- "height": 15,
- "enabled": false
- },
- {
- "row": 6,
- "hidden": false,
- "height": 30,
- "item": ">",
- "label": "nodesep=\"0.75\" ranksep=\"0.75\""
- },
- {
- "row": 7,
- "hidden": false,
- "height": 15,
- "item": ">",
- "label": "sep=\"+36,36\""
- },
- {
- "row": 8,
- "hidden": false,
- "height": 15
- },
- {
- "row": 9,
- "hidden": false,
- "height": 120,
- "item": "BATCH_CONFIGURATION",
- "label": "{\\N|file_name \\lfile_path \\ltemplate_name \\lbusiness_unit_code \\l id \\lcountry_code \\llanguage_code \\l records_per_file \\l last_run_time \\l schedule \\l method_code \\l}"
- },
- {
- "row": 10,
- "hidden": false,
- "height": 30,
- "item": "BUSINESS_UNIT",
- "label": "{\\N|business_unit_code (PK) \\ldescription \\l}"
- },
- {
- "row": 11,
- "hidden": false,
- "height": 30,
- "item": "COUNTRY",
- "label": "{\\N|country_code (PK) \\lcountry_name\\l}"
- },
- {
- "row": 12,
- "hidden": false,
- "height": 30,
- "item": "LANGUAGE",
- "label": "{\\N|language_code (PK) \\llanguage_name\\l}"
- },
- {
- "row": 13,
- "hidden": false,
- "height": 45,
- "item": "ATTRIBUTES",
- "label": "{\\N|id (PK) \\lnrq_id \\lattribute_value \\lattribute_name \\l}"
- },
- {
- "row": 14,
- "hidden": false,
- "height": 180,
- "item": "REQUEST_QUEUE",
- "label": "{\\N |id (PK) \\ltracking_id \\lrequest_source_code (FK) \\lrequest_state_code (FK) \\lsystem_id \\ltemplate_name \\lseverity \\lcategory \\lbusiness_unit_code (FK) \\lcountry_code (FK) \\llanguage_code (FK) \\lretry_limit \\lprocess_after_dt \\lcreate_dt \\llast_updated_dt \\lcreated_by \\lto_address \\ltype \\ljob_type \\l}"
- },
- {
- "row": 15,
- "hidden": false,
- "height": 165,
- "item": "TEMPLATES",
- "label": "{\\N|template_id (PK) \\ltemplate_name \\lbusiness_unit_code (FK) \\llanguage_code (FK) \\lcountry_code (FK) \\lmethod_code (FK) \\ltransmit_mode_code (FK) \\lsend_classification_code (FK) \\lcountry_code (FK) \\llanguage_code (FK) \\ljob_type \\l}"
- },
- {
- "row": 16,
- "hidden": false,
- "height": 240,
- "item": "WORK_QUEUE",
- "label": "{\\N|id (PK) \\lrequest_queue_id \\ltracking_id \\lwork_state_code (FK) \\lmethod_code (FK) \\lretry_limit \\lto_address \\ltime_zone_code \\lprocess_after_dt \\lcreate_dt \\llast_updated_dt \\lcreated_by \\ltemplate_name \\lbusiness_unit_code (FK) \\lcountry_code (FK) \\llanguage_code (FK) \\laction_category \\ljob_type \\l}"
- },
- {
- "row": 17,
- "hidden": false,
- "height": 30,
- "item": "REQUEST_SOURCE",
- "label": "{\\N|request_source_code (PK) \\ldescription \\l}"
- },
- {
- "row": 18,
- "hidden": false,
- "height": 30,
- "item": "REQUEST_STATE",
- "label": "{\\N|request_state_code (PK) \\ldescription\\l}"
- },
- {
- "row": 19,
- "hidden": false,
- "height": 30,
- "item": "SEND_CLASSIFICATION",
- "label": "{\\N|send_classification_code (PK)\\ldescription\\l}"
- },
- {
- "row": 20,
- "hidden": false,
- "height": 60,
- "item": "TEMPLATE_ATTRIBUTES",
- "label": "{\\N|attribute_id (PK) \\lattribute_name \\lattribute_description \\ltemplate_name \\l}"
- },
- {
- "row": 21,
- "hidden": false,
- "height": 30,
- "item": "TRANSMIT_MODE",
- "label": "{\\N|transmit_mode_code (PK) \\ldescription\\l}"
- },
- {
- "row": 22,
- "hidden": false,
- "height": 30,
- "item": "WORK_STATE",
- "label": "{\\N|work_state_code (PK)\\ldescription\\l}"
- },
- {
- "row": 23,
- "hidden": false,
- "height": 15,
- "enabled": false,
- "item": "PK to FK Relationships"
- },
- {
- "row": 24,
- "hidden": false,
- "height": 15,
- "item": "BUSINESS_UNIT",
- "relatedItem": "BATCH_CONFIGURATION"
- },
- {
- "row": 25,
- "hidden": false,
- "height": 15,
- "item": "BUSINESS_UNIT",
- "relatedItem": "REQUEST_QUEUE"
- },
- {
- "row": 26,
- "hidden": false,
- "height": 15,
- "item": "BUSINESS_UNIT",
- "relatedItem": "TEMPLATES"
- },
- {
- "row": 27,
- "hidden": false,
- "height": 15,
- "item": "COUNTRY",
- "relatedItem": "BATCH_CONFIGURATION"
- },
- {
- "row": 28,
- "hidden": false,
- "height": 15,
- "item": "COUNTRY",
- "relatedItem": "REQUEST_QUEUE"
- },
- {
- "row": 29,
- "hidden": false,
- "height": 15,
- "item": "COUNTRY",
- "relatedItem": "TEMPLATES"
- },
- {
- "row": 30,
- "hidden": false,
- "height": 15,
- "item": "LANGUAGE",
- "relatedItem": "REQUEST_QUEUE"
- },
- {
- "row": 31,
- "hidden": false,
- "height": 15,
- "item": "LANGUAGE",
- "relatedItem": "TEMPLATES"
- },
- {
- "row": 32,
- "hidden": false,
- "height": 15,
- "item": "REQUEST_QUEUE",
- "relatedItem": "ATTRIBUTES"
- },
- {
- "row": 33,
- "hidden": false,
- "height": 15,
- "item": "REQUEST_QUEUE",
- "relatedItem": "WORK_QUEUE"
- },
- {
- "row": 34,
- "hidden": false,
- "height": 15,
- "item": "TEMPLATES",
- "relatedItem": "BATCH_CONFIGURATION"
- },
- {
- "row": 35,
- "hidden": false,
- "height": 15,
- "item": "TEMPLATES",
- "relatedItem": "REQUEST_QUEUE"
- },
- {
- "row": 36,
- "hidden": false,
- "height": 15,
- "item": "TEMPLATES",
- "relatedItem": "TEMPLATE_ATTRIBUTES",
- "styleName": "Related by value"
- },
- {
- "row": 37,
- "hidden": false,
- "height": 15,
- "item": "REQUEST_SOURCE",
- "relatedItem": "REQUEST_QUEUE"
- },
- {
- "row": 38,
- "hidden": false,
- "height": 15,
- "item": "REQUEST_STATE",
- "relatedItem": "REQUEST_QUEUE"
- },
- {
- "row": 39,
- "hidden": false,
- "height": 15,
- "item": "SEND_CLASSIFICATION",
- "relatedItem": "TEMPLATES"
- },
- {
- "row": 40,
- "hidden": false,
- "height": 15,
- "item": "SEND_CLASSIFICATION",
- "relatedItem": "WORK_QUEUE"
- },
- {
- "row": 41,
- "hidden": false,
- "height": 15,
- "item": "TRANSMIT_MODE",
- "relatedItem": "TEMPLATES"
- },
- {
- "row": 42,
- "hidden": false,
- "height": 15,
- "item": "TRANSMIT_MODE",
- "relatedItem": "WORK_QUEUE"
- },
- {
- "row": 43,
- "hidden": false,
- "height": 15,
- "item": "WORK_STATE",
- "relatedItem": "WORK_QUEUE"
- }
- ],
- "styles": [
- {
- "row": 2,
- "hidden": false,
- "height": 15,
- "name": "node",
- "type": "node",
- "viewSwitches": [
- "yes"
- ]
- },
- {
- "row": 3,
- "hidden": false,
- "height": 15,
- "name": "edge",
- "type": "edge",
- "viewSwitches": [
- "yes"
- ]
- },
- {
- "row": 4,
- "hidden": false,
- "height": 15,
- "name": "subgraph-open",
- "type": "subgraph-open",
- "viewSwitches": [
- "yes"
- ]
- },
- {
- "row": 5,
- "hidden": false,
- "height": 15,
- "name": "subgraph-close",
- "type": "subgraph-close",
- "viewSwitches": [
- "yes"
- ]
- },
- {
- "row": 6,
- "hidden": false,
- "height": 15,
- "name": "keyword",
- "type": "keyword",
- "viewSwitches": [
- "yes"
- ]
- },
- {
- "row": 7,
- "hidden": false,
- "height": 15,
- "name": "native",
- "type": "native",
- "viewSwitches": [
- "yes"
- ]
- },
- {
- "row": 8,
- "hidden": false,
- "height": 30,
- "name": "Table",
- "type": "node",
- "format": {
- "shape": "record",
- "fontname": "Calibri",
- "fontsize": "10",
- "fillcolor": "cornsilk",
- "style": "filled",
- "width": "1.5"
- },
- "viewSwitches": [
- "yes"
- ]
- },
- {
- "row": 9,
- "hidden": false,
- "height": 15,
- "name": "Invisible Node",
- "type": "node",
- "format": {
- "color": "invis"
- },
- "viewSwitches": [
- "yes"
- ]
- },
- {
- "row": 10,
- "hidden": false,
- "height": 15,
- "name": "Invisible Edge",
- "type": "edge",
- "format": {
- "color": "invis"
- },
- "viewSwitches": [
- "yes"
- ]
- },
- {
- "row": 11,
- "hidden": false,
- "height": 30,
- "name": "Parent Child",
- "type": "edge",
- "format": {
- "dir": "both",
- "arrowhead": "dot",
- "arrowtail": "odiamond",
- "fontname": "Calibri",
- "fontsize": "10"
- },
- "viewSwitches": [
- "yes"
- ]
- },
- {
- "row": 12,
- "hidden": false,
- "height": 30,
- "name": "One To One",
- "type": "edge",
- "format": {
- "dir": "both",
- "arrowhead": "nonetee",
- "arrowtail": "nonetee",
- "fontname": "Calibri",
- "fontsize": "12",
- "fontcolor": "blue"
- },
- "viewSwitches": [
- "yes"
- ]
- },
- {
- "row": 13,
- "hidden": false,
- "height": 30,
- "name": "One To Many",
- "type": "edge",
- "format": {
- "dir": "both",
- "arrowhead": "crow",
- "arrowtail": "nonetee",
- "fontname": "Calibri",
- "fontsize": "12",
- "fontcolor": "blue"
- },
- "viewSwitches": [
- "yes"
- ]
- },
- {
- "row": 14,
- "hidden": false,
- "height": 30,
- "name": "Many To One",
- "type": "edge",
- "format": {
- "dir": "both",
- "arrowtail": "crow",
- "arrowhead": "nonetee",
- "fontname": "Calibri",
- "fontsize": "12",
- "fontcolor": "blue"
- },
- "viewSwitches": [
- "yes"
- ]
- },
- {
- "row": 15,
- "hidden": false,
- "height": 45,
- "name": "Related by value",
- "type": "edge",
- "format": {
- "style": "dotted",
- "dir": "both",
- "arrowhead": "dot",
- "arrowtail": "odiamond",
- "fontname": "Calibri",
- "fontsize": "10"
- },
- "viewSwitches": [
- "yes"
- ]
- } ],
- "sql": [
- ]
- },
- "settings": {
- "data": {
- "graphToWorksheet": {
- "runMode": "manual",
- "imageType": "png",
- "imageWorksheet": "graph"
- },
- "graphToFile": {
- "directory": "",
- "fileNamePrefix": "graph",
- "imageType": "pdf",
- "appendOptions": false,
- "appendTimeStamp": false
- },
- "layout": {
- "engine": "dot",
- "direction": "top to bottom",
- "rankdir": "TB",
- "splines": "ortho"
- },
- "options": {
- "graph": {
- "center": false,
- "graphType": "directed",
- "compound": false,
- "forceLabels": false,
- "newrank": false,
- "orientation": false,
- "outputOrder": "",
- "overlap": "",
- "transparentBackground": false
- },
- "nodes": {
- "includeOrphanNodes": true,
- "includeNodeLabels": true,
- "includeNodeXLabels": true,
- "blankNodeLabels": "default"
- },
- "edges": {
- "addStrict": true,
- "concentrate": false,
- "includeOrphanEdges": true,
- "includeEdgeHeadLabels": true,
- "includeEdgeLabels": true,
- "includeEdgeXLabels": true,
- "includeEdgeTailLabels": false,
- "includeEdgePorts": true,
- "blankEdgeLabels": "blank"
- }
- },
- "styles": {
- "selectedViewColumn": "E",
- "includeStyleFormat": true,
- "includeExtraAttributes": true
- },
- "debug": {
- "debug": "off",
- "fileDisposition": "delete"
- },
- "columns": {
- "flag": "show",
- "item": "show",
- "label": "show",
- "outsideLabel": "hide",
- "tailLabel": "hide",
- "headLabel": "hide",
- "relatedItem": "show",
- "styleName": "show",
- "extraAttributes": "hide",
- "message": "hide"
- }
- },
- "graph": {
- "zoom": 70
- },
- "settings": {
- "additionalGraphOptions": "",
- "maxSeconds": 60,
- "pictureName": "",
- "additionalCmdParameters": ""
- },
- "source": {
- "indent": 4,
- "buttons": [
- {
- "id": "SourceWeb1",
- "buttonText": "Graphviz Fiddle",
- "url": "http://stamm-wilbrandt.de/GraphvizFiddle/",
- "screenTip": "On-line code editor for Graphviz",
- "superTip": "GraphvizFiddle draws DOT language [directed] graphs. It is a dual-view Graphviz editor and playground for Graphviz written by Hermann Stamm-Wilbrandt.",
- "visible": "show"
- },
- {
- "id": "SourceWeb2",
- "buttonText": "Pocket Reference",
- "url": "http://graphs.grevian.org/graph",
- "screenTip": "On-line code editor for Graphviz",
- "superTip": "An on-line code editor for Graphviz written by Josh Hayes-Sheen for Computer Science students.",
- "visible": "show"
- },
- {
- "id": "SourceWeb3",
- "buttonText": "Graphviz Online",
- "url": "http://dreampuf.github.io/GraphvizOnline/",
- "screenTip": "On-line code editor for Graphviz",
- "superTip": "Online Graphviz editor with syntax higlighting.",
- "visible": "show"
- },
- {
- "id": "SourceWeb4",
- "buttonText": "Sketchviz",
- "url": "https://sketchviz.com/new",
- "screenTip": "On-line code editor for Graphviz",
- "superTip": "Renders Graphviz diagrams as if sketched by hand.",
- "visible": "show"
- },
- {
- "id": "SourceWeb5",
- "visible": "hide"
- },
- {
- "id": "SourceWeb6",
- "visible": "hide"
- }
- ]
- },
- "extensions": {
- "tabName": "Extensions",
- "customCode": {
- "groupName": "Custom Code",
- "buttons": [
- {
- "id": "ExtCode1",
- "visible": "hide"
- },
- {
- "id": "ExtCode2",
- "visible": "hide"
- },
- {
- "id": "ExtCode3",
- "visible": "hide"
- },
- {
- "id": "ExtCode4",
- "visible": "hide"
- },
- {
- "id": "ExtCode5",
- "visible": "hide"
- },
- {
- "id": "ExtCode6",
- "visible": "hide"
- }
- ]
- },
- "webResources": {
- "groupName": "Web Resources",
- "buttons": [
- {
- "id": "ExtWeb1",
- "visible": "hide"
- },
- {
- "id": "ExtWeb2",
- "visible": "hide"
- },
- {
- "id": "ExtWeb3",
- "visible": "hide"
- },
- {
- "id": "ExtWeb4",
- "visible": "hide"
- },
- {
- "id": "ExtWeb5",
- "visible": "hide"
- },
- {
- "id": "ExtWeb6",
- "visible": "hide"
- }
- ]
- }
- }
- },
- "layouts": {
- "data": {
- "rows": [
- {
- "id": "heading",
- "row": 1,
- "height": 15,
- "hidden": false
- },
- {
- "id": "first",
- "row": 2,
- "height": 15,
- "hidden": false
- }
- ],
- "columns": [
- {
- "id": "flag",
- "column": 1,
- "heading": "",
- "width": 1.71,
- "hidden": false,
- "wrapText": false
- },
- {
- "id": "item",
- "column": 2,
- "heading": "Item",
- "width": 27.14,
- "hidden": false,
- "wrapText": false
- },
- {
- "id": "label",
- "column": 4,
- "heading": "Label",
- "width": 31.29,
- "hidden": false,
- "wrapText": true
- },
- {
- "id": "outsideLabel",
- "column": 5,
- "heading": "Outside Label",
- "width": 0,
- "hidden": true,
- "wrapText": true
- },
- {
- "id": "tailLabel",
- "column": 3,
- "heading": "Tail Label",
- "width": 0,
- "hidden": true,
- "wrapText": true
- },
- {
- "id": "headLabel",
- "column": 6,
- "heading": "Head Label",
- "width": 0,
- "hidden": true,
- "wrapText": true
- },
- {
- "id": "relatedItem",
- "column": 7,
- "heading": "Related Item",
- "width": 27.14,
- "hidden": false,
- "wrapText": null
- },
- {
- "id": "styleName",
- "column": 8,
- "heading": "Style Name",
- "width": 27,
- "hidden": false,
- "wrapText": true
- },
- {
- "id": "extraAttributes",
- "column": 9,
- "heading": "Extra Style Attributes",
- "width": 0,
- "hidden": true,
- "wrapText": true
- },
- {
- "id": "message",
- "column": 10,
- "heading": "Messages",
- "width": 0,
- "hidden": true,
- "wrapText": false
- },
- {
- "id": "graphDisplayColumn",
- "column": 11,
- "heading": "",
- "width": 8.57,
- "hidden": false,
- "wrapText": true
- }
- ]
- },
- "styles": {
- "rows": [
- {
- "id": "heading",
- "row": 1,
- "height": 48,
- "hidden": false
- },
- {
- "id": "first",
- "row": 2,
- "height": 15,
- "hidden": false
- }
- ],
- "columns": [
- {
- "id": "flag",
- "column": 1,
- "heading": "",
- "width": 1.71,
- "hidden": false,
- "wrapText": true
- },
- {
- "id": "name",
- "column": 2,
- "heading": "Style Name",
- "width": 21.14,
- "hidden": false,
- "wrapText": null
- },
- {
- "id": "format",
- "column": 3,
- "heading": "Format",
- "width": 50.71,
- "hidden": false,
- "wrapText": true
- },
- {
- "id": "type",
- "column": 4,
- "heading": "Style Type",
- "width": 16.57,
- "hidden": false,
- "wrapText": null
- },
- {
- "id": "view0",
- "column": 5,
- "heading": "All Styles",
- "width": 7.43,
- "hidden": false,
- "wrapText": null
- }
- ],
- "ranges": [
- {
- "name": "Type",
- "range": "$B$2:$B$37"
- }
- ]
- },
- "sql": {
- "rows": [
- {
- "id": "heading",
- "row": 1,
- "height": 25.5,
- "hidden": false
- },
- {
- "id": "first",
- "row": 2,
- "height": 15,
- "hidden": false
- }
- ],
- "columns": [
- {
- "id": "flag",
- "column": 1,
- "heading": "",
- "width": 1.71,
- "hidden": false,
- "wrapText": false
- },
- {
- "id": "sqlStatement",
- "column": 2,
- "heading": "SQL SELECT Statement",
- "width": 55.14,
- "hidden": false,
- "wrapText": false
- },
- {
- "id": "excelFile",
- "column": 3,
- "heading": "Excel data file (.xlsx, .xlsm, .xlsb, or .xls only)",
- "width": 34.71,
- "hidden": false,
- "wrapText": true
- },
- {
- "id": "status",
- "column": 4,
- "heading": "Status",
- "width": 21.57,
- "hidden": false,
- "wrapText": true
- }
- ]
- },
- "source": {
- "rows": [
- {
- "id": "heading",
- "row": 1,
- "height": 15,
- "hidden": false
- },
- {
- "id": "first",
- "row": 2,
- "height": 15,
- "hidden": false
- }
- ],
- "columns": [
- {
- "id": "lineNumber",
- "column": 1,
- "heading": "Line",
- "width": 6.57,
- "hidden": false,
- "wrapText": false
- },
- {
- "id": "source",
- "column": 2,
- "heading": "Graphviz Source",
- "width": 168.14,
- "hidden": false,
- "wrapText": true
- }
- ]
- }
- }
- }
Add Comment
Please, Sign In to add comment