General

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

Hi, I am a beginner, mostly have been using graphic QGIS interface before this. I appreciate FMN Workbench very much :)  I have been comparing old and new data from catchment area streams. Suddenly the second AreaOnAreaOverlayer stopped working. No matter what I did: it did not bring anything else to the table than the _overlaps data column. It's quite a big area (with smaller catchment areas in it) I am studying so the information about the catchmentarea_id is important. I'm choosing only the areas where are streams defined to me when I started working.  This is for someone having the same issue: do not spend time with transformer not working. Copy the first one working and rename it for example 2_AreaOnAreaOverlayer. I didn't let the system to rename it anymore, just in case because I don't know why the table information disappeared.  Hope this helps someone other to save time. KatiFinland

Hello ,  i am facing this problem I would like to import xml document (schema only ) to write into file geodatabase but I got this error The error number from ArcObjects is: '-2147220735'. The error message from ArcObjects is: {Unable to create object class extension COM component Then feature class name .Could someone provide me a solution for this problem ?FME 2021 Thanks in advance

Hello, I am new to FME and am taking over support for our FME extracts between Smallworld and MicroStation. I am seeing an issue where MicroStation is not honoring the colors I am assigning in the .fmw file. I tried the Level Overrides setting and that was not the cause. I seems to be an issue with the cells themselves, but I am not sure. Other cells seem to work fine but I am so far unable to make a distinction between the ones that work and the ones that don't. Hoping anyone has encountered a similar issue-- any information is appreciated.

two seperate shape file are there for trees and poles respectively, how to create there 3d visualisation with appropriate texturing.

I logged into FME Server several days ago and had no problems. Today when I logged in I get this message. Any ideas on a fix? (Our FME Server environment includes a Load Balancer between FME Server 1 and FME Server 2); I am logging in using the Load Balancer URL.

How can I compare 2 lists and find match elements as per the attached snap:I have 2 different data sate and I need to match attributes as per the element in dataset 2 list2 elements are mandatory and in dataset 1 list1 elements are should contain list2 elements. if list 2 has 3 elements and list 1 has 5, list 2 elements 3 must match list 2 elements, and the rest 2 elements of list 2 are optional. kindly refer to Snap for a better understanding.