FME Form

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 

Hello!I have Esri 3d Mulitpatch data as a shapefile, and I tried to see the 3d data on Graphics, but I can see nothing. Also I tried to extrude 3d objects from 2d multipatch, and I insert correct height value, but nothing has changed. Could you tell me how can I solve this issue? I tried to change the coordinate system and I've done several times, but only coordinate system is changed and still cannot see the 3d.

I have a SQL Server table that holds log information. It contains a date field. If I query it in SQL no problem I get: In FME I have a FeatureWriter. I have it set to Update and Use Existing and I've chosen Where Clause as my row selection method. I thought it would be easy to select all rows having todays date, but I'm 3 hours in and having zero luck. I've tried all sorts of iterations like these and many, many more and every time I get "date is incompatible with some data type" or it finishes successfully and I get zero matches. Any suggestion would we GREATLY appreciated. Kim

Hi,  I have a user parameter where we are entering raw text in the format of:\\gis\scripts\FME_Projects\Production\Staging Folder\bulk_geopackage.gpkg  The first time this parameter is used is in a featurewriter transformer:Then when I look at the path it is passing through the output, you will notice one of the slashes has been reversed...Any thoughts as to why this is happening at this point?

Wonder if there is a way to read  Microsoft Planner (Microsoft Task) with FME ? Yarko

Hi all, I've created a series of FME scripts that translate geometries in a source DWG file into ESRI consumable SHPs. However, now that I want to change the Writer source to write to the FGDB I created, the scripts won't run properly and say this.Is it a matter of adjusting the attributes viewable in the end FC in the FGDB? I was able to set it to manual/automatic with the SHP writer, and everything translated through with no errors. In my initial transformation from DWG to SHP, the SHP writer geometry enabled the shapefile_first_feature option and dimension from first feature.In the FGDB writer opti

This is a silly question, but I can't seem to use the File Copy writer to copy a DWG file to another folder properly. The transformation seems to run with no issues, but when I check the output folder I specified, the DWG file is not there.In the Reader, I chose to merge it as a single merged type, as the DWG has about 30+ individual layers in it. Is there a method to ensure I just copy over the whole DWG file into another folder? I don't want to move the original file, simply make a copy of it to another folder.Thanks everyone

I am new in FME and I have a project to convert 3D models in .rvt format to be poblished in scene 3D views in ArcGIS enterprise. I was trying to find articles or similar projects that was done before but I couldn't. Can someone help me please tnx!

When I run my spatial filter with the entire dataset the filter fails but if I run using partial data the dataset it works. Does anyone know why this would happen?Note: Spatial Realtor works but not the spatial filter.

I am slowly loosing track of all my inpector windows. How can I stop fme creating a new instance every time a tool is run?

I have several Revit files for design review of a construction project and I want to make them available to our organization through ArcGIS Enterprise using a 3d web scene showing the Revit data as a "building layer." I've set up the Revit readers but that is as far as I have gotten in FME. I tried creating Esri file geodatabase writers from the readers but resulting the feature class schema is different than what the results from the BIM File to Geodatabase geoprocessing tool in ArcGIS Pro produces. For context, in ArcGIS Pro my steps would be:BIM File to Geodatabase (geoprocessing tool)Make Building Layer (geoprocessing tool)Share as Web Scene

Is there a way to check the status of a FME job through a powershell script?

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: