FME Form

I'm trying to read a .json file into a single feature attribute. So far all my attempts to read the json has led to it being flattened, with all json 'keys' showing up as an attribute. The reason I want to have it in one attribute is that the jsons in question are service definition for ArcGIS Online content. Essentially it gets converted into a python dictionary using json.loads(feature.getAttribute(...)).  One workaround I've thought of is just changing the extension of the json to .txt and reading that instead. However, I would prefer to do it a neater way, if there is one. Any suggestions?

I received a geopackage named "test.GPKG". When I set up a reader I select OGC GeoPackage as format and browse for the dataset. I select "test.GPKG" and click "Parameters" to select the tables. But then I get a error message that no such file exists. FME does not recognise the extension when written in capital. In the message FME is looking for "test.GPKG.gpkg". Solution: rename dataset to extention with lowercase letters. Like "test.gpkg". Then the tables are shown. Question: Is this behavior wanted? Or should FME also recognise the extension written in uppercase letters? Freek

My last pair of FME socks from the 2017 UC are on their last legs. Probably the last day I'll be able to wear them. I'll have to put them in a safe place until I can put them on for the UC in August. Anyone else need some sweet new Safe swag? 

This is what I'm trying to remove is this block:    <Remarks>  "<span><span>xxxxxxxxx </span><span class="xxxxxxxxxx">xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx</span><span>xxxxxx </span><span class="xxxxxxxx">xxxxxxxxxxxxxxxx</span></span>" : 2022-01-24T08:23:34     "<span><span>xxxxxxxxxxxxxxxxxxxxx (<span class="xxxxxxxx">xxxxxxxxxxxxxxxxxxxxxxxx</span>)</span><span>Suffix: T (<span class="xxxxxxxx">xxxxxxxxxxxx</span>)</span><span>xxxxxxxxxxxxxxxxx</span><br /><span>---- </span><span class="xxxxxxxxxxx">xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx</span><span>---- </span><span class="xxxxxxxxxx">xxxxxxxxxxxxxxxxxxxxxx</span><br /></span>" : 2022-01-24T08:23:39     "<span><s

Hello, I am missing something basic here I think. I am trying to use a road centerline and boundary (polygon) information to assign the boundary data to the road centerline with LEFT/RIGHT indicated which is associated to the digitized direction of the line. I have tried the LeftRightSpatialCalculator but that seems to only give me the polygons as an output as opposed to the centerline being tagged with the LEFT and RIGHT polygon that falls on either side of the line. I tried working with the list but I couldn't get it joined back to the line. For point of reference. ArcGIS has an advanced tool titled 'Identity' that, when used with lines and polygons, can add the data or just the Id of the polygon on to the line segment based on whether the polygon is to the LEFT or the RIGHT of the digitized direction of line. Could I possibly use a tool related to the topology to derive this information? I tried looking for the result but only found those items related to LeftRightSpatia

I have a workspace that reads a geodatabase polygons and writes areas to a dwg file. In between I use a DWGStyler to add a hatch fill pattern to an area. But when I want to add a hatch fill pattern, I see only the standard hatch options. Where are my custom hatch fill patterns from my template fill? I have received also the .pat files of the custom hatch patterns. But how do I use those in my workspace? I installed autocad to meet the environment specifications. I placed my custom .pat files in every possible folder that can be used by autocad and fme. But no extra hatch patterns in my fill pattern name window of FME. But in Autocad they will pop-up next to the standard hatches.Is there a specific folder where I have to place my .pat files.?Can FME read custom hatches from a template dwg? Who can help me? Freek FME(R) 2020.0.1.0 (20200407 - Build 20218 - WIN64)I'm writing to dwg not REALdwg. If that is a part of the solution I will try.

Which FME requires to connect with SAP HANA ?i have FME Desktop , is there a method to connect with SAP Hanai wish that someone shares his experience to integrate FME with SAP HANA and also which ideas and problems that he faced .Thanks in advance .FME Desktop 2020

hi,using FME 2020.1.0.1, I find that occasionally the RasterDEMGenerator crashes when trying to rasterize a TIN. I have isolated some of the triangles (see workbench and data in zip file).  The crash occurs when using the BreakLines input. Using the "Points/Lines" input is not an option, since the resulting raster has artefacts.  Another FME user suggested the PointCloudCombiner as a workaround. This is a very slow option, unfortunately. I hope Safe can assist in fixing or working around the crash in the RasterDemGenerator (using breaklines input). Kind regards, Richard.

Hi, I have 1 DGN file. This file has regional limits. I want to see the drawings within the boundaries of this region in Excel, but not all of them, I am giving an example. Additional base number in Region_1 55 Additional base number in Region_2 25 I want to see the figure separately in Excel, how can I do this?

I am having trouble connecting to the API at https://developer.vasttrafik.se/portal/. I would like to get the public transport stops (https://developer.vasttrafik.se/portal/#/api/Geography/v1/admin), but I am stuck, I keep getting "HTTP/1.1 403 Forbidden" from the HTTPCaller. I have tried using "Authorization" as suggested at https://community.safe.com/s/question/0D54Q00008WImfCSAT/using-fme-to-call-power-bi-via-the-api-to-refresh-data-sets-dynamically-i-am-stuck-with-the-authentication-piece-for-the-bearer-token, but no success. Any suggestions on what I might be missing?

Hello everyone,  I am in the midst of converting a IFC building model to CityGML format with a modified version of the workbench from: https://community.safe.com/s/article/bim-to-gis-intermediate-ifc-lod-300-to-lod-4-cityg At present, I am unable to create an opening for the doors in the interior wall surface in FME. Both are aggregate multi-surfaces but the interior walls are simpler with only 1 surface. I have tried various transformers and they do not work, partially due to how complicated the door's geometries are and the number of coplanar doors and walls.  Let me know if there are any more information you may need. Thank you for the help in advance!

