FME Form

i have oracle data, how could i configure it to read the data from it .i am not sure how to connect with and read the data parameter available : user and password and Host and port no. and service name FME 2018

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

I have the following MongoDB Atlas cluster, hosted at Google Cloud, to which I'd like to connect in FME Workbench.FME should be capable of connecting but I did not find the right settings yet to do so.In my Node.js Express app I'm using a connection string which includes the username and password as well as the database. In FME these are separate fields.The connection string looks like so:In FME I think this translates to this, but it does not work for me. And what do I fill in for authentication database name? I'm stuck at the following error message: Any thoughts much appreciated!

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

Dear FME community, I have CityGML tiles which I converted into KML or KMZ files. They are in a certain folder structure. Now if I open single KML files they will only display in 2D with the inspector transformer. Is there a way to load all the files that belong to the KML structure? So that it displays in 3D? When I upload it in Google Earth it works just fine. At the end I would like to convert these KML or KMZ files into 3D CAD files like dwg or obj. Thank you very much for your help. With kind regardsChristian Lendl

I have a 2D point dataset with elevation information. They are not evenly distributed on the field. However, I would like to create a DEM based on the information I have. Which steps should I follow? My final goal is to calculate the Surface Volume. Therefore I need to generate a DEM. Thanks in advance.

Hi, I have a map with different territorial (regional) authorities and heaps of points (around 2000 points) representing each of those territorial authority. Question: My idea is to use the FME to reduce the number of points (or smooth the geometry) of each territorial authority. The reason behind doing this is.....I want to use that map in another geospatial software .....where with current number of geometry points it's hard to zoom in or zoom out the individual territorial authority (it takes long time to look into individual territory). I don't know which transformers in FME should I use to do this process...any suggestions on this will be really helpful.

Hi,I want to group materials and pipe length according to different age barckets (of say 2 or 5 or 10 years)...how could i do in FME?Please see my sample data: 

I am using AttributeCreator to add a new date attribute, and this is what I have in the attribute value:@DateTimeFormat(@round(@DateTimeNow(localUnzoned),0),%Y-%m-%d %H:%M:%S) I am getting an warning and null value in my output: I have tried using DataTimeConverter, DatetimeCalculator, and DateTImeStamper. All works, but it doesnt give me the output I want.  Example: 2021-07-21 10:30:40 Any suggestion?   

