Best Answers

I'm wondering if it's possible in FME to perform a dynamic segmentation on an LRS event with an offset to the output line geometry.  What I mean by this is I'd like the result geometry to be beside the base geometry, parallel to it and a distance away. For example, here's my base LRS geometry, going from 0 to 10 meters. Here's the event I'd like to perform the dynamic segmentation on, with a start measure of 0 and and end measure of 5. This is what I'd to have. A line going from 0 to 5 meters, located to the left of the base LRS geometry. Is it possible to do something similar to this in FME?

I am needing to read a comments field and replace the double quotes with 'inches' and replace & with 'and'. I tried my hand with regular expressions, but am very new to this and it did not work (user error I am sure). I also just tried Replace Text and it doesn't seem to work either.

The problem:I have two lists which are related to each other by way of index so lets say we have the following format - List 1 (contains 4 Elements)List 2 (contains 4 Elements) The Elements in each list relate to one another so Element 0 in List 1 is directly relatable to Element 0 in List 2. Element 1 in List 1 is directly relatable to Element 1 in List 2 and so on and so forth for the rest of the Elements. What I'd like to Achieve:If any Element stored in List 1 = "foo" -- I would like to remove it as well as the related Element in List 2. I think this is easily achieved if it is possible to extract not just the attribute of the Element in the lists, but the Element Index as well. How do I do this? I am able to extract the attribute name of each Element easily by using:my_list = feature.getAttribute('my_list{}) Thanks in Advance. 

Hi everyone. I'm using the FGDB Open API writer in 64-bit FME 2020.1 (build 20624) to write an FGDB table (no geom). I have 2 "double" type fields in the FGDB table which are set to allow NULL values (I've checked in ArcCatalog). When I run my Workspace, FME refuses to write features to the FGDB table which have NULL values for the "double" fields. I have tried ensuring the values are NULL using a NullAttributeMapper before the Writer, but it hasn't made any difference. I have also tried using the other FGDB Writer - the one that uses ArcGIS Desktop, which seems better - I just need to fix some features which have "null" instead of NULL to complete the testing. Has anyone else experienced this difference between the FGDB writers?

Hi, I have a workspace that downloads two different files (1 geopackage, 1 textfile), renames them and stores them in a ZIP file. Said ZIP should contain the current date in its filename. Normally I use the date/time functions in the filepath paramters to create the current date on the fly but the options in "Destination Fanout Directory" do not offer these functions. As a workaround a created a Text Parameter where the user enters the current date manually but if possible I would like to do this automatically. Can this be done somehow?

Hello,I am trying to do some cleanup work of some Polyline Features where densified curves have been created due to loading the data into a Shapefile at some point in the past. I want the densified or stroked curves to be turned into true curves. I know there is the Curve Fitter transformer but I want to limit the amount of linework that the Curve fitter is run on to help eliminate unnecessary manipulation of the data. I have some approximate curve selection parameters in a Python Caller Transformer to help select the appropriate lines to select the lines I want the Curve Fitter to run on. The issue is I need to know which lines are connected together in sequence to allow the Curve lien selection algorithm to work. The lines have OID fields that are randomly generated based on the copy and past functionality of ArcGIS Pro. So far I have tried the Attribute Manager Adjacent Features but that appears to work off of table rows which is OID based(I think) not spatially based so that doesn

I would like to transpose the attached data structure. I have tried using the attribute transposer without luck. The attached excel has the input structure and the desired output. Many Thanks, Andrew

HI, I've not used the HTTPCaller using a POST request and body attribution.The API call constructed by the developer has been provided like this:var client = new RestClient("https://sww.smartchartapi.co.uk/api/Authentication/request");client.Timeout = -1;var request = new RestRequest(Method.POST);request.AddHeader("Content-Type", "application/json");request.AddHeader("Cookie", "ASP.NET_SessionId=xcqkvogm2bp2yxshsgx1ncbg; AspxAutoDetectCookieSupport=1; __AntiXsrfToken=e680dfae824a472088c01d6672ba8471");var body = @"{" + "\\n" +@"  ""username"": ""SWWAPI""," + "\\n" +@"  ""password"": ""***""" + "\\n" +@"}";request.AddParameter("application/json", body,  ParameterType.RequestBody);IRestResponse response = client.Execute(request);Console.WriteLine(response.Content); I've set

