FME Form

Hi, I have created a random polygon (in EPSG: 4647) and now I want to put hatches inside of it via DWGStyler. They should be depicted in an angle of 45° and as lines - this works. Between the lines, there has to be a distance of 2 meter and this is where I got stuck. I've tried to achieve this via Pattern Scale in the DWGStyler and by setting "autocad_hatch_pattern_space" to 2 by using an attributecreator, but this doesn't seem to work properly.

I am using the DuplicateFilter to remove features with the same attribute. It does work well but I am having an odd issue with the geometries behind each feature. The features that gets filtered out somehow 'still exists in the background'. It doesn't get counted as a normal feature if loaded in GIS, nor appear as one, but when using transparent symbology it is visible, as if it hasn't been fully removed. Just the attribute seem to be removed. The filtered out feature still seem to exist hidden in the dataset (a shapefile in this case).  How can geometries be filtered out properly with their attributes?

I'm sure this is really basic but I'm stumped. How do I take some sort of action based on the number of features emitted by a previous transformer? In this particular instance I need to abort the final write (and send an email) if the number of features are less than 2000. I have a Counter, and can see the number of features. I have a Tester, but it appears to be testing each feature instead of the total count.   

I have a shapefile of the road and I want to convert it into GeoTIFF But I want the GeoTIFF should show the road name

Is there any possiblity to configure/customize fme server error messsages on server side? Any good idea for this?

If I use a Counter Transformer in my workspace, I often find myself using a 'Local' Count Scope, and also I prefer to start counting at 1 (instead of at 0).  Also, I would prefer to use the count functionality through Count() FME Feature Function(s) as opposed to using Counter Transformers, as this makes my workspace a bit more compact.  Unfortunately, I haven't been able to combine both of these goals. In particular, I haven't been able to use the 'Count()' FME Feature Function in combination with a Local Count Scope and a Count Start of 1. See below screenshot and the attached workspace (FME 2021.2.2.0 b21806, Counter Version 3)). I had a look at the FME Feature Function documentation page, and I thought that the NO_LOG option could be similar to the Local Count Scope.  If I look at the indicated Syntax of the Count() function, i.e.@Count([<domain>[,<startVal>[,<modulo>]]][,NO_LOG]),I'm tempted to believe that it should be possible to us

Hello FMEers FME Academy UpdatesIn case you missed the announcement, there are a number of useful updates to the FME training academy that may be of interest to you. New modules include:Read From and Write To Multiple LocationsImprove Data Quality by Handling Null and Missing ValuesBuild a Shared Library of Custom Transformers These are part of the new Build Advanced Workflows trail. I count 11 trails so far, each with different modules:  And don't forget, online FME training materials are free of charge to use.  FME Hub UpdatesThe Hub Monthly Digest is a must-read if you are Swedish since most of the new items relate to Swedish formats.  There is a web connection for the Nationella Geodataplattformen (NGP) and several transformers for the Digital Twin Cities Centre (DTCC). The DTCC project seems to be about modelling urban environments to assist in real-world planning and design.  It looks like a series of projects, actually, so I'm really happy to see FME functionality may pl

I have Esri SDE writer that is not updating a representation domain. I am trying to update two fields, a string for color and the rep field with an integer. If I remove the color field it writes the domain field fine. If I "enable" the color field it nulls out the domain field and writes the color. The log is not showing any errors. The workspace is super simple. I don't understand why it is doing this.FME 2021.1Esri 10.6.1Oracle 12c

Currently I have an XFMap file to parse attributes, but I'm looking at creating an attribute with the raw XML of the item to write out as a CLOB. Is there an easy way to add this into the xfmap to include it as an attribute when parsing out all the other attributes? I've tried mapping match=".", mapping match="*.", mapping match="*" all which don't work correctly.Thanks in advance!== Feature-Map to parse out each item ==<feature-map multi-feature-construction="true"><mapping match="item"><feature-type><literal expr="Feature"/></feature-type></mapping></feature-map>== Feature-Content-Map (what I'm trying to get to work ==<mapping match="."><attributes><attribute><name><literal expr="RAW_XML"/></name><value><extract expr="." /></value></attribute></attributes></mapping>

