Skip to main content
Question

Use Excel to make a list of key Layers and a count of said layers from a DWG file

F

Hi guys,

Pretty new to FME so any help would be greatly appreciated.

My client wants me to use FME to produce an Excel sheet that will show the ‘Expected layers’ and ‘Unexpected Layers’ in a given DWG file and a count of features per layer. I am able to use a Tester to filter for the ‘Expected layers’ and ‘Unexpected Layers’ but I am having trouble making an Excel document that will make each Expected layer the head of its own column. Right now all the Expected layers are coming in together in one column and without a count. I'm assuming I have to breakdown the 'autocad_layer' found in Format Attributes in the reader into new attributes based on the list of ‘Expected layers’ that I have? I have been playing around with Attribute Splitter, Attribute Manager and Attribute Exposer all to no avail.. Hopefully someone can point me in the right direction.

 

Thanks in advance,

 

Fred

3 replies

F
  • fredtaylor
  • Author
  • July 14, 2020

Essential_Layers.PNGI realized that all I need is the statistics calculator and click 'Total Count' to get what I am looking for. My next question is how do I get the counts to show up in my excel sheet? Currently all I am getting is a row for each Essential layer..

Any help would be great appreciated.

 

Fred

 

L
  • louisput
  • July 14, 2020
fredtaylor wrote:

Essential_Layers.PNGI realized that all I need is the statistics calculator and click 'Total Count' to get what I am looking for. My next question is how do I get the counts to show up in my excel sheet? Currently all I am getting is a row for each Essential layer..

Any help would be great appreciated.

 

Fred

 

Hi Fred, make sure to check the 'user attributes' in the writer, these records are the ones that will be written to your Excel. It's possible the definition is set to 'manual' so you will need to add the count manually or you can set the definition to 'Automatic' to write all attributes.

F
  • fredtaylor
  • Author
  • July 15, 2020

Thanks @louisput! That worked a treat. Much appreciated.

Reply


Helpful Members This Week

Community Stats

31,416
Posts
119,129
Replies
39,033
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.