FME Form

I need to have a choice parameter offering all the database tables of a specific database for the user to choose from before running the workspace.I do have the Python code ready, and created a scripted parameter, returning a list of all table names.I referenced the scripted parameter as input for the choice parameter, but that only gives me a dropdownbox with the name of the parameter linked to it. Is it possible to populate a choice parameter from a Python script (scripted parameter), and if so how?

Anyone come across .nt files (N-Triples) files? Their doesnt seem to be a native FME reader for it.

Something I recently learned about with FME is that each HTTPCaller seems to equate to one session - there are most likely a lot of cases where this isn’t true but I had some weird issues recently where a series of calls working intermittently. The process was creating a document container and then uploading files into it and then closing the container. I used 3 separate HTTPCallers for this. When testing from FME desktop it worked sometimes and others it didn’t work. I spent a tonne of time trying to debug what was wrong in my POST. Finally it seemed like it was working, I published to Server and directly had issues again. Looking into the Debug logs I noticed that with each new instance of the HTTPCaller there was a new connection to the service BUT that connection was going to a different IP. The host was using a load balancer to handle API requests. Turns out my container was being created on one server and my follow up requests we

How can i extract data from this line?  {"sl:stand": {"sl-bag-extract:bagObject": {"Objecten:Pand": {"Objecten:status": "Pand in gebruik", "Objecten:geometrie": {"gml:Polygon": {"@srsName": "urn:ogc:def:crs:EPSG::28992", "gml:exterior": {"gml:LinearRing": {"gml:posList": {"#text": "114062.419 542728.035 0.0 114067.343 542726.792 0.0 114067.637 542728.082 0.0 114068.445 542728.468 0.0 114069.011 542730.438 0.0 114068.36 542731.246 0.0 114068.639 542732.471 0.0 114063.762 542733.793 0.0 114064.204 542735.512 0.0 114057.619 542737.161 0.0 114055.721 542729.372 0.0 114055.572 542729.428 0.0 114053.081 542719.589 0.0 114059.937 542717.727 0.0 114062.353 542727.763 0.0 114062.419 542728.035 0.0", "@count": "16"}}}, "@srsDimension": "3"}}, "Objecten:voorkomen": {"Historie:Voorkomen": {"Historie:BeschikbaarLV": {"Historie:tijdstipRegistratieLV": "2010-11-26T12:31:16.436", "Historie:tijdstipEindRegistratieLV": "2014-10-27T12:32:20.904"}, "Historie:eindGeldigheid": "2014-09-25",

I am hoping to produce a group of points along polylines of various lengths. I’ve been trying to mimic the GeneratePointsAlongLines() method from arcpy and ArcGIS Pro which will simply build out points from the start of a polyline at a designated interval (regardless of line segment vertices). I’ve investigated Densifier, but this transformer incorporates vertices and produces points that do not conform to the designated interval. I’ve contemplated utilizing Snipper, but this seems challenging given that many of the line segments I expect to incorporate may vary in lengths for different inputs.I’d appreciate any insight that can be offered.

Hi. I'm reading dwg files with the civil 3D reader. I need to use the attributes in the propertysets. this works perfectly with exposing 'autocad_xrecord_datalist' in the reader for all geometry types, but not for the blocks. the property set attributes from the block don't seem to be present on the 'autocad_insert'. I tried exposing fme_attrib_info but they are also not there. any ideas? or is this just not possible on blocks ?i added a screenshot of the pset in the dwg

I have a workbench which is calling data back for 8 reports via 8 different httpcallers. I can add a date parameter to the URL to call back one date at a time. I have 60 dates I need to individually grab the data for.How can I get it too complete the workbench, move on a day and run it again, and again...and so forth, through a list of dates?

Hi,Does anyone know how to retrieve the information from the Settings tab of a layer published to Esri ArcGIS Online (AGOL)? I’m specifically trying to get the Data Source URL. The Request URL I’m using doesn’t return that information. Any ideas? 

*Aka Data Virtualization Transformers, but with the french touchSince I’ve been publishing a bunch of Data Virtualization custom transformers lately, I figured it was time to make a post about them—what they do and how to use them.FME Flow’s recent update introduced a cool new feature: Data Virtualization.https://community.safe.com/product-updates/introducing-fme-data-virtualization-38066?tid=38066&postid=86#post86This feature lets you build your own APIs using FME workspaces.To make that work, your features need to include certain attributes required by the Data Virtualization writer, such as: response.status_code response.body.content response.body.content_type respo

Up until 4/12, my workspace was writing to a SP list normally. It reads data from SQL and updates the SP list to match any changes. After someone changed the name of a SP column on the 12th, the workflow errored - but after the change was reverted, it still errored. The first line with the Python Exception was not in the original error when the column name was changed:Python Exception <TypeError>: unhashable type: 'dict'SHAREPOINT writer: A fatal error has occurred. Check the logfile above for detailsFeatureJoiner_2_JOINED_-1_35_Player (RecorderFactory): SHAREPOINT writer: A fatal error has occurred. Check the logfile above for detailsFirst photo is an overview of the workspace - everything runs fine up until the SharePoint Writer labeled "TOPS Project List". No problems with the SharePoint Reader. Second photo is settings for the Writer (which worked fine last week!). 

Hello,I am trying to write 3D Geometries (Points and Linestrings) to an Oracle-Database (21c Express). In the process all z-Coordinates get lost and SDO_GTYPE is wrongly written as 2001 or 2002 (2-Dimensional Geometries) instead of 3001 and 3002.Multiple Geometries are entering the writer as an aggregate (example below).  Apart from the z-Coordinate missing these are written and interpreted correctly when writing to Oracle. I have checked the “Contains Z Ordinate” Option in the Writer-Parameters.Does anyone have anymore ideas what I could try?

Sometimes when I do a transformation from dwg to shape everything is included in 1 polyline (text, pipes, arrows) and when I look at it in inspektion mode I see that the dwg is splitting the lines by color, how do i do the transformation with a separation by color or adding the color value inside the whole polyline Sorry if my vocabulary is wrong

Hello everyone,This is the FME news for 12th January, 2022. FME2021.2.2 UpdateAlthough 2022 is very close, we still release updates to 2021. In this case version 2021.2.2 was updated yesterday:  Except... a number of keen-eyed users noticed that the installed FME was still flagged as 2021.2.1. So what happened? Well, that's on us. We uploaded build 21805 when we meant to upload 21806. Sorry. We'll upload 21806 shortly. If you did install 21805 then you're one build short. What's missing in the extra build? Well, let's look at what's new in general. So 2021.2.2 is minor fixes (not new functionality) and there were fixes for: SchemaScanner transformerGeoJSON Writer (when writing Mapbox Styler properties)Log4j updates

Has anyone run into an using the OGC WFS Reader for a WFS hosted by QGIS Server where the coords are swapped? Before I go back to the provider with the observation “hey I think there’s a bug in how your service is being delivered” I’d like to check that it’s not a known issue etc. To use the service I had to do the following: Thanks for any ideas!

Hello,This should be a very simple thing, but I just can't figure out how to do it!I want to append two tables together (Tables 1 & 2), both with very similar attributes, but I want to use the ID from Table 1 as the official Primary Key, and then get the highest number from that PK and increment upwards to create new PK values for the Table 2 appended values. I can get the maximum value from Table 1 using StatisticsCalculator, but I can't for the life of me work out how to use that value in the creation of the new Primary Key.I've been trying to do a conditional value calculation in Attribute Manager, something like, if Table 1 ID has a value, then PK = Table 1 ID, else use MaxValue from StatisticsCalculator and sum it with @sum(@double(@Count()),1.0) to increment up. But it's not working.Any ideas greatly appreciated!Thank you!Katrina

Hello,  How do I add a datestamp to a file name in the Excel Writer? I tried adding @Value(_timestamp) to the Writer output and all I get is the file name Bldg_Pts_@Value(_timestamp) as the file name. No date.   

Hi there, I am working on a data clean up model. Many thin areas and remnants have been cleaned up but I can't figure out how to this last thing.There are some thin areas that connect on both sides to a large and very complex polygon. (See image)Does anyone have a suggestion for how to remove these type of areas? So only the thin parts have to be removed.

Hi everyone,I need help, when i upload my shape file in fme which is in gaus kruger coordinate systemI want to change coordinate system into epsg 32634, and when i use coordinate system setter, it changes, but its not exactly how i need it to beSo i need to do something called transformation, and i need help with how to do that, if its posible to do transformation in FME? 

Hi,I was wondering if there are some best practices and or style guides / examples on for workspaces. Some questions that I have about this (besides the obvious: avoid crossing as much as possible, annotation, clear transformer names etc) Like is there an agreed style for public and private parameters (casing, under scores, ...)Is there an advise on how many transformers can be put in the main part and how many in a custom transformer?How many custom transformers can be nested into each other or is it advised to not do this to deep (performance impact)Any other good to implement styles?

I am Featurejoining the output from a change detector that compares an original layer from ArcGIS Online to a revised layer from my Geodatabase.    Note:  The AGOL layer was originally published from ArcGIS Pro from the coordinate system WGS 1984 Web Mercator (auxiliary sphere) .The Featurejoiner transformer rejects the features saying: “Coordinate system does not match first feature's coordinate system”Similar to the issue as seen in https://community.safe.com/topic/show?tid=20659&fid=8When I inspect the original and revised features, my features on AGOL have “SPHERICAL_MERCATOR” and my revised features have “SPHERICAL_MERCATOR_0”In  my workspace, my revised features are reprojected with ESRIReporojector to WGS_1984_Web_Mercator_Auxiliary_Sphere before entering the change detector. They then show a Coord

I'm migrating spatial data from AutoCAD (hosted in an Oracle database) to a SQL Server(ESRI geodatabase). I want to automatically extract domain values from Oracle lookup tables and populate them as domains in the SQL Server (EGDB) without using ESRI tools (like ArcGIS or ArcPy). Is there a way to automate this process, and what would be the recommended approach?

Is it possible to downgrade from Revit 2025 to Revit 2024 using FME Revit Writer?

Hello,I have a question regarding the implementation of dynamic attributes.I created a flow to turn a single attribute into text for the actual values of the column and row of an attribute; Following the pattern below: Original AttributeGoalAfter achieving this, the biggest problem is that these 'dynamic' name attributes come as unexposed attributes.Unexposed AttributesI could simply place an AttributeExposer and resolve this cas

Ok so I have read that the Waze JSON feed is not formed correctly which stops FME from natively reading the GeoJSON with a reader. You have to use a httpcaller with the Accept-Encoding heading parameter. So I got the translation started but I have hit a snag with the line geometry for the JAMS and IRREGULARLITIES feature categories. Here is our waze feed if anyone can get it to work properly with a reader instaed of a http caller.https://www.waze.com/partnerhub-api/waze-feed-access-token/8065da30-c46e-4dee-937a-68b8dac4d2a0?format=1 I have attached a sample json txt file of our feed. The issue im having is I have paired the line features down to {"x":-96.637385,"y":32.846625}{&

I have a JSON file from waze that I am trying to read.I am using the JSON (JavaScript Object Notation) reader.There are three schema; alerts, irregularities and jamsI can read alerts okay with this queryjson["alerts"][*]Flatten Nested JSON values into Attributes = YesRead Entire Feature as JSON Fragment = Nowhich reads 433 alerts, each with a location.x and location.y which allows me to built a point object (Vertex) for each feature.But I am struggling with the irregularities and jams.The irregularities have a line object which obviously does not convert into two neat columns.How do I read the line object?I have attached the json file here