How to import CSV coordinates with additional text into Microstation V8 2004?

Hi,

i'm trying to find a way to import a simple CSV file with "Point nr,code,X,Y,Z" so that i can get points to the specified coordinates and text attached to these coordinates.

 

For example: 1,601,5000000.00,400000.00,10.00

 

Any ideas?

Parents
  • I can offer a inelegant but effective solution. Use the Import Coordinates tool. However, you have to use it multiple times and manipulate your .csv file each time.

    Open the .csv file in Excel, and select the first 2 columns (point no. and code) and paste them into columns to the right of the coordinates. Delete the now empty first 2 columns and re-save the file. Use Import Coordinates in the Point Element import mode to place points at the active symbology. (You can place cells, but that takes additional work.)

    Now cut and paste the point numbers column back into the first column, and re-save the file. Now Import Coordinates in Text import mode and set Order to TXYZ. Set your active text justification (and other text parameters) before you import. The text will be placed at that justification. Now swap the Code and Point Number columns in the .csv file and re-save. Change the text justification, and import again. The codes won't be on top of the point numbers this way.

    It sounds messy but it doesn't take very long to import data this way.
  • Attached my version of PLTPNT. I have made some additions so that LIDAR .xyz files can be imported.PLTPNT.ZIP

  • Unknown said:

    Attached my version of PLTPNT. I have made some additions so that LIDAR .xyz files can be imported.(Please visit the site to view this file)

    if I run the bat  file does it make a  new  ma file  (ie recompiled)  version?

    Lorys

    Started msnt work 1990 - Retired  Nov 2022 ( oh boy am I old )

    But was long time user V8iss10 (8.11.09.919) dabbler CE  update 16 (10.16.00.80) 

    MicroStation user since 1990 Melbourne Australia.
    click link to PM me 

  • It will not compile as it is for Windows in german language and you need SDK and Visual Studio 2005.

    I tried to compile with the [censored] BMAKE but stuck on error - "Recursion on macro expansion has exceeded limit"

    Bentley Systems Make Utility. Version 08.11.09.02, Jan  5 2010
    Thu Feb 01 14:45:00 2018
    BMAKE: Recursion on macro expansion has exceeded limit - $(baseDir)\PLTPNT\
    BMAKE: call trace
        line:   43, \PLTPNT\PLTPNT.mke
    Thu Feb 01 14:45:00 2018, elapsed time: 0:00

Reply
  • It will not compile as it is for Windows in german language and you need SDK and Visual Studio 2005.

    I tried to compile with the [censored] BMAKE but stuck on error - "Recursion on macro expansion has exceeded limit"

    Bentley Systems Make Utility. Version 08.11.09.02, Jan  5 2010
    Thu Feb 01 14:45:00 2018
    BMAKE: Recursion on macro expansion has exceeded limit - $(baseDir)\PLTPNT\
    BMAKE: call trace
        line:   43, \PLTPNT\PLTPNT.mke
    Thu Feb 01 14:45:00 2018, elapsed time: 0:00

Children
  • BMAKE is evil of all evils. It seems to contain lot of hardcoded paths which differ from default installation path but at last was able to compile it for v8i.

    Had to comment out this section as not sure why it gives error. So cell placement doesn't work but all others are ok.

    MSWChar cell[18];    
     
        /* --- read cell for cell library --- */
        if (params.toggleMask & TOGGLEID_Cell)
            {
    //compile error!
    //        strcpy(cell, params.cellName);
    //        strupr(cell);

    PLTPNT-v1.02.zip

    Source:

    https://github.com/otofoto/PLTPNT-PLot-PoiNTs-

  • Any instructions on how to use this Otto,btw your link below says page not found

    github.com/.../quote]

    Lorys

    Started msnt work 1990 - Retired  Nov 2022 ( oh boy am I old )

    But was long time user V8iss10 (8.11.09.919) dabbler CE  update 16 (10.16.00.80) 

    MicroStation user since 1990 Melbourne Australia.
    click link to PM me 

  • Corrected the link:

    PLTPNT (originally by Bill Steinbock) is an Microstation v8 MDL application which plots points at the location specified in an ASCII file.

    PLTPNT is an MDL application which plots points at the location specified in an ASCII .txt or LIDAR .xyz file. Each point may have a cell, elevation, decriptor text, and a text label associated with it. The user activates the application by keying-in MDL L PLTPNT. A dialog box activates where all choices for placing point and associated text are selected. One recent addition is the settings for the number of decimal places for the elevation text.

    The users' data files must be formatted to comply with one of the space or comma delimited formats available. These formats are:

    D,X,Y,Z,L \ D = Point Descriptor text
    D,Y,X,Z,L \ X = X coordinate value (easting)
    X,Y,Z,D,L / Comma Y = Y coordinate value (northing)
    Y,X,Z,D,L / Z = Z coordinate value (elevation)
    D X Y Z L \ L = Point Label text
    D Y X Z L \
    X Y Z D L / Space
    Y X Z D L /


    Note that text strings (D or L) to the right of the X Y and Z data are not required to be defined,
    but any descriptor text designated as left of the actual coordinates must be defined.
    For example, if you select the format D,X,Y,Z,L, the point descriptor text is required
    but the label may be left blank. Similarly, if the format is set to X,Y,Z,D,L
    the only required data are the X,Y, and Z values. Sample design, cell library,
    and data files are include for software testing. The sample data files show the different input formats.

    File Input Format
    ------- ----------------------
    test_1c D,X,Y,Z,L or D,Y,X,Z,L
    test_2c D,X,Y,Z,L or D,Y,X,Z,L (L not used)
    test_3c X,Y,Z,D,L or Y,X,Z,D,L (L not used)
    test_4c X,Y,Z,D,L or Y,X,Z,D,L (D & L not used)
    test_1s D X Y Z L or D Y X Z L
    test_2s D X Y Z L or D Y X Z L (L not used)
    test_3s X Y Z D L or Y X Z D L (L not used)
    test_4s X Y Z D L or Y X Z D L (D & L not used)