Transformers

I have a Workspace containing an Excel Reader. The Reader parameters specify two of the columns as x_coordinate and y_coordinate. After updating the Reader to point at a new version of the XLSX with 2 additional columns (after the x_coordinate and y_coordinate ones), the geometry is not created. If I inspect the output from the Reader, it says there's no geometry. The x_coordinate and y_coordinate columns have the same names, so why is the geometry not getting created? Also, if I wildcard the file name in the Reader e.g. "data*.xslx", the geometry does not get created from the Reader, even though x_coordinate and y_coordinate are specified. I want to be able to wildcard the file name in the Reader for regular updates e.g. "data*.xslx" so I don't have to update the Workspace for "data Feb 2019.xlsx", "data Mar 2019.xlsx", etc. Is this just the Reader, or do I need to do it with a VertexCreator rather than in the Reader for this scenario?

Hello, I'm new to FME and I'm looking to get a JSON file formatted like this : { "depart": { "INCENDIE" : 533, "AUTRES" : 30, "RISQUES TECHNOLOGIQUES" : 71, "OPERATIONS DIVERSES" : 320, "ACCIDENT" : 411, "SECOURS A PERSONNE" : 3813 }} The data comes from the following treatment : And the inspector give me that informations : I've try to use the following treatment : With that configuration : But I can not get the desired result as above. If anyone could help me ...? Best regards.

@DaveAtSafe hello, Dave, we are using the fuzzyStringcompare software in order to compare Arabic strings from 2 different data set, but it's not giving the expected result even when the ration is high, Since you have been involved in this costom transformer any idea on how we could fix this Thanks

Hello, Because of the python 2 deprecation, I'm updating existing workbench to python 3 and I'm having an issue with the transformer GeographicBufferer This is the error message that I'm getting after pressing ok. What should I do? Thanks?

I would like to identify 360 degree loops formed from a polyline and its attributes. ID's are the same but should only occur on 3 or less edges and not 4, forming the "loop". Below image gives a clearer overview. How will I go about identifying these issues? Thanks

Hi, I have to remove segments of roads, which are closer than 37,5 meters from each other. How can I do it? I mean roads' segments like this:

I have some different 3D-models in different formats. I want to batch create a 2D image without opening them with FME Data Inspector or another tool - take a screenshot and save as image. Are there any way to do this? Ie - do you know of any open source or other tools that can take as an input an inputfile (vector / 3D) - a viewpoint and write that as a raster?

This is my first real experience with rasterdata so my knowledge quite basic. What I want to do is to convert rasters to vectors using Potrace and the PotraceCaller. The rasters are 8 bit PNG's, see attachments. In the PotraceCaller, the raster is being written to BMP. The BMP is commandline converted to DXF by Potrace. The DXF is being read, world file applied. This works great, but not for all rasters. When running the workspace the following warnings show up: 2019-02-06 12:11:52| 0.5| 0.0|WARN |BMP writer: Unsupported palette value interpretation 'RGBA32'. Converting to interpretation 'RGB24'. If this conversion is undesired, consider changing the interpretation explicitly2019-02-06 12:11:52| 0.5| 0.0|WARN |@ReinterpretRaster: Converting some band/palette interpretations from 'RGBA32' to 'RGB24' might result in a loss of data I think to understand that a palette is an overview of all variations being used in the raster. The raster which is successfully converted has the following pa

Hi, I need to update a database model which has a lot of fme jobs associated with it. So I would like to extract all connections made by all our workspaces and make a little data model of all fme jobs and associated connections. I get some info out of the fmw reader but there are connections made by sql statements (and pl/sql) as well which as I see it now would need sql parsing. Is there any alternative for going down the python route? Cause I would to need learn something I hardly use and thus forget. Administering fme jobs this way would make it possible to gather more quickly where to update the fme jobs after a data model change. Any alternative transformer to the python caller? Any alternatives to the fmw reader? Any workflows you guys use to organize that forest of jobs? All the best, Robbert

I'm having a problem using WFS XML filter. I'm trying to read only 6 features from entire dataset and I get the following error: I wrote query in SQL and need to convert it to XML: "SAV_ID" IN (21,23,25,55,56,88) Interestingly when I'm quering only 2 of thoses features, I get no errors. XML filter (working one) for 2 features is: <ogc:Filter> <ogc:Or> <ogc:PropertyIsEqualTo> <ogc:PropertyName>SAV_ID</ogc:PropertyName> <ogc:Literal>21</ogc:Literal> </ogc:PropertyIsEqualTo> <ogc:PropertyIsEqualTo> <ogc:PropertyName>SAV_ID</ogc:PropertyName> <ogc:Literal>23</ogc:Literal> </ogc:PropertyIsEqualTo> </ogc:Or></ogc:Filter> I tried the following variants (for more than 2 features): (1) (gives error) <ogc:Filter> <ogc:Or> <ogc:PropertyIsEqualTo> <ogc:PropertyName>SAV_ID</ogc:PropertyName> <ogc:Literal>21</ogc:Literal> </ogc:PropertyIsEqualTo> <ogc:PropertyIsEqualTo> <ogc:PropertyName>SAV_ID</ogc:PropertyName> <ogc:Literal>23</ogc:Literal> </ogc:PropertyIsEqualTo> <ogc:PropertyIsEqualTo> <ogc:Pro

