FME Form

Hello,An enterprise geodatabase reader interprets a value in a date field as: 20130426000000A file geodatabase reader interprets the same date value as: 20130426This is a problem when comparing date values in ChangeDetector, as they are always noted as an update, even though they are essentially the same value.Does anyone have any ideas on how to make the 2 dates comparable?

Hi there, I'm using the UpdateDetector transformer and it's detecting changes with lat/long fields where numerically there's no difference. This is because in one reader (the CVS reader) these two fields have trailing zeros, while in the other reader (an oracle table) they do not. What's the best way to resolve this?

RegEx, FontEncoder and StringReplacer experts, please help! I want to replace regular text characters in a text string attribute with entirely different unicode characters, and be able to use them as geographical labels.For instance, let's say that I want to convert the character "A" (unicode U+0041) in my text attribute, to the Roman numeral "I" (unicode U+2160), and label my map with that.  Some other characters should use other conversion codes - maybe using a lookup table. Is it possible?

I am working on creating a geodatabase made up of multiple types of proformas, a total of 67 different proformas. The proformas contact collected survey data of differing species and spatial data.

Good Morning:We are trying to transform autocade dwg files to GeoTIFF. The log indicates that the 17,000 features are read except for the raster feature. Thus it fails when we try to write during the conversion.I've attached the read log and the failure to read the raster

Does FME support ESRI Representation when mapping data between two file geodatabases? If so how do you go about setting this up?  Thank you, Sam

Hi, I am trying to IMPORT an EXISTING relationship feature class and FME complains about the name being too long....I cannot rename the Relationship feature class since it is a part of an existing data model. The table/feature class name 'WaterstaatswerkWaterkering_Waterkering' is too long for Oracle (!!??) to accept. Please shorten the name and try again I think this is a FME limitation that should apply if you are going to CREATE the table, but should not apply if the table/relationship feature class already exists! Anybody any thoughts/ ideas on how to go about this?

I have a .dgn model that I am converting to a tileset but some of the input is just lines that I should 'fill' (see image attached). My initial though process was:Create areas from them, with the config from the imagesThen pass it through a MesbuilderBut what I'm getting from the AreaBuilder and the Meshbuilder is off (images attached)I am not sure what's wrong, I tried playing around with the snapping tolerance value in areabuilder but the higher it got the worse it looked. Any advice would be greatly appreciated.Thanks in advance!

When using PointOnPointOverlayer (POPO), after FME 2018, I experience performance issues. With FME 2018.1.2.0 (20190225 - Build 18590 - WIN64) I could use the POPO with 600,000 records and this portion of the job use to run in 30+ minutes. Now with FME 2020.2.1.0 (20201130 - Build 20806 - WIN64) it takes 7+ hours. I also tested briefly with FME 2021.1.3 (Build 21631 - win64) but saw no significant improvement. What options are available for removing this additional 6.5 hours of processing time? Similar issue to this article from 2017. Thank you in advance for your time :) Julia Highlights from the logfile:2021-10-21 14:11:59|  0.4| 0.4|INFORM|FME 2020.2.1.0 (20201130 - Build 20806 - WIN64)2021-10-21 14:11:59|  0.4| 0.0|INFORM|FME_HOME is 'C:\\Program Files\\FME2020\\'2021-10-21 14:11:59|  0.4| 0.0|INFORM|FME Desktop ESRI Edition (floating)...2021-10-21 14:12:50| 50.4| 0.0|INFORM|Creating spatial index of 2 point features2021-10-21 14:12:50| 50.4| 0.0|INFORM|Completed spatial in

I am trying to use DatabaseUpdater but it appears not to work with a versioned SDE Table. Is there a work-a-round?

Hi. I was trying to figure out a way to rename all the fields of my output shape using a PythonCaller. I used the "BulkAttributeRenamer" to rename the fields, but just using a single parameter as: prefix, sufix, lowercase, uppercase etc and it's not enough. When I tried to use PythonCaller, I could change only the attributes itself, but not their field's name (I used the function setAttribute(name, new_value))Is there a python function that can set the AttributteName ?

I get an error when I use the WMS reader. I add the the URL as: "https://wms.abc/ServicesWhen /abc.Proxy/wmsserver.ashx?password=yyy&username=xxx" That works, as I can see the layers from which I chose the one I want to load in. I dont select any "Network Authentication" option. I leave the Map options as get filled out from WMSs metadata. After pressing OK, the reader is successfully shown on my canvas.  When i want to run this reader, without having it connected to anything, it stops with a fatal error. I can see it made a WMS URL, where the username and password are used at the start and also end of the URL. That is also failing if I place it in a browser. But just by removing the closing un/pw, it all works in the browser.  Does anyone know what induces this double credential issue?   https://wms.abc/Services/abc.Proxy/wmsserver.ashx?username=xxx&password=yyy&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&LAYERS=DK-DDOland1995_80cm_UTM32ETRS89&

