FME Form

I have a process that is reading from Smallworld (using the SWORLDSWAF reader) in 2020.1. All it is doing is writing to a file geodatabase. It keeps running out of memory no matter what I do. Is there anything I can do to reduce memory usage when accessing Smallworld?- I can't use 64 bit because the Smallworld reader isn't compatible-I have 32 GB of RAM on my Windows 10 machine-I have the temp files writing to a separate hard drive-I have a WHERE clause filtering out the incoming features Thanks

I am looking for the proper format to use the WHERE Clause to query features using the Smallworld 4/5 reader in FME 2019.1. The closest I can seem to get is:[interfaces].maintenance_notification where code_group_for_part = "DMPS0TR"[interfaces].maintenance_notification where code_group_for_part = "DMPS0VM"I have tried every combination of things but it always throws errors.

I have to tables from ms sql server.table A: Task_postingtable B: Task_analysis They are joined by the transaction_id field. Now I need to get all Fields from A and add line_cost, Line_qty and Line_unit from B. What transformer is the best for this? I tried to use databasejoiner, but in the section "fileds to add" I cannot find the fields from table B 

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?

Is it possible to publish a workbench to FME Server that will?Let an end user upload a random (Esri) GDB with any type of content and random naming of features.Be able to choose (dynamically) a feature within the GDB and transform that selected feature to example SHP.Key points the choice dropdown list can’t be predefined/hardcoded, standard GDF formats to be used such as points, polylines, polygons, rasters not Datasets, Annotation, Topologies etc

I am working on a longterm project that will take csv files, turn the data into fme points and then use them to publish an agol web map. I have been trying to play around with the agol writer to publish the new feature layer. Whenever I use the writer to create a new feature layer, the data is lost, somewhere in the process and i get a blank layer with no data in it. Furthermore, when I try to insert data into these layers, nothing happens, the writer says it runs successfully but there will be no new data in the tables, they will remain blank. The final goal of this project as I said is to take csv data files containing point data and automate the process of making a web map with them. Is FME's writer unfeasible for this task? Do i need to accomplish this goal using Arcgis REST Api? The CSV datafiles typically contain the following: Latitude, Longitude, Object ID, Completion Status, Address, and a notes field. If I need to use python, how do I write my code so that it will use the

Hello !I'm completely blocked in finding a solution to be able to do the quality control of data. I have an autocad file in reader which I've transformed in GML and Esri Shapefile in writers. Now I have to do a quality control to know if there is missing lines, curves or areas in the final datas compared to the initial DWG file. Actually, it happens to have few missing elements in my transformed data. I've used change detector, matcher, spatial filter, but no successful result. Can FME perfom such control on two data sets to identify missing elements or disparities ?  Thank you.

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 all, I need clarification whether FME supports migration of Smallworld Electric Office data to ESRI Utility Network. Any lead in this aspect will be quite helpful. Please share if any portal is available as reference.

Hi I am looking for the best practice where to save an sde connection file when publishing to FME Server. I am thinking to determine the location of the sde connection file using scripted parameter as below.However when I run the workspace, I get ERROR : Python Exception <KeyError>: 'FME_SHAREDRESOURCE_DATA'Any suggestions? import fmeobjects if FME_MacroValues['FME_SHAREDRESOURCE_DATA']:  # Running on FME Server  return FME_MacroValues['FME_SHAREDRESOURCE_DATA'] + 'connectionFiles/sdefile.sde'else:  #Running on FME Desktop  return '../config/sdefile.sde'

Hello,I'm having difficulty getting the results I want out of the Spatial Relator and AreaOnAreaOverlayer. Essentially, I'm trying to identify overlapping polygons within the same layer, where the overlap area is of a significant size, so that I can separate these out into separate layers in a fan out at the end of the process. I want to do this by creating a field and populating that with a value, where the first / bottom polygon remains in the original layer, but additional overlapping polygons are allocated an increasing number so they can be separated into a new layer - all the '0's, '1's and '2's together. I don't want to identify or attribute what are essentially topology errors (very slight overlaps), as these need to be reviewed and fixed manually, just what are considered 'legal' overlaps so they can be topologically cleaned separately. I have an (incredibly bulky and inefficient) solution, using both SpatialRelator and AreaOnAreaOve

Hello.  I would like to remove (replace with no text) everything what is after dash also with the dash. What I have: test - fmeWhat I want: testCheers, Oliwer

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!

Hello all,I need to read glb-files and run a spatial transformation on it. Every glb shows one floor of a building with all its rooms. On the walls there are textures of photos so it looks like the view inside the room. The exterior walls show the same image as from the inner backside, because the building photos where only taken from inside, not from outside the building.FME can not read glb, so I tested some software to create different formats which FME can handle, like fbx and dae.When I look at the glb, fbx or dae in a 3D-Viewer, I can see the photo projections correctly. But in FME Inspector and after transforming the data to cesium 3D Tiles at exterior walls the inner room images are only shown outside. On the inner side there is the image missing.Is there a way to show the same images at the exterior walls and also at the inner side or change some settings so I can see the images only at the inner side and not outside?I am thankful for any help!Best regards, MiHue

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