FME Form

Hello,I have the JSON string format like this “[[{"name":"Column1","value":"Value1"},{"name":"Column2","value":"Value2"},{"name":"Column3","value":"Value3"}], [{"name":"Column1","value":"ValueA"},{"name":"Column2","value":"ValueB"},{"name":"Column3","value":"ValueC"}]]”And I would like to convert it to table like:------------------------------------------------Column1 | Column2 | Column3Value1    | Value2     | Value3ValueA    | ValueB    | ValueC Is there any transformer can help me to do so?

I’m running FME Form 2023 and creating a new script with a reader wich fails when looking up tables. Message given: Failed to retrieve feature typesCould not open the enterprise geodatabase because the local version of arcgis is not compatible with the server's SDE version.On the laptop I have both Arcmap 10.7 and ArcGIS PRO 3.1 (AGP) installed. When creating the reader I use a connection file created in AGP. I also have FME 2018 but this is 2023. The reader is defined as “Esri Geodatabase (ArcSDE Geodb) / Embed Connection Parameters” as the geometry format in the database is ST_GEOMETRY. To me it looks like files from ArcGIS 10.7 is found and used which doesn’t work. Is there any way to force FME 2023 to use “library files” from AGP 3.1 or is there another way to solve the problem?

I am currently working on updating and maintaining a workbench from a previous colleague and am having a little trouble with adapting to a certain aspect of the output schema that we need to follow. The shapefile that we are reading from has multiple very close together lines representing the different vertices of a kerb feature, anywhere from 2-5 lines. Without manually removing the excess lines, is there any way to only keep the lines that would represent the back-of-kerb, or rearmost line.

Hi FME'ers,I wanted to write up a brief guide to connecting transformers (and other objects) on the FME canvas, and rather than making a full blog post out of it as I've done before, I thought I'd experiment by posting it in the forums here.So here's a quick guide to the shortcuts for connecting transformers. I'm hoping that it covers any techniques you might not be aware of. Guide to Connecting TransformersMethod 1: Drag and ReleaseI'm sure you all know this method, but here it is anyway:You drag a connection from one port and drop it at a second port.Method 2: Quick Add with InsertHere we have a connection between a reader and writer feature type. The workspace author wishes to place a transformer between them. Rather than place and then connect the transformer in a number of steps, the author can do it in one by pre-selecting the connection:In other words, whatever is selected when you use Quick Add, that's where the transformer is placed.Method 3: Drag-a

I am joining a data table with polygons, via a FeatureJoiner using a common value between the two datasets, both data sources come from a sql database. I am outputting a spatial table (the polygons, joined with the data) to another database.I am encountering a strange issue when I try to open this data with ArcGIS Pro, I have never come across this before - The ESRI_OID does not exist. I was not aware this was required previously either.This is causing various issues with viewing the data and publishing it, or joining it within ArcPro. I am getting this error on the esri GIS server when I try to view the polygons/or view the table. here is what the output data rows look like:It is a very simple dataset with geometry. I’ve never had to make esri_oids before in any of my workbenches, does anyone have any insight to what might be going wrong?  

I have a snowflake connection that works perfectly on desktop, and most of the time hangs when I push it to FME server. My connection to snowflake is a service account with a username and password. I am using the SQL executer transformer to run a query against a table of shipping data in snowflake. I have also tried the workflow with the Snowflake Non-Spatial Reader, and the feature reader.Running it on desktop is no problem. Just about any query I throw at Snowflake returns data, even up to 700k+ rows. When I publish to server, the job almost always hangs up right at the point where the query is submitted. I say almost because when I shrink the query down to just 1 or 2 records returned, the job will return that data. Based on this information, I am assuming my connection between my FME server and the Snowflake instance is good. Any thoughts as to what could be causing the jobs to hang?  FME desktop version 2022.2.1FME server version 2022.2.1

I’m trying to dynamically add a suffix to all attributes in two Excel files. The suffix will come from the last 10 characters of each Excel file (fme_basename), which is the date the file was produced. I have not been able get this to work using the BulkAttributeRenamer. When choosing the Action “Add String Suffix”, only constants appear to work. I’ve tried using the Text Editor to dynamically create the suffix in the String dialog. I’ve also tried creating the suffix beforehand with an AttribuiteCreator and choosing it for String. Neither work. I’m using FME Form 2023.2.0.0 (Build 23764). Any insight or advice?

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 desired solution?Thanks in advance,Sander

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: I’d rather that they would look something like this:I guess I would have to make the buildings into separate polygons to achieve these results, if it’s even achieveable. Does anyone have any ideas? I’ll attach a copy of my script

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)2. (어떤 사건에 대해 특정한 입장에서 밝힌) 설명[생각/견해]3. <다른 언어로 된 것을 번역하거나 다른 예술 작품 형태로 된 것을 영화·연극·음악 작품 등으로 만든 것> (→the Authorized Version, cover 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 the shapefiles. Any help to get all 33 shapefiles to go through the <Schema> output would be greatly appreciated! Thank you

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_length = len(textur_coord_list)if textur_length > 0:for trian_mesh in first_part:ver_index = trian_mesh.getVertexIndices()textur_index = trian_mesh.getVertexNormalIndices()newFeature = fmeobjects.FMEFeature()pnt1 = vertices_list[ver_index[0]]pnt1_t = textur_coord_list [textur_index [0]]newFeature.setAttribute('X1',pnt1[0])newFeature.setAt

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.