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.
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.