Skip to main content
  • EN

FME Form

A space to discuss FME Form

10000 Posts
B
bek
asked in Transformers
Polygon Overlaps from two datasets with Percentages

I need to generate a list of polygons from Dataset Y that overlap with Dataset Z and the percentages each polygon overlaps the polygons in the other dataset.I’ve currently used a spatial relator > list concatenator to find overlapping polygons but it then requires a lot of additional work in excel to get it into a usable table so I am not getting results in the format I need.The data essentially looks like the follow example and I need something similar to the Ideal Resulting Dataset or in a format that is easy to follow or easy to turn into that dataset.Example Dataset Y1234 Dataset ZABCD Spatially Datasets Y and Z:Ideal Resulting Dataset:

3674
topotoma
Contributor
C
clickingbuttons
asked in General
How do I *write* a TIN so I can open it in ArcGIS Pro?

Using the TINGenerator with 3D points as input, I get edges, triangles, surface and points. This looks fine in the inspector, and I can write the results out as e. g. Multipatch. I would like to write the result(s) (just the surface really) out to be readable by ArcGIS Pro as a TIN, like the result of the "Create TIN" GP tool. How do I do that? "Esri ASCII Grid" fails no matter the input and the adf writer (the TIN files in the Pro-created TIN folder end with *.adf, mostly) wants to write e00 files. 

2790
nielsgerrits
VIP
A
asherk
asked in Data
Writing CityGML generics attribute

Hi,  I am wondering how it is possible to write generics attribute in CityGML?  Any help appreciated :)  Regards,  Asher

606
aklamwis
Contributor
naveen
Contributor
naveenContributor
asked in Transformers
Feature reader - version differences

I am trying to get version difference via ArcGIS Portal service and I am getting this error message : ERROR |Python Exception <KeyError>: 'rings' I am encountering this error message for only layer (pointing to polygon featureclass) on the service and the rest looks OK . In case I use other layers from the same service, its working fine and giving me version difference results without any issues.  If I do some edits from ArcGIS Pro and perform version changes, that seems to be fine for the same layer.  Thanks,Naveen

140
hkingsbury
Celebrity
arash_hokm
Contributor
arash_hokmContributor
asked in General
Erstellung eines Features mit pythonCreator

Hello FME Community, I get the following error message when creating features in FME using PythonCreator. Does anyone know what the problem is?

102
hkingsbury
Celebrity
pinkopo
Contributor
pinkopoContributor
asked in Transformers
Read SDE feature class by csv, keep attribute and apply filter to each layer

Hi guys,im using a CSV file + feature reader to manage SDE feature classes get read into my workbench. In this csvI also have a list of filter and attribute to keep/rename for each of these layers, im wondering what's the best practice to do this - is there an easy way i can apply my csv file rather than repeating tester / attribute renamer for each layer? thanks guys as always!

214
pinkopo
Contributor
epro_admin
Contributor
epro_adminContributor
asked in Transformers
Update 3 out of 10 Excel tabs in a spreadsheet

Hello! Not sure where to put this. I'm sure others must have tried this and figured it out before.  We have a spreadsheet with 10 tabs. 3 of those tabs we'll have automated via an FME workspace.  Question 1 - Is it better (or easier) to purely overwrite or append? We have an excel template set up as the formatting (font size/ auto height) need to be followed. The scenario here is we are keeping track of communications and creating a new row each time there's a new communication. Is anyone able to share a screenshot of what the parameters should look like? I am getting confused by truncate/insert/update, templates and named range and how they all work in this situation. Is it possible to only overwrite the three tabs or if I select overwrite does that imply the whole spreadsheet. I notice there are two sections to control parameters  I'm a little bit unsure of setting up a named range since the list of communications will continuously grow. There are still those other 7

570
debbiatsafe
Safer
cavarly
Contributor
cavarlyContributor
asked in Transformers
Using an xml document as schema resource for a dynamic writer.

My question concerns when a resource is read when using a dynamic writer. Is it read at the start of the process or immediately before needing when dynamically writing? I am modifying the xml schema in my workspace and overwriting the file. However from what I can see the resource has already been read and applied as the schema. Should the resource be read just before the writer needs it or at some earlier point? Could I use an attributefilereader to read in the xml as an attribute and use this as a schema attribute just before the writing bypass this issue? Thanks,Ian

1370
danminneyatsaf
Safer
cnorth
Contributor
cnorthContributor
asked in Data
JSON file with a field yourDateOfBirth with a UK date format (DD/MM/YYYY), DateTime Converter not Converting to US format

in in FME Json Reader following,{"yourDateOfBirth":"15/08/1987"}become column yourDateOfBirth with a value of 15/08/1987, I need to convert to value 08/15/1987? Thanks

601
redgeographics
Celebrity
galigis
Enthusiast
galigisEnthusiast
asked in Transformers
Geometry Challenge - Perpendicular line (Same X Coordinate)

