FME Form

I'm try to translate a multilayer GDB file to GEOJSON file. As a result. I found all layers are merged into one single layer. How can I translate it into multilayer GEOJSON

I'm trying to read a Orthophoto from ArcGis-DB using Reader-Transformer Geodatabase-sde-Raster-Dataset and clip an specific area of the raster using definition of Search Develop. At the End, make a tif export from that.  The Problem is that FME represent the reading raster als grayscale, although the raster has four bands. How should I export a rgb tif from raster dataset? I would appreciate any Help in advance. with regardsSoschianet

Hi there,Not sure where to post this so putting it here.Can someone please keep up to date the "Known Issues" button on the support homepage (https://community.safe.com/s/support) so it links to an article for the latest version of FME, not 2020 (https://community.safe.com/s/article/workarounds-to-known-issues-in-fme-2020x) ? Thanks,Marc

How to download multiple zip files from linux server in local starting with same prefix name (e.g. ARESFF01.341,ARESFF01.342, etc) with sftp in fme?Can we use FTPCaller?If so, how? If we can do it other way also kindly suggest.

I'm making an ETL to convert some features from an geodatabase SDE to Autocad DWG-files. It is working well, but i'm getting an error.AutoCAD Writer: Shape file 'ltypeshp.shx' or 'ltypeshp.shx' not found when trying to resolve shape ''It has no consequences for the output, but it is bottering me. Any idea what the problem could be. Am i missing some parameter?

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