FME Form

I have some database tables which contains a few so called "GeometryCollections". I try to use FME to find which objects are of that type so that I can fix them, but none of the alternatives in GeometryFilter will find the GeometryCollection objects. Any suggestions?

HiBeen struggling with this for the last hours now and I cant get it to work with gpkg, with shp it works fine. But this file i need to download is gpkg. The data is open road data and the zip is around 2.7Gb big. This is the error I getOGCGEOPACKAGE reader: Dataset 'C:\\FME_TEMP\\wbrun_1694624249590_18024\\fmetmp_0\\1694627133694_13812_d\\tor050\\http_download_1694627134354_13812.zip.gpkg' requires file extension '.gpkg'. Using dataset 'C:\\FME_TEMP\\wbrun_1694624249590_18024\\fmetmp_0\\1694627133694_13812_d\\tor050\\http_download_1694627134354_13812.zip.gpkg.gpkg'OGCGEOPACKAGE reader: C:\\FME_TEMP\\wbrun_1694624249590_18024\\fmetmp_0\\1694627133694_13812_d\\tor050\\http_download_1694627134354_13812.zip.gpkg: No such file or directoryOGCGEOPACKAGE reader: Failed to open the dataset 'C:\\FME_TEMP\\wbrun_1694624249590_18024\\fmetmp_0\\1694627133694_13812_d\\tor050\\http_download_1694627134354_13812.zip.gpkg'. Please ensure source data is valid and correct

Hi,New to FME and creating a workbench converting CAD to GIS. I am trying to get the structure fields to match and eventually join them after more clean up. Id like the structures field to be abbreviated. I was thinking Attribute manager could do this. but when I use conditional formatting I loose the "-#". another thought would be to add an alias? but again I am not too sure of a solution. Thanks!

I'd like to calculate the total sum of points associated with different asset IDs that fall within a specific polygon. My desired output should resemble the table provided below.

I have two separate files, one containing GIS pipe data, and the other with pipes exported from a model. Both of these files have lines, and I want to identify the GIS lines that overlap spatially with the modelled links. I've attempted to convert the GIS lines into polygons and then check if the modelled pipes fall within these buffered polygons. However, I've tried transformers like LineOnAreaOverlay, SpatialRelator, and more, but none of them seem to be working for me. Can anyone assist me with this issue? I eventually need to compare the diameters between both files and it would also be good if can merge attributes from both files

I have a LAS point cloud dataset that i want to urn into a nice mesh surface,the area is 1kmx1km. it has some high-rise buildings. using the workflow below. I've tried thinning the point cloud and ive also tried playing with the parameters in the TIN generator but it doesn't come through very nicely. any advice? I was thinking it ditch FME and use something else for this conversion?iwould like to use this mesh in unreal engine if the conversion goes well  

