Transformers

Hi I am trying to run an SQL to select records in past 10 mins from Oracle I have tried various methods in my sql, but none seem to work select * from table name where updatedtime >= sysdate - interval '10' minute select * from table name where updatedtime >= to_char(sysdate - (10/24/60), 'DD-MON-YYYY HH24:MI:SS') I am thinking of setting a parameter to the required datetime and use it in SQL Server Couple of queries: 1) Is startup script best place to create this parameter 2) Will SQLCreator query work with a parameter e.g. select * from table name where updatedtime >= to_timestamp(fmeparameter, 'DD-MON-YYYY HH24:MI:SS') where fmeparameter ='14-DEC-2018 14:00:00'

I don't see any readers or writers for Mapbox datasets and was wondering how you can manipulate. Trying to manipulate the vector data in the map opposed to the Tiles. Any help would be great, thanks.

I have a mesh example which I'm trying to simplify with the MeshSimplifier. When using certain different Settings I get either a mesh or a rejection message. In the attached example the mesh passes when using 0.5 as the Relative simplification amount. When set to 0.2 I get an invalid mesh. Also when using the result form the MeshSimplifier. Can anyone tell if my mesh is invalid or if this is just FME behaving badly? If it is the mesh does anyone know if there is a way to fix it? Example:

Hi I wanna try to convert building footprint shape file to cesium 3dtiles Building footprint shape file has attribute of Building Floor information Attribute field name is 'GRO_FLO_CO' Check it under image and i need to attach shape to DEM I use 'SurfaceDraper' and Extruder from floor attribute. I want to display different color of 3D building surface according to building floor. I use appearanceStyler and AppearanceSetter but they didn't work. Only AppearanceSetter Work. This is my Workbench <Workbench overview> <AppearanceStyler Setting> <AppearanceSetter Setting> <Result cesium3dtile> - Though i set 3 different condition and color but only one color applied

I'm trying to convert ISO datetime to FME DateTime in 2015 version. Have tried using DateFormatter transformer but gives wrong output. It is strangely displaying Expected datetime+02:00 hrs. It looks like it may work in other versions, but not in 2015. Not sure what the issue is. For ex: The value 2018-12-13T22:05:36.000Z (ISODateTime) gives 2018-12-14 00:05:36 instead of 2018-12-13 22:05:36 Any suggestions please? Thanks in advance. Tagging @takashi, @david_r.

I am converting a kml to shp and trying to calculate the area of the resulting polygons. It seems to run okay, but I don't see the calculated result. The field that should have it is blank in the attribute table in ArcMap. Here is the AreaCalculator transformer: This is Inspector: Is it actually doing the calculation? Where is the result? Thank you..

Hi I am trying to create drive time zones for a data set with 2-5 starting points, much like image #2 here, http://desktop.arcgis.com/en/arcmap/latest/extensions/network-analyst/what-is-network-analyst-.htm. I read https://knowledge.safe.com/articles/30048/creating-time-and-distance-isolines-using-the-netw.html and I managed to create drive time zones for a single starting point: Each zone is 3 minutes of travel. However, I am looking for a solution for using multiple starting points. The idea is to see what happens to drive time when adding or removing points (clinics, in my case). Any suggestions on how to achieve that? Currently, the workspace looks like this: Regards, Magnnus

Result of duplicatefilter unique port is always 5000 features, irrespective of the number of input features. Is there a kind of FME default value of maximum features I have to change/increase?

Hello, We are trying to connect to a Naviline billing system that is used for water billing for the first time that has an IBM DB2 database with an i IBMDA 400 server. I saw this web page that was posted on June 1, 2016. https://knowledge.safe.com/articles/675/creating-an-odbc-connection-to-an-ibm-db2-database.html After reading this I am thinking this is the process to make this connection. The post is a couple of years old. Has anyone tried this process recently? The .exe file mentioned in the article is v9.7fp1_nt32_client.exe. Is this still the case or is there a newer one? Thank you in advance for your consideration. Laura

Hi FMErs Is there a way to extract the bottom-left coordinates from an output geometry using the Tiler transformer? The reason is that I'm tiling/filing a geometry (to CAD format) and would like to use the bottom-left coordinates as file names, like for example "x=12000 - y=3000.dwg". Please let me know if you need me to elaborate or if it is not clear. Many thanks

Hi, I am a fairly new FME user and I don't have a lot of experience with it so I was hoping somebody could help me out. I have two shapefiles and I want to update field values from one table with values from another. The "Line table" had fields From and To Node ID that matches with the "Nodes table" Node ID. I have sorted out all the nodes that have no Z value and I want to update that filed with values from the "Line table" with the condition that the lower value is chosen if From and To Node_ID_Z are different. So for example for Node ID = 3 I would like to have a value 1,8. But I don't know how to properly join these two tables and set this condition. Any suggestions?

Hi FME'ers, I have two network datasets, one for all streets and one for footpaths only. There are instances where the footpath and the streets follow a similar path. This is never exact and they often weave around each other, intersecting each other at multiple points. I need to find a way of identifying sections where the street network and footpaths are similar. The goals is to reconcile their geometries but the decison over which geometry take precedent is not mine to make. I have attached an example. The green is the street network and the turquoise is the footpath. Thanks, David

Hi. I have data in postgres server and I need to fetch the polygons from there. The data is like, Country-State-District-Town-Locality. There are association ids in a separate column for each level. So, one country has one association id. The state has multiple association ids attached to that country id, the district has multiple association ids attached to the state and country... etc. I have extracted(SqlCreator) the data using the list in spatial relator, but not sure how to extract using association ids. Any solutions? Thanks!

