Best Answers

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.

I am trying to connect to an ESRI basemap through a REST endpoint and utilize the resulting raster within a VectorOnRasterOverlayer, but I cannot get the raster within my workspace to work properly. Here is the URL that I pass into the ImageFetcher. This results in an image but it doesn't know its spatial placement and such. I have tried to return JSON but I don't really know what to do with it...https://services.arcgisonline.com/arcgis/rest/services/World_Topo_Map/MapServer/export?bbox=-87.835947%2C31.067928%2C-87.601273%2C31.214859&bboxSR=4326&layers=&layerDefs=&size=&imageSR=&format=jpg&transparent=true&dpi=900&time=&layerTimeOptions=&dynamicLayers=&gdbVersion=&mapScale=&rotation=&datumTransformations=&layerParameterValues=&mapRangeValues=&layerRangeValues=&f=image Any help on this would be greater appreciated.

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 676 DTMs, each a 1000 x 1000 grid. I am trying to convert them to a point cloud.I am using a PointCloudCombiner transformer between reader and writer. This worked perfectly for my sample tests. 1,000,000 points produced for a single file.The transformation fails when I scale it up to read all the files due to the limitations described here: https://community.safe.com/s/article/error-reading-large-number-of-raster-files#:~:text=The%20C%20runtime%20library%20used,file%20for%20reading%20or%20writing.I've used the work-around technique described and also used an additional RasterBandNodataSetter before the 2nd RasterMosaiker which I think creates a rectangular DTM within xmin, ymin to xmax, ymax despite there not being full coverage of this area in the 676 input DTMs.In the Raster Parameters in the PointCloudCombiner, Extract Nodata is set to No.When I test the workspace on 5 tiles it produces a point cloud with 5,000,000 points as I would expect.When I scale it up to process al

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 am wanting to set the twist angle on an existing viewport, I see twist angle in the DWG reader but I am having trouble finding how to identify the viewport in autocad since they are not named, can I use viewport order and only rotate view port with same order? After that I think it is simply a matter of inserting the proper attribute on export but I am not sure what the name of the attribute is.

Is it possible to set up a parameter for a custom transformer so it allows selection of a list, not just a single element of the list?

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

Hi,  I have troubles setting up a dynamic writer. In my workbench I perform two different queries on a PostGreSQL/PostGIS database. I want to write the results of these queries in a FileGDB using a fanout that creates feature classes based on an attribute value. Furthermore I want to overwrite the entire GDB each time the workspace runs.  I setup a FeatureReader for each SQL query, connected the ouput+schema to a fileGDB writer using the dynamic writer option. It almost works as desired but the problem is that the different schemas are merged in the output, so each feature class now has all attributes from both SQL queries. Does anybody know if and how I can setup the writer to get the correct schemas. Thank you very much!  

I know how to use ListConcatenator in order to concatenate all list values into a single attribute. However, what can I do if my feature has multiple list attributes? I want to concatenate all values of all lists into respective single attributes. The resulting single attributes should have the names of the original list. I don' know the names of the lists in advance.Examples:colour{0} = 2 colour{1} = 3 colour{2} = 2single attribute colour = 2,3,2shape{0} = triangle shape{1} = square shape{2} = circlesingle attribute shape = triangle,square,circleThanks for any help

Hi Guys, Can anybody help me with this. In condition statement i putted if a like b value is @int@rand()*4 which gave me random value 0,1,2,3. Now in else i want to put rand value 6, 7,8 How can i do this ?? It would be a great help Thank you 😊

Good morning. I'm putting together a workspace to transform a Revit file into Cesium 3D tiles. Overall, it is a pretty straightforward process, but I'm facing an issue with the elevation. The building stored in the Cesium 3D tiles is floating, so I need to offset the Z to put it in floor level over a 2D basemap. I've been using the Offsetter transformer with lots of trial and errors until getting it right, but I would like to know if there is a better way. So the question is: Is it possible with FME to make that "elevation removal" automatic?

Hi, I've got a pretty complex model going on, and I am writing an an excel file (appending) a few times throughout. However, even with the Feature Writer (as shown here) field names, it's not being picked up in the Feature Reader which is the next step. I know there's other field names of this type in the model, however I'm pointingit at the file to read, and they appear as such in the written excel file. I've tried purging temp data, closing and opening workspace, but to no avail. Any ideas?Thanks

Hi All, I tend to use the workspace description parameter to track my overall changes and updates to the workbenches I create. This is handy for me to have a way to track things within the workbench itself, without having to keep notes elsewhere on what i've done. However, it's not exactly easily "user facing" for the others in my organization. I'd like to be able to pull the overview, help and history from the workspace parameters in order to have them exported out alongside the reports that i'm generating if possible. I don't see them stored as standard parameters that FME can fetch in something like ParameterFetcher. Perhaps this information is accessible in the FME python API somehow?

I'm attempting to use the Trimble Connect web connection, but I am receiving an authentication error. I have a Trimble Connect account and have received my consumer key and consumer secret for authentication, but I'm not able to get it to work.  I've reviewed the Trimble Connect API documentation, but I am still relatively new to working with API's, and this API requires multiple steps, so I'm having trouble. Does anybody have examples of authenticating with Trimble Connect with FME? I could sure use some assistance. I downloaded the provided collection and environment in PostMan and was able to connect, but no luck getting this to work in FME. Trimble Connect API Documentation 

I

Hi all, Often users from this forum reply and attach a file with a sample workspace that shows how the transformer works. So I wonder if there is a collection of example workspaces for any transformer somewhere ? Thank you!  

I am trying to load some buildings to Cesium but when translating shp to Cesium 3D tiles I get rotating buildings in Cesium (when changing the camera position), although the buildings' location is correct in Cesium. I've tried converting this shp file to gml and then loading this gml to Cesium ion which makes 3d tiles itself and this works - buildings are not rotating. What could go wrong with FME Cesium tranformer when tiling?

Hi there! I am a testing the capacities of setting up a REST API to interact with FME Server, and I am now stuck trying to get access from an external network. I am usinghttp://<yourServerHost>/fmerest/, pasting my hostname:80, but browser always reply with the “This site can’t be reached”So, I can neither access Web User Interface from an external network Was looking for an answer on the Forum, but couldn’t find any. Some post are around allowing firewall to get the port 80. Already did that, and nothing happens. Do you have any suggestions?Thank you very much, J.

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) 

FME 2020: What is the equivalent tool for AutoCAD “join” in FME? For example, in the screenshot below, I got 4 lines. I need to join (merge) connected lines to end up with 2 lines (polylines). What tool can perform this?        

FME 2020: How to select polygons (areas) that contain more than one point? I couldn’t figure out how to select polygons (areas) that contain more than one point. For example, in the screenshot below, I got just two polygons that contain more than one point. How to get them identified and selected?