Transformers

Hi guys,im using a csv file (with sde feature class names and etc.) as initiator to read various feature classes from a Esri sde database.however i also need to setup a spatial filter on this feature reader to limit the number of record being read. is there a way I can get this setup? I tried add another initiator into same feature reader transformer but seems this is not working.. Thanks guys!

I have a linear network that I have processed with the TopologyBuilder. I have a second linear network that I defines the from-to lines for the ShortestPathFinder. My concern is that the polylines in the two linear networks are segmented differently, for example, the Topology Edges are segmented at intersections and the From-To lines are segmented at mile markers.  Is it necessary that the segmentation of the two networks aligns or just that the From-To vertices correspond to points on the Topology_Edges?

Hello All, Currently I'm converting CityGML 2.0 from IFC4. The IFC file is a building model. So normally the exported CityGML feature types should be under Building module, which are named with "bldg" as the namespace prefix, e.g. bldg:Building, bldg:BuildingInstallation, bldg:WallSurface, etc. However, I found some feature types of the exported CityGML were assigned to Bridge module. Although I can turn on "Add XML Namespace Prefix to Feature Types" (found in the parameters of CityGML Writer), and make the feature types "brid:Door"/"brid:Window" to "bldg:Door"/"bldg:Window".  I'm just wondering why the feature types "Door" and "Window" will be assigned to Bridge module by default. Or is there any mechanism to decide which module will be assigned to?  Thanks in advance.Regards,Qubbie

Hi, I will create a military grid (10m precision) for an area. I have seen that there are some transformers in fme. I think the "MGRSGRIDGenerator" Trasformer is what I need. As input any 2d polygon feature is allowed. I runs successfully but does not generate any output!  Does anyone have experience with this trasformer?  

I have a shape file containing for each 100m a line segment representing a 100m segment of a railway line. I would like to create for each line segment a buffer polygon that has no overlap with neighbouring buffers in railway lines to corner.  Creating an indivdual buffer for each 100m line segment results into the following buffers:As you can see the buffers are having gaps wen the line is cornering. In order to avoid the gaps I created a single line using the LineCombiner and then using the Bufferer to create a single polygon. Next step would be to 'cut' this single polygon into polygons with a length equal to the original 100m line segment.  Following the result of the LineCombiner and the Bufferer:Does anybody have an idea on how to cut this long polygon into 100m polygons? 

I am trying to get FME to compare all fields (no key) and only insert uniquid rows.On initial insert all works great but when I go into excel and change a few field values of a rows or two, FME does not update. Instead it inserts them as new rows.How can I overcome this? ThanksB

Hello,Did anybody resolve a problem of writing character ???ŠŽ ( part of Latin2 / cp1250 codepage ) to Geospatial PDF Writer ?Regards Mišo

Hi, does anyone know a workflow for detecting green areas based on aerial images? We have true orthophotos (with NIR-channel) as input. Perhaps there are already instructions or someone has had experience? hope someone can help me! Thanks in advance! 

