FME Form

I have a CSV file that looks like this:- ID,X_COR,Y_COR187347635,335375,369977185565488,282016,438601185768788,281568,438584 FME has classified the X_COR and Y_COR columns as time? I lost hours of work by not spotting this and getting mysterious geocoding errors.  I can't see an easy way to override it in the Reader and it doesn't make sense to me to have the time classification?  

I'm currently working in FME 2021.2 and trying implement a workbench that can do some dynamic filtering, etc by using a user parameter that defines which fields to act against. The workbench reads in zipped shp file(s) that can have different schemas each time it runs and I want to use a parameter to define which fields I wish to analyse. I can successfully get it to work when one field name is entered but never with 2 or more.Does anybody know what the parameter type should be (eg. text) and what format the field names need to be entered as (eg. VM_STATUS,R20AH or VM_STATUS R20AH)? When 2 or more fields, only 1 feature is returned. I know for a particular datasets that I should expect 207 which is what I get by manually selecting the fields when the data is cached while debugging the workbench. Thankyou for any time spent looking at this

I'm struggling to understand why I get different results for what should essentially be the same transformers. I created a set of sample data and workbench to demonstrate my question.  Using NeighborFinder I'm getting points about 6 miles away from my test point. Using the same test point and using GeographicNeighborFinder I find the correct nearest points only 5 miles away. Since all my data is in same LL84 I don't understand why NeighborFinder isn't giving identical results.  I'm asking because I eventually have to run millions of features and GeograpicNeighborFinder is nice but has a lot more overhead and will take much longer to complete. I don't need the extra features if NeighborFinder would give identical results.

