I am creating SHAPE or MITAB file from ORACLE Spatial table. I am able to create MITAB or SHPAE from table. But I want to create empty file if there are no records in table.
How can I do this?
Hi,
It's not really possible (or quite quite complicated): FME is feature based, so when there are no features, nothing happens and nothing gets triggered.
There is a trick for Shape-files (http://fmepedia.safe.com/articles/How_To/Create-an-empty-Shape-file), but I can't see how you'd do it with Mapinfo-files, since they can contain any geometry.
The easiest solution might be to write a shutdown script that checks for the number of features written. If there were not features written, you could copy a pre-made, empty Mapinfo-file into the results folder.
David
I am thinking, as table is created by other application, if there are no rows to put in table insert a single row with null geometry value. I think that should create a empty file.
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.