Skip to main content
  • EN

Recently active posts

405 Posts
gogopotter90
Contributor
gogopotter90Contributor
asked in Data
How to select only the modified tables in sde versions ?

Hello , I'm looking for an efficient way to compare the versioned SDE with the original SDE. I'd like to perform this comparison before running the compression and before posting the jobs in the database.I believe it would be time-consuming to read and compare all tables from both the versioned and original SDE. Is there a method that would allow me to read only the specific tables that have been edited in the versioned SDE?Thanks in advance FME 2021

403
hkingsbury
Celebrity
18 days ago
thomastupuivao
Contributor
thomastupuivaoContributor
asked in Community Q+A
Unsure of the "distance" result from NeigbourFinder

I have a pair of longitude latitude coordinates that I’m trying to measure the distance between in KMIf I cross-reference this “distance” result in ArcGIS Pro, I get approximately 1.44kmThis is also roughly the same result if I use a online calculator;My question, is how does the result 0.01630799258600798 translate to 1.44km? is there something I’m missing??

373
thomastupuivao
Contributor
19 days ago
fmelizard
Contributor
fmelizardContributor
asked in FME Hub Alerts
SolidOrientationRefiner

FME Hub user joeluhlin just uploaded a new transformer to the FME Hub.The SolidOrientationRefiner transformer checks and corrects the orientation of surfaces in solid geometries. It ensures that each face’s normal points in the specified direction (either outward or inward from the solid structure) and that each face polygon’s vertex order follows a clockwise direction, ensuring consistent, valid geometry suitable for 3D modeling and rendering.Would you like to know more? Click here to find out more details!

40
fmelizard
Contributor
19 days ago
ivanwriter
Contributor
ivanwriterContributor
asked in Transformers
When Uploading CSV to Azure BLOB via AzureBlobStorageConnector, Some Records Missing in BLOB

I have an FMW that writes a CSV file and then uploads that CSV to Azure BLOB. The CSV that's created on the server's disk is okay. It has 201 records as expected and opens up just fine. That CSV--after FME uploads it to Azure BLOB via AzureBlobStorageConnector has about 25 less records--seemingly randomly removed. To rule out Azure BLOB itself as the problem, I used Microsoft Azure Storage Explorer to upload the CSV--when I do that, all records are in the CSV file when downloaded back down from Azure. I have experimented w/ a folder upload (upload the file w/ a containing folder) vs. a file upload--no luck w/ that, same result. What really bothers me about this is how it makes no sense. The CSV that gets uploaded should be the CSV that's on disk. It's a file and file-upload process. What could possibly be removing certain lines/records from the file?

141
ivanwriter
Contributor
20 days ago
ivanwriter
Contributor
ivanwriterContributor
asked in Community Q+A
Use Microsoft App Registration in Entra ID to Connect to Azure BLOB - Is that Possible?

Is it possible to use Microsoft app registration in Entra ID to connect to Azure BLOB (non-anonymous, for read+write)? I find information on using a key to connect to BLOB--but my IT policy doesn’t allow keys. I need to be able to connect to BLOB from FME Flow.App registration with Entra ID works w/ connecting to Sharepoint. How about Azure BLOB?

453
ivanwriter
Contributor
20 days ago
ebygomm
Contributor
ebygommContributor
asked in Security
Stopping the current automation automatically - authentication

We currently have a process where an automation is stopped by any upstream failure triggering a workspace which contains a httpcaller with a call to the fme rest api to stop the automation. The request is configured to use $(FME_SERVER_WEB_URL) and an the Automation General Attribute/Key AutomationID to construct the request for the api so in this way it is generic. I’m wondering if there’s any way to use the user running the automation as authentication for the http request?

251
dylan.at.safe
Safer
20 days ago
jokerfme
Contributor
jokerfmeContributor
asked in Data
Problem :Insert new points through FME has no UT-Attribute Data

