Using transformers to modify data.
Recently active
HiI am having an excel sheet like below. I need to group them in Field name route and assign a value for route field .let's say (routeNo) or any other unique value.the grouping is based on finding a value that is considerable above of other previous records below is 48. which is very big than other previous ones.Any help is highly considered. Route 1Route 2
Hi,I have two Oracle tables: POINTS_TABLE and LINES_TABLE. I’m trying to export both tables to DGN. I’m using “Bentley MicroStation Desing (V8)” writer. In writer parameters, I filled out “Cell library file”, and now I’m trying to do something to fill “CellName”. How should I do it, to have different “CellName” value for POINTS_TABLE and for LINES_TABLE in my output dgn file?
My user on the production MS SQL database has an ampersand (&) in their password and FME can't login with it.Is there any workaround for this without having to change the password ?This happens in both FME Desktop and Server.Edit @TiaAtSafe:The password also contains this special characters $&@=Versions:FME Server 2017.1.1.1FME Desktop 2017.0.1.1 (20170512 Build 17291 WIN64)
Hi! I have tried searching for an answer to this problem with no luck, so i thought i’d try making my first post in this forum!I am working with a polygon layer containing cities. I want to dissolve all overlappning cities by removing common boundaries and thus create fewer but bigger areas. The issue i have is that i want to sort this dissolving/mergeing by the population-attributute of the cities. In some cases there are 20+ polygons dissolved into one, and i want to make sure that the output polygon inherits the attribute information from the city with the largest population. I’ve tried using list-arrays of both population and city-names on the dissolved areas with little success, so i am very unsure of how to proceed. Does anyone have any tips how to solve this?Many thanks!//Andréa
Hello everyone,I am trying to run the Feature Outline Masks tool from ArcGIS Pro in FME using the PythonCaller transformer. I am new to Python and would greatly appreciate your assistance. I copied the script from the ArcGIS Pro tools website (as shown below) and made modifications to fit my data:# Import system modulesimport arcpy # Set environment settingsarcpy.env.workspace = "C:/data" # Set local variablesinput_layer = "roads.lyrx"output_fc = "cartography.gdb/transportation/roads_fom_polys"reference_scale = "25000"spatial_reference = arcpy.SpatialReference(4326)margin = "5 meters"method = "EXACT_SIMPLIFIED"mask_for_non_placed_anno = "ONLY_PLACED"attributes = "ALL" # Execute Feature Outline Masksarcpy.FeatureOutlineMasks_cartography(input_layer,output_fc,reference_scale,spatial_reference,margin, method,mask_for_non_placed_anno,attributes)Source: https://pro.arcgis.com/en/pro-app/3.3/tool-reference/cartography/feature-outline-masks.htmI modified the script in PythonCaller to fit my d
Hello, I have a geodatabase file to update with FME : some features must be updated, et some new features must be inserted in that geodatabase file. Those features are polygons with several attributes. First in my script, I read the geodatabase file. Then I change some values and create new ones. Finally, I use a "Esri Geodatabase (File Geodb)" writer to update former data and insert new data at the same time. I chose feature opeartion "upsert" and table handling "create if needed". When I open the resulting "updated" gdb file in Arcgis Pro, I can see the updated data and... only part of the new features. There are several of them missing ! But why ? Here is what I should have : And here is what I get : Am I doing something wrong ? Is there a way to correct this ?
I have built a custom transformer. Now I am looking for a way to share it with my colleagues, without having to actually sending them te file. Ideally, I’d have them show up like all other HUB-transformers like this:However, as the trasformer contains private information, I connot actually upload it to the hub. Is there a solution, for example through FME Server, where I can get my custom transformer show in this list, only for my colleagues?
