FME Form

I have an FME process that requires me to read in an AGOL feature service that includes attachments and write the data and attachments to tables in an Enterprise SDE database on our servers. I've gotten this entire process to work on a smaller copy of some of this data, but for some reason when I run the process on the larger set of the data, none of the attachments that exist on the hosted feature layer are read by the reader at all. I definitely have "Include Attachments" turned on, and I've exposed all of the attachment related attributes: everything is identical in the FME process to the one that functions properly. There are some minor differences in the way these layers were uploaded to ArcGIS online, so I'm just wondering if there's ANYTHING on that end that could be causing this problem.

I have a viewer with layers in ETRS89 and want to add a WFS layer in ED50. I need to convert the co ordinate system in the cloud before it reaches ArcGIS Online so that everything is in ETRS89. What writer and transformer should I use? Is there a relevant tutorial (name please!)

In the UK we are able to download energy performance certificates from the following government website. Energy Performance of Buildings Data England and Wales (opendatacommunities.org)Unfortunately you need to register to gain access but its very straightforward.Within there is access to an api, which I have tried to use within FME to automate the downloading of these certificates for a local authority area, but always get a failure.Can anyone else connect to this API and download certificates and if so how. Sorry i cant paste the API but it changes for each user... Regards

Hi, I'm following the FME Desktop Basic training, now doing exercise "Flood Risk Project" (under "Use Conditional Values"). As it is clear that I'm newbie to FME, so maybe this is a stupid question: where can I find the parameter "Elevation"? See pics attached here. This parameter is not listed in the AttributeManager, nor in other Read items. The FME workspace can be found here. Maybe I overlooked something?

I have created a workspace which reads all CSV files from a zip file selected for a file user parameter by using $(ZIPFILE)[**\\*.csv] as the dataset in a FeatureReader. This works as intended in Desktop, but will not run on our FME Server (tried with FME Server 2021.2.5 and FME Flow 2023.0.2). In both cases, the CSV reader fails to open the file, which is being stored in a temp upload directory specific to the workspace file name, including the ".fmw" extension. I currently believe that the ".fmw" in the directory path is causing the issue, as I am able to run the workspace successfully when I add the file to another FME Server Resources directory and browse to the file instead of uploading when attempting to run the workspace. Is there any way to specify where the file gets stored when being uploaded from the Run Workspace page or via a server app? Any other way I might be able to get this to work as intended?

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