I am trying to create a webhook for a sheet in Smartsheet (https://www.smartsheet.com/ ). API documentation on webhooks can be found here: https://smartsheet-platform.github.io/api-docs/?shell#creating-a-webhookAs you can see in the diagram for creating a webhook, the webhook needs to be enabled after creation: this is where I'm having a problem and need some help! The "subscriber" (the callback URL, which for my test case I'm using a topic posted to FME cloud) has to respond with a 200 status and also echo back a "challenge" random number that comes in the response header by including it in the response header "Smartsheet-Hook-Response". Or it can respond with a json that contains this value in "smartsheetHookResponse" attribute.As you can see above, when I try to enable the webhook, the callback URL is triggering the topic (all good here; two attempts shown above). The highlighted string is what I need to return (step #5 of the image in

I want to upload several pdf maps to AGOL, which I am downloading from Sharepoint. How can I upload over 20 pdfs on AGOL using ArcGISOnline Connector transformer?

HelloI have a polygon, which is a single feature and need to clip it where the road name changesThe data i have is the polygons adjacent to the road, and the road centreline. I have created a centre line through the polygon, chopped that centreline into 1m segments and applied the nearest neighbour roadname to them.Any ideas how to chop the polygon where the name changes as shown in the redline on the image attached.Regards 

I understand can use the coordinateSwapper transformer to switch Y Z values in the wavefront obj file. But can I also change the sign of the y-values (says from -ve to +ve) as well?

I have two GDB Feature Classes: street centerlines (polylines), and cross streets (points). The values in the cross streets field are, for example, in this format "A St/Elm St/Fern Ave". These are all the cross streets at each intersection. ​I am using the PointOnLineOverlayer to join the points at each end of the line. There is one point at each end of each line. I have unchecked Merge Attributes. I have checked Generate List On Output Line.  I checked and all points are snapped to each end of the line.  I have increased the Point Tolerance in the PointOnLineOverlayer in increments up to 50 and there is no change to the output. ​I created 2 Lists, PT(0)_CROSS_ST_NAMES and PT(1)_CROSS_ST_NAMES. PT(0) captures the cross streets (a single point) at one end of the line, PT(1) captures the cross streets (a single point) at the other end of the line. ​When I run the transformer in some situations it duplicates the line and places the cross streets that should be in PT(1)_CROSS_ST_

 Hi, New to FME here. I have been tasked with creating a workbench to convert DWG to GIS (storm water asbuilts). Below is the autocad text string field which contains three rows. first structure name, Top elevation and on invert elevation. I would like to know a way to separate this into three fields. I have created the fields with Attribute manager but have no idea how to parse this out.  I was thinking it could be based on line row number? Since Multiple types of structures and line is always structure name, line 2 is always top, and line three is always Invert elevation.  Thanks! 

I've walked through all the steps found here to connect to our Enterprise portal: https://community.safe.com/s/article/How-to-create-an-FME-Web-Connection-for-Esri-ArcGIS-Portal-Feature-Service-OAuth-2-0. I created an application on the portal, made a new Web Service from the default Portal template, but I can't get past the Authentication of the web service, every time I test it I get a 404 error. Has anyone encountered similar issues before?

Hi, I'm trying to dynamically write some features to a Geopackage, but constantly get the error `OGCGEOPACKAGE writer: OGCGEOPACKAGE writer: For feature type 'd_y_n', primary key attribute 'fid' has unsupported type 'mediumint'. Primary key must have type 'int'`. I'm reading the schema and features with a FeatureReader, from a PostGIS database. Dynamic writers for other formats seem to be working fine (obviously not tried them all!). And I've tried manually changing the schema in the workbench (by altering the native type attribute), which also doesn't work. If I manually set the output schema it works, but I can't do that... Any ideas how I could resolve this issue? (Using FME 2021.2 on MacOS)

Dear Sir / Madam, So I have two excel tables. Mother name.xlsx is the original data and waterbody.xlsx is another table. So I would like to compare two excels. If both excels' column "ModelName" are matched. The mother name excel's model name column should change to newmodelname column. If not, just keep the original modelname. I try to use tester transformer but I am not sure why nothing can be matched. I hope someone can give me a hand. The output that I want is in the Output.xlsx Thank you very much. 

Hello Community, i want to know how is the transfer of georeferencing information is done between IFC and CityGML. Like is there any FME documentation that covers this subject?Thanks in advance.

say I have a GDB, with a feature dataset fruit (gdb) apples (feature dataset)coreslicesusing the schema reader, how can I expose the feature dataset name of apples?exposing all of the attributes in schema reader will not expose the name of the actual feature dataset within apples. I can get all the other attributes using list exploder.but can't get the feature dataset name.anyone know how?

When using the "Select file from Web > Browse Amazon S3" option as the source for a reader, is there anyway to pass parameters in to the dialog?I have some FME Flow/Server workspaces that are called with the bucket name and path as parameters, I'd like to be able to use those parameters instead of hard-coding the bucket and path. Currently we use the S3Connector with parameters to download the files to local temp and then a FeatureReader to read them, but it would be nice to read them directly. Thanks,Andy

Has anyone run into CTRL+V not working in 2022.1? Seems to be okay within transformers but I can't use a shortcut to copy and paste a transformer itself. What's weird is if I use CTRL+C, the paste icon above correctly pastes the transformer. Just can't use the CTRL+V shortcut. Worked without issue in 2021.

Dear all,You have an article explaining how to create a WMS Service. Two operations are explained: GetCapabilities and GetMap (https://knowledge.safe.com/articles/19640/how-to-create-a-wms-service-using-fme-server.html).However, we also need the GetfeatureInfo operation. Is it possible with FME? I have not found information about this operation. It would be very helpful to have a .fmw for the GetfeatureInfo operation, in case it's possible to create it.Thanks in advance and best regards,Montse Marco

Hello all,I am trying to update a feature layer on the ArcGIS Enterprise Portal.I have the feature layer and an Excel I'm using for the updated information.  The change detector detects the one change I've added to my test version but when I try to update the online layer I get this error message:  "ArcGIS Portal Feature Service Writer: 'updateResults' error for a feature in 'C1_Cluster_Flurstueck'. The error code from the server was '10500' and the message was: 'Cannot convert a value of type 'java.lang.String' to 'INTEGER'.'" The values that I'm trying to update in the excel and in the layer are both text fields and not numerical hence I dont understand where the integer part is coming from. Can someone tell me if I'm using the right transformers and what I should change to make it work? Thanks in advance! (I'm fairly new to FME so any help regarding the workspace is appreciated) 

Hi, I am a new FME user and hope someone can assist with my issues. I have to update weekly utilities data from .12dxml to geodatabase. From thegeodatabase, I have to create a map in ArcGIS Pro and publish it to ArcGISOnline. I just run the FME and overwrite the map whenever I receive data toupdate. I have no issues doing it since I just overwrite the data for everyupdate.However, the team requires me to add the date to each of the layer names e.g.:utilities_electricity_20221025.Previously it was just utilities_electricity.Hence, I couldn’t overwrite the data into the gdb. It will create a new layerinstead since the layer names are different every time I update the dataweekly. eg:utilities_electricity_20221025(for week 1); utilities_electricity_20221104 (for week 2). My questions are:1.      How to overwrite/replace the layer with a different name? E.g.: utilities_electricity_20221025(old data) replaced with utilities_electricity_20221104(new data) in gdb?2.      How to make sure the m

I've built an AutoCAD based automation in FME Form and use blocks with text for some of the output features. The text aligns how it was designed in the block in the FME Form output.   However, when running in FME Flow the text shifts.If I move the block slightly, select Reset Bl;ock or edit the text in AutoCAD then it snaps back to the correctly designed position.I'm using the same template dwg in FME Form and FME Flow.

Hi, I'm trying to run the attached workspace on a series of files to check the coordinate system then output the filename and whether it's georeferenced or not.  I want to extend this functionality later, but am struggling to just run it on files instead of the features within. Can someone please explain the best way to achieve this - my current way is to run a separate workspace runner and direct it to this, I don't think I'm quite getting it though still. I'm also running a different workspace for internal feature checks, and assume this would be the way to go - to break to an internal feature check, and file check workbench (can't think of clean way to organise the data otherwise.) Thanks!  

Hi all. I've got the measure calculator working with the standard measure generator/pointonlineoverlayer/measure extractor routine. In many cases points are close to two or more line however there is a common attribute between a point and the line. How do I go about using the common attribute detail to calculate the measure. That is a want the measure of Point 1,2...n with attribute "x" calculated on line 1,2...n with attribute "x". Kind of like preventing them from snapping to the incorrect line. The other issue is not all points fall on the line but are very close so a tolerance needs to be introduced. Hope that makes sense. Thanks,Michael