自动创建机架图 [英] Automatically create Rack Diagrams

问题描述

HI，

我有一个excel文档，我想用它来创建Visio中的服务器机架图。我可以将对象链接到形状没有问题，但我想要做的是使用我在excel中的机架位置信息自动将对象（服务器
/开关等）放置在图表右侧机架内。 / p>

有任何想法如何做到这一点？

谢谢

Denis

---

问候，

Denis Cooper

MCITP EA - MCT

帮助保持论坛整洁，如果这有帮助请将其标记为答案

博客： LinkedIn：

解决方案

Denis，

这是一个非常常见的请求，我通常只是简单地回复，

"将需要大量的代码"，"和"使用关系数据库，而不是

Excel"。它基本上是Bill of Materials类型的应用程序。您可以查看

Chris Roth的网站'www.visguy.com'，了解一些想法。我用VB.net和SQL服务器做了类似的事情

。以下是讨论视频。

https://www.youtube.com/playlist?list=PLBAFAAC68D36484CA

hth，

al edlund

HI,

I have an excel document that I wanted to use to create a server Rack Diagram in Visio. I can link the objects to shapes no problem, but what I wanted to do was use the rack position information I have in excel to automatically position the objects (servers / switches etc) within the right rack on the diagram.

Any ideas how to do this?

Thanks

Denis

---

Regards,

Denis Cooper

MCITP EA - MCT

Help keep the forums tidy, if this has helped please mark it as an answer

Blog: http://www.windows-support.co.uk  Twitter:   LinkedIn:

解决方案

Denis,

This is a very common request that I usually just put in a shorthand response of ,

"Will require an extensive amount of code", and, "use a relational database, not

Excel". It is basically a Bill Of Materials type of application. You might check out

Chris Roth's site 'www.visguy.com' for some thoughts. I did something similar

with VB.net and SQL server. Here are the discussion videos.

https://www.youtube.com/playlist?list=PLBAFAAC68D36484CA

hth,

al edlund

这篇关于自动创建机架图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！