General

I have a point shp file that has an attribute with a number and I need to do a point on area overlayer, but the count in the area needs to be a sum of the attribute in the point file. I am stuck on how to do this! Hope this makes sense!

I'm trying to convert 3D models to GLTF, however, the output models tend to be a little do dark in the application we're using. I'm trying to make them brighter by setting the SpecularColor factor to white. I also want to set the shininess, but only if there is no shininess set. In addition I want to also apply a fallback appearance to the surfaces which have no appearance. The conversion needs to work for all inputs and ideally be nice and fast. I've been playing around with the SharedItem tools and have gotten very close to what I want, however, there are some edge cases where my process doesn't work.It seems like it should be really easy but I just can't get it to work. Has anyone had luck doing this?

I have Lines (13,000 Street Centerlines) and Points (7,000 Intersections). I want to do a spatial join of the Lines and Points so that the attributes of each point is merged with the 1 to 4 lines that intersect each point.  I just started using FME, after completing the training last month. What Transformer(s) would you recommend I use for this process? My goal is to have the lines each have the CROSS_ST_NAMES field which is in the points layer be joined to each line that intersects a point. In the points layer, the CROSS_ST_NAMES field has no <null> values, when they are merged with the lines there must be no <null> values. Below is a screenshot of what I am working with. Each line is a street centerline, each point is an intersection.  

I have recently installed FME Desktop 2022.0 (Database edition – Build 22337 – WIN64) and want to migrate old workspaces to this latest version. I have a workspace that was written and runs in FME Desktop 2019.0 (Database edition). It reads in about 120,000 records via SQL Creator (non-spatial Microsoft SQL data format), does some transformations, and writes to a CSV file. It works perfectly in FME Desktop 2019.0. However, when I open and run the same workspace in FME Desktop 2022.0 it is not working correctly. I have tried this on Windows 10 Enterprise and Windows Server 2012 R2. I have tried with Feature Cache on and off. I have tried running as a batch process. I have tried running the workspace in 2022.0 unchanged (as a 2019.0 workspace). I have tried running the workspace in 2022.0 unchanged (as a 2022.0 workspace). I have tried running in 2022.0 with transformers upgraded to the latest 2022.0 versions. In all cases after every 10,000 records, several records are corrupted on the

