Transformers

I was using"

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.

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 can I tell FME to write the secondary geometry to a specific attribute? Attached is the interlis-model (ili) provided by state.The class with multiple geometries is "InfrastrukturKnoten" with its optional attribute &quo

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?

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.

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.

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'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! I have a question that I can't figure it out myself. I have a CityJSON (v1.0.1.) building data set which contain surfaces with type both "RoofSurface", "WallSurface" and"GroundSurface". How can I read or filter my data based on these types? Does FME support this when processing CityJSON, like it does for CityGML? I have tried eg. to extract geometry parts and deaggregate buildings, but none of these helped. Thank you a lot!

I have a user parameter getting a string of comma separated words. I would like to use that as items/arguments to filter whether or not a feature attribute contain one of those words. It would be to be used on about 10,000 features eventually with maybe up to 5 different words I can get the user parameter to a list, and then to an attribute, but I can't find a way to use those to filter my dataset, either using Like, In, or Contains Any idea how this can be done?It's basically to filter whether a path does or not contain some words

I have a bunch of records with a GroupID attribute on them. Some GroupIDs will only have a single record/geometry, while others will have multiple records/geometries. When I use the Aggregator, it aggregates ALL the records, even the ones that only have a single geometry part.How do I either aggregate only the truly multipart aggregates or deaggregate only the single part aggregates?

I am trying to export to a geojson file (to upload to Mapbox). Unfortunately, 5 out of my 736 features have a type of GeometryCollection. The remainder of the features are MultiPolygon and Polygon. Mapbox is unable to work with the GeometryCollection. I tried using a GeometryCoercer with the Geometry Type set to fme_multi, but all of the features go through the Untouched port. I also tried running the 5 through a GeometryRefiner. This converts 2 of the 5 to MultiPolygon, but I can't seem to get the remaining 3. I have been trying to figure out how to use the GeometryPartExtractor, but I can't seem to get the syntax correct (this is all quite new to me). I'm also wondering if my lack of understanding of the Geometry XQuery syntax is the reason I can't get the GeometryCoercer to work. If anyone has any experience with this, I would greatly appreciate the advice. Thank you.

Hello, I have a single line, and also a set of 16 points that lie along that line.  I need to split the line into 16 different segments that start/end at these points. I found PointOnLineOverlayer that does this, and even mentions being able to apply attributes to the segments.  Its working perfectly to split the line up into segments, the problem I'm having is that those segments don't seem to be taking their attributes from the points that split them, but instead are taking them from the original line, and so the attributes for each segment are identical. How can I apply an attribute from the points to each corresponding segment of the line?

Hi FME'ers,I am using the HTTP caller to download multiple CSV files to a folder. I'd like to zip the folder and output the zip folder path as a single features to a automation writer. Can this be done? The automate writer would then trigger a second workbench to read all the CSV files and process them. I don't want to automation writer to trigger this workbench per file. Thanks, David

Hello i have Columnname A and B.I read the Excelfile with a FeatureReader. Get Columns A and B.Now i close FME. Rename Columname A to C in the Excelfile.Open FME. Read the Excelfile. Get Columns A and B instead of C and B.Why does FME cant see my renamed Column C and still sees Column A wich doesnt exist anymore?

I'm trying to reproject layers that were built in CAD. The first 6 figures of the coordinates match up to british national grid 6 figure grid ref. BUT there are 9 figures in the grid reference almost like it used BNG in millimetres instead of metres. I'm sure it is a simple quick convert/reproject but I'm a bit stumped...?

Hi All, I am stuck trying to figure this out. I am having trouble seeing feature classes inside FeatureDatasets using the FeatureReader. My Feature Types to Read is fme_feature_type_name and I am exposing fme_feature_type and geodb_metadata_string. All seems to work for feature classes but FCs in FeatureDatasets are skipped in Generic. They come across in the Initiator though. See screen cap below. I must be missing something simple. Any thoughts?

I'm fairly new to FME Desktop. I have a FeatureWriter with three inputs. I'm creating an Excel file with three sheets. It works great except many of the column widths are much wider than the content. I have to open each sheet, select all columns and Auto Fit Column Width. Today I realized that if the data type is text(255) then the column width will be 255. If the data type is text(150) then the column width will be 150. My data source is an ArcGIS feature layer created from Survey123. The default length for a text field is 255 so, I have many columns that with a width of 255 in Excel. This doesn't seem like a great way to determine width. I'd rather go with the Excel default column width. In the User Attributes tab of the FeatureWriter parameters, I see that I can set the column width. I believe that I can use zero to auto fit the column width. The problem is that I have about 30 columns and 3 sheets so, I'd have to type '0' close to hundred times. Is there

i have seen numerous posts about this but i cant get a good working solution. i have a user parameter that i want to limit a second user parameter based on the selection of the first. so far i can get a filter on the first parameter but how do you link the second parameter to the first in order to present the user with only the attributes that match the first parameter?

Hi, How could I assign a value to a polygon based on the value of most of the overlapping points? Thanks in advance. 

I just would like to convert xml files to json keeping the structure. I give you an example of my problem : My xml files look like that : <Organisme id="pmi-25047-01" codeInsee="25047" dateMiseAJour="2019-04-19" pivotLocal="pmi">  <Nom>Centre de protection maternelle et infantile (PMI) - Baume-les-Dames</Nom>  <EditeurSource>La Direction de l'information légale et administrative (Premier ministre)</EditeurSource>  <Adresse type="géopostale">  <Ligne>2 rue des Frères-Grenier</Ligne>  <CodePostal>25110</CodePostal>  <NomCommune>Baume-les-Dames</NomCommune>  <Localisation>  <Latitude>47.3492012024</Latitude>  <Longitude>6.36126995087</Longitude>  <Précision>8</Précision>  </Localisation>  <Accessibilité type="ACC">rampe d'accès</Accessi