FME Form

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

Hi guys,im using a csv file (with sde feature class names and etc.) as initiator to read various feature classes from a Esri sde database.however i also need to setup a spatial filter on this feature reader to limit the number of record being read. is there a way I can get this setup? I tried add another initiator into same feature reader transformer but seems this is not working.. Thanks guys!

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.

I have a linear network that I have processed with the TopologyBuilder. I have a second linear network that I defines the from-to lines for the ShortestPathFinder. My concern is that the polylines in the two linear networks are segmented differently, for example, the Topology Edges are segmented at intersections and the From-To lines are segmented at mile markers.  Is it necessary that the segmentation of the two networks aligns or just that the From-To vertices correspond to points on the Topology_Edges?

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?

Hello All, Currently I'm converting CityGML 2.0 from IFC4. The IFC file is a building model. So normally the exported CityGML feature types should be under Building module, which are named with "bldg" as the namespace prefix, e.g. bldg:Building, bldg:BuildingInstallation, bldg:WallSurface, etc. However, I found some feature types of the exported CityGML were assigned to Bridge module. Although I can turn on "Add XML Namespace Prefix to Feature Types" (found in the parameters of CityGML Writer), and make the feature types "brid:Door"/"brid:Window" to "bldg:Door"/"bldg:Window".  I'm just wondering why th

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 will create a military grid (10m precision) for an area. I have seen that there are some transformers in fme. I think the "MGRSGRIDGenerator" Trasformer is what I need. As input any 2d polygon feature is allowed. I runs successfully but does not generate any output!  Does anyone have experience with this trasformer?  

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?