FME Form

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 

I am wanting to change the the background color of a table cell based on the text value within the cell. I.e. if the value in the cell is "Good" change the background color to green and so on. I am converting an excel table to html table using the HTMLReportGenerator then created custom html where the script below runs but the output doesn't work. I just get the html table with no background colors. The jQuery code below seems to work when testing it using this site - jQuery toggleClass example - JSFiddle - Code Playground : <script> var cell = $('td');  cell.each(function() { //loop through all td elements ie the cells var cell_value = $(this).html(); //get the value if (cell_value == "Bad") //if then for if value is "Bad"  $(this).css({'background-color' : 'red'});  // changes td to red.  else if (cell_value == "Good") //if then for if value is "Good"  $(this).css({'background-color' : 'gr

I would like to import a select number of tables from Oracle Spatial Object into ESRI geodatabase_SDE (ArcSDE Geodb), where they are given a new table name.I can do this one table at a time, but is there a method where I can batch or loop this process, as I have a large number of tables to process.I have both the required input and 'renamed' output table names in an excel spreadsheet.Please note - I do not want to import the whole database, only a select number of Oracle tables which are then given a new name in SQLserver.

I would like to save the feature count from a reader and later use it as a conditional check before writing the data back to the database. For example if the reader feature count is 600, I would like to make sure there are 600 features after processing and before writing the feature back to the database. I have experimented with trying to connect StatisticsCalculators to get the count, VariableSetters /Retrievers and the Terminator, but cannot get everything to work and it seams overly complicated for something so simple. Especially since I can see the feature count on each connection line. Any input or suggestions?

FME DesktopFME(R) 2019.1.3.1 (20191019 - Build 19643 - WIN32)Running on a server with Windows 2008 R2 service pack 1 I have a workspace that uses an HTTPCaller transformer to get a user token from ArcGIS Portal. I then take that token and use it to read features from an ArcGIS Server Feature Service. This works fine. Then, I use that same token to write to an ArcGIS Server Feature Service through the ArcGIS Portal Feature Service writer. I do this because there is no ArcGIS Server Feature Service writer. But I'm not able to get it to work. Is there a better way to do this (write to a Feature Service sitting on ArcGIS Server)? Below is a screen shot of the ArcGIS Portal writerAnd below is the error from the log. Note that the writer is appending "sharing/content/users/https:?f=json" to the URL. Creating writer for format: Esri ArcGIS Portal Feature ServiceTrying to find a PYTHON plugin for writer named `ARCGISPORTALFEATURES'The workspace does not contain user Python. FME will attempt to

I have CAD file with nomber of layers, each layer represent landuse, i want to knew what transformer i should use to convert the CAD file into GIS personal database , the output to be one feature class and landuse use to be saved in one field.

Hello, i'm trying to read a geopackage via the featurereader and performing a where clause to read only the necessary data - it's not working! is there a known problem with fme 2020 and the featurereader with geopackage?

I have developed a workbench that reads from Oracle SDE geodatabase and writes to a filegeodatabase. If I run it from fmeworkbench, it works fine but if I run from a command line, I get the following error: The Esri Product license used by this machine does not include licenses for the 'ArcServer' licensing levelThe ArcObjects license 'Standard' is being selected from the Windows registryThe Esri Product license used by this machine does not include licenses for the 'Standard' licensing levelThe ArcObjects license 'Standard' is being selected from the Windows registryThe Esri Product license used by this machine does not include licenses for the 'Standard' licensing levelUnable to load a library in the folder: D:\\Program Files\\ArcGIS\\Server\\framework\\runtime\\ArcGIS\\bin64. The error number returned from GetLastError is: 126I have 64 bit background geoprocessing installed. ¿Is it not possible to run it from a command line? 

Hi,I'm creating objects in 5 different tables and I have a requirement for the object's IDs to be unique accross all 5 tables. I also need to set the starting ID value with a UserParameterSuppose I had 3 features created in each table.My objective would be :Ids 1 to 3 in table AIds 4 to 6 in table BIds 7 to 9 in table C...Would anyone have a suggestion for the best way to do this?I've tried with counters and feature holders but I haven't been successful. Strangely, I get something liketable A : 1,2,3table B : 1,2,3table C : 4,5,6although it seems to me I'm doing the exact same thing between table A and B and between table B and C... Cheers !

Hello, New to using web services here. I am trying to use oauth2 login to Portal ArcGIS Server feature service on a specific layer index and use the REST Query function to pass in a couple of parameters and then have the output to json format.  For instance this is the ArcGIS Server Feature Service on a particular feature layer (e.g. index 3) https://ppp-snoopy.com/un/rest/services/SnoopyUN_Network/FeatureServer/3  Then pass in the string query parameters according to this reference page Query (Feature Service)—ArcGIS REST APIs | ArcGIS Developers  where: GUID = 'abc1234xyz'gdbVersion : Snoopy.Surveyoutfields : objectid, GUIDf: json I am trying use HTTP Caller to access the ArcGIS Server feature service using NTLM authentication and got this error :{"error":{"code":499,"message":"Token Required","details":[]}} I also tried to use direct URL to the ArcGIS Server Feature Service (without Portal) and no luck.  Any help wo