FME Form

Hi, I've downloaded a json file that contains geometries defined as an array of coordinates. A portion of this json file is described below. One json feature can have one or more geometries. I can't find the proper way to parse this json file and transform this array of coordinates to a polygon. Do you have any solution ?  Thanks for your help.{ "identifier" : "2", "country" : "REU", "name" : "[FM][D 2] La grande montée/Plaine des cafres", "type" : "COMMON", "restriction" : "PROHIBITED", "restrictionConditions" : "", "region" : 931, "reason" : [ "OTHER" ], "otherReasonInfo" : "Zone dangereuse", "regulationExemption" : "", "uSpaceClass" : "", "message" : "Vols interdits sauf lorsque la publication d'information aéronautique l'autorise explicitement ou avec l'accord du gestionnaire de la zone lorsqu'il est désigné par l'information aéronautique", "applicability" : [], "zoneAuthority" : [ { "name" : "Autorité mentionnée en ENR 5.1 de l’AIP", "service

Hello!  I am generating a few TIN surfaces which i want to use in Unreal Engine. This means that i will need to generate a UVmap to be able to texture it in engine.  My current setup looks like this: (Ignore my Apperance setting and image rasterizer, i was trying to see if generating a georeferenced texture would work in the appearance setter.). My TIN surface is far away from Origin, so what i am doing is removing the xmin and ymin extracted in the bounds extrator for the offset in the texture coordinate setter. I have tried to do the same thing for the appearance setter aswell.  It seems to generate a UVmap, but the UV is VERY offset in regards to where i need it to be. the scale is correct though.  This is how my UV looks in 3Ds max, its the correct size, but WAY offset.  As you can see below, the size is correct if i manually move the UV down to the 1:1 UV.   Moving this manually for every tinsurface i generate is both nonexact aswell as timewise impossible. Do you have any tips?

We are using SQL Server 2014 deployed as 3 node cluster with 1 primary and 2 secondary. We need to connect to the READONLY secondary. To do that you the set the Application Intent=readonlyBut i cannot find the parameter setting in the database connection for SQL Server.

my question:i have an Ifc file structured like IfcProject -> IfcSite -> IfcBuilding -> IfcBuilding Storey -> IfcSpacetrying to convert to gml i fail to convert IfcSite to GmlLandUse. the export structure is:CityModel -> LandUse -> Building -> BuildingPart -> Roomwhen i remove the writer for LandUse, the structure exports as expected like:CityModel -> Building -> BuildingPart ->Roomids and parent ids are inherited from CityModel to LandUse to Building.... suppose ids and parentids are correct LandUse has no geometryany help appreciated

HI EVERYONE, I have a problem where I need to update ENERGY ADE using FME workbench but there is nothing appeared, I would like to ask, is it any of you have been work with it? I really need the helps since this is my final project.

I have a field with a code (number) and I would like to know if a feature haven't a number code in her line (maybe a message like "error" or other but with letters). Thanks for helping

Hi all, I've published a workspace to FME Server which updates some rows in Excel. When run on FME Workbench, the rows are correctly updating (using fme_db_operation = UPDATE) at the correct row number, which starts at row 10. I've set the row number by using a counter for xlsx_row_id with a Count Start set to 10. Weirdly, when published to FME Server, the workspace ignores the xlsx_row_id attribute and starts writing at row number 1 (even though it gets the correct column positions). Is this a bug in FME Server? Does anyone have a workaround? I've tried different options in the Start Position parameters of the FeatureWriter (both "Named Range Start Row" and "Start Row") but no success... Any advice gladly received, BI

Hi,I have an ifc file and there are attributes like volume, width, height etc . I can't see them in fme. I even tried to expand the format attributes. Does this mean that reading IFC files is limited to a certain number of attributes? How can I turn on the visibility of these attributes? Is it possible? I've attached a screenshot. The attributes I want to process are in a red box. Regards,Aneta

I have 16 polygons (zone) and a feature of points. I would like to clip points by zone and write to points in each zone in a separate shapefile. that means as a result I have to get 16 shapefile from points. Attached you can see the workbench I tried dynamic and fanout. anyway i only get one feature from punkt.

Dear All , We have a line and we need to add an arrow to it , as shown below we need to add the blue line , it looks that we need to use 2d pointer adder but how to get the exact location from the end point and draw two lines

How do you design a simple architecture on Revit and import the IFC file to FME and then convert it to citygml format. Thank you so much.

Vertex normals removed due to application of non-invertible matrix,Error running translation. when I try translate the 3d .obj model to 3dtiles,the error Appear，of course not all obj appear the error

Hi, I am new for using FME to create PostgreSQL database and having trouble updating schema or adding columns to the existing table. so to explain in detail: 1) I have different councils 3 waters pipe data which I want to add to my database2) I have already done extracting, and transforming of data but now I want to load data coming from different councils into a single PostgreSQL database3) So I am using FME writer format "PostgreSQL" and table (say Table1) definition as "Automatic" and ok till I have added the data from one council having 52 columns4) Now when I am trying to add data into same postgresql database table (Table1) from other council having 79 columns in it ... my database is not accepting data from those new columns came from new council 79-52= 27 columns into my existing database table Any comment or recommendation on this will be great!

