General

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 took a linear feature like this, created a list of its vertices, and processed those numbers directly. This week I could do the same, but instead I'm going with a spatial approach. In short, I'm going to divide the line into two-part segments, calculate each segment's angle (bearing or azimuth), and test how much each segment differs from the previous one. Preparing the DataThe first step is to prepare our data by chopping it into two-point lines. The alternative is to just extract the coordinates and work on them (as I did last week) but this time it's just that bit easier 

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 how to write to a database during a streaming mode. Writing is a little tricky because, generally, writers don't do anything until they have all the incoming data available, yet that's not going to work in a continuous stream. The article explains that you have to set Bulk Insert parameters, including the Features Per Transaction:  Here, the writer wa

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. the FME OAuth log is detailing some nio error: Sun-19-Feb-2023 04:28:08.734 AM  INFORM  http-nio-0.0.0.0-80-exec-2  417005 : Retrieving connection with nonce: <removed>Sun-19

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 issu

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 refresher on parallel processing in 2019. Basically it was removed from individual transformers and retained only in custom transformers. I wrote a blog article to explain

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>http://gisstrm-po-c2p.cable.comcast.com/trainingSTORM/spatialSUITE/v7_1_0/ws-i/HubTraceB7</wsa:To> </soap:Header> <soap:Body> <test:TestRequest> <test:Action>echo</test:Action> <test:Parameter>CB10995066|Incoming|CB10995070_1</test:Parameter> </test:TestRequest> </soap:Body> </soap:E

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

I have multiple .dwg files I am trying to convert to feature classes. However I would like to nest the resulting feature classes inside a feature dataset that has the same name as the input .dwg file. I have tried to change the Feature Dataset name to @Value(fme_basename) under Table Creation Parameters after previously exposing fme_basename:But running the workspace with the above displays this error in the logs:"Esri Geodatabase Writer: Creating feature dataset '@Value_fme_basename_'An error occurred while attempting to create a feature dataset. The error number from ArcObjects is: '-2147220654'. The error message from ArcObjects is: {The table name is invalid.}GEODATABASE_FILE writer: A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for details" When I remove @Value(fme_basename) and just write a regular string, it works. Thanks!

Hi I am trying to set up connection to an external SQL database (the supplier describes it as an ODBC connection). I am using the SQL non spatial reader. However, we have been told it needs to use SSL to connect. Is there an option in FME to use SSL for the connection please?

Greetings, I used a setting that limits record input to 1,000 records before.I cannot find the setting to limit FME to read the first 1,000 records?? This is useful when testing a FME workbench that has large number of records. If anyone can point out the setting, it would be appreciated. ThanksClive

I have a workspace published to FME Server 2022.1.1 (build 22623) in which I want to give the user the option to Truncate Existing or Use Existing via a user parameter. When you create the parameter in the ArcSDE writer feature type, the name of the parameter defaults to fme_table_handling. This works fine when running from FME Desktop 2022.1.1 (build 22623). When running from FME Server, the parameter choice is not honored. It simply uses the choice of the parameter that was made in Desktop before the upload. However, when you change the name of the parameter to something else like 'table_action', it works as intended on FME Server.  Here is a screenshot from FME Server log file, where the parameter name is left as the default value (fme_table_handling). As you can see, the parameter is preceded by only one dash, where it should be two dashes. And also, 'fme-' has been dropped off. I think this is where the issue is occurring.

Feature Type: `JobHistoryReader_LoopHere'Attribute(32 bit integer): `Loop to JobHistoryReader_LoopHere1664443291 Input Splitter.BranchingFactory.Count' has value `1'Attribute(string: UTF-8) : `_min_job_age' has value `20220928000000'Attribute(64 bit integer): `_offset' has value `0'Attribute(string: UTF-8) : `fme_feature_type' has value `Creator'Attribute(string: UTF-8) : `fme_geometry' has value `fme_undefined'Attribute(string: UTF-8) : `fme_type' has value `fme_no_geom'Coordinate System: `'Geometry Type: IFMENullCoordinate Dimension: 2===========================================================================Loop to JobHistoryReader_LoopHere1664443291 Input Splitter (BranchingFactory): Transformer/Factory JobHistoryReader_HTTPCaller is blocking and cannot be used in a loop, but was found between 'Loop to JobHistoryReader_LoopHere1664443291 Input Splitter' and 'JobHistoryReader_LoopHere1664443291 Input Splitter'An

