Using transformers to modify data.
Recently active
I have a Python script that cleanses a specified document and then creates a logfile in a local directory. I am trying to embed this Python script to run out of FME via the PythonCaller, so instead of creating an independent log file, it will print out as an attribute and I can create additional functionality via FME based on the content. I was able to successfully run the data cleansing side, but I'm getting stuck with the logging side. That is, I was able to print characters inside the FME Validation Log, but I don't want that as I can't use additional transformers on that log content. Can someone provide an example file or structure of how I can add this feature to my existing PythonCaller? I'm currently running FME(R) 2021.1.1.0 (20210730 - Build 21619 - WIN64) and Python 3.8.
Hi there, can anyone please help me how can I filter some record that have a particular word. For example, I would like to filter all the road name starts with 'The ' (e.g. The Meadow but not like 'Theodor road'. If I use contains/begins with in the tester, it gives me all that have string part 'The'. I never used Regex editor. A good response will be highly appreciated. Thanks in advance.
With the help of the following request url in the Httpcaller, it was possible to get a returned xml output with information about one feature. However instead of retrieving information about one feature, ideally I would like to retrieve metadata of all the items from ArcGIS Online. Does anyone might have an idea how that can be achieved? This url gets me metadata of one feature.https://<companyname>.maps.arcgis.com/sharing/rest/content/items/<Item Id>/info/iteminfo.xml
We translated a GML file to GDB, Then we get two problem:FeatureColleation layer induced, how to remove itlayer name with geometry, how to remove itThanks
Hello all, I am trying to replace a macro in Access that makes a series of SQL queries to update a table used in more processing afterwards. I am pretty new to creating work benches and wanted to get some input as far as how I might construct a workbench to do this and the transformers I would use. I am getting lost in whether I can create a more linear process with transformers in sequential order, or if it will take a different way of thinking to build it that incorporates different pieces at different times. I am more used to ArcGIS Modelbuilder and this is just different enough get me second guessing all ideas.Here are all of the SQL queries the macro executes, in order with a couple of notes I added for clarification: NOTE: I know this part can be done with the truncate option in the writer: DELETE StagingTable.*FROM StagingTable;________ INSERT INTO StagingTable (PIN, MailingTo, FullAddress, CityState, ZipCode)SELECT SourceTable1.PIN, "" AS MailingTo, SourceTable1.StreetAddress A
I have a dataset containing 10ish attributes. Most of the fields are empty (if an item has a value in attr1, it has no value in attr2, attr3, attrN, etc), and I want to have a single attribute containing the value of all the others.
I have two geodatabase.I used "AreaOnAreaOverLayer" to have the intersections of features for the one of the geodatabase and then, for the second geodatabase. It creates for both, a field named “Overlaps”.It works correctly. After that, I wanted to join the two geodatabases The two geodatabase overlap but they haven’t the same name so I can’t use « feature joiner » because I haven’t a common field.With the transformer “clipper” I haven’t all fields (It misses the field “overlaps” of one of the geodatabase)With “AreaOnAreaOverLayer”, “SpatialRelator”, “SpatialFilter” and NeighboorPair” one of the field "overlap" is null That’s why I want a transformer to make a spatial join and not a attribute join with all fields of two geodatabase. Thank you !
I'm reading and writing dynamically some spatial data and this works as intended, however there is a usecase where if a certain attribute has value 'X' something else needs to be done (different kind of projection). The caveat is that the input isn't consistent on the name. it can be AtributeName, Atribute_Name,attribute_name,... Is it possible that when the user specifies the input data location, the user can also specify which attribute from it's data that contains the correct information? I've tried with a AttributeName parameter in the UI, but this is always linked with the attributes that are present in the initial reader and doesn't refresh to a new gdb if I provide one
Hi. By default we use Property Extractor geometries, but how can this be used if both geometries (part0, part1) have the same name? Thank you
Instead of logging in and looking at the credits usage on ArcGIS.com daily/weekly, I would like to have a script running finally in the FME server that runs daily or weekly and informs me via a mail that the credits has reached a certain amount. This informs me that additional credits need to be bought. Does anyone know what would be achievable in FME desktop? How can I retrieve credits information within FME deskstop?
X1/Y1 is the left bottom corner and X2/Y2 is the right top corder. Cannot find how to do it...? Vertex creator with Add point and LineBuilder just draws a line
Hello My 2 recent posts were related to issues experienced with FME 2022.I was hoping this one would disappear however it still persists using the latest build. It did stop (previous build) some of my critical workflows from functioning properly although the translations were successful. Basically Attribute Manager will highlight some of my values in Red.But the transformer's cog itself isn't red. It seems to affect Arithmetic values or use of functions. Here's the workflow - Nothing unusualLet's check the Attribute ManagerValues highlighted in Red for no apparent reasons I click on the Attribute Values and they return to "normal" however when you close / re-open the Transformer sane thing happens. Not sure what is going on here.Translation is successful though. ThanksSameer
I am working with rasters and want to fill some No Data Value cells with new data using a Raster Convolver (square matrix, with 0 in corners). To do an extent.When I use this, it still creates cells with value 0.0 in the corners where I would still want no data in this corner ; so I could repeat the process if needed (and fill a new gap instead of using a 0 value that will have an effect of values for next iterations).I am asking if there is a way to have this in FME, or to use any self-made matrices to be applied on rasters.ThanksSG
I have Geotiff file and I need to convert in shape file with data I am new in this so I don't know how to Extract fields and attributes from Geotiff + this is the file https://www.nhc.noaa.gov/gis/inundation/inundation.zip
Hello I'm working on an BIM/GIS integration approach. I need to integrate my revit model in a 3D GIS environnement mainly in ArcGIS pro and use it for spatial analysis. Any suggestions about the best approach ? should i simply import it, use data interoperability extension ( quick import ) or convert it to citygml or file geodatabase ? I'm struggling to understand these different formats and I'm new to this. Please Help.
I tried to use DateTimeCalculator, but it has an error output as 'invalid input' but I cannot see where it is.I attach the details.
I am using "Esri Geodatabase (ArcSDE Geodb)" reader and writer (For read and write features dynamically), but empty feature classes not listing under feature types.
Hi!I see that AreaBuilder transformer does not work with 3D lines and cannot generate 3D area. But what is the solution here or what alternative exists in FME?I have a data set with roof lines that describe roof shape. In the last 3 months I have tried many possible combinations of transformers and tested many parameters but never got the desired result.Anyone can help me with this?
Hi, I need to understand some FME log statements that is : INFORM|Combiner: The following attributes will be generated with default values because they are required but not present on the feature: fme_rejection_code When writing output to the ArcSDE writer, which is set to Insert and Update, I use Attribute remover to remove attributes that I do not want to write, but I forgot to include fme_rejection_code in a list of attributes to remove. I am concerned that the writer will include this attribute in the feature class. I realized I had forgotten to remove a couple more attributes from in attribute remover. Is it going to break something at the back-end ArcSDE. I dont see any new attributes added in the feature classes though.I appreciate any assistance on this issue. Thanks,
I have 3 questions with regards to converting ifc to citygmlI did a conversion from ifc to citygml, but when I look at the converted citygml model, I only see some attribute information displayed. Is this a proof that converting ifc data to citygml will definitely eliminate some semantic aspects?How to display volume information of each converted room from ifcspace ? Is it because the space modeled in lod4multisurface cannot be determined in volume? (The conversion scheme I made refers to the conversion scheme found on the fme website and the experiment that has been carried out by the geobim project). previously I also converted ifcspace to Room element. The room is modeled in lod4solid on fzk software and I can see the calculated volume resultI converted the ifcslab element into a citygml model, but when making a conversion scheme to citygml, the element must be modeled on the floor surface element. If it is not modeled on the floor surface, the conversion results cannot be displayed
I have a workbench that has a ESRI Reprojector that reprojects from HARN to Web Mercator before publishing to out to a service in ArcGIS Online.Each time get the error:Reprojector: Invalid reprojection parameters%0 Writer: Failed to reproject feature with coordinate system '%1' to '%2'. Verify that the coordinates and coordinate systems are valid, and try againARCGISONLINEFEATURES writer: A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for detailsCnxParcel_Overlay (SpatialRelationshipFactory): A fatal error has occurred. Check the logfile above for details Scott
Hi,I have a set of regular polygons of 4 vertex like shows attached figure.I have to split each of these polygons in 2 parts following red line shown in attached figure. Also, I have the condition to cut in parts of specific amount of total polygon area, for example: 20%. It's important to say I don't have the red line. It's only to explain how to cut the polygon. I tried PolygonCutter transformer from FME Hub but needs to have the line, so maybe the question was how to create the cutter line? I look forward to hearing your expert suggestions, thank you!
Hi Everyone, I am trying to link a custom transformer, instead of having it embedded in my workspace. But when I right click on the transformer only "Edit" is shown. The action for embedding or link is not shown (as in the tutorial link below) Any Idea where I am going wrong? Has the UI changed in FME 2022? I tried following this article:https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Desktop/Workbench/custom_transformer_embedding_linking.htm CheersFred
How to convert a .tiff file to .MBTiles using FME?