Legacy Ideas are now read-only and have been migrated to our new platform: Aha! Click Here

Under Review

over 4 years ago

MicroStation Reports: Improved Key-In Commands

MicroStation CONNECT Reports let you export DGN data to an external file. You can choose various file formats, including Excel.

There is an apparently-related key-in command REPORTS EXPORT. However, that command is not documented and appears to do nothing.

This Idea is for an expanded set of export command key-ins. A comprehensive set of REPORTS EXPORT key-ins would facilitate automation and batch-processing of Reports.

It would be useful to have various set commands. For example...

REPORTS EXPORT SET FORMAT csv | xml | html | Excel
REPORTS EXPORT SET FILENAME fileName
REPORTS EXPORT SET OUTPUT folder

If the key-in is entered without a value, it should echo the current state of that value.

Here's a set of report export commands...

REPORTS EXPORT reportName
REPORTS EXPORT reportName, fileName

Jon Summers

Top Comments

Offline Jon Summers over 4 years ago in reply to Lorys

Lorys wrote: IMPORT report to UPDATE ITEMS from external file Report

This Idea is about Reporting, not Importing. There's already a way to import data from Excel to Item Types.
- Cancel
- Vote Up 0 Vote Down
- More
- Cancel
Offline Lorys over 4 years ago in reply to Lorys

while were adding to wish list, how about a GUI to all this and no need to use the batch processor make it a one stop shop, create reports or report and select all the dgns to use..
- Cancel
- Vote Up 0 Vote Down
- More
- Cancel
Offline Lorys over 4 years ago

Exapanding on Jon's suggestion it would be great if you could have 2 extra function keyins

1. APPEND report, allowing you to via the batch processor to use the report function over several drawings and keep adding to the same report to cover several drawings in a single report.

2. IMPORT report to UPDATE ITEMS from external file Report (or tags converted to items) from a modified report to update ITEMS via batch processor
- Cancel
- Vote Up +1 Vote Down
- More
- Cancel
Offline Huan Ting Chen over 4 years ago

Any update for this?
- Cancel
- Vote Up 0 Vote Down
- More
- Cancel
Offline Colin Wang over 5 years ago

Hi Jon, thank you very for your suggestions.

I've filed 2 work items for this issue:

Defect 943886:There isn't a help document for keyin "Reports export"
Enhancement 943890:MicroStation Reports: Improved Key-In Commands

By the way, "REPORTS EXPORT" now needs a path parameter like “CategoryName\DefinitionName” to do work. For example "REPORTS EXPORT CategoryName\DefinitionName", it pops up the dialog for where to save the reports, selecting the file type and giving the file name. It is same with the command icon "Export Results" which is on the Reports dialog.
- Cancel
- Vote Up +1 Vote Down
- More
- Cancel