[推荐]：Microsoft Office Importer

sun369

在 MicroStation 上动态链接Excel 和 Word 文件数据的工具

Microsoft Office Importer for V8 enables MicroStation users to import and link nearly unlimited quantities of spreadsheet data into MicroStation with ease, formatting and reliability vastly superior to MicroStation’s built-in LiveLinks command. On a test conducted, Microsoft Office Importer for V8 had no problem in pasting an Microsoft Excel spreadsheet containing 14 columns and 700 rows of data with a single paste.
Microsoft Office Importer for V8 uses a more reliable method of linking and automatically synchronizing the spreadsheet file with the MicroStation file; the links to Microsoft Excel and Word files created by Microsoft Office Importer for V8 are very stable and do not cause MicroStation file corruption, even when unlinked.
Microsoft Office Importer for V8 allows the linked data in the MicroStation file to be updated automatically each time it is opened or on command from the user. Microsoft Office Importer for V8 also provides far greater formatting control of the elements it creates in MicroStation; the linked data retains the grid lines, text size, italics, bolding, underline, line spacing and other visual aspects of the spreadsheet or word processing file being placed. Microsoft Office Importer for V8 can also import and link in data from Microsoft Word files.
Plus, the data Microsoft Office Importer for V8 imports can be easily edited since it抯 pasted as easy-to-edit, multiple character text and text node elements.
Microsoft Office Importer for V8 consists of one MDL component and one Windows Dynamic Link Library (DLL) component.

                               
登录/注册后可看大图

操作步骤：
1、In order for Microsoft Office Importer to update pasted data automatically each time a MicroStation file is started, it must be added as one of the applications that starts every time a MicroStation file is opened. To do this, select the MicroStation “Workspace” menu and select “Configuration”.

                               
登录/注册后可看大图

2、The “Configuration” dialog box pops up. In the “View/modify all configuration variables” section, scroll down and select the configuration variable called “MS_DGNAPPS”. Configuration variables hold information [which can be modified according to the needs of a MicroStation department] that is used to customize the MicroStation environment of a user or a site. In this case, by modifying the MS_DGNAPPS configuration variable, you will tell MicroStation to start Microsoft Office Importer every time a MicroStation file is opened.

                               
登录/注册后可看大图

3、Click on the <Edit> button. In the “New Value” field, move the cursor to the end of the existing value. Type a semicolon (;) and then the following line: “$(AXI)office\office.ma”. The “$(AXI)” value tells MicroStation where Axiom products are installed. “Office\office.ma” is where the Microsoft Office Importer application file is relative to the Axiom root directory.

                               
登录/注册后可看大图

4、Click <OK>, and click <OK> again. Then, click <Yes> when asked to save the changes to your configuration file. Then, restart MicroStation.

                               
登录/注册后可看大图

5、Once MicroStation restarts, you’ll notice that Microsoft Office Importer toolbar is loaded.

                               
登录/注册后可看大图

6、You’re now ready to paste linked data into MicroStation. Open the Excel spreadsheet or Word document and copy the contents you want to link. Go back to MicroStation and click on Microsoft Office Importer’s “Paste” button.

                               
登录/注册后可看大图

7、You’ll see the “Paste” dialog box pop up. To enable the automatic update of links, check the “Import with link to original document” checkbox and the “Update automatically when design file opens” checkbox.

                               
登录/注册后可看大图

8、Now enter a data point, and your data is immediately pasted and linked! To see the link information, click on the “Link Info” button. The link information is displayed right above the linked data as in the example below.

                               
登录/注册后可看大图

From this moment on, every time the design file is opened, Microsoft Office Importer checks the linked data against the data in the source file, and updates it in the MicroStation file when it has changed — no user intervention required!
Updating linked data while working on the MicroStation file
If the source document is modified (and the changes are saved) after having been linked in the MicroStation file, and the MicroStation file is opened, the linked data can still easily be updated without reopening the MicroStation file. To do this, simply:
1. Click on the “Manage Import Link” button.

                               
登录/注册后可看大图

2. Then, double-click on any of the elements inside the linked data area. In the “Manage Import Links” dialog box that opens, click on the <Update> button

                               
登录/注册后可看大图

Microsoft Office Importer immediately updates the linked data with the latest modifications in the source file.

点击下载 for MicroStation 95/SE/J or V8.
点击下载 for MicroStation 95/SE/J.

xmlinet

解压时要密码啊 ，第一个，请指点啊，多谢。

sun369

silver

xmlinet

对不起，还得请教，没有forv8的程序，v8里调用提示bad  version number！

sun369

我的没有出现这种情况

键入:MDL LOAD C:\AXI-TEMP\USTN\V8\INSTALL

xmlinet

我解压下载的文件后就没有v8的目录，没有C:\AXI-TEMP\USTN\V8\INSTALL.ma文件。两个下载文件都是的。请赐教！

brain

sun369老兄，感谢你为大家找到这么有用的小东东。我去过www.axiomint.com主页了，我� ... �看到的Microsoft office importer和Filefixer等软件。在那里，有demo版的可以下载，但我不知道这个demo版的和full-featured版到底有哪些区别，你能告诉我们吗？万分感谢！

sun369

最初由 xmlinet 发布
[B]我解压下载的文件后就没有v8的目录，没有C:\AXI-TEMP\USTN\V8\INSTALL.ma文件。两个下载文件都是的。请赐教！ [/B]

要么就在这里C:\Program Files\Axiom\V8,
这里就没有INSTALL.ma

sun369

最初由 brain 发布
[B]sun369老兄，感谢你为大家找到这么有用的小东东。我去过www.axiomint.com主页了，我� ... �看到的Microsoft office importer和Filefixer等软件。在那里，有demo版的可以下载，但我不知道这个dem... [/B]

