Using transformers to modify data.
Recently active
Hi, I am a new FME user and hope someone can assist with my issues. I have to update weekly utilities data from .12dxml to geodatabase. From thegeodatabase, I have to create a map in ArcGIS Pro and publish it to ArcGISOnline. I just run the FME and overwrite the map whenever I receive data toupdate. I have no issues doing it since I just overwrite the data for everyupdate.However, the team requires me to add the date to each of the layer names e.g.:utilities_electricity_20221025.Previously it was just utilities_electricity.Hence, I couldn’t overwrite the data into the gdb. It will create a new layerinstead since the layer names are different every time I update the dataweekly. eg:utilities_electricity_20221025(for week 1); utilities_electricity_20221104 (for week 2). My questions are:1. How to overwrite/replace the layer with a different name? E.g.: utilities_electricity_20221025(old data) replaced with utilities_electricity_20221104(new data) in gdb?2. How to make sure the m
Hi all. I've got the measure calculator working with the standard measure generator/pointonlineoverlayer/measure extractor routine. In many cases points are close to two or more line however there is a common attribute between a point and the line. How do I go about using the common attribute detail to calculate the measure. That is a want the measure of Point 1,2...n with attribute "x" calculated on line 1,2...n with attribute "x". Kind of like preventing them from snapping to the incorrect line. The other issue is not all points fall on the line but are very close so a tolerance needs to be introduced. Hope that makes sense. Thanks,Michael
Hello everyone, I have a dataset with a lot of columns which do not contain data in every row. It is structured something like this: What Im trying to do is create HTML-Reports for each Row but excluding the empty columns in each individual report, basically creating something like this: Table in HTML Report 1Table in HTML Report 2Table in HTML Report 3 Group Processing gets me halfway there but sadly keeps unnecessary columns. Is there a way to do this in FME? Any help appreciated.
Hi, I have an attribute by the number 0821 and similar which I want to add next to another counter attribute that starts on 01 and goes on 02, 03 etc. My attrbute KnKod_1 looses the leading 0 to the left. See expression in Arithmetic ed. in the pic.
We want to convert Date in format 2023-09-13(YYYY-MM-DD) to Timestamp in milliseconds 1694563200000 using FME Transformer but no FME transformer is able to convert date to milliseconds.For example 2023-09-13 -> 1694563200000
Like the title states, a while back I encountered a situation in which I obtained an SSL connect error when using the HTTPCaller.In my case I wanted to fetch some 'table information' from a website, and I noticed that using the HTMLExtractor for this job did work for me. In the end the HTMLExtractor sufficed for my usecase, but I'm still curious on why the HTTPCaller resulted in the SSL Connect Error. Also, I can imagine that maybe in the future I would like to use the more advanced functionality of the HTTPCaller here (e.g. 'Retry Failed Requests' or 'Rate Limiting'). See below screenshot and attached workspace for some more information.Is there maybe someone that has a clue on why I obtain an SSL Connect error with the HTTPCaller? Within the HTTPCaller, I tried tweaking the settings a bit, in particular the 'SSL/TLS Options' and the 'HTTP Client Options';SSL/TLS OptionsChanged 'Verify SSL Certificates' to 'No'Changed 'M
Hi guys, I am working on a 3d building model conversion to cityGMLI have several openings and I tried flipping them with their original geometriesI set the gml_geometry_reversed attribute and used GeometryPropertySetter(gml_geometry_reversed, xlink_href) to make the orientableSurface as followsthe orientable surface was successfully generated but when I open the file with the inspector its appearance was flipped in wrong waythe windows and doors are supposed to be like this I GUESS the appearance part in the document must be written incorrectly(specifically, <app:inFront>fasle</app:inFront> part)this is true partand this one is false partthe order of the coordinates is the same for both parts...I am not sure this has something to do with the flipping issue I have no idea how to edit the transformers and fix this problem please help me solving it...!!😂
want to know detail process convering dxf to gltf
In table 2, the percentage change was calculated separately for each category of A, B, and C. I'm using FME2022. Table 1Table 2
I would like to import the Control points from Leica TS10 into FME https://leica-geosystems.com/en-gb/products/total-stations/manual-total-stations I would like to import the Point cloud from Leica RTC360 into FME https://leica-geosystems.com/en-gb/products/laser-scanners/scanners WHAT KIND OF READER I use to read the data into FME , I didn't find any so if anyone is aware of ???
Is there a straightforward FME way to set all attributes exiting the failed port of an AttributeValidator and listed in the validation message list to null? I have a very straightforward bit of python to do it, but my brain is failing me this afternoon on an FME methoddef FeatureProcessor(feature): for i in feature.getAttribute('_fme_validation_message_list{}'): attrname = re.search(r"(?<=Attribute \')\w+",i) feature.setAttributeNullWithType(attrname.group(0),fmeobjects.FME_ATTR_UNDEFINED)
The number always begins in the PDF file with "Registratienummer: the number I want to copy"
Hi there Just as the title says. I know how to do this with a shapefile within the writer but I cant see the same options within the sharepoint list writer Thanks in advance-Ed
For example, projectname: X has a MethodType:Vegetation. When one chooses Project name X, MethodType:vegetation should autopopulate. This ensures correct method type gets picked up without spending time to identify the methodtype for that projectname especially if there are many methodtypes.
FME Form 2023.0 I have four datasets, three line datasets which I add an attribute to distinguish it from the others, this attribute is called MaxLength. The forth dataset is a point dataset. The three lines datasets are run together and then run I a pointonline with a groupby using the MaxLength attribute in the line datasets but I get no matches. If I remove the groupby then I get results. Is the above possible with the group by or do I just need to run the pointonline with each line dataset separately?
Hi, I am trying to automate creation of template file from different forms into Excel spread sheet. There are many forms to extract information from. I am trying to first create a template of the column headers for each form into separate excel spread sheet.I managed to get all the column headers as a feature within each form_id as seen below.As you can see there can be many forms (form_id is unique for each form) and within each form_id i have column headers (label). how can I transpose these labels as column headers in excel (1 excel template for each form) and write them out in excel? I have seen e.g. transposing columns into headers, but I'm not sure what I can do when I have dynamic number of forms and each form can have dynamic number of columns. Any help is much appreciated!
For eksample: Features with the same UUID shall be used later in the workflow. But I don't know what UUIDs will be in the Input data. I can geneate a list of unique UUIDs at runtime and would like to use this list in the AttributeFilter, defining the AttibuteFilter-ports. Would // How would this be possible?Thank you.
I don't want to use the drop&create option on the table, this is too dangerous. My goal is to read the collection, rewrite some rows using JSON transformers and update them thanks to their mongodbId.
In the same manner as I can get the name of the workspace via the $(WORKSPACE_NAME) Trying to make it easier to bugfix scripts if they fail or get terminated by a terminator transformer. The message is then sent to a teams-channel.
I read files from Sharepoint. Sometimes I can read all the files but other times (no obvious pattern) I get this error msg when reading the exact same files again:`fme_rejection_message' has value `SharepointOnlineConnector: Could not connect to server. Check that you are connected to the internet and that no firewall is blocking outbound connections. The error was 'HTTPSConnectionPool(host='graph.microsoft.com', port=443): Read timed out. (read timeout=60)''Can I somehow easily adjust the read timeout?
Hello, I have the following problem. I have a file with a lot of rings, which all have a unique ID. On the other side I have a lot of raster files which also have this ID as file name. Now I want to crop each one of the raster files to the corresponding outline with the same ID. These cropped individual raster files are then to be saved individually. How can I tell the Clipper Transformer to "blend" the ID of the ring with the ID of the raster file ? Maybe someone can give me a hint. Many thanks and best regardsMaisels
how to do it such that upon getting the value of ward_no it should run the model for the data pertaining to the ward and how to pass the parameter value (in this case ward_no) to fme workbench reader to make the process dynamic.
Newb here, I'm using FME a lot for simple GIS feature class extraction, from source DB to a target DB, pretty straight forward. After many of these I'm thinking there must be a simpler way to map the source and targets.Per image below, reader layers on the left and writer layers on the right, then I manually connect them. The writers are identical, no changes or alterations required, surely there is a way around the manual connecting of source/target.