FME Form

I currently have 2 datasets - one is a set of records with a date attribute. The other is a schedule dataset with 2 attributes indicating the start and finish dates. I am trying to identify how I can query whether a record in dataset one is within the range of the start and end dates of dataset two, and then subsequently count the number of times each record appears in the range of dates The end result ideally is something similar to the statistics calculator where I would see each record with an extra attribute with a numerical value indicative of how many times that date has occurred in the range of the schedule dataset.

Hi there, I have merged two tables by using FeatureMerger and kept some attributes by using AttributeKeeper. when I am writing this merged table to Excel by using Writer, I am asked to choose a feature type from two. If I select one, the writes takes all attribute from one type. In that instance, some attributes from the merged table are left out. Can anyone kindly tell me how to overcome this issue? A screenshot is attached here. Thanks in advance.

I would like to be notified if there is any wrong attribute value in a non-spatial table which is read from SQL database by comparing with an spatial attribute table. In other way, I want to detect change if the attribute of a particular entry/row is different from each other. I have intentionally changed attribute values for two entries so that these two are picked. Both tables have few common fields but the schemas of the tables are not same. I have tried with changeDetector, Matcher and DuplicateFilter but not getting the actual outcome. Any help will be very appreciated.  In the attached image, 1 is the non-spatial table and 2 is the spatial attribute table. I have used attribute manager so that the attribute names in interest in both tables are same.  

hellowe migrated to new sql server (names changed from SERVER1 to SERVER2) and now jobs is failing.i open failing fmw file in FMW Workbench, changed sql server names in parameters (where found), saved file, but jobs keep failing.any suggestions?thanks.

In your experience, would splitting the feature flow and directing it into multiple, simultaneous SurfaceDraper transformers significantly decrease the processing time for a workspace, all else being equal? Let me explain what I am dealing with and why I ask ...I have 730K points (center points of square grid cells) and 2.1K triangular 3D polygons, overlapping with each other in both 2D and 3D. For each point, I must identify the triangles it intersects (in 2D) and identify the triangle that is lowest at that point's location, extracting the triangle's z-value as an attribute. For that, I use a SurfaceDraper -- see the screenshot above. Points and triangles go through a PointOnAreaOverlayer with output of both points and areas, and those two flows are directed through ListExploders to end up with two matched sets of equal size as input to a single SurfaceDraper transformer. Functionally, the workspace works fine, but the processing time is massive. The SurfaceDraper appea

I have an incoming string attribute e.g. 20220322100000 which I need to convert to milliseconds after epoch for writing to an ESRI Portal Feature Service. I can't seem to work around this output format error below in Desktop 2021.2?`Failed to evaluate expression '@DateTimeFormat(20220322100000,%s)'. Result is set to null'

Hi, I have the StatisticsCalculator that mysteriously looses one feature:I would expect both input and output feature count would be the same. The StatisticsCalculator doesn't do any group by: What am I not understanding?Thanks in advance!

I'd like to find some documentation or information regarding the lookup table attributes 'Type' and 'Mapping type' associated with the Schema Mapper. I have done a lot of digging around the FME knowledge base and cannot seem to figure how to format the values associated with the attributes.  This article has many different use cases associated with the Schema Mapper. I downloaded the associated FME Workspace and CSVs. The CSVs have different values assocaited in the 'Type' and 'Mapping type' fields.: https://community.safe.com/s/article/schemamapper-use-case-example?r=1807&ui-knowledge-components-aura-actions.KnowledgeArticleVersionCreateDraftFromOnlineAction.createDraftFromOnlineArticle=1  

They have more in common with the Min and Max Extents in the Feature Information window than down below where the geometry coordinates are. Should I expect the indices to align with the existing coordinates? Do aggregates change how the CoordinateExtactor works? It is really mystifying. Any insight is appreciated.

Hi,I am facing a problem while using the realdwg-writer to put out autocad files that include multi-texts (the process running in advance is doing fine). Many of my source files have multiple viewports with different scales (e.g. 1:200 and 1:100). Before writing the data, the values in the autocad_anno_scale list look like this:   When opening the resulting DWG file (input DWG is used as template), the aforementioned list includes additional values:  Because of this, some multi-texts get different sizes in the viewports in my written files than they have in the original ones. In the case documented by the screenshots, the text is depicted smaller although it should stay the same size, just like it is in the source file. I've tried some workarounds I came up with, but unfortunately without any success. Is there a possibility to control the sizes of texts when writing them to a DWG (or to just keep output sizes the same as input sizes)? Because I have to use my workbench on quite a n

FME Desktop 2022 Build 22304: “GeometryFilter” with and without “GeometryValidator” prior to it shows different results considering that nothing is repaired,  I couldn’t figure out why “GeometryFilter” with and without “GeometryValidator” prior to it shows different result considering that nothing is repaired. How come a “multiarea” is detected if the “GeometryValidator” is run before the “GeometryFilter” but never identified if the “GeometryFilter” is run without “GeometryValidator” prior to it?  What could be the issue here? The data is attached   

Apologies if this is a dumb question! What I'm trying to do is build a dataset extraction tool for a third party in the organisation, but need to keep any login credentials secure.

