FME Form

I have an Oracle database with about 500,000 entries. I want to read in 1 feature for each unique value of 'DEVICE_TYPE'. Is there a select or where clause I can use to do this?

Hi! I'm trying to extract parts of a response body from a HTTPCaller. I've read some previous threads on the topic but I just end up more confused. The response body looks something like this:  [{"href":"https://download-geotorget.lantmateriet.se/download/99d120aa-9532-43a9-a5a7-6128b333bc88/files/root/militartomrade_kn0125.zip?q=t-CwjGgGH....1Vl4dA==","title":"militartomrade_kn0125.zip","type":"application/octet-stream","length":3792,"displaySize":"3,7 kB"}, {"href":"https://download-geotorget.lantmateriet.se/download/99d120aa-9532-43a9-a5a7-6128b333bc88/files/root/hojd_kn0125.zip?q=t-CwjGgGHQJjXdA1styBEV1B.... ] And so on. It goes on like that, so I shortened it down. The parts I'm trying to 'extract' are several URLs, and I'm looking to create attributes from them, in order to download the zip-files they point to. Does anybody have a solution to this?  You

If i have an esri fgdb that has no features in it. To be used for a template.I want to validate data coming from the field against these coded domains values in the template. But i can't see how to get the domain values. I have the "resolve domain" checked on. I can see that probably having the single merged feature as features will not work as you get literally NOTHING.i have also tried individual feature types as both features, and metadata.As features I get no features (of course), as metadata I get 1 feature for each featuretype (and have enabled ALL format attributes for each featuretype). But, there is no "ATTRIB_resolved" attribute. So using the FME Hub "Read_ESRI_GDB_Domain_Data" custom transformer doesn't even work. It seems the only interface that will allow this is through the esri "KLUNK KLUNK" domains/subtypes "clickamilliontimes" interface with no output.anybody else experience this?

What is the best management practice (bmp) for assigning Unique ID to AutoCAD drawing (dwg) objects? I am preparing to use upsert (haven’t upgraded FME yet) and need to establish a Unique ID for every AutoCAD object that becomes a feature. The current workspace ingests ~300 drawings, transforms to GIS features, then writes to a single feature class in an ESRI geodatabase (gdb) file. Up until now, my focus has been on the ingesting and transformation. The current workflow simply overwrites the entire feature class every run. Now, with upsert coming, I want to refine my process to update and insert only modified features.I understand that AutoCAD object ‘handles’ are unique to each drawings object, but I’m thinking not necessarily unique across multiple drawings. I could concatenate handle with drawing name, which would work for me currently, but could at some point be flawed, as drawings in different directories could have the same name. I have other ideas, but want to hear form the com

How about ArcGIS 10.8.2 Support ? It is around since 2021 and nothing is mentioned on the FME Esri compatibility page.

Hey there, Trying to figure out of this is possible with the current data I have. I have a road network that looks like this of which I generated points for the mid-points of the segments. The road network does have froms and tos.Essentially we have a camera on a car that needs to traverse this network in the same direction every time to make comparisons going forward. So ideally im looking for the quickest way to travel this route hitting ALL of the roads and have something that can be repeated every month where the driver is going the same direction every time. Is there an article on this I can't find?

I am trying to build an API POST call using HTTPCaller for situations where there will be a dynamic number of parameters using the same name based on an aggregated list. In this instance, I have an attribute value called "fee id" which could have anywhere from 1-20+ items in the list (built using Aggregator) depending on how many charges were processed in a specific transaction. Each item on the list needs to be its own parameter (the values cannot be comma-separated), which is where I'm running into trouble. I can configure HTTPCaller manually to handle this, but that is only in my tests where I know ahead of time how many items will need to be processed.  I have been unable to find a way for FME/HTTPCaller to accommodate dynamically generating a query string parameter for each item in the list. Is this possible?  Even though it is not the most elegant solution, I also tried playing around with using a conditional statement for the name column (i.e., if a value in &q

I would like to use the hosted (cloud) solution, but my database is behind VPC, so there is no direct access from FME to my DB.how can I save the data in the EWKT or EWKB format, so I could save it by myself to the DB , using a text file? (or a stream in websocket?) I tried using GML & GeoJson - but they both loose the geometry types and just save as multilineString

I have lab data that is reported in rows, one row for each analyte for each sample. I need to create a single record for each sample, with the analyte values as columns in the record - build a single record of analyte values for each sample.to this:

Hey guys, I have XML Meta data files which I read and aggregate to one table to write them in a ArcSDE. The SDE is an Enterprise Geodatabase and the platform is SQL Server. To Connect to that SDE I need username and password. I use the FME Workbench directly in ArcGIS Pro and my connection to the database is existing. When I use the Writer "ArcSDE Geodb" FME is asking me for "Connection file". How do I get such an file? Or is there another way to publish the output directly in the SDE? Thank you in advance!Take careCheers,Fabian

I'm trying to take a simple shapefile and transform it to citygml. I've found a couple solutions that suggest all I need is what it defined in my attached workspace but the output doesn't seem to honor my extruded geometry. Any ideas what I'm doing wrong? And here is a picture of the workspace if that helps.

I have an old autocad drawing which contains static labels in the 'Banen_Detail-regnr' layer.I wish to convert this to dynamic labels with map annotation templates.In case an object's metadata value (from the Object Data) changes I wish to update this label automatically (CMD: _mapannrefresh / Stringsonly) I can find the attributes values in fme_attrib_info{}.field_name & _value but I cannot write this to a block nor can i link it to the object.

When writing to a csv file with the following settingsIf writing a value such as 18" pipe the field is written to the csv file as18" pipeThis is different behaviour to the 2015 writer where this would be represented as"18"" pipe"It looks like the 2019 writer doesn't consider the presence of a single quote character to warrant the field value to be quoted (although i would consider it to be an unsafe character)Is this expected? 

Hello! I have a problem while trying to read the data from postgresql (I'm not an expert). Everything seems fine with database connection (test is successful - also I'm able to connect with the same parameters from psql).The reader is created, I can see the attributes of chosen postgresql table.Everything goes well until I hit the RUN button.Then I get two types of errors: Error executing SQL command ('SELECT c.relhasoids AS oids FROM pg_class...Error executing SQL command ('declare "public_xxxxx_crsr" cursor... Does anybody have some experience with this and can share some guidance. Thanks in advance!  

I have 2 kind of points that are connected graphically every 2 points with a line. I would like to know how FME can be used to link the attributes of points with associated ones. I am attaching an example for better understanding. 

Following some helpful advice from Shannon in the FME Customer Success team, in place of a jobs board on the FME site I was advised to post a current position we are recruiting for here. We are looking for a seasoned FME Professional with Desktop and Cloud skills to support a team of geoscientists and help mentor 5 or so other FME users within the office. The role within Landmark Halliburton is to continue to develop our suite of geoscience products which include a range of 2D and 3D continental and global scale geological representations of the Earth - see Exploration Insights for more information.Within the role you will be working on further innovations to the product range and helping to shape the direction of product delivery. If you have OL3 and GeoServer experience as well that would be a fantastic bonus.If you are interested please apply through:this linkThe role is permanent and based in the Oxford office in the UK, the salary range will be between £50 - 70k depending on exper

Hello.I have a layer of lines and a table of observations on these lines.The line observation table contains the ID of the line on which the observation is made as well as its distance from the line origin. I would like to build a layer of points along the lines containing the information of the observations respecting the distance of the observations to the origin. Do you have any ideas? My research has only allowed me to create points in a regular way without being able to assign the attributes of the observations. I am a beginner in FME, thanks in advance for your answers.

I have several IFC files, each one has its own structure.I managed to save some of the data as a polyhedralSurfaceZ in postGIS, but some of the data structure is more complicated, and saves as a geometry collection of several types. I only managed to save it to postGIS when the geom type is the general "GeometryZ" but then I cannot used the indexing power of postGIS and queries take forever, and some don't run at all ( like st_volume) is there a way to transform the geometry collections to a solid that will be saved as polyhedralSurfaceZ? example of such data:GEOMETRYCOLLECTION Z (CURVEPOLYGON Z (COMPOUNDCURVE Z ((....some also have PolygonZ , some have POLYHEDRALSURFACE Z   

Hello, I'm experiencing difficulty transforming a .las file to Mojang Minecraft format, as I receive an error stating that the Z coordinates exceed the allowed parameters (0-255). I've found no straightforward way to manually set the maximums and minimums before transforming. I've tried to scale the .las, but the feature is imprecise and results in distorted structures. ​Is there a way to set minimum and maximum coordinates prior to transforming?

Hello everyone, is there any way how to write custom file properties (metadata) to Sharepoint, please? Thanks a lotLubo

An Oracle table with 16339 features is called in a workflow. After that a tester selects items with conditions: CODE begins with RK or CODE begins with PK. All but 4 items are selected. The workflow works without problems in FME Desktop, but fails on FME Server. As an alternative I put an SQL query in the tabel reader: CODE LIKE 'RK%' OR CODE LIKE 'PK%'. To my surprise it - again - works in FME Desktop but fails on the server. So it seems the problem lies in the Oracle database table. Any thoughts?

In a same dataset I have two columns that I want in a same column. How can I do that ? Thanks

For example, as you see on the screen, I would like an only feature for Roda (and Mira too) in a first column and all the color in another column . Here, I have many line for Roda and Mira, I would like an only. How I can do that ? Thanks!

Hi, Im trying to write a scripted parameter to allow only specified EPSG codes from the CsmapReprojector and apply the correct transformation . Based on a chosen source and destination CRS selected by the user a certain transformation is applied. This works fine, except when I try to use the <Auto> parameter. According to the documentation I should "Use the alternative blank string and NULL_FME respectively when passing in as an attribute." Unfortunately when I use "" as blank string in my script, the workspace fails because "Parameter 'TRANSFORMATION' must be given a value."  So how do I pass a "blank string" that triggers the automatic transformation in CsmapReprojector? My script looks something like this:  import fme if fme.macroValues['SOURCE_CRS'] == 'EPSG:25833' and fme.macroValues['DEST_CRS'] == 'EPSG:31468':  return 'DHDN_to_ETRS89/01_local_grid_FME (Reversed)'else:  return "&quo

Hello, I am in the process of developing a 3D noise model using FME to process the geospatial datasets ready to convert into noise modelling files. As part of this process, after having draped road centrelines to make them 3D, I need to then generate an elevation surface from the 3D road centreline geometries that will be used to drape bridges and breaklines so that their elevations align (there is a reason why we want to do this rather than draping bridge and breaklines to DTM/DSM which I can explain if required).  Appreciate any advice on how best to approach this?