2604.Import Points.zip ◄ Download
Import Points CE 2.0 is an open source mVBA applet which runs in MicroStation CONNECT Edition. The applet enables users to import location data from text files of various formats. Imported points and accompanying fields are transferred to the dgn file with user-specified data mappings and graphics. See documentation for installation and operation details.
New in 2.0
1) Support for Shared Cells
( It just needed to happen )
2) Cell Specification Rules
Specific cells may be placed based on field values that are evaluated against user-defined rules. The general syntax is as follows:
If the expression is True, then use CELL NAME
Where the expression consists of:
A field value (string), operator and comparator (string) that evaluates to either True or False.
supported operators:
Points of Interest For New and Experienced MicroStation VBA Programmers...
Some notices:
Hi Dave
Thank you for the answer.
We are using MicroStation CONNECT Edition Update 15 (Version:10.15.02.11) with MicroStation CONNECT Edition x64 Language Pack Update 15 (German) and MicroStation CONNECT Edition Update 14 (Version:10.14.2.1) (German).
The OS i'm using is Windows 10 Pro (Version: 1909).
Regards Simon
Invalid use of Null (Error 94)
Hello Simon,
FrmImportPoints.Show is executed almost immediately after the program is loaded. The form upon being initialized, kicks off a number of procedures. While there are several places where the Invalid use of Null error might be encountered, the applet has code that will detect and gracefully recover from this error. That being said, your environment or the data you are processing seems to have revealed something we missed. But before we get too involved with that, can you let me know OS you are using and under what version of MicroStation the applet is running? Also, please check the settings in the VBA Editor (Microsoft for Visual Basic Applications): Tools>Options>General>Error Trapping to make sure "Break on Unhandled Errors" is selected.
Thank you for alerting us to this issue!
Regards,
Dave
Thank you for the import Tool.
If i want to run it, i get the runtime error 94 illegal use of zero.
The Debuggingtool shows me, that there is a error at "FrmImportPoints.Show".
Do I still have to make certain settings or how can this error be circumvented?
Thanks for the clarifications Dave,
I look forward to the updates. One of our possible uses would also include many more than 16 fields, possibly up to double that, and would require an Itemtype Definition for each if that is at all possible.
Thanks again for your efforts providing this application.
John.
Hi John,
Thank you for the feed back.
Regarding the issues you encountered:
1) You are correct, the Select Item dialog currently does not display items attached from dgn libraries. I'll look into this for the the next release. In the meantime the the work around is to localize the library by following these steps:
Or you can use Libraries>Import function from the Item Types dialog.
2) The error in the screenshot may be avoided by using an item type with fewer properties (13 total). This should be addressed in the next release.
3) There is no requirement fields from the CSV have a corresponding item.
4) There are no other specific settings.
Hope this helps!
Thanks Again,
Hi Dave,
This looks like a great tool, but I am having difficulties to get it to work. I have a csv file with 16 fields (it had more but I deleted the rest) and I am seeing two problems, the first is it does not recognize Items in a dgnlib, they have to be imported first, the second is, it is throwing the error "Fatal Error in RestorePreviousMapping Could not find the specified object." as in the attached image. I am guessing I have something missing or not set correctly but I can't seem to get around it.
Is there specific requirements in the item to match all the fields in the csv file?
Is there any other specific settings required?
John Davidson
The MVBA file has been added to the zip. -Thanks!
This zip file only contains the Import Points CE 2.pdf and the Points Templates.dgnlib.
There is no updated mvba file
Greetings All,
Thank you for your feedback on the initial release of Import Points CE. As you know software is never done, it's just revised and revised again. Hopefully IPCE 2.0 address the shortcomings brought to our attention with the first go-around. It's your comments and experiences that drove the improvements. Again thank you, and keep the comments coming!
If you haven't already made the connection, this tool works very well in combination with display rules and items. I've seen impressive "heat map" and "sounding chart" output generated using Import points, items and display rules. With that in mind if you find this tool useful and would like to share a bit about your success, feel free to post a snapshot and description of the problems you addressed using the aforementioned MicroStation functionality and Import Points CE.