General

I've got a grid of polygons, each square is equal in size but has an attribute stored against it with a numeric value. I want to group grid squares together based on a sum of that attribute, but that sum needs to be as close to an upper limit as possible. So for example in the picture below all 'like' coloured grid squares are collected into groups where their attribute sum does not exceed 60,000. As close to 60,000 as possible would also be acceptable. I can't have disparate geographic groups, it has to be one block of squares, albeit that block doesn't have to be completely uniform.When I started looking into this I thought, this must have a "name", an existing algorithm and "I bet there's already a custom transformer"... Well, I haven't found anything yet. Can anyone help put me out of my misery? This feels like a loop might be required, but the issue is the proximity, the grid squares might need to be pre-sorted geographically first?

In FME Desktop* I'm upgrading attribute transformers to latest version. The most significant change seems to be that now attribute types are specified. In the case of SQL Server and `varchar()` varchar takes a a width parameter. FME appears to be suggesting values based on the input stream from a cached run, which is very helpful. However I don't know for sure the present input stream represents the possible range in the source.  In this example we see AttributeManager showing wide variety of specific integers in varchar() width: 80, 7, 969, 95, 43. What do these numbers represent? Are the exact measurements of current input? Are they padded a little bit for insurance? Do they take into account if the input is high UTF-8, and thus need 2-spaces to encode 1 character? Most importantly from work productivity perspective: is there something I can do to adjust all these numbers by X percent or value instead of clicking each and every one of these values and then typing a number acr

Our supplier has changed their API and are now using OAuth. I'm struggling to connect, mostly because they are very unhelpful about what is needed in the Header and Body to access the credentials API I have been given this information:access token URL https://ashridgeidentityserver.azurewebsites.net/connect/token OAuth 2 with Client CredentialsClient ID : AG_WaternetAPIClientClient Secret : **********Client Scope : AG_DatabaseAPI And a screenshot from their POSTMAN service. Can anyone help me set up the HTTP Caller? I have added the client secret to a Bearer Token thus far but just get "bad request"  

Hello,I have an error when trying to use a costum transformer : FME Flow version : 2020.2.1FME Form version : 2020.2.4Error : The custom transformer was created with a newer version of FME Workbench All jobs created under the more recent version work perfectly on FME Flow.There is just the transformer who causes this problem.Could anyone explain to me why this happens ?@david_r​ or @Hans van der Maarel​ ?Thanks a lot.

is there any way that Automatically Date and Timestamp When Data is changed

I am using FME Form (previously desktop)FME(R) 2019.2.3.2 (20200320 - Build 19825 - WIN64)I want to learn how to use a simple WFS readerThe provider is Geoscience Australiahttps://services.ga.gov.au/The WFS is National Local Government Area Council Officeshttps://services.ga.gov.au/gis/services/Australian_Coastal_Sediment_Compartments/MapServer/WFSServer?request=GetCapabilities&service=WFSThe URL I have set ishttps://services.ga.gov.au/gis/services/Local_Government_Area_Council_Offices/MapServer/WFSServerBut it does not workI get this error<ows:ExceptionReport xmlns:xs="http://www.w3.org/2001/XMLSchema=" xmlns:ows="http://www.opengis.net/ows=" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance=" xsi:schemaLocation="http://www.opengis.net/ows http://schemas.opengis.net/ows/1.1.0/owsExceptionReport.xsd=" version="1.1.0="><ows:Exception exceptionCode="InvalidParameterValue=" locator="outputFormat="> &l

How to setup connection to Azure using MSSQL_AZURE which requires "Azure Active Directory Authentication" FME MSSQL_AZURE is lacking such option. We need "Azure Active Directory - Integrated" as Authentication

HiI have a travelling salesman use case, where a fleet of perhaps 2-4 vehicles need to reach a set of locations in a municipality. I have used the shortestpathfinder before, but not with multiple agents/vehicles. Is that possible (finding the optimal plan for, say, 3 vehicles for an address list)? I found https://engage.safe.com/blog/2016/11/fmeevangelist158/, but it doesn´t mention more than one vehicle.

Hello , i have many start node and several end nodes and network that I am using as input for shortest path finder .My problem : i have found the paths that I want from start to end . how could I remove the overlap parts of path ,because i have found that some paths uses the same network to reach different end nodes .there are intermediate points locates on the network ,so I would like to know the id of each point (from direction start node to end node ) . as example , the next point after start node has id 389 then next 490 then next 999 then …… i would like to know ( 389 connects to next 490 and 490 connects to 999 till reach the end of the path )fme 2021 thanks for help .  

Hi, I'm trying to create ECW mosaic from multiple ECW files. It's trying to mosaic 3693 ECW tiles. I have a floating licence for FME.  This is the workflow I'm running. Below are the errors I'm occurring: 2023-07-10 20:42:10|24575.6| 0.0|ERROR |ECW writer: Could not open compression task Output image size exceeds license2023-07-10 20:42:10|24575.6| 0.0|ERROR |ECW writer: Failed to write dataset. This may occur if you have insufficient privileges to write this file, or if insufficient disk space is available2023-07-10 20:43:13|24638.5| 62.9|ERROR |ECW writer: An error has occurred. Check the logfile above for details

Anyone help me out to extarct the data from this pdf please

