Transformers

I have a large polygon SDE feature class (>3M features) from which I only need polygons intersecting a few Oracle polygon features.I've connected the Oracle features to the SDE FeatureReader's Initiator port and I'm using them to filter SDE data with the 'Initiator Intersects Result' spatial filter. I've realized it returns duplicates when there's an SDE feature intersecting more than one (non overlapping) Initiator feature. So if an SDE feature intersects 3 Initiator features I get 3 copies of the SDE feature.This is not what I would expect. My only option is to use a DuplicatFilter right after the FeatureReader but when reading thousands of features this will slow down my translation.Has anyone come across this same problem?

Hi All, Appreciate if someone in this forum let me know the process to transform Enghouse Cable Cad files to any OGC format with attribute data transformation. Thanks in advance. Vijai Gunalan

i have different points (A,B,C,D,E,F,G,H,I,K) . some points are connected together and some not in the network ,as example A connects to B connects to C D connects to E C connects to GF connects to I connects to K  if there are any connection between any point ,i want to use shortest path finder ,depend on the shortest length and the largest value in specific attribute .soi am not sure how could i let the shortest path finder pick only and choose the largest value of attribute if he has multiple path and the transformer should decide  FME 2018Thanks for help

I am trying to extract vertexes from a shape file that has 3D Lines with both a Z value and an M value. I am trying to extract the both the Z and M value but I don't see a way to do it. Vertex Extractor will only give me X,Y,Z

FME 2017.0 (17271).I have a polygon layer which consists of an area with buffer zones around it. The polygons do not overlap. I also have point data of address which covers a larger area and includes postal and non-postal addresses. I want to select only the postal addresses that fall within the polygons.The address data is stored in SQL Server using the Geometry data type to store the locations (WKB Geometry). So I've been comparing ways of doing the selection. In doing this I've found that using FeatureReader with both a WHERE Clause AND a Spatial Filter results in some address records being selected twice.I read in the polygons then send these to the FeatureReader. The FeatureReader connects to Microsoft SQL Server Spatial to read the point data. The Spatial Filter is set to "Contains".If I leave it like this and add a Tester to do "Postal NOT LIKE 'N'", I get 653,819 records. If, instead of the Tester, I add a WHERE Clause to the FeatureR

Hello there,I am trying to aggregat neighborhood polygones (they need to touch or intersect each other) grouped by their ID with the condition, that the value of a specific attribute from the neighbor polygone needs to be in the range of +-10% of the „motherpolygones" value. In addition, I need to use the „Attributes to Average, Weighted by Area“ attribute accumulation setting from the aggregator. This option isn’t available in the neighborhoodaggregator. Also the "Attributes to Concatenate" option is necessary. In words the Transformer should do this:"If the polygones has the same ID and touches or intersect each other and the value of the attribute AA is in range of +-10% aggregat them. Weight the BB attribute by area and concatenate the attribute CC." Does someone has an idea? best regards,knigge

The highlighted Polygons should form a larger polygon with the same attributes. Both have different IDs, so after merging only one should be retained. The same transformation needs to occur for other polygons in the screenshot also. Usage of Dissolver and FeatureMerger transformers has not yielded results. I hope some light can be shed on the right approach to take here.

I want to transform a polygon dataset into a raster using the NumericRasterizer where the new raster matches the dimensions of another raster in terms of dimensions so that they align perfectly (I assume extend and cell size is enough to achieve this). As you can see on the image below, I already have the rasterize part working. The problem is that I don't get it working that the dimensions (extend and cellsize) of the references raster (the geotiff reader in the image below) are used as extend and cellsize input of the numericRasterizer. I need the extend and cell size to be automatically extracted from the Geotiff because that can vary.  I already tried the RasterPropertyExtractor but then I am not able to extract the attributes. I somebody able to help me with this issue?  

Using a reader to consume a pretty basic spreadsheet, but loading it fails with the following message: Excel Reader: Failed to open the dataset 'C:\path\to\file.xlsx'. Error message was 'Length too short' A fatal error has occurred. Check the logfile above for detailsFailed to read schema features from dataset 'C:\path\to\file.xlsx' using the 'XLSXR' reader This file has ~450 rows. Other files generated by the same system work just fine. The only difference between this file and the last one that worked is row count, around 150.

 Maybe my question has already been addressed somewhere, but I can't find this topic so quickly. How can I combine a file with project shapes (SHP-file) with a map (WMS / WFS) and get a map (JPG / PNG / BMP / ... as output per project, where each map is given the name of the project (project name is an attribute in the shp file)?

Hi there,I was wondering if anybody can give some pointers on writing CityGML dynamically.I am using a Generic writer in combination with a referenced CityGML writer.The CityGML feature types have been imported as mentioned here to the referenced CityGML writer. The source data contains feature types that match exactly the CityGML schema specification (PlantCover, Road, LandUse, Building, WaterBody and GenericCityObject). The Generic writer schema definition is set to dynamic using the schema feature from the FeatureReader transformer. I am not very familiar with the CityGML schema specifications , but since the resulting CityGML LandUse feature type has all the original source attributes plus CityGML generated attributes, I imagine that it should be possible to have that for all the resulting CityGML feature types. Another issue it noticed is that the city_feature_role is set to cityObjectMember despite the fact that I am setting the value in the workspace to the corresponding feature