Hi All,  I'm working on a workflow to identify if line is perpendicular and shows the same X at both vertex . Below a screenshot that shows a line pointing to the north but the X (top vertex) is different to X (bottom vertex). The aim of the is fail the lines which are not perpendicular and show different Xs, I was thinking about TopoBuilder but can't get it to work, Any ideas? Thanks :)     

563
galigis
Enthusiast
galigis
Enthusiast
galigisEnthusiast
asked in General
@DateTimeFormat in FeatureWriter with multiple sheets

Hi All, How can I force FME to write a single excel file with an unique DateTime value for all the Excel sheets included in a FeatureWriter? see the details below: Atm FeatureWriter writes a 'datetime' per excel sheet therefore export multiple xlsx instead of one single excel file. Any ideas? 🙂    

323
redgeographics
Celebrity
dean.mcgowan
Contributor
dean.mcgowanContributor
asked in Transformers
How do I convert a multiband raster to a NetCDF file with a time variable?

The netcdf format is new to me. I have created a multiband raster with 50 bands. Each band contains values for 1 day. My workflow looks like this: The sampler to the left is for testing only and lets 7 bands go through. The listbuilder creates a list of values for the 'days_since' variable. I want to use these values in the writer for the 'netcdf_band{}.coordinate_variable{}' port.How do I apply this as a list? At the moment I have to apply them individually day for day in the attribute manager before the writer.This works but is obviously not scalable. Any help in this matter would be much appreciated - I have thousands of bands to include! :)

1812
dean.mcgowan
Contributor
jugoslaviaa
Enthusiast
jugoslaviaaEnthusiast
asked in Transformers
Unable to convert OGCGEOPACKAGE wkb_multi_polygon to compatible FME geome

While reading a gpkg file, I am getting the following error, Does anyone know what i can get over this error?

622
geomancer
Evangelist
marta.podsiad
Supporter
marta.podsiadSupporter
asked in Data
Rename feature classess in gdb (dynamic schema)

Hi, I am trying to rename feature classes in the gdb. I have found couple posts about this but I got FAILED when I implementing suggested soutions. What am I doing wrong? 

720
marta.podsiad
Supporter
dxirgu
Contributor
dxirguContributor
asked in General
HTTPCaller version 2022.2

Hi!! I've got a problem in FME Desktop 2022.2 that I did not have in FME Desktop 2021.2 I have a workflow that makes POST request to ArcGIS Print Service in order to get an image of a map. We upgraded version and this workflow it doesn't work right now. It shows the following error:  "The encoded string is not a valid fme-wwjd string" The content of this string is a JSON that I need to do my request. As I sayd, the same workflow it works on version 2021.2Does anyone has any idea what happen?

11821
david_r
Celebrity
featuremichael
Enthusiast
featuremichaelEnthusiast
asked in Transformers
convert .RGB files to .ECW

good morning fme intusiasts I need your help. I have to convert .RGB files to .ECW and unfortunately I have no possibility to install "https://gdal.org/programs/gdal_translate.html" GDAL_Translate, which would save me a lot. it is about the "Intergraph Raster Reader/Writer" (https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/ingr/ingr.htm?Highlight=intergraph) Is there a possibility to use this reader/writer ?  Kind regards Michael

5511
featuremichael
Enthusiast
arekpierchala
Contributor
arekpierchalaContributor
asked in Data
How to get georeference for objects placed on Autocad paper space? Any parameter or format attributes?

HiI've got ACAD file and need to migrate objects placed by operator on autocad paper space. FME can read paper spaces (parameter 'Read Paper Space') but objects have got coordinates related to paper spaces. Is there something to get georelation for paper space and map data?

317
gisbradokla
Enthusiast
mzondervan
Contributor
mzondervanContributor
asked in Transformers
Converting JSON nested point coordinates to lines

I'm using the HTTPCaller to read in an MDS data feed that I would like to convert to an AGOL line feature by connecting the points together from the "route" attribute. I'm able to extract the attributes for each trip in the dataset using the JSON Fragmenter and JSON Extractor, but I'm getting stuck on creating the geometry. How can I take each point coordinate from a trip and connect them into a line and keep the trip attributes associated with it? Example of the JSON format is attached. 

1234
mzondervan
Contributor
K
koenrv
asked in Data
FME basic training, PostGIS database connection ,

Hi, In the FME basic training I am trying to create a PostGIS connection for Exercise 4 'FME Hackathon' (page 430).The Hackathon PostGIS Database should be located at postgis.train.safe.com, but I cannot get a connect with it using the given parameters (below). I followed the steps Tools -> Database Connections -> Add Database Connection.Host: postgis.train.safe.com Port: 5432 Database: fmedata Username: fmedataIn the log window the following error appears:Error connecting to PostgreSQL database(host='postgis.train.safe.com', port='5432', dbname='fmedata', user='fmedata', password='***'): 'server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.'Isn't the server online or am I doing something wrong?My version is: FME Workbench 2017.1Thanks,Koen

24326
nathanherzog
Contributor
deanr
Contributor
deanrContributor
asked in General
Why does featurewriter hang when I import featuretype from dataset in Flow 2023?

