Best Answers

Hello,I'm looking to read a feature class from a GDB (for testing purposes, but eventually this will be many feature classes so this process requires minimal manual handling) and add the date on the end YYMMDD and write back into the same GDB.E.G READ - "TEST"WRITE - "TEST190415"I've look at ways of doing this and not many seem to work. The closest I've got is to set the reader to expose the 'fme_basename' -> Date/Time Stamper -> Date/TimeConverter (adding _date column to attributes) -> Attribute Manager where I add a new attribute called "New_name", the value is @Value(fme_basename)@Value(_date)The write is set to Dynamic Schema Definition with the source as the GDB used and the Schema Definition Name set to "New_name". The output is the GDB name. When I edited this to just the _date, the output was the date.So the basename is being read as the gdb, and the date is being picked up in the new attribute. Can someone p

Hi there,I've never had to use the workspace runner before, and I'm kind of lost on how to set it up in the way I need it to function.So currently I have a very simple workspace that is essentially just a SQLCreator and an Excel sheet writer outputting some measurement summaries. My SQL statement connects to a PostGIS database, which contains a list of per-country tables. All these tables are named the same (i.e. "France_full_2019", "Ireland_full_2019") except for the country name.In this workbench I added a plain text parameter in the SQL lines instead of a specific country, so in this way, running the workbench, I can type "France" in the parameter window and get France's data. This all works perfectly fine and as intended, but of course limits me to 1 country at a time...This is where my request comes in:I want to know how to use the workspace runner to somehow input an entire list of countries and have it run the above mentioned workbench f

Dear all,I hope you can help to solve this question. I need to calculate Length ranges and I have as data class and Length. Can you help me please?Class Length Lenght-rangesA-1 100 100A-2 250 (100-250) = 50A-3 300 (250-300) =50B-1 10 10B-2 30 20B-3 80 50C-1 40 40C-2 100 60C-3 200 100

Hi I am trying to install FME Desktop 2019 onto an off network laptop Windows 10. Attached is the error I get during installation. I tried installing an older version of Desktop 2018 and this also gave me the same error. Then it rolls back and undoes the install.

I have lost the instructions for the FME Solar Powered plane. I was wondering if anyone had a copy of them as a pdf.

I have two KMZ files containing states and cities borders. I want to combine them and find out which city falls under which state as a result in some tabular format. How I can achieve this with FME? Are there any transformers available for this?

I do not see a reader yet that can read a GeoJSON file in S3. Rather than needing to download it via the S3 transformer.We would like to use S3 as a spatial data hub so it can be used by many tools.

Hi, I'm creating a new feature service in ArcGIS Online and it works great except the writer coordinate system is ignored, I get the default web mercator (3857). Is a particular version of coordinate system required on the features or how do I get the writer one respected? I know my desired CRS is supported by AGOL. Thanks all.

Hello,I'm working on a project where we need to run a mean-shift algorithm on a very large raster dataset. We've been able to do it with the Orfeo Toolbox in QGIS, however we've had some pretty serious stability issues with QGIS itself, and therefore we would like to run the algorithm itself in FME Workbench instead. Does anyone know if it is possible to import the source code or a bat-file and run it as a transformer in FME? Or, does anyone know if there is a transformer that is capable of performing mean-shift algorithm on raster datasets?

Hi all, I have overlapping polygons and I am using Dissolver to avoid this. However, I would like to keep some attribute from both polygons that are overlapping in case attribute value is different. For example, those polygons have attribute calls "Side" and i would like to have list of these in case of both polygon has different value for it such as Side = W and Side = E but if both attribute Side = W and Side = W. I want to do it because in some cases i have 6 polygons are overlapping and if i generate a list regardless from the values of those attributes, I am having very long attribute list. Thanks in advance. Best

I am looking for a way to close FME Workbench once a translation has completed. Is there an option somewhere for this, or possibly a shutdown script that could be used for this purpose?Ideally the solution would close only the current instance of FME Workbench, and leave other instances open.Thanks in advance

Our jobs pull from APIs with ever changing results. The caches WILL change. But FME 2019 won't let me re-run with feature caching on thinking that the data will be the same. It won't.

Hello, What we do is get KMZs and run the ArcGIS tool to convert them to to layers in a file GDB. When you use the layer in ArcMap there is a field PopupInfo, which has HTML data we need to extract?? I have tried several recommendation with HTML, but nothing gets me to where I can flatten the data out into a usable table. Please let me know any suggestions?

I am creating an XMLtemplate that loops through all the id\\value pairs in a list and creates an XMLelement for each. I got the looping working after reading through some of @takashi's post replys, but the $i variable is not getting passed correctly into the fme:get-attribute function on the list number. Am I going about this wrong? Is there a different way that I need to call the variable inside the function? <update_transaction object="ObjectNameHere">{for $i in (1 to xs:integer({fme:get-attribute("_Result_count")}))return (<attribute_value name="{fme:get-attribute("Inspection.Results.Result{$i}.id")}">{fme:get-attribute("Inspection.Results.Result{$i}.Value")}</attribute_value>)}</update_transaction>  

