FME Form

I'm creating a dynamic workspace which reads Excel sheet as a configuration and extracts data from a Feature Service. Configuration file looks like this:FME workspace looks like this:Feature reader reads every row in configuration file and extracts data for the listed Feature services. It outputs everything through the generic port.  In the configuration file I have field mapping information where attribute fields in a feature services are mapped with the output fields I need: 

I have too many points A and too many points B and I have many small polygons . every small polygons contain point A but some of them include point B . i would like to to find each point B that close to point A but it should be at the same small polygon if point A does not find point B ,at same small polygon so it will be better if i can mark it .that no point B close to point A .FME 2021Thanks in advance

I am trying to read an arcgis dimensions file from an sde . While reading i am getting the error "Unable to convert row to 'DimensionFeature'". i need to read the dimesions and need to convert them as a line feature.can you please hep me to resolve this issue.

I have a 3D meshes of buildings in a Rhino file that can be exported as a .obj or .fbx and want to use the fanout expression to put each building into an individual file/folder. The exported file (both .obj and .fbx) dont have any attributes and is read as one cohesive mesh so I am unable to assign any attributes to them to split up. How would I go about this workflow?

In the attributemanager, I declare the igds_model_name which is an atttribute for the model name and is determined by feature_type. Therefore in theory every feature should be written to their respective model. I also declared the model names in the seed file of the dgn, but for some reason the specific features are not written to their respective model. I was wondering whether it's possible to write features to different models in a dgn file and how one is able to do that. 

Hi,No data area of geotiff generated from 'HillShader' can't be shown as transparent in ArcGIS. If it's shown as RGB it contains ALPHA band, but if I choose 'stretched' in symbology, Alpha band is missing, nodata has been shown as black?Anybody knows how to show nodata as transparent in ArcGIS if the hillshade output generated by FME?

I have a simple workspace to generate some web tiles.   I first used WebMapTileClipper to break the data into vector tiles.   I next ran each vtile through MapnikRaster and grouped by _tile_column & _tile_row. I next sent each raster to WebMapTiler. See my attached workspace image. It seems that WebMapTileClipper and WebMapTiler do not agree on column and row. WebMapTiler generates an extra tile for many of the same tile coordinates. In my attached example you can see that MapnikRaster generated 1 image for _tile_column: 978 and _tile_row: 1655 however WebMapTiler generated 2 tiles. Any advice would be greatly appreciated. Richard Carmel 

Looking to extract 12 different unique number values in a CSV file. What would be the ideal way to accomplish this task. TIA

Hi all.I'm trying to update single values in a table, which has 3-4 keys. The three keys are mandatory, while the 4th is optional.A writer will apparently only update records which has a value for the 4th parameter, erroring when this value is NULL.Why is that ?I tried to test for the NULL value, but that didn't work. Apparantly the value needed to be tested as being an empty string, not a <null> value, even though that was what it contained.Is that a bug ?And lastly you - again apparently - cannot simultaneously have a writer/update and a SQL Executor (to handle the NULLs), the writer blocks the SQL Executor. I had to ditch the writer and go with two SQL Executor's.Why does a writer block transformers ?All this a s a warning to y'all. Can anyone confirm these findings ?Cheers.2020.2 / MS SQL Server

We use file geodatabase replicas to edit our enterprise SDE geodatabase. Edits made to these file geodatabases by FME are not recognized as "changes" when these replicas are synchronized to the master.Has anyone found a way to solve this?I see a post from Mark Stoakes (about 5 years ago) where he explains that FME cannot make entries in the change tables maintained in the replica - which definitely makes sense.Just wondering if anyone has possibly solved this? 

I've created an excel sheet with a series of dataset names and different equations to run against them e.g. @Value(COV_LEVEL)-@Value(INV_LEVEL) Using fme_feature_type and FeatureMerger I am able to get my datasets and the required equations together. How do I tell FME that to use the content of my Feature Attribute as an equation and action it rather than as seeing it as a text string? thanks

I have some date with id-blocks, meaning there is a column where one and the same object is represented of several features, with different attribute values, but always with the same id for these features.How many features there are per object varies.I was thinking to build some 'decision-tree' in an AttributeManager to find the correct features of such an id-block to process further. Unfortunately, the AttributeManager is not a group-by transformer and I was wondering how can I group my data by id, and process the resulting group, before the next group is created and processed.

Hi Community! I would like to know how, if possible, I can move workspaces from one fme server to another using the rest api. The overall goal is to use the rest api to backup the contents of one fme server onto another. Has anyone done something like this in the past and if so what did you do? Cheers,John