There are GML/FGDB dataset with "round conner polygon" or multilines geometry which is mixed "curve and lines". It can't be written into GPKG file.src dataset geometryThe output geometry is IFMENullHow can fix it?

My workflow regularly compares files stored at path X with prefix Y with files stored at path Z with prefix Y. I'd like to set up the workbench in such a way that I'd copy the workbench for a project and only have to edit the Y parameter for it to read in the required files, i.e. Read: $(Path_to_X)/($Prefix_Y)*.csvRead: $(Path_to_Z)/($Prefix_Y)*.csv Can this be done, and if so, how?Thanks!

Hello, would anyone know how to group data under one airport? I have 32 airports, each airport has x UUID_departure and each departure UUID has x departureLegs and each departureLeg has two points. DepartureLeg has a unique ID and each departureLeg point also has a unique ID (it can be a variant of startpoint and endpoint). I have finished the connections, now I just need to somehow pair all departure legs under one UUID_departure and not connect individual points to these departure legs. Connect this whole thing to the airport. Is there any such transformer outside of featureMerger? I am attaching the WS on the download link, it is too big with data. Thank you!!!download link: https://www.uschovna.cz/zasilka/AQ2HU24BLI9F2R6D-XCY/

basically what i. want is that the outer polygon should be a doughnut-like shape, currently, its area is also covering the higher value qpf polygon inside (darker colours) it should have multiple polygons, just none that overlap the shp file needs to be clipped by itself

Hi I am interested in understanding the standard pattern to develop web services in FME. The standard use case is an external application post data to an FME server endpoint (e.g. polyline GeoJSON), have FME transform it (e.g. add a buffer around line), and return data back (e.g. GeoJSON again). I am trying to get my head around repositories, workspaces etc. Looking at it now it seems like the above needs to be accomplished with mulitple steps? Potentially posting data to FME server first, then submitting a job, then getting the results, then getting the final data? Thanks in advance,Nick

Hi all,  I was wondering if somebody could advice me a good tool that can be used for good version control of FME Workbenches and FME Custom Transformers. Any suggestions? Preferable an open source tool.  There are some  tools available for this, but most of them offer also automated "merge" and "compare" functonalities and in my opionion  this doesn't work well on .fmw en .fmx files, therefore I prefer not to have this functionality.  In case there is a difference, the user should be the responsible to choose the local version or the version of the server to decide which one to keep. Also multi-user-editing of the same workspace is not something that works in an FME environment (yet). But I do have interest in the back up functionalities, the compare functionalities, have a single repository of the main workbenches, being capable of taken the models locally and run them locally,...  I experimented with GIT version control, and It helps, but it is not exactly wh

Our data is in the cloud and there is possibility for increasing the performance of our network disks on the cloud. However doing so, will lead to much higher costs. So if the performances of the fme scripts are mostly determined by internal memory of the computer, then maybe we wouldn't need to increase the performance of the cloud services.

Hi altruist, I am having an issue in after using AreaOnArea overlay operation. I have overlaid two polygon datasets and ideally the output should have attributes from layer when there is _overlap field have 2 and more. This is what happened for other overlay operations. However, in the following cases I do not see the attribute from one of the polygons after the overlay operations: This is the attributes before overlay:The overlay operations:After the overlay:Does anyone have idea why that may happen?

Hi everyone,I try to put the "responsibleOrganisation" and " annotation" in my AIXM 5 writer. My workbench seems to have an issue but i didn't find where is the problem.I tried with an older version of FME (2017) and everything is good. I put here the 2 versions of the workbench. ( 2017 and 2022). With the written files output. If someone could help. Something seems to ne wrong with the "geometryPropertySetter", with the "XMLTemplater", and probably with the writer AIXM5. 

Hello!  I am trying to write to an MS SQL DB and some of the feature classes have a primary key where the column name is longer than 30 characters.  On the writer feature types, I can set the default primary index colum to a length longer than 30 characters, but when I look under the user attributes, the column name gets truncated to 30 characters.  When I try to write the features to the DB, it fails because the field names are no the same.  Does anyone know if there is a work around for this, or how I can get a column name longer than 30 characters to be recognized under the features user attributes?  Thanks! Tristan

Hey guys, is it possible to perform an INSERT/UPDATE/DELETE operation (fme_db_operation) on GeoPackage using an UUID which isn't an integer?The UUID was created by UUIDGenerator. If I execute the following workspace, I'll get this error message:e.g.OGCGEOPACKAGE writer: Cannot perform Delete on feature type 'original' by matching attribute 'UUID' since value '{48fb8445-ca8d-4f74-94ed-b0ce6c89ffdc}' is not an integer. Skipping feature. Workspace:Writer-Settings (unfortunately in german language) Thank you very much!

I'm trying to import different IFC modells via IFC Reader and for some it happens that the walls do not contain the respective openings where the windows are (see Screenshots of BIM Viewer and FME Inspector. I tried different import settings, and thought especially "Subtract Opening Geometries" should solve the problem but it still didn't work. I'm having a hard time finding a solution as I'm not entirely sure how FME cuts out these openings.  Any suggestions what might casue the problem?