Transformers

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 for any help.

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.  From this prior answer, and linked blog post, it seems that "data shattering" relates to problems of over accuracy, so to speak (?). Though, from from my (limited) understanding, there were no answers to my question there, he

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\fme\foundation\kernel\fmetran.cpp:1369)Here's my code:import sys, os, fmeobjectssys.path.append(r"C:\Program Files\FME\fmeobjects\python37")os.chdir(r"C:\Program Files\FME")r

 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 but iam still trying and i hope someone guide me ,how to find intersection betwen line and polygon from dgn file . somethinfg else i want to know,what is linkage extraction should i mark

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.  

i have output of transformer l , it looks like the above table. in the inspectori want to split this table automatically depends on the amount of cells in ID column .as here the table has only 4 rows but sometimes i got another output with different rows ,but any table has idso i want to divide the output of transformer to many seperated output and each output has his own id with his row bcs i want to do some actions later and connected seperately with some transformer .i need the output looks like the picture as down , but i want to create way automatically whatever the amount of ID ,get me the result output seperately .exactly , i have lines with different id and this is the output as shown above. Thanks for help 

 as you see in photo no amount of numbers get out of polygon so i will not see anything if i connect the polygon with inspector so what should i do ,both of them get from the same file,is that normal or there is transformer should i add before work on it .thanksbut if click inspect on polygon it hows me in display control,ellipses and lines and multi text and points and shapes and text .but if i create inspector and connect with polygon it shows nothing,it does not give me the fme data inspector to see how it looks like ,what is important for me i want to find intersecton between lines and polygon but lines show me amount of numbers on output but polygon show nothing so the ouput is wrong .i hope,i find answer.thanks

@takashiGreetings FME sensei, good to see you're still around! I had a question about a Python script I'm using as a Private Parameter linked to two published parameters to generate log file folders that include the local user and date in the folder name, then generates time/date stamped log files within those folders.Here's the script:# Scripted (Python) Parameter Example # Create log file path with time stamp. import fme, time, os d = FME_MacroValues['Log_File_Dir'] # directory path w = FME_MacroValues['User_Name'] # workspace name t = time.strftime('%Y%m%d%H%M%S') # time stamp f = FME_MacroValues['Folder_Name_Date'] # date in folder name # If the workspace name ends with ".fmw", remove it. if w.endswith('.fmw'): w = w[:-4]  # Create a new folder which has the name of the workspace. dir = os.path.join(d, w, f) if not os.path.exists(dir): os.mkdir(dir)  # If the expected path conflicts with an existing file, # append sequen

Is there any transformers to aid in  MultiPolygons to simple Polygons.  I'm going from ESRI Geodatabase to SDF.  Chris

The equivalent tool to “pivot table” of ArcGIS in FME,    I couldn’t figure out which tool is equivalent to “pivot table” of ArcGIS in FME. I have a layer and I want to rearrange the attribute table in a specific way  The following picture shows my need    when i use the pivot table tool the table is look like this        Thanks in advance  Best

i have numbers in String format but need to translate to numericlike belowOriginal StringNeed to be convert One 1 Two 2 Three 3 Four 4 Five 5 Six 6 Seven 7 Eight 8 Nine 9 Ten 10One Hundred and Fifty Nine 159Five Hundred and Nineteen 519Nine Hundred and Fifty One 951 Two Thousand Four Hundred and Eighty Six 2486 Two Thousand Six Hundred and Eighty Four 2684 Six Thousand Eight Hundred and Forty Two 6842 Eight Thousand Six Hundred and Twenty Four 8624 Eight Thousand Four Hundred and Sixty Two 8462 Thirteen Thousand Five Hundred and Seventy Nine 13579 Thirty One Thousand Five Hundred and Ninety Seven 31597 Fifty Three Thousand One Hundred and Seventy Nine 53179 Seventy Five Thousand Three Hundred and Nineteen 75319 Ninety Seven Thousand Five Hundred and Thirty One 97531 Note: I'm getting value upto 7 digits.

I have the following that worksSDE DATA => Test Filter (Name = Point) > XMLFramenter > Rest works as expected 1 feature coming throughI want to remove the Test Filter and and put an SQL Where clause at the SDE Data level ( Name = Point ) the SQL is valid and 1 feature comes through however the XMLFramenter fails.Looking at the data in both cases for the field that contains the XML data is identical yet it fails in one case and not the other, any ideas?

Folks,I need to scour some file shares with a python script to identify any data files. I would like to exclude 'non data' files and it occurs to me that one way of doing this would be to compare file extensions with a list of format-specific file extensions that are used by FME Readers...The Knowledge Base does list file formats (https://www.safe.com/fme/formats-matrix/ ) but doesn't specify the associated file extensions.Does anyone know if there is a matrix that lists the file extensions associated with each FME Reader?Many Thanks, Graham

HiI am using the R caller for creating a scatter plot with 2 variables and I would like using 2 different colors for the 2 variables. I am using the following function:plot(wells, col = c("red", "blue"))Yet it comes out black!Any ideas Best regards, Felipe Verdú