My FME translation includes 2 different streams depending on the type of data provided in a zipped file GDB. So the first step before processing data is to test whether it contains a rater dataset/mosaic dataset or any number of feature classes. I don't want to read data yet, just check the data type of feature datasets. What's the best way to check that? Tried a generic schema reader but it doesn't provide an attribute with the format of feature types inside the file GDB.

Hi,For some time, I used the following approach to open a KML dataset (both in Desktop for development, and in Server for operational use, version 2020.1.0.1, both running on Windows (server) OS): Create a public parameter "INPUT_FOLDER"Create a public parameter "INPUT_FILE"Add a KML Reader for a specific KMl file to the workbench, which defaults to a public parameter "SourceDataset_OGCKML"Make this a private parameter, and change the definition to: "$(INPUT_FOLDER)\$(INPUT_FILE)" I then use either UNC or local paths in the INPUT_FOLDER to point the reader to the correct location. Last week, we started migrating to 2021.2.4, which I installed on my workstation (windows). For the sake of completeness I think I should mention we are targeting an FME server running in a docker container on a linux host. This approach stopped working, with the message :2022-03-19 14:58:52|   0.8|  0.0|INFORM|Loaded module 'OGCKML' from file 'C:\Program Files\FME\2020.1.0.1\plugins/KML21.dll'2022-03-19 14:5

I would like to make a custom map for Power BI's Shape Map visualisation: https://docs.microsoft.com/en-us/power-bi/visuals/desktop-shape-map When I make a TopoJSON with FME and open it in Power BI I see a completely filled square (basically the bounding box is filled). When I take the TopoJSON generated by FME and process it using the default paramaters of the online mapshaper tool (https://mapshaper.org/) by exporting as a TopoJSON the mapshaper TopoJSON file open's without a problem in Power BI.  When I compare the FME TopoJSON files to the mapshaper TopoJSON file using a text reader the only obvious difference that I see is that the parameters are in a different order, but the scale and transformation parameters are similar. I have attached the files to this message. Any ideas on what I need to do with FME so that the outputted TopoJSON files will open in Power BI?

FME Desktop 2022 Build 22304: The “harmonize ad filter by fme_type” option in the “geometryfilter” appears not to be available, The “harmonize ad filter by fme_type” option in the “geometryfilter” appears not to be available in the Build 22304 that’s used to be in the Build 22257         Is this by design?

i would like to know : Does the data transmitted in encrypted form? https/TLSor which encryption form is using in FME Desktop ?please ,refer me to the documentation regarding to encryption form ,if available .Thanks in advance FME 2020.2

I am trying to extract records from one table based on a series of date ranges in another table. I want all the records from table A, that fall between date ranges from table B. Each table B row has a start date and end date.

Can GIS layers be setup via a relate in a workbench similar to how it is done in ArcMap

I'm not sure what is happening, but when I inspect a CSV the values in the CSV are not equal to the values read in by the CSV reader in FME Desktop 2021.1.0.0 Win64. Actual CSV ValuesFME Inspector As you can see it is not reading the first few digits of the easting values. Any ideas as to what might be the issue? My first thought was some sort of encoding problem, but wasn't sure. I've attached the CSV file in question.  

Hello there how could we move the blue line in order to make it parallel to the read one?

I'm restoring some data from/to a MS/SQL database, which has been stored in a PostGIS database.PostGIS lowercases all attributes, and I'm getting errors in FME when writing them to the original database, where attribute names are mixed case. The database itself uses collation Danish_Norwegian_CI_AI, i.e. Case Insensitive.FME is case sensitive, and I presume that's why it throws this kind of error:Existing table for feature type `PARKER.d_basis_attribs_kontrolflader_traer' does not have attribute with name `tr_bemaerk'. Cannot continueThe database table has an attribute TR_BEMAERK, i.e. as uppercased.How come FME doesn't respect the case INsensitivity of the target database ?It feels kinda stupid to have to rename all attributes needlessly, and no, they're all very mixed case, not all uppercase.(still) using 2020.2

Hi.I'm generally use the workspace repository to assign job queue when scheduling job executions, although I have a couple of special queues to enable high importance jobs to run sooner.But jobs that are not scheduled by the FME server itself, instead being initiated via the REST interface, all seem to end up using the Default queue.I've looking into the API example, and it doesn't seem to include a queue name request parameter. And there's no way to create a queue designated for REST initiated jobs.Is it possible to control the execution queue with REST initiated jobs ?Using 2020.2.5

Hi Please am looking for your INPUTS on different idea what kind of services we could develop. What are mote transformer for this industry . Data is mostly from indoor Surveying Data ( point cloud)  OPEN to any suggestion, ideas or help . Highly obliged with your response. thank you

Hi,I have a set of polygons following a line like shows attached figure. The distance between these polygons along the line are the same. Objective: I have to create some polygons at the end/beginning of the line in the same line direction. Line could be in any direction, not only horizontal. Method (FME Desktop 2020): The original dataset is a polygon shapefile, so (1) I have computed a layer with center point of polygons, and (2) I have constructed a Line (LineBuilder) with this ordered points to know the line direction. (3) I generate a new polygon at the beginning or end of this line at some known distance. The size of new polygon is the same as the original ones, and I have to translate the polygon along the line (In fact, I have to generate several (n) new polygons along the line equally spaced (d)): I have extend the line (LineExtender, n*d), split the line n times to get center points,and then I have to create a new polygon in every center point. Question: Is it possible to mak