FME Form

I'm looking for some help with creating a Bridge in CityGML with two BridgeParts. Those BridgeParts can consists of one or more other objecttypes like BridgeConstructionElements. I've tried many things, but I can not figure out how to create the hierarchy of all the components in CityGML...Of course using the gml_id and gml_parent_id to connect elements, but unfortunately this somehow doesn't work out the right way. Anyone ?Like to share the final solution! What I like to see is a hierarchy:one bridgeconsists of two bridgepartswhereas different bridge elements like constructionelements can be found in both 'bridge' and the two bridgeparts So, something like this (simplified of course):<Bridge gml_id: BRIDGE>  Bridgepart gml_id = part_1 gml_parent_id = BRIDGE BridgeConstructionElement gml_id = 563456 gml_parent_id = part_1

We had numerous SQL Creators based on JDBC connections that worked in both FME Desktop and FME Server. We are in the process of migrating our SQL Creators from JDBC to Microsoft SQL Server Non-Spatial (ADO). In doing so their SQL continues to perform well in Form, but now generates Warnings when executed on Flow. The Warning takes the following form:"Microsoft SQL Server Non-Spatial Reader: Getting Custom SQL schema failed. Custom SQL query 'SELECT ... WHERE ... ORDER BY ...' may execute in an unexpected manner. Make sure all columns are named (any ambiguous columns, e.g. GEOM.STBuffer(1), must have an AS clause). If there is an ORDER BY clause, either remove it or add a TOP clause." Removing the ORDER BY does eliminate the Warnings generated on Flow. However we enjoyed using the power of the database to presort the records prior to being transformed within the workspace.  Why is ORDER BY

how can I adjust the tolerance or script to account for the hard turns with the wind radii and wind forecast graphic? I want it to get rid of the extra space when there is a turn see below picture:

Hello,I have an sde database containing hundreds of feature classes, in which each feature class has an attribute containing a document reference.I would like to be able to read the first row of attributes from each feature class so that I can check the document reference.My current workflow uses the SQLExecutor to extract all of the feature class names. Then the names are passed to a FeatureReader to read in each feature class, with the 'Max features to read' set to '1' to save reading more attributes than required.However, this is still taking a long time to process all the feature classes. Is it possible to do all of this in SQL?

How can I assign user parameters via a file? I have a large number of parameters and they all need to be pre-assigned. However, the content of the parameters can change. Therefore a variable solution is needed

FME Flow cannot delete File GDB, but the FME Form can delete and succeed, is there something I need to do for Flow to work correctly. I have added my domain svc account for Flow to the output directory with full privileges.

Using string searcher with the search text LB I identified the number in the red box on the left. The number always contains the text LB and the same number of characters after LB. There are a lot of PDF's where the file names need to be changed to the LB number. Below I attached a screenshot in which I used a tester and a string searcher. I can find the LB number but how do I copy it to the writer name as output and how can I easiliy process aproximately 1000 pdf's in one go without manually changing parameters?

We have a selection of roughly 40,000 Uber H3 Hexagons. From this set we need to randomly choose 10 hexagons to perform a survey within, and would like to then select 10 more hexagons as alternates should one of the original 10 not be suitable for survey. Our first attempt used two Samplers. The first Sampler selected 10 features using the "Randomize Sampling". The second Sampler was fed from the NotSampled port of the first Sampler, and 10 more features were selected. Unfortunately both Samplers are selecting very similar patterns. Consistently, nearly every feature of the second sample is a neighbor of the first sample.  In our second attempt to get a more randomized pair of samples, rather than a repeated pattern, the first Sampler selects 20 randomized features. Those 20 are then fed to a second sampler to choose 10 from those 20. This approach generates what appears to be a more randomized sample of both primary and alte

I have prepared workbenches using FME 2022. Few days back, I have installed FME 2023 build 23603 FME 64bit. When I executed the workbench in latest version then translation is very slow when compared. I have crosschecked one again by running same workbench in FME 2022 and translation has completed as previously. Whether any other have encountered same issue??

I have about a hundred or so .csv files. They all live in different folders on the same network. In a database table I have the path and name of each file (something like: "M:\\ExampleFolder\\Example.csv"). As I process each record, I just want to copy each source .csv file to a folder called "D:\\Temp" and rename it "Final.csv". So "M:\\ExampleFolder\\Example.csv" would get copied to "D:\\Temp\\Final.csv" when that record was processed. The next record in the table might be "D:\\ATotallyDifferentFolder\\Different.csv". When that record gets processed I want that file to replace/become the new "D:\\Temp\\Final.csv". I can't seem to figure out how to use the File Copy writer to do this. Any help would be appreciated. Thank you.

Normally the MSWordStyler works in sequential order. But in my case the transformer works in a different order and I have a table that doesn't seem to take the style that is defined in the MSWordStyler .

I have made a beautiful Map using "HTMLReportGenerator". This Web Map contains coordinates of points or lines that I dont want to be shared with the World if I publish it online (because of data protection). Is there a way I can somehow make invisible those coordinates so that if I inspect the HTML page I will not be able to see all the coordinates ?

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.zi

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 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 duplicate

 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?