Using transformers to modify data.
Recently active
Out of the blue, I've started getting the below error message with my workspaces running on flow which talk to SharePoint: FME Flow error logI did some of my own digging, and found this community post:where the user had a similar issue. I have uninstalled my sharepoint package (1.1.6) and downgraded a version but it still doesnt work. I also upgraded it to 1.1.7 for good measure and that also didn’t fix the issue. I am not downloading these packages directly off of hub because my install is on a remote server, so i have to copy the packages across before installing. I know partial installs can occur doing it like this, but error came out of the blue and I’m not sure why. There was an OS upgrade on the remote server prior to this, but if something was inadvertently deleted, I would have thought that reinstalling the package would restore what was missing. FME Server 2022.2.5Build 22795 - win64 Thanks :)
Hi,I am working with CityGML data and using FME to process and transform buildings from a 3DCityDB into CityGML output. I know I can use the 3DCityDBImporter/Exporter for this but I would like to create a custom FME script for more control.I am trying to transform attributes from the 3DCityDB into a format suitable for CityGML output, specifically list attributes like citygml_function{}, citygml_function{}.codeSpace and citygml_usage{}, citygml_usage{}.codeSpace. These attributes are stored as strings with values separated by --/\--, and the corresponding URLs (codeSpace) are also in a similar delimited format.I attatch one building with these attributes in csv format as an example.The end result should be like this feature (building):Have anyone done something similar as this? Im not very used to working with lists. Would appreciate the help, thanks in advance!
Hi, I am trying to edit the workbench from https://fme.safe.com/blog/2016/05/point-cloud-power/ so it splits the polygon into the number of parts or area I provide. I cannot figure out how to change the PointCloudCoercer to allow me to do so
Hi there, I have a shapefile with real estates that enclose several buildings. I want each polygon in the real estate layer to inherit the attribute entries for the buildings that lie inside each real estate polygon. Some of these entries will be the same, but I want all unique entries for buildings within the same polygon to be written to the same entry. For example. Three buildings lie within one real estate with attribute entries “Residence” “Grocery store” and “Recidence”. I want these attributes entries to be concatenated into a single attribute entry, separated with comma, in the real estate layer, but with duplicate entries removed. So, the final attribute entry should be “Resicence, Grocery store” for the real estate polygon. Is there any way to achieve this in FME?
Hi All! Just a hopefully quick question: I want to write data to ArcGIS Online, and i want to do it dynamically, but it isnt really working out, here are my settings: I want to dynamically write data to ArcGIS Online, but i get this error message: Can someone tell what im doing wrong? Thanks in advance!
Hello, my previous post was not well Described apparently, i need to split .las just like that. please if you suggest any workflow do describe it a little more than just the name of transformer as that is usless for me (i dont really know how to use FME)
Hi All, I’m trying to dissolve thousands of polygons from different feature classes into a single shape in FME. The idea is to obtain a single external boundary after merging/dissolving all the polygons. The current dissolve transformer gives me an error while trying to dissolve the polygons.Parameters in the dissolver are set to default.Is there any ‘hard dissolver’ option to merge the following? Thanks :)
Hello to all,I need to add a missing property into an existing Pset. I tried the workbench shown by Liz in the post “Updating IFC example” but it doesn’t work in my case. Before testing with an Excel sheet contaning GUID and properties to add, I just test to add manually a single property:First, I created 2 attributes:Then I used the GeometryPropertySetter:With the XQuery:I find my previous properties in the “Proprietes” Pset, but I don’t have the new one “TypeVitrage”. Did I forget something or do I have to use “IfcPropertySetDefinitionCreator” ? Thank in advanceBest regardsBruno
I want to pull Google BigQuery data in FME and write as shapefile. Can somebody help me on how to do that?
Hello community!I am working on an analysis to calculate the percentage of incline or decline from railway level crossings. This means the incline or decline along the road that crosses the railway.The desired result is six percentage values. Three for each side of the track (viewed in increasing kilometer (M-value)). The three intervals are 0-4.5 meter, 4.5-8 meter and 8-18 meter, measured from the outer edge of the railway track.It is desirable that the length is measured along the road.Decline from the level crossing should be shown as a negative percentage value, and incline as a positive percentage value. Based on the client's wishes, I have divided the analysis into smaller tasks:Add a property that shows whether the road lines are on the right or left side of the railway, viewed in increasing kilometer (M-value). I have tested the LeftRightSpatialCalculator, but for some unknown reason it always gives me the same side on both sides. I see that TopologyBuilder is mentioned in the
One feature has 40 vertices and the other 41, but ChangeDetector using “Lenient Geometry Matching” option says they are the same. It's right?
Hi,I have a shape with polynones. I want to select 30% of the polygons at random. Is that possible?
Hi community! I've been trying to formulate an efficient workspace that would:Extract feature service URLs from an excel sheet (many have the item ID number at the end)Download the GIS data from each feature serviceTransform the idea with typical cleaning upWrite out to a file GDB on a local server drive For steps 1 and 2, I've been experimenting with HTTPCaller and FeatureReader but haven't yielded a successful extraction yet. I think 3 and 4 will be straightforward, but if there any any suggestions (specifically with getting from 1 to 2) welcomed, and appreciate any feedback in advance!
I want to loop through the list ‘attribute’ in a PythonCaller and change some values, but I get an error. Line 34 is the for-loop. File "<string>", line 34, in inputPython Exception <TypeError>: 'NoneType' object is not iterable Can you see the error? def input(self, feature: fmeobjects.FMEFeature): feat = feature.getAttribute("attribute{}.attribute") for obj in feat: if "fme_varchar" in obj.fme_data_type:
Hey all,So I upgraded FME Desktop to 2024.1 (through ArcGIS Pro installation) and opened up an exisitng workspace I had created in a previous version. When it opens I get the message stating:Transformers are used that are not installed: 'CenterlineReplacer (version 6)'https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Transformers/centerlinereplacer.htmWhy is this happening? I have no option to upgrade the existing transformer and it disappears from my workbench and when I try to search to add another ‘CenterlineReplace’ transformer, it is missing from the list.I have ran a repair on the installation but it is still missing.
Hello Safers! Please, is there any way how to read file information about excel document?And if there are defined footer of pages, is there any change toread value of footer?Thank You so much!Lubo
I need to write an existing feature class to a new feature class (with some modifications) in an Esri SDE database and require that the attachments to be included and properly linked. When I write out to the new feature class, none of the attachments appear to be persisted in the __ATTACH table. What do I need to do so that the new feature class retains the attachments?
I have a workspace that I am using a JMSReceiver to receive JSON files from ActiveMQ. I am then using a JSONFlatterner to parse out the JSON fields. When I write the output to an email the attributes get sent to the email body as expected. But when I try writing the same output to a geodatabase feature class or a text file the attributes do not write. In the case of the text file the variables are identical to the variables for the email body - works for the email but not the text file. Am I missing a step that is causing the output not to be written to the text file or geodatabase?@Value(P_LINK_ANNTENUATION)@Value(P_LINK_ANTENNA_AZIMUTH)@Value(P_LINK_ANTENNA_HEIGHT)@Value(P_LINK_ANTENNA_TYPE)@Value(RTU)@Value(SCADA_DB_RTU_ID)
Hello everyone.I have a bug in a process that reads a NetCDF file and makes a Crop using a clipper transformer and then compare the result file with the original file using QGIS, compare point to point and some values coincide but others, in the file result file do not coincide, it has a negative value and the difference between that value and the original file for the same point is a constant, for example in the result file the value is -0.588 and in the original file it is 0.436, the difference is 0.436- (-0.588) = 1,024.The clipper parameters are like thisIf someone has had this problem and can help meThanks in advance
Hi folks,I have multiple images I need to extract blob data for. When I input my individual feature types into the Raster Extractor (eg. 32 JPEGs, as shown in image below) the raster extractor seems to duplicate the first image for all of the feature types, so I end up with a blob of the first image for all of my individual feature types:This results in the first image duplicated, as a blob, for all 32 features - when I require a unique blob value for each input feature. The only workaround I’ve found is to have a raster extractor for each feature type, which is not suitable.Any help is greatly appreciated. Kind regards, Aaron
I have successfully POST Authenticate using postman. But have no luck using HTTPCaller? Any idea please?
I am using a python Caller to determine if a value is in a range of two other values which are read from a csv file.For Example: Is SearchValue LMH_HNR_Z in the range of value PTOa and value PTOb? If yes, set the variable Fall = B3, if not set it to B3f.LMH_HNR_Z = 5, PTOa = 1, PTOb = 10 should return: Fall=3B, LMH_HNR_Z = 11, PTOa=1, PTOb=10 should return: Fall=3Bf The Code in this picture is part of a bigger function where I discovered the problem but I narrowed the problematic part down to this. The row where the problem happens is this:if (min(PTOa, PTOb) <= LMH_HNR_Z <= max(PTOa, PTOb)):What happens is, that this request randomly returns false even if the search value LMH_HNR_Z is in the range of PTOa and PTOb. The output of some tested values and ranges is also visible in the lower part of this post. I can’t really see a pattern there, maybe one of you?Is someone aware of a bug that causes this behavior? I am using FME Data Interoperability, FME(R) 2022.2.1.0 (20221202 -
A while back I was informed that I needed to update the feature type name of a GPKG that I created with FME.Instead of generating the complete dataset again, I wanted to use a dynamic reader/writer to update just one of the feature type names, and leave the rest intact. However, upon doing so, I got the feedback from our 'data broker' that the GPKG no longer met the geometry requirement (should be single geometries). When I investigated a bit further, it seems to me that a dynamic GPKG writer assumes multi geometry (in my case multi point), in case the writer is configured to use the Geometry 'From Schema Definition' (fme_point). Ok, I can get my head around that.However, when I then manually set the geometry in the dynamic writer to 'geopackage_point' or 'geopackage_multipoint', the geometry_type_name in the underlying SQLite DB (GPKG is based on this), returns 'GEOMETRY' (I think tied to 'geopackage_geometry'). In this case I believe &
For my process, I use pythonCaller and I have a JSON-type attribute. However, since the setAttribute function doesn’t recognize the JSON type, I have to use json.dumps() to convert the JSON into a string. I then connect a featureWriter to the output of pythonCaller to write the result in JSON format. However, I don’t understand why the featureWriter reformats the JSON on input. How can I have a correct json formatHere is an example of the file from featureWriter [ { "result_json" : "[{\"millesime\": [{\"2022\": {\"echelles\": {\"Y\": {\"max\": \"20.39\", \"min\": \"18.11\"}, \"X\": {\"max\": 461.0, \"min\": 0}}, \"resultats\": [{\"distance\": 0, \"pixel_value\": \"20.39\"}, {\"distance\": 425.0, \"pixel_value\": \"19.76\"}, {\"distance\": 265.0, \"pixel_value\": \"19.4\"}, {\"distance\": 461.0, \"pixel_value\": \"18.11\"}]}}, {\"2023\": {\"echelles\": {\"Y\": {\"max\": \"2039\", \"min\": \"1811\"}, \"X\": {\"max\": 461.0, \"min\": 0}}, \"resultats\": [{\"distance\": 0, \"pixel_value\"
We have merged Ascii grid and then classified the Raster using “RasterExpressionEvaluator” the Interpretation is set to UINT8 The color values have been assigned defining the interpretation of the palette as RGB24 using an AttributeCreator and then adding the color values to the RasterPaletteAdder. Export in Geotif format is possible. The Tif is transparent between the classified raster cells via the Nodata value.For performance reasons, we want to use a jpeg2000 and control the transparency via an alpha band as the jpeg2000 format does not support nodata values.How can we export the classified raster image in jpeg2000 with an alpha band?Thank you very much for your help in advance.