General

Hi all, I need to extract the Hex Code Point of multiple letters using TextEncoder.However, the transformer fails to encode Roman numbers and some special characters. You can see in the below screenshot that it successfully encodes Bengali letters and some special characters, but not the others. Anyone has an idea how to solve it or any workarounds? Thanks! 

I'm trying to write ~20m records to a Geopackage format file. If I remove all but a unique identifier column the output is created and FME runs correctly. If I try adding the original columns the process fails with the following errors. What can I do to fix this? 2024-01-04 10:57:31|  1.8| 0.0|ERROR |OGCGEOPACKAGE writer: sqlite3_exec(CREATE TABLE "Table1" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "geom" POLYGON, "Toid" TEXT(20), "Version" MEDIUMINT, "VerDate" DATETIME, "FeatCode" MEDIUMINT, "Theme" TEXT(80), "CalcArea" REAL, "Change" TEXT(80), "DescGroup" TEXT(150), "DescTerm" TEXT(150), "Make" TEXT(20), "PhysLevel" MEDIUMINT, "PhysPres" TEXT(20), "Broken" SMALLINT, "LoadDate" DATETIME, "OBJECTID" MEDIUMINT, "OSMMSTYLE_NAME" TEXT(70), "Style_Code" SMALLINT, "SHAPE_Length

I am trying to generate a point coordinate at the midpoint of Arcs. These Arcs have a very large radius and a tiny sweep, so they look like lines, but they are parts of a larger Arc. Whether I try the arc.GetMidPoint() method, or use Intersector with a crossing line, the point is always off. When I run the features through the SpatialRelator, it returns 0 _related_suppliers. It looks fine at first glance, but zooming in reveals that the intersection point really is NOT intersecting. My hunch is that this is due to the Point being calculated as a float. When using the Intersector or PointOnLineOverlayer, it actually changes the shape of the Arc! Here are some pics to illustrate:Midpoint of Arc at a distance Intersection point at a distance."Intersected" Point from Intersector lines (purple), with actual Arc (grey) close up. It intersects with the Intersector-created Arc, but not with the input Arc:Here is what I am running the features through to verify. Note: If I

Hi, I have Civil 3D AutoCAD model with XRef attached. I cannot find the way to read the XRef layes as autocad_entity=autocad_xref. The only place that tells me that is an xfer is stored in the autcad_layer as apart from the layer name has the name of other model. What am I doing wrong?

Hi all,Please help!  From January to April 2023 I worked through most of the FME Desktop/Form Advanced and Server/Flow advanced course. Now, December 2023, it seems my account and the progress is lost. All the badges I gained etc. In addition, some of the trailmixes I followed seem to not exist anymore. Anyone had a similar experience? Or know how this could be solved. Kind regards,Peter Goedbloed

Is there any easy way to add a date stamp to output file names when using the FeatureWriter? I am outputting Excel files that have multiple tabs with multiple separate inputs, from multiple data sources. The only way I could figure out how to do this without the FeatureWriter splitting up the different feature types into separate files is to add the DateTimeStamper to each data source, make sure it is kept all through the Workspace, and then take off the _timestamp attribute from each Feature Type in the Attribute list on the FeatureWriter. What a pain! Surely there is a better way? I tried to create a User Parameter, but it did not work. Any hints on this?  Thanks, -L

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 username and password of the API itself? Thank you so much in advance.  

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.

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?  

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

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

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?

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.

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 outnumber spatial in the long run. That said everything i

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

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!

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?