As you can see, when I extract the data, it's showing me all "advrnum" with "td". but when I merger them so I get only one recoder of Advr 8  I need all rows.  

 Hello Group, I manage a large directory of geospatial data, mostly in .tab. But times and needs are changing and I’d like to have the data available in other formats such as shp, geojson and gpkg. In an ideal world we’d have a PostGIS database, but that’s not about to happen any time soon. So, for the time being, and probably into the foreseeable, I will continue to maintain flat files.  In FME Form, I need a process where I can point a FeatureReader at a folder and, in as few steps as possible, write each one to .shp, for example. I need to maintain the name (done so through Accumulation Mode: Merge Initiator and Result, I believe). So, for example a folder may contain 20 tab files (Zones_A.tab, Zones_B.tab, Zones_C.tab etc. etc.). I would want to create Zones_A.gpkg, Zones_B.gpkg, Zones_C.gpkg, but do so in one go. I know I can read in files from a folder (via ‘Select Multiple folders/Files’ in the FeatureReader) and then publish as a different format to the same location (or differ

Using the AttributeManager, i understand that i could create a new attribute_alias for each attribute i want to update. However, since there are hundreds of attributes and they all need to be named the same as the existing attribute name - except in TitleCase without underscores > I wonder if there is an easy way to do this?

Hi, I have two polygons dataset. I would like to find the differents polygons between them. In other words, which polygons have in dataset A that do not have in dataset B. In opposite too. I used spatialrelator and PointOnAreaOverlayer already, but no success. Attached follow my datasets. Thank´s

What I want: I want to read a list of pdf files and write metadata of these files to a postgresql database. The attributes I want to export are number of pages, file name, file path and file id (which I create through the UUIDGenerator).  I start with a PATH reader to find all pdf files from this folder through all the subfolders. The problem is I also want to add the number of pages of each pdf file to the output table and I don't think I can find this with the PATH reader.  Therefore I included a PDF reader and have found the number of pages of each pdf. Now the problem is - how do I combine the output of these two readers? I have tried to use Featurejoiner and Featuremerger but both of these requires a common attribute to join on. But I can't find a format attribute in the two readers that is unique. Is there a way to index the attribute tables of each reader? Or is there some much easier way to perform this action?  I have included a screenshot of my workspace until now.

 Been trying to get this working for a while, but I have to surrender... My XML:<?xml version="1.0" encoding="UTF-16"?><Surface name="Zone 101_01.01_A_020!" desc="" xmlns="http://www.landxml.org/schema/LandXML-1.2"> <SourceData/> <Definition surfType="TIN" area2DSurf="234921.542328654672" area3DSurf="238197.012906672346" elevMax="11.943587904916" elevMin="-3.839199295337"> <Pnts> <P id="2">214609.472108227172 150506.362479594914 5.162708941504</P> </Pnts> </Definition></Surface>The attribute I need is "Zone 101_01.01_A_020!". Queries I tried:/Surface/@name/string()for $c in /Surfacereturn data($c/@name)/Surface/@nameWhen I test in online extractors, it does work. When I remove the namespace it starts to work, but why?I'm using FME Desktop 2021.2.6Can someone please help?

I am trying to connect to a map service hosted on another organization's ArcGIS Server. I have the credential for the service and able to connect through the REST endpoint on a browser. When I try to connect using the ArcGIS Server Feature reader, I get the error that a token is required. I read on community blog that some people had to set up a web connection using a Portal template .It looks like this requires and AppID from the Portal, which I can't obtain since I am no admin and it is from a different organization. What are my options then?  Any input is appreciated! Thank you!

I'm new here and need to filter data from a Odata feed. The feed contains open data so no need for credentials. When I add an Odata reader and paste below URL, I can choose several feeds. The main one is named: TypedDataSet​https://opendata.cbs.nl/ODataFeed/odata/82062NED​​The direct link to main Odata feed is: https://opendata.cbs.nl/ODataFeed/odata/82062NED/TypedDataSet​It contains data from 2012 tot 2023 April. I only need data from 2022 and higher. I found some tips for filtering like placing?$filter=Perioden gt 2021MM12 but this doesn't work. I think I'm almost there and only need to figure out the right syntax. Can anyone help me?Thanks in advanced!Cheers Richard ​

I have a dynamic workflow that writes spatial data from a MS SQL Server to a postgis database. Since my inital data is not always restrictive on geometry types, I want to ensure that Geometry types are well defined in my destination database. I had an issue with mixed lines and multilines that I solved using an aggregator (destination geometry (multilinestring) ) but I had some geometry collections creating some issues when writing data so I added a GeometryFilter. Visually no feature is filtered (only lines) and the writing is doing great. Removing this filter will make the writing fail.  My question is then : Is the GeometryFilter altering the data or the way the data is presented to the writer? 

Hello everyone,  I am currently working with .DGN files.My goal is to create a new DGN file with new values in the "igds_cell_name" field. I would like to know if it is possible to modify the "igds_cell_name" attribute value??? Because at the moment, 

Hi, I'm looking for some additional explanation on parallel processing using the workspacerunner transformer. There's 20 batches of GDB-data (all separate gdb's to prevent locking).When I use the workspace runner to use 1 workspace to run 4 parallel instances using different input and output geodatabases (no locking is occuring) for all 20 batches something goes wrong. I cant tell what is causing issues because the logs are incomprehensible. Does every instance keep overwriting the log file? I see that it executes the command to run in a rapid order while each feature is expected to run around 5 minutes. After waiting and seeing all FME processes finish in my Task Manager i only see around 4 output geodatabases made. I need to see: 20. However: I tried to fix it. I use Text-reader and Text-writer to create 1 .fmw for each batch: so 20 fme models. I use each model 1 time in each parallel process. Meaning: unique input gdb, unique output gdb, using unique fme workspace. This

Is it possible to read curved annotation from File Geodatabase and write it to ArcSDE with zero/minimal distortion? Note: Source and Destination feature count should match. Thank you.

I wondering it is a bug or not on FME?Input from CAD:And on FMEPls, help me to explain it and how do i handle it on FME! 

 Hello everyone i have polygons and there are points in them my question is how can i find the point with smallest value inside the polygon thank you very much to everyone in advance