Transformers

I have a ESRI SDE Geodatabase that was created using an identity field. So, to update the table I am using the Microsoft SQL Server Non-Spatial Writer. For some reason though it won't update the table. The table parameters I have are as follows: Feature Operation: Update Table Handling: Use Existing Where Clause: **Set to the unique fields necessary** Insert into identity column: Yes Is there anything else that needs to be set to update a record?

Hello, I am loading citygml data with the OGC Citygml Reader and afterwards I want to calculate the normal vector of each roof surface. How can this be done in FME for a big data set? Using the SurfaceNormalExtractor I get some errors that result in stopping the calculation. After sorting out that surface I have to restart the reader and the surface normal extractor. Is there a better workaround? Thank you for your help in advance!

I have a dataset with 29m polygons some of which have the same attribute (say Key ID). I need to aggregate them by the Key ID but the dataset is not ordered. After nearly 12 hours of run time it has only aggregated 1.1m features. I need to find a better way of aggregating. Any ideas? The data is being read from about 10 shapefiles as the source data. I have access to Postgis if that would help.

I am trying to find out if there is a way to label some line features (lets say some streets or rivers) so that when I write HTML file to see directly these labels (like we label features in any GIS Platform e.g. ArcGIS). My solution so far (look the image below but I am not very happy with it): I used "Labeller" Transformer and then "TextStroker" but not very hapy since text stroker gives text outlines which is not very nice to see and therefore I dont have a lot of control over font style, font size etc. Any Idea ? I am using FME 2022.0.0.1.

I've search quite a bit and can't seem to find an answer. Why would a log file not get created? If anyone has any ideas, I'd appreciate it. -Kurt

Hi, A question closely related to this older post: https://community.safe.com/s/question/0D54Q000080hE6vSAE/workspacerunner-how-to-catch-all-items-created?t=1657893646062 I have placed a WorkspaceRunner in a Custom Transformer. The WorkspaceRunner is set to Wait for Job to Complete. With the suggestion from the older post, I have placed it in a custom transformer so it can run multiple jobs in parallel but still is able to wait untill jobs are completed. Parallellism is set to Moderate, so 7 threads can be used on my machine. I can see the first 'batch' of 7 results being send out of the custom transformer. Later I can see the next 7 results being send out. But immediately after, it's not longer waiting for the other 115 Jobs to finish and continues. I have tried to prevent this by using a FeatureHolder and a Sampler (Last), but no result. Flow should only continue after finishing all 129 features. Any ideas? In the older post there was a Python suggestion of @Takashi Iijima​ , but I a

I have DGN file. In Microstation I can see that it had a defined GCS (ETRS89 / UTM zone 32N) When I read the file with FME the coordinate system is not recognised. How do I get FME to read the GCS details?

