FME Form

Hi allFirst time poster, long time reader of all the great advice on this forum.using FME 2021.2.6 (work limitation)I am currently having issues regrinding my CSAR (Raster and Pointcloud) files while keeping the lowest value in its original XY position in the regirded area. Example of regirded squares with the smallest values being picked.Note: the gridded squares are just a visual example, I have potential looked at applying a Buffer to the soundings based on the (SCALE) area they fall into but have had no success yet. I also have an Area file (Shapefile1) that contains the regrid values (SCALE) I would like the effected CSAR file to be regirded too.Example: Of the desired regrid areas (Shapefile1) overlaying the CSAR file. I really have 2 issues currently affecting me that I need help with. 1)      I need to be able to regrid my CSAR files (RASTER or POINTCLOUD) by keeping the lowest values in the regrided area.2)      I have a Area file (Shapefile1) that contains the regrid values I

I have a summary query with GROUP BY, HAVING, and ORDER BY clauses and I would like to send an email with the results from this query. My workspace can send html results of a query of listing all the records but that is not the summary I’m looking for. The Aggregator transformer doesn’t seem to have what I’m looking for either. Is there a way to send the result of this query shown below? My data is in SQL Server.  SELECT caseID 'ID', count(*) 'Count'  FROM my_table  group by caseID  having count(*) > 1  order by count(*) desc 

Hello, i need some help here.I recently had my workbenches stop working. I am pushing updated into to referenced feature services in arcgis portal. I have re-created every reader, wriiter and parameter but cant get the same process to work again.I have made new workbenchs and new connection where i have just Readers and Writers (No Transformer) and i cant FME to push changes to featuer services.The error’s i am get is :ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server was '500' and the message was: 'Unable to complete operation.'. Details: 'No edits ('adds', 'updates', 'deletes', 'attachment edits', or 'asset maps edits') were specified.'BADNEWS: ARCGISPORTALFEATURES writer:Or“Could not find a layer/table matching the feature type”It Seem to JUST be a FME issues as i can access the Rest end point and use post to make edits, using fme i can update hosted serivces. It isnt a permssions issues and to my knowledge nothing has change on th

Hello, I am struggling with conversion of several thousands of XML files (same scheme, but different attributes) in to single Excel/CSVThe tool works fine for single XML but not for multiple at once,The XML has nested levels so I am using xml_Id and xml_parent_id to navigate thru and join tohether with featurMerger tool.This is on the other hand the reason why I am struggling with the batch processing - since when  multiple files are processed at once, the xml_parent_id is the same among files and the so data are ovewriting themself, or they are rejected in the feature merge with multi-reference error. Don’t you know if there os a way how to proceed? To run one by one, for example with Loop in ArcGIS works but it’s soooo slow. Thank you!  

Hi everyone,I am currently comparing lines in database A and database B, and I want to categorize them based on distance from each other:If line A < 10cm line B → class 1If line A 10 - 30cm line B → class 2If line A < 30cm line B → class 3I thought I'd do this using the Clipper transformer: if part of line A is within 10cm of line B, and another part of line A is 12cm from line B, I want line A to be split. See my workflow below:I have my Clippers grouped by ‘type’ and ‘level’, so [railroads on level 1] are compared to [railroads on level 1] and [road lines on level 2] are compared to [road lines on level 2]. I have Overlapping Clippers set to ‘Clip Interim Results’ and I am generating a list of IDs from line B on line A. This is the situation im currently facing:Database A in red, database B in black and a 10cm buffer around database B in grey. The darker grey area is where the two database B buffers overlap.In the situation above I want to compare ID_A = 1 to ID_B = 1, but ID_B

As title says, unable to convert lat/long to MGRS when latitude is -80.01 through -81. e.g., x= ‘100’, y= ’-80.1’ . I’m sure this isn’t the exact range but am able to reproduce the error.Was wondering if someone had additional information on how transformer calculated polar zones and, if there is preprocessing required for points located in south and north polar regions?Additionally, lmk as comment if you’re able to reproduce error in other FME versionFME Form 2023.2 

Hello, I’m trying to migrate data from a SQL Server 2016 spatial to a ArcSDE on SQL Server 2022. Using ArcGIS Pro 3.2 on same machine. I am using FeatureReader with schema and featureWriter with dynamic writer.   I don’t get any errors but I get thousands of this warning:GEODATABASE_SDE Writer: Renamed user attribute 'attribute{109}.name' to 'attribute_109__name' based on format constraints for invalid characters, length, and caseIf this waring occure the feature with this schema will not be written to the database, so it should yield an error not warning. yield waring on FME version 2023.2yields none-traceable error in version 2024.1Anyway I can’t figure out what it means. Any clues?  