Hi,I have a workspace where I use the oracle database connections as a variable. This works fine. When a runs the workspace a published parameter determines which connection is used. But when I publish this on fme server. I get an authorisation failure: FME Server error: `Unauthorized request by user due to lack of proper permissions for connection: **@**. Please see: http://fme.ly/zn8' Connections in fme server are available as in the variable.

Hi new at this...I am trying to separate some data from a CSV separated by a comma and then merge it back into one feature, I can't work out how to merge the 4 results I get from each entry.

I can create an AWS RDS Postgres Reader and Writer on FME Desktop and successfully run the workspace. However after publishing the workspace FME Server it fails. It looks like Readers/Writers to AWS RDS Postgres are not using system Proxy Settings. Completed steps in manually setting the proxy:port using fme.exe in the FME Documentation.  Thanks 

Hi everyone, I'm using FME Desktop 2022.1 and I would like to use the LDAP reader with an encrypted connection (LDAPS, Port 636).  When testing the stored connection I get the following error:javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested targetI know how to get the root and the ldap server certificate. But where do I have to store them within the FME Desktop installation? Kind regards,Peter

I would like to calculate the average of pixels for each polygon, how can I do that? I have several raster fragments and several polygons.  Thanks

Hello FME friends,Welcome to the What's Up Wednesday newsletter for October 26th, 2022.  For reasons of space, this is an extract from the full version of this newsletter, which you can find here on LinkedIn. Spatial "For Dummies"Did you know that Safe Software helped to produce an e-book on this subject? The actual title is "Spatial Data for the Enterprise for Dummies", but that was just a bit long to fit in a heading.  The book is available for free download from our website. Obviously, it's not in-depth technical content or training. Instead, it's a very good overview of the sort of work that we're all doing with FME. For existing FME users, I think it's a great book to share, for example, with the manager who doesn't quite get what you do, or what the potential is. Like, "You remember what I was saying about Real Time Tracking, and Digital Twins? This book shows how useful they would be." And they might not even notice you'v

Block legacy authentication with Azure AD with Conditional Access How will this influence the FME Server Azure AD integration? And what can be done to fix it? https://learn.microsoft.com/en-us/azure/active-directory/conditional-access/block-legacy-authentication

Have a FeatureWriter to insert data into a SQL table. It ran successfully without any error. However, no data shown in the destination database table. Reviewed the log and it says Features not written (see below):Below is the Feature Writer: Both FME Desktop and Server are the same 2021 version. FeatureWriter insert works well in my other workspace. Not sure why it didn't work here.

I need to extract the Values from Logfiles and create an HTML report with separate columnsfrom this code I need the date and time ... stats (Table Names), inform (Transation Success and durationI m using fme desktop transformerFMEServerJobSubmitterFMEServerLogFileRetriever 2022-10-27 11:52:48|  1.7| 0.0|STATS |Past Track                                                                  12022-10-27 11:52:48|  1.7| 0.0|STATS |Past Wind Radii                                                             12022-10-27 11:52:48|  1.7| 0.0|STATS |Storm Surge Communication Points                                          3082022-10-27 11:52:48|  1.7| 0.0|STATS |==============================================================================2022-10-27 11:52:48|  1.7| 0.0|STATS |Total Features Written                                                    8782022-10-27 11:52:48|  1.7| 0.0|STATS |=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-2022-10-27 11:52:48|  1.7| 0.0|INF

I have reviewed the recommended Virtual Memory settings in this post. But, my server is hosted in Azure. It has 32GB of physical memory, 4 cores, and has a dedicated 149GB drive for the pagefile that is managed by Azure. Still getting this error when reading in 5M well records from Enverus data to our SQL Server Enterprise Geodatabase (SDE). The FME version is the lates - 2022.1.3. Just upgraded from 2020.2.2. 2020.2.2 did not have this issue.  To clarify - I have NOT made the suggested settings as Azure manages the pagefile and it is substantial.

Hi All, I'm looking for the latest, or what you have found, the best workbench/template for generating (as much is possible) FGDC compliant metadata. I'll be using a template xml document. Any and all recommendations are welcome! Thanks, Jerry

Hey there,following my issue with clothoids I now have a problem with writing geometry properly into LandXML.While the geometry is proper within FME Desktop, it gets worse as soon as it's written to LandXML.Any ideas?A sample workspace is attached. Cheers,MariaKa

My parameter says this.$(FME_MF_DIR)\\CF\\PNM.sdeBut I want it to say this.C:\\Users\\USERNAME\\Desktop\\CF\\PNM.sde Can this be done? This is a problem because it breaks the connection when the workbench is put in different folder.

Hi, I would like to crop image according to shapefile boundaries, similar to arcgis extract by mask. Currently I have this result after clipper transformer, but is bad for me.   Thank´s 

I'm currently working on a high-voltage network, which relies on pressurized oil being forced into cables to insulate them, through a pressure gauge. The pressure gauge (node) is connected to an oil line (line), the other side of which is connected to a connector (node), which is then connected to a cable (line). I'm looking to add attributes of the connector and the cable to the pressure gauge, but can't seem to figure out how to get it to work. Main issue with SpatialRelator seems to be that from 1 pressure gauge there are 3 oil lines, going to 3 connectors, going to 3 cables, over which a single connection runs in 3 phases, where the connection has no geometry.

With the list of transformers growing ,I would love a list of all available transformers - ordered by the date they were created/implemented.I'm not interested in the modification/upgraded date, and it is not related to a specific task or workspace. Just the entire transformer package :) Is that possible?

Hello I want to give the location and Id of the points that follow the path of the line to simulate asset movement I am soring Y descending and X ascending But it's not working  Any suggestion please 

I have an HTTPCaller that fetches all the source rows in one call however the downstream transformers make the caller run again for each row. How to tell the transformers they already have all the data and to loop only within? 

Screenshots attached when I had the issue initially (FME1) and the other after login into ArcPro - Error is now gone (FME2)

Hi, I am just exploring some of the standard dashboard features of FME Server 2021.2.3.0 (20220131 - Build 21812 - WIN64), I have got a couple working without any issues, and now I am unable to get the "DailyAverageQueuedTime.fmw" workspace to run, each time I get a warning: Path Reader: No files found in folder 'C:\ProgramData\Safe Software\FME Server\resources\dashboards\temp' using glob pattern '*.csv' with glob filter 'FILE'. No features will be readI have attached the full log file, has anyone seen this before, or do you know how to resolve? I am not sure what I should be looking for. Cheers

I am trying to dynamically read all the gdb's in a folder then write all features out into an SDE with the same schema. Unfortnetly it is giving me errors when running it. I am reading both the schema and the features but the SDE writer does not like it.  Also, if I am sucsessful, I assume it will count the 10 schema features are actual features, but they arn't really features at all. Is there any way to remove these from the output while still keeping the schema?