Transformers

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

I'm using the HTTPCaller to read in an MDS data feed that I would like to convert to an AGOL line feature by connecting the points together from the "route" attribute. I'm able to extract the attributes for each trip in the dataset using the JSON Fragmenter and JSON Extractor, but I'm getting stuck on creating the geometry. How can I take each point coordinate from a trip and connect them into a line and keep the trip attributes associated with it? Example of the JSON format is attached. 

I have a report coming out of an out-of-the-box Vertigis Studio workflow that is written out as multiple excel files. Each has the title Results (number) e.g. Results (1), Results (2). (The dataset name is exposed as the tab name, for some reason and not the file name). If I were reading a group of spreadsheets with the same structure, I would just set the reader to read *.xlsxw, and it would be non problem. However - here I have differing attribute schemas.  The datasets called by each report vary depending on a spatial interaction, but come from a finite list of possibilities. And as I say, the attribute schemas can vary.  I need to read all files of the output, expose attributes and write out into a single excel sheet, fanned out by dataset (presumably using the FME basename - is it possible to grab the tab title instead?) I have done the reading thus far using a Reader set as pic attached ...however, this isn't dynamic. Moreover, this workspace needs to be usable by a relativ

Hi everyone, If I want to change a numeric value of an attribute, I tend to use the ExpressionEvaluator. I kind of see it as the 'transformer equivalent' of the Arithmetic Editor. Is there a 'transformer equivalent' of the Text Editor as well? I guess there is the StringReplacer, StringConcatenator, AttributeManager, etc., but which one would be the best/most efficient to use? And speaking of efficiency, I have another question regarding transformers. A colleague of mine told me a while ago that, for debugging's sake, it is wiser to use e.g. an AttributeCreator, AttributeRenamer and AttributeKeeper in series instead of using a single AttributeManager to perform all those tasks in one go. I tend to agree with them on that, but does this also have any consequences for performance? I can imagine the difference being minimal, but best practices and all that. Thanks in advance!

I've always had a hard time with XMLUpdater, but it usually ends up working. This time I just can't make sense of the errors and how to solve it. I have two XML, I want to take elements from one of them and use those elements to replace the elements in the other XML.  If I take the exact text from the XML-fragmenter at create an attribute containing just that, the XMLUpdater accepts it and produces the expected result.If the XMLUpdater is part of the same flowpath as the XMLFragmenter the XMLUpdater will throw an error.I even tried putting it into a new attribute with different datatype. Can that be right?? The attached workspace is made in FME 2023.2 but the error is the same in FME 2022.2.Any help or ideas is appreciated.

Hi.I haven't really used XML Updater before, but is now tasked with trying to update certain sub-elements i a large hierarchy. I'm trying to update QGIS project files (QGS).I've extracted the needed replacement tag with content, and routes them in via the "update" connector. But I'm stumped wrt. how it's set up correctly.My XPath is set to be this: //field[@name=fme:get-attribute("fieldname")]/editWidgetThis is the location of the tags I want to update (replace) in the source XML file.But it doesn't replace anything, and it errs with this somewhat cryptic message in the log:XMLUpdater(XQueryFactory2): The following error occurred while executing query number 1:XMLUpdater(XQueryFactory2): The following error occurred near line 2, column 26 of the query:XMLUpdater(XQueryFactory2): invalid expression: syntax error, unexpected "type"My replacement XML tag looks like this (example):<editWidget type="TextEdit">            <config>              <Option type="Map">           

I'm using Python Caller with the module ifcopenshell to validate properties and naming of Ifc entities.To do this im also using an excel file that lists the requirements, and the script is now dynamically creating attributes based on the excel file. My challenge is that i want to write a excel file with the results, but i dont want to manually decide wich attributes to expose so the reader can access them.Is it even possible?

I have been working with the following workflow:Bufferer to buffer the buildings with 50 meterClipper to clip the vegetation to the buffersSpatial filter where "BuildingBuffers OGC-Contains Vegetation". The vegetation is the candidate.Area calculator of the resulting areasStatistic Calculator to sum the calculated vegetation area for each building ID. The result is missing data for many of the building buffers. I think one problem is that the vegetetad areas only are counted once, while in reality they can be included in many of the building buffers. Do you have any advice? 

I have already included the network network utility package xsd file from github and followed the import instructions but now I do not know how to map the shapefiles to this network utility ADE in FME. The ultimate goal is to include this heating network system in my citygml model in cesium (3D tiles). Currently the cityGML is without the heating system

I have two seperate features classes - holes and polygons. I simply want to merge them with disolve by grouping by a certain id. However output has lines at the border of the holes. How can i get rid of them? Holes are brown and Polygons are pink in the picsAfter dissolve This is before dissolve