Ph 1300 762 614
ECS XYZ Data Import Tool
The Data Import tool will provide users of Bentley MicroStation (and Bentley PowerDraft) with enhanced ability to import xyz coordinate data from either a comma delimited file or a Microsoft Excel spreadsheet.

Vanilla MicroStation has the Import Coordinates tool that will allow you to place an active point, the same text or the same cell at a coordinate location read from a comma delimited text file. It does not have the ability to read a spreadsheet, draw lines between the coordinates, or allow you to place numbered identifiers or specific cells at each location.

The Data Import tool from ECS has a wizard style dialog that allows you to do any of the following actions with the coordinate data being read:
  • Read a Microsoft Excel spreadsheet directly
  • Ability to choose which worksheet in an XLS file to read from
  • Read a csv file directly
  • Read a formatted text file (delimiters by either , ; | tab space)

  • Allow you to choose which row to start processing from (allows you to skip the column titles if you have them)
  • Allow you to select which column in the input file is which value (x, y, z, text string, cellname)
  • Place active points at each coordinate
  • Join each of the coordinates with a line
  • Place the same text or text read from a column in the input file
  • Append a unique identifier to the text string (or just place a sequential identifier)
  • Place the same cell or a cell read from a column in the input file
  • Define a fixed cell size or a random size between a lower and upper limit (great for placing random sized trees)
  • Define basic symbology for the imported data

  • Displays a preview of how it will interpret the input file prior to processing
  • Displays a percentage bar showing processing progress
  • Displays a summary including statistics and errors encountered

step1of3     step3of3
The pre-requisites for the Data Import tool are below.
  • Operating System - Windows XP, Windows 7, Windows 8.1
  • CAD Software - MicroStation or PowerDraft v8 2004, V8 XM, V8i
  • Other Software - Microsoft Excel 2003 or later (for importing from XLS files)

Free 7 day Evaluation of the Data Import Tool
To obtain a free 7 day evaluation of this software, enter your details on our Registration Page.

What users are saying
The Data import Tool created by Engineering CAD Solutions is simple to use and well thought out. The instructions provided are detailed and easy to follow. There is excellent adaptability when using spread sheets which allows you to access only the information required. With previous programs I have had to edit the spread sheets, so that only the information required was present.

If you have a need to create drawing details using point data in Excel or Word format, I would highly recommend you take a serious look at this tool.
Michael Phillips, Drafting Coordinator / Senior Design Drafter (Primary Design), Consolidated Power Projects
Copyright © 1997-2017 Engineering CAD Solutions Pty Ltd. All rights reserved.