Hi there... Sorry about my English. I'm trying to translate survey drawings made in Autodesk Civil 3D 2017 and 2019 to GDB using CoGoPoints and Survey Figures. For CoGoPoints no problems at all, but Survey Figures are not supported at my FME ESRI Desktop 2017.0.0.1.If the Survey Figure is supported by FME Desktop 2018 or newest, I will ask to my company for a software update, if not I need change my strategy. Thanks in advance! Demetrius

Hello, I am trying to interpolate a raster surface from 3D points in FME like the Trend tool makes in ArcGIS but I couldn't find any tool like it. ArcGIS Trend tool definition: Interpolates a raster surface from points using a trend technique.  Is there anything similar? Thank you 

Hi everyone,I'm quite new to this community so I apologize in advance if I make some mistake in the introduction of my question.I have a column with building names (dromore lodge, killowen house, church of jesus etc.) and I want to use PythonCaller to capitalize each word except some of them like the articles (a, an, in, of...). I've tried this simple code with poor results :import fmeimport fmeobjectsimport re def processFeature(feature):    str=feature.getAttribute('BUILDING_NAME')    exceptions = ['a', 'an', 'of', 'the', 'is']        for word in re.split(' ',str):        if word not in exceptions:            word = word.capitalize()        feature.setAttribute("B_NameCap", word)     passWhat I have as a result is the last word capitalize as I want (Lodge, House etc.) in the column I've created (B_NameCap). I understand Python is giving me the last result overwriting the first one in the list.I've tried to .append a new variable with the capitalized data and .join the data anew to no

Hi there,I wonder anyone can help me on my query. I have a Point dataset and a Polygon Dataset they on ESRI file Geodatabase format.I have over 700 circles and 7million PointsPoint Data contain Premise Count , so I will require to sum up all Premises by each Circle and assign that number to each circle, including overlappingI have used Spatial Relater/Spatial Filter/Clipper none of them give me the correct answer. Let me know if this can be done using FME .  thanks,Regards,Pushpa

I published a project to FME Server and am utilizing the 'Workspace Sharing' function so that Users do not have to authenticate for this particular project. When they click the Sharing Link, the screen display 'FME SERVER' at the top. Is it possible to modify the 'branding / splash page' to utilize our utility name and logo to ensure the employees that they are within a secure trusted internal site??

Hello FME community,I have a fairly complex series of workspaces that dynamically harvest, validate and write featuretypes. We harvest using WFS and online GML.I have an issue where in FME Desktop (2018.1.2-b18590) the FeatureReader reads both the schema and the features, but in FME Server (2019.0-b19238) it doesn't create a schema feature in the gml FeatureReader, so when I want to dynamically write to my database it doesnt recieve a schema feature.The XSD and the GML are findable and downloadable by FME Server. The steps to reproduce this behaviour is to run it in Desktop, publish it FME Server.See attached an isolated Workspace to show my problem with the logfile saying in FME Server: 103 INFO Merged 0 schema features read from 1 datasets into 0 resulting feature types104 WARN UniversalReader -- readSchema resulted in 0 schema features being returned105 WARN Reader Parameter(0) = >https://geotest.drenthe.nl/website/ngr/am.xml168 WARN Reader Directive(..)176 WARN UniversalReader -

I have a dwg circa 1998 that contains among other things contours and spot elevations. All of these features exis in 3d within the dwg I have confirmed this using AutoCAD viewer as well as the FME inspector. The only place I see the elevation value is in the coordinates section in FME Inspector. I would like to covert these features to a shapefile and capture the elevation as an attribute but don't know how to expose this elevation value. 

Hello everyone, I have a street centerline dataset and I would like to identifying where there are T intersection (3 centerlines intersect at same point). Here is the image and I would like to find the highlighted lines. Thanks in advance. Best,

please see below the json response from a httpcaller transformer.  I want to extract the items (only id and type attributes are interested) and format them to new fme features with 2 separate fields id and type. I have tried JSONFragmenter (setting like below). However the output gives me a flat table with 704 records (352*2) like below. How to output a table of 352 records with two fields id and type?{"total": 352,"start": 1,"num": 352,"nextStart": -1,"items": [{"id": "5c6729ea37f84ffbb9ece1f428d83bf4","owner": "Admin","created": 1425413285228,"modified": 1547658596161,"guid": null,"name": null,"title": "World Population Density","type": "Map Service","typeKeywords": [6 items],"description": "","tags": [5 items],"snippet": "World Population Density data service provided by ESRI","thumbnail": "thumbnail/World_Populations.PNG","documentation": null,"extent": [2 items], 

Authentication fails when attempting to connect to ESRI ArcGIS Online feature service writer. After entering organizational credentials for AGOL, the error states "Failed to Obtain Refresh Token: Error retrieving access token". The translation log reads "java.lang.NoSuchFieldError:INSTANCE". I experienced this problem with FME desktop ESRI Edition v2017.0 and after upgrading to 2017.1 the issue still persists.

Hi, I'm trying to expose attributes from a JSON file using JSONFragmenter and it's working perfectly fine for all attributes except one which is stored in [] brackets. This is an example of how the JSON is structured:  [{"id":"5cad42","nummer:"697582","name":"place name","position":[51.51146259999999,11.5696619],"status":false}]  And once I have exposed the attributes I see all values except "position" value is missing, so I assume it has something to do with the [] brackets.  These are the JSONFragmenter Parameters:  Should something be changed here? I know it must be easy :) Thank you! Cheers,Linda