Hi,
I'm simply trying to write a summary list of the layers used in all dwgs in a folder to excel. The workbench will do this to inspector but not xls but I can't figure out what's going wrong, any hints?
Question
AutoCAD Layer to Excel
+3This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Hi @just_super, to clarify the situation, could you please post a few screenshots that illustrate the followings?
- How FME Data Inspector is displaying the summary list of the layers.
- How you have configured User Attributes in the Excel writer feature type.
+18- Supporter
You can try generating a workspace, this will automatically set all the attributes on the writer feature type.
After that you can remove any undesired output attributes.
To make sure a single feature per layer is written use a sampler transformer, set the group by to the layer and sampling on 1.
Hope this helps.
+12- Contributor
Hi,
Scenario 1:
If the excel file is not generated then probably either file is opened or rights problem or configuration error.
Scenario 2:
If the excel file is generated without the layer names in excel file then you should add the attribute header in user attributes in excel writer.
+3You can try generating a workspace, this will automatically set all the attributes on the writer feature type.
After that you can remove any undesired output attributes.
To make sure a single feature per layer is written use a sampler transformer, set the group by to the layer and sampling on 1.
Hope this helps.
+15- Contributor
layer names are in autocad_layer and in fme_feature_type.
If u add the dwg reader to the canvas, the fme_feature_type is automatically exposed. (autocad_layer needs manual exposing).
Use a sampler grouped by fme_feature_type sample rate = 1 and sampling type = first n features.
Add writer and add the attribute to the excel writer (or copy it from reader).
There should be no problem.
(it will not write to open excel of course, but I assume you know that)
+18- Supporter
Sound advice and kind of worked. The dwg is read and a xls written. However a sheet is being created for each feature type whereas I just wanted them listed. Just like in the log below!
+3layer names are in autocad_layer and in fme_feature_type.
If u add the dwg reader to the canvas, the fme_feature_type is automatically exposed. (autocad_layer needs manual exposing).
Use a sampler grouped by fme_feature_type sample rate = 1 and sampling type = first n features.
Add writer and add the attribute to the excel writer (or copy it from reader).
There should be no problem.
(it will not write to open excel of course, but I assume you know that)