FME Form

I have an SDE with a point feature class that has 120k locations across the entire US. I can read those points in with a normal reader, but it takes a long time ~5 minutes and I really only need to return 100 out of those 120k points.  Which 100 changes depending on the input of an excel reader. I pull in a list of 10 or 20 points from an excel sheet, take a 2 mile buffer around those points, and then spatial join that to the big list from SDE. Those 10 to 20 points could be anywhere in the US.  Is there a transformer that will let me read in my 10-20 points, then make a query to SDE/SQL with a transformer based on the location, so that I'm only asking the database for the records I need? That way I am not pulling in the rest of the 100k+ records.  Right now I am thinking I can take the lat long coordinates from the excel input and create a bounding box of sorts to query the SDE point feature class. But I don't see a transformer that can read from SDE 'inline' with the

Hi,I am currently trying to archive information out of old DWG files in my company. But so far I am still rather uncertain with how I open the DWG files in FME in a way, that I can access the labels within the DWG file and write them into another file format.I found a lot of tutorials with how to write into DWG, but nothing much the other way around.Can someone help or point me in the right direction?

Does anyone know of a way to use FME to generate a .lyrx file with symbology that I could then use in ArcGIS Pro?  I think a lyrx file is just XML under the hood? Making and remaking layers in ArcGIS Pro is a pretty huge pain point for me, and I'd love to see someone make a transformer / writer to help with this, so that I can just specify a data source, specify symbology parameters and click 'Run' in FME to generate this > add to ArcGIS Pro, instead of using ArcGIS Pro's laggy interface to click around in the symbology pane. @mark2atsafe​ thought you might know of a solution? Thank you

I possess a polygon layer containing sections where polygons overlap and also areas where gaps exist between them. My objective is to address only minor overlapping sections, specifically those where polygons overlap by less than 20 square meters. I wish to consolidate the gaps between polygons as well, targeting cases where the gap between boundaries is less than 20 meters. Is it feasible to perform this analysis using FME? I attempted to utilize the AreaGapAndOverlapCleaner in FME, but it appears to make adjustments for any type of overlap. However, in certain instances, two polygons may possess identical geometry, and I do not desire the overlap to be rectified in such cases.

Hi all, does anyone know if it is possible to draw only the outside walls of a building based on a ground surface and a roof surface. So ground surface is given and should not be modified and a detailed roof shape is given and should also not be modified. It is important for us to keep the original roof and ground and create only the walls.. We are using BrepSolidBoundaryCreator. As input we are taken the roof polygon and we do a negative extrusion to minal z value. But unfortunately we have as result a new ground surface and the old one does not fit to the walls. We want to keep the original ground surface. So is it possible to move the created walls to the ground surface subsequently?This would be necessary to take our original ground surface! Something like this:

Hi, I will create Walls with the transformer BRepSolidBoundaryCreator.Beta. As input I have roof surface and ground surface. The transformer should take ground surface and roof surface and should create wall surface (orthogonal projection). If the roof does not 100% match the ground polygon, the roof should be adjusted. At the moment the transformer creates new walls and in addition new ground. Thats great but nevertheless I will take my own roof and ground surface. Is this possible? Or is there another transformer which I can use?

I have followed this pattern of a workflow for years, where I maintain attribute names and data types in a spreadsheet for different databases, and I import those names and values using the Import... dialog within the AttributeCreator as one of the last steps of a data workflow.​When I import values, here's what I usually have in the AttributeCreator:​Output Attribute Valueattribute{0}.name AreaNameattribute{0}.fme_data_type fme_varchar(64)​Now that the AttributeCreator has a data type in the dialog, should I still follow this pattern?  How does this new data type parameter work with dynamic workflows?

Where can I download of instruction manual for Advanced FME

ArcGIS Portal Feature Service Writer: Writer configured to use Global IDs, but this is not supported by the Feature ServiceARCGISPORTALFEATURES writer: A fatal error has occurred. Check the logfile above for detailsFeatureJoiner_3 (FeatureJoinerFactory): A fatal error has occurred. Check the logfile above for detailsFeatureJoiner_3 (FeatureJoinerFactory): ARCGISPORTALFEATURES writer: A fatal error has occurred. Check the logfile above for details

Hi all. I'm having some trouble reading the Feature Types in the Microsoft SharePoint List reader. I've uploaded an XML file for the Web Connection and successfully tested it. When attempting to read the Feature Types it throws the error in the attached image. I have permissions to access the site and I can open the same URL to the SharePoint site when it throws the error. What have I missed? It's my first time working with SharePoint lists in FME so any information is appreciated. Thanks,Michael  

