Transformers

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!

Hey Community!How can I find and know the right projection système of a shapefile that he has not the .prj file?Tnkx 👽

I

Hi all, Often users from this forum reply and attach a file with a sample workspace that shows how the transformer works. So I wonder if there is a collection of example workspaces for any transformer somewhere ? Thank you!  

I am trying to load some buildings to Cesium but when translating shp to Cesium 3D tiles I get rotating buildings in Cesium (when changing the camera position), although the buildings' location is correct in Cesium. I've tried converting this shp file to gml and then loading this gml to Cesium ion which makes 3d tiles itself and this works - buildings are not rotating. What could go wrong with FME Cesium tranformer when tiling?

I am converting IFC to file geodatabase. Some are in mm. I have used scaler to convert but the geodatabase properties would seem to indicate that the units are still mm. I am not able to convince myself that my script has actually converted correctly. I use 'generate script' to statically convert from ICF to GDB inserting the scaler where there are features to convert before writing out.Any help would be appreciated,Ian

The following is how the data comes in using SQLCreatorAnd this is how i want it to lookThe other tricky part is that there is no limit on the number of nar_num records (rec_seq) that can be linked to a single ass_num - at the moment I have a max of 17 but that could go up or down I looked at the pivoter and didnt have any luck with that but i am new so maybe i am missing something.Anyone have any ideas?         

Hi all, I have a seemingly easy question. I have two feature classes that I have spatially joined using the spatial relator. There are two cities fields in this new feature. For the sake of the example, we can refer to them as Cities A and Cities B. Some values are null in both fields, however the Cities A is more accurate. How do I combine Cities A and Cities B into a new field with priority given to Cities A, assuming it is not null. i.e. if Cities A is null and Cities B has a value, we use Cities B. If Cities A and B both have values for a feature, then only Cities A would be used.

I have different features that are segments of cable. Each one is different and the shape is always straight. My goal is to find both end points and then label one as start and one as end. My question is how do I get the points from a line.

Hey community! I have a square in 2D and I want to clip a TIN surface inside this polygon, how can I do?tnkx

Hi All, I'm trying to use PythonCaller for a few more complex date calculations that I couldn't find how to easily do with other FME transforms. One of the things I need to do is some standard if/else testing to set a variable based on two other feature attribute values for further processing down the chain, however the results are not returning correctly. I've split out what i'm trying to do into a simple PythonCaller: import fmeimport fmeobjects# Template Function interface:# When using this function, make sure its name is set as the value of# the 'Class or Function to Process Features' transformer parameter def processFeature(feature):    #Define vars    completionDate = feature.getAttribute('PREREQ_COMPLETE_DATE')    notRequiredDate = feature.getAttribute('PREREQ_NOTREQUIRED_DATE')    useDate = None    #Test if completionDate is null and fill with notRequiredDate if so     if completionDate is None:        useDate = notRequiredDate    else:        useDate = completionDate #Set new 

Hi @everyone, I want to test my 3D Dataset for vertical lines (only horizontal are allowed). I instructed the transformer to test if the z-start point is the same like the z-endpoint. Now the problem is the amount of z-points in the data set differs, some lines got more than 6 or less:  How can I test dynamically for the end z-point? Thank you in advance.

Hello,I have a bigger workspace with a lot of spatial transformations writing into .ffs files. The process is running since two yeas on FME Server 2018. Now after migrating the workspace to FME 2020 the process ends with a FATAL 'Expression: !isPoly || curve->isClosed2D()'.However the .ffs are written successfully.Now I 'm searching for the transformer which might have fired the message to analyse what I have to change.Any ideas?thanks Klaus 

I have to read all the WFS features, but it can't be sequential read, because server crashes then using this method (feature count is ~3 000 000). I managed to read in all features with 10 different WFS readers and XML filtering by attribute. Is there any simpler/faster way to pull it? For example it is possible to somehow read first 100k features, then request another 100k and so on?