General

Hello, I have received a list of vertices/points of different lines in a CSV-File from our client. The CSV-File has the same structur like the following image: Creating the respective lines is not the problem (VertexCreator -> LineBuilder (GROUPBY "row1"). In addition to the complete line with all its vertices, I would also like to create all the individual line segments between the individual vertices as lines. Now there is the possibility to achieve this with the chopper, but after segmenting the line into its individual segments I would have to attach all attributes from the second column of the CSV file (start -> end point) to the line segment again by means of a spatial selection. I would like to avoid this. Is there an elegant way to do this in FME? Thanks a lot

We have a dataset of 911 calls by unit and are trying to calculate a response order for the unit by call. The dataset contains the fields ReportNumber(Unique Call ID), Unit, UnitType, UnitDispatch(Date/Time), UnitEnroute(Date/Time), UnitOnscean(Date/Time), and ArrivalOrder(Numeric). My goal is to calculate a field ArrivalOrder so that if 3 units are assigned to the same ReportNumber I can tell which unit was the first on scene, second, ETC. The dispatch database only gives me the first unit but doesn't give me the running order if multiple units are involved. I've gotten to the point that I need to group them by ReportNumber and now I'm stuck. Has anyone tried to calculate something silitar and had any success? I thought maybe StaticsCalculator might work but wasn't giving me the order per line. Thanks.

Hello everyone, I'm trying to create a point of intersection between bridges and the road below. The problem is that I need to create one point at the first intersection in the direction of traffic as shown in the image below (Image1).  My first tought was do to a line on line overlayer to have the intersection point between the road and the bridge. In doing so, there is a lot of point that are created (Image2) and I don't know how I can select the right one automatically.  I have tried to select them based on the coordinate but since the direction of the road change all the time, it is not reliable.  The ultimate goal would be to have a point that represent the clearace of the bridge at the intersection of the first bridge in each direction. This would be needed for the whole bridge dataset and have to be generated automatically.  Any help is much appreciated!

I have a 2D shapefile of the building footprints (without the building heights in the attributes) and Lidar data. Is there a way to clip the pointcloud according to the building footprints and then extrude according to the pointcloud?  I've looked at this webinar, specifically Demo 6, https://www.safe.com/webinars/gain-total-control-of-your-lidar-and-point-cloud-data/ but the reader is giving me errors because the building reader is having troubles reading the building attributes I think.

I know the question is a little bit weird, but I'll try to explain it. I have to create a simple workspace to get data from an external database (Informix) and copy to our database. This workspace will be published to FME Server.  As I said, I don't get access to external database, from my PC, but I do from Server. So, if I can publish the workspace to the Server it will run correctly, I sopose. But, how can I create an Informix Reader in FME Desktop if I don't get access to this database? Is it possible to do it? Thanks.

How could i put the output of fme as image in sheet of excel file ?i have read Pdf file and after i worked on it at Workbench and did some modifications .i would like to have the output inside sheet in excel file as image. How could i do that ? FME version 2018 Thanks in advance .

Would it be possible to create a script in one PythonCaller with a number of functions, and then call the functions in that script from another PythonCaller using the 'from <script_name> import <function_name>' syntax?

I have a folder containing over 200 xyz-files. Each xyz-file contains hundrets or thousands of point coordinates. So it is basically a text-file in the xyz-format. There are no other specififactions in the files, so only the coordinates. I would like to convert each xyz-file into a mesh-file (like fbx or obj). It shoud have the best quality and use the least amound of disc-space. I am looking for a way to automate the conversion. So when I click "run" over 200 fbx-files (or obj-files) are created with only one click. Down below, you can see a screenshot of the xyz-file. There are no headlines, that indicate which number is the x, y or z coordinate, but I am assuming it is in the order as the filename suggests. I thank you very much for your help in advance!  

Hello,I have a lot of geotiffs that I want to import into a map project. Unfortunately these blueprints are framed by a white background, which I would like to transform into a transparent one. Basically I only want to keep the lines, that make up these blueprints. I imagine the required steps somewhat like this: Select the background. Since every blueprint has a different shape, i would try try to detect the background-pixels by colour (white). Possible drawback: Single pixels in the needed Picture could also be white and therefore be falsely selected. Is there a transformer for this you would recommend?How else could I differentiate the needed parts of the geotiff?Delete the selected pixels or turn them transparent.Another issue that I worry about: The thin, dark lines of the blueprints might hardly be visible on an orthophoto-based map. Can I somehow change the colour of my outcome? Since I am new to FME, I wonder which transformers I should use. If you are experienced with similar

I have a points shapefile, I buffer the points and use this to clip VRT Rasters. I need the output to retain the attributes passed from the point/buffer, which the clipped output does. However the clips retain georeference and place the clips within total images footprint if that makes sense. I tried converting to PNG (no world file option chosen) which works great but this loses all the attributes. Grateful for any suggestions.

Thanks for your help and suggestions in advance. I am using Elasticsearch service on AWS the default port for it is 443 not 9200. Unfortunately FME seems to keep wanting to put 9200 at the end and then reporting it cannot reach the service: ELASTICSEARCH writer: Opening index 'https://search-web-elasticsearch-4vxxxxpx2.eu-central-1.es.amazonaws.com/webmapnotes'ELASTICSEARCH writer: Failed to connect to search-web-elasticsearch-4v3o3xxxpx2znima.eu-central-1.es.amazonaws.com port 9200: Timed outELASTICSEARCH writer: Unable to locate or open server 'https://search-web-elasticsearch-4v3xxxznima.eu-central-1.es.amazonaws.com'. Please ensure the server exists and is accessible.  In the writer I put the port https://search-web-elasticsearch-4vxxxxznima.eu-central-1.es.amazonaws.com:443 That doesn't seem to work. Any idea how I can change the port away from the default. Many Thanks Oliver

I get this error when using HTTPCaller for generating .CSV file. It is fully authenticated as the call goes through and has status code of 200.Failed writing received data to disk/applicationHTTPCaller_2(HTTPFactory): HTTP transfer summary - status code: 200, download size: '6950 bytes'ERROR |HTTPCaller_3(HTTPFactory): HTTP/FTP transfer error: 'Failed writing received data to disk/application' 2018-07-16 14:29:06| 1.2| 0.0|ERROR |HTTPCaller_3(HTTPFactory): Please ensure that your network connection is properly set up 2018-07-16 14:29:06| 1.2| 0.0|ERROR |HTTPCaller_3(HTTPFactory): No proxy settings have been entered. If you require a proxy to access external URLs, please ensure the appropriate information has been entered.Please advise. Thank You @takashi, @david_r

Guys, seeing al the magic u do... impressive. This is only very start for me... any tips how to convert arc seconds into degrees...thanks

I am facing issue with conversion of geojson data to cesium 3D tiles. I have tried converting geojson to cesium 3D tiles using FME software. When I convert using FME, some of the faces of buildings are missing (shown in the attached images). Kindly guide me if something missing in that conversion.I have attached images of geojson data as well as cesium 3d tileset data from all sides of the building.

I would consider do this using ArcGIS python API, but wondering if FME can handle this, which would save me a lot of time and effort.

I have quite a complex workbench which works well apart from one thing. I need to pass a raster map and point to the same object in each page in PDFpageformatter. I created a Bounding Box to try to set the position and expected the raster and point to 'fit' into this. However the position seems to shift as the pages go on. See attachments. It seems to be basing the position on the overall combined raster footprint rather than the Bounding Box. I hope that makes sense? I've attached a snippet of my workbench for info.

I replied to a thread and later went looking for that same thread and I expected it to be in my Profile Feed, however my feed contains posts where I asked the question. Am I looking in the wrong place or is there a setting or something I need to select to find my replies?

On the last leg of migration to FME 2020 from 2018. Was able to clean up a lot of legacy junk - whew! and had a chance to upgrade all relevant workspaces in the process - whoohoo! Starting with a clean slate so to speak. But now I've run into an issue with a SQL Executor that runs some SProc's and does some updates/inserts. This was working with no issues in 2018. Now it complains about the semi-colons:Semicolons detected in SQL. May need to use FME_SQL_DELIMITER keyword to specify a delimiter.Then it fails with:Microsoft SQL Server Non-Spatial Reader: Query failed, possibly due to a malformed statement. Again, I have to ask: anything change from 2018 to 2020 as it pertains to FME_SQL_DELIMITER? Do I have to reformat my statement for Server? Desktop 2020 didn't seem to bother complaining about it. Thanks. Running MS SQL 2017. FME Desktop/Server 2020.2.

I need to use FME to generate .pdf & .jpg project location maps where the project boundaries are drawn in color and the rest of the map is in grey scale. An example output would be:  The issue I am encountering right off is that while FME can read in an ArcGIS Online map or ArcServer Map Service (REST), it doesn't appear that FME is able to read in all of the map symbology for the various layers that I hope to use as a basemap (I have all of the "additional attributes to expose" checked).   I had anticipated there being an issue with reading in text labeling, however I assumed that FME would read in all the layer symbology just fine. I tested this with a tiled web map as well and FME does not read in that symbology either. I am hoping that I will only need to manually symbolize my project boundary layer in FME while FME automatically reads in the unique symbology for each of the basemap layers. Is there a way to do this? I looked at an FME article on Creating PDF Cart

i would like to convert output lines to dash lines (- - - - - ) to show the line as dash in pdf output

Hi!I'm using TableAdder to create a table for a pdf writer. I'm having problem to align the rows. Can someone help me please. Thanks.

I'm evaluating FME DESKTOP 2020.2 and would like to know if it's possible to:- connect to a SQL database view (non-spatial)- update ArcGIS enterprise geodatabase (Postgresql) so far I am able to read the SQL data, I then generate points using Vertex creator, then finally attempt to update the geodatabase data.This is where I am stuck.What writer should i use?ESRI geodatabase arcSDEPostgreSQL writerPostGIS writer so far I haven't had much success with either.Am I missing a step?Do i need to generate objectIDs befortehand for the data to update the geodatabase tables?I was hoping to use FME rather than arcpy as it's alot quicker....thanks

I would like to explode a polygon containing lines and arcs into its parts and preserve the arcs. I am reading an autocad drawing and I tried the chopper transformer but it chopped the arc into line segments which is not what I need. Has anyone done this before?

When I run workspace its gives me error for below lines : Starting translation...Starting translation...Python version 2.7 loaded successfullyTraceback (most recent call last):  File "<string>", line 19, in MF_Include_1611748445222  File "<string>", line 5, in ParamFunc  File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/UserDict.py", line 40, in __getitem__    raise KeyError(key)KeyError: 'FME_LOCAL_OUTPUT'INCLUDE -- failed to evaluate Python script `def ParamFunc():  import os, time, re  temp_output_path = os.environ['FME_LOCAL_OUTPUT']But actual code is like  import os, time, re, sys print("before printing....")temp_output_path =  os.environ.get('FME_LOCAL_OUTPUT')print("printingvalue",temp_output_path)Its not running actual code. why its is like this ? I have set up environment variable also able to get value in general python script.  fmw script was running FME 2016 server. I am trying to run same script in FME 2020 workbench. This running fro

I have set environment variable which I am able to access in terminal. But in workbench. Is there any setting need to access this variable ? Trying to access using  os.environ.get('FME_LOCAL_OUTPUT') This is python startup script where some logging activity is doing.  This is working in FME server. Same thing am trying to replicate on local machine. Log of error :  Starting translation...('printing path', None)Traceback (most recent call last):  File "<string>", line 19, in MF_Include_161192722330  File "<string>", line 6, in ParamFunc  File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/posixpath.py", line 70, in join    elif path == '' or path.endswith('/'):AttributeError: 'NoneType' object has no attribute 'endswith'  INCLUDE -- failed to evaluate Python script `def ParamFunc():  import os, time, re   temp_output_path = os.environ.get('FME_LOCAL_OUTPUT')  print("printing path", temp_output_path)