FME Form

Hello I'm doing a spatial join between a polygon layer and a point layer. For polygons that are "passed" I want to retrieve the attributes of the corresponding points. Wich transformer should I use ?Thanks

I am trying to set up the Startup python script to be able to run a process which taps into Smartsheets API and converts it to an excel, which I then separately read into FME and runs through an FME process. I'd like to have the python code run every time before running through the data processing workflow I set up. I have added my python script, set the interpreter to 3.10 and have installed modules into the Documents\\FME\\Plugins\\Python folder using command prompt : C:\\Program Files\\FME>fmeworkbench.exe python -m pip install pandas --target C:\\Users\\vberg2\\Documents\\FME\\Plugins\\Python . It ran and successfully installed pandas, along with a few other modules I installed after. I am however getting this error when I try to run the FME workspace: Python Exception <ModuleNotFoundError>: No module named 'pandas._libs.interval'. When I look into the folder directory, that file is there.  Am I missing a step, or did I install pandas incorrectly?  Thanks for

We have generated a chart by using the transformer "HTMLReportGenerator".As result we have something like this:Now we wanna color each data point inside the chart differently. Something like this: In fme I can only choose one color for the hole data atribute!Is it piossible to create different colors for one data attribute?  

I am facing challenge while transforming data from XML. The challenges are while reading an element it gives incorrect format.

Hello ,Will be possible that FME Server integrate with SAP BW ?i would like to deliver the data output of fme to sap bw Thanks in advance 

Hi,  I have a requirement to refresh a materialised view in Oracle database, read the view and then write to a CSV file. Reading of the view should only happen after the view is refreshed. Tried using 2 SQLCreatorsFirst one,BeginDBMS_MVIEW.REFRESH(SCHEMA.MVIEW_NAME);End; Second One,Select * from SCHEMA.MVIEW_NAME; How to make sure that Materialised View will be read only after the view is refreshed? Thankssresree   

Ultimately, i aim to end up with a map where you know depending on your location, where your nearest point is, represented by area.

Dear All,I need a full video tutorial to convert objects on Micrcsation v8i software to Autocad software using FME software?Someone did it, please guide me.Thank you very muchPham ngoc Quang

Hello Sir/ Madam, I have several transformers that I am not quite understand even I checked on the "help". I hope someone can give me a hand. May I ask what is the purpose of using transformer "Creator"? I often use "reader" to add the data. However, I saw other people use "Creator", may I ask why?What is transformer "GeomtryCoercer" does? It said to reset the geometry type, what does it mean?How about "Aggregator" and "Deaggregator"? does it mean to combine and separate data? Thank you.

SFC (Scadec Feature Comment file) files are used to store CAD data and are included in the SXF (Scadec data exchange format) format of the CAD data exchange standards.

I'm using the TopologyBuilder with default settings to create linkage in an ESRI sourced water network - mainly because there's no node-to-node connectivity like there is in Oracle.Generally its working well but has thrown up an anomaly. The transformer has created the edges of a line which should be two adjoining mains at the left and right edge, but instead the left edge is showing as joining to itself. In the picture the highlighted main should be showing with a left edge of edgid 83360 and the right edge of edge_id 83331. Instead the left edge is 83391 - which is itself:   Any ideas why this is happening? I have used a snapper and GeometryValidator and there appears to be no issues with the geometry. Do I need to add a tolerance into the TopologyBuilder?Many thanks in advance!

Hello,I want to create simple mesh trees from Point Cloud (LIDAR) in FME. And the closest thing I came to was with the "PointCloudSurfaceBuilder" transformer.Can anybody help me with this, please. The file is the way I want the final trees look like (it seems like it is about 8 piece of pentagon polygons for each tree).And the file is the closest I came in FME.I attach the FME-Workbench file and the input LAS file (and it looks like this ).Best regards,Jonas

Hi. I try to create a HTML report (with Esri Leaflet) with point and polygone on the same map. It's possible ?

100 % new to FME and FME Academy. As a new user I have started my first trail, Integrate Data with the FME Platform. The third Module, Transform Data, has the student connect to a postGIS database, called fmedata at: I have tried this as documented, but get no response. A ping to this returns: Pinging ec2-54-214-172-21.us-west-2.compute.amazonaws.com [54.214.172.21] with 32 bytes of data:Request timed out. Is the database available? 

I use Data Interoperability extension. I try to change the location of the log file, but the Log file parameter is missing from Navigator > Tool parameters > Logging . There is another ETL tool in the same toolbox, where I can see the parameter. Any ideas why is it missing, and how can I make it visible? Thanks.