Why does featurewriter hang when I import featuretype from dataset? Is this a bug?  FME Flow Version: FME(R) 2023.1.1.0 (20230928 - Build 23631 - WIN64)Windows Version: Windows 10 Pro for Workstations (Build 19045.3693) I add a FeatureWriter to the canvas.I open its configuration dialog.I set the format as Microsoft SQL Server Non-SpatialI set the connection one of the Database Connections I have saved in FME.I click the drop down menu below the Feature Types input port list and select Import from Dataset...I select the table from the dialogs.The table attributes are loaded and the table shows up in the Feature Types input port list.I close the dialog and the FeatureWriter transform is now not accessible and immovable. I am able add other transformers, readers, and writers, but if I resize the Flow window, the window panes do not resize with the window.

185
deanr
Contributor
paul_c_2
Contributor
paul_c_2Contributor
asked in Transformers
Want to read in a varying number of excel sheets with different schemas then write out into a single excel workbook, fanning out by dataset. The dynamic reading is the issue.

I have a report coming out of an out-of-the-box Vertigis Studio workflow that is written out as multiple excel files. Each has the title Results (number) e.g. Results (1), Results (2). (The dataset name is exposed as the tab name, for some reason and not the file name). If I were reading a group of spreadsheets with the same structure, I would just set the reader to read *.xlsxw, and it would be non problem. However - here I have differing attribute schemas.  The datasets called by each report vary depending on a spatial interaction, but come from a finite list of possibilities. And as I say, the attribute schemas can vary.  I need to read all files of the output, expose attributes and write out into a single excel sheet, fanned out by dataset (presumably using the FME basename - is it possible to grab the tab title instead?) I have done the reading thus far using a Reader set as pic attached ...however, this isn't dynamic. Moreover, this workspace needs to be usable by a relativ

1530
danminneyatsaf
Safer
joepk
Influencer
joepkInfluencer
asked in Transformers
Change a string and efficiency of transfomers

Hi everyone, If I want to change a numeric value of an attribute, I tend to use the ExpressionEvaluator. I kind of see it as the 'transformer equivalent' of the Arithmetic Editor. Is there a 'transformer equivalent' of the Text Editor as well? I guess there is the StringReplacer, StringConcatenator, AttributeManager, etc., but which one would be the best/most efficient to use? And speaking of efficiency, I have another question regarding transformers. A colleague of mine told me a while ago that, for debugging's sake, it is wiser to use e.g. an AttributeCreator, AttributeRenamer and AttributeKeeper in series instead of using a single AttributeManager to perform all those tasks in one go. I tend to agree with them on that, but does this also have any consequences for performance? I can imagine the difference being minimal, but best practices and all that. Thanks in advance!

120
redgeographics
Celebrity
mathiku
Supporter
mathikuSupporter
asked in Transformers
XMLUpdater - doesn't work on fragments?

I've always had a hard time with XMLUpdater, but it usually ends up working. This time I just can't make sense of the errors and how to solve it. I have two XML, I want to take elements from one of them and use those elements to replace the elements in the other XML.  If I take the exact text from the XML-fragmenter at create an attribute containing just that, the XMLUpdater accepts it and produces the expected result.If the XMLUpdater is part of the same flowpath as the XMLFragmenter the XMLUpdater will throw an error.I even tried putting it into a new attribute with different datatype. Can that be right?? The attached workspace is made in FME 2023.2 but the error is the same in FME 2022.2.Any help or ideas is appreciated.

604
mathiku
Supporter
lifalin2016
Supporter
lifalin2016Supporter
asked in Transformers
XMLUpdater woes

Hi.I haven't really used XML Updater before, but is now tasked with trying to update certain sub-elements i a large hierarchy. I'm trying to update QGIS project files (QGS).I've extracted the needed replacement tag with content, and routes them in via the "update" connector. But I'm stumped wrt. how it's set up correctly.My XPath is set to be this: //field[@name=fme:get-attribute("fieldname")]/editWidgetThis is the location of the tags I want to update (replace) in the source XML file.But it doesn't replace anything, and it errs with this somewhat cryptic message in the log:XMLUpdater(XQueryFactory2): The following error occurred while executing query number 1:XMLUpdater(XQueryFactory2): The following error occurred near line 2, column 26 of the query:XMLUpdater(XQueryFactory2): invalid expression: syntax error, unexpected "type"My replacement XML tag looks like this (example):<editWidget type="TextEdit">            <config>              <Option type="Map">           

10512
mathiku
Supporter
skibhof
Participant
skibhofParticipant
asked in Transformers
Is it possible to make sure new attributes created in Python Caller is automatically exposed?

I'm using Python Caller with the module ifcopenshell to validate properties and naming of Ifc entities.To do this im also using an excel file that lists the requirements, and the script is now dynamically creating attributes based on the excel file. My challenge is that i want to write a excel file with the results, but i dont want to manually decide wich attributes to expose so the reader can access them.Is it even possible?

480
david_r
Celebrity

Badge Winners

Show all badges

Community Stats

31,840
Posts
120,940
Replies
39,474
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.