I'm trying to do a spatial join between two AGOL layers, one is a strip map and the other is parcel data with owner info. I want to merge the two and create a table with the owner information and its respective page number.  I have been using the SpatialRelator tool; the parcel data are Requestors, the strip map pages are Suppliers, Spatial Predicates are intersects/touches/within, and merge attributes are checked with Merge Supplier as the Accumulation Mode and Supplier as Conflict Resolution. The SpatialRelator will create a table with all attributes merged but all of the supplier data is shown as "<missing>" (and it's definitely not missing in the AGOL layer). I have tried a few different combinations of this but I just can't seem to populate the entire table. Has anyone ever encountered this problem?/Does anyone have any ideas on a fix?

I have a MHWS and along the MHWS line the elevation from the DEM varies. I want to locate the 2metre elevation point relative to the MHWS Line. Could you please suggest an approach that would work to identify this and convert to a line

I normally run FME Desktop at the office, where I'm storing named connections and associated files on an office network share, in order to facilitate sharing these between the development and production desktop licenses.These files are backed up to my local drive every day.Now, when I'm trying to run FME offline, without access to the office network, FME refuses to access the named connection, and even bars me from reading from a local SQL database although all connection data is entered manually.This also happens after I change the references in under options to point to the local backup copies of the files in question.WTF?Why is FME refusing to work normally in this manner ?Version 2022.2.2

I'm having an error I have not been able to fix when attempting to read/write an annotation feature class from one SDE geodatabase to another. When writing the annotation feature class using INSERT and TRUNCATE in the writer, I get the following error: Invalid geometry type received for an annotation feature. Please split multi-part annotations using the SPLIT_MULTI_PART_ANNOS keyword on the reader to 'yes', or switch to classic geometry mode before attempting to write them to a GeodatabaseBoth annotation feature classes have been updated to an ArcGIS Pro 3.0 version, and they have matching schemas. I've made sure to "clean" the geometry in ArcGIS Pro (no geometry issues were found) but no luck. I'm using FME 2022.0.0.2 (Build 22343 - WIN64). I also followed the suggestion and changed the SPLIT_MULTI_PART_ANNOS keyword to 'yes'. Not sure what "switch to classic geometry mode" means... I'm able to read/write older versions (i.e. Arc

I have a lot of ZGF files to convert to shapefile format.  I tryed to use FME to do it, but it seems that some mistake is happen while the imput file is been reading, that cause the lost of Coordinate System. It seems thta the software used the plot coordinate instead of original file coordinate. The ZGF units was identified as 0.

I have tried all the ways I could think of to do this but cannot find anything on how to change a text field to an integer field like in ArcGIS Pro. Please help! This is what I have tried: @int(USER_Price)@int(@replace(@replace(USER_Price, "$", ""), ",", "")) I have also tried @Trim which produced a 3 digit result.

Hello.i have simple workflow to update Access MDB content.it starts with SQL creator to define the queries and end up with SQL Executor to write down all the attribute manipulations and the end.Works fine in workbench as it updates existing MDB file and therefore there is no Writer placed at the end. Im seeking an advice how to update this to be able to publish it to FME cloud so the Cloud returns the updated MDB file.as this MDB file is uploaded at the beginning, it still exists and being updated somewhere in the temp folder of the FME Cloud so it should be easy just to request it with some transformer at the end and provide it as a result. can you advice me what transformer can do it for me?

I created a workbench in an earlier version of FME workbench and then when I updated it to 2022.1 it eventually stopped working referencing an undefined macro 'OUTFIELDS' to a file that doesn't exist when the translation fails. I tried copy and pasting the workbench into a new workbench but that didn't work. I tried updating to 2022.2 but that also didn't work. I'm hoping someone here has had a similar issue and knows how to fix it. I am trying to avoid recreating the workbench from scratch because it is rather large

I am trying to simply export results with a Writer into a .shp. If I do not use a GeometryValidator most of the features are present in the final attribute table, but not shown in a ArcGIS map. If I use the GeometryValidator and then use both the good and the repaired features as inputs for the Writer, some results are missing from the final attribute table, but all the result in said table are also displayed in an ArcGIS map. The log gives following warning "Dropping heterogeneous aggregate feature for the SHAPEFILE Writer, due to feature type allowed geometries restriction". How do I solve this? Thank you!

Hello everybody, we have a problem with the Directory and File Pathnames Reader.There is an UNC-path: \\\\[server]\\X$\\[directory]\\[directory]\\[directory]. The user has access to the (last) directory and also rights to write. This has been checked. If we use this UNC-path with the Directory and File Pathnames Reader zero features will be read. There is no error, just zero features.It works (with same settings except the path) when the path/directory is connected as network drive. But this is undesired. Has anybody an idea how this with the blank UNC-path works? We are using the FME Desktop (and FME Server) version 2020.2.0.0  Thank you very much in advance! EDIT:it works with a blank path filter and when subfolders are excluded:But we also n

Hello,in the past it was possible to set the options to no and still choose a template. Is there a workaround here? Why is that no longer possible? I would like to use a template and every time the workflow writes that this is done to the same file and not all spreadsheets are removed. 

Can I have one more question? Is there a transformer within FME that could format CSV into plain text with formatting, see the attachment? Thank you very much