Hello there we have Millions of JPG Photo we want to geotag all the metadata is located in an excel file is there a way to do this via FMEThanks 

Why i am Getiing this warning and error when i try to run workspace on desktop and on server 

Hell all, I am able to read my previously created shp file in Fanout mode, but I get this warnings:Shapefile Reader: Input dataset XXXshp' contains a Record Index file that is not a sufficient length to be useful and will be ignored. Features can still be read but performance may be impacted. After reading this shp file I am using AreOnAreaOverlayer and fme stacked there with warnings. Number of Inner Boundaries: 1 -------------------------------------- Inner Boundary Number: 0 Geometry Type: IFMEPolygon Boundary: Geometry Type: IFMELine Number of Coordinates: 10 -- Coordinate Dimension: 2===============================================================ccoordinates ============AreaOnAreaOverlayer (OverlayFactory): Overlaying requires a tolerance of at least 2.5078612099758616e-13 for these features, and the input tolerance is 0. Setting the tolerance to 2.5078612099758616e-13When I changed Tolerance from None into Automatic, another warning appears:@Geohash: The feature is either too

We recently upgraded both Form and Flow to 2023.1 after we ran some workspace from form and flow we encountered that they were failing on the writer part with the following error message: "Too many values to bind. Found '127' when expecting a max of '100' ".It seems that FME is not able to write the data to an Oracle Spatial DB if the amount of attributes is greater than 100. When we reduce the amount of attributes to lower then 100 there is no such message and the writing is succesful. The problem is that I cannot reduce the amount of columns below 100 (the DB design is debatable I know ;-) ). Is this supposed to work like this or is it a bug in the writer? 

Hallo. i am trying to create connection between FME desktop and azure adi have client id an client secret and tennant id but I am not sure ,what is [OAUTH Scope] ?Where should I get it from ?i have written https://Storage.azure.com instead of Oauth scope because it is the resource.then i clicked test but It shows me a window to log in with Microsoft online .could someone advice me ,what should I do ? thanks is in advance fme 2021

I'm attempting to read in address points from a shapefile and filter them by the "County" attribute field. I'm using the AttributeFilter and trying to import all the values to route the points to their respective ports. When I try to import the values in the transformer, the only value showing up is that of the first feature. Not all of them. When I attach a second attribute filter, all the values show up. I guess I can go about the workflow doing it this way, but it seems like all the values should be showing up in the first attribute filter. Any suggestions?

I want to write to an existing FGDB and I'm getting "Esri Geodatabase Writer: XXX attribute value(s) were truncated" (in my case: XXX = 500+) in my translation log. Concerning the attribute values that should get written and given data types, everything seems to be fine. What could be a way to determine which attribute values are truncated and why? I can't find further information on this.

Hello,I have several featureclasses to convert from EPSG:4326 TO EPSG:3847. Almost all of the input featureclasses got reprojected and got saved as a new output featureclass . But, for few, I receive the below error ,An error occurred while attempting to add a shape to a feature buffer. The error number from ArcObjects is: '-2147220936'. The error message from ArcObjects is: {The coordinates or measures are out of bounds.} I'm not sure what is the reason and how to resolve it. When tried using Arcgis pro it worked well but not in fme desktop. I used ESRI reprojector for this operation and even I tried using other reprojection transformers too and I get the same issue. Can any one provide some guidance or solution to this problem? Do I need to change any writer parameters ? Thanks.

I am having issues running workspaces on FME Server that contain Python 3 (using Esri GIS Python module). This is the error I am getting: The workspace has Python Compatibility set to 'Esri ArcGIS Python 3.6+', which requires an appropriate version of ArcGIS Pro or ArcGIS Server. If ArcGIS is not required by this workspace, then update Python Compatibility to a non-Esri-ArcGIS Python. Otherwise, please install the required ArcGIS product, or if ArcGIS Desktop already installed, update Python Compatibility to 'Esri ArcGIS Python 2.7'. To update this setting, go to: Navigator -> Workspace Parameters -> Scripting -> Python Compatibility Environment Details: FME Desktop/Server 2021.2.5.0, ArcGIS Pro 2.8 and ArcMap 10.8.1 Per the compatibility page (https://community.safe.com/s/article/notes-on-fme-and-esri-versions-and-compatibility) ArcGIS Pro 2.8 is compatible with the version of FME I am using. In my workspace in FME Desktop, I set Python Compatibility to Esri A