Transformers

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

In *.dwg I've got some roadmarkings which I would like to export to fbx. In *.dwg that's a linetype.The roadmarkings are default polylines, How can I get the same view from a dwg in a fbx?Could I for example divide the line into pieces (3m roadmarking, 9m empty, 3m roadmarking etc), and...I would like to have them in 3D Thanks!

Hi all,I'm a newcomer to FME from the geospatial side of things and have inherited a somewhat large model of complex geometric operations (clips, intersects, bounding boxes etc...). On trying to run the model (with data and a workbench that has, supposedly, succeeded in 2018) I always encounter this "data shattering" warning leading to a fatal error.Hit data-shattering case as 55 new nodes were created after phase 7, compared to 2 nodes created after phase 1To resolve the above issue, try setting a tolerance if your transformer has a Tolerance parameterError running translationI believe I've narrowed the problem down to a NeighborFinder operator, and have attached screenshots of the processes leading into it, as well as its parameters. 

Hello guys , iam tired from tryng doing that and i could not get the result that i want .i have many lines and some blocks in the map ,and i want to find neighbour step by step and give each line that i can find new id as temporarly id .when the line touch the block so another lines touched the same block give them new id .so how can i do that tried alot by line divider and neighbout finder but i did not success or by 2 coordinate extractor(tart point and end point ),2 vertex creator also then neighbour finder but i i did not success ,please could u guide me what should ,i need to find the neighbour give new id for the neighbour that u find then continue fom next neighbout to find the next and so on but sometimes map has blocks not only lines.Thanks in aadvance for helping

FME(R) 2019.2.2.0 (20200103 - Build 19817 - WIN64)When clicking on the icon with the magnifying glass, the data is not displayed in the visual preview. The user has to click once more on this icon to get the data source.

I have a line .kml which is needed to converted to shape. And I need to make a relation between "Folder" and "Placemark". I have a common field (kml_id in "Folder" and kml_parent in Placemark). How can I join them ? 

Hi, in the list of the supported formats (https://www.safe.com/integrate/) I can't find CIM XML so I'd Like to know if it's possible to read and write it. Thansk a lot and best regards.

In Source, one feature (2627) to connected features (2626,389,2628,2665 and 2623) snapping same as Target data

Hi, I'm understanding slowly how to use XQuery but I have come across yet another stumbling block. I have an XMLUpdater and I want to replace the contents of the following path with some code:XML Path://group[@id=fme:get-attribute("CODE") @category=fme:get-attribute("CATEGORY")]I'm pretty sure that the above code is not the correct syntax for referencing two variables at once but I can't find any information on how to do this. Any ideas?Thanks,

I have these parameters for database Uploader transformer and I'd like to do the same thing on a python shutdown script so I don't need to have a parent and child workspace for capturing log information. Looking for some python samples to do this with SQL Server. Thanks. 

I was using this question to help with launching workbench from shutdown script but I kept failing.https://knowledge.safe.com/questions/93753/how-to-execute-a-workbench-from-python.htmlThe error message I get is.BADNEWS: FME_END_PYTHON failure class StatusInfo *__cdecl FMETranslator::translate(class FMETValOrderedVector<class ObsoleteString>,bool &,void (__cdecl *)(FME_MsgLevel,const char *),void (__cdecl *)(const char *),bool,bool (__cdecl *)(void *,class ObsoleteString &),void *,bool)(c:\code\fme\foundation\kernel\fmetran.cpp:1369) - class StatusInfo *__cdecl FMETranslator::translate(class FMETValOrderedVector<class ObsoleteString>,bool &,void (__cdecl *)(FME_MsgLevel,const char *),void (__cdecl *)(const char *),bool,bool (__cdecl *)(void *,class ObsoleteString &),void *,bool)(c:\code

 Hello Guys ,i am misunderstanding this point ,i hope some one explain to me what is the difference between group elements by Geometry and Schema numbersi mean when i choose geometry i got lines feature seperately but when i do schema level names i do not have same feature type lines or another names as geometryi have lots of numbers and when i connect with inspector ,what i got from schema numbers i could not find the same amount numbers that i knew it before from lines (Geometry) what is important for me ,lines and polygon too find intersection but when i extract geometry , polygon collections what i got from geometry it seemly not working or misunderstand for me,bcs when i connect with inspector i see nothing so i was thinking to try something else as schema numbers iam totally new in program bu

Hi,I have lines and points near lines. I need to move point perpendicular (vertical) to line and break line at that point. Any ideas?

Hi all,  I try to redefine the outer boundaries of the red and green polygons. As you can see in the picture, they are not up-to-date anymore. However, I have tried different transformers, in different order like GeometryCoercer, LineOnLine Overlayer and a clipper, but the outcome is everytime a mess of lines criss-crossing (second picture), Basically I want to get rid of everything on the 'inside' and just keep the outer boundary of both red and green (or in-and outside of green ofcourse, but then I have another problem with different symbology on both sides...). I don't need any of the attributes, just the geometry will do. I am relatively new to FME, any help much appreciated!  Thanks.