Best Answers

I have House number field but some of values are not valid like start with zeros and spacesneed to remove zeros or spaces from red highlighted columns

I have an IFC file representing a Stormwater network, and it has IFCFLOWSTORAGEDEVICE features representing nodes and IFCBUILDINGELEMENTPROXY features representing pipes.I have been able to pull out all the IFCPROPERTYSINGLEVALUE attributes for the node features thanks to daveatsafe's excellent answer here.However the pipes are a little more challenging as there seems to be some sort of aggregate standing in between the geometry and the attributes, and I can't expose the attributes in the same way. In the IFC file they are represented like this: IFCBUILDINGELEMENTPROXY('1HDtbP71IFCELEMENTASSEMBLY('3xaXAEmy159vLIFCRELAGGREGATES('2U9sLih9H1YhOYOIFCPROPERTYSINGLEVALUE('calculateIFCPROPERTYSINGLEVALUE('calculatewhereas for the nodes it was just straight in to the attributes:IFCFLOWSTORAGEDEVICE('1NHbOsZUIFCPROPERTYSINGLEVALUE('pit idIFCPROPERTYSINGLEVALUE('pit naIFCPROPERTYSINGLEVALUE('pit tyThe IFC file was created with 12D software, and to be h

Hello FME Users,i am using FME Version 2019.0.2.0 WIN 64 bit windows 10 . now days i am facing "FME EXE has stopped working" frequently mostly "WorkspaceRunner" & Workbench itself also facing do any one has solution why this is so    

Is there any way to configure automations or publications such that a workspace can be triggered via email from one of several senders? Both publications and automations can filter by email subject, and the Filter action in automations can then filter emails based on one sender, but there appears to be no way to filter based on a list of senders ("from either Person A or Person B"). Is this in fact the case?Details, if they help: we'd like to enable a certain work group of five people to be able to trigger a specific workspace via email. While they can and will also use a specific subject line, I'd like to be able to ensure that no one outside the work group can trigger that same workspace even if they know the "key" subject line.Is there a way to achieve this, short of using five separate Filter actions per automation? Which appears work, but isn't very elegant, and will get hard to maintain as/if a given work group develops more workspaces. It also doe

I am creating an index and have a couple of tiles that have multiple images associated with them. See below, I have two polygons that overlap, they have similar attributes, but I want them to merge so both are in the same field (Example 3). Is this possible?1. First PolygonS2_File_Nam123_456_2018.tif 2. Second PolygonS2_File_Nam123_456_2017.tif 3. Desited outcome.S2_File_Nam123_456_2018.tif, 123_456_2017.tif  ThanksB

I try to relate boreholes (points) to 3D Solids from Cad. (autocad_original_entity_type = autocad_solid3d) FME does read the 3D Solids as surfaces. (fme_geometry = fme_aggregate / fme_type = fme_surface)The way I found to do this is to convert the surfaces to polygons with a SurfaceFootprintReplacer, then use a SpatialRelator to define the relation. But this takes a lot of time as I have quite a bit, quite big solids.So I wonder: Am I doing this correctly? Does an alternative solution exist?Thanks!

Hello!Can somebody please try to figure out why in some cases bufferer doesn't work. I have 2 streets with the same name. I'm creating buffer around them gruped by street name. I want those two buffers to become one buffer.But when I put buffer amount = 5 nothing is passed through bufferer. If I change it to 3 or 10 it works. For 1, again it doesn't work. I played with the buffer size but can't figure out some rule why it works with some numbers but not with the other.Here is the data if someone want's to try. 

  I have two feature classes. one is Table-1 and another is Table-2.Challenge: Select data from Table-2 based on NICKNAMES which is matched with last NAMES matched. I need output LIKE FINAL TABLE. NOTE: need to select red colored DATA need not to select green colored DATA

I have a large, relatively complex workspace that performs a few tasks - loads data, validates bearings, distances, areas, creates subsets of the data and then creates a number of reports, PDF, HTML and XML)The PostGIS database is located externally on a separate hosted server.On my laptop the workspace takes less than 2 minutes to complete. My laptop is a pretty stock standard HP, Windows 64 Bit with 8GB RAM.I have published to FME Server Cloud and had a starter configuration established with 2 virtual cores and 4GB RAM. This configuration caused the server to melt down and the jobs just kept failing with no specific errors. I upgraded to the standard configuration with 2 virtual cores and 8GB RAM. The workspace failed after about 30 minutes and what appeared to be multiple cycles of attempting to run but still no errors in the log.Below is the memory monitoring. The job was started at 8:06, memory peaked a couple of times and then finally failed at 8:36What I am seeking is some advic

Hello!I have SHP file with the bunch of streets. There are many streets with the same name which is ok - streets with the same name can exist. But also there are some streets with the same name which are actually one street but entered as two different features instead of the one feature. So those streets have two geometries and the same name and are actually one street. I want to isolate (select) such streets. Is there any suggestion how can it be done in FME?So, for example, street with the name "Oak street" can have splitted geometry in one location but also there can be many other "Oak streets" in other locations (some of them regular with only one geometry, but also maybe other with also splitted geometries).So, the idea is to select streets with the same name which are in the neighborhood of 100m (for example 100m - the assumption is that those are most likely streets with the splitted geometry).I would appreciate any help and thanks in advanced!

As far as I can see, SharePoint writer currently only supports Custom / Generic Lists. Are there any plans for adding the possibility to write a SharePoint calendar? Thanks in advance!

Hi,I have ArcGIS desktop 10.2.2 (with background geoprocessing) and ArcGIS Pro 2.1.2 installed. I'm running FME 2018.0 , no admin rights.  How do I call specifically the ArcGIS Pro Python 3.x (C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3) from the Python Caller? When running the Python Caller example here:https://knowledge.safe.com/articles/47216/using-arcpy-for-fme-feature-processing.html  I see this message in the log:Using Python interpreter from `C:\\WINDOWS\\system32\\python27.dll' with PYTHONHOME `C:\\Python27\\ArcGISx6410.2'Python version 2.7 loaded successfully I don't quite understand the implications of changing the FME interpreter itself...does that limit the functionality of FME tools if I change the entire workbench to run from another version of Python? Incidentally when I've changed it in FME>options>translation>Python interpreter (from FME 2.7 to the ArcGIS Pro option) - it has no impact.  In my head - what I want to do i

Hi,I'm relatively new to FME but am interested in running a workbench that loops/iterates parameter values (Neighbour Finder distance, Bufferer distance, and a number value in a tester) multiple times.E.g. I want to generate outputs with a buffer distance of 5000, 10000, 15000, neighbour counts of 4,5,6 etc. What is the best way to set a workbench running, that will generate multiple different outputs, based on iterating through parameter values, naming outputs accordingly? I wish to end up with multiple outputs in a format similar to output_$BufferDistance_$NeighbourDistance_$NumberValue

Hello all,I am seeking help to configure the JSON reader, which I am not familiar with.The JSON file is not a GeoJSON, (despite containing coordinates). Only the JSON (JavaScript Object Notation) Reader recognises it.There are two arrays containing objects. custom_markers and markers "custom_markers": [ { "rating": 3, "gallons": 0, "marker_type": "Other", "mileage": 0, "longitude": "152.690125", "latitude": "-27.976959", "price": 0, "date": "1563341193.242588", "pin_color_blue": 1, "pin_color_red": 0, "marker_description": "", "pin_color_green": 0.5019607843137255, "name": "Stop 1 " },there are about 17 custom markers and these should be rendered as point objects "markers": [ { "longitude":

I have some vehicle GPS tracking lines. The lines have gaps in them. I want to join the lines.The data is ordered and categorised so I can use a Chopper to chop the lines into vertices and then a LineBuilder with "Group By" set to the vehicle Type and "Group By Mode" set to "Process When Group Changes" to rebuild the lines with gaps joined.However, in the source, consecutive lines may be a different vehicle of the same Type (I can see they are different vehicles but there is nothing in the data to differentiate individual vehicles), so I get unwanted connections.There are two methods I could use to prevent most of these unwanted connections:if the distance to the next line is too far do not create a connectionthe source data contains start and finish times for each track, so if the finish time of the current line is after the start time of the next one, do not create a connectionBut I'm not sure how to do either of these - can anyone help?

I have a workspace (2018.1) that read a ArcSDE feature class into a Geojson file and then read the Geojson into MongoDB. The Geojson writer works fine in writing, but always gives an error at the end of writing regardless of the geometry type or the size of the feature class:-------------------------------------------------------------------------------------------------------Opening the GEOJSON reader with source dataset 'W:\\gis_data_admin\\Admin\\AllenG\\FME\\MongoDB\\Geojson\\IHS_INT.json'A JSON syntax error was found at line 1, column 0The JSON data is incomplete: Unexpectedly encountered the end of JSON dataA JSON syntax error was found at line 1, column 0The data does not contain any JSON text-------------------------------------------------------------------------------------------------------If I change the reader to shape files, then I don't have the above problem. So the problem seems to be related to ArcSDE feature class. On the other hand, the Geojson reader

Hello, I just moved to fme 2019 and in this example I'm using workbench  FME(R) 2019.0.1.0 (20190506 - Build 19253 - WIN64)  I have very simple workspace: creator -> featurereader (postgis) -> gml writer   When I run it I don't even get to the breakpoint. On reader there is log:   2019-07-18 21:46:06|   7.6|  7.1|FATAL |POSTGIS reader: An error occurred. FME will attempt to provide more information on the error, but this may cause the translation to be terminated2019-07-18 21:46:06|   7.6|  0.0|INFORM|Successfully closed POSTGIS database reader2019-07-18 21:46:06|   7.7|  0.1|INFORM|Successfully closed POSTGIS database reader2019-07-18 21:46:06|   7.7|  0.0|FATAL |POSTGIS reader: stk::ex::bad_expected_access   I discovered that problem is with one row. In column of type:timestamp with time zone  value is:-infinityIn version fme 2016 I don't have that problem. I executed that workspace with fme 2016 and 2019 and here I can see the difference in fme postgis reader version:   I did 

Hello all,I have 1721 point features, which I am combining into a single line using LineBuilder.Each node has a datetime stamp, and I want to populate the line with the attributes "start_date" and "end_date" drawn from the "date" attribute of the first and last point feature.In the LineBuilder I have ticked the parameter Generate List, so I have a list with 1721 elements.I can use the Attribute manager to create a new attribute "start_date" with a value of;@Value(points{0}.date)However, I fail to do the equivalent for the last element in the list.@Value(points{-1}.date) is not accepted by the Text editor or the List Element Selection: points{}.dateI thought I might solve it by using ListElementCounter, which does create a new attribute with a value of 1721, but again the List Element Selection: does not accept an attribute value as an input. 

I am looking at valve turning data from a hand held device which is stored in an access database.The database has torque charts stored as an attribute in one of the tables ,It is an encoded (UTF-16LE)My intention is to split this into separate columns and make an histogram chart from it.Any direction on how to get at it will be very much appreciated.

Hi,I created some user parameters and want to set their values programmatically some time later (when some data is processed). Is this possible? Or I must set their values initially?

I'm building a flow that uses the MapnikRasterizer for building a legend but getting some unexpected results. The flow below creates a object in creator 4 and the AC adds a URL/path of the SVG to this object. The MapnikRasterizer replaces this point with the SVG using the symbolizer marker and the URL created with the AC in the file parameter under the marker parameters. See the fmwt file below for the flow and the files.The hello.svg and hello2.svg works fine with this but getting some weird results when using the hatch.svg.<?xml version="1.0"?><svg xmlns="http://www.w3.org/2000/svg" version="1.1" baseProfile="full" width="122" height="122">  <g transform="translate(0 0)"></g>  <g transform="translate(0 0)">    <rect x="0.5" y="0.5" width="21" height="21" fill="#ffff40" fill-opacity="1" stroke="#000000" stroke-width="1" stroke-dasharray=""/>    <pattern id="D3B19CBA-2005-7FB3-52A547FFC3CD3D34" patternUnits="userSpaceOnUse" width="115" height="18"

I am suddenly receiving a pipe separated text file with imbedded pseudo-unicode characters that are supposed to be a macronated 'o'. Unfortunately it translates to a ^Z in the ASCII file.All the vowels can have macrons in Maori and there is a new policy that all government departments must add macrons. If all software was unicode aware then this might work.Some programs will handle this, reading the whole file regardless of the ^Z but many stop. The FME CSV2 reader stops. Oddly the FME Textfile reader does handle them with encoding set to DOS-Latin-1 (ibm-850)What can I do?The simplest idea is to translate the pair of characters ^Zo back to a plain ascii o.Surely tr could just strip the ^Z...nope.I have tried to use utf-8 encoding parameter on the CSV reader and other tricks with tr without success.I have attached a test sample.asc of two records.Unix wc -l returns a count of 1, not a good start since I can cat two records.

When viewing in FME Data inspector it shows the bands as Band 0 (RED16), Band 1 (GREEN16), Band 2 (BLUE16), and Band 3 (UINT16) but the image in the viewer is black. I am able to view it in ArcMAP fine (although it is mainly red because ArcMAP is interpretting the NIR as the red band, the Red band as blue, and the Blue band as green.

Is there a way that FME can "bypass" the native format of .img Garmin (or intermediate format?) so I can create a transparent map to add on top of an official Trackmaps in both BaseCamp and GPS?

Hi I have a list of grid tiles on Esri shape format. Those tiles are not clustered, tiles can be anywhere in the country. I need to extract geometry within those Tiles, from an Oracle spatial DatabaseHow do I go by without reading all the features on the entire Database?thanks