Transformers

Hello,I'm trying to georeference some non-geospatial PDF files. I have the corresponding GEOTIFF and a shape of the desired bound for each one. I need a PDF output in CMYK and a reasonable file size (that's why i'm not using GEOTIFF directly in the first place).Here is what I have tried so far:1) replace the boundingbox geometry of the pdf by the shape, but the pdf bondingbox get rejected2) use raster georeferencer with known upper left coodinates, but I don't know how to find the appropriate cell spacing, and using raster is part of my problem (as explained above).Any ideas ? Thanks

I have an axis-aligned sphere and a plane that's rotated. Both have the same origin point. I want to rotate the sphere using the plane's RPY (in degree) attributes using the 3D Rotator, with Origin XYZ equaling the plane's XYZ, and the Direction XYZ = plane PRY. The rotation (for which I use the plane's R) works, but neither in the right direction or by the right amount. I tried switching the values around but so far I can't get it to work. Here's an illustration (current / goal): 

Hello,I would like to count the amount of cells that contain a value for each row in my dataset. It is basically the COUNTA function of Excel. But I don't know how to apply it in FME. I have a large table with 100+ columns which looks like this:DBKAlCaClPbZn10.10.15 1.2 2 0.11  1.330.20.130.41.52.1 Can anyone help me to get the below outcome?DBKCount132235 Thanks in advance.

Hi folks, I'm searching some documentations upon :installation and desinstallation of FME Desktop on SILENT mode and COMMAND LINE mode.can you help ?Regards.

I need to build something in FME where it automatically selects all ID entries and then looks at another column with values and selects the row with the highest value, and delete the other rows with the same ID. in the screenshot i have 2 columns: Risicoprofiel_BEREK and ID, in ID there are multiple entries which i need to select and then find the highest value from the Risicoprofiel_BEREK column. 

Hi there,I am creating a data frame that has two columns i.e. date and time on Python caller (at init function). I used the "attribute to expose" field to display the value of data frame. When I ran the translation, it made the dataframe column in the output but values were missing. I also tried to display the data frame value using column-wise but no luck. Could anyone tell how to add data frame at the output using Python caller?

Hi!TLDR: Writing a 3DS from a IFC with scaling of 0.001 and reprojecting from a local coordinate system to SWEREF99 12 00 I loose model quality, scroll to last pic. Info:I'm trying to convert a IFC model to a format I can use with GIS and Specifically import into ArcGIS PRO / Online. Shape Multipatch writes fine and the quality is there, but file size get big quickly and I loose textures with this writer.  Writing from IFC to 3DS without any other transformers yeilds a good result on my model: This quality pretty much looks identical to my INPUT IFC.If I Scale it 0.001 it also looks acceptable:if I only reproject I can see some small artifacts, why does this happen and can I fix it?

Hi,I am trying to use the LengthToPointCalculator in 3D mode however whenever I run my workflow I get the following warning message: WARN |@Length -- Cannot calculate length to a point in 3D. Continuing using 2DThe line geometry is definitely 3D as I can see the elevations for each vertex in the Inspector. Has anyone else experienced this and if so, do they have a solution?I am using FME Desktop 2019.1Thanks, 

We are converting 100s of DGNs to DWGs. All of our complex shapes (that have an arc as a component of that shape) in DGN are being converted to splines in DWG. We want to drop all splines to polylines, while still maintaining the arc information. Is there a way in FME to do that?

Hi guys,I have three Excel files which need to be converted into a Esri file gdb as three tables.As a schema for each of these tables I want to use three other tables which are stored in a gdb. I imported the last mentioned tables as readers and tried to implement their schemas in the writer of the first three tables using 'Schema definition'.However, I got an error when running the translationI am doing something wrong?

I am running a query similar to below, but FME does not recognise the geometry, at least it does not show geometry in the inspector, only tabular data with my geom column with binary as string? I have also cased the geometry to EWKT and WKT, but I cannot find how I can make FME create geometry from either WKT or EWKT so I can continue with my workflow?select ST_Union(Geometri_SPA) as geom from xwhere ....UNIONselect ST_Union(Geometri_SPA) as geom from xwhere....UNIONselect ST_Union(Geometri_SPA) as geom from xwhere....

Hello,I'm trying to select the polygons that are cut by another polygon (Boundary Box) (polygons that are completely inside or completely outside the Boundary Box polygon are of interest to me). My attempts with the SpatialFilter and SpatialRelator ("Requestor Touches Supplier") all failed. Are there any other possibilities? I have a shapefile as source data and the boundary box polygons are created from LAS files using BoundsExtractor and BoundingBoxAccumulator. Thanks a lot in advance

Hi AllI am working on an electric network as input where line segments sometimes join. The end vertices lie on top of each other. I have used the Snapper and LineCombiner to combine lines where only two lines meet. The LineCombiner transformer can however not combine lines where more than two lines meet.It does not really matter what two lines are combined, although it would make sense to join the longest segments. The line segments all have the same attribute values (ie the same voltage and reticulation name). The reason for wanting this is to make the output dataset as small as possible, as there is so much unnecessary duplication with the attributes for small pieces of line being exactly the same.Is there a way to combine two lines where more than two meets?Hope someone can help.