For example:  I have an external table that has regions for column headings (North, South, East, West) and part numbers for row headings (Part#001, Part#002, Part#003, Part #004,...). A part number in a specific region has a cost as shown in the in the image.  Also, I have another table with the attributes Region and Part Number in FME.  I want to make a new attribute that searches the external table based on the two attributes in my FME table: region and part number and returns the cost. How can I do this?    

Quarter 1 is April, May and June; Q2 = July, Aug, Sept; Q3 = Oct, Nov, Dec; and Q4 as Jan, Feb, March.If I need to run a workbench at regular intervals throughout the year, which transformers will I need to identify features from the current month, and current quarter?I have converted the dates to FME format, and I guess I need to add a DateTimeStamper to get the current date. Then what do I need to do?Many thanks in advance for any pointers you can give me.RegardsStu

I have a PDF Writer which generates PDFs with 4 layers:Frame, Basemap, OldLine, NewLine.NewLine is an interactive layer (hover over it to see attribute details). I would like to also do the same with OldLine - which has a gap that NewLine fills nicely. However when I make them both interactive then, in the resulting PDF, I either get to see just the first part of oldLine or the whole of Newline... Both lines are visible in the sidebar bookmark and the mouse pointer changes when I hover over the invisible linework. I have tried various layer orders (guidance says interactive are always at the top anyway) and many other settings, but can't get a decent output with both layers fully visible and interactive. Is there a hard restriction to one interactive layer? Cheers

I'm sure this will be something really simple I am overlooking (as usual!)I have some excel data of personal information, including age.I need to:1.       group ages, 0-17, 18-25, 26-35, 36-45 and so on.2.       count how many each category / group has.3.       Display data in ExcelFor point 1, I have used the Attribute Range FilterThis gives these resultsSo far so good! For point 2, I use the statistics calculator to do the total count of each group:Then into Attribute manager to rename the columnFor point 3, I would like it to ultimately look like this desired output: However, when I use the Excel writer with these settingsI get this result, I've highlighted yellow where I have gaps that I don't like, and I can only get the age groups to appear as column headings.What do I need to do to obtain the desired output?Many thanks for any help you can give.RegardsStu

Hi I'd like to convert footprint and 3D buildings from Esri Arcpro to CityGML.However, I couldn't import the shapefile in 3D.Do you have any idea about this?Thank you for your help. I'm new to FME so I'm struggling lol 

Hi all, I've created a series of FME scripts that translate geometries in a source DWG file into ESRI consumable SHPs. However, now that I want to change the Writer source to write to the FGDB I created, the scripts won't run properly and say this.Is it a matter of adjusting the attributes viewable in the end FC in the FGDB? I was able to set it to manual/automatic with the SHP writer, and everything translated through with no errors. In my initial transformation from DWG to SHP, the SHP writer geometry enabled the shapefile_first_feature option and dimension from first feature.In the FGDB writer option, I don't see the same option, rather selecting a sepcific type of geometry only (polyline, polygon, point, etc)Would this be where it is going wrong in teh sense that the shp writer enabled for the merging of line/arc/polyline geometries?

This is a silly question, but I can't seem to use the File Copy writer to copy a DWG file to another folder properly. The transformation seems to run with no issues, but when I check the output folder I specified, the DWG file is not there.In the Reader, I chose to merge it as a single merged type, as the DWG has about 30+ individual layers in it. Is there a method to ensure I just copy over the whole DWG file into another folder? I don't want to move the original file, simply make a copy of it to another folder.Thanks everyone

When I run my spatial filter with the entire dataset the filter fails but if I run using partial data the dataset it works. Does anyone know why this would happen?Note: Spatial Realtor works but not the spatial filter.

I need to generate a list of polygons from Dataset Y that overlap with Dataset Z and the percentages each polygon overlaps the polygons in the other dataset.I’ve currently used a spatial relator > list concatenator to find overlapping polygons but it then requires a lot of additional work in excel to get it into a usable table so I am not getting results in the format I need.The data essentially looks like the follow example and I need something similar to the Ideal Resulting Dataset or in a format that is easy to follow or easy to turn into that dataset.Example Dataset Y1234 Dataset ZABCD Spatially Datasets Y and Z:Ideal Resulting Dataset:

I am trying to get version difference via ArcGIS Portal service and I am getting this error message : ERROR |Python Exception <KeyError>: 'rings' I am encountering this error message for only layer (pointing to polygon featureclass) on the service and the rest looks OK . In case I use other layers from the same service, its working fine and giving me version difference results without any issues.  If I do some edits from ArcGIS Pro and perform version changes, that seems to be fine for the same layer.  Thanks,Naveen

Hi guys,im using a CSV file + feature reader to manage SDE feature classes get read into my workbench. In this csvI also have a list of filter and attribute to keep/rename for each of these layers, im wondering what's the best practice to do this - is there an easy way i can apply my csv file rather than repeating tester / attribute renamer for each layer? thanks guys as always!

Hello! Not sure where to put this. I'm sure others must have tried this and figured it out before.  We have a spreadsheet with 10 tabs. 3 of those tabs we'll have automated via an FME workspace.  Question 1 - Is it better (or easier) to purely overwrite or append? We have an excel template set up as the formatting (font size/ auto height) need to be followed. The scenario here is we are keeping track of communications and creating a new row each time there's a new communication. Is anyone able to share a screenshot of what the parameters should look like? I am getting confused by truncate/insert/update, templates and named range and how they all work in this situation. Is it possible to only overwrite the three tabs or if I select overwrite does that imply the whole spreadsheet. I notice there are two sections to control parameters  I'm a little bit unsure of setting up a named range since the list of communications will continuously grow. There are still those other 7

My question concerns when a resource is read when using a dynamic writer. Is it read at the start of the process or immediately before needing when dynamically writing? I am modifying the xml schema in my workspace and overwriting the file. However from what I can see the resource has already been read and applied as the schema. Should the resource be read just before the writer needs it or at some earlier point? Could I use an attributefilereader to read in the xml as an attribute and use this as a schema attribute just before the writing bypass this issue? Thanks,Ian

Hi All,  I'm working on a workflow to identify if line is perpendicular and shows the same X at both vertex . Below a screenshot that shows a line pointing to the north but the X (top vertex) is different to X (bottom vertex). The aim of the is fail the lines which are not perpendicular and show different Xs, I was thinking about TopoBuilder but can't get it to work, Any ideas? Thanks :)     

The netcdf format is new to me. I have created a multiband raster with 50 bands. Each band contains values for 1 day. My workflow looks like this: The sampler to the left is for testing only and lets 7 bands go through. The listbuilder creates a list of values for the 'days_since' variable. I want to use these values in the writer for the 'netcdf_band{}.coordinate_variable{}' port.How do I apply this as a list? At the moment I have to apply them individually day for day in the attribute manager before the writer.This works but is obviously not scalable. Any help in this matter would be much appreciated - I have thousands of bands to include! :)

While reading a gpkg file, I am getting the following error, Does anyone know what i can get over this error?

good morning fme intusiasts I need your help. I have to convert .RGB files to .ECW and unfortunately I have no possibility to install "https://gdal.org/programs/gdal_translate.html" GDAL_Translate, which would save me a lot. it is about the "Intergraph Raster Reader/Writer" (https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/ingr/ingr.htm?Highlight=intergraph) Is there a possibility to use this reader/writer ?  Kind regards Michael