Skip to main content
  • EN

Hi,

I’m trying to apply a schema from excel to 2D utility lines so that it applies the schema to the lines and creates 3D pipes of the same size, also adding the metadata.

I have an idea of how to put this together, however am struggling to select the right information from the excel and make it dynamic.

Example: If find ‘water’ in dwg, then apply a 200mm pipe to the center and add ‘water’, metadata1, metadata2 as attributes to the line.

 

Thanks in advance!

This would be a lot easier if you could 'flip’ your Excel. Is that an option?

  type size info1 info2
asset1 Gas 60 metatata1 metadata2
asset2 Water 200 metadata1 metadata2
asset3 Electrical 50 metadata1 metadata2

 

I think @geomancer is right, transposing the table would make this a lot easier. You would have one feature for each asset type, containing all the information needed. 

It is possible to transpose tables using FME, see this article: https://support.safe.com/s/article/transpose-a-table-using-fme

Also, this is something that has been asked frequently on the forum, here's one example of a solved thread:

 

 

Reply


Community Stats

30,108
Posts
114,295
Replies
37,743
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.