Question

Is there a way to copy to excel user attributes table of any writer?

  • 17 May 2023
  • 6 replies
  • 0 views

Is there a way to copy to excel user attributes table?

 

I need to reproduce the table of writer attribute names, data type, width, value, precision. Figured there must be a way to extract those fast?

 

Capture


6 replies

Badge +20

I recommend saving the writer in an empty workspace and using the FME Workspace Reader on it.

You will find the the parameters you need under FeatureTypeUserAttributes. Just process the strings to get the needed values.

Excel FMW ReaderThis is what I get for the setting on the right.

I recommend saving the writer in an empty workspace and using the FME Workspace Reader on it.

You will find the the parameters you need under FeatureTypeUserAttributes. Just process the strings to get the needed values.

Excel FMW ReaderThis is what I get for the setting on the right.

Can I just copy and paste this? I need to extract all data type and lengths.

 

When I try to do so, I end just pasting that one value

Badge +20

Can I just copy and paste this? I need to extract all data type and lengths.

 

When I try to do so, I end just pasting that one value

Sorry, no copy/pasting. Some transformers have an import function but I haven't seen an export one.

Badge +10

Can I just copy and paste this? I need to extract all data type and lengths.

 

When I try to do so, I end just pasting that one value

You can copy and paste the results from the FeatureTypeUserAttributes

Process user_attribute_type to get type and width separate, keep the attributes you want

imageThen select all by clicking top left in the inspector, and right click to copy with headers and then you can paste where you need it

image

Can I just copy and paste this? I need to extract all data type and lengths.

 

When I try to do so, I end just pasting that one value

Would you be able to share the steps?

 

Thanks!

Hi,

I have the same issue. I want to get the user attributes in an Excel table, but I just can't figure out how. Did you finaly got it ?

 

Thanks

 

Frédérique P.

Reply