Hello,I have posted my question in esri community but I did not get answer yet .i hope ,if someone could fix my issue  .I am inserting points into an SDE version using FME, but after creating the point, I'm unable to edit the UT Attribute Data. My company uses UT-Editor (developed from ArcMap), and typically, when I create a new point in UT-Editor, a window automatically appears to fill fields in the UT Attribute Data.some fields are necessary to fill in like Adresse and … However, since I'm inserting the points through FME, when I use the UT Attribute Data symbol to select  the point to try  fill the fields in, the window does not open. How can I resolve this issue? Is there a specific method that would allow each new point to linkage to UT-Attribute Data by FME ? or How could open the UT Attribute Data window in UT-Editor for each new point ,come from FME ?Thanks in advance . FME 2021 

300
jokerfme
Contributor
20 days ago
tb09114
Contributor
tb09114Contributor
asked in Transformers
MeasureGenerator + MeasureExtractor for multipart lines

I have an aggregated line, containing three parts. Every 50 meters I need to have a point/vertex/measure and using the MeasureGenerator in conjunction with the MeasureExtractor works in principle fine.The MeasureGenerator will only work if I ‘Deaggregate’ the parts and then every part gets a list of measures, starting from zero (as defined in the MeasureGenerator).My challenge is, that the next part of the line should actually not start from zero, but should set the first measure with regards to the remainder from the part before, where there might be the last measure at e.g. 250 m, but there is a remaining piece of 2.2 m.These 2.2 m should basically subtracted from the start value when creating measures for the next part.Is there a way to achieve that?

583
tb09114
Contributor
20 days ago
danielleatsafe
Safer
danielleatsafeSafer
posted in User Spotlights
FME Community User Spotlight: Joep Kuijvenhoven

Welcome to our second FME Community User Spotlight! Every month, we’ll be spotlighting a user in the community whose active participation and helpful contributions have been invaluable to the community. We’re excited to highlight their experiences and insights!User Spotlight: Joep Kuijvenhoven @joepk What’s your name?Joep KuijvenhovenWhat company do you currently work for? I work for Avineon-Tensing, a GIS consultancy based in Utrecht, the Netherlands.What’s your current job role and title? GIS ConsultantTell us more about what you do and how you use FME? As a GIS consultant, the purpose of my FME usage can vary. I am currently using FME to improve the data quality of two databases that describe the same road network. A large part of this workflow is automated, but another part involves preparing and processing input from an editorial team.Why did you join the FME Community?I grew up using many online forums, and I really enjoy the culture of online communities. This is what initially

902
rob_braggaar
Contributor
20 days ago
jeroen_hack
Contributor
jeroen_hackContributor
asked in Data
Saving Excel with Template to Sharepoint Sync Error

Hello fellow FME enthusiasts!We've run into in issue with writing Excel files to our sharepoint. We have a workspace that output's an Excel file.We've set it up to use a template to make sure it has the same easily readable layout for our users. We store the Excel file on our sharepoint. Our sharepoint folders are available locally on the PC through One Drive. So we store them to a location like: C:\Users\[User Name]\[Sharepoint name]\[Folder name]The issue we have is that every time we do this with the Template setting active in the Excel writer we get a sync error saying there is one file in out local folder and another one online. It's easy enough to fix this manually (One Drive gives us this option). But it is a manual action. If we write to the same location without the template setting in the Excel writer all works fine.We are working with FME version 2024.0.3.0 (build 24220)Has anyone experienced this before? And found a way to fix this?

151
jobvdnoort
Contributor
20 days ago
moustik
Contributor
moustikContributor
asked in Transformers
SQLExecutor in FME2024.1 doesn't show Geometry of PostGIS raster, in contrary with FME2023.1

Hello,I am currently working with some database PostGIS rasters and wanted to import some into FME 2024.1, using a filter to only select 2 out of 11030.To do so, I tried both a SQL Executor and a FeatureReader (as both enables PostGIS raster reading).The SQL Executor filters the rasters correctly but doesn’t create the geometry and returns an error in the log file.The FeatureReader loads the 11030 rasters without filtering, suggesting a problem with the “WHERE clause”.I tried the same thing using FME 2023.1 and the SQL Executor is working under this version. I am wondering if there is a bug in the FME 2024.1 version.The problem was the same for the Feature Reader.A colleague said that the Feature Reader outputs everything as well in previous versions of FME (2022.2 and 2021.1).Do you know when the FME 2024.1 bug will be corrected?We are linking our work with ArcPro and we know we will have to use FME 2024.I am enclosing a share folder with the different logs (as txt) and the 2 workbenc

