Skip to main content
Question

Non-Spatial data to CSV

  • June 24, 2014
  • 2 replies
  • 43 views
J
Hello,

 

 

I am trying to transform any non-spatial data to CSV.

 

I have

 

1. Added Generic Reader with workflow Option "Individual Feature Type" as I have may get CAT,txt,xls etc

 

2. added CSV Writer with dynamic properties

 

 

Whnd I try to run this simple workflow I am getting bank lines in csv i.e. if there are 5 lines in txt file I get 5 blank lines in CSV.

 

 

One of the Input Text file contains sometnig like this

 

 

ID,Name,Type

 

1,ABC,Land

 

2,XYZ,Water

 

3,AAA,Airport

 

4,BBB,Field

 

 

Could you please let me where I am going wrong?

 

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

gio
Contributor
Forum|alt.badge.img+15
  • gioContributor
  • Contributor
  • June 24, 2014
Hi,

 

 

Are u trying to write them all to 1 csv writer?

 

If so then sources with different schema's result in what u see, i think. ( 1 schema might have a

 

If you use dynamic properties, it will try to use only 1 schema to map your csv.

 

 

If u do want to read all different schema objects and output to a single csv, you could concatenate all fields in each input to a single string with comma as delimiter. To for instance "textstring" and write the text string to the csv.

 

 

 

 

mark
Contributor
Forum|alt.badge.img+1
  • markContributor
  • Contributor
  • June 24, 2014
Hi,

 

I think this might be a problem in FME, or at least a 'feature' in how a CSV/Excel schema is read by a Reader and by a dynamic Writer.

 

 

I suggest you file this one with our support team (safe.com/support). Let them know it probably relates to PRs: 51578, 52658, 52941, and/or 53066. There are a lot of similar issues, but if you include your workspace and data then someone in support will be able to figure out exactly what issue is affecting you and hopefully come up with a workaround

 

 

Apologies for any inconvenience this is causing,

 

 

Regards

 

 

Mark

 

 

Mark Ireland

 

Product Evangelist

 

Safe Software Inc

 

Community Stats

32,670
Posts
123,975
Replies
41,103
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.