General

Hallo FME community,I have many lines in a shapefile and some lines are connected to each other. I want to bring all lines that are connected together into one feature. I would be grateful if someone could give me an idea. 

When using Sharepoint Online Connector, this error message appears "timezone offset does not match system offset: -18000 != -216000. Please, check your config files." I'm from Mexico timezone, how can this be solved?

I have a vendor OData feed URL. It works fine in my Power BI, but fails to retrieve the feed in FME desktop (2020.1.3). Below shows the error. I am using the same credential in both Power BI and FME user authentications.  Python Exception <KeyError>: 'name'A fatal error has occurred. Check the logfile above for detailsFailed to obtain any schemas from reader 'ODATA' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more informationUniversalReader -- readSchema resulted in 0 schema features being returnedReader Parameter(0) = >

Hey guys, I'm not sure if this is the right forum to ask, but I'm at a loss as to what to do here. I'm still quite new to FME and have tried looking for solutions to this problem that I am having.I have read this https://knowledge.safe.com/articles/281/failed-to-connect-using-sql-server-2012-native-cli.html and installed SQL Server Native Client 2012 on my machine, https://www.microsoft.com/en-us/download/details.aspx?id=50402, which wasn't installed before, but I am still running into the same issue.Details from the translation log:2021-06-05 13:14:39|   0.2|  0.2|INFORM|F

I am trying to configure to run a FME workbench as in Schedule task. The batch file itself run fine. But something is happening when its run from Task Schedule. It seem to start a workbech, but it is not executing the workbench. This is the stout output i manage to log.          FME 2022.2.5.0 (20230329 - Build 22795 - WIN64)            FME Database Edition (floating)                Permanent License.           Machine host name is: xxxxxx   Operating System: Microsoft Windows Server 2022 64-bit (Build 20348)         Copyright (c) 1994 - 2022, Safe Software Inc.                Safe Software Inc. When i run the batch file through cmd it start logging "reading" etc after the first I assume is a license check initial License check. I have tried to multiple things alreadySet the "Start in" option to be the directory where the bat file (and workbenches) are located

I have about 500,000 building footprints that are collected to varying degrees of accuracy. I would like to true these footprints so the corners are either 45 or 90 degrees on the polygons as depicted below. Is there a means to do this using FME desktop? The corners are typically within +/- 5 to 10 ground units of being true.  Before:After:

I generated TIN by TINgenerator.I would like to procedure to generate TINrelief of CityGML from the TIN.

Hello everyone, I've recently been doing some work using HTTPCallers to connect and authenticate to an API. The basic flow is that the first HTTPCaller hits the login endpoint. The credentials (username & password) are passed as application/x-www-form-urlencoded values. An XML response is sent which contains a Session ID. This is then passed through to all subsequent HTTPCallers via the header as Cookie - ASessionID=<Our session ID>. This all works very well, but I've been asked if I could move the whole authentication part into a nice secure easy to use Web Connection. I've done similar before, so thought this would be a fairly easy task, but alas, I've hit a bit of a wall when it comes to the Access Token Response. Unfortunately, the login call to this particular API only returns XML and will not return a lovely JSON response for FME to parse and handle. I was under the impression that FME should be able to look at a JSON or an X

My goal is to read a directory of SDE connection files and then list out the database name and all the feature class names, tables, geometry types, etc. associated with each connection file. I've reviewed the articles below and can't figure out how to set the Feature Types to Read parameter since it only shows tables/feature classes from the one Reader as a Resource SDE connection. This isn't an issue if there is only one database but when there are multiple (like what I'm trying to do), it doesn't seem to work. Is this possible or is there another way to get this info? Here are the articles I've been using:https://community.safe.com/s/article/how-to-read-all-feature-classes-from-multiple-esri 

If i run this command in the command prompt (OS) it takes about 15 seconds.M:\\Survey\\'COGO DATA>DIR /S *.DWGIf I run the Directory and File Pathnames Reader with essentially the same parameters it takes 5 hrs! Why can't fme do this any faster?

Hello, I have a REVIT file which contains some cylindrical objects (e.g. pipes) and when I convert the model to cesium, it creates hexagonal shaped pipes instead of cylindrical ones. Is this intentional or can I bypass this behaviour somehow? NOTE: The Revit model is offset according to it's Reference Point. Also, the Data Inspector shows the cylinders correctly where it is an aggregate geometry with with many many IFMEFaces. 

Hi Team, I'm doing the training for FME Professional, using FME Desktop 2022.2 and am now at https://safe.my.trailhead.com/content/safe/modules/turn-coordinates-into-geometry/exercise-turn-coordinates-into-geometry-using-the-vertexcreator-transformer . The last question on this page is about VertexCreator making a line instead of a point geometry. The question gives the impression that creating a line using this transformer is "a feature" from that transformer (and values the answer given accordingly), while the page https://community.safe.com/s/article/Known-Issue-VertexCreator-creates-lines-instead-of-points clearly shows that this is a glitch th

I'm running a workbench on FME Server 2017 and after running through some transformers, the data should be writteninto a database. I'm getting an error ans this message: An error occurred while flushing the cursor for the table/feature class 'xxx.yyy.zzz'. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error [[Microsoft][SQL Server Native Client 11.0][SQL Server]Arithmetic overflow error converting float to data type numeric.] [xxx.yyy.zzz]} Am I right to assume that the error is possibly invoked by an incompatible value? How can I find out which value is causing the error? Is there a possibility to retrieve more information to start the search for the cause of this error?

