FME Form

Hi!I am trying to get data (exchange rates) via a Rest API. I am a very beginner in using Rest API:s.By now, I start with a creator and connect than the HTTP Caller. However, I have difficulties to set up the HTTP Caller and get a connection.I use the following url: https://api.riksbank.se/swea/v1/Observations/SEKEURPMI/2022-01-01/2022-12-31 HTTP/1.1 The API needs a so called Ocp-Apim-Subscription-Key. It contains of 32 numbers and letters.I guess this should be defined in the header, but how would I do this in FME? There is no such parameter available, is it?To access the API portal username and password are required. Do I have to use this username and password in the "Use Authentication" section or does it refere to the

Hello! I am having trouble getting the ProjectWiseWGSConnector working on FME Form 2023.0.2. I have a dedicated service account (SVC) account that can access two projects using ProjectWise Explorer. I am connecting with a username and password, not with Bentley IMS. When I use the same login and password in FME Form, I cannot access those projects. FME lists a series of folders that I have not seen before. I have attached a screen grab of the list of folders, ProjectWise API version, and ProjectWise connection configuration.

When I try to import Revit file to File geodatabase i face with the following error. An error occurred while attempting to create the feature class 'Structural_StructuralFraming'. The error number from ArcObjects is: '-2147220649'. The error message from ArcObjects is: {Cannot create a table with a duplicate column. [Structural_StructuralFraming]} my version of FME is 2023.1I did previously import Revit files in geodatabase without any error in previous version of FME.

I have a shape file containing for each 100m a line segment representing a 100m segment of a railway line. I would like to create for each line segment a buffer polygon that has no overlap with neighbouring buffers in railway lines to corner.  Creating an indivdual buffer for each 100m line segment results into the following buffers:As you can see the buffers are having gaps wen the line is cornering. In order to avoid the gaps I created a single line using the LineCombiner and then using the Bufferer to create a single polygon. Next step would be to 'cut' this single polygon into polygons with a length equal to the original 100m line segment.  Following the result of the LineCombiner and the Bufferer:

When I was trying to add the line to the existing line using PythonCaller FMELine.appendLine(feature.getGeometry) then it is closing the paths as polygon. Basically it is adding an extra segment and closing the path.In the below image selected line, there is a straight line created when I use the above function.  What's this worst calculation? Who is the coder for this?  

Has anyone figured out how to read Overture maps data using FME yet? Looks like it should accept a spatial query but maybe it requires a custom reader. I tried using the AmazonAthena connector but didn't get anywhere... Overture documentation can be found here:https://github.com/OvertureMaps/data/blob/main/README.md#how-to-access-overture-maps-data Thanks in advance!Nic

I am trying to get FME to compare all fields (no key) and only insert uniquid rows.On initial insert all works great but when I go into excel and change a few field values of a rows or two, FME does not update. Instead it inserts them as new rows.How can I overcome this? ThanksB

Hi there!I have several different FME scripts I have developed to translate layers in a source DWG to feature class in a FGDB.I need the ordering to fire as the below in the bookmarks, with one line creating a merged shp, then the other line taking that merged shp and importing it into a FGDB. Is there a way to set the order of lines or bookmarks to fire before the other?  Thank you!

