• Home
  • Forums
  • FME Form
  • Data
  • Export xyz ascii tab delimited.txt from DGN v8 levels into level corresponding text files
Question

Export xyz ascii tab delimited.txt from DGN v8 levels into level corresponding text files

  • 19 December 2019
  • 2 replies
  • 5 views
M

I have a v8 DGN with say 25 different levels - I need to generate xyz coordinates of these specific levels into a tab-delimited asii text file (id y x z level#).txt So i.e dgn level "post level in the dgn" will output to post.txt

 

I need to extract the coordinates of the point features:

igds_xhigh 2014161.7674759198

igds_yhigh 13799548.426837647

igds_zhigh 73.6230882525444

 

the first number from which the data came from

igds_level_name 77 Insulator Attachment at Structure

 

and YXZ of nodes from the shapes also: as seen here

 

i tired this so far:

 

output file is blank

any help is welcome - thank you

2 replies

erik_jan
Rank
Userlevel 2
Badge +16

For extracting the tab delimited coordinates, I would use the CoordinateConcatenator transformer.

Then adding the id attribute can be done with the AttributeCreator, AttributeManager or StringConcatenator transformers (any of these will be able to do so).

Writing the data to different files can be done using the Fanout option (see the Text writer in the Navigator window), choosing the igds_level_name attribute as the Fanout expression.

I attached a workspace example: dgnv82textline.fmw

Hope this helps

M

Thanks Erik - that worked great - just need some minor formatting tweaks

  • change the coordinate delimiter | to an enter "next line" so that the next consequent coordinate is assigned its own number ID (this applies only to polygons/shapes)
  • drop it to 3 decimals?

thanks

right now it looks like this: (2 coordinates for this line)

403657 2014027.2555011988,13798531.990937235,25.03747374534607 |2014001.3199832845,13798529.703414556,26.174532392024993 95 Driveway Edge

final to look like this :

1 13798484.859 2014508.926 24.610 2

I was able to add @Value(igds_level_name) which added the 2 (+text) at the end

 

can the | be changed to new line/ID

and the , to TAB i did not see the option in the menus for these

 

I am going to start studying up on FME more - this is awesome

thanks again for your help

 

Reply


Community Stats

28,683
Posts
109,411
Replies
36,542
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.