Question

Oracle Non Spatial Reader to CSV Writer

E
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!

3 replies

fmelizard
Rank
Userlevel 4
Badge +13
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)
fmelizard
Rank
Userlevel 4
Badge +13
Optionally you can set the translation to dynamic and not worry about attributes any more....
E
Ah, brilliant! That was the piece I've been missing. Thanks so much!

Reply


Community Stats

28,669
Posts
109,357
Replies
36,531
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.