FME Form

This is more format than FME related but I want to make sure that FME is not the cause of a problem I have with reading a geopackage. I created a workspace that downloads a geopackage from an API and reads it with a FeatureReader for further processing. The geopackage contains a point, a line and a polygon layer but for some reason all 3 layers have the geopackage_type "geopackage_linestring" and fme_geometry "fme_line" in the format attributes (example in the attachment). I created a separate Geopackage with the same geometry types in QGIS and here FME returns the correct types so I'm guessing the geopackage from the API has some SQLite metadata that is not defined correctly. I already checked the metadata in QGIS but here the layer informations show the correct types for each geometry. What or where could be the cause of this problem?

Is there by any chance some kind of 'Paste as Text' option when Copy-Pasting text (often from online sources) to Annotations in Workbench? Personally I sometimes copy online sources to Annotations. However, I constantly struggle that also formatting is copied. For example, when I copy the following from this FME Community question;and paste it in an Annotation of FME Workbench, the result is;Whereas I would like to get;Is there some option/menu in FME Workbench to do so? I'm looking for something similar to the 'Keep Text Only' paste option in Microsoft Office.

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 ab

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

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?