I am attempting to append records to an ArcGIS Enterprise Portal table from a Postgres database using an SQL statement. I have a SQL statement that works correctly to query the database. I can use this in the SQL Creator Transformer and connect it to an Esri ArcGIS Portal Feature Service writer in FME Workbench. I can run this in FME workbench, and the records successfully write to the Portal table. The project works on my local machine and on the network server we plan to use for scheduled tasks. FME is installed on the server. I would like to run this on a 12-hour interval using Windows Task Scheduler.  Here's what I've tried:Copied the "header text" from the log in FME Workbench, and saved this as a .BAT file. Placed the .FMW and .BAT files in the same directory on a network server, and edited the .BAT file to point to the .FMW file in its new location.I created a new scheduled task in Windows Task Scheduler to Start a program, and pathed to the .BAT file.Nothing i

Hello,Here is my situation. I have nearly 500 gdbs with exactly the same schema (each gdb contains 7 feature classes). I need to merge only two feature classes. My process also involves a loop and because I do not want to read all the gdb everytime, I have an index shapefile (one feature = one gdb extent) which I intersect with the area of interest in order to extract the names of the targeted gdbs.  Right now I have come down to creating a custom transformer which is able to select the good 2 features classes but in order for my filters to work, I need to be able to input the list of the previsouly selected gdb names in my epxression. So far this is what I manage to do.  I know there is something missing but I can't seem to figure out what. Basically, what I need is a way to feed the list of attributes to build the expression that will filter what I need. Thank you for your help!

Hi, my attributes to expose in an jsonfragmenter comes from an user defined parameter, but I have to insert array brackets (like "WIND_6H{}"). How can I do this? It is only possible to edit this list manually or to take userdefined parameters, but not to edit the parameters dynamically.Thank you for your help!Christoph

I encountered something peculiar and I was wondering how/why this is the case. When I build a JSON document, I am able to fetch a number parameter, and parse that to a string.When I however try to do the same with a text parameter, and try to parse that to a string, I get an error. See below: Also seems related to this old community thread. In some sense I get the error 'undeclared variable' (since in XQuery the '$' is used for variables), but it seems odd that this error does occur for a text parameter and not for a number parameter, and I was wondering how that is possible. Of course there are easy solutions. I generally try to enclose user parameters in double quotes in these situations, like e.g. {    "key": "$(IN_Text)"}In that case, (data type parsing) functions also can be used, like e.g. {    "key": xs:string("$(IN_Text)")}But in this case that's a bit of a redundant example, as without that data type parsing function, the parameter is already inserted as a string. Just as a ca

I have created a workspace with the help of Mr. Takashi(a person from this forum) that reads the shapefile ,creates buildings then this buildings are separated in storeys and then the storeys are separated in roof,ground and wall surfaces. All this work is attached.I want to find a way to write this information in CityGML (Lod 2).In conclusion i want a workspace that gives me a CityGML writer with the buildings.

I have two Arc SDE Geodatabases. Both in different coordinate systems. I need to do a spatial filter. Can I temporarily reproject data to do the spatial filter? If so, how do I do that?

Hello FMEers,Here is your weekly FME news update, just a day late. Unfolded FormatIn case you missed it, we revealed the new Unfolded format reader and writer last Tuesday.   And it really was a reveal, because that format hasn't even been exposed in the FME betas yet. But when it is available, do give it a try. I just created an account on Unfolded itself and it certainly looks like a useful platform. FME TerminologyI'm sure you've noticed that by clicking "More" on the FME Community menu that there is an option to access documentation. But what you might not have noticed is a newly added link to the FME Terminology page:  The FME Terminology page looks like this:  It has been available for quite a while, but fairly well hidden from view! Now that you can find it through this link, I hope that you'll share it with other FME users - especially beginners - to help them understand the terms we use in FME. Deprecations and Other ArticlesThere are a few new and up

Hello, I'm currently reading multiple data sources with a File/DIRECTORY reader and then using the path to read data whether its from a gdb, shp or json. I'm having trouble understanding how I can manage to read ONLY features that have a POLYLINE geometry. I'm guessing there is something to do in the constraint parameters of a FeatureReader transformer but, for the life of me, I can't seem to figure it out.Thanks for your help!Anne-Marie