HelloHow to simply perform a sql operation of union of 2 different database tables ? (not a join)thanks

Hi there, Need a suggestion from FME's experts. I have FME transformation that calculates two fields based on the data coming from different sources. Now, I want to use the calculated field along with some other fields from the data and perform normalization on it. I have already written a script in Python (separately) which performs normalization. The Python scripts contains while loop and comparison operators. Is there any way of calling the external Python script from FME? What do you suggest

I have successfully created an FME Workspace Runner Python script that will launch Workbench (Desktop) and start an FME conversion process. This is an effort on my part to eventually sell the idea of purchasing FME Server. Everything works quite well, with exception to one small glitch. I cannot seem to get the script to automatically retrieve the appropriate files (based on date as per below) to include in the process. Currently, before I run the Workspace Runner I need to first (manually) include all of the files that I would like FME to convert in an FME Reader, but I would like this step to run entirely from the Python script.I think I know where the problem is (see below in blue), but I don't know how to remedy the parameters (if it's even possible).The data in question is referred to as NMEA data (National Marine Electronics Association) and is basically Ship born GPS data that is standard in most GPS units today. Below is an example of the dat

I am using the JSONTemplater with such Root Expression:  {     "Code" : fme:get-attribute("Code"),     "Nom" : fme:get-attribute("Nom"),     "C3" :         [           {             "label" : "2006",             "value" : fme:get-attribute("C3_EII06")         },{             "label" : "2007",             "value" : fme:get-attribute("C3_EII07")         },{             "label" : "2008",             "value" : fme:get-attribute("C3_EII08")         },{             "label" : "2009",             "value" : fme:get-attribute("C3_EII09")         },{             "label" : "2010",             "value" : fme:get-attribu

Hi all,I am specifying the AutoCAD Layer color by a given attribute 'Category' which is being filtered using 'AttributeFilter' transformer and redirected to each DWG Writer to specify the AutoCAD Layer Name and color. All the below DWG Writers are a single DWG Output File. For some reason, when no features are written to some of the above DWG Writer, I still have that AutoCAD Layer Name written as below, even though no features have been past through the attribute filter so I am not even sure why that Layer 1, Layer 100000, etc. is being set.Any help would be highly appreciated. Thanks,Ana

Hello, I am trying to clip polygons which are outside of a shape boundary. Basically as attached image, I'd like to clip/ erase all yellow selected polygons. The first step is working to clip ortho photo and generate polygon terrain from boundaries. But the "left" over polygons in between (with no ortho photo) are the ones which would need to be erased.I've tried deaggregator to get all polygons from the generated terrain and feed into the clippee. The Clipper is the shape polygons from first image. No success so far.I appreciate any ideas.Thanks!    

i used line combiner to join more than segment line and lines intersects with another lineseach line has around seven segment line so i used line combiner to join more than segments of line and also join the next line that intersects.so i have now long line and it is working so nicely but i have still question if i need also to export the id of each line that intersects with next line to make long line .so if 5 lines intersectes in nodes so i need id for each line that intersected with neighbour line.so as example for 5 lines connected i need five lines id plus the whole new id for the long line that contains 5 old id line.really i learned alot from FME Community and from membersThanks alot 

Hi,After spending some times on creating a pointcloud from a 3D Polygon, I realized that the PointcloudCombiner does not correctly interpolate on a 3D Polygon. So the workaround is to create a pointcloud with PointcloudCombiner (Points elevation are WRONG) > Pointcloudcoercer (to multipoint) > SurfaceDraper (Drape multipoints on 3D Polygon).I think that the pointcloudCombiner should handle the conversion or at least write it in the helpsheet.ThanksFlorian

I am using SpatialRelator to merge attributes from intersecting features B, C, D etc onto feature A. The number of supliers varies from 1 and upwards 4-5. My problem is that the transformer only seems to read the first intersecting suplier that enters, and then moves on. Any ideas on how to solve this and merge the attributes from all incoming features? 

Hello, I'm having troubles with exposing FME Feature Attributes with the SQLExecutor. I use the SQL Executor with this statement:And therefore I entered these attributes to be exposed: I would like to add the FME Feature Attribute ‘SAMPLE_NR’. - How do I need to add the attribute to the SQL statement? - And what should I put as ‘Attribute to Expose’? I tried this:With the term SAMPLE_NR or '' or as Attribute to Expose. But each time I get the value <missing> in the SAMPLE_NR column.   Thanks in advance f

Hi there,I have two tables that I want to merge using feature joiner. I am doing a left join. I want all the rows of the left table to come in the output table. When I ran the program, most of the rows from the left table, however, I found that about 100 records went into the rejected output field. When I investigated I found that the column I used from the left table to join has null values and that goes into the rejected output field. Could anyone guide me on how could I make sure that all records from left table come to the output table? 

Hello,  I am attempting to round the xy coords of a point cloud.  I am using a PointCloudExpressionEvaluator.  This is the expression - @round(@Component(x))  But it is throwing the following error;  PointCloudExpressionEvaluator (PointCloudEvaluationFactory): Failed to parse the EXPRESSION_LIST clause. The provided value was '@round(@Component(x))'. Please ensure that your syntax is correct  Round does not appear in the PointCloudExpressionEvaluator in the Math Funtions list, does this mean it is not available?  Ben