FME Form

The Swedish DOT offers extensive road data as Open Data. It is packaged in an ESRI Personal Database (mdb) with 120+ tables. I want to dynamically load all of the data into Postgis for local storage.However, quite many fields, scattered in the database structure, are of the type CHAR with a width of 2147483647 (sic!). Of course, no post contains that many characters, and FME tries to convert these fields to VARCHAR with the same width. This breaks the translation with the message that the type VARCHAR cannot exceed 10485760 characters.So in short, I need a way to filter and catch all tables with fields of the type CHAR, with a width of 2147483647 and alter the width to either the actual content of the field, or a static value that does not truncate what's in there.Regards, Mats.E

Hi, I have a JSON return form a HTTPCaller with schema info. An example of the return looks like this:{  "name": "Administration",  "properties" : {    "Id" : {      "type" : "number",      "required" : true,      "description" : "The given Id for the object"    },    "GeoType" : {      "type" : "string",      "required" : true,      "description" : "The type of object"    },The json continues here with more schema info.I want to turn the information into a table like this:  I have 82 other JSON returns with the same layout but other “name” values and exposing them all takes to much time. I have tried to use JSON transfromers but so far no succes.Is there a more dynamic solution to transforming the return to my de

Hi, I’m working on a script that takes building footprints and outputs different lines inside them (crosses, diagonals, centerlines) depending on the type of building. I have achieved good results for square buildings and buildings that only require a centerline. See picture below.But when it comes to buildings with more complicated shapes it doesn’t work as well. Some buildings turn out acceptable, like these ones below:But some shapes turn out pretty bad, like the ones below:

We have a polygon dataset with roads and we need to find the roads than are less than 13 meters turning radius. We kan also create centerline dataset with the polygon. We imagine that someone out there has done this before. We need this datasett to find which roads the fire trucks will have problems to drive. 

We are trying to set up a nightly read of two separate folders in a OneDrive location to get a list of the files in the directories.  There are several thousand files in each directory.  Sometimes the routine will run and report less than 500 records and then when you immediately run it again it will read all of the 5,000+ records.Is there something I am not aware of on the OneDriveConnector that would be causing it to give such wildly differing results.  I am so accustomed to consistent, bulletproof results when running FME routines that unpredictable, inconsistent results is quite disconcerting.We are needing to write an inventory of files to SQL Server to use for linking in a GIS system.

I know that citygml has versions from 1.0 to 3.0.However, it seems that changing ifc to fme is only possible with citygml 2.0.Maybe I don't know how? Or is fme only converted to 2.0 by converting ifc to citygml?version미국식[│vɜːrʒn]영국식[│vɜːʃn; │vɜːʒn]1. (이전의 것·비슷한 종류의 다른 것들과 약간 다른) -판[형태] (→beta version)

The .ecw file created through FME, QGIS cannot identify its CRS correctly. I tried with both ecw v2 and v3. This can be fixed through ECW header edit. It might be a bug when trying to write GDA2020 datum to ecw file.

Hello community,I've updated an ArcGIS Online Feature Service using FME, but unfortunately, I seem to have lost my data. The table still exists, but the data is missing. The feature service I want to restore was already added as both a feature service reader and writer. Does anybody have an idea how I can restore my data? The 'Enable Feature Cache' option was already checked.FYI: we only have Arcgis online, we dont have Arcgis Entreprise and portal 

HiIn production environment i have FME Server  that has a SAML Configuration and it works fineI created an APP in FME.This app need to be under authentication and i set the users in the configuration. The problem is that this APP is included in sharepoint page using IFRAME. The users are authenticated in Sharepoint but when they  access to the page that contains the FME App, the app shows the login page. If the users click on SAML Auth button, the IFRAME try to show the provider's sign-in page that is not setted to be included in IFRAME and so it doesnt’ work.So to solve this problem, i tried to create a token and tried to call the app in IFRAME passing the token in the query string. But it doesn’t work.So the question is: there is a way to display an APP using token instead of user credential?

What would be the best way (aside from opening the file in a GIS software) to find out if the vertices in a shapefile has a Z and/or an M?

Hi -I’m attempting to identify the schema of 33 shapefiles. The goal is to transform all the shapefiles from one schema to a standardized schema in a single workflow. My thought is to first identify all the attributes of the raw data then create a look-up table. To do this, I started by running a query on my source folder using the PATH reader to identify all the shapefiles in the folder. Next, I was going to use the FeatureReader transformer with the Format set to ESRI Shapefile using the file path attribute (path_windows) from the PATH reader as the dataset to read. I was then going to use the ListExploder to expose the attributes from the <Schema> output port. However, the schema output port is skipping 4 of the shapefiles. The schema output port = 29 ; initiator output port = 33. I’m not sure why it’s doing this. The file path is different for all

Hi, when opening fbx in FME, I see a property with a description of the material in the geometry parts (pay attention to the line highlighted with a marker) FME has a python interpreter, with its own classes and functions.I have already pulled out the coordinates of the points, in the code belowimport fmeimport fmeobjectsFeatureProcessor class (object):def __init__(self):passesentering def (self, feature):all_geom = function.getGeometry()first_part = all_geom.getPartAt(0)if type(first_part) == fmeobjects.FMEMesh:meshs = first_part.getAsMultiSurface()vertices_list = first_part.getVertices()textur_coord_list = first_part.getTextureCoordinates()textur_l

It is possible to the saved zipped file from the ShapeFile feature wrtiter NOT split (generate) multiple zip files. The workbence/job is running on FmeCloud.  

We use the SDK in C++. When migrating our code to FME 2024, I realized that several files related to pointcloud cannot be found in the new SDK any more.The only file I can find for pointclouds is pointcloud_fwd.h. But when using an IFMEPointCloud pointer, the declaration cannot be found. The files that I used in earlier versions of FME do not exist any more (ipointcloud.h, ipointcloudblock.h, ...)Where can I find these declarations now? Is there an example for C++, how the point data of a pointcloud feature can be extracted with the SDK of FME 2024? 

I have got an excel sheet and there are some cells with just colour and i don’t wish to include them for analysis purpose / output . Without any edits in Excel sheet (eg. add some kind of numeric or standard text for colour cell etc.) i wish to remove or exclude. I also don’t wish to depend on any other column or cell value to filter rows with ORANGE colour cell  I WANT to remove / exclude entire ROW that has yellow colour in cell in Column NCR Ref   

Hi,I was wondering if you could please help me convert data in NAD83 with vertical from HT2_0 to CGVD 1928 adjustment.I am using the CSMapReprojector transformer in FME Form 2023.2.1.0 (20240104 - Build 23774 - WIN64) but apparently FME is looking for a geoid height grid (*.gdc) file.Please advise. Greatly appreciated.Thank you! WillyWilfredo de Vera

Hi, I am writing spatial plans in PostGIS just fine, but when I read them back through PostGIS Reader, the appearance seems to disappear, and its this generic gray color. Can someone help me preserve the geometry appearance as well?Writing geometry: Reading geometry:  

I have a text field (attribute) in a table that is 2048 characters in length. I want to change it to 50. What Transformer do I use in FME to achieve this? I am using FME Form 2021. 

I have spatial (ESRI FGDB data) that I want to make into a non-spatial table.  Regardless of what I try (e.g. deleting the ‘Shape’ field) the data is still spatial. 

Hi! I am transforming data from different sources. The data travels at different speeds through their own workflows and end up at my Excel Writer at different points in time. This in itself is not the problem. It’s because I have specified a Fanout function in the name of the file all the data/features are being written to that the problem appears. The Fanout contains hours and minutes, the name of the file begins with:“@Timestamp(^Y).@Timestamp(^m).@Timestamp(^d)_kl.@Timestamp(^H).@Timestamp(^M)...“ Since the data gets to the Writer roughly a minute a part I end up with two written files with only part of the results in them. The two files get different names with only a digit’s difference. For example:File 1: “2024.05.30_kl.12:55...”File 2: “2024.05.30_kl.12:56...” I can obviously solve the problem by removing the hour and minutes from the Fanout in the file’s name. But I would really prefer to keep it. 

I have one shapefilter consisting of agricultural land and some gps points in csv. how can I filter these gps points which fall in the agricultural land? I have already tried Spatial Filter but it doesn´t work all the time it fails. Would be really nice if anyone could help me with this problem. :)

Hi,Is there any way to prevent FME Desktop from converting dates to its internal format? For example, if you get '2024-05-30' I want it to remain '2024-05-30' and not '20240530'.I understand that it can be useful in some cases but there are others that this automatic conversion becomes a headache. Thank you!Regards.

Hi, I hope someone can help me with the following.I have a workspace app, lets call it "app1", which uses the file/URL parameter and the "User can Upload" setting in the Edit workspace apps enviroment to upload data. When I test the workspace, it correctly shows that the file is processed and ready for use. I have also have another workspace, let's call it "app2", which uses the exact same setting as app1 for the file/URL parameter and the workspace app. However, when testing the workspace app, it does not register the file upload Pressing upload file does not process or show a filename or percentages of completion. Browse resources and "drag and drop"

I have a close polyline in dwg and some lines inside this polyline. the polyline contains arcs too. with these 2 I create small areas in fme.now the problem:when i create these areas the boundary where the arc part of exterior polyline is different fromthe boundary of smaller areas.is this a bug in fme? cause it doesn’t make sense to create parts of the same arc that are not colinear with the arc that the part was extracted.or is there a setting that i have to set? ive notice that the arcs has different description in inspector windowfor the new created areas it says “IFMEArc: Arc By Center Point With Ends”and the other shape it says IFMEArc: Arc By Bulge. example:Pink area was generated and overlaps the exterior boundary (blue line) area. that should not h

Hi, everyone.I have two datasets. I need to find polygons that do not overlap, even if they have different shapes. I'm using a spatial filter, and I've tried others too, without success. When analyzing the failed ports, some polygons appear as 'NO INTERSECT', but in ArcGIS, it's possible to see that the polygons are overlapping others. I've tested this and I think the intersection analysis in ArcGIS is better than the spatial transformers in FME. How can I perform this validation correctly in FME?  I'm worried that my results are not reliable when using FME for detecting overlaps. Could it be that my configuration in the transformers is incorrect? Which transformer or configuration is equivalent to the intersects operation in ArcGIS?