I’m trying to define a transformation process between Intergraph GeoMedia SQL Server Warehouse (Reader) and Esri Geodatabase (File Geodb API) (Writer) using FME Workbench 2015. I have defined a schema file in a spreadsheet that is added in the Workspace Resources (Schema - From Table) to be used as Schema Source for my writer. The features that I am reading are coming with geometries like: `fme_geometry' has value `fme_aggregate' and `fme_type' has value `fme_point' OR `fme_geometry' has value `fme_point' and `fme_type' has value `fme_point'. Basicly this means that my source contains multipoint features and single point features. In my schema file I have defined the Geometry Type Value as fme_point. When the process tries to write the multipoint feature it fails with the message: Failed to write Geometry to feature class … with geometry type 'esriGeometryPoint'. The process works if I manually set the geometry output to geodb_multipoint but I w

How can I convert raster boundary to polygon? Raster Domain is equivalent tool in ArcGIS / Pro.

Can FME desktop call Open API data after receiving coordinate information from a file? Basically the client will supply a lat/long from CSV file and then we want use those coordinates to get data from our API source. Request format: https://<apiURL>/data/lat={lat}&lon={lon}&exclude={part}&appid=[API KEY]

Currently, I'm seeing all files uploaded as 'application/octet-stream'. Not that this is a terrible failure, but I'm trying to respond to uploads in the bucket with cloud functions that will follow the content-type as best as possible to determine subsequent actions.  I'll use file extensions for now.

Does FME support writing to Citrix Sharefile?

Weirdest behavior, I have a 'pipeline' with a set of transformers that do the job by themselves without parameters, let's call this the 'prototype' pipeline.I can copy this prototype pipeline into any workflow, it will work just fine, until I remove this pipelines starter and it starts behaving different.This prototype pipeline has a snakegrid transformer at the end, with the starter behind the pipeline I get the output, if this prototype is connected to another pipeline the attributes arrive to the snakegrid transformer but they don't go further from there. This seems to me like a bug because the prototype pipeline has no variables in it, everything is hardcoded and is working by itself so connecting it at the end of something else shouldnt be the problem, but it is. Any advice?

Attached my ifc file. I changed the ending from ifc to txt. 

Hi all,I was wondering if the same way that I can easily access to the layer content via ArcGIS Online, ArcGIS... can be made too via FME Desktop. I've tried the "Esri ArcGIS Portal Feature Service" reader, but not sure if I needed to have credentials for authentication. The URL:https://geodata.antwerpen.be/arcgissql/rest/services/P_Portal/portal_publiek2/MapServer/83 My purpose is to only read features from that service.Thanks,

I have an excel file with many sheets. I need to process each sheet separately. How would I go about doing this?

Undefined macro `SourceDataset_FILEGDB_3_FILEGDB_3' dereferenced in file `A:\\...\\...\\FME Worksapces\\wb-xlate-1459541027202_6756'Program TerminatingThis error happened to me today for no identifiable reason. If anyone has encountered this issue or has an idea as to why this could happen I encourage you to share your thoughts here. After this happened two files were created in the folder where I store my work spaces (Not where temp files go).wb-xlate-1459541027202_6756ANDwb-xlate-145865875395_6136A peculiar thing happened to one of my readers and it kept "resetting" to not being set (<Not Set>). So you could not open the containing folder or edit the path. It had no options, but the schema and the reader were still in the workspace.At first I tried rolling back to the very beginning of my work flow history to check if the translation would run when it used to run, but no, I got the same error.The problem can be fixed by copying over the entire workflow into an

I want to single out polygons that share only one edge with other polygons. In the example below the polygon circled in red has one shared edge whilst the blue polygons have two neighbouring edges.  I have tried everything I could think of using TopologyBuilder but have not found a way to separate "reds" from "blues". I can't find a useful patern amongst lists and attributes. Any suggestions on how to count how many of a polygons edges are shared with other polygons? 

So I got a dataset, floorID and Unit Number. Here is what I want to do.  For each of the floorID (meaning each floor), the unit number should start from 0001 to the max number in sequence. For instance, in my example, there are 4 floor ID "level1", the unit should be 0001-0004. In contrast, there are 3 floor ID "level2", so the unit should be 0001-0003. In my case, the input of floorID and unit number is unknown. But I want to find out the missing unit numbers or wrong input unit numbers. Could someone guide me how to work in this case? I have attached the correct and wrong output in here. Oh, also, I have another question. This is the sample of the data1-1, 1-2, 1-32-1, 2-2If I want to see if the incoming input is within this value, might I ask what kind of transformer should I use? Do I need to input these values manually? Thank you very much and sorry for all the questions. Zach