Hello, I'm using FM0 writer on FME desktop and everything works fine. When I try to run the same workspace on FME Server I get exception: Caught a COM Exception in FM0Writer::open() Im writing file to nas share. \\\\naslocation\\test.fm0 but when I would write it to zipped location: \\\\naslocation\\test.zip\\test.fm0 then it works fine. What can be the reason for that?

String text = "John.Davidson/05051988/Belgrade Michael.Barton/01011968/Krakov Ivan.Perkinson/23051986/Moscow";

I want to filter from a dataset the polygons that contain no further polygons. I have tried the Transformer AreaOnAreaOverlayer and SpatialRelator (Attributes (s) that Must Differ = element_id) so far.

Hi, I want to read a dwg file, transform the coordinate system and write it back in to a dwg file again. Therefore I use the CsmapReprojector. The transformation works fine, but I have the problem that all hatchings/solids of the dwg file are lost after the transformation.How can I solve this problem?Thanks and best regards!

Hi, New user here, I try to make an atlas in a geospatial pdf. I have multiple vector map with a main shapefile with multiple polygone (it's the foundation of my atlas) But I want to chose between 2 raster image (ecw) as base layer for each map, I want to chose the good raster based on the size of the main feature of my atlas. I created a BoundingBoxAccumulator where I can have the area of the futur map to display. How can I switch between the two raster based on the value of the area ? if area >XXXX then put raster 1 as base layer else put raster two as base layer. Thanks in adavnce for your help.

Is there a good way to calculate the age of this tree with FME? https://twitter.com/reisir/status/1091726774919196673?s=19

Hi, I have two shape files, one is polygon and second one is point. I need to reposition point shape that are outside of polygon so every point is inside of polygon with same id. Input: Output: Thank you.

Hi, so I have an update SQL query that the sql executor transformer executes. It looks like UPDATE *TABLE_NAME* SET COLUMN_NAME = @VALUE(ATTRIBUTE_1) WHERE OTHER_COLUMN_NAME = '@VALUE(ATTRIBUTE_2)' The first attribute is always a number, but the second one is a string so I have to put quotes in. But, the string can contain quotes itself, which causes the query to fail for those cases. If I put double quotes around it I get a SQL error: it thinks I'm setting it equal to the value of another column in my database table instead of a FME attribute. How do I put the whole string value of attribute 2 in my where clause, quotes and all? Thanks!

I need to check a long list of keyword (excel1) if they are available in an even bigger list(excel2) of phrase the end result will be keyword 1 : phrase 228 keyword 2: phrase 228 keyword 3: phrase 230 .....etc this case is used to much land use with standard naming Any idea

I'm trying to migrate from dwf's to GIS. When I inspect the dwf in inspector, none of the attributes that I really need and can see in Autodesks design review are even listed in the available columns under table view schema. Is this a known issue or is this due to my limited experience with FME?

Can somebody explain met the different encoding options for JPEG2000? Normally we convert our TIFFS to ECW with a nice result and the converting is very fast. Arcmap server needs an additional license to use ECW's, so I was thinking to use JPEG2000 instead. The image quality is a tiny bit better and the file size is smaller, but the convertion took so long... I used the standard FME writer options. Encoding profile 1 that is. What is the difference between all those profiles? There is very little documentation about it or I cant find any. Thx Koen

Hi I'm wanting to use window functions in the Inline querier. For example, ROW_NUMBER() OVER (PARTITION BY .. ORDER BY). I see that SQLite version 3.25 onwards supports window functions. However, when I tried to write a query in the inline querier it was unable to execute the query. I'm using FME 2018.1.1.2. Does anyone know what version of SQLite the inline querier uses for FME 2018.1.1.2?

With the attached Workspace I am trying to match up to adjacent boxes that slightly overlap. I was hoping MRF2DCleaner would do this and remove the overlap. However, it doesn't seem to read areas at all.Problem.png shows the overlap. ExpectedResult.png shows what I want to achieve. Any ideas?

I'm creating an attribute for storing start date/time of processing with AttributeCreator and I'm having a hard time removing the decimal of a second. @DateTimeFormat(@DateTimeNow(local),%a %b %d %H:%M:%S PST %Y) Output Thu Jan 31 11:16:20.9415159 PST 2019 Want Thu Jan 31 11:16:20 PST 2019

Hi,I need to reproject data using FME and am wondering if FME's NAD27_to_NAD83_Canada_FME (Reversed) is the same as NAD_1927_To_NAD_1983_NTv2_Canada?