472
moustik
Contributor
20 days ago
ed-progres
Contributor
ed-progresContributor
asked in Community Q+A
How to replicate this? (convert line to polygon and inflate it until it touches the adjacent polygon )

Hi FME ninjas.I'm trying to replicate this end result:These are city streets, they started as line objects and have been converted into polygons.I'm guessing the workflow is as follows:- Convert street lines with a buffer into a polygon- Inflate those polygons until they touch an adjacent polygon- ???- Proft! 😀But I don't have a clue how to do this or what transformers I need.Who can help me out creating this workflow?​​​​​​​Thanks.   

475
ed-progres
Contributor
20 days ago
lifalin2016
Contributor
lifalin2016Contributor
asked in Authoring
Bug in FME ? - "SQL to run after write" triggered even after a Terminator is activated

I would assume (dangerous in this case), that a Terminator would halt processing completely.I have a workspace, that imports from a WFS. It errs because the provider made a breaking change by removing a column in the read dataset. This issues a rejected feature, which triggers a Terminator.But even then, the postprocess action of my SQL writer is triggered.Why does this happen ?If a terminator is called, it indicates that the workspace has failed. And then triggering postprocessing is a dangerous action, as this usually requires the writing to have been completed without errors.Is this not a bug ?Using FME 2022.2.6 on FME Server/Flow.Cheers

384
nielsgerrits
VIP
20 days ago
arnold_bijlsma
Enthusiast
arnold_bijlsmaEnthusiast
asked in Community Q+A
Transformer to check if on Form or Flow?

Hopefully easy question: what is the easiest way for me to check if a workbench is running on FME Form or on FME Flow?On Form, when testing, I want to read the source data from my C-drive. But when on Flow, I want to read the official data uploaded on the server.

656
nielsgerrits
VIP
20 days ago
geosander
geosander
asked in Authoring
FME Server: aborted job keeps running on engine

Whenever we cancel a running job (in our case: using the REST API), the job is cancelled successfully on the FME Server core (the job reports itself as aborted when we fetch the status), but the engine on which the job is running (on a different physical machine than the Server core) just keeps on going: the job simply runs until the end of the translation. This is not what I expected, but since I don't see any errors in the server logs e.g. about communication issues with the engine, I started to wonder.Is this intended behaviour? If so, are there ways to actually stop the job process on the engine as well? If not, any suggestions on how to fix this?

7918
zhangjun
Participant
20 days ago
lifalin2016
Contributor
lifalin2016Contributor
asked in Authoring
Why can't ones own reply to a topic be marked as best answer ?

In the olden days, you could mark your own reply as best answer, if you figured it out yourself.This is no longer possible.Why ?

424
lifalin2016
Contributor
20 days ago
ecx
Contributor
ecxContributor
asked in Transformers
How can I use the values from two fields to match against another dataset?

Hello,How can I use the values from two fields to match against another dataset? image 1, filtered portI have a test filter, which filters out all items that contain ‘FeatureWriter’ in the transformer_parameter_value field, I now want to take the items from the unfiltered port,Image 2, Unfiltered port.and match these against the initiator_workspaceId AND transfomer_id items from the filtered port (image 1). I do not want to do a row by row comparison, I want to match all items that exist in the filtered output (image 1) against all items in the unfiltered port (image 2). If they have a matching combination of both the initiator_workspaceId AND transfomer_id.I attempted to use a featureJoiner to achieve this: image 3. failed attempt but as can be seen, there should be 3 items with transformer_id 81, but unfortunately some of the items were merged, which I do not want. I want all items from the filtered list and unfiltered list to be in the output, without any sort of merging.  How can t

261
ecx
Contributor
21 days ago
hayley.lam
Contributor
hayley.lamContributor
asked in Data
Running a Sharepoint Excel in my workbench results in OSError: [WinError 10093] Either the application has not called WSAStartup, or WSAStartup failed

