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, 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, TylerFME 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

HiI am running a workbench to update a single field in an existing table. I have the following settings: Feature operation: UpdateTable handling: ExistingMatch 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

HiI 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 archiveConvert to htmluse a pythoncallerPythoncaller 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 regardsChristian 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? 

HiIs 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

Dear FME community,I'm trying to run the CsmapReprojector transformer to modify the vertical reference and projection system of a LAS dataset.The change of projection system seems to works well, but the change of vertical reference does not. I use a .grd file that I made with a workspace to transform an Ascii Point Cloud to a grd format that would be more suitable to transform it from the https://community.safe.com/s/article/creating-vertical-adjustment-grid-files-for-use-wi help.I can provide this .grd file if necessary (as well as .las test).Do you know if this transform works in a particular way?Thanks in advance and have a nice day.Julian.