I am transforming an IFC file to CityGML to upload the CityGML model to the 3DCityDB. I used the workspace published by Liz (https://support.safe.com/hc/en-us/articles/25407718003341-BIM-to-GIS-Intermediate-IFC-LOD-300-to-LOD-4-CityGML). The CityGML file created looks fine in the FME inspector. However, when I try to import the CityGML into the database, I get a lot of errors saying, “Failed to resolve XLink reference”. I was doing some research, and it seems the problem is that 3DCityDB does not support a gml:MultiGeometry with different dimensions (This is what they mention in the GitHub: In general, a gml:MultiGeometry is a collection of geometries that are allowed to have mixed dimensions: points (0D), curves (1D), surfaces (2D) and solids (3D). The 3DCityDB can handle geometries of different dimensions and collections of geometries having the same dimension. But collections containing geometries of different dimensions are not supported.). Is there a way I can modify the FME works

Hello, Here is what I need to do: I have a workspace that includes the Emailer Transformer. When a file is placed in a folder and email is sent to the recipients notifying them that there is a file in the folder. The workspace works great. But, if one of the email recipients changes or needs to be removed for whatever reason, I am contacted and must go into the Emailer Transformer and manually delete the recipient. I would like to allow a user to open a spreadsheet of the email addresses and alter/delete them there rather than having to contact me. I need some help in getting started: If I have a list of email addresses in a spreadsheet, how do I include it or reference it with the Emailer Transformer? For example, if an email address is deleted or added to the spreadsheet, when the Emailer is going to send an email it will send the email to the list of recipients in the spreadsheet. Looking for some ideas on what transformer(s) I would need to use before the Emailer.

I have installed FME Server on a machine called "fmeserver-dev.com" and also used this as the hostname.Later we switched everything to SSL (including the Websockets) and the external web host name to "(https://)fmeserver-prod.com".  Now, everything (Web UI, Services, Websockets...) is working fine, except the Topic Monitoring!  Using the Developer Tools of a web browser, I have identified that there is still a parameter 'webSocketServerName' set to the old hostname "fmeserver-dev.com". This must be causing the issue as the SSL certificate is not configured for that domain. How can I fix this?

Hi there,Can you please help me with this? Every time when a new report came in, I’d have to manually open the “FreatureReader” dialogbox and hit “Ok” (to close) so that the new attributes that are added in new report at the new folder location are emerged. Otherwise, it would just read previous attributes from the new report (in below case, up to the end of June, not the July columns). I’m just trying read an MS Access file that is stored dynamically in different folder each month.   

I am attempting to add a Geocoder transformer to spatialize address data using a published geocoding service on ArcGIS Server. When running the address data to the transformer, it rejects every feature with “Code 403: Access to this resource is not allowed”. The REST URL and Portal credentials are all correct and I am able to get to the service in a browser, as well as access and use the Locator in ArcGIS Pro to geocode addresses. With that being said, I don’t know why access to the resource would be disabled in FME but nothing else. Any insight or suggestions would be appreciated, thank you!

Hi!I would like to create a workbench with a lot of flexibility for the users. I use a FeatureReader with a spatial filter. I create a user parameter to chose the system of coordinates. So I would like to use it on the Featurereader but there are no option. Do you know a way to indicate to this transformer the system of coordinates? I suppose the spatial filter will work if the datas are in the same system but I would prefered to force it.Thanks !

I need to warp some data, so I'm using the RubberSheeter. This works fine except that in certain parts of the data I also need to create a gap. In broad terms the situation is as shown here: I need to cut along a line (the red line) and then use the control vectors (green) to pull things apart, leaving an empty void in the middle. What I've done is use a Bufferer / Clipper to remove a little bit from the original feature, along the cut line. Then I've added a bunch of control vectors, making sure they don't start exactly on the cut line but just a little bit on either side. However, FME is still showing data inside the gap and I really don't want to have to manually edit that. Does anybody have a suggestion?

I have had success in connecting to my corporate Sharepoint with the SharePointOnlineConnector using the web connection as set up in this HowTo: How to create a Sharepoint Web Connection (safe.com). Now I want to connect to another Tenant for which I have been granted access, but the connector only presents me with the Safe Template version for my web connection - even though I have set up and succesfully tested a new connection with a new name. I tried testing on a new machine, with no previous connections, and imported the new connection via xml then tried to add the web connection from within the transformer - same issue - the dropdown list doesn't show me the newly created connection (no matter what I call it):Can anyone advise on what needs to be done to connect from a selection of web connections for sharepoint?

What I try to do is to download a raster from a WMTS to use it as a background image for a report. I do not want to download the entire service, only a part to use as background. The result I get is only working on very zoomed out tile matrices, like 04, where the resolution is not useful: On deeper levels the FeatureReader is downloading a lot of tiles, which takes a very long time.The WMTS I use is a Dutch one, in epsg:28992. I wonder if I am doing something wrong, or this is never developed / tested for this coordinate system?The point is on 147513.92, 523126.09.The WMTS is https://service.pdok.nl/hwh/luchtfotorgb/wmts/v1_0?The Layer is Actueel_orthoHRAttached the 2023 workspace. 

Hi,I would like to merge polygons based on area up to a certain point. For example if I had 1000 polygons I would like to reduce that number to 100 keeping them as close as possible in size to one another. Does anyone know if this is possible in FME?Thanks for any help!B

Hello, I need to switch to a new machine. I save my workspace files under a designated directory, which has been transferred to the new machine. I am wondering if there is any important configuration file would need to copy over (e.g. some database connection, web connections, where those info stored?) and where usually to find the file?I am using FME workbanch 2023.2.3.Thanks. 

After upgrading FME Server from 2022 to 2023.1 my existing workspaces have started failing due to the following error:Python Exception <TypeError>: init() takes at most 2 arguments (4 given)ARCGISPORTALFEATURES writer: An error has occurred. Check the logfile above for detailsThe same workspace runs correctly locally on FME Desktop (both 2022 and 2023) and I have tested reuploading the WS from FME Desktop 2023 to the Server but without success.I tried creating an entirely new workspace in FME 2023 that should just write a single object using the Portal Feature Service Writer. It failed with the same error on both Desktop and Server when writing to a referenced feature service but was successful with a hosted feature service.In summary:Original workspace (writing to referenced feature service with Portal writer)  FME 2022 FME 2023 Desktop Yes Yes Server Yes No  New workspace in FME 2023 with Portal writer  Referenced feature service Hosted feature service Deskt

Hi I am new to FME and here as well…I am trying to use a PDF that has an image and I want it to use FME ( not sure which one) to export it to TIFF the same as you see in PDF ? Is that possible for me to do that ?

Is it possible to upload a file as Multipart Upload without first writing it to the filesystem?I have this working:But this requires to first write the attribute to a file and then using the filepath to upload.I tried base64 encoding the binary attribute and uploading. But I dont know what to set the mime-type to._response_body (string: UTF-8): { "args": {}, "data": {}, "files": { "temp.zip": "data:application/octet-stream;base64,AAAAAAAAAAAAAAAA=" }, "form": { "token": "tokentokentokentokentoken", "f": "json", "archive": "true" }, "headers": { "host": "postman-echo.com", "x-request-start": "t=1722253286.223", "content-length": "201671", "x-forwarded-proto": "https", "x-forwarded-port": "443", "x-amzn-trace-id": "Root=1-66a77fe5-2101668c0d99d0fd01e61cc4", "user-agent": "FME/2021.7.42.21821 libcurl/7.79.1 (OpenSSL/1.1.1n) Schannel zlib/1.2.11 WinIDN libssh2/1.9.0 nghttp2/1.44.0", "accept": "*/*", "accept-encoding": "deflate, gzip", "cont

FME kullanarak cad dosyalarını gis dosyalarına nasıl dönüştürebilirim?

Currently the OpenAIVisionConnector (version 6) requires an OpenAI API Key and there is no possibility to adjust the endpoint.I hoped the transformer would be adjustable, but it’s password protected…I was wondering if it is possible to offer a setting where the end user can self set an endpoint. Bigger companies have the tendency to run their own cloud, and ours is no difference here.We for instance use Azure OpenAI, but with open source AI models e.g. Llama getting more and more capable there might be a valid point to give the end user the possibility to adjust the endpoint.It might be a bit uphill, but if there would be the option to chose between an API Key, and a Bearer token; that would be awesome!What do others think about that?

Hi,I am trying to extract the four corner coordinates of a tif file using the RasterPropertyExtractor.What I need are the coordinates of the data extent of the image without Nodata, what I get are the coordinates of the full extent of the image. I guess somehow I have to make the existing Nodata “0” to “real NoData”. Any help is appreciated.Thanks 

Hello Safe Software Community,I work for Riteway Towing INC, a leading towing company in Queens, NY. We're exploring ways to enhance our operations, particularly in managing our fleet of tow trucks and providing timely roadside assistance. Given the complexity of NYC's traffic and the high demand for 24 hour towing, we need a robust solution for real-time data integration and route optimization.Can FME help us integrate various data sources (like traffic updates, GPS data, and service requests) to streamline our dispatch processes and improve response times? Additionally, has anyone implemented FME for similar logistics and fleet management tasks? Your insights and experiences would be greatly appreciated!Thank you!Olivia Marie - Manager at Riteway Towing NYC