FME Form

Hi, I have a non-spatial SQL dataset containing a unique identifier along with 2 sets of coordinates (start x and y, end x and y). I am using 2 vertex creators to spatially enable the data and then want to draw lines between the coordinates, separated by each unique identifier. However, using the LineBuilder the output is only coming out of the Point port and nothing is coming out of the Line output port. The workspace worked previously using Desktop 2018, the only difference now is I am using 2020 with updated SQL data, though the data type is unchanged.

Suppose I have a data containing 10 million records but I want to read every 1 million features and run my processing parallel in 10 batches. Can someone please suggest any method?

Hello all.Last year, I delivered a number of Shape files to a customer, which they had no problems in using.Now I've adapted another of our systems to create Shape files as a supplement to an email message.These latter Shape files cannot be read by their ArcGIS Pro. The error message is "Failed to add data: ... A user-supplied component or subscriber raised an exception (Exception from HRESULT: 0x80040208)". I've also tried to apply Geopackages, but they err the same way. Both output routines uses FME. The former used straight up fixed writers, and the latter uses FeatureWriter, but that shouldn't matter, right ?I cannot see any difference between the two Shape files, and QGIS reads them both without any qualms. Apparently they can read the offending Shape into QGIS, and have it save it as another Shape, that works in their ArcGIS Pro.I cannot see any difference between the two flavors (in QGIS), ex

When I add a custom domain for Salesforce in FME, FME is not adding or permitting the ?locale=au suffix. The formatted string should be https://p-2576944.my.salesforce.com/?locale=au but FME looks like it is using https://p-2576944.my.salesforce.com.

Hi allThis should be a simple solution and I'm obviously looking in the wrong places so would appreciate your assistance. I'm creating some new records in a database.I need to create a GUID (esri sde) and an exact string copy of the GUID Using the UUID Generator i can create a uuid like soUsing an AttributeManger to convert to UpperCase it writes the UUID like so - which is the esri way  Using the same AttributeManager i should be able to rename UUID to GUID and copy the value of GUID to a GUIDString attibute

Hello everyoneI am using the isochrone transformer in the fme hub for an analysis. I have a network to a single road and multiple source points. I'm trying to get each source point to be analyzed separately and to create polygons as a result of isochrone. All my attempts, including changing the transformer, were unsuccessful. Can you help me with this.I want an output like the screenshot below.a polygon for each source point

In the past I asked this question. Things have developed and now I want to use a HTML table, which is the outcome of a FME workbench, in a workspace app. Something like this: Within my HTML table I included sorting and search functionality. These were included in the FME app before. You entered a search string as a User Parameter - Hit Enter - Browser with found HTML content was shown. To improve my app I removed the FME search function and put everything directly in the HTML table. Is this possible in a workspace app?

How to get ArcGIS Explorer .markup files to shapefile/feature class format?

In an Interlis Model provided by the state, I have to write two geometries per feature to Interlis2. Using this FME article (Writing to Database Tables that contain Multiple Geometry Columns) I was able to read the multiple geometries from Oracle. In the database I have a view with both geometries (point and additional polygon). The linked article only provides information for writing multiple geometries to databases. In the Interlis-Writer (ili2fme) I don't have any settings for treating features with multiple geometries. Is it even possible?The interlis model needs the "primary" geometry (point) to be written as standard geometry, while the secondary geometry (polygon) should be written into a specifiy attribute "Detailgeometrie". How

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 />

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

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

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 F

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