Skip to main content
Question

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


esalmagul

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

caracadrian
Contributor
Forum|alt.badge.img+23
  • Contributor
  • May 17, 2023

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.


esalmagul
  • Author
  • May 17, 2023
caracadrian wrote:

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


caracadrian
Contributor
Forum|alt.badge.img+23
  • Contributor
  • May 18, 2023
esalmagul wrote:

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.


ebygomm
Influencer
Forum|alt.badge.img+39
  • Influencer
  • May 18, 2023
esalmagul wrote:

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


esalmagul
  • Author
  • May 18, 2023
esalmagul wrote:

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!


fpaquet
Participant
Forum|alt.badge.img
  • Participant
  • May 30, 2023

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.


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