Transformers

Hi, sorry for this newbie JSON extractor question but I am using the JASONExtractor transformer and I am trying to populate a column called 'Temperature' and populate it with the value, such as '50' shown below. My query is this: json["beds"].["Weather"].["Temperature"] but this and many, many other variations also do not work. Can someone please, please help me? [ { "id": 3009, "beds": { "Time": "Morning", "Weather": { "Temperature": 50 }, { "id": 2969, "code": "STPAL", "name": "Acme Co." } ]

Hello, I have a DWG file with rooms drawn as closed polylines (all on one layer), and within each polyline, there are 2 text labels (on 2 different layers). I'm trying to transform these 3 layers into a single GeoJSON file, where the room polylines would populate the "geometry", and the 2 text labels would populate 2 different "properties" ('id" and "label"). I tried doing this using the FeatureMerger tool, however this doesn't produce the result I'm looking for, as the attributes from the Supplier ("id") are merged. The current result is that all the features in the GeoJSON have the same value for "id", which is not what I'm trying to achieve. I simply want to transform all the rooms to geometries and the 2 text labels to properties of the geometries. I'm sure I'm missing something simple, but is there a way to get the result I'm looking for? Here's a screenshot of my current workflow below:

Hi, I have a .obj file and a geotiff file, the .obj file is in xy space and the geotiff file is in UTM-48N projection. I am looking for a way to "align" and reproject the .obj file. Is there a way to reproject the .obj file to geospatial coordinates?

Hi, Is it possible to place 3D created objects with the creator transformer, on specific xy coordinates from a point dataset? Thx, Mark

Hello, I'm wondering about data showing in the Visual Preview. Below an example. Two flows of data going to two Inspectors. When I select the SRC_RAW Inspector the Visual Preview shows the SRC_NORMALIZED data. I will have to use the drop down menu in the Visual Preview to retrieve the SRC_RAW data. That has annoyed me for quite some time now - why can't I just select the Inspector and see the proper data straight away? Cheers, Ed

Hi FME community, I need help to do one little thing: I have a request to simplify the geometries I processed with a tolerence of 0.5 meterThe geometries come from two tables and at the end they are saved as Geometrycollection (with aggregator). Thanks for you help...

Hi! I have a file with only one block put repeated a lot of time. Each block have a 5 labels with a different rotation for each of them. On FME, I change the name of the block and I add attributes. I have a template with the block for the writer. I succeed to export my blocks, but on Autocad, when I do the command BATTMAN, all my rotations are reseted. For me that don't work because the orientation is on the label, and the label of the block on the template have an orientation by default defined on the block. So I would like to recover the rotation of each label and put it on DWGstyler to keep these rotations. Fisrt problem : on the reader, the label is not join to the block.There are 2 differents entities. So I need spatial join on the workbench, but I would like to avoid it, because I should have to check each value to be sure that the join is correct. I try with exploding block and autocad_block_number to have an unique value on common but it don't work. Do you know an other method?

Hi All, I'm attempting to extract rendered data from a web page that is embedded in an ESRI dashboard. I'm in search of the map itself. I can get all the surrounding data from the attributes of the feature classes. I am in need of just the rendered map to put into a jpg, tiff, pdf, or whatever. Has anyone had any luck with doing such a thing? I've been working with HTTPCaller, ImageFetcher, ArcGIS Server and Portal Services (the real one is internal data, but this will work too for learning). Maybe use HTTPExtractor? If there is a way of extracting the map only, then I'd also be interested in being able to specify coordinates as well in order to grab specific areas of said map for other images. Thanks, Jazmateta

Hi! I'm trying to write a regular expression into StringSearcher so I can extract specific attributes. Those are numbers looking like this: 1234/123 or 1234/1234 I can't just use a filter with "contains /", because there are some other attribute values also with /. They have to be specifically looking like in my example (well, the numbers can be any). It's mainly the aspect and structure that has to be like this. Any help? I don't have much idea on how to write expressions... Thanks in advance!!

How do I copy the data in the Table view and/or export to a spreadsheet

Hello guys. What i am trying to do is to get tiles from S2 on AWS inside FeatureReader. So far so good but i want to adjust the range of dates by incoming attributes from another input (eg. Excel table). Start date is a specific date minus 5 days, and end date is the same specific date + 10 days. Everything seems ok till i click OK on the FeatureReader. Then i got this screen: So in the end of the day i don't have the start/end date defined by the incoming attribute. Is this somehow possible because i don't want any manual inputs in this flow. Thanks and keep safe!

Hi everyone, A quick, probably very simple, question here. I'm working with different areas and I have calculated what percentage of a certain area belongs to a certain group. Now, the percentages all have a single row in the attribute table (see picture). I want all the percentages to be on a single row so I can have the percentages per area and make a pie chart with it. So it should be just one row for the GEBIED = Donzel 1 Hopefully this makes sense. Thank you in advance for your help! Best regards, Esmee

Hi @daveatsafe et al, if I am using the Maximo Transformers in FME Workbench, what Reader or Writer do I use? For example, if I am reading from a ESRI FGDB and I get certain records with attributes from that read, and I wish to write them to a Maximo Asset, I understand that I must use the MaximoObjectUpdater. But what Writer do I use? Or, If I am reading from a Maximo Asset, I must use the MaximoObjectQuerier. But what Reader do I use? Thanks, Mark

I have made a workspace that downloads Dutch TOP100NL via links like these: http://geodata.nationaalgeoregister.nl/top100nl/extract/kaartbladen/TOP100NL_20W.zip?formaat=gml I read the GML data with a FeatureReader and in the end I write it to a File Geodatabase. However after I ran my entire workspace I saw that I was missing some columns in my Attribute table. After searching for some time I found that the GML sometimes has multiple value's for the same attribute. As you can see in this screenshot we have two values for 'fysiekVoorkomen'. If this is the case in FME there are two curly brackets behind the attribute and in the end this attribute is not written to the File Geodatabase. This is not only the case with the attribute 'fysiekVoorkomen', but with a lot more attributes in my workspace. Here you see how the attribute is displayed (fysiek...omen{}). Apparently the curly brackets mean that the attribute consists of multiple elements (listelements). I would like to write this attri

Hello I'm looking for inspiration to parse a tab delimited text file that defines features. Geometry can be Point (single row), or Line/Poly multiple rows with the order maintained in the file and also with a sequenece number if required.This is all fairly simple except the segments for Line/Poly can be a mix of straight lines and arc segments. Looking for ideas how to construct the geometry for Lines/Polys containing arcs? My current approach might be to build the geometry in an attribute value (FME OGC WKT doesn't support arcs) and use GeometryReplacerFurther suggestions appreciated - Thanks

I use the S57 reader to read a 000 file and have set the parameter "Action to Take on Update" to True so that the update files (001, 002 and so on) will be applied. When the reader apply an update I expect that the attribute UADT (Update application date) on the DSID object will be the date from the last update file. When I use the Inspector to watch the object the UADT has the same value as ISDT (which is the date when the 000 file is created). Is there an error or is there something I have to do to get the correct UADT?

Hello FME Community, I got a problem with polygones (Buildings), which intersect each other. The data is given as 2D Polygones (or maybe as 3D, but better would be, if I could solve the problem with the 2D Dataset). Each Polygone got an ID. Each polygone got the attribute "height". Some Buildings are so complex, that they are mapped as many polygones with the same ID. To review the situation: I got 2D polygones and some of them are intersecting each other. This could be in many ways, Sometimes 1 Polygone is just intersected by another, but there are many situations, in which the polygones are intersected by more then 1 polygone. It happend, that one polygone is with 100% of its Volumen in another one (100% overlapping). On top, in could happen, that the polygone is intersected by another polygone with the same ID and by polygones with another ID (so the grouped by doesnt work). The Goal: I Need to figure out the Volumen of each polygone without the intersections. The intersected part m

I have some big ECW files 3-6gb each and they are clipped by the administrative boundaries (50polygons,1 shape file,attribute name is administrative unit name). Now the administrative boundaries has changed and updated and i want to use this new polygons as clipping feature where rasters should be clipped or merged(mosaic) by parts of neighbor raster based on the new boundary which they fall inside. What is the right workflow cause i dont want to do it one by one filtering the administrative units shape file one by one, i want that the rasters to be clipped inside the new boundary for every administrative unit(where all the units are inside one shapefile with the attribute as administrative unit name). And i am not sure if the ECW files are the recommended format for this process case i'v read that they are very slow.

It seems that the RasterExtensCoercer removes every attribute which name is prefixed with underscore, if you set Raster Extent or Data MBR Extents to the Extents Type parameter. See the attachment. (FME 2020.0.1)

Hi, I kindly need to know how to transform a file in .csv format into a file in .pxy format or a .txt format. Many thanks, Mamdouh

Heya, I'm having some trouble writing a two csv tables (share a relationship via a common ID in both tables) to a esri feature class and related table (linked via relationship class - global ID / parent globalID) which have a set pre-configured schema. Here are the steps i have taken and some screen shots of my process to load the csv data to the feature class schema (part 1/2). Part 1/2 - load geocoded main csv table data into esri feature class The csv default for each field is read as a text field, thus the Esri reprojector is trying to pass all these text fields into a set schema. Do I need to include a schema mapper? If so, what does that table look like and in what format does it need to be in. Or, do I need to define all the fields in the CSV reader? The csv is being created correctly no problem and the data are same in the same projection and in the same region as I view them all in the preview with feature caching. The writer to write to Awhina Schema cannot be run - it's grey

Using TableAdder to create a table with more than 1 content-row results in the rows not being aligned. I have tried with and without different group-by options. Inside the tableAdder the error becomes obvious, less so to fix. Data for placing the boxes in the Y-axis depends on the _count variable, and so the boxes ends up being displaced a half-height for every iteration. Has there been updates to Counter without TableAdder being udated? I managed to get the output I wanted, by removing a counter transformer and changing the code for y-placement, but I am left wondering why the plug-n-play transformers are broken?

Hello there! I have a little problem with solving this issue. need to create a geometry (with creator) which should be used as an "selector" maybe via intersect or overlap of features. This features are comming from featureReader (ArcGis-Online Portal). They should be intersected (or overlapped or similar) with created geometry, and as a result should be plain Excel Data, that inhalts only interected features. The problem is, that in my result excel data are no features inside. It looks like the were no "intersection". No features in created geometry. (but they are there) . I tried it with intersection and also with overlapping . Not pretty sure what is the problem. Maybe I just do not see some setting? the result Excel is included Any Ideas? Thanks

Good morning. I've been facing all morning a FME crash that I do not understand. So far I have tested my workspace with two version: FME 2018.1 and FME 2020.0 both 32-bits. The process fails with both of them.My source data is a Personal Database (MDB) without spatial information. In one table I have data about "group layers" and in other about "layers". A group can contain layers and other groups. I must build a JSON with that info. To build the JSON with the groups, I have used the following JSONTempalter: ROOT contains: { "version": "1", "tipo": "3", "servicios" : [ fme:process-features("GRUPO") ] } GRUPO contains: { "Nombre_ES": fme:get-attribute("NOMBRE_ES"), "Nombre_EN": fme:get-attribute("NOMBRE_EN"), "grupos" : [ fme:process-features("SUBGRUPO", "PARENTID", fme:get-attribute("ID")) ]} And SUBGRUPO contains: { "Nombre_ES": fme:get-attribute("NOMBRE_ES"), "Nombre_EN": fme:get-attribute("NOMBRE_EN"), "grupos" : [ fme:process-features("SUBGRUPO", "PARENTID", fme:get-attribute("ID")

I am trying to figure out how to insert empty lists into a JSON Templator as an empty bracket like this: "materials" : [], Currently, I can't only get it to look like this: "materials" : [ { "materialBridgeId" : null, "materialTypeName" : null, "materialName" : null, "quantity" : null, "tamsUnitOfMeasureId" : null, "tamsUnitOfMeasureName" : null, "tamsStockpileId" : null, "tamsStockpileName" : null, "isDerivedFromCirus" : null } ], Any thoughts on I can achieve the empty elements listed above? Thanks! Mark