Question

Read from dwg into excel sheet

  • 9 March 2020
  • 2 replies
  • 15 views

Hi! i have to read dwg plans and export information from the title block to excel. Just few values are interesting to me. I have an excel sheet with possible attribute values so only values which are both in the Autocad and in the "reference excel sheet" go to the final writer in excel format.

for example:

Cad provides the attribute autocad_text_string

autocad_text_string

green

Thursday

white

3800

12/01/2019

February

NAME

Peter

Excel reference sheet

Colours

Days of the week

Months

Names

blue

Monday

January

Laura

yellow

Tuesday

February

Mary

red

Wednesday

March

Anne

green

Thursday

April

Julia

orange

Friday

May

Charles

black

Saturday

June

Peter

 

Sunday

July

Anthony

 

 

August

Bob

 

 

September

 

 

 

October

 

 

 

November

 

 

 

December

 

 

The writer should look like this:

Colours

Days of the week

Months

Names

Green

Thursday

February

Peter

So the final table contains values that were in both places. The rest are not relevant. Does this make any sense? Hope to get help because I don´t know how to make the connection between my 2 readers in an effective way.

 

Thanks a lot!

 

 


2 replies

Userlevel 4
Badge +30

Hi @ninani

I sugest you the transformer FeatureMerger to join both readers.

After you could use the transformer AttributeManager to edit the attributes that you need.

 

Thanks,

Danilo

Hi @danilo_fme

I have tried with FeatureMerger but still does not merge my attributes. Feature Joiner works using few of those so not very elegant solution..Hope to still improve it some how.

 

Thanks a lot for your answer!

Reply