Transformers

I am reading the polygon and Lines dataset in FME. I need to select lines that are intersecting a polygon and populate the polygon name in Lines. I have used tester after feature to filter one polygon and select intersecting lines using a spatial filter. Is there a way to loop through a polygon feature and select one polygon at a time in FME, Instead of entering the Polygon name in a tester every time.  

I'm trying to connect to our SharePoint Online environment to be able to work with lists. In FME Workbench (2021.1) I used the "Microsoft SharePoint Online (template) to create a new web service. When I try to test it I'm getting an error: "Authorization and token retrieval was successful but refreshing the token using 'Refresh Token Parameters' failed. Error: HTTP/1.1 401 Unauthorized".My redirect uri is set to https://localhostMy Auth parameters url is:https://login.microsoftonline.com/{mytenantID}/oauth2/v2.0/authorize?scope=https://{mytenant}.sharepoint.com/.default offline_access&response_type=code&prompt=consent Retrieve Token Parameters url:https://login.microsoftonline.com/{mytenantID}/oauth2/v2.0/token refresh token Parameters url:https://login.microsoftonline.com/{mytenantID}/oauth2/v2.0/tokenrequest format (default carried over from template):client_id=[CLIENT_ID]&refresh_token=[REFRESH_TOKEN]&grant_type=refresh_token In Azure

Good day, I tried to convert XML file to shapefile using FME and using the same steps in safe website but the data did not show up in the map and the shape was point, and what I was expecting is line.Here is the data source of XML:OneGeology catalogue (brgm.fr). Thank you with kind regards,Majdi

My purpose is to save it as .txt document. Manually I can open it in notepad and save it as .txt. But this has to do through FME.

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! 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

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

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 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

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 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 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?

Hello,I'm currently having a problem with my PostgreSQL and Postgis writers.When the feature operation is set to "INSERT", the INSERT is perform on all columns of the table instead of just the columns that are specified in the attribute definition.It result in empty data on columns that arn't defined in the feature attributes but have a default value in the DB. For exemple :I have a table with 4 columns (column_1, column_2, column_3, column_4).The column_3 have a default value ('my_default') In my script, I have a feature to INSERT some data into this table. This feature have an automatic attribute definition (to avoid defining every new column each time I modify my script).But my customer havn't any data for the column_3 and the column_4.So, the feature in FME have only column_1 and column_2 defined in it's attribute definition (beacause I chose the automatic definition option).After I run the script, the result I'm expecting is this one :column_1column_2column_3column_4data1.1data1.2

I have no problem adding the WMS reader to the canvas (selecting layers etc.), but as soon as I try to read the data I get an error: '<WMS> Exception detected for the GetMap operation, requested Content-Type, 'image/jpeg', returned Content-Type, 'application/xml'.' This is the WMS creating the error: https://service.pdok.nl/hwh/luchtfotocir/wms/v1_0?request=GetCapabilities&service=wms The layer is '2020_ortho25IR'. Does anyone know what is creating this error? Thanks. FME desktop 2021.2, W10 

hi everyone,I will give some background information beforehand. I have one dgn file that consists of many models (each model does represent a floor of a building) and the dgn file consists roughly of 1.5 million features (yeah, that's a lot for one building). The idea of my current script is that at first the dgn file is read, some transformation steps take place and finally each floor will be written to a seperate dxf file. So far so good, since each floor/model needs to exported to a sepereate dxf file. However, after some time only a few adjustments are to be made (e.g to only one floor and thus only one model is adjusted in the whole dgn file. Therefore I would need to run the script to overwrite the output of that specific model/floor since changes have occured.  I would like to know if there is a possibility of reading the dgn file and only taking the features of that one model that has changed within a certain time. This might reduce the computing time of the script treme

I have some 3D Data with existing appearances - I just want to make a few of them brighter. I can use the AppearanceExtractor to get the unique appearances, and I can see that with the ApprearanceSetter I can apply one based on a trait I can also see that it's possible to just update an existing appearance. I just can't figure out how to just update it based on the appearance name as this doesn't seem to be a trait For some reason I can't figure out how to do this - has anyone achieved this?

Apologies for asking what I expect is going to be a very basic question. However I would like to read all files of a particular format (eg dxf) in a folder, apply a coordinate reprojection to them and then output them to a different folder. To read the files from a particular folder I believe I would use the Directory and File Pathnames Reader? To apply the reprojection transformation I would use the csmapreprojector, however to write the many files (eg dxf) out to a different folder I am not 100% of the methodology (and or writer) for that.Many thanks in advance