how can i extract RTF format file in feature reader

I have tried using spread duplicate points remover followed by neighbour finder , but the feature is still in same location .This is critical issue . can you please help on this ? 

Hi AllI am using the neighbour finder, and it works absolutely fine, however i have noticed that some of the lines cross into the neighbouring polygons as shown on the image below.The YELLOW Line is the site boundary, and ideally I would like to keep the line within the site boundary, as shown by the RED line. The GREEN line shows what has been calculated.Anyone have any ideas if this can be done, and if so how... RegardsAndy 

I've downloaded a geopackage file from Data Map Wales (in the UK) containing listed buildings and whenever I load it into FME Desktop it seems to miss a field containing a date, all the other fields are there. I've used DB Browser for SQLite to read the file and the missing field is definitely in there and contains data. In FME Desktop I've tried using a reader and a featurereader to load the file, both approaches fail to recognise this field. I've also tried in QGIS and the field does not load in there either. I initially thought that the data might be malformed in some way but the fact that it reads fine in DB Browser for SQLite suggests otherwise. Does anybody have any ideas as to how I can read this date field? The data is available from this website Listed Buildings | DataMapWales (gov.wales)

Fanout expression using wildcards?: Need to split a shapefile into six shapefiles based on the third character in this string: US5ME54M. That 3rd character can be one of six characters, 1 thru 6.

Greetings, I keep getting this error:Out of memory. Program terminating.  I ran the FME Performance Tuning document. I cannot set the FME Temp to a SSD.I am reading data from an ESRI fgdbMy laptop configuration is: Core(TM) i7-1255U  1.70 GHz16.0 GB (15.7 GB usable)Any suggestions are appreciated. ThanksClive

Hello,  I created a script that update a gdb file. The problem is that in a table it update all fields in 10 minutes. In a other table in same database with same quantity of data it update in 3 days . What is the problem ? Do you have any idea or documentation about the gdb/sde update parameters? a capture to the table problem . ELE_MUFFE work perfectly but no ELE_MUFFE

I am attempting to write a raster file to a PostGIS DB held on AWS. There is a schema set up to write to and the PostGIS Raster extension has been enabled in the DB. I've added the connection into FME and can successfully connect to itRunning the writer gives the following error message; "Writer failed to create table 'tif.test' because requested schema '\\\\gis\\GIS\\Qgis\\Data\\Raster\\Open Map Local Raster\\SP56SE' does not exist. Please specify an existing schemaPOSTGIS_RASTER writer: Writer failed in write() call" Can someone advise me why this is failing and how to resolve it.

I have a problem that RasterResampler does not provide good enough quality when scaling down a raster. I have tried all the methods available but it is "far" from the quality I get if I do a rescaling with e.g. Irfanview, Pillow (python library) or Photoshop. Are there any other tricks one can use to get better quality when rescaling with FME? See this image where I scaled from 2308x2212 pixels to 512x512 pixels. The left image is what FME can give me with the best settings I found (Average 16)The right image is downscaled with Pillow (python)  Note how "pixelated" FME's result are. Compare for example the road markings.

When the dataset is run first the preview is fine. It is only when I first click View Source Data. The preview searches the connection at C:\\Windows\\System32\\%connectionname% which is wrong. It should just go to the connection defined in the workspace

I need to create a summary slide with multiple sections/placeholder tables on one slide, so I need to have my font size to be 10pt for example. So far it seems that FME hard codes the table font to 18pt. Thanks, Joey

plz Note there is there is thickness of this object so the challenge is to extract the Face coordinates. Highly thankful to all FME Community and Experts for your effort.  

Morning. I'm trying to create an upstream trace on a network using a loop. A feature finds the upstream id of it's nearest conduit, then uses a FeatureMerger to join with a shapefile of conduits and find the feature with that ID as it's downstream id, therefore moving one length of conduit upstream. It then loops back to the start to check if that conduit has a particular value and outputs if so, or does another upstream trace if not. FeatureMerger is a blocking transformer and I've followed all the tutorials to create a custom transformer for looping with blocking transformers, but I still get the error "UpstreamTraceDWF_FeatureMerger is blocking and cannot be used in a loop..." and it then crashes. Does anyone know a way around this or is there a better way to upstream trace I could use?

I have two readers reading two shapefiles: a centerline and a AOI of interest. The centerline is in WGS 1972 and the AOI. I need to reproject the centerline to the coordinate system of the AOI. Is there a way to define the "Destination Coordinate System" with that of the AOI?