Skip to main content
Question

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.

  • November 30, 2023
  • 6 replies
  • 22 views

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

6 replies

dustin
Influencer
Forum|alt.badge.img+31
  • Influencer
  • November 30, 2023

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.


esalmagul
  • Author
  • November 30, 2023

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.


dustin
Influencer
Forum|alt.badge.img+31
  • Influencer
  • November 30, 2023

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


redgeographics
Celebrity
Forum|alt.badge.img+62

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


dustin
Influencer
Forum|alt.badge.img+31
  • Influencer
  • November 30, 2023

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.


takashi
Celebrity
  • December 1, 2023

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.