Hi there,  I have connected to a Sharepoint Excel file in my workbench. I am able to read the rows and values when inspecting the Excel.  However, when I connect the Sharepoint Excel reader into any transformer, I get the error below: Exception ignored in: <finalize object at 0x13bf76a0; dead>Traceback (most recent call last):  File "weakref.py", line 590, in __call__  File "C:\Program Files\FME\python\urllib3\connectionpool.py", line 1135, in _close_pool_connections    conn.close()  File "http\client.py", line 1020, in close  File "socket.py", line 505, in close  File "ssl.py", line 1311, in _real_close  File "socket.py", line 499, in _real_closeOSError: [WinError 10093] Either the application has not called WSAStartup, or WSAStartup failedException ignored in: <finalize object at 0x13bf7cc0; dead>Traceback (most recent call last):  File "weakref.py", line 590, in __call__  File "C:\Program Files\FME\python\urllib3\connectionpool.py", line 1135, in _close_pool_connections 

542
hayley.lam
Contributor
21 days ago
oliviergayte
Contributor
oliviergayteContributor
IFC CertificationArchived

FME is not recognised enough in the BIM world.It would be interesting to have it certified as an IFC compliant application for IFC2x3 and IFC4 specifications.https://www.buildingsmart.org/compliance/software-certification/

8
201
LizAtSafe
Safer
21 days ago
jpaixao_cwl
Contributor
jpaixao_cwlContributor
asked in Transformers
FME 2024 FeatureReader - Constraint - Feature Types to Read - File Geodb - ALL or NONE

Build 24627Hello, I am having issues reading a single Feature Type while using the Constraints in the FeatureReader transformer with both the File Geodb and the File Geodb API formats. Each of the Feature Types are visible when clicking on the ellipses; however, after you select one or multiples, the transformer updates and the only outputs are Schema, Generic, and Initiator.There is a workaround, to not select a Feature Type to Read, however, this will then read all of the feature classes in the File Geodatabase.Thanks,Justin

161
jpaixao_cwl
Contributor
21 days ago
pat_uow
Contributor
pat_uowContributor
asked in Transformers
Create 3D voxel or polygon from rasters

Hi FMErs,I have 3 rasters of equal extents and cell size (clipped to the same 2D polygon)a) representing the floor elevation of a sub-surface stratab) representing the thickness of the same sub-surface stratac) representing the roof elevation of he same sub-surface strataLooking for tips on the best / most efficient way to create a 3D polygon in FME similar to ESRI extrude between, and assuming other strata sections are available in the same raster form , iterate through each strata section to create a 3D subsurface model.Thanks in advance

1648
LizAtSafe
Safer
21 days ago
markcoopersdc
Contributor
markcoopersdcContributor
asked in Automation
Log file not created for jobs unless admin account is logged in to the web interface

Hi We have recenly started using FME Flow more. When someone runs a flow app no log file is created. However, if the admin user logs onto the web interface and they run the app again (on the same or different pc), a log file is created. Is this expected behaviour? If not, does anyone know how to get round this? Thanks  

222
markcoopersdc
Contributor
21 days ago
emerson_styles
Contributor
emerson_stylesContributor
asked in Transformers
ShortestPathFinder processing time

I have a workspace that is calculating the shortest path across a network for a dataset of start and end points (joined as lines). The length of time it is taking to process the data through the ShortestPathFinder transformer is a lot and it sits as follows for hours on end:  Is there a way to speed this up at all? I know I’m trying to process a large amount of data which could be the primary reason but I am curious if there are ways to perfect this process to enable it to complete much faster.

593
mark2atsafe
Safer
21 days ago
todd_davis
Supporter
todd_davisSupporter
More FMERest api calls documentedIn Development

FME Server has a good range of Rest api calls but they aren't all documented. For instance, named connections are avaliable by fmerest/v3/namedconnections/webservices, version control push by /fmerest/v3/versioncontrol/remote/push. It would be great if more of these calls could be documented

49
6810
LizAtSafe
Safer
21 days ago
loicgueninrande
Contributor
loicgueninrandeContributor
asked in Data
Geoparquet Reader on FME Form 2024

Hi @Safe !I have a probleme with Geoparquet reader on FME Form 2024. It does’t work with the file in attachment but work fine with Apache parquet on FME Form 2023. The error is :Thanks for your help.Loïc

283
AliAtSafe
Safer
21 days ago

Badge winners

Show all badges
30,149
Posts
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.