I have what I hope is a simple question. I'm using a Where clause in my Esri Geodatabase (SDE) Writer. One of the criteria I'm using in my Where clause is that a jurisdiction matches a value being passed in using a User Parameter. This value "jurisdiction" parameter has a comma in it (which I think is the problem). When I manually type the Where Clause in as Jurisdiction = 'SomeName County,St' it works no problem. When I pass the parameter (I.E. "Jurisdiction = '$(parJurisdiction)') with parJurisdiction set to the exact same value I get:  "Unclosed quotation mark after the character string 'SomeName County))' Any suggestions as to how to solve this problem would be appreciated.  Thank you.K

Hello,Did anybody resolve a problem of writing character ???ŠŽ ( part of Latin2 / cp1250 codepage ) to Geospatial PDF Writer ?Regards Mišo

Hi, does anyone know a workflow for detecting green areas based on aerial images? We have true orthophotos (with NIR-channel) as input. Perhaps there are already instructions or someone has had experience? hope someone can help me! Thanks in advance! 

I have a raster and want to set values which are < 5 to NoData and also values which are equal to 255. I have tried setting values of 255 to NoData using the RasterBandNodataSetter, but in the output raster all three bands still have values of 255. I've attached the workspace. Ideally I'd like to set these values all at once but I'm just trying to get one value set correctly first. Thanks

Hello!I have shp footprint of buildings and DEM information with TIFF format. I would like to extract Band0 value as a height information, and then apply it into footprint, so then I can create a 3D buildings. Could you tell me the flow that I have to use? maybe I also have to change the coordinate system right

Hi,hopefully someone had the same problem before and could help me.I'm trying to export annotations and features from ArcGIS sde connection to Microstation dgn. However, the justification of the text are slightly shifted to the right, compared to the original text (see picture below). I've tried many things with DGNStyler and also the attribute igds_justification. None of these helped. It seemed like the calculated origin point is always slightly right. Last but not least, I also extracted x and y of the extent of original annotations and set that to the exported features. But it seemed FME still calculated an insertion point (see https://community.safe.com/s/article/text-justification) when exporting to DGN, so that there is a shift.After tha

I can see from the translation log after running with the GUI that there is a plugin imported that allows the readers to operate. How can I incorporate this plugin while running with command line interface?Here is the output from command line:fme "C:\FME\my.fmw" --BlockNameLookup "C:\FME\BlockNameLookup.csv" --DWG_InputFile "C:\FME\my.dwg" --DWG_MetaData_File "C:\FME\my.dwg" --DB_Input_CSV "C:\FME\my.csv" --PostGIS_DB_Connection "DEFAULT_NO_CONNECTION" --FEATURE_TYPES "" --FME_LAUNCH_VIEWER_APP "YES"                FME 2023.1.1.1 (20231011 - Build 23636 - WIN64)                        FME Form Fixed (node locked-crc)                               Permanent License.                        Machine host name is: mymachine     Operating System: Microsoft Windows Server 2022 64-bit  (Build 20348)                 Copyright (c) 1994 - 2023, Safe Software Inc.                               Safe Software Inc. Transla

For example:  I have an external table that has regions for column headings (North, South, East, West) and part numbers for row headings (Part#001, Part#002, Part#003, Part #004,...). A part number in a specific region has a cost as shown in the in the image.  Also, I have another table with the attributes Region and Part Number in FME.  I want to make a new attribute that searches the external table based on the two attributes in my FME table: region and part number and returns the cost. How can I do this?    

Quarter 1 is April, May and June; Q2 = July, Aug, Sept; Q3 = Oct, Nov, Dec; and Q4 as Jan, Feb, March.If I need to run a workbench at regular intervals throughout the year, which transformers will I need to identify features from the current month, and current quarter?I have converted the dates to FME format, and I guess I need to add a DateTimeStamper to get the current date. Then what do I need to do?Many thanks in advance for any pointers you can give me.RegardsStu

I have a PDF Writer which generates PDFs with 4 layers:Frame, Basemap, OldLine, NewLine.NewLine is an interactive layer (hover over it to see attribute details). I would like to also do the same with OldLine - which has a gap that NewLine fills nicely. However when I make them both interactive then, in the resulting PDF, I either get to see just the first part of oldLine or the whole of Newline... Both lines are visible in the sidebar bookmark and the mouse pointer changes when I hover over the invisible linework. I have tried various layer orders (guidance says interactive are always at the top anyway) and many other settings, but can't get a decent output with both layers fully visible and interactive. Is there a hard restriction to one interactive layer? Cheers

I am trying to perform cascading deletion in the database but because the records are many and the deletion is happening in many tables, this takes a long and the database gets disconnected after a while. How to solve this?

I am working on a project to get my home city into Minecraft (Harrisburg, PA - pop. 50,000). I have a QGIS file of about 40 layers consisting of:2D shapefiles (polylines & polygons - to describe materials or edges)2D shapefile of buildings (heights based on a BLDGHEIGHT value in the attribute table)3D DEM (using this for the Ground Level of the Minecraft World) I have seen what could be done in converting GIS to Minecraft from some of the how-to links. I have two concerns, what data cleanup should I be concerned with and would there be anyone out there who might be able to help guide me through the process this next month? This project started in 2013 as an idea to take a 2D image and "loft" a Minecraft world from the pixels (World Painter). This worked well and created a flat creative world. Unfortunately the area was only one neighborhood in the city, approximately an 1/8 of the city. The image allo

After upgrading to FME Flow and Form 2023.2 (Build 23764), I'm receiving errors publishing workspaces to FME Flow. Even when testing with the superuser credentials, I receive an error message. Has anyone else experienced this issue or have a workaround? Steps Taken to ResolveReinstall FME FormReinstall FME FlowRecreate FME Flow ConnectionsError Message2023-12-15 11:27:10|      |     |INFORM|Starting connection to '<redacted> FME Flow'2023-12-15 11:27:10|      |     |INFORM|Connecting to 'https://<redacted>' (web connection, authenticated login)...2023-12-15 11:27:10|      |     |INFORM|Successfully connected to FME Flow 2023.2 (build 23764).2023-12-15 11:27:12|      |     |INFORM|Connecting to '

FME Flow does not send emails through emailer-transformer in the workspace. It works on mine production-server, but not in system test. I get error message Emailer: <class 'locale.Error'>: unsupported locale setting. The difference is between TEST and PROD: TEST: Process Encoding : UTF-8PROD: Process Encoding: windows-1252 I have tried deleting safe.emailer, under recources and plugins. Deleted the Build-folder. Tried different Python interpreter. But still no response. Is it Python installed on server that is causing trouble? Are there settings I can make either in the Flow GUI or on the server?  Emailer running from desktop works.

I'm sure this will be something really simple I am overlooking (as usual!)I have some excel data of personal information, including age.I need to:1.       group ages, 0-17, 18-25, 26-35, 36-45 and so on.2.       count how many each category / group has.3.       Display data in ExcelFor point 1, I have used the Attribute Range FilterThis gives these resultsSo far so good! For point 2, I use the statistics calculator to do the total count of each group:Then into Attribute manager to rename the column

Since FME lives (thrives!) in the lands-between-realms I'm thinking this is the best place to ask this question and hook knowledgeable reponses. There are more eyeballs in the Esri and Stack Exchange community forums but they're less likely to have the broad horizon to horizon perspective combined with life in the tunnels found here. What are the trade-offs to consider when deciding between native DB spatial type or Esri Enterprise Geodatabase (or both)? Where 'native' means PostGIS for Postgres, SQL Server Spatial, OGC in Mysql, etc., etc. Assume equal proficiency of staff and resources is or will be made available. Licensing et al is consequential but not determining. Content is a mix of spatial and non-spatial. It's hard to say which is more. By volume in terms of storage it's spatial - a lot of wildlife telemetry, survey and observational data. However by number of tables the non-spatial will probably outnu

Hi I'd like to convert footprint and 3D buildings from Esri Arcpro to CityGML.However, I couldn't import the shapefile in 3D.Do you have any idea about this?Thank you for your help. I'm new to FME so I'm struggling lol