At the moment it is not possible to use special characters, such as '(' and ')' in feature type names in Writers. Many formats do support these characters, but it is not possible to use these in FME, since they are being replaced with an underscore.
Please implement this.
Note: It is also not possible to create an attribute containing the feature type name and use this as the feature type, it still gives an error since FME replaces these characters with an underscore.
If you could let us know which writer in particular, we can start there. Aside: these substitutions are governed by entires in the 'metafile' for a format, which we set eons ago. Since then perhaps the world changed and we are being too harsh. Would love to get an example format and work out from there. Could be a very simple quick fix.
Dale here is an example:
AT_T is the output of a filename when I was wanting AT&T
What writer were you targeting? And what operating system are you on?
Hi @daleatsafe,
In most cases the filename isn't the issue, but the name of the feature type is. Up to my knowledge it counts for most writers, at least the Esri writers, but I have seen it for other writers as well.
In particular the issue arose with feature services in ArcGIS Online, where I have feature types with spaces and the () mentioned above.
Sorry I missed your comment from last year, otherwise I would have responded earlier.
Hello @daleatsafe.
I'm having the same problem in ACAD Writer / FeatureWriter Transformer (ACAD). My original input file contains a "." in attribute name, but in the writer the attribute the "." is replaced by an underscore.
It would be very helpful keep some special characters. Is it possible?
Thank You very much.
I have problems with special charachter in reading oracle layer with where condition. It doesnt recocnize Ë or Ç so i get the error
ORACLE Reader: Unable to execute SQL statement `SELECT "IPRO2013"."PARCELE_TSUR"."FID", "IPRO2013"."PARCELE_TSUR"."AREA", "IPRO2013"."PARCELE_TSUR"."AREA_NOMINAL", "IPRO2013"."PARCELE_TSUR"."EXACT_AREA", "IPRO2013"."PARCELE_TSUR"."STATE", "IPRO2013"."PARCELE_TSUR"."KONTROLLUAR", "IPRO2013"."PARCELE_TSUR"."LEVIZJE_TOTALE", "IPRO2013"."PARCELE_TSUR"."LIDHUR", "IPRO2013"."PARCELE_TSUR"."ZK", "IPRO2013"."PARCELE_TSUR"."NR_PAS", "IPRO2013"."PARCELE_TSUR"."PROBLEM", "IPRO2013"."PARCELE_TSUR"."LLONI_PAS", "IPRO2013"."PARCELE_TSUR"."PRONARI", "IPRO2013"."PARCELE_TSUR"."KONFIRMIM", "IPRO2013"."PARCELE_TSUR"."MARKIM", "IPRO2013"."PARCELE_TSUR"."KONFIRMIM_OLD", "IPRO2013"."PARCELE_TSUR"."GEOM" FROM "IPRO2013"."PARCELE_TSUR" WHERE fid in (select fid_tsur from parcele_tcen where fid_centroid in
(select fid from parcele where k_perfundimtar=1 AND zk!=1 and shtet = 0 and bashkia_G = (
'K?LCYR?')))' for table `IPRO2013.PARCELE_TSUR'
...............................................
`ORA-01756: quoted string not properly terminated'.
Any update or workaround for this? I'm having this issue with FME 2022.
For me it works if I create the writer and then replace the Layer Name with the ID of the layer