Using transformers to modify data.
Recently active
Hi there, I am looking for a transformer or a solution that allows me to check if any attribute of a feature has a specific value (e.g. string "remove"). Only then I want to remove the attribute. Renaming would work as well. Thanks for your help.
I'm trying to calculate the percentage of nodata cells within a raster by using the point cloud combiner + point cloud splitter in fme to extract the value of cells with data vs cells with nodata, and get a ratio. It's clearly not the right approach as it is taking forever. Is there a better way to do this? Usually it would be fore raster tiles with 1,000,000 cells. Counting the nbr of nodata cells in each file basically
Hello , I have a feature geometry with two parts (IFMEMultiArea with two IFMEPolygons). Using PythonCaller transformation, I want process line segments in various parts of the geometry.Is there an API for getting the coordinates of any part of geometry?I am able to get the part count as follows: partsCount = feature.numParts(True,True) I can get the parts as follows: areaPart = feature.getGeometry().getPartAt(0) But I could not find a suitable API for getting coordinates of a particular part in the API documentation. Thanks in advance. Regards,Byju
Add color to Point Cloud, hello dear community, i have a point cloud in a .xyz format, only with coordinates. I would like to add sth. like a color or a height ramp, which depends on the height of each value and gives each point an unique RGB value.
I have checked with other values and 2.1234567 is fine and so is 2.8888888 and 0.1234567. this issue only happens with whole numbers
Hi,I have been playing around with FME Desktop for a great while now and I think it's definitely capable, however, my knowledge lacks a bit here. I am trying to convert an OSM XML (Luxembourg for example, but not limited to) into a couple of information levels:level 0point (equals nodes)xyz id (equal to node id)node id/indexFace idline (equals edges)xyz idedge id/indexfrom node idto node idleft face idright face idpolygon (equals faces)face id/indexedges{}.edge_idedges{}.orient (boolean value of all_edges{edge_id}.fknot > all_edges{edge_id}.tknot)level 1point (equals nodes)point id (this correlates with the level_0 point id of this point)desc id (type parameter, maps to an array of strings)feature code (an integer, which maps to an array of strings)attributes{}.segmented_attr_idnodes{}.node_id (all the level_0_points that are connected to this point)line (equals edges)line id (correlates with level_0_line id of this line)desc id (type parameter, maps to an array of strings)featu
I need help with translating a shape file into SmallWorld. I am having problems finding any info on the subject. Was hoping to get some example code so I can move forward . I usually translate from Smallworld to MicroStation
Hello, I'm looking to generate a number of lines from coordinate data within a spreadsheet, each with distinct start/end points, but grouped by a common attribute. Each of the points are ordered numerically (and geographically). Using LineBuilder seems connects all points in a line to eachother, rather than creating one line sequentially. The image attached shows how the relevant data is organised, so with this data I'd need 3 lines, one each for group A, B, and C, with each line each starting at point 1 and ending at point 5. Thanks for any help!
I'm manipulating an IFC file, writing it back to IFC with a few changes. So far I couldn't figure out how to write a Material Layer Set. I can see it is defined in the geometry traits of my original IFC file but when I write it back out it seems to remove the information. Has anyone done this?Geometry traits on original IFC:Original data:IFC file translated with FME:
I'm writing data to a hosted ArcGIS Online feature Service, one field is of type string but I sometimes writes an integer to it. When I do that the number is converted to decimal. So 25 becomes 25.0.Has anyone solved this (without adding a space at the end)?
Is there a Transformer that lets you download OSM/Openstreetmap Address points for a country?
We are using FME Desktop 2022.0 Beta and have created many workbenches for nightly data processing. I want to run these in varying sequences using python but cannot get fmeobjects to load. We are running Python 3.7.11 64-bit (arcgispro-py3:conda) installed with ArcGIS Pro on a windows machine. The following code fails on import fmeobjects: ImportError: DLL load failed: The specified module could not be found.import syssys.path.append(r"C:\Program Files\FME\fmeobjects\python37") import fmeobjectsI see many posts pertaining to this issue but none of the recommend approaches work. I have also tried adding the path above to my PYTHONPATH with the same results. Input?
ContextI am building a custom transformer. I need to transform input features into points to process them and then build back the features geometry before to output them. Output features are expected to have the same geometry type as input ones. ProblemI thought I could just reconstruct the geometry of the features using the LineBuilder transformer, but it creates polygons with closed lines, even when the input feature is a line (fme_line), not a polygon. QuestionHow can I reset the features geometry to their original ones before sending the features to the output port? The GeometryCoercer could do the job if I could set the output geometry at runtime (e.g. using an attribute with original fme_geometry value).
I have imported data, from a shapefile, into an existing object in Smallworld before but we recently acquired a smaller Telco and will be importing their data into ours. I have a reader (shapefile) transforming into an existing object in our Smallworld writer. In the type_ field of the shapefile there is data that matches what the spec_id should be in the SW object, and the spec_id field is an enumerated (integer-string) list. I have changed the data on the shapefile side to match what the spec should be, both integer wise and string wise. I'm still getting the Translator Error: Value "x" not in enumerator set. I've tried to run just a basic import without setting the spec_id field from the shapefile and I get specification is mandatory error in the magik prompt box on the SW FME session. I'm sure this is a user based error, but have tried this on multiple objects and still running into the spec_id issue. Thanks for any help.
I am using a featurewriter to overwrite 2 feature classes in a file geodatabase. The attribute definition panel shows the correct GlobalID and guid types. However, the result is string fields. Any ideas?
This has been asked before, at least here and here. The problem is best described in the picture, with the starting point on top and desired outcome below. The data is huge, so manual attribute creation is not an option, the attributes should be generated like "Year@Value(number)" and "Explanation@Value(number)"I have tried the method used in these, with AttributeCreator with every option I can imagine, but to no avail. I've used it in conjunction with AttributeExposer, but without any good outcome. Dear all, is there a solution to this?
Hello, here is my question. I have two table. The first table is like a glossary. The second table is the input data.Table 1 (glossary)Number Fruit1-1 banana;apple <= (meaning can be either banana or apple)1-2 orangeTable 2 (Input data)Number Fruit1-1 banana1-1 appleSo my goal is to see if table 2 match with table 1. I have a input data (table 2). Both are number 1-1 and the fruit name also match with table 1. Hence, both the result should be passed. However, I am not sure how to do the matching. As the table 1 fruit name is "banana;apple", separating by ";". I would like to have some guidance. Thank you very much!
Hello friends,Im a new user of FME. I have a dgn file with hundreds of points with or without tags. i need to convert this dgn to shp with unique custom ids. Is it any procedure or transformers to do this in fme. I mean each point have unique id numbers I tried with many videos and tutorials didn't solve my issue thanks
Hi, I'm looking to update a value of an existing JSON structure once it has already been constructed.I feel I'm using JSONUpdater for its correct purpose, but might be messing up the syntax. Attached is how it looks for me:Does this appear to be the correct syntax for trying to modifying a nested key/value pair?I also wonder if using the attribute "ProgramProfile" for the JSON Text field would be a better approach, as it does show up in the list of selectable attributes. I have not had luck with this approach either though. JSON sample being used:{ "UserInfoList" : [ { "IntegrationUserID" : "123456789", "UserProfile" : { "FirstName" : "Johnny" }, "ProgramProfile" : { "UserCategoryName" : "PLACEHOLDER" }, "AddressProfileList" : [ { "CountryName" : "Japan" } ] } ]}
Hi, I'm fairly new to FME. I'm curently trying to set up a workbench that reads data from multiple sources and merges it. However, I have to be able to work repeatly within a specific extent which is provided with a shapefile (see pic below). For now, I just wan to manually input a shapefile with one feature ( hopefully I manage to find a way to loop the procedure with many features but that might be for another question). Right now, I can't seem to be able to pass the extent coordinate (which I get from a BoundsExtractor) to the search envelop of a FeatureReader. This post (https://community.safe.com/s/question/0D54Q000080hXiFSAU/assign-bounding-extents-to-reader-search-envelope) talks about using spatialFilter after the Feature Reader but that means I have to read ALL the data and then filter it (which I don't find very optimal). Has anyone have an idea on how I can go around this?Kind regards,Anne-Marie
Hello all,Since updating to FME 2020 (FME(R) 2020.0.1.0 (20200407 - Build 20218 - linux-x64)) the columns filter in the data inspector table view does not work most of the time.When clicking on the "Columns" button then selecting some columns to display, on clicking "ok" the columns displayed in the table view are filtered to what appears to be a random set of columns. eg. After selecting the following in the column selector: Clicking ok results in the following columns being displayed in the table view: As can be seen, they are not the same columns. This happens most of the time, though it does occasionally work correctly. I do not know what is different when it does work. This happens when Data Inspector is opened standalone and also in the Table View in the Visual Preview in Workbench. This is also occurring in the Windows version of 2020 (FME(R) 2020.0.1.0 (20200407 - Build 20218 - WIN64)). It did not occur when we were using 2019.Does anyone know what is caus
Hello, I'm using a WMS Reader to convert the wms to mbtiles. The workbench is called repeatedly for all my polygons (Bounding Box) with "FMEServerJobSubmitter" from a second workbench. The first conversions run succesfully but after a few iterations the process stops with the error: HTTP/FTP transfer error: 'SSL connect error' Please ensure that your network connection is properly set up |No proxy settings have been entered. If you require a proxy to access external URLs, please ensure the appropriate information has been entered The error occurs only in FME Server, in FME Desktop 2017.1 I do not have this problem.
I'm using the EsriReprojector with source RD_New to destination GCS_WGS_1984 and geographic Transformation Amersfoort_To_WGS_1984_NTv2. Later I need my features to go back to RD New so I use the EsriReprojector again with the source and destination switched and the geographic transformation direction set to Reverse. But this gives me a different coordinate system: _Netherlands-RDNew-2008_0 instead of Netherlands-RDNew-2008 (what it used to be). Why is this a problem? Everything is projected with an offset of 100m. When using geographic transformation Amersfoort_To_WGS_1984_2008_MB in reverse it seems to be fixed. Yet it still gives me the new coordinate system _Netherlands-RDNew-2008_0 Why, how, and will this give me problems when overwriting layers with Netherlands-RDNew-2008? Any dutchies with the same question?
Hello friends, I’m new to FME. I have two dgn files for roads. One file for the central line of roads with all tag details. The other one is a new file, filled roads (create as region in microstation) based on the center line file. I would like to combine these two files and the output should be only one shp file. Not required the center line on the final shp. All tags should be as attributes in shp. Only the tags to copy from centerlinefile to new file which is falling on the top of the filled shapes. (like spatial join in GIS) Using Products : Microstaion SS4, FME Trial Thank you Chithra
Hello FME-Users,I have a problem with my CityGML Data. I want the final results to look like clean OBJ Files. When I load them into e.g. 3Ds Max they should have no errors. I also do not want faces to be seen in my 3D software. Instead I would like to see proper polygons (if quads are possible, I want to see them; they can be made out of triangles, but these triangles should be hidden).I found this image on Wikipedia showing the different possible Elements of a mesh: My current FME workflow looks like this: I have buildings made out of 3 elements: Groundsurface, Wallsurface and Roofsurface. I would like to bring all of these together as a mesh (with polygons). I used the GeometryCoercer to convert the rawdata into polygons. The MeshBuilder is used to create a mesh. Here I think my polygons were converted into surfaces... Below I also provide you with my settings from the Deaggregator and the Coerser. In 3Ds Max the buildings look like that:this looks really faulty... The files are