FME Form

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. I built a workspace in 2024.1, that fetches a number of files from a customer Sharepoint site. It works (in 2024.1) without problems. I just installed 2024.2, and ran the workspace (with no changes). Now it issues an error with a SyntaxWarning from the package “safe.microsoft-sharepoint”: C:\Users\xxx\AppData\Roaming\Safe Software\FME\Packages\24783-win64\python\safe.microsoft-sharepoint\stringcase.py:247: SyntaxWarning: invalid escape sequence '\W' return re.sub("\W+", "", string) Is this something that I should worry about ? SharepointOnlineConnector is not listed as an upgradable transformer in 2024.2 Cheers.

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 touch Since 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#post86 This feature lets you build your own APIs using FME workbenches. 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 response.body.content_file_path response.headers{}.name response.headers{}.value Data Virtualization Writer After manually setting these with an AttributeCreator a few times, I thought: why not create a tool to make this easier? So I made the DataVirtualizationResponseSetter ! DataVirtualizationResponseSetter This transf

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 details First 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 Update Although 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 transformer GeoJSON Writer (when writing Mapbox Styler properties) Log4j updates (see this page for the latest info) Cesium format (on a Japanese Windows machine) also a fix for version numbers HTTPCaller (GUI fixes) Garmin (improve reaction to incorrect GPSBabel version) Only the last item was part of 21806, so if you can live without that, you can s

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=8 When 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 system of “SPHERICAL_MERCATOR_0”. FYI The ESRIProjector does display a warning saying “2.1_EsriReprojector: Ignoring input feature coordinate system `_MGA2020-54_FME_0'. This warning w

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 Attribute Goal After achieving this, the biggest problem is that these 'dynamic' name attributes come as unexposed attributes. Unexposed Attributes I could simply place an AttributeExposer and resolve this case, but the problem is that the flow will run in several different scenarios, and the values (A, B, C, F) will never be the same; they can vary to anything (G, H, T, Z, B, A, or K, LL, BN, XS, D). Therefore, I need the exposer to work automatically as well, but I couldn't make it receive @value(list_name); it literally exposes the value '@value(list_name)' as if it were an attribute with the name of the code. Thank you for your assistance! Best regards,

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}{"x":-96.637275,"y":32.846417}{"x":-96.636865,"y":32.846035}{"x":-96.636524,"y":32.845655}{"x":-96.636179,"y":32.845214}{"x":-96.635502,"y":32.843905}{"x":-96.635225,"y":32.843463} I need to convert that to a line either by creating vertices or something. Im sorry this is so disjunct. My brain is pudding.

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 jams I can read alerts okay with this query json["alerts"][*] Flatten Nested JSON values into Attributes = Yes Read Entire Feature as JSON Fragment = No which 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

Hi, We are trying to use a FileCopy Transformer to transfer files from one location to our server (synology) / other computers (other computer). If we do it in Ubuntu GUI / SystemCaller command it works perfectly. But the file copy transformer always give error messages as we don’t have sufficient permission. Even if I put our NAS credential in the transformer (with a featureWriter), it give the error messages. The files are created in the server but there’s no content inside. Does somones already experienced it ? Thank’s Sam

Hello everyone, At our organization we work on a virtual machine. When you log on into a virtual machine, you share the virtual machine with other users. Since a few weeks we encounter sometimes black screens when trying to use FME form 2023 or FME form 2024. I googled and the problem is quite similar to Known Issue: FME Workbench 2023 Opens as a Blank Window on a Virtual Machine – FME Support Center, instead it's a black screen. The article mentions about OpenGL versions, however the specs for all our virtual machines should be the same, so I think the cause is different. When you encounter the black screen, you can only hover over the black screen and can't do much else. When you close FME Form and try to open a new FME Form sesssion, you still get a black screen. The only workaround is to log off and log into a new virtual machine where this problem doesn't occur. We already did some troubleshooting and we know one thing for sure It's possible that fme form 2023/2024 initially worke

Hi, I am using the attribute creator to populate a new field. I want to fill in the blank rows with the previous master property number from the master prop no field. I have enabled the adjacent features but no matter what I try it still only populates just the 1 record after a value and not all the blanks. I thought I would only need 1 based on what I’ve found on the forums. What am I doing wrong here? I also tried to do that same thing via the attribute manager but get the same result. The end result would also have row 3 (FME row id not the xlsx one) with ‘932590’ and row 6 with ‘933123’ and rows 9-11 with ‘933796’ etc with the number of blank rows varying from 1 to potentially hundreds. The settings I have for the transformers are below. I am using FME 2022.2. Thank you! Belinda

Hey all, My FME workbench stopped working and then crashed. Is there a way to recover my unsaved work? Thanks, David

Hi All, I have set up my tool tip to tell me the version number of a particular Transformer in my workbench. Is there a way of relating the version number of a Transformer to the version number of my software? Can I find out which version of the software that a particular Transformer has an upgrade? For any particular software version, is there a list of the version numbers of the Transformers? Thanks, Nick