FME Form

I’ve seen a few other posts discussing this or similar issues when it comes to writing data to tables in an Excel file, which is now affecting me on a current project. There is a similar problem in named ranges as well, although slightly less problematic. I went ahead and filed a support ticket but in the meantime, decided to post here in case someone knows of a solution.Every time data is written to tables and/or named ranges and a template file is used, the resulting file contains errors that Excel tries to fix upon opening the resulting file. If tables are involved and cells are referenced elsewhere, links to the first table end up broken as you can see below:Here is the resulting error upon opening the Excel file: Data seems to be written as expected, but having to click through an error when opening the Excel file, plus the potential of losing links to table data, is not a good thing. An example workspace template is attached so you can play around and test on your end (in version

I use Fme Form 2024.2.2. If I remember correctly, I used to convert multiple files in one process with an earlier versjon of Fme Form.I have attached a file showing how I structured the fmw for to separate files and for multiple files.I need to convert more than 100 files from Quadri format used in Norway to the GDB format.When I convert two files separately, everything is OK.The sise of gdb files are: Rp2 5,90 MbKdp3 2,62 MBBut when I convert to files in one process something is going wrong. The size of files are:Rp2 – 5,90 MBKdp3 – 154 kBI have tried different combinations of the order of files and numbers of files.It seems to me the first file is always Ok, but it fails from the second one onward.I appreciate all kind of helpEla 

HelloHere’s my challenge:I have two datasets that I need to compare after several transformations.- Dataset 1: This contains georeferenced points with distances associated with a linear reference system (LRS).- Dataset 2: This has no geometry, but contains distances from the same LRS.My aim is to associate each value km_start in dataset 2 with the closest value _measures in dataset 1, even if they don't match exactly (I’d like to be able to assigne a tolerance, for ex. max difference of 0.01m). Thanks to this matching, I will be able to assign a geometry to the data in the second set. Below are a few screenshots to illustrate my question: Dataset1 with georeferenced points, _measures are distances in the LRSDataset2 with non geometry features I want to get the closest match from Dataset1 We're talking about fairly important datasets but it shouldn't be too much of a problem if the process takes time.Thank you in advance for your help and ideas.

I have a a workflow of moving several tables from one database to another one. I needed to make a change and wanted to test the workflow writing to my localhost instead of production database. So i changed the postgis writer from “Truncate existing” to “Create if needed” targeting my local test environemnt. Still i get an error complaining that the tables does not exist?.. It does not matter if I hardcode the Table Qualifier or not. Or if i remove it all together. I have tried to not running the wb in cached mode etc..Tried running the WB in both 2023 version which it was created in and in 2024 version. “POSTGIS Writer: Table 'rplan.PblMidlByggAnleggOmråde' does not exist. Please check the Table Name specified, or modify the Table Handling value under Format Parameters”And yes the schema “rplan” does exisit in my localhost database.I have no explanation to why FME would struggle with this?

Is it possible to get the owner information using the ArcGISOnlineConnector? if not, is there something else I can use? I used the List Action and was able to get a list of the services/maps, but because there are the same item in two different AGOs in this group, I am unable to get the right one unless I know the owner. Thanks

Good day , I have these 4 lines. Each line is an aggregation of two different lines (blue and yellow). I want to split these 4 lines into 2 lines each where they intersect with a given point (red dot). I used the intersector and the point on line overlayer. But in both cases I get 3 lines as a result instead of 2. These two transformers split the lines at point intersection as well as desaggregating the blue and yellow line part. This is not what I want. I only want to 2 lines (split at point intersection) as a result of the transformation. How can I achieve it ? I can not split lines at point intersection before I combine the lines. It’s a complex workbench.

Hi FME world,I have received a series of NetCDF files (representing rain radar) and I have no information on the projection for them, other than they are supposed to be in New Zealand and maybe Lambert Conformal? I can represent in an app like Panoply (image below) but when I try to project in FME, NZTM or LL84 is incorrect. I have tried creating a custom coordinate system but this is no use either. I’ve included a view of the Feature Information with the exposed list as per this conversation NetCDF - no CRS desposited | Community.Would love some direction if anyone has any thoughts?! Thanks!   

I suspect this might be an ESRI thing rather than an FME thing, but is it expected behaviour that if a feature is written to a table which has a non-nullable long field that field gets populated as zero if an attribute is missing? No error, or warning?

How do i read LAZ raster files from Azure Cloud? 

i use  pyrhon create FMETriangleStrip, how i add normal list  for FMETriangleStrip? thanks

I have a workspace where the user should be able to export a DEM grid in several different fileformats (a user parameter for the output filetype). Then I have a FeatureWriter for the output. It works well if I want to output a raster DEM (e.g. a GeoTIFF), but if I want to output the data as a DWG with a point grid, I get several thousands of Features exported.Of course, I could make a workspace with a lot of different filetype Writers instead, but a single Feature Writer would be nicer.  Is there a way to consolidate all the thousands of DWG points into one DWG? I dont really want a DEM consisting of one multipoint either.

Hello folks,I want to split data from below data as shown. I want the output format in CSV as this - where the target quantity is Quantity / No. of days in months.The problem I am getting here is I am not able to split the data of month into number of dats because as I need the date as 01-Jan-25 for all the days in the monthHow can iterate these values. Kindly help!

I appreciate that’s a wordy question. Hopefully, this pic will clarify.  A and B - green polys, low detail at edge - are a dataset I am using to run into a SpatialFilter to determine areas of intersection with the more detailed dataset in pink (amber where there is overlap). You can see that part of the upper example polygon I have coloured part of area 1 in blue, and sits mostly inside A. The smaller, black part of 1 sits inside B. I want to join the entire area of the intersected polygon fully to the feature from the green dataset that contains the largest part of it - in this case, to A. Any ideas how best to proceed? I currently foresee: Check for intersection of area 1 with areas A & B Calculate area of overlay Test for largest Join all of the area of 1 to A Feels like there may be a fair few transformers involved. It’s a national dataset. Just trying to figure out how best to do it. In Esri, I think there might be a simple option to ‘join to largest’…? (Not that I want to jum

Hello, I would like to do the following (see attachment):Select these three lines (black, green, red) from a db table (how the table is structured I have to select the three of them and not only two) Create a 2m buffer around each line Identify the two lines (black, green), as they are the lines with a smaller angle to each other, and create a point where their buffers intersect /diverge (red dot) Create a perpendicular line to the green and black line starting from that point Create a point (yellow dots) 4m away from the intersection of the perpendicular line with black/green line on the black/green lineThe first two steps are easy to do but I have troubles with steps 3-5. What transformers shall I use ?

Hi,I’m trying to use the OGC WFS FeatureReader to read in features based on a dynamic URL stored as an attribute. This is because in the URL link, I want to have a bounding box parameter that changes based on the extent of another dataset. I.e., I only want to read in the features that are within the bounding box of another dataset.I’ve set up an attribute “URL” that contains the bounding box parameter.When I hard-code in the URL with the bounding box parameter into the FeatureReader, it works as expected and reads in only the features within the bounding box. If I replace the URL with the dynamic “URL” attribute, it ignores the bbox parameter and reads in everything. I  And yes, I’ve confirmed that the dynamic URL attribute is exactly the same as what I’ve hard-coded into the FeatureReader that works. Does anyone have any idea how I can fix this? Or any other ways I can read OGC WFS features with a dynamic bounding box?I’ve tried the Spatial Filter parameter in the FeatureReader too a

I’m trying to split an ArcGIS sde table of rooms into multiple CSVs based on floors, and then upload the resulting CSVs into a Google Drive directory. I have the first part, but when I run the Google Drive connector it says the translation is successful, but nothing gets uploaded to the GD directory. I have admin access to GD and there is nothing wrong with my connection. Has anyone else had a similar problem? 

Hello am new to FME I in the process of Automating the import of invoices and G/L transactions.  Our CitySuite by Harris.  Is the anyone who is or who has been involved  with the integration of these.  My biggest hurdle at the moment is the format of dollar amounts in XML.  I have tried using the xquery  formula but then the XML Templater fails. Any assistance would be appreciated.  

Hi, I would like to know if there is any processing in FME as "Euclidean Distance" tool in ArcGIS. Thank you. Clara.

I used PointToPoint overlay to find out which two points are a repeat in two datasets. How can I still grab two columns of information from dataset 1 into dataset 2 if they are overlap? the two datasets do not have FKs, is there a way to join them spatially and then have the tables join instead of union? ---Thanks---

Hi all. I am reading in an Excel sheet where DateTimeUTC is formatted like this as text, but I need to convert this into a proper datetime for UTC… thoughts? DateTimeConverter is out, or perhaps I’ve not formatted it correctly.   Otherwise, I can use attribute splitter to get the date, but the time part is tricky… not sure what to use to get that formatted properly

I have finally started using FME Workbench (Form) 2024 a bit more consistently now that I built a new instance of FME Server (Flow Hosted) 2024.1.1.1. I like the updated look, but am missing a few things and noticing some inconsistencies in how the transformers render on the canvas:The newer look is more modern and although it’s just “ok” for me (looks like a card and less “fussy” than the previous transformer look), I like it. I miss the cog-wheel to access settings with a single click at the top-right of each transformer. Now you have to highlight the transformer and then you can click to access the settings. Doubling the mouse clicks isn’t a great enhancement. Would love to see this make a come-back, maybe as a minimalist “dot” or something... I can double click to get to the settings, but still not thrilled about it. It is forcing me to use the Parameter Editor window more now, docked to the right of the screen. Still getting used to it in an effort to reduce the clicking but with

Hi,How can get the green dot on the blue polygons.I have created the polygon centroid using center of polygon and with neighbor finder I get the green dot on red line. What I need the green dot on blue polygon and the small segment connecting the red line to blue polygons.I tried lion on area but I cat extract the  segment marked in black.Any help is appreciated

Hi, I’m an FME newbie. I have an ArcGIS sde (SQL) feature class of rooms with about 15000 rows across several hundred buildings. I need to write a list of rooms, by floor to directories for each floor in Google Sheets. I’m not sure how to go about generating each list. I’ve messed around with list builder some, but I’m stuck. I could do this in Python, but I’d like to take advantage of the FME Google Sheets writer. 

Hi all. I’m trying to generate UIDs for helping out with site inspection reports for structures. The structures are comprised of “Components” and each “Component” is comprised of “Sub-Components”. Each “Sub-Component” has a inspection lists (“Lists”) that are checkboxes that need to occur for each “Sub-Component”. Each checkbox is a coded item (“Code”) that must be inspected. There are multiple “Codes” for each of the “Lists”.The UID format that is desired is this:“Site ID”. “Component ID” . “Sub-Component ID” . “Code”The problem I am running into is that the data have been provided in Excel. There is a “SiteVisits” Tab, and a “Lists” tab. The SiteVisits tab has 350+ records, with columns containing Site IDs, Component IDs and Sub-Component IDs, and a column on the “Lists” required for each Site.SiteVisits Tab, with 350+ recordsThe “Lists” Tab contains a descriptor of each checkbox and the associated “Code”. What I am trying to do is concatenate the easy parts of the UID (“Site ID”. “C

Hi,It seems that the SpatialFilter does not always work as expected when the Filters First option is enabled. I have taken several steps to fix the incoming data (such as using the GeometryValidator and applying reprojections), but the SpatialFilter only works consistently when the Multiple Filters option is enabled.Below, I have included an image of my workbench, where—after multiple test attempts—only the top SpatialFilter suddenly works as expected.Is this a bug?I am comparing .dwg files with a feature class in a geodatabase (area)I work with the DataInteroperability extention by ESRI, in a workbench created outside of ArcGIS PRO,FME(R) 2024.0.1.0 (20240328 - Build 24202 - WIN64)