Transformers

Hi everybody,I have problems to show geometry after SQL statement.Inputs:-PostGIS public database: geometry (polygons) & table I am using the SQLCreator transformer and my query (SQL Statement) works properly but in Data Inspector only the table result of my query is showed but not spatial elements.I´ve tried to use 'GeometryExtractor' in order to extract the geometry column, It does but neither shows spatial elements. Any idea? I don´t know what I am doing wrong?Thanks,Juanjo

Hi,  I try to make lines from points to the nearest polygon. I used Counter as unique ID for the points, and a geometry remover because I thought is necessary to obtain points from the vertex creator. However, it still does create lines. Also the result I want (LineBuilder) are obviously weird. Whats going wrong here?  Thanks! 

Hi.I originally had some issues with 2019.0 om my home pc with a home license. It crashed every time I added a Tester or a TestFilter transformer: https://knowledge.safe.com/questions/90340/fme-20190-problems.html These problems were solved in later builds, and neither 2019.2 nor 2020.0 crashes like this anymore. However, I just accidently ran into other similar problems with both 2019.2 and 2020.0 (and even 2018.1) on the same pc.Now it's the transformers AttributeFilter and AttributeValueMapper that makes FME crash immidiatedly.And I noticed that the Sorter transformer doesn't provide any attributes for the sort value either.Luckily both versions work on my office pc, but I would very much also like FME to work properly at home. Are there any information I can provide that'll help find the source of my problems ?I did check the "Improve FME by reporting ...", but I suspect it doesn't work when FME crashes.The pc in question is Windows 10 Pro version 1903 bui

I have a working pipe network where I know how many service connections are on each pipe saved as the attribute [_count] on each pipe.I'd like to count the number of connections upstream of each pipe segment and save it as an attribute on that pipe. Our goal is to prioritize emergency repairs based on the # of properties a particular pipe segment serves.Most of the examples and transformers are based on the shortest value (time, travel, length, etc). I kind of want the opposite. StreamOrderCalculator could work if I were allowed to 1) use an attribute instead of Stream Order Type, and 2) accumulate that attribute at nodes instead of checking which one is larger or if they are equal. Same with StreamPriorityCalculator. It's looking for shortest path, not longest.Any suggestions are appreciated.

Hi there,i am trying to calculate area of whole bunch of vertical standing free form 3d Polygons but somehow the calculated areas (sloped area) are not correct, for instance a polygon that suppose to have 35m2 area (calculated in autocad), gets here a 18m2 area in FME!i import a dwg with closed 3d polygons in FME and then i use "Area Calculator" with Sloped surface option and multiplication factor 1. the units area in meters...does it sound familiar to anyone and is there any solution to it? any help would be appreciated. 