Last week I was contacted by a colleague to process a text based dataset that reminded me of something I had seen in the past for Fortran based datasets.  In particular, the text based dataset looks somewhat like a CSV dataset, only now columns are separated by a fixed width. See below for an example of how it looked:I was wondering if there is maybe already some type of reader that can deal with such type of data? Of course, if you get such a dedicated dataset, you can use a text_line reader, cut/split the text line into separate features (based on the known width (e.g. using a '#s#s#s' format string in an AttributeSplitter, see third example on the

I'm trying to output CSV files to Word or PDF. Formatting issues... not sure which transformers to use and what settings to use... Thank you in advance!!!  

I want to use the RasterCellCoercer to polygonise a raster. I am using it in favour of the RasterToPolygonCoercer, since this one is running out of memory constantly when dissolving. So I would like to write the raster cells as polygons to a PosgresDB and then ST_UNION them.However, on the RasterCellCoercer I am unable to retrieve the band values. There is only one band. The _band{}_value field is always empty. When I use the RasterToPolygonCoercer I get the expected values.Could someone give me a hint on how to solve this issue? Thank you in advance!

A while back I developed a workspace in which I wanted to calculate the 'outsideWallArea' of buildings. That is, whenever buildings are directly next to each other, the touching wall that they both share, shouldn't be counted as an outsideWall. So for example, consider these 3 buildings (cubes with sidelength of 1);Now both building 1 and 2 would have an outsideWallArea of 3, and building 3 would have an outsideWallArea of 4 (note, the floor and roof do not count as wallArea). For this purpose, I used a SurfaceOnSurfaceOverlayer on the buildings. In this way neighbouring buildings fall apart in individual IFMEFaces, and by using the _overlaps attribute neighbouring walls can be excluded from the (outside)WallArea. The 'problem' now is that disjoint buildings are not overlayed to other buildings, and these keep hav

I have a large postgres database with over 100 layers. I would like to know how, and if, the indvidual layers relate by a shared attribute. For instance: a river will have an attribute with the county-name it flows through. However, the county will not have an attribute with the river name (but wil have an attribute with it own name). Both will have a completely different geometry obvioulsy. I am also not interested in creating that attribute (using spatial relator). I just want to know which features share which attributes. Since the dataset is so large I can not use the matcher since I will not know beforehand which attribute might match. How would I best go ahead to try and find these relations?

Are there possibilities to do an automatic texturing with oblique aerial photos in fme? Ther eare some software like CityGrid or RhinoCity who can do that. They only need some parameter regarding orientation of cameras. We have an production workflow for CityGML buildings in fme and we would like to texturize within the workspace or by implementing existing functions or something else. Does anyone know if this is possible by using FME?

Can somebody please confirm that I'm understanding this correctly:https://knowledge.safe.com/articles/23883/working-with-geodatabase-subtypes.htmlLimitationsAt the time of writing, FME will not allow you to associate different domains based on a particular subtype. For instance, you would not be able to set range domains of 0-50,000; 50,000-100,000; 100,000-250,000 and apply them to a subtype definition containing the values of Small, Medium, and Large. In order to achieve this, you would need to create the domain:subtype relationship in ArcGIS.In our database (ArcSDE 10.3.1 w/ Oracle 12c) we have a feature class which has a subtype field and within each subtype there is defined a different domain for a "subclass" field. I want to be able to resolve the subtypes and domains (both in and out of the subtypes) but the above para

Hiwindows 10, FME desktop 2020.2.5 I installed scipy using pip"fme.exe python -m pip install numpy --target C:\\Users\\<user>\\Documents\\FME\\Plugins\\Python\\python37 " I check numpy version and it says 1.16.5 using pip list in commando prompt. But when I run the script in FME desktop it saysERROR |C:\\Users\\<my username here>\\AppData\\Roaming\\Python\\Python37\\site-packages\\scipy\\__init__.py:149: UserWarning: A NumPy version >=1.16.5 and <1.23.0 is required for this version of SciPy (detected version 1.15.1 UserWarning) But the only version of numpy that i have installed is 1.16.5.  Any suggestions on how I can fix this problem? 

I have a workspace that has two SQL Executors connecting to an Oracle database (the same database connection). In between there is processing that happens. It appears that FME is keeping the oracle connection open from the first SQL Executor for the entire duration of the processing, and using the same connection when it runs the 2nd SQL Executor. This is causing a network timeout error to occur. To prevent this I have tried unchecking the Persistent Connection option in the 2 SQL Executors, but still get the same behaviour.  As a test, I have logged the oracle session ID from the first SQL Executor to the log file, and in the 2nd SQL Executor I have logged the session ID and session duration. Both session IDs are the same and the session duration is the entire running time of the workbench. See attached screenshot for workbench, the decelerator is to simulate processing time.  So to summarize, the Persistent Connection check box doesn't do any

I'm creating DEM rasters (1m cell size) from Lidar using RasterDEMGenerator. Then Hillshades from the DEM rasters using RasterHillshader.I'm getting hillshades that look like stacked contour layers.I believe the hillshades "should" be smooth surfaces (especially Lidar surfaces) so I'm not sure what I'm doing wrong.I've attached my model and sample output.

My Data moved from Network drive A to Network drive B.Is there a way to mass change the Source Paths from the Readers in multiple Workbenches at once or do i need to open every Workbench and need to change it manually?

Hİ,I have one las file and all point cloud data is in one class. How can I classify this las data and export only ground data from it? 

We'd like to publish the /fmerest/v3/ API in an API Manager.It's well documented and structured here:https://docs.safe.com/fme/html/FME_REST/apidoc/v3/index.html#I was wondering if there's also a OpenAPI definition of the services.

Hello, i have an e57 file with size over 100g. It contains 50 pointclouds and 300 raster. So i wan to reduce the point cloud size .I've 2 questions​ I'm not sure if my workflow for this is correct. Cloud someone give me advice？In transformer "Writer" exits much options, i'm not sure the one i've choosed enough to export and save the minified file Thanks in advance​

I have a file in format of .e57, it contains point cloud and raster.I plan to firstly reduce the number of points and export again as e57 that also contians raster and point clouds.​After processing the point cloud data is there 2 options in transform Writer: Raster, Point cloud. ​Which one should i choose? Or can i just export the raster and point cloud separately(like the picture below), and then open these 2 data file in FME Inspector at the same time and save as format .e57?​Thanks in advance.

i converted my shape file to tiff which is basically a road layer of an area. That shp contain a name attribute which shows the road names. I want that name to display on tiff image. Pls guide me  

Can i Convert my shape file to tiff image with geo location ? Pls guide me . 

I have created a workspace with the help of Mr. Takashi(a person from this forum) that reads the shapefile ,creates buildings then these buildings are separated in storeys and then the storeys are separated in roof,ground and wall surfaces. All this work is attached.I want to find a way to write this information in CityGML (Lod 2).In conclusion i want a workspace that gives me a CityGML writer with the buildings.

Hello everyone, So I have a workspace, at the end I will output the HTML result by using HTML transformer. For my html report, I would like to have my writer naming: input file name + _level For instance, if the input file is: abc.geojson, the output file is: abc_level.html I tried as the figure below, yet it is not working. Could someone please give me guide on how to make it works. Thank you and sorry for soooooooo many questions recently. Zach

I can set up a zip file extractor with a user parameter but how do I then connect it to the reader to have it extract the shapefile from the zip file?

Hello,  I am a basic user of FME and have created a workbench merging many tables. I need to add a further table, but before I use the FeatureMerger I need to specifiy a WHERE clause on the reader. I have tried doing thison the reader with no joy. I have also tried with the FeatureReader and no joy. I cannot find any help documentation in the reader to help me with syntax. Is there a simple transformer I can use?  I need a very simple clause to pass only certain attributes from one of the fields into the next transformer.  Can someone assist please? Harriet