FME Form

Hello friendly FME Community! I'm trying to implement a GeoFencing service which will calculate the time spent by vehicles in particular areas. In short, I have a set of points (with timestamps) and set of polygons (geofences) against which I want to calculate how long these points were inside these polygons.  I did make a workspace which does this using SpatialFilter (which identifies if points were inside polygons) StatisticsCalculator which calculates min and max timestamps and DateTimeCalculator which calculates the interval between this min and max timestamps. The problem is that vehicle can move out of all polygons and then get back which will distort the calculation as the period that vehicle was outside the polygon will be included because last timestamp will be inside the polygon. Is there any trick or technique in FME which allows to follow up these gaps and exclude them from calculation described above? Thank you in advance for any suggestions!

I have a few AutoCAD drawing files (.dwg) that have a number of 2D and 3D lines and polylines. My goal is to extract all the vertices of each individual line so that I can store it within my GIS database (PostgreSQL). Additionally, I want to extract the layer name and a few other attributes.  Is there a way to extract this data and convert it into a Shape file (.shp) ?  Cheers

I am unable to find online if FME can read data from Power BI. We currently us an SSRS to pull data from multiple sources and write them to a xls file. According to our developers Power BI can't write an xls file the same way so we were wondering if FME can reach into Power BI to pull data out as a reader in the workbench.

Hi, I have a scenario with a random string test; "Häradålderön" which my goal is to se the result to "Haradalderon". Basically replace any [ä, å, ö] with [a, a, o] letter.  I guess using regular expression could do it, but I find it tricky since it might be three sequences to search for ä, å, ö. Any ideas appreciated!

I would like to write some messages to the Log, at the end of a successful Translation.For example, the source schema & table name and the destination schema & table nameIs there a FME Transformer that can write a user parameter to the Log? With some surrounding text?

I am trying to get the result when both "insert" and "unchanged" have values, but if one of them doesn't have a value, it's going to fail. Can anyone please help?

Hi. I aim to reproject the coordinate system EPSG:25832 to a metric coordinate system. Which destination system do you recommend?

Hi everyoneI wanted to know if there is any workflow I can do to convert my points cloud to Cesium 3D tiles and I wanted to be also georeferenced ?

This is my first time using FME to update a database, I usually just write to another file.  I have connected to a specific table in the database (multimedia objects) and I've basically filtered and done a string replacer on some instances in a specific column (product_uri).  How do I now save these changes in the database? I just want to replace the 156 cells I string replaced and keep everything else as it was. 

Hello, I asked the above question in the New To FME forum, but no takers. Lets see what happens here. My goal is to join CAD wall lines that are collinear and have a gap where the door is located (usually 36"). The LineBuilder does not have a conditional option.  Two ways I can think of pursuing are:Group collinear lines that have a gap of 36" between end-point of one line and start-point of another. Lines have all been changed to a positive vector, so end-points are followed by start-points on X or Y axis.Use the CAD Door layer to locate prospective lines. These door symbols are blocks with an insertion point at the hinge. Very standard. Here is a screenshot, attached, of a typical hallway. There are large gaps which should be ignored and others that are approx. 36". On the left, you see two door setbacks. It is not a problem to separate horiz and vert lines if needed. Any help is appreciated. Thanks,@larue

Hello, I think the answer is easy but I don't know how to do. For each fme_basename value, I want to copy the B3 cell value to the B1 cell.Thank you !

Hello FME Experts that are far smarter than me, I have a very interesting text file that I need to isolate columns for to map points via lat and long values. Below is the URL to the dataset, it relates to fire weather conditions that are updated daily. https://www.wfas.net/images/firedanger/fdr_obs.txt I need to isolate the Colorado-related records and put all the values into their designated columns. If I use the standard text file reader, everything is mashed into one column (see screenshot). I tried using the CAT Reader, but can't seem to get that option to the right place. Does anyone know a better Reader or combination of Transformers that could help delineate these columns of data? 

Good morning, I'm trying to achieve the following: Read DWGs from all folders one level down but no further sub directoriesCurrently have: Directory and file pathnames -> tester (= dwg) -> tester for depth = 1? Was previously using a wildcard but it was going to far into directories and picking up a lot of irrelevant files. Thank you for your help.

I would like to input only 1,000,000 features at a time from a single 60,000,000 feature dataset (Parquet) to a workspacerunner. Can I use featurReader for this? I could select features based on attributes (dates or names) but I cant proces the data per tile or a spatial filter.

KML output written in kml_schema_data,I am not able to write in kml_data as shown in expected ouput image    

I attach a visual example, from the visual preview, I want the blue tick row to merge/duplicate the attribute while the row with the yellow mark to keep the attribute value from the original value. Any help or guide will be appreciated. Thank you.

Hallo ,i have read an article about RMinimumSpanningTree . will be possible that someone provide me a sample workspace to understand it clearly . Thanks in advanceFME 2021

In earlier version this error did not acccur

I have a workspace that outputs fewer features when run from Server than when it is run from Desktop. The log files are ~2700 lines long so finding out exactly where they differ from each other is quite hard. I would like to feed the log files to a diff & compare program like WinMerge but the number of inconsequential differences between log files are too high. Even after removing timestamps I'm still getting hundreds of differences. How to search/parse/transform/rewrite the log files so only the notable differences are apparent? For example it doesn't matter that the path of DLLs are in different locations (in this scenario, in others it will be). It also doesn't matter that hundreds of HttpCaller download requests differ by a few milliseconds and/or 1 byte. However it very much matters the total number of features written is 2654 instead of 2658. 

I am trying to load ArcGIS Pro Annotations which in the source system have also Leading Line. Annotations are successfully loaded into the FGDB, but, although I populated (hopefully correctly) all geodb_text_leader_line* attributes, Leading Lines are not visible.Does anyone have maybe working example on how Annotations containing Leading Line should be loaded in ESRI GDB?

Hi, I have a question regarding the “create spatial index” option in the spatial database writer for Oracle.If you’re truncating an spatial table with an existing index. Do you still need the create index option on or is it redundant? And if not, is there any performance loss in keeping it on?

Hello. I have created some geometries (using Bufferer and Extruder) from 2d coordinate points. Can anybody let me know how I can export them as IFC Geographic Elements in an IFC file?

Hi , I have geospatial pdf has coordinates and I have shape file with other coordinates . i have read the pdf file with reader geospatial pdf and i can see that it has many layers and some data at pdf does not exist in my shape file and some exist  i would like to change coordinates of geospatial pdf to same coordinates as shape file .How could I achieve that ? the shape file consists of lines and polygons (Buildings) and points some of buildings and lines ,i can find also at pdf file but in other coordinates .it locates far away of each other . i have used pdf reader ,parameters coordinate page point and enable non spatial read meta data objects ,Map frames The type coordinates of geospatial pdf is unknown for me .which transformers could be useful to move geo pdf to same location of coordinates as shape file ? i am thinking if there is any transformer to compare between shapes and find which polygon is exact as other then provide shape coordinates to pdf file fme 2021

Hi Team, I have a electric lines and electric devices . I want to split the lines where the device exist . I used the point on line overlayer with 0.001 tolerance . But its creating many new lines with 0.001 feet (less than a feet) lines .Ideally this shouldn't be . Its creating the issues when building the Utility network . can you please help me on this ?