I have several types of rasters in my folders (ecw, png, tiff..). Not all folders i want to process contain all of the types. In my workspace i created one reader for each type, but when one type is not available, i can not launch the workspace. How can i make a reader optional so it will accept no input data?

This week I looked at this question on the community. "I have a 100 ft line that curves and then turns back into a straight line. How can I use FME to only gather the straight line after the curve only. I basically want to cut out the curve and only grab the line after the curve." This isn't too difficult, but what's interesting is the contrast with last week's question. Last week (click the link to check it out) I too

AttributeManager_10 (AttrSetFactory): Bulk features are not supported because of the setting for 'If Input Attribute is Missing'. Changing this to 'Remove Output Attribute' may improve performanceI see no such setting in attributemanager_10. Where is this setting? Form or Flow I get the same message in both.I do have an sqlexxecutor directly in front of the attributemanager but do not see this exact setting in it. 

Basically here is the need: right now workbenches run (Using FME Desktop 2020.2 and Task Scheduler) and the email addresses are typed out within the Emailer Addressing "To" parameter.We would like things to be more easily updated. For example, if someone is no longer on the team, or if someone is new on the team, we would like to simply update a text file and ALL of our jobs will be updated. I tried reading the text file in, aggregating the addresses into one long string separated with a comma, but I wasn't sure how to assign the value to a User Parameter.(I tried a couple things and failed) Thanks in advance for your help.@danminneyatsaf​ 

Dear FME friends,Welcome to What's Up Wednesday. For reasons of space, this is an extract from the full version of this newsletter, which you can find here on LinkedIn. Streaming to a DatabaseThis week I saw a question about writing an incoming stream of data to a database: "I have a workspace that runs continually in streaming mode (receives from a connector). I want to write to a Spatialite DB while the workspace is still running. I've tried a FeatureWriter, but nothing is written out while the workspace is running. Is this normal behaviour for Workbench?" So there is a great article on the knowledge base about

Hi,FME Server 2022.2.1 Express install.Connecting out via proxy (not authenticated).https is not enabled on tomcat I've published an OAuth2 connection to the FME Server and am trying to Authorize it. Proxy is configured in the FME settings. Client ID and Secret is all set up correctly, including the redirect URI as I can get to the OAuth sign-in page for the app. However when supplying my credentials the token/code is being sent to http://<server><port>/fmeoauth but it just returns an error page "FME OAuth Service FAILED" "Failed to complete". I've also tried to use the ip address of the proxy to no avail. I'm guessing it is a tomcat redirecting issue but can't see any previous info related to modifying the server.xml or OAuth config file in the install folder.

Hello people. I am having an issue that i cannot resolve. I am using the FME for 2 months now. Basically i have a workspace that performs pointOnRaster value extraction, does some calculations based on the result and writes to table/excel file/csv or whatever. Because i want to run this process over 10 000 files i created a workspace runner that loops trough a folder of *.nc files and compares them to one single shapefile containing the points. Regardless of the output format or the different approaches i've tried i am not getting the whole batch of results written in the output. For example i ran the workflow over the first 326 files and the WorkspaceRunner gives me 326 successfully processed entries. But the output file contains only 87 entries. If i run that workspace again it gives me between 67 to 90 entries but nothing close to 326. The log file doesn't indicate any kind of a problem. I've tried to do that with vector files as well, but still i am having the same i

I have a workspace which takes point features and assigns them models essentially this workflow: https://community.safe.com/s/article/creating-and-using-geometry-instances But I'm finding that the performance is quite bad. Is there anything I need to be aware of when using this kind of workflow? The idea of using a geometry definition was supposed to speed things up - heh.  I know with raster datasets there is some little tricks that FME does in the background to speed things up by not reading bits until it needs to. Perhaps there are some transformers I should avoid?

Happy new year, FMEers.Our question-of-the-week was posted just a few hours before I started to review the week. It's about parallel processing and the ShortestPathFinder transformer. Question of the WeekQ) I was hoping to speed up my ShortestPathFinder calculations with "Parallel Processing", but I don't notice any speed improvements. The 2018.1 documentation says "If it is enabled, a process will be launched for each group specified by the Group By parameter." However, the most recent documentation does not mention parallel processing at all. Am I missing something? Asked here by @magnus A) Yes, there are a number of points. The first is what happened to parallel processing in 2019, the second is how to ensure parallel processing works... Parallel Processing in 2019So here's a quick

Keeping getting the following error message - Overdue_Emailer: The file 'C:\\ProgramData\\Safe Software\\FME Server\\repositories\\GIS\\Test send Email/Overdue.xlsx' could not be found. It is required to form the content of the attachment Overdue.xlsx Works space created in workbench and published to server. Works fine if a run from workbench and I can see the .xlsx files that are the attachment in fme server repository but still getting an error

Hi Team,I am using the following xml snippet (thru postman) to get the response and i get the response from postman. it is working good. Now the same thing i need to achieve thru FME. Please help me on what transformer to be used? and how can i pass the parameters?can httpcaller do this? i tried with http caller using GET methos but Response is NULL.  <soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:test="http://www.synchronoss.com/spatialSUITE/test"> <soap:Header xmlns:wsa="http://www.w3.org/2005/08/addressing"> <wsa:Action>HubTraceB7</wsa:Action> <wsa:To>

Hi All, I'm new to fme, I have a LAS/LAZ point cloud data and I want to convert it to cesium 3d tiles. how can i do that using FME 2022.1.3. Please Help. -Thanks Aseem