FME Form

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.

Hello, does someone please knows how i can do if I want to detect the point with min Z value in a PoinCloud and calculate the distance ( along the Z Axis ) to the closest point ? Thank you

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

Hello Forum, I’ve read in a points dataset (properties) and a estates dataset (polygons). I need to do two things: 1)add an area calculation in a new field to the estates polys. This has been achieved with an AreaCalculator. 2) add a count of the amount of properties (points) falling within each estate polygon using an PointOnAreaOverlayer.  See workspace image attached. I’m finding that the output is counting some estates (polys) two or three times. However when looking at the source data these features are there only once, which is correct. See Inspectors image attached. I’ve played around with GroupProcessing and some other settings, but couldn’t get it right. Can you advise, please. Thanks,Stuart  

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

How can I efficiently integrate the results from a previous transformer into a tester, especially when the results may vary with each analysis, without the need for manual updates every time?

We are seeing an intermittent issues with connecting to database from FME workbenches ( That runs on FME server ) though the database is healthy FME Server 2021.2.6Build 21821 - win64 The error message is "Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error[HY109:[Microsoft][ODBC Driver 17 for SQL Server]Invalid cursor position No extended error.]}" Any ideas on how to investigate this further ?? Thanks

SystemCaller command 'query user' works perfectly well on Windows CMD command prompt but throw an error on workbench:SystemCaller: Failed to Execute `query user'There is something wrong with my syntax or this is just a bug?I am running FME 2022.1 by the way.

Hi all, I need a hand integrating this python regex script into the python caller, I basically want to run as per below. I have it all working in python but now have been asked (as work uses FME) to do it here. I'm struggling to understand how to integrate python into the FME workflow. if you could assist setting this up in a basic manner I'm sure I will get the hang of it, but have been struggling for a day or two. (Also I know I could not use python, but I want to extend beyond this functionality later and prefer python) My python script is around the lines of: def check_filename(filename):    pattern = r'^([A-Z]{3}-\\d{3}-[A-Z]-[A-Z]{3}-MOD-\\d{2}-[A-Z]{3}-[A-Z]{3}-\\d{4})(-[A-Z]-\\d{2})?(\\.\\w{3,4})$'    match = re.match(pattern, filename)        return bool(match), filename if not match else "" def check_all_files():    for filename in filenames_:        result, reason = check_filename(filename)        if result:            passes.append(filename)       

Hi guys, I am working on a 3d building model conversion to cityGML​I have several openings and I tried flipping them with their original geometries​I 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 part​and 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 ???

I have an FME workbench that writes to multiple Excel files (all contained within a single zip file) with the intent that the generated files will not really be stored, but merely returned as the output of an FME web app and discarded soon after. Having to write these files on-disk first means I have to consider "hygiene" between runs so that there's no risk of file name collision/overwriting, while also saving them in a location that is available for the FME Flow server to expose to the user via HTTP. None of the documentation I could find really addresses where to save files meant for use with the "data download service", nor how to ensure that file paths cannot overlap between runs. Is there an FME Flow parameter for this purpose, like a unique run identifier I could add to my file names, or a private directory created only for the output of this run? I'm thinking of something like what TempPathnameCreator outputs, but not as a transformer, since it means

I have a table including some file name and I was wondering if ther is a transformer or work flow can read the file name from the table and download them from the local server to my computer.

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"

I’ve got an interesting problem with a land (polygon) and matching coastline (polyline) data. For cartographic styling reasons (using offsets), it’s important that the coastline is always traversing with the land on a consistent side (say, on the right). Where it’s not, I’d like to reverse the polyline coordinates. Fortunately, the polylines are simple with only one segment, i.e. not multipolyline. Logically, I could buffer each section of coastline on one side (or offset the polyline) and detect a material overlap with the land. If no overlap, reverse the polyline. Has anyone done anything like this before or have any suggestions on the best way to implement it in Form? Many thanks. /Warren

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.

Hello ,i Would like to create a connection between FME and Microsoft azure storage .i am looking for a method without using account name and key .I would like to use only token Generation rest api and avoid using account name and key .but I did not find a good documentation to create the connection .could someone explain the method ,if it is possible ?FME 2021

I wonder if it is possible to fill in the properties of an image when uploading this with the SharePointOnlineConnector.I tried setting up an AttributeCreator setting "Inspection Title" etc. but it didn't do anything with the created attributes.

I'm using FME Desktop (2022.1.3.0) to run an AreaonAreaOverlayer on two very large Geopackage files. It's been running for 4 days and currently on "Preparing spatial indices for intersection phase# 2... 11.91% done". My PC has 128Gb of RAM and 40% of that is free, yet FME is only using 7Gb and thrashing my pagefile.sys. Does anyone know how I can force FME to use more physical RAM please? ThanksRob 

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?