Transformers

See attached screenshot. I have a shapefile with Photo_Name attribute (175 features), I apply a tester on the shapefile to filter the features I need (109 features). How can I then select only the 109 required images from the 175 source images - the fme_basename of my images = the Photo_Name.

Hi all - I've got a model where the nulls are mapped as zeroes, however when I write it out to an SDE, the nulls are still nulls. I did try this with a Geodatabase, and it wrote the nulls out as zeroes, and I imported that into the SDE - all looked good until I re-ran it and the newly-made zeroes turned into nulls, despite the AttributeManager saying to write out zeroes. I realise in writing this, the amount of times I put "nulls" and "zeroes" has probably caused you to space out.

I have 3D building model (in *.ffs and cityGML format) and I would like to clip of them by 2D polygon. I tried Clipper transformer, Extruder 2D polygon and SpatialRelator ("Requestor is Within Supplier"), and I tried also a CSGBuilder. But all of them don't give me appropriate result. When I use a spatial relator, my result is in Rejected port, and Total Features Written is 0. When I use a Clipper Transformer, I receive an error: "Clipping is not supported for IFMEBRepSolid geometry"Someone has any idea to solution of my problem?Thanks in advance.

I am trying to use the FeatureJoiner to join Parcels(LEFT) to centroids(RIGHT). If I choose a LEFT as the join mode. I should the same number of parcels as the orinial input. This would include the successfully joined parcels and the parcels that had no match. My initial parcel input is 830K. My output is over 1M. Where did the extra parcels come from?  It looks to me that dupliate parcels were created. But I dont know why.

Hi, so I have a point cloud like this: I would like to generate contour lines but have a smooth edge at rivers and lakes. Currently I get results like this(where lines are made across the water and weird things) using ContourGenerator with pointcloud as input. using    I then clip these lines away but it don't look too great,I end up with stumps like this sticking out into the river for example. How could I go about fixing this, like stopping lines to form across such large distances? Afterwards I also run Generalizer to smooth the lines out. Tips on this?edit: owait where did the pictures go let me readd.

I am reading a feature class from sde and using schema mapper mapping the names of input and output attributes. Finally using a dynamic writer I'm writing it to a shapefile. I have a workspace resource which reads a file and defines the schema. In the dynamic writer schema definition, I have given schema sources as the workspace resource . The attribute names are as expected in the output shapefile. But there are no values for any of the columns. They are just empty. Not sure what the mistake is. Any help appreciated

My goal is to batch deploy the process to many CSV. The transposer is only keeping the attributesof the table. FME_basename and all other attributes are dropped. With one file at a time i'm able to link to the source data set. but its not working when i batch deploy. It's keeping the same name and my files are overwriting each other. Thank you for your help

Hi list.This may have a simple answer, but I'll try and ask anyway.I have some 200+ features, that I want to add a geometry to. Simple, right?My table with geometry has 2.5 million rows, and I have to match on two string values.I initially tried to use DatabaseJoiner, but apparently it doesn't handle geometries ?I then got stuck with reading all 2.5 million records and use a FeatureJoiner. It works, but it's not optimal.What is the better way when fetching geometries from a database table/view for very few features ?Cheers.

For example:Parameter 1: Calculate area: yes/no Parameter 2: Units: m2/ km2,.... I would like to disable parameter 2 if the value of the parameter 1 is set to "no". At the same time I would like to have Parameter 2 as an mandatory parameter if the value of the Parameter 1 is "yes" Thank you!

All of the results appear to be anchored to the beginning of the text but the box is not aligned.

I have 676 DTMs, each a 1000 x 1000 grid. I am trying to convert them to a point cloud.I am using a PointCloudCombiner transformer between reader and writer. This worked perfectly for my sample tests. 1,000,000 points produced for a single file.The transformation fails when I scale it up to read all the files due to the limitations described here: https://community.safe.com/s/article/error-reading-large-number-of-raster-files#:~:text=The%20C%20runtime%20library%20used,file%20for%20reading%20or%20writing.I've used the work-around technique described and also used an additional RasterBandNodataSetter before the 2nd RasterMosaiker which I think creates a rectangular DTM within xmin, ymin to xmax, ymax despite there not being full coverage of this area in the 676 input DTMs.In the Raster Parameters in the PointCloudCombiner, Extract Nodata is set to No.When I test the workspace on 5 tiles it produces a point cloud with 5,000,000 points as I would expect.When I scale it up to process al