Hi everyone,  I have a polyline shapefile that represents a transport route. I also have a point shapefile of markers along the route. I want to be able to split the polyline into segments between the points. I want to retain the route rather than use line builder to create segments between the points.  I have tried using the PointOnLineOverlayer transformer but I end up with significantly more line sections than I am expecting. For example I have a line with 27 markers along it. I am expecting to get 28 segments when I split the line at these points. Instead I am ending up with 61 as the line is split in locations where there is no point (highlighted blue part is on of the output lines). I think this may be a result of the aggregate geometry parameter. When I run the polyline through the aggregate filter it says the line is an aggregate. I see that the aggregate options in the PointOnLineOverlayer are deaggregate (which I think explains why I get more line segments than I was expectin

I have input points with multiple coordinate systems. I am trying to use esri reprojector on them, using a table for the input and output coordinate system and the geographic transformation.After MUCH testing, it appears to me that the geographic transformations are not being read. I hard-coded the identical value that is in the table and the features ended up where I wanted. When I set the value to get read from the table, they don't. I am pretty sure I've entered it correctly.Note: since I ran successfully with a hard-coded value, after switching to reading the table value it is working correctly. Logical explanation is that it is not reading the table. Input coord is read from table. Output coord sys is hard coded (wgs 1984), geographic transformation appears to be ignoring table values.

Hi there,I'm having problems with my workspace. It's quite big:reading an oracle data basetransforming and calculating datawriting to SpatiaLiteAnd all this on a virtual machine.I cannot provide the workspace and data here as they are sensitive, but I'll try to explain what I already did:The wohle workspace will throw an error. Sometimes because of memory space issues, sometimes unspecified (just 'Error during translation').I already set FME_TEMP to another disk.I did run it in debug mode: no hints on the abrupt termination.I disabled some parts of the workspace to get a focus + activated caching: while running part by part including writing to SpatiaLite, it didn't fail! But: I saw the temp-directory increasing up to 40GB.I ran the workspace in batch mode - failed. What else can I try? It seems to be a space issue (disk and/or memory). Does anyone else have experience on that (especially with a virtual machine)? Cheers,Maria

I have a line and a point dataset. The lines have measures, generated with the MeasureGenerator. Some lines are partly overlapping, so they share part of their route. The lines have a "ROUTENAME" and the points have the same attribute, indicating which line they are associated to. Now I want to derive the measure value of the points along the route, but only on the route they are associated to. How can I make the PointOnLineOverlayer and MeasureExtractor take into account the "ROUTENAME". Now some points get the wrong measure (of another route on the same location). Any ideas to help me out?

My input is a dwg file. Currently, I am reading the layer which consists of the location and the height of the elevation point in the field. I am trying to create point feature with VertexCreator. I think it does create it. However, if I send the output to the PointOnAreaOverlayer, all points are rejected and get "INVALID_POINT_GEOMETRY_TYPE". And idea what I am doing wrong?Here how my workbench currently looks like https://i.imgur.com/nh25NON.png And here is my points and the rejection msghttps://i.imgur.com/75tF2Eq.png

HiI'm trying to read a raster from pdf plan 08 that can be downloaded from his site:https://challenges.dk/en/challenge/banedanmark-digitisation-cable-drawingsThe plan includes i raster feature. I can view it ok in Chrome but when I try to view it in FME all the RGB and A pixels values are 0 and th plan is not visible. Any idea how to fix this?

I have exported an AGOL featureclass as a JSON and GeoJSON featurecollection as I need to use the httpcaller to push the data to another feature layer in AGOL. I need to use the caller as I need to see the to/from objectID's for further record manipulation. However, I am really struggling with the format of the json to read from the file. Any pointers would be appreciated. thanks. Example exported JSON below{ "type" : "FeatureCollection", "crs" : {  "type" : "name",  "properties" : {   "name" : "EPSG:3857"  } }, "features" : [  {   "type" : "Feature",   "id" : 1887,   "geometry" : {    "type" : "Point",    "coordinates" : [     12897276.605700001,     -3756547.8676999994    ]   },   "properties" : {    "OBJECTID" : 1887,    "description" : "100 James St.\\nreplace pit lid and patch with cre

Hello Safe Software, The functionality to disable transformers in FME Workbench is a very useful functionality that I use quite often in the iterative stages of workspace development/authoring. But as of now when a transformer is disabled in a workspace in FME Workbench, FME features do not pass beyond the disabled transformer. Can Safe Software look at adding the ability in FME Workbench to let FME features pass through a disabled transformer. In other words, the transformer though still in the data flow but since made inactive (disabled) should simply let FME features to pass through without any manipulation it is actually expected to perform on the FME features entering it. Regards  SRG

i would like to add 6 extra character empty space at end of attribute value that include text . How could i achieve that ? FME 2018

Welcome to What’s Up Wednesday, your weekly source of FME and Safe Software news! Known IssueDue to Google Sheets changing our app verification status, you may encounter an Authorization Error 401: disabled_client when using 2FA. To resolve this, please update the Google Sheets package or create your own app, see Known Issue: Google Sheets (v4) - Authorisation Error 401: disabled_client for more information.  FME TrainingIf you’re reading this early on the 21st, there is still time to sign up for today’s Integrate Data with the FME Platform training course which starts at 9am PDT. We also have other free live online courses you can sign up for, or check out the new FME Academy, it’s Free!  WebinarsWe haven’t added any new webinars this week, but our Partners have! So be sure to check those out.  Knowledge BaseHow to Read XSD-Driven XML: This new article walks you through how to read XSD Features and the difference between reading XSD and Feature Paths. Local Government Citizen Services