General

Hi everyone, Happy new year :) I have created a series of FME scripts that translate DWG file to a feature class in a FGDB.I want to ensure that any time the DWG source file is updated, that the feature class is updated accordingly.Would the "Insert" and "Truncate Existing" option in the Writer be the correct option to choose here? Essentially the user would be updating / adding/ removing polygons from the layer in the source DWG file and I want to ensure that the feature class in the FGDB is also updated.In this case the feature class in the FGDB already has been created and exists currently.  Thanks so much in advance!

Thus, the work of each work area is reported dynamically with each work time. For example, work was done on the plots layer on 1000 plots, 800 were updated and 200 were deleted in Excel form.

The data I am working is real time vehicle AVL GPS data that is dumped into a Feature Class using ArcGIS GeoEvent Server. The Point Feature Class has 104 records.  My objective is to have my workspace act as a "listener" and send me an email every day M-F @ 10a letting me know that GeoEvent Server is reading these records.  Of the 104 records (more records are added each month, so 104 is not static), there are 17 that are not the current date so they are routed to Failed in the Tester. There will always be records in this data that are not the current date.  My question relates to the Tester, the way I have my workspace set up now, is if there are no records in Passed and all 104 records are routed to Failed, I will not get an email. Is there another transformer that needs to be added or maybe a parameter change in one of the existing transformers in my workspace? I want to also get an email if no records are routed to Passed, is t

We used an XMLTemplater (2022.2) to generate an xml message using Excel file input with some optional columns.The XML template contains some if structures like this :            {            if (fme:has-attribute("STATUS")) then <Info> <keyName>STATUS</keyName> <value>{fme:get-attribute("STATUS")}</value> </Info>            else()            }The output xml is correct, but contains empty lines for every missing column, which we want to avoid.Leaving out the else() clause is not allowed as it results in a parsing error.How can we avoid those empty lines in the output xml ?

Is there a way to remove an existing Workspace Parameter from the FME Server Job Submitter? 

This is the original uniquevalue Data with the number of existing features. 1140 Metadata.Worksets203 Metadata.ViewInformation182 Metadata.FamilyInformation105 Metadata.MaterialInformation20 Electrical.CableTrays16 Electrical.CableTrayFittings8 Metadata.PhaseFilters7 Metadata.LevelInformation6 Metadata.StyleInformation5 Metadata.LinkInformation4 Metadata.PhaseGraphicOverrides2 Metadata.ProjectPhases2 SitePoints1 Architectural.Railings1 Metadata.FileInformation in Tester transformer I used (Architectural.Railings / Electrical.CableTrayFittings / Electrical.CableTrays)  The Original coordiante system was : XY-MMI used CoordinateSystemSetter and set CRSM.MTM-10 and then chang it to EPSG:3857For the writer I used I3S with i3s_3d_object Geomet

Hello FME Experts! I have been struggling with this for several weeks and I'm hoping someone may have some insight.  I have a set of data that contains buildings that were manually digitized from roofline data. From this set, I have scaled the polgyons based on the type of roofline (scaling factors predetermined). This resulted in some properties with multiple roofline types to separate from each other. Think of a home with some steep and less steep rooflines - the scaling was done on each polygon. In addition, I used @Takashi Iijima​ 's workbench and modified it slightly to right angle polygons where possible.  Now, I have an issue because I have polygons that should be adjacent (have shared boundaries) but because of the scaling, they are no longer attached (and because these were manually digitized, there were previous gaps in the data).  I would like to physically MOVE the polygons to allow them to have a shared boundary without

Hi, I have compress a text with AttributeCompressor and stored it in an XML file. The text should be a password, so I don't want to store it as plain text. Then, I read the XML file and try to decompress the password with AttrributeDecompressor. But I only get this:2023-12-15 14:31:40|   0.6|  0.0|ERROR |@CompressAttributes: The 'Compressed-table.Compressed.password' attribute could not be decompressedBy the moment, I'm only compressing, not enconding. But I cannot make it work.I'm using FME Desktop 2022. I'm attaching both workbenches, (compress and decompress), the xml written by the first and readed by the second, and the logs of my execution.Thank you for your help.Best regards.

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&quo

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.

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

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 outnu