Hi, I'm using FME to build an ESRI REST service call to solve a routing problem. We need to route 1500 properties into 15 routes every day, each route has a capacity of 100 visits (orders in ESRI terminology).Occasionally ESRI snaps the lat/lon of the property to the wrong street so the sequence of the route is wrong.In the image property 1 is actually on the same street as properties 11-14 and property 15 is actually on the same street as properties 2-10. I need to 'move' the properties to the correct street. They still need to be on the correct side of the street as we need to maintain left hand curb approach ie to prevent having to cross the road (less of an issue with these small streets but the routes cover rural to urban streets). Does anyone have any ideas how to achieve this? I have access to a street centre line layer as well as the property points. many thanks

Hi. I want to find in a FGDB (Esri) if some value are null or empty ( 2 filters) for a lot of table and feature class. Also i want to know if some field have different value from list of value. Thank you everyone !

Is it possible to set up a parameter for a custom transformer so it allows selection of a list, not just a single element of the list?

Dear colleagues! I've read this article https://community.safe.com/s/article/writing-citygml-example and I have 1 goofy question. How could I change repeat times of my texture, and it will correlate with the length of the wall?

Hi,  I have troubles setting up a dynamic writer. In my workbench I perform two different queries on a PostGreSQL/PostGIS database. I want to write the results of these queries in a FileGDB using a fanout that creates feature classes based on an attribute value. Furthermore I want to overwrite the entire GDB each time the workspace runs.  I setup a FeatureReader for each SQL query, connected the ouput+schema to a fileGDB writer using the dynamic writer option. It almost works as desired but the problem is that the different schemas are merged in the output, so each feature class now has all attributes from both SQL queries. Does anybody know if and how I can setup the writer to get the correct schemas. Thank you very much!  

Good morning. I'm putting together a workspace to transform a Revit file into Cesium 3D tiles. Overall, it is a pretty straightforward process, but I'm facing an issue with the elevation. The building stored in the Cesium 3D tiles is floating, so I need to offset the Z to put it in floor level over a 2D basemap. I've been using the Offsetter transformer with lots of trial and errors until getting it right, but I would like to know if there is a better way. So the question is: Is it possible with FME to make that "elevation removal" automatic?

I successfully set up a Scripted (Python) Published Parameter called GIS_FILESHARE_ROOT. The script has the following code:import syssys.path.insert(0, FME_MacroValues['FME_MF_DIR'])import configreturn config.GIS_FILESHARE_ROOTThis imports config. Config is located in a subdirectory called 'config' of where the fmw lives. This subdirectory has an __init__.py file with the following code:import osGIS_FILESHARE_ROOT = os.path.abspath(r'\\server\dir\to\the\filestore\root')A shapefile reader was added pointing to $(GIS_FILESHARE_ROOT)\sub\shp_folder\TheShapeFile.shp and this successfully reads the shapefile. But, when I try do a similar thing but with a shapefile writer, I get an error.Undefined macro 'GIS_FILESHARE_ROOT' dereferenced in file ... Can someone help me understand what's happening and how can I setup a similar dynamic root config like I did with the reader?

Hi, I've got a pretty complex model going on, and I am writing an an excel file (appending) a few times throughout. However, even with the Feature Writer (as shown here) field names, it's not being picked up in the Feature Reader which is the next step. I know there's other field names of this type in the model, however I'm pointingit at the file to read, and they appear as such in the written excel file. I've tried purging temp data, closing and opening workspace, but to no avail. Any ideas?Thanks

Hello I want to set the Layernames in my output like in the picture, like the attribute-names of "description"But If I set it in the feature writer like this:Finally in the data inspector, I have still the wrong layernames:What am I doing wrong? Tried a lot of things, but cant solve it by myself. Thank you in advance!  

Hey community!How can I create a point-cloud from a TIN surface?tnkx

I am using fme_db_operation to write some data into SQL spatial server. After the running finished, in translation log it says:=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Features not written - verify feature type fanout/dynamic settings=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- (Check that fanout/dynamic feature type attribute exists and has a value)=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- 12809==============================================================================Total features not written 12809 From my checking, all new data are insert successfully.  Another error log is: Microsoft SQL Server Spatial Writer: Data type `identity' of attribute `gisids' of feature type `featureXXX' is not supported for writing. Attribute will be ignored by writer. The attribute was not ignored, it successfully updated in the database. I am really get confused by the log, it ca

Hi!I would like to be sure... the "group value" on microstation (group of complex elements, like symbol and text) is really unique, by group of element, on each file?On others words, is it possible to use it like an unique identifiant to extract informations link to the same object? thanks!

​I have 2 spatial files with postal codes and I already filtered out the duplicates in each table. I want to match the postal codes in the 2 tables and find out those that are not match.   The 2 fields I want to match are 'ADDR_POSTAL_CODE' and 'POST_CODE' (in 2 different tables). Thanks!