Hi, I have a shapefile with municipality polygons and I am using the SpatialRelator with the option "Requestor Touches Supplier" to count the number of neighbours of each polygon. However, I need to know the lenght of each common border for all polygons. Is there a way to output that information? In QGIS is posible (as explained on this link https://spatialthoughts.com/2020/04/08/calculating-shared-border-lengths/#more-962 ) but it's not very fast to run, therefore I would like to do the same in FME. Thanks and best regards Oscar

I want to mosaick 188 netCDF files into a single netCDF file. I get the error NetCDF writer: Failed to end definition. The error was 'NetCDF: One or more variable sizes violate format constraints' The data is a DEM, so only one band which is elevation. I have attempted both "Classic" and "64-bit Offset" Parameter What am I doing wrong?

Hi, I want to run some Rscript and so installed an R-interpreter and installed some Libraries. As a test case I downloaded the workspace from a rather old article "RCaller: Ins and outs of using R in FME". The workspace is from 2020 though so i ran it on both 2019 and 2021 versions but it returned the same error in both cases. Actually the exact same error as mentioned in the article itself: "Failed with exit code 1 when executing R script. Output was: Loading required package: gsubfn.......". Now the article mentions to check spelling but as the workspace is an exact copy from safe I expect that to be tested and ok and furthermore that is just not the issue as the line "fmeOutput<-data.frame(meanEst,meanAct, r2, m, k)" in the Rcaller works just fine if I just pick one of the columns for output, irrespective which one. e.g. "fmeOutput<-data.frame(r2)" But the moment I comma separate a few data frame columns for output I get the error. Any help with this appreciated. All the best, Robbe

Hi, I am creating contour lines and contour polygons from a raster geotiff file with 50m intervals. In lowland areas near the sea a lot of tiny lines/polygons are created wherever the elevation fluctuates around value 0-m. GDAL has a parameter (Offset from zero relative to which to interpret intervals) which allows setting an offset so as to reflect only significant low elevations (by setting it to -5 for instance). However this parameter is not present in the ContourGenerator transformer of FME. Can you think of a workaround for simulating such behavior? Otherwise is it easy to call the GDAL function from within FME? Thank you! Best regards, Olivier

I have a workbench that takes a zip file as a user input and checks if it contains a shapfile. If it does, it goes to a FeatureReader and then on to a shapefile writer. I have tried every setting I can, but I can't get it to generate an output shapefile if the shapefile writer is set to use a Dynamic Schema Definition Am I missing something, or is this just not possible? The log says the workbench ran successfully, but no shapefile was created: > Translation was SUCCESSFUL with 9 warning(s) (353 feature(s) output) >FME Session Duration: 3.1 seconds. (CPU: 0.6s user, 0.8s system) >END - ProcessID: 940, peak process memory usage: 116280 kB, current process memory usage: 111672 kB >Translation was SUCCESSFUL Ultimately, I'd like to publish an enhanced version of this to FME Server and create an app so that colleagues can upload zipped shapefiles and have convert their data to different coordinate system. I'm running FME Desktop/Server 2021.2. Thanks, Dave

Greetings, I have a Feature Reader transformer, reading a list of dwgs. Sometime after I initially created the Feature Reader I needed to expose additional attributes, and so did by adding to this list... ...however, the newly exposed attributes are not showing up in my output ports. I'm not seeing the Feature Reader in the 'Update Readers' command, so am not sure exactly how to get the newly exposed attributes exposed. Any pointers would be appreciated. Tyler FME WorkBench 2021

I am trying to convert a CAD file in GDA 94 to a CAD file in GDA 20. But it is creating the output CAD file of very less size around 12 kb. Please suggest.​

Good day, I'm using FME desktop to create a mosaic dataset of some imagery in a file geodatabase. In the footprint attribute table there are default fields "Name", "GroupName", and "ProductName" that are able to be edited in ArcGIS. Is it possible to write this data to the mosaic dataset in FME? Right now I'm populating these attributes in an AttributeManager transformer, but they are obviously not being added to the mosaic. The "Name" field seems to be populated with the basename of the rasters I'm adding I'm using FME Desktop 2021.0 with the ArcGIS Pro 2.8 data interoperability extension.

How to extract Revit Shared Parameters? And how to extend the built-in parameters received from Revit?

Hey! I have a a road network that is split into several features. They represent different values of the road. Example: 1 layer describe surface and another width. So the length of each line in the layers differ from eachother. I would like to merge these together and i wonder if anyone have a solution? So far I've tried to Take the endpoints from all the lines. Bunched them together and then used them in one PointonLineOverlayer for each Line Feature to split all Lines at the same spot. Now I'm unsure on how to join all the features to 1 Line features with all the attributes i want. Example Picture:

On my fme server is a workspace for download which I can start with a webhook. I want to use that webhook in a Python Script. Are there any examples for calling the webhook and receiving the data in python? Best regards Gerhard

I am using Aggregator and HTTPCaller in conjunction with eachother to create an API POST URL and am having issues with the Aggregator output and URL encoding. I'm using Aggregator to concatenate and merge records and am using a separator of "&fee_id=" as the field will end up as part of the query string parameters: The output is correct: But when I run HTTPCaller and view the URL that ends up getting generated in the translation log, only the "&fee_id=" that was added by the aggregator gets messed up. Example: https://TARGETURL.COM?api_key=KEY&amount=2000&PARAM1=50&payment_method=PYMT&paid_timestamp=20220628000000&transaction_id=yna4EcJMDk6gBvcEce0wlg&fee_id=EPVDnnsMl0K9Qj91eyKOWg %26fee_id% 3DXjix%2FpQsd0aKiT9Ikn4aWw I have tried various combinations and orders of the TextEncoder, TextDecoder and StringReplacer transformers to try and force the URL to format correctly, but I'm not having any luck. I've also tried setting different Content Types in HTTPCaller. Anyone have any suggestio

Dear community, I try to write an ifc-file, converted from a dwg file. Simply extruding a block and using the extrude for IfcWall, IfcOpeningElement and IfcDoor. (I am going to add the attributes later). Now the only thing that I am missing is the ifcrelfillselement and ifcrelvoidselement. I followed the instructions given by the explanation on the FME page "Industry Foundation Class STEP Files (IFC) Feature Representation" and the hints given by @dominik​ concerning this issue. But I am not quite sure, where to add the ifc_opening_id and what values to assign to it. Could someone help me out here? Thanks a lot in advance, Morten

I have a dwg in CAD, it doesn't have a projection, I need to convert this to a shapefile, how can I add the British National Grid and move the drawing to the correct co-ordinates?

Hello, I have to update DATE value in XML file and I use XMLUpdater transformer. It works perfect if it is only one date value. I have problems updating date field for coleListValue="publication" in the situation that shows the following example: <CI_Citation> <date> <CI_Date> <date><gco:Date>2006-07-01</gco:Date></date> <dateType<CI_DateTypeCode codeList="myCodelists.xml" codeListValue="creation"/></dateType> </CI_Date> </date> <date> <CI_Date> <date><gco:Date>2014-07-11</gco:Date></date> <dateType><CI_DateTypeCode codeList="myCodelists.xml" codeListValue="revision"/></dateType> </CI_Date> </date> <date> <CI_Date> <date><gco:Date>2016-03-17</gco:Date></date> <dateType><CI_DateTypeCode codeList="myCodelists.xml" codeListValue="revision"/></dateType> </CI_Date> </date> <date> <CI_Date> <date><gco:Date>2020-01-22</gco:Date></date> <dateType><CI_DateTypeCode codeList="myCodelists.xml" codeListValue="publication"/></dateType> </CI_Date> </date> </CI_Citation> I have checked information at

Our team are trying to create a workbench which will be used to answer user data requests. The workbench should provide a packaged export from our Oracle database, including a schema definition, metadata and various file type(s). I'm trying to make this as simple as possible by using parameters for the user to input, including table name and spit out folder at the end however I'm stuck when trying to create a parameter for the table name we want to download using the Esri Geodatabase (ArcSDE Geodb) Reader. I've actually managed to work around this for the metadata by setting a default table, using the merge feature type option and using a wildcard, then setting a parameter from that. However when I try this with features although I get the geometry I get an empty attribute table. Anyone have any experience of this or potential better solutions?

Forgive me for what is likely a very simple answer to this question, but I'm still rather new to FME. I'm wanting to use a defined User Parameter (Type - Text) which will then inform my AttributeFilter transformer (where the user parameter directly corresponds to a specific field of the dataset being read by the AttributeFilter transformer). However, when I set the transformer parameters as per the screenshot below, I don't then get the expected output, i.e. the dataset filtered for that specific value. Is there something I'm missing? Thankyou for taking the time to read this post.