I have a MapInfo table with attributes Species, GridRef, Year (such as 2020, 1999..). There may be many records where the Species and GridRef are the same, but I want to filter and retain only those with the most recent Year - so only the most recent record for a Species at each GridRef. There can also be many where Species, GridRef and Year are the same, but I just want one of those with the most recent year (it wouldn't matter which). I think by using a combination of Sorter and Sampler I should be able to sort by Name, GridRef, Year and group by these in the Sampler - so it should pick the first record in each group? I tried this but still seem to be getting duplicate Species and GridRefs in the result.I'd be very grateful if someone could at least point me to the right transformer. or give me details about the parameters I should be using in the Sampler.Many thanks, and keep safe,Jane

Hi There, I have polyline feature class (in GCS_WGS_1984) and I want to perform Generalize function (ArcGIS Link) on the layer for 10 meter treshold. I found this transformer Generalizer transformer that seems like right transformer to use but it has lot of options to choose from. I am trying to figure out the equivaent in FME world for ESRI's Generalize function. Appreciate any input.

Hi all, I was looking at this arcticle: https://knowledge.safe.com/articles/176/fme-temp-environment-variable.html  I have created FME_TEMP system variable to point to an drive with a lot of space (D drive) I have some big WBs which create a lot of temp files, but these still go into c:\\user\\...\\temp folder and sometimes space on C drive will run out and WB will fail. What is the problem here and how can I tell FME desktop to write temp files to D drive? Do I need to create the FME_TEMP per user and not per system? Something else?

Hi everyone,I have a workspace to create polygons from point with aixm 4.5 data (previous question here, thank you @takashi)Somes of the polygons contains arcs, and theirs direction clockwise (CWA) or anti-clock wise (CCA) matters, I don't know how to handle this in python, or with other transformer.Any ideas ? Thanks

I have created a fme workbench. It has creator transformer, python caller and S3 Uploader. The purpose of the workbench is to created a pdf (python script does it) and to upload that pdf to S3. Our FME is 2019.2.  I am using custom python3 installation. If I just run creator and python caller, all works fine. If I disable python caller, and run creator and uploader, all works fine as well. If all parts are connected, I am getting an error:Python Exception <ImportError>: cannot import name 'ssl' from 'urllib3.util.ssl_' (D:\Program Files\FME2019.2.3\python\urllib3\util\ssl_.py)PythonFactory failed to load python symbol `fmepy_amazons3.connector.S3Connector'Factory proxy not initializedS3Connector_CALLER (PythonFactory): PythonFactory failed to process featureA fatal error has occurred. Check the logfile above for detailsBridge failed to output feature on tag `PYOUTPUT'PythonCaller (PythonFactory): PythonFactory failed to process feature In all cases, python script creates output p

The revised dataset uses a sql executor and the value is 0.00001600. The value from the sde is 1.6e-5.When using a change detector always show as updated when the values have not actually changed. Can I fix this in the sde reader or is there a way to ensure that there is no conversion to scientific notation?

Hello guys,I´m new to FME and would need some help with the following problem:I want to create a gdb out of a dwg file. For this dwg a local coordinate system was used, but it is not set. Unfortunately, the only thing I´ve got is a sligthly complicated formula for a (similarity) tranformation to the underlying MGI (EPSG: 31256) including these paramaters: Offset dx[m], Offset dy[m], Center of rotation x0[m], Center of rotation y0[m], Rotation angle [rad]. Because Millimeters and the rotation center were used the formula for the new x´ and y´ looks like this:x´= x0 + (x/1000-x0) * cos(-rad) - (y/1000-y0) * sin(-rad) + dxy´= y0 + (x/1000-x0) * sin(-rad) - (y/1000-y0) * cos(-rad) + dyFirst, I tried a combination of CoordinateExtractor, Offsetter and Rotator, what didn´t bring a perfect result regarding the coordinates. Besides I had to aggregate all the features to one because otherwise the Offsetter changed the pattern of the lines.Then I tried the Affiner, but (thanks to my math skills)

Dear friends,Please help me to merge two databases in single MDB, merge MDB file for winter 2019-2020 to winters 2009-2020 mdb database. I tried few options and it did not help much.Also, I want to setup the system in task schedule. Thank you. Abzal

Hi, I am trying to generate a table with N columns and R rows as a layout page in a DWG file. I have this table defined as a template and the data is from different sources like shape files. I am creating a Multi-text for each field and using a VertexCreator with a fixed x,y position in the paper space to place them at each column. Everything works fine except that the rows are filled in the upward direction rather in the downward direction. Is there a way to auto calculate the position of next row ( x,y ) for multi-text or any other ways to auto fill the table ? any insights to set the rows automatically would be highly appreciated.

I am trying to run a python script in a PythonCaller to Truncate Features in an Oracle ArcSDE database.If I run the script and hard code the Feature it runs fine but when I try to use feature.getAttribute to read a list created in a previous transformer, I keep getting:Python Exception <ExecuteError>: Failed to execute. Parameters are not valid.ERROR 000187: Only supports Geodatabase tables and feature classes My script is:# Import arcpy moduleimport arcpy def processFeature(feature): IFeatures = ('C:\\\\AppData\\\\Roaming\\\\ESRI\\\\Desktop10.5\\\\ArcCatalog\\\\Connection_to_HYDRA.sde\\\\' + feature.getAttribute('_list{0}'))  print (IFeatures) for mark in IFeatures: arcpy.TruncateTable_management(mark)

How to get tutorial materials for FME

i would like to ask about Aggregaator transformer  i have several lines with intersection nodes with another lines i used network topology calculator and aggregator combine by network id with generate list and it works great but my problem when i am using deaggregate transformer or List Exploder to show again the attribute of each line ,it has a list say for specific line consists from 3 line so it has three id for the three line . but after i use list exploder ,i found in the inspector it does not know exactly which id of line relates to this segment ,it refers to the whole line (as this id ) ,when i choose the second id ,it refers to the same whole line .but it should specifies ,which segment refers to this id not the whole line .How could i solve it ?i have another question about line combiner , after i tried to combin on attribute by network id ,break attribute yes ,it can not able to combine all the lines that has the same network id but aggregator can do that .do any one h

Hello therewe need to generate a report for then many roads,we need to draw a line between each point and show the distance valueThe same as the image belowis there a way we could use FME in this case   

When attempting to update the geodb_type attribute from geodb_pro_annotation to geodb_annotation the attribute becomes missing. I'm assuming this isn't expected behavior, so looking for any insight into my problem.For background, in my process I am reading ArcGIS Pro annotation from a file geodatabase and writing it to an FFS file in a separate workbench. This annotation started as standard geodatabase annotation, was upgraded to pro, and I am trying to write it back to a standard geodatabase annotation feature class.In the workbench that is reading the FFS file I am exposing the geodb_type attribute, then updating it with the AttributeCreator. The exposed attribute has a value of geodb_pro_annotation, but after trying to update the value it becomes missing.The image shows the relevant part of my workspace. The Visual Preview is showing the output from AnnoAttributeCreator.Using FME(R) 2020.0.1.0 (20200407 - Build 20218 - WIN32)

Forgive my probably dumb question as I am still learning the volume type data.My end goal is to create a volume object from a pointcloud and export it as a solid for cad. I suspected this had to be easy but it might be harder than I anticipated.What I did was feed the pointcloud to a TinGenerator and I got an acceptable surface, which I can apparently not symply extrude. This is all I want, an extruded surface with a thickness of 1 meter.I found the BRepSolidBoundaryCreator.Beta on the hub but it needs python 2.7 which I didn't install last time apparently.Do I want something impossible or am I missing the obvious?Thanks for looking :-)

Hi ,I need to do a conversion between 2 formats with many files in several directories ,how can I define that output directory =input directory

Hello,I'm very new to FME and trying a relatively simple workflow. I have a DWG file of a building layout. It includes polylines for rooms (all on one layer), and within each polyline, there is a simple text label for the room number (all on another layer).  I would like to transform the data in this DWG to an existing PostGIS table, where the room geometries will populate the 'geom' field and the text labels will populate the 'name' field.  I'm having a hard time converting the labels to text strings and also ensuring that the text labels are matched to the correct room polyline.  My current workflow is shown below:The room polygons from the DWG file import fine, however the text labels for rooms do not populate at all in the PostGIS table.

HiI wonder why FME sometimes add more decimals. For example:  If I import the number 652314.30, FME sometimes convert it to 652314.300000004Does anyone know why? I see this problem quite often and I solve it with the string formatter./Fredrik

Hello, I am struggling with an issue within my workbench. It is a bit difficult to explain, so I hope my explanation is understandable. I got stuck at this transformer: The failed output port is similar to this format: The passed output port is similar to this format: What I want to accomplish is the following table:So I want to test the outcome of the failed output port based on the fact if a value in the 'Number' column corresponds to a value in the 'Number' column of the passed output port. And if a row meets this requirement I want to join it with the rows of the passed output port.Can anyone explain to me which transformer(s) I should use to accomplish this? Thanks in advance!Eva

hi, I have an excel file, which has 3 fields: date, confirmed and country. But some data and confirmed values are without values. For those who are without values, I would like them to be filled out, considering the last value. In other words, the last data for a given country was 04/29 and the next data record for empty, the filling must be automatic for 04/30. The same thing should happen for "confirmed" if the last record is determined for 50 country and the next record is empty for that same country, the filled value must be 50, always the previous value.  thank´s