将实体关系从 Excel 导入 Visio

将实体关系从 Excel 导入 Visio

寻求帮助/任何建议,将 Excel 数据中的非常大的多对多实体关系图导入 Visio 中的关系图中。

我的数据正在识别实体的上游和下游依赖关系,我正在寻找一种从数据提取中轻松可视化这种关系的方法。组织层次结构导入失败,因为我的顶级数据可能依赖于多个底层上游数据集。一个顶级数据集可以对中/低级数据集具有多个底层依赖关系,而这些中/低级数据集有时可以汇总到其他顶级数据集中。

一个例子包括像这样结构的数据在此处输入图片描述

我找到了一篇文章,它基本上做了我想从 Visio 2002 开始做的事情,但我似乎找不到该功能是否仍然受支持: https://boxesandarrows.com/automating-diagrams-with-visio/

本文介绍了一种格式如下的 CSV 文件,用于创建具有编号模式的形状以唯一地标识形状:

Shape,"1.0","","Top A"
Shape,"1.1","","Top B"
Shape,"1.2","","Top C"
Shape,"1.3","","Top D"
Shape,"2.0","","Med A"
Shape,"3.0","","Bot A"
Shape,"3.1","","Bot B"
Shape,"3.2","","Bot C"
Shape,"3.3","","Bot D"

然后像这样附加行,使用其唯一的编号模式在形状之间创建链接:

Link,"","","","1.0","2.0"
Link,"","","","1.1","2.0"
Link,"","","","2.0","3.0"
Link,"","","","2.0","3.1"
Link,"","","","1.2","3.1"
Link,"","","","1.3","3.2"
Link,"","","","1.3","3.3"

Visio 2016(甚至专业版)似乎没有简单的方法来处理此类数据。非常感谢任何有关如何以可视格式获取这些数据以更好地解释其中一些关系的建议。

相关内容