Using transformers to modify data.
Recently active
I have a 3D meshes of buildings in a Rhino file that can be exported as a .obj or .fbx and want to use the fanout expression to put each building into an individual file/folder. The exported file (both .obj and .fbx) dont have any attributes and is read as one cohesive mesh so I am unable to assign any attributes to them to split up. How would I go about this workflow?
In the attributemanager, I declare the igds_model_name which is an atttribute for the model name and is determined by feature_type. Therefore in theory every feature should be written to their respective model. I also declared the model names in the seed file of the dgn, but for some reason the specific features are not written to their respective model. I was wondering whether it's possible to write features to different models in a dgn file and how one is able to do that.
Hi,No data area of geotiff generated from 'HillShader' can't be shown as transparent in ArcGIS. If it's shown as RGB it contains ALPHA band, but if I choose 'stretched' in symbology, Alpha band is missing, nodata has been shown as black?Anybody knows how to show nodata as transparent in ArcGIS if the hillshade output generated by FME?
I have a simple workspace to generate some web tiles. I first used WebMapTileClipper to break the data into vector tiles. I next ran each vtile through MapnikRaster and grouped by _tile_column & _tile_row. I next sent each raster to WebMapTiler. See my attached workspace image. It seems that WebMapTileClipper and WebMapTiler do not agree on column and row. WebMapTiler generates an extra tile for many of the same tile coordinates. In my attached example you can see that MapnikRaster generated 1 image for _tile_column: 978 and _tile_row: 1655 however WebMapTiler generated 2 tiles. Any advice would be greatly appreciated. Richard Carmel
I have some date with id-blocks, meaning there is a column where one and the same object is represented of several features, with different attribute values, but always with the same id for these features.How many features there are per object varies.I was thinking to build some 'decision-tree' in an AttributeManager to find the correct features of such an id-block to process further. Unfortunately, the AttributeManager is not a group-by transformer and I was wondering how can I group my data by id, and process the resulting group, before the next group is created and processed.
I'm having an error I have not been able to fix when attempting to read/write an annotation feature class from one SDE geodatabase to another. When writing the annotation feature class using INSERT and TRUNCATE in the writer, I get the following error: Invalid geometry type received for an annotation feature. Please split multi-part annotations using the SPLIT_MULTI_PART_ANNOS keyword on the reader to 'yes', or switch to classic geometry mode before attempting to write them to a GeodatabaseBoth annotation feature classes have been updated to an ArcGIS Pro 3.0 version, and they have matching schemas. I've made sure to "clean" the geometry in ArcGIS Pro (no geometry issues were found) but no luck. I'm using FME 2022.0.0.2 (Build 22343 - WIN64). I also followed the suggestion and changed the SPLIT_MULTI_PART_ANNOS keyword to 'yes'. Not sure what "switch to classic geometry mode" means... I'm able to read/write older versions (i.e. ArcGIS Desktop) of annotation feature classes w/o issue wi
I have a lot of ZGF files to convert to shapefile format. I tryed to use FME to do it, but it seems that some mistake is happen while the imput file is been reading, that cause the lost of Coordinate System. It seems thta the software used the plot coordinate instead of original file coordinate. The ZGF units was identified as 0.
I have tried all the ways I could think of to do this but cannot find anything on how to change a text field to an integer field like in ArcGIS Pro. Please help! This is what I have tried: @int(USER_Price)@int(@replace(@replace(USER_Price, "$", ""), ",", "")) I have also tried @Trim which produced a 3 digit result.
Hello.i have simple workflow to update Access MDB content.it starts with SQL creator to define the queries and end up with SQL Executor to write down all the attribute manipulations and the end.Works fine in workbench as it updates existing MDB file and therefore there is no Writer placed at the end. Im seeking an advice how to update this to be able to publish it to FME cloud so the Cloud returns the updated MDB file.as this MDB file is uploaded at the beginning, it still exists and being updated somewhere in the temp folder of the FME Cloud so it should be easy just to request it with some transformer at the end and provide it as a result. can you advice me what transformer can do it for me?
I am trying to simply export results with a Writer into a .shp. If I do not use a GeometryValidator most of the features are present in the final attribute table, but not shown in a ArcGIS map. If I use the GeometryValidator and then use both the good and the repaired features as inputs for the Writer, some results are missing from the final attribute table, but all the result in said table are also displayed in an ArcGIS map. The log gives following warning "Dropping heterogeneous aggregate feature for the SHAPEFILE Writer, due to feature type allowed geometries restriction". How do I solve this? Thank you!
Hello,in the past it was possible to set the options to no and still choose a template. Is there a workaround here? Why is that no longer possible? I would like to use a template and every time the workflow writes that this is done to the same file and not all spreadsheets are removed.
Hi guys, I tried using IDENTITY_INSERT on several tables of single SQL Server Non-Spatial writer. There is a error I'm getting that says I cann't do that. I now for the rule that SET IDENTITY INSERT can only be used on a single table per connectio, but I wonder if there is some way to make my 4 tables use this feature with a single writer? These tables aren't beeing populated at same time, so can I do something with SQLExecutor for example or no?
I found that after using the Hyper File Writer, that I had no way to open the file and view it in FME, and could only use Tableau to open the file to see the data there. I could not find a Reader for Hyper Files as well.
I am using user parameters to direct the input and output of a workspace app.the user parameter is a choice configuration with allow choice edit enabled. This does allow the user to type or paste the value required in. I have the allow edit enabled to the parameter.It would be nice though if the checkbox allowed actually ADD(appending) the new value to the parameter list and not just to run the workspace with the new value and then lose it. (edit: I am not sure why but previously the app would not allow me to change or edit the value but now i am able to do that so i assume that was user error)
I have two tables. One with input data the other with unique high/low lookup ranges to categorize the input data. The lookup ranges and input data are numeric values. How can I append the associated data in the lookup ranges table to the input data based on where it falls between the min/max values? I considered AttributeRangeMapper but that will not allow comparison between two tables. Thank you, Gil
To populate in an automated way the json templater what I would to do is to add the string stored in 2 attributes that I created in the table of my source.The first one is to create the list of attribute name and the second one to run the command in Json templater to add the value of the same attributes present in the source. ( see picture)something like:{ "id":fme:get-attribute("id"), "@ns:com:here:customer:$(CustomerName)": { "objectidOriginal": fme:get-attribute("objectidOriginal"), "toaddr_l": fme:get-attribute("toaddr_l"), "toaddr_r": fme:get-attribute("toaddr_r"), .............................. .............................. .............................. "filegdb_type": fme:get-attribute("filegdb_type")} I created this ROOT:{ "id"
I force the autocad_text_size = @Evaluate(@Value(autocad_text_size) / 100), autocad_box_height = @Evaluate(@Value(autocad_box_height, and autocad_box_width = @Evaluate(@Value(autocad_box_width) / 100). When viewing the Attribute Creator transformer value they look correct but when I open AutoCAD DWG file the text is still at the original height.I try using TextAdder and DWG styler but nothing seem to work. Can someone show me what I am doing incorrectly in my workspace?
Hello,I have seen this post concerning the customization of the FME Server Web Interface:https://knowledge.safe.com/content/idea/42274/customize-the-fme-server-web-user-interface.htmlIn 2018.1: is there a workaround for changing the color of the "FME Server menu"? Can we modify a css file? Or ??Thank you
Hi All,I'm trying to create and write dynamic attribute name with the joined workspace. In a FFS file, I have C-SEGMT entities. I would like to count how any entities I have until the current year (e.g. 2023) but also for the two previous years (e.g. 2022 and 2021) and put the result in a dynamic attribute name (for my example, three attributes named "NumEntities__2023", "NumEntities__2022" and "NumEntities__2021" I can create them, as you can see it in my Workbench and the screen capture, but I don't know how to write them in my Writer. It's OK for a FFS Writer, but if I want to write in a GEOJson file or other formats, it fails. I could name them directly "NumEntities__2023", "NumEntities__2022", "NumEntities__2021" ; or I could expose them with AttributeExposer : I can see their name if I have enabled feature caching. But my goal is, if I run the workbench next year, the attributes will be automatically renamed
I need to read multiple geodatabases from url, where some geodatabases are at the root folder, and some in subfolders.I tried to follow the article here, but already the initial schema reader fails. I set the source to https://arealdata-api.miljoeportal.dk/download/**/*.gdb. The error message I get is: Unable to connect to the File Geodatabase at 'HTTPS:\\arealdata-api.miljoeportal.dk\\download\\**'. Make sure the correct filename was specified, and that the Geodatabase wasn't saved with a newer version of ArcGIS than the one installed locally. The error number from ArcObjects is: '-1'. The error message from ArcObjects is: {}
I use FME for updating several things in AutoCAD drawings (dwg) and writing out to new drawings using acad reader and writer. At present, when the new drawing is completed, the autocad_entity_handle is different on each object in the new drawing. Is there any way to preserve the original autocad_entity_handle from the original drawing in the new drawing?Thanks!
We need this to be able to post the attribute to an API which requires one of the other File Structure types than the default
Hi, I made a workspace to create INSPIRE datasets. When checking whether the created INSPIRE GML is valid, I wanted to add an XML Schema Validation step into the process. When doing so however, I noticed that in FME's XMLValidator I get two Validation Errors;no declaration found for element 'so:soilProfileObservation'element 'so:soilProfileObservation' is not allowed for content model '(metaDataProperty*,description?,descriptionReference?,identifier?,name*,boundedBy?,location?,inspireId?,localIdentifier?,WRBSoilName,otherSoilName*,validFrom,validTo?,beginLifespanVersion,endLifespanVersion?,isDescribedBy+,location)' See also below screenshot;If I however validate the GML using either (the XMLTools plugin) of Notepad++, or INSPIRE's validator, the GML does validate. Does anyone know what causes these validation errors of FME's XMLValidator? If I check the second (unique) error that, i.e. that the element soilProfileObservation is not allowed in the c
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.