Hello everyone,For my colleague I would like to convert dgn (V8 and 3D) to a IFC file.I tried based on the following link that converts dwg to IFC. I tried to adjust the workbench from that link to make it work with Microstation (V8), however I am already stuck at the Creating the Space Geometry part. There are a lot of attributes for which I don't know what the Microstation equivalent is and I am not sure whether what I want is to currenlty possible to achieve in FME desktop 2022.For example I don't know the Microstation equivalent of these autocad attributes:Height LongName Nameautocad_entity_handleI was wondering if someone can send me in the right direction

I have a workbench that reads .dbf tabular data and .shp spatial data and writes both to a Fgdb. It works fine if I manually point to an existing gdb but when I try automate gdb creation by exposing the "fme_dataset" and use that for a location and filename, via fanout, it only writes the tabular data. I can get it to write the spatial data but it comes out in another gdb labeled "null."  I'm guessing that since the dbf and shp and not directly linked the writer doesn't see the "fme_dataset" based gdb as an option. I've even tried directly linking the table to the shp with an AttributeKeeper but its still creating a second "null" gdb instead of inserting the spatial data in the "fme_dataset" based gdb.

I am trying to visualize all speed bumps and elevation changes such that there is a height difference every 0.5m in the 3d model.What I have tried: Clip the raster using the clipper, followed by RasterStatisticsCalculator (tried maximum, mean, median) followed by Attribute manager to rename 'band0.max' to 'Height' followed by Feature Merger to join the shapefile to the GEOTIFF. Then followed by Extruder transformer using the 'Height' attribute.  I don't get the 3D roads in 0.5m resolution but rather long stretches of road surfaces. How can I change my workflow to get the elevated roads from the GEOTIFF in 0.5m resolution?  Thanks!

I have a dataset that has multiple records, each with a different types. Each of those types could have any number of records from 1 record to 5000+ records.  How can I write these records to individual files based on a limit of 50 records per file with no more than 10 types? For example: File 1 would consist of:Type 1 = 10 Records,Type 2 = 37 RecordsType 3 = 13 Records File 2 would consist of:Type 3 = 50 Records File 3 would consist of:Type 3 = 5 recordsType 4 = 45 records and so on... and so on... I've tried groupers, and I have tried building lists, I've also tried the modulocounter, but I can't seem to find a way to build this criteria with any of those. Any help is much appreciated! Thank you! I've built a sample set of data that could be used to do testing. My final output needs to be no more than 50 records per file with no more than 10 Circuit ID's in each file. Please help! 😁

I'll be the first to admit this may be a dumb newbie question, but I'm struggling! I have an input field that contains a file path like the following:q:\\staging\\incoming\\1930s\\WI\\Sauk\\1937\\Sauk_WI_WU_11_908_19370707.tifI need to construct a URL to the file as referenced in a URL, and dump it into another field:https://server.com/1930s/WI/Sauk/1937/Sauk_WI_WU_11_908_19370707.tif My conceptual approach has been to use string processing to replace q:\\staging\\incoming with https://server.com, and then replace backslashes with forward slashes. Well, you can see where this is going... the slashes and backslashes are wreaking havoc. For example, I've tried various combinations to escape the \\, like:@ReplaceString(@Value(inputpath),"/\\","/")... but I either get no results, or a syntax notice. Am I even in the ballpark?? I'd love some suggestions on how to approach this issue.  

Hi Guys, Lets assume below shown line has a certain distance , in that I need to generate line from 1.1 to 1.7. To do this can any one help me on this? Thanks and Regards,Prashanth  

Hi Guys, I need to generate values between 1 and 2 ,it includes decimal values like 1.1,1.2... Can anyone help me on this? thanks and regards,Prashanth

We are working with a legacy dataset of scanned images and are moving everything to SharePoint. We discovered these files that have all the document information stored as a title property that is lost when moving to SharePoint. We are hoping that there is a way we can rename these files with the title information using FME. I have tried to expose it using the Directory and File Pathnames reader but cannot find the attribute anywhere.

@nielsgerrits​  I have a road shape file with numerous segments (links), all of which share the same road id. Now the user has provided me with csv data, claiming that this is the bad route from chainage 0.75 to chainage 5.1. In order to highlight the road, I must add another line geometry (a long line) on top of road features. The created line must overlay eactly on top of road. the created line begins at link 1 (0.75 chainage far)and extends to link 9 at a 5.1 chainage. How do I accomplish this with fme? I tried a lot of different things, but none worked. Actual line length and chainage length are two different metrics. We can take the proportionately dividing road length since chainage length is accurateWhat I mean is that if the real length of the line is 1.5 km and the start chainage and end chainage (attributes) difference is 1 km, then it becomes 100 m = 150 m in geom length. sample source shape file attachedand source shape ,desired output line, how it looks like( jpg files)