Skip to main content
In the writers, under user attributes we can see the table with name, type, of data, width., etc. Is there a way to copy/pate or export this table in csv? I am tasked with data type for multiple outputs, and it would be great not to do so manually.

You can use the FMW Workspace Reader to read in all kinds of information about workspaces, and then write that out to CSV. Not sure if the specific info you need is available, but it probably is.


Tries that, and there is a lot of good stuff, but not exactly the table I need. Still don't see data type and character lengths for the writers.

I also looked into schema mapper and scanner., but that's not it.


Tries that, and there is a lot of good stuff, but not exactly the table I need. Still don't see data type and character lengths for the writers.

I also looked into schema mapper and scanner., but that's not it.

That is unfortunate, and actually hard to believe it's not available, but sure enough....I tested and couldn't find that info. The idea has been posted here if you would like to upvote: https://community.safe.com/s/bridea/a0rDm000002DIj2IAG/fmw-workspace-reader-extract-attributes-along-with-data-type-and-lengths

 

I know it's not the best solution, but in the meantime you might consider reading the .fmw file in using the Text File reader. Near the bottom, you should find the writer info you are looking for. The problem you will find is parsing that information into something usable. In the example below, I have an Excel reader with 3 attributes (Error, Error_count, and Severity). You can see the data type is available as well.image


Maybe the Schema reader, ListExploder and then write it out to CSV


Maybe the Schema reader, ListExploder and then write it out to CSV

I figured that might work, except there may additional attributes in the flow that are not being written in the writer.


Hi @esalmagul​ ,

Right Click on the writer feature type > Copy, paste it onto a Text Editor, then edit the text manually:

- remove unnecessary lines,

- replace one or more consecutive white spaces with a single comma.

It's a bit primitive but effective, I think.


Reply