我也不太清楚,我看到后觉得好就贴上来了

xmlinet

最初由 sun369 发布
[B]

要么就在这里C:\Program Files\Axiom\V8,
这?.. [/B]

可是我下载的文件是changer.exe，解压后没有v8目录，更没有Axiom目录。

gp341

那就是用V7嘛
这个软件有什么用 请用中文说一下好吗？？？？

sun369

最初由 gp341 发布
[B]那就是用V7嘛
这个软件有什么用 请用中文说一下好吗？？？？ [/B]

一个全球化的设计文件转换工具

The problem with most MicroStation sites is that they have more than one design file. If each site had just one design file, making system wide changes would be easy.

If you only had one design file and you wanted to start using a new cell library, all you would have to do is bring up the (only) design file with MicroStation and enter RC=newlib.cel. Your problem would quickly be solved.

But what if you want to change the cell library for a project that consists of 85 design files?

Bad Solution #1

Theoretically you could do 搉othing? You could just tell your operators to wait until the next time they got into each design file and enter RC=newlib.cel at that time. But then for a period of time some design files would be using one cell library while other design files were using another. Sooner or later at least one of your operators would forget to switch to the new library, he抎 modify and place cells from the old library, and presto you抎 have a time consuming disaster to sort out.

Bad Solution #2

Another thing you might do, in theory anyway, would be to spend an afternoon bringing up each design file, one after the other and typing RC=newlib.cel for each one. That would (eventually) solve the problem, but would require $100 to $200 worth of labor and a considerable amount of patience.

The Modern Solution

Use Global File Changer for V8 to solve the whole problem in less than 5 minutes.

Just tell Global File Changer for V8 which design files you want to change (*.dgn) and which MicroStation command you want to execute on each one (RC=newlib.cel). Without further human intervention, all your design files will be changed just the way you want.

In practice, the changes you抣l make using Global File Changer for V8 will probably be much more complex than simply repeating a single command over a series of design files. Whole series of MicroStation commands, even user commands and MDL commands can quickly and easily be executed on design files all over your system.

Element selection feature puts the SelectBy command to shame

Global File Changer’s element selection feature lets you select elements to process based on element type, symbology, or any element property using a user-friendly dialog box.


One of the difficulties encountered when making changes to lots of design files at once is how to change just the elements you want and nothing else. Global File Changer’s element selection tools give you this ability. For example, you could select only red, unfilled shapes on levels 10-12, which were drawn with a custom line style, whose perimeter is less than 10 master units and which has an MSlink number somewhere between 8 and 14. Now that you have selected the elements you want, you can make any change you want to just those elements.

As another example, you could change all selected elements to a different custom line style, color or level, or you could change all three at once. In addition, you can set up multiple selection sets and save them by themselves or as a group. Use these sets to make any change you want to all the design files in a project or your whole system.

Global File Changer’s element selection feature picks up where 揝electBy?leaves off, giving you far more control than ever before possible.

Dozens of powerful built-in commands give you even more control over your design files

In addition to executing MicroStation key-in commands, Global File Changer for V8 has dozens of its own built-in commands. These commands let you easily make the following changes to any number of design files with a single command:

Scale cells.
Replace cells.
Scale text.
Standardize text height and width.
Set text slant.
Change fonts.
Change text justification.
Adjust underline position.
Adjust textnode line length.
Replace text substrings.
Dozens of other important design file modifications.
Every Global File Changer for V8 command can be executed on dozens of design files at the touch of a button. Global File Changer for V8 lets you make changes to any group of design files as though it were one big design file!

Unless your site has only one design file, Global File Changer for V8 will probably pay for itself the first week you own it.

Examples of how Global File Changer for V8 gives you control over design files all over your system...

Global File Changer for V8 can be used to make thousands of different types of changes. Any command you can type at the MicroStation command prompt can be repeated on any number of design files. Any non-interactive user command can be repeated on any set of design files. The ways Global File Changer for V8 can help you are limited only by your imagination.

The important thing to remember about Global File Changer for V8 is that it will do almost anything you want it to, not just the things it comes preprogrammed to do.

That said, here are some examples of what Global File Changer for V8 can do:

Replace a certain cell in hundreds of design files.
Scale a whole series of design files.
Copy level symbology settings from one design file to hundreds of design files.
Change the font of all blue text on level 33 to font 41.
Change the master units of a series of design files from feet to meters.
Change the global origin of a series of design files.
Replace the word 揜oad?with the word 揝treet?in a series of design files.
Attach a different cell library to a series of design files.
Lock all the elements in a set of design files so that they cannot be changed.
Attach a reference file to a whole series of design files.
Move all elements on level 2 to level 4 in a series of design files.
Turn on the display of line weights in a series of design files.
Turn on level symbology in a whole series of design files.
Make sure a whole series of design files have the exact same dimensioning parameters in effect.
Remember, the power of Global File Changer for V8 is limited only by your imagination and your ability to write simple (or not so simple) user commands and MicroStation commands to do the things you want done.

sun369

最初由 xmlinet 发布
[B]

可是我下载的文件是changer.exe，解压后没有v8目录，更没有Axiom目录。 [/B]

我也没有下到 V8  的,好像其服务器限制了部分下载内容

xmlinet

最初由 sun369 发布
[B]我的没有出现这种情况

键入:MDL LOAD C:\AXI-TEMP\USTN\V8\INSTALL [/B]

to sun369:你发的图片不就是v8的程序吗？不是你的界面啊？

saint12

我有V8的安装程序,但好像安装了之后也不能用阿.
请问如何用的,请SUN369兄指点指点一下小弟.
还有能否将你,汉化了的文件贡献出来阿.