Using transformers to modify data.
Recently active
Some of my features are sent to the DateFormatter with empty values in the formatted attribute, but they come out with today's date. Why does this happen, and how do I stop this?
The Mapbox vector tiles (MVT) writer has parameters for minzoom and maxzoom. Is it possible to make the writer read these parameters from an attribute in incoming features? In addition to z0 - z22 , you can also select "Source" in the writer parameters, but there is no documentation on what "Source" means.
I am new to FME. I have a geojson file with an array of features - for example under functionalClass i have 6 different modes of transport and under category I have 5 different types of roads. I want to create a new geojson file but using an existing geopackage (with only the attribute field called roadName as a value) but I need the new geojson file to have the same array of features as the first one. What would be the best way to create this? I have consider the feature readers and writers, JsonTemplater and JsonFormatter. But I am a bit lost on where to start or what transformer is the best to use in this case? Or is there an easy way to extract the arrays in FME so I can build csv files and just map them using an attributemapper transformer? Thank you for your time.
Hello. I have a question. Does anyone know how to check inside the workspac that the workbench has processed all the data at the beginning of the WS? It happened to me several times that during a large WS the workbench looked like it was finished properly, but not all the data was retrieved during the data transformation. I came up with a counter at the beginning and end of the WS, but it's probably not the perfect solution. Another thing is that the counter reads over and over again, if WS is automated, I would need to somehow reset it when it's done. I need something that will be obvious at first glance, the search in the log will take me a long time. Thanks a lot
Hi, I have an MDB file with a SourceID, its SequenceNumber and PositiveResponse as in the below image: SourceID SeqNum PosResI want a new column OUTPUT having the sequence 1,2,3,4,5,... But, the count should start where SeqNum=1 and PosRes=0. So, it would be like- SRCID SEQNR POSRES COUNT 5126350015700451 01 1 5 5126350015700451 02 1 6 5126350015700451 03 1 7 5126350015700451 04 1 8 5126350015700451 01 0 1 5126350015700451 02 0 2 5126350015700451 03 0 3 5126350015700451 04 0 4 I have tried using Sorter, Matcher, StatisticCalculator, Tester but I am not able to collect the output. Thanks in advance.
I have a CAD file that looked to be in local coordinates and I finally found the handy tool 'Local Coordinate System Setter' and I reprojected it into state plane and almost got the CAD drawing in the correct location but it is still off by a bit and not sure what I am missing. I've tried the Affiner tool to get the direction correct since i noticed in the CAD drawing it has _xdir_x and _ydir_y and so on.Adding those directions into the Affiner tool, it rotated at least correctly but not quite in the right location (blue CAD, green GIS):Is there another tool that i need to use to make it align better or at least get the CAD drawing in the exact locations?Thanks!
Below you see what I get when I run the translation. What can I do about it? INCLUDE -- failed to evaluate TCL expression ` if {[string equal -length 15 {FM E_CONDITIONAL} {P:\\82\\8213-0081-000\\22_Uitvoering_geodesie\\40_Dataprocessing\\03_ mapping\\06_DGN2MDB\\GIS-BLOCK-45\\*.dgn} ] == 0} { set encodedVal [ FME_EncodeText {P:\\82\\8213-0081-000\\22_Uitvoering_geodesie\\40_Dataprocessing\\03_ mapping\\06_DGN2MDB\\GIS-BLOCK-45\\*.dgn}]; puts "MACRO IN_DGNV8__FM EENCODED__ $encodedVal" ; } else { set encodedVal {P:\\82\\8213-0081- 000\\22_Uitvoering_geodesie\\40_Dataprocessing\\03_mapping\\06_DGN2MDB\\GIS-BLOCK-45\\ *.dgn}; puts "MACRO IN_DGNV8__FMEENCODED__ $encodedVal" ; }; ' -- invalid command name "FME_EncodeText" while executing "FME_EncodeText {P:\\82\\8213-0081-000\\22_Uitvoering_geodesie\\40_Dataprocessing\\03 _mapping\\06_DGN2MDB\\GIS-BLOCK-45\\*
Hello, I have to add a custom coordinate system that includes a custom datum to FME2013. I know how I can add the custom coordinate system to my file "MyCoordSysDefs.fme". Where can I add the custom datum information and how is the syntax? Can you provide any help? Borone
Is there any fundamental change in the TopologyBuilder v8 (2016), or is is just a cosmetic renaming of the ports from Line and Area to Edge and Face?
I need to find the top/bottom turningpoint of a dataset - as seen on the image below. these are expressed as x,y,z and possible more attributes. Is there another way than python?
Hi,I am using FME 2019.1 and have encountered a strange issue with the Counter transformer.I am getting the below value being returned in the _count attribute for some but not all records. Just prior to the Counter transformer I reversed the orientation of a few records and I have found that for those records which are reversed, I get the below value output, but for those which are not reversed, I get a normal number output. However, when I pass only the reversed records through the counter, I get normal number outputs. It doesn't seem to like the combination of reversed and non-reversed records!@Value(__fme_ft_return_value112f8e69-4aa4-4f5f-9f81-f47c60797f64)Has anyone seen this before?
I have some data that I have run through the statistics transformer in the format shown below i.e. ID, Year, Count I want to create a chart but need to include the years that have a zero value in a five year period i.e. 2015 to 2019. How do I manipulate the data to add in the missing years with a zero value? Any assistance would be greatly appreciated.
I have a scenario where I need to convert the bit depth of a raster from 16 bit to 8 bit, or vice versa, but the type should remain the same. ie Gray16->Gray8, Int16 -> Int8, Red8 -> Red16, etc.Given that the RasterBandInterpretationCoercer does not accept attribute values for the Destination Interpretation Type parameter, is there an alternate method to testFilter for all allowed types, and 14 hardcoded RasterBandInterpretationCoercers?
Hello, I have a digital model in ifc format that I want to convert to CityGML format in FME and then integrate it into a Postgis database. I want the model to keep its characteristics at the end of the process.
Hi all. I have a question. I don't think i've seen this before, but maybe any of you knows what, if at all, i am missing here. I read a set from a oracle spatial. These are all area's. I do a spatial query using lines as supplier. All is well, the inspector shows results as they should be. But when i try to write a polygon shape file, it insists there are a huge number of lines and arcs. A larger number of lines/arcs then the input too. In the inspector i see conflicting information on the objects: As you can see in the picture it relates the area objects with line /arc objects and puts this in a list. On the bottom you see appear SHAPE_Geomtery....this is the supplier geometry. It should not be there as far as i know and have previously experienced. Espescially when there are actually only area's in the selected data. From the objects in this pictures most are therefore rejected. I have never seen this before and i am stumped. (or the dentist hurt me too much yes
Can anyone tell me how to colour the values of height data supplied by the Ordnance Survey in the Terrain 50 data in ASC format. I want to create a gradual increase in colour dependant on the height value in the ASC file. Thanks Andy
Hello all .... I am considering adpoting a different cadastral base to our existing base and will need to spatially move other spatial vector layers (which currently align with the existing cadastre base) to align with the new cadastre. I am hoping FME Desktop can assist. Iwas wondering if anyone can advise or provide what transformers and process I would need to use. Maany thanks in advance
Need some help. We are trying to convert an export tool originally developed in VB6 to VB.NET. Our current version of FME is Desktop 2010 (Build 6210). We are developing in Visual Studio 2008 with the .NET Framework set to v2.0. in which we have a reference to the FMEObjectsDotNet.dll object library. All object library references resolve and the code compiles cleanly. The target CPU is x86. However the following code produces the error shown below. Imports Safe.FMEObjects Dim FMESession as Safe.FMEObjects.IFMEOSession FMESession = FMEObjects.CreateSession() And here's the error: Safe.FMEObjects.FMEOException: Exception of type 'Safe.FMEObjects.FMEOException' was thrown. at Safe.FMEObjects.FMEObjects.CreateSession()
I am transforming a dataset using the RubberSheeter, but it is having no effect on the Observed data. The control dataset is 11,600 polylines, in a shapefile, and are an average of 1,150,000 feet long. I have successfully used this transformer before, but the control geometries have been much shorter in length. Distance Exponent: 2.0Max Distance: 0Max Number of Influencing Vectors: 0No constraints. The Control and Observed are the same coordinate systems.The features exiting from the Corrected port are exactly the same as the original source and I cannot figure out what the issue is. Any help appreciated.
Hi all, I am generating a workspace for a client. A requirement is that output data should be in EPSG:29902. The writers have been defined to use 29902 as the output coordinate system. However, when I open the datasets in QGIS or Arc, the data is reporting as coordinate system EPSG:29903. Is there a way to correct this behaviour? Attached is a simple workbench with a creator transformer and a writer set to use 29902. But the output generated is 29903. Many thanks
Is their any way to write to a noSQL cassandra database.
Could I convert open street map to dgn file with the same color as maps .I would like to extract only one polygon from OSM to dgn file with the same color as map .How could I achieve that ?Fme 2018 Thanks in advance
I am clipping a raster and then running RasterStatisticsCalculator. The results are completely wrong to what I get in ESRI using zonal statistics and the only stat that is correct is the max value.FME Results: When I export the raster and bring it into ESRI, cell values are different and zonal stats are different Zonal stats results from ESRI: I would appreciate some help in how best to run zonal stats in FME. Thanks,K
Sort of following on from my previous question about Overlapping Polygons .... (AreonAreaOverlayer) I'm going to be wanting to look at ways of analysing the data based on the accumulated attributes of these polygons. Each Polygon has an assigned Intensity Value. Where these polygons overlap then there will be an accumulated Intensity Value. I'm wanting to represent these Intensity Values in some meaningful way, and thought that a Hotspot/ Density analysis might be a good way to do so. That is, to create a cluster around areas of a similar intensity valueand have a gradient/ contour map showing these Intensities. There seem to be some transformers which would work on point datasets, but can this be done on a polygonal dataset too ?. Would using a Convex/ Concave Hull around polygons of a similar Intensity Value be a valid way of achieving this ? Thanks in advance, Bruce
Hi.I just tried (in 2018.1 x64) to add a Separator to the Page Content list. When I tried to move the Separator to the top of the page content list, both my previous Header and List items lost their settings.I also tried to put the Header and List to the bottom instead, but that resulted in much the same rresult.It looks like the settings aren't following the rearranged items.This looks very much like a bug to me.Cheers.