If I wanted to hide a transformer so that it couldn't be added to the canvas in an FME workspace, can it be done? I don't want to do anything drastic, just tuck it away so that another transformer would be used instead. Lets say I didn't want anyone to know the 'Reprojector' existed in order to ensure they always used the CSMapReprojector, is there a file I can edit somewhere to 'comment out' the Reprojector...? I've tried editing \\transformers\\fmesuite.fmx to no avail. Many thanks...

Hi, I need help ….. I have an infrastructure-network with points and lines/polylines in 2D and I want to transform it in 3D. For the points I used the transformer „3DForcer“, to assign them „Z_value“ to the z-coordinate, there is no problem. But to transform the lines (add the Z_value), I don’t know how ? Thanks for Your help …..

Good day, I have a list of warnings that I want to write to a database. I am using MSSQQL_JDBC_NONSPATIAL writer to write to our SQL Server database. One of the table attribute is the WarningTimestamp. (I set the type to datetime in the writer.) It is in ISO datetime format. When I want to write the records to the db, I always get an error telling me "MS SQL Server (JDBC) Writer: Error writing feature. Error: Attribute 'WarningTimestamp' does not contain a valid timestamp" even thought the WarningTimestamp is '2018-10-08T00:00:00'. If I use the DateTimeConverter to convert the ISO datetime to FME datetime, the import is working. Why? Please help.

Hi Is there a size limit for the "Search in"-string of the StringSearcher-Transformer? Regards, Tobias

Hi, I have two datasets of line features which I want to check individually for duplicate line features. However, the output containing the duplicate line features of both datasets should be combined in one dataset. I used a Matcher transformer on each dataset. When combining the output I of course get similar match_ids for features, that aren't always matches of each other. How do I adapt my workbench to avoid this? Is there a way to set the match_id attribute of one of the Matcher transformers to start counting at a specified number? I also can't send both datasets to the same transformer, because for my datasets that would result in unwanted matches. a simplied version of the workbench And a simplified version of the generated output

Hi everyone, I have a good question that I tried to achieved but this is very difficult for me. I have circuits in the smallworld database. This circuits have got a simple parent-child relationship. There are many circuits like this but there is no relation first circuit with 3th circuit. If I accept the first circuit is a parent, this parent related downstream circuit mean that its own child circuit. However this parent circuit doesn't have relation with its own child's downstream circuits. I would like to make a relation among from first circuit to end.... I have got circuit_line as shape format and the related internal table as excel in the attached You can consider and start from this parent id 46598749 circuit id =5018-OG-6002 Your browser does not support HTML5 video.

Hello All, When I sort the table view of an inspector in FME Inspector the values go blank and the cell value returns an error. I don't mean "Null" or "<Missing>" values, i mean they're completely blank and it suddenly removes values from every cell in the table. Relative to the image below, Inspector "Combined" is the problematic table. It is the output of combining a geodatabase point feature class with output from a workflow. Inspectors "A" and "B" display and sort fine, it's only when I sort the combined one that I have issues. Any help is appreciated!

The Extruder's error I recently used the Extruder to process the floor plan and expect to be able to stretch it into a 3D building model, but I have encountered many problems. In the process, I used 3dsMax to generate the same model at the same time, and compared it with the model generated by Fme. I used Fme Inspster and VS Code to view the Fbx model and compare them. I got some of the following points and discussed them together. 1, The Location Is Wrong When viewing the model with FME Inspster, the model's position is correct. However, when using VSCode's 3D Viewer for VSCode module for single display, the position of the model is tilted and inconsistent with the position of the origin! I judge that there are two parameters "Geometry Instance Local Origin" and "Geometry Instance Matrix" missing! Because from the Fbx file generated by 3dsMax, both parameters are valued and the location is correct. My question is, why does FME not calculate the attribute values of these two parameters

I am brand new to FME. I have a schema that i need to compare field collected data to to verify that all the attributes are there and are valid data types. Schema: XSLX of field data: Thanks! John

Hi, I have developed a workbench to process some spreadsheet information (as you would). There are no Python callers, system callers or startup/shutdown scripts in the workbench, and never have been. Opens excels, writes excels. At some point this morning it suddenly decided that when it is run, it deletes all files (not folders) within the folder it is being run from, including itself (as it is open I can hit save after it runs). I cannot think of anything that should be causing this unexpected behaviour. Has anyone seen anything like this before? FME 2018.1.0.3 Build 18552 - WIN64 on Windows Server 2008 R2 Enterprise SP1 64bit. Regards John

Hello, I would like to know if there is a syntax in the XML reader “Elements to exclude” option for excluding a node when it has a specific attribute value. For instance I would like to skip reading all nodes "complexAttribute" which have an attributeType equal to "TTOM-Name:Name.Body" such as in this example node: <complexAttribute attributeId="ee823867-532f-4fca-83ad-6dd9f8df7524" attributeType="TTOM-Name:Name.Body"> … </complexAttribute> Such nodes could be present at different levels inside the XML. If these are skipped (because they contribute for a significant part of the XML volume and are not necessary for my process), then it will be easier for me to flatten the XML structure using a series of ListExploders for the remaining nodes. Thanks for your hints! Olivier

Hi, I wish to model railway and road surfaces by draping 2d polygons of their extents over a 3d point cloud and then make the surface completely smooth in order to generate straight contours. The first part is no problem, I have created a workbench that drapes the polygons, but I'm struggling to think of a way to achieve making the surface smooth? The railway surface will be completely flat only sloping up and down length-ways but the roads will likely be at a slight angle. I'm thinking that there isn't a surface transformer that can accomplish this? And perhaps the best way would be to treat the 3d points that are within the polygons somehow? Any suggestions would be greatly appreciated!