Transformers

I'm just posting this as an FYI because it took me a while to figure it out. If you enable the Group By functionality for a custom transformer it will not, by default, expose the group by attributes on the transformer output. I'm not sure why this is the default behaviour because "group by" attributes are always exposed on standard transformers. Anyway, if you run into this issue, there's a setting under the custom transformer properties to enable this: > Transformer Parameters > Advanced > Preserve Group By Attributes

I have a workspace that grabs the last two weeks' worth of sensor data that resides in SQL Server. It's about 90k records that go into an excel spreadsheet. The end-user has requested the ability to set the start and end dates before the data download process kicks off in FME Server. Rather than reinventing the wheel, I figured I'd throw it out here for some help. Any ideas would be greatly appreciated.

Hello, I have dimensions in autocad file but when i put the parameters in my transformer (i don't have arrowhead) : In file atuocad i have this dimension : but after transformation in ArcGis i have that : It's not ok because the dimension it's not a good place. I change parameter but it's impossible for me to resolve the problem. Can you help me please? Thank you

I would like to transfer a layer with a number of adress points to the building polygons in which they are located. For each point I would like the corresponding polygon of the building. With PointOnAreaOverlayer I got the attribute data of the polygons, but how to replace the point geometry with the existing polygons of the buildings retaining all the items (no aggregation)?

What is the logic of saving individual object types from an IFC file to the resulting geodatabase feature classes? I am asking because lines are also created for some types of objects with solid geometry. In addition to the multipatch object class, a nonspatial table is also created. No nonspatial table is created for the following object types: IfcGrid, IfcSite. What it depends on? How does FME map geometry from IFC files to feature classes? Regards, Aneta

Hi All, I am trying to migrate Dimensions from AutoCAD to ESRI. But while doing so, i get an error "An error occurred while attempting to set the 'DimensionShape' property on the 'IDimensionFeature' interface for the dimension feature class 'PD_ServiceDim100'. The error number from ArcObjects is: '-2147220936'. The error message from ArcObjects is: {The coordinates or measures are out of bounds.}". I have assigned the coordinate system in dwg. I have tried by normally migrating the Dimension as well as re-projecting the same, but am getting the same error. To test, whether the coordinates are correct or not i placed a point feature in the same and was successfully able to migrate (without reprojecting) it to a point feature class in GDB. Not sure, whether any attribute is creating a problem for Dimensions. Any ideas ?

Hi, I have a an IFC file that represents a bridge. The IFC file also contains damages wich are shown as openings in the bridge. I need to convert this file into a Caesium 3D tiles file. I thought that I could just read the IFC and write into Caesium but this did not work. I did some reasearch but did not fin anything for this problem. I did find a tutorial form IFC to CityGML and there they used a Triangulator. So I added a Triangulator between the Reader and the Writer and it worked. But the damages were not shown as openings. I looked at the parameter and it made no difference if "Subtract Opening Geometries" is set to Yes or No. I tired a CSG Builder with the difference output (with and without a SolidBuilder before it) but that also did not help. Does anybody know how to selve this? thanks for any help

I need to know the source of the duplicates (FME feature type). I've try a duplicate filter but it's doesn't work. Thank you for your help.

I'm getting confused when writing to a gdb with regard to feature operation parameters. The options are Insert, Update, Delete, and fme_db_operation. What I am looking to do is write only changes. Add rows if required, subtract rows if required, modify rows if required, and no modifications to unchanged rows. In other words, compare tables, then update only changes. It is not clear to me in the documentation that any one parameter does this. Let me know. Thank you, Tyler FME Workbench 2020.2

Where can I download a sample workspace and dataset to convert Autocad DWG files to PostGIS?

I'm trying to use PythonCreator to process and Analyze some data, and my results are in a Pandas DataFrame. There's any way to convert that table to features to use in FME? Thanks for your help

I would like to use FME to handle an execution plan from MS SQL. The `SET SHOWPLAN_XML ON` function has to be run in it own batch. The normal way would be to us the `GO` operator, however this is not part of t-sql but is interpreted by the sqlcmd and osql utilities and therefore the FME SQL interpreter does not understand it. I've tried running it in one SQL Executor transform followed by the query in the next SQL Executor, but each transform seems to create it's own connection. This means that the settings don't persist from one transformer to the next.

Hi Is there an easy way to add a custom transformation with Helmert-parameters to features in FME? Ie A0,A1,B0,B1 - parameters? I have looked through MyCoordSysDefs.fme and articles describing this however it would be nice if there was a Transformer that you could use for this.

I have"year installed" values (1999, 2011, ...) in a CHARACTER field. I need to get that data into a "date installed" DATE field. Best would be YYYY only in the date field, but I could work with YYYY/D/M if necessary. Is that possible?

Hi, I have extracted the list in JSON file to an excel file using ListExploder. However the result didn't come out as expected: Any suggestions on which transformer can I use to get the expected result as attached: Thank you in advance.

Running FME desktop workspaces seems to cause errors in the path locations for custom transformers when located outside of the root transformer folder.

Image attached

Hi I am running a workbench to update a single field in an existing table. I have the following settings: Feature operation: Update Table handling: Existing Match Columns: Set to two fields that identify the record to update I have an attribute manager before the writer to only show the field I want to update and the match columns. Therefore, those three columns in the writer have the green indicator and the rest are red as they are not connected. My question is, will this writer write to the match columns too? I know by definition of them being match columns, it will only overwrite with the same value, but I would prefer it to leave them alone altogether. Is this possible, perhaps if I remove the match columns in the User Attributes tab, is there another way, or should I just trust it and leave it as it is? Many thanks

Hi I need to add a field to a SQL table as the schema has changed. However, all the instructions indicate I need to drop the table. As there is data in there already, I cannot do this. Is there a way to add the column in FME, or should I just go into SQL Server Management Studio?

The most recent info I have been able to find is from 2017, do later builds have a solution? The methods I have seen so far: Call 7 ZIP and extract the archive Convert to html use a pythoncaller Pythoncaller is probably the simplest solution, but I would like to try and achieve this using native FME if I can, as this is a training exercise in the software. https://community.safe.com/s/question/0D54Q000080hDL7SAM/read-microsoft-word-file

Hey community! How can I fusion differents DEM togheter? I need to merge a DEM for trees with other DEM

Dear FME Community, I would like to create a mesh from a xyz-pointcloud. Does anybody know what settings I could use so that it looks nice and just like the original point cloud? Any help would be greatly appreciated! With kind regards Christian Lendl These are my settings at the moment. The mesh looks like there is a hill, but in the original point-cloud there is no hill... here you can see the preview I get from the original point cloud. There is not much elevation in the back.

Hello, I have consecutive Oracle LRS geometric segments in several locations that I would like to concatenate (see attached or the description below). First LRS Geometric Segment : from distance a1 to distance b1 Second LRS geometric Segement: from distance a2 to distance b2 with a2=b1 Third LRS geometric segment: from distance a3 to distance b3 with a3 = b2 ...Nth LRS geometric segment from distance an to bn with an= bn-1 I'm able to write a query to merge all the N geometric segments and to compute the distance from (a1) and the distance to (bn). How can I create the corresponding LRS geometry which will be the concatenation of all the touching geometry segments in the right order?

Hi Is there a way to have the AttributeRangeFilter create the Output port names in a new attribute that's called like '_attrRangeFilterOut' and the values being whatever the name of the output port is? So instead of having the AttributeRangeFilter followed by a bunch of AttributeCreators which basically sets the new attribute 'range' to the value that's similar to the output ports of the AttributeRangeFilter, is there a way to just have the AttributeRangeFilter do that for us?

Hi FME Community, I've recently been given quite a big task of migrating, renaming and sorting documents. I have naied the moving and renaming part by using a mix of FME and SystemCaller for Robocopy (as FME would output the PDF files as folders, for some reason). So, the moving is all good, but is there a way I can use FME (as I am quite constrained by my working environment, such as python being stock and FME version) to say - "if a file exists in folder A, but also exists in subfolder X, delete the file in folder A" I've tried with a DuplicateFilter, which gets a few, but misses others (attached screenshot). Been going mad with this one