I have a shapefile with both points and multipoints (not produced by me) which I am reprojecting and then writing to shapefile again. The multipoints don't get written due to the writer expecting only point feature types. I would like to split the multipoints into single points before writing, similar to the PointCloudCoercer when splitting a point cloud to single points. Is there an easy way to do this in FME or should i just give up and fix it in ArcGIS? 

When my script comes to "Updating access token for 'zzzzz'" it stops. No errors or anything. When trying to make an new Onedrive Connection it just shows the OneDrive login briefly and stops. Has anyone experienced this?

Hi everyone.I want to find the difference between two tables. The first is a FGDB feature class. The second one is a XLSX files. I need to find if some value XLSX is absent in FGDB. I need to compare 4 different field, but not all fields.Thank for your help

Hi everyone, I want to update the metadata on ArcGIS Online. Is this possible?This was previously asked a few years ago but I cannot find anything more recent https://community.safe.com/s/question/0D54Q000080hFh4SAE/writing-metadata-to-arcgis-online Thanks  

Hello,     Our AV policy is set so that any unknown executable file is blocked unless it is trusted. There are two options for a file to get into this state:   1) The file is signed by a recognized Certification Authority  2) It has been analyzed by the AV itself (and it has to be executed prior to analysis)     This means that after every update we have to experience continuous blocks -as every dll is analyzed independently- until the whole program becomes functional.     As a good security practice that any mature software company should perform, could you please sign your code?    Thank you in advanced,

Previously for simplification purposes on reports, I would use the Total Count feature and define the attribute name as TOTAL for the number of objects with an id field. Now it dumps my counts to a field called id.total_count which I then have to run through an attributerenamer to change the attribute name to TOTAL which adds more transformation, clutters the workspace further, and uses more memory. Why was this function removed? Was it really such a big issue to be able to define the name of the output attribute?

Hi FME Community, I've been sent a spreadsheet with a series of rent entries. The name of the property, the dates and rent are the fields which are important. For each entry, which is a single line per rent payment, there may be an increase in the amount. This can be after 1 line, or 20. Basically, I need to only keep the entries which show an increase in rent amounts. Trying to find these entries and automate them seemed simple at first - but has stumped me. If anyone has any ideas, I'll be very grateful.Thank you

I have a problem with FeatureWriter on v2020.1 32bit I have no problem with direct connexion but i want use Summury result of FeatureWriter to continue insert or update on table and associated file.  this is the part logError connecting to PostgreSQL database(host='', port='', dbname='connexion validé', user='', password='***'): 'fe_sendauth: no password supplied I use a connection so I don't undersand why host, port and user is emptyI have test my connection and all are ok  

I have a 10-year-long dataset that needs to be split by year. The complication in my case is that I need each output year to start from December of the preceding year, i.e. the output filter for year 2019 has to be from 01/12/2018 00:00 to 01/01/2020 00:00. I can't seem to get this to work with AttributeRangeFilter. Cheers.

When running long jobs, the ability to provide an email address for sending a download URL to is very convenient. Unfortunately, this only seems to be provided with 'normal' jobs and not within a FME Server App.I did some searching and encountered this Idea (click). Of course I voted for this, but that will not help me out on the short term.I looked into modification of the notification message (e.g. using FMEServerNotifier transformer), but this does not appear to be possible. I would really like to stay away from solutions like chaining workspaces in Automations or using the emailer Transformer. Better would be to use the already available functionality for notifications.Anyone some ideas about fixing this?

Hi everyone , i need to write a gml . i have a set of xsd files and an example file (wkpb_voorbeeld.gml) how do i write a gml file like the example (the only thing i need to write in the gml is the poslist (geometry)

I need to write records to 3 different databases and then delete the source records from the source database. What is the best way of making sure the records are not deleted from the source before all the writes have completed?

I am trying to build an integration between a few of our vendors, and one of them requires us to connect to a Tibco JMS queue. I'm not a java guy, and have been trying to find some information to help get this going, but has anyone set up this connection before that could help me?  Thanks!

I was wondering if it would be possible to extract the text information about a pipe, the pipe is represented by a linestring, with the text being in close versinity to the line. And if it's possible, also extract the letter representing a manhole or point to which a line can connect.The red letters "A" represent manholes, the yellow line represents a pipe. Both the letters representing points and the lines have z values. The white text under the yellow line in the center, represents the name of the pipe type (KL200), and the text values in the start and the end of the line represents the elevation of the pipe. The value with the large font text (56186 and 56185) is the ID of the manholes. I have a structure in which I would like the data to fit but the whole, extract text information and apply it to the attribute of the nearest line or point is where my limited experience with FME holds me back. I have no idea if what I'm asking is even possible, but I think it might