Transformers

I am using the jsonfragmenter to expose the attributes "name", "street", "city", "zip" in the following json.I want to also expose the geographicpoint attribute and append the "latitude","longitude" as a field on the same level as the other attributes so that I can obtain the following data structure."name", "street", "city", "zip", "latitude", "Longitude" How can I delve into the "geographicalPoint" attribute and flatten ist further in my schema?  JSON{"name":"Medicus-Apotheke","street":"Walsroder Str. 8","city":"Soltau","zip":"29614","email":"medicusapotheke@googlemail.com","geographicalPoint":{"latitude":"52.9836451","longitude":"9.8358444"},"contactName":"   Andreas Hagedorn","services":[{"service_id":34,"service_name":"Krankenpflege","service_icon":"ico_krankenpflege.png","service_url":"","service_descript":"Krankenpflege","service_longdescript":"Krankenpflege","service_type":0},{"service_id":35,"service_name":"Verleih","service_icon":"ico_verleih.png","service_url":"","service_de

Hello, I have got 2 sets of Polygones. 1 consist of big areas (431) and the second one has the smaller Polygones. Theese smaller polygones includes infos/attributes which I need to write into that larger polygones. The problem is that I get from AOAL too much Polygones, but not this result what I want...I want to get the infos from (many) Polygones in the larger (less) Polygones. Maybe to use a different transformer?Any Idea?Thanks

I am trying figure out how to populate missing date records in a COVID database using the last known value.Here is an example of input data:CountryLast UpdateNumber of CasesMexico3/1/20205Mexico3/3/20205Mexico3/6/20206Mexico3/8/20207Mexico3/9/20207 I would like to generate a record for each day.  CountryLast UpdateNumber of CasesMexico3/1/20205Mexico3/2/20205Mexico3/3/20205Mexico3/4/20205Mexico3/5/20205Mexico3/6/20206Mexico3/7/20206Mexico3/8/20207Mexico3/9/20207 Any ideas on where I would start with this one?

There are some air-quality sensor in the area I work. These are connected with the LORA-network and The Things Network (TTN). Data can be accessed by the MQTT-protocol. However I have no experience with this. I found the MQTTReceiver (which uses an old Python version) and MQTTConnector. I tried both Transformers with the settings I received; like this:Unfortunately it is not working. The error I get  Anyone experience with this? Thanks!Stefan

As per the topic: Any difference in the values calculated by either Transformer when using @Evaluate in AttributeCreator vs ExpressionEvaluator?

Hi  New to FME so please be gentle...  I think the question lines out what i want to do but for clarity, I have several dxf files in a folder on my c-drive. These dxf files are a combination of point, lines and polygons with a known projection. I want to convert all these dxf files to an ESRI geodatabase (or separate shapefiles -whichever is easiest) with the name of the dxf file naming the "shapefile".Additional - if possible I would also like to reproject the shapefiles to another projection - but not that important now.  

I have a *.csv-file with values, I would like to put them in a Autocad block attributes:The issue is that the 'pino'-values which I filled in by hand will come over. The values from the csv won't (value from Sheet Name 2).I can't get it, who can help me please? :-) Thanks! acad_excel2acad_Safe.fmw0002_Sheet Name.csv

Hello, I am looking for the possibility to count all points (3D) within a 3D body/sphere. Using the 3D buffer (it was faster than HUB3DBuffer, but less accurate) I have generated a solid body and now I want to check how many 3D points are inside this body. With the Spatial Relator apparently only points in a 2D space are checked. Is there a transformer in FME that does this job? Thanks a lot.

Hi, I have used SchemaMapper to create two new attributes that have successfully mapped to my output shapefile. I can see them in the inspector in the Feature Information window. However, I want to map these values into my attribute table. When I try to expose these attributes using AttributeExposer they are not there. I have searched through many posts on these forums and can't seem to find an exact answer. Could someone help me with this?ThanksB

Hello everybody,I got one GeoTIFF image and I want to get N ( for example 3000 roofs ) smaller jpg images of point of interest in which every roof is one picture. I started making polygons in the place where are points of interest but I don't know how to "clip" it.

Hello! I would like to build lines between neighbour points. Unfortunatelly the points cannot be gouped by the neigborfinder, as sometimes an other point is closer. But the points are in numeric order as they have an ID. Can I do something with it?

I am interested in zoom meeting if that is possible

I have a "mapinfo" table that I'm trying to load into a oracle DB with SDO_Geometry. My license doesn't let me create a writer in FME as an Oracle Spatial table. So my workaround is to add the tables as "oracle non-spatial" tables. This works fine for address points but when I run the following SQL;This updates successfully. The issues is when I check in "Data Inspector" if its saved correctly (for this particular record which is a multipolygon). I get only one of the polygon objects returning;

Hi guys, I am trying to create " cross lines" between 2 points. I just got the lines in black that u can see in the capture. But I wan to get the red lines. Can u help out please? 

Hi,I have a block which contains (Autocad)attributes, in Autocad you can edit them by double clicking on it.I would like to insert this block in a dwg and fill in some values. When I put this block in a template and insert it with the dwgstyler than it becomes a default block, whithout the 'doubleclick' functionality.How can I insert a block with (Autocad)attributes and fill in the values? Thanks!

Hello everybody, I hope everybody is doing well! But for the question, I'm currently looking at creating 3d polylines from a rail. I have used the offsetcurvegenerator for getting an offset and then use the neigbourhoodfinder to rebuild my polyline. Now the problem is I need to get the the exact same vertices on the offset polyline as these from the original, as these are the points where the rail was measured. And I don't get this with the offsetcurvegenerator. I have seen the use of the buffer transformator but also this isn't giving me the correct results. Can somebody guide me into solving this problem. Many thanks and keep safe,Andreas

 I have a set of areas. And all neighbours should be connected with a line. If I have 10 areas they should be connected with 9 lines to connect them all. I have tried to explain in detail with the attached pdf and in annotations in my workspace. I have a solution but its not the best solution and could probably be edited to something better. For small amount of data it works. But for large its a heavy process.  The end result should look something like the images below Alla areas are connected    Alla areas are connected  And there are 1 less line then there is areas     

I have a dataset with 3D buildings like this:The dataset is a gdb-file (geode-multipatch) with aggregate geometries.I need to extract the roof height for each part of the building (meaning one building gets multiple height values for each part – e.g. the second building from left in the front row in the screenshot should have a different value for its tower). The height should then be a attribute for the below mentioned polygon.And I also need to extract the footprint as polygon shape for these building parts. How could I achieve this?

I am using an XMLTemplater to output XML. In FME 2011, the XML comes out with literal less-then, greater-than tags, that is:     <StreetTree TreeID="2919"> However, in FME 2015, the XML comes out with character entity references, that is:    <StreetTree TreeID="2919">  The XML reader in FME 2015 does not understand the character entity references. Is there a way to tell FME to output the literal less-than / greater-than characters?  Thanks 

Hello,I am trying to build queries using inlineQuerier query but an error pops up, I am not sure if my input dataset is right. I have a screen capture attached. Could anyone please help me. I am absolutely a new FME learner.

My little firm use FME 2019 on workstation Intel i7 (6th generation, 8 core, 16 thread with 16 go Ram). We want to renew our computer fleet and we want to install FME on a stronger machine.What kind of configuration would be the most effective to run FME : a strongest CPU with more Core, more RAM (32 or 64 GO), both of them or another element ?We use FME to transform big raster in shapefile, perform calculation with big database...Thanks by advance for your help.

Hi,In a point cloud I have those values for RGB.@Component(color_red)@Component(color_green)@Component(color_blue)How do I convert this to a hex number or an FME_color atribute?The goal is to filter the point cloud by color, for example removing all greenery from grass.Have no inpute other than the point cloud.

Hi all,Does anyone know more about the Offsetcurvegenerator transformer? I've offset a 3D polyline using this transformer setting it to the Miter option using a large miter limit (shown below). I would have expected this to give me the same number of vertices in the offset line but it appears to have added new, somewhat random points to the offset line. Shown below in the blue highlight. Can anyone shed some light on why this is happening and how I can get around it?

I try to update FeatureClasses in an Esri FileGeoDB. I use FeatureWriter with fme_db_operation=update and dynamic schema setting. FeatureClasses have NOT NULL attribute constraints.Problem: How do I control which attributes are updated ?I have the impression, that I cannot update only some attributes without specifying all attributes of the FeatureClass/Table. If I do not supply an attribute it will be set to NULL. Is that really so ? Is there a way to leave attributes unchanged, while others are updated ?That's what I am used to from SQL ...ThanksMichael

Desired functionality scenario: criteria stating the minimal Requestor overlap percentage the Supplier needs to have. (e.g., Supplier overlaps at least 80% of Requestor, or else the record is <Rejected>). I believe that adding this property to the SpatialRelator would add a lot of value and save a lot of complexity and time.But for now, I would like to know in as much of a step-by-step fashion as possible, how to achieve this functionality, which I believe could be accomplished more elegantly with a SpatialRelator upgrade.Feel free to chime in if you also support this functionality.