I am using a few check boxes at the Run window to let the user choose a few different things. I'd like different action to result from whether a tick box is checked or not. I can do that ok using a Tester and checking if the user Parameter is YES or NO, and the test works well, but this gets ignored by a FeatureMerger a bit later. The workbench somewhat carries on no matter what the test result is.  The end goal is to only create attributes if the user tick a box or not. Are there examples of that?   No features should go to the bookmark in yellow, but it does anyway despite failing the test. And the FeatureMerger returns empty values of course. I'd like to get rid of the Attribute with empty values before they get exported. What's the best way to do that? Let it merge then remove the attribute? if user-parameter is NO -> AttributeRemover on X I'd be a lot easier with Python, am i missing something obvious? I tried this but can't make it work: https://community.s

Hi everyone, I'm making a call to the FME Server API to get a list of Schedules and I'm getting back "raw" encoded strings in the json response, but I would like the "values". Is there any way to do it? Here's an example request, which uses a token that I set up in FME Server (the token only has access to the Schedules) :  The json returned looks like this : {"offset":-1,"limit":-1,"totalCount":65,"items":[{"owner":"me","request":{"publishedParameters":{"name":"MyURLAttribute","raw":"https:<solidus><solidus>myFMEServer.com<solidus>something<solidus>blah"}...The "raw" values look like they're encoded eg. "<solidus>" instead of "/" I was expecting :{"offset":-1,"limit":-1,"totalCount":65,"items":[{"owner":"me","request":{"publishedParameters":{"name":"MyURLAttribute","value":"https://myFMEServer.com/something/blah"}...I tried changing the "response encoding" to the system default but it didn't make a difference.  Any ideas?   

Have updated the Apache listening port to 8080 and updated the virtual host statement.http://192.168.1.???:8080/ does return the Apache2 Ubuntu Default Page http://192.168.1.???:8080/fmeserver returns 404 Not found message. I get same behavior on other Windows boxes with other browsers. Thank you in advance!

17302021-7-26 00:00:58 | Python Exception <TypeError>: '<' not supported between instances of 'str' and 'NoneType'17312021-7-26 00:00:58 | Traceback (most recent call last):17322021-7-26 00:00:58 | File "AttributePivoter\\__init__.py", line 163, in close17332021-7-26 00:00:58 | File "AttributePivoter\\__init__.py", line 268, in generate17342021-7-26 00:00:58 | TypeError: '<' not supported between instances of 'str' and 'NoneType'17352021-7-26 00:00:58 |17362021-7-26 00:00:58 | AttributePivoter (PythonFactory): PythonFactory failed to close properly17372021-7-26 00:00:58 | AttributePivoter (PythonFactory): A fatal error has occurred. Check the logfile above for details17382021-7-26 00:00:58 | AttributePivoter (PythonFactory): A fatal error has occurred. Check the logfile above for details17392021-7-26 00:00:58 | A fatal error has occurred. Check the logfile above for details

Hi FME world, I have a workspace which reads from and writes to several ArcGIS Online feature service layers. At some point, it has stopped updating the data within one of the layers. The workspace still runs successfully and writes features to the layer, but the data is not updated (where there were existing data present) when I check the written features. Where there are blank fields before, the update works as expected. So there is something to do with not being able to overwrite fields where data is already present.The writer mode is set to UPDATE and there are only ever an X amount of features to update, so the OBJECTIDs never change.  Any ideas?Thanks

Hi,I found an example for creating multipage pdf on https://www.safe.com/webinars/choosing-the-right-transformer-for-your-data-challenge/?utm_source=youtube&utm_medium=social&utm_campaign=webinar-transformers-2018. I downloaded the workspace pdfpalooza.fmw and tried it. In the demo I see it crates a pdf with multiple pages, but when I run de workspace in FME 2020.1 it writes evething to one page, see attached PNG. I want to achieve the exact same thing, so multiple pages for one of my own workspaces so it would be nice to have a working example. Anyone?

I have 3 Transformers (StatisticsCalculator) at the end of my workbench. They all sum up some values. As the output of the working process I would like to create a log file or text file that show the results of the Transformers like Humus: XXX m3Volume 1 : XXX m3Volume 2: XXX m3Values are the output of StatisticsCalculator. I used Text File Writer where I collected all info in text_line_data. However, the output does not look how I imagined. It repeats it 3 times https://i.imgur.com/2OpR3lg.pngAny idea how I can avoid repetition? https://i.imgur.com/9ejOMzh.pnghttps://i.imgur.com/IrG2xcL.png

Hi, I have created a simple workbench that merges two datasets together and performs statistical calculations. So far, I have been unable to set my Excel writer to have one sheet for the dataset and another sheet for the summary from the StatisticsCalculator. I have already seen the "write data to different sheet" post, but have not had much luck. Would anybody be able to offer any advise to me, please? Many thanks, Jess

Hi, I'm trying to make an html report using the awesome HTMLReportGenerator transformer, I've been able to do some customizations for better results, but when it comes to the charts that the report creates, I'm still not sure how to increase the width it occupies, to get a graphic distributed over the entire page space. I've been reading the documentation for chart.js a bit, which is the js library that this transformer uses to generate the charts, but still haven't found the answer, does anyone know how I can get a larger chart? I have attached an image of the current report that I can generate and as you should see it would look much better if the chart took up all the space, I already moved the legend to the bottom so I have room on that side. Thanks!

Is there any tool to calculate real surface from DEM which similar to this tool from SAGA http://www.saga-gis.org/saga_tool_doc/2.1.3/ta_morphometry_6.html? It mainly takes into account the slope while calculating the surface area! Thanks in advance

Hi, I have a NetCDF file, exported from flood modelling software, that has the timesteps stored as seconds since the flood event started. I am wanting to read and use a timeslider in ArcGIS, but it seems that I require a valid StdTime format for the timesteps. In FME I am attempting to add a 'fake' date on to the start of the seconds value and convert the timestep format to make this work.The timestep is located in a matrix(?), i.e. as netcdf{}.coordinate_variable{} Anyway I think I have to explode the netcdf list so I can add on the date to the coordinate_variable list. This is fortunately always {0}. After changing this value I then rebuild the list and join it back to the original features (after removing the list attribute from the original feature).However I am getting the following error when trying to write to the output NetCDF file.NetCDF writer: Multiple bands have the same permutation of dimension values. Please ensure tuple of values specified in the netcdf_band{}.c

I am not getting the results that I expected. I believe it may be because I do not have anything connected to the 'Initiator' for the SQLExecutor transformer. What I was trying to do, was to execute the SQL statement and if no results were returned then proceed with the workspace. If records are returned, then send to the Writer. This sql statement should return 1 row.

Hey guys, I have an CSV file where I have 4 different columns with values (column1 till column4). I'am creating in the attribute manager a new columns (column5) where I connect all the values of the first four columns with a point in between.   For example  ```column1, column2, column3, column4, column51, 2, 3, 4, 1.2.3.4```  `column2` has the special that there are numbers from `1` til `99`. I want to put infront all values of `column2` which are from `1` til `9` a `0`, so that it looks like the example. But already two digits numbers should not get a `0`.   For example  ```column1, column2, column3, column4, column51, 02, 3, 4, 1.02.3.4 3, 65, 5, 9, 3.65.5.9``` How can I manage this? Has anybody a clue? Or could somebody help me please? Thanks in advance! Have a good day! Cheers, Fabian

Hi,I am trying to read data Oracle non spatial data from a View and create an output in Oracle Spatial.Although the process writes to the Oracle Spatial table and you can view the attribute data OK the data does not seem to be spatial and I can't see any data on a map. I have learned through passed experience that the Spatial Column must be changed from GEOM to SHAPENot sure if this is because i can't set the Eastings and Northings in the Reader to Types x_coordinate and y-coordinate?You can set in a CSV Reader but not Oracle? (if this is the issue)  Thanks

I need to run a sql statement to determine if my workspace should run. If the sql statement returns any records, then I need to terminate the flow. If nothing is returned then it is okay to run the workspace. I would like to pass in a user parameter as a string to be used in the sql statement. Is this possible?

Dear FME community, I have attributes which contain numbers with several integers like 5800386.006999999 as values. I would like to round these values in steps of 500. So the number above becomes 5800500. If the value is closer to e.g. 5801000 then it should be rounded to that number. If it is closer to 5800000 then it should be rounded to that. The values can have a lot of decimal places or none. This means the solution should be able to handle any given number.  I am very thankful for any help. Thank you so much in advance!

I have 4 lines and I constructed a polygon by using AreaBuilding. Now, I would like to clip the polygon with a 60 m offset from the northeast point. How can I do it? https://i.imgur.com/U59AcpG.png