Hello Brains trust , hoping someone out there can help me. My workspace is as follows.2 arcsde feature readers. sde1 contains records and attributes that are pulled from a number of sources to create areas of interest.sde2 contains one of the source datasets that are used to update sde1. sde2 is also a source of truth dataset so the geometries are the most current.nb - the sde's have been maintained using ESRI not FME - trying to automate the process. My work flow checks the geometries of sde2 against sde1 and were they don't match I use sde2 geometries to UPDATE the sde1 records (i use the fme_db_operation attribute to identify that it is an UPDATE and i keep the attributes from sde1). Simple enough. However, some work and some don't when writing (have been using a process of elimination to narrow down the records that write and don't but nothing in particular is jumping out). The error FME is giving for the records when it fails to write is I have written the compl

FME Desktop 2020: How to get the number of features located in front of the tools arrows, Currently, the number of features is located at the middle of the line that’s connected between two tools. As per the screenshot below, in particular arrangement for the tools, it gets hidden if the fields are expanded, for example. Is there a way to get these number located in front of the tools arrow?         

FME 2020: How to pass the Blocks number to their Parcels? In the screenshot below, there are two layers: parcels and blocks. I wanted to pass the blocks number to all parcels contained in it to end up with a new layer that has two fields: parcel number and block number What might be the best practice to perform this? The data is attached 

FME Desktop 2020: FME appears to mistranslate the content of AutoCAD dwg file, In the screenshot below, I couldn’t figure out how the FME creates the marked square while it’s not physically existing in the AutoCAD drawing file. What could be the issue here? The CAD file is attached            

I am currently just working on some of the modules as I am trying to learn FME, but when I manually set the final line for some of my expressions as just ")" it automatically sets an "=" for my Operator and then changes my logic to ") AND". For some of my conditions I've been able to simply put the final parenthesis and be okay, however, the attached image is where I am running into issues. Line 7 just keeps switching itself to ") AND".  How can I use the ")" logic without it auto resetting to ") AND"?  

I am reading a table in from a Microsoft SQL database with a MSSQL_ADO Reader. The table has longitude and latitude attributes, read in as float data type. I would like to write this table into a geojson format, where the geometry of each feature is defined by the longitude and latitude coordinates. I have tried using a VertexCreator Transformer, but when I then write the table to a geojson, the geometry feature is null in the whole file. What do I need to do so the geojson writer writes non-null geometries?

I have two scenarios; In Column A, I need everything before a set of string, and in Column B, I need everything after a set of string, by using StringReplacer. Below is an example of what I am trying to do: COUNTY OF PRINCESTONREGION COUNTIES OF LAMBERSON Column A: COUNTYREGION COUNTIES Column B:PRINCESTONLAMBERSON in the StringReplacer, I have the expression ^.*\\ OF for everything before \\ OF ,*$ for everything after Based on a previous forum https://community.safe.com/s/question/0D54Q000080hTpzSAE/how-can-i-remove-everything-after-in-fme-using-string-replacer  The result of this is that there are no changes to the strings, as everything before and after the ' OF ' remained in the columns. 

If the measure value provided beyond the min and max, it would snip to a point as indicated in the log file: WARN |@Snip (or FMELine::snip) was given Measures of 123625.0508 and 123625.0508, which are out of range for a line with min/max measures of 2.1792075131088495e-6 and 79907.89199766226. Snapping params to closest valid value.Can Snipper be set to reject the input?

I need export ESRI SDE Raster-Dataset and Raster-Catalog to tiled GeoTIF. The ESRI Conection File to the DB run in FME :) . I need the setup for FME and how can i save direct (not first in temp. on C:user: ... I have not space on mashine :( ) I nned save in a extern drive.

I'm looking to generate the Getis-Ord GI* statistic in a workbench hosted on FME Cloud. I believe this can be achieved with an Rcaller, or by calling certain python packages.  Is it possible to install R, or non-built-in python packages on an FME Server instance hosted in FME Cloud?

Hi, We use FME Desktop 2021.1We read and applied the exact procedure found here, for single tenant application (custom Client ID):How to create a Sharepoint Web Connection (safe.com) However, when all the steps are followed, when we test the connection, we have an extra window asking for user authentification. However, the aim would be to use this webservice without the user to be identified : this way, the script could be executed by anyone.Moreover, when trying to identify with my personnel Azure account, it says that the approbation from an admin is required, so that FME can access the resources.Is it possible to overpass this authentification? Thanks a lot !

I'm trying to speed up the processing speed. There might be a few different ways to do this. I'm trying to make incremental changes to a workspace and every time I run it, it takes about 40 seconds. I have two tables in ArcGIS and I use a FeatureJoiner to join them in FME. One of the tables has a data field. I'd like to only process a range of dates. I have about 8,000 records total and I'd like to limit it to 1,000 or so records. Once I get my workspace functioning correctly, I'd like to remove this date range limit. I'm very new to FME.

Hello, After upgrading FME Server from 2019 to 2020 on Linux, i do have this message when i try to launch an FMEJobSubmitter : 1062021-8-5 17:39:57 | FMEServerJobSubmitter (ServerFactory): https://myserver.fr - Failed to submit request to run workspace 'Integration_Classeur_Affaire.fmw' in repository 'Affaire'1072021-8-5 17:39:57 | FMEServerJobSubmitter (ServerFactory): Reason - unable to connect to FME Server 'https://myserver.fr' Regards,Stephane