Hello, FMEers. Here's the latest news for you... Conference TrainingA traditional part of the FME User Conference is pre-conference training.   As we plan for the upcoming conference, we're gathering interest on training course topics and welcome your feedback. We've created a survey that lets you vote for existing course ideas or submit your own. If you are interested in filling it out, we'd appreciate you doing so by Feb 4th. If you already signed up for training courses from a previous postponed UC, don't worry. We will be in touch with details of any changes.  World Tour RegistrationsSpeaking of FME events, registration is now open for the upcoming FME World Tour. The theme this year... performance and power in the form of motor racing!  So "put your pedal to the metal" and visit the World Tour website to browse the schedule of events and see when the World Tour is at a venue near you. Don't forget to click on the Virtual button too, to find online

I have a CSV file that looks like this:- ID,X_COR,Y_COR187347635,335375,369977185565488,282016,438601185768788,281568,438584 FME has classified the X_COR and Y_COR columns as time? I lost hours of work by not spotting this and getting mysterious geocoding errors.  I can't see an easy way to override it in the Reader and it doesn't make sense to me to have the time classification?  

I'm currently working in FME 2021.2 and trying implement a workbench that can do some dynamic filtering, etc by using a user parameter that defines which fields to act against. The workbench reads in zipped shp file(s) that can have different schemas each time it runs and I want to use a parameter to define which fields I wish to analyse. I can successfully get it to work when one field name is entered but never with 2 or more.Does anybody know what the parameter type should be (eg. text) and what format the field names need to be entered as (eg. VM_STATUS,R20AH or VM_STATUS R20AH)? When 2 or more fields, only 1 feature is returned. I know for a particular datasets that I should expect 207 which is what I get by manually selecting the fields when the data is cached while debugging the workbench. Thankyou for any time spent looking at this

I'm struggling to understand why I get different results for what should essentially be the same transformers. I created a set of sample data and workbench to demonstrate my question.  Using NeighborFinder I'm getting points about 6 miles away from my test point. Using the same test point and using GeographicNeighborFinder I find the correct nearest points only 5 miles away. Since all my data is in same LL84 I don't understand why NeighborFinder isn't giving identical results.  I'm asking because I eventually have to run millions of features and GeograpicNeighborFinder is nice but has a lot more overhead and will take much longer to complete. I don't need the extra features if NeighborFinder would give identical results.

Last week I was contacted by a colleague to process a text based dataset that reminded me of something I had seen in the past for Fortran based datasets.  In particular, the text based dataset looks somewhat like a CSV dataset, only now columns are separated by a fixed width. See below for an example of how it looked:I was wondering if there is maybe already some type of reader that can deal with such type of data? Of course, if you get such a dedicated dataset, you can use a text_line reader, cut/split the text line into separate features (based on the known width (e.g. using a '#s#s#s' format string in an AttributeSplitter, see third example on the documentation page)), and then using e.g. an AttributeTrimmer to remove excessive whitespace. However, this method needs to be configured for each individual dataset, so I was wondering if there was maybe already a tailored made reader that could do this (by first automatically detecting the column widths).  Out of curiosity I crea

I'm trying to output CSV files to Word or PDF. Formatting issues... not sure which transformers to use and what settings to use... Thank you in advance!!!  

I want to use the RasterCellCoercer to polygonise a raster. I am using it in favour of the RasterToPolygonCoercer, since this one is running out of memory constantly when dissolving. So I would like to write the raster cells as polygons to a PosgresDB and then ST_UNION them.However, on the RasterCellCoercer I am unable to retrieve the band values. There is only one band. The _band{}_value field is always empty. When I use the RasterToPolygonCoercer I get the expected values.Could someone give me a hint on how to solve this issue? Thank you in advance!

A while back I developed a workspace in which I wanted to calculate the 'outsideWallArea' of buildings. That is, whenever buildings are directly next to each other, the touching wall that they both share, shouldn't be counted as an outsideWall. So for example, consider these 3 buildings (cubes with sidelength of 1);Now both building 1 and 2 would have an outsideWallArea of 3, and building 3 would have an outsideWallArea of 4 (note, the floor and roof do not count as wallArea). For this purpose, I used a SurfaceOnSurfaceOverlayer on the buildings. In this way neighbouring buildings fall apart in individual IFMEFaces, and by using the _overlaps attribute neighbouring walls can be excluded from the (outside)WallArea. The 'problem' now is that disjoint buildings are not overlayed to other buildings, and these keep having an IFMECompositeSurface geometry, where neighbouring buildings fall apart in IFMEFace geometry features. So after this step I need to distinguish betwe