Skip to main content
  • EN
I'm relatively new to FME, so any help here would be greatly appreciated.

 

I can link to a SQL server to pull specific information from a table. However, I don't have write-access to the server, so I want to save the results of my SQL query in a CSV file. I've tried just doing a Reader of Oracle Non Spatial to a Writer of CSV. It reads the data fine, but nothing actually gets copied into the CSV File; it is just an empty file.

 

I'm obviously missing something here. Can anyone help? Much obliged!
Hi,

 

 

Are the attributes of your reader schema present on the csv writer?

 

You can quickly copy the input attributes by right click on the writer> copy atribute from feature ....(select your input feature type)
Optionally you can set the translation to dynamic and not worry about attributes any more....
Ah, brilliant! That was the piece I've been missing. Thanks so much!

Reply


Community Stats

30,159
Posts
114,480
Replies
37,805
Members
Terms & ConditionsCookie settings
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.