Best Answers

I have been trying to automate uploading/deleting from a Google Drive Shared file using a GoogleDriveConnector, which I thought was recently changed to support shared drives. The first issue is that the files do no automatically overwrite if they have the same name, they create duplicates, whereas if you upload manually the files will become versioned. To get around this, I assumed I would be able to identify and delete the older file first before uploading the new file, however when trying to delete the older file I get:"2021-10-20 15:19:39| 21.6| 0.0|INFORM|Delete_existing_file: Object with id "File ID" does not exist on Google Drive. Nothing to delete". (I have removed the ID for this post). I have permissions to delete from the drive, and I have created the shareable link manually as a check to confirm that the file ID is correct and exists. I can successfully upload new files to the said folder, but I'm trying to avoid a scenario where I have a load of outd

I have a lot of excel spreadsheets that all have the same attribute schema. However, there are a varying number of header lines that precede the data in each. In FeatureReaders & Readers, we define the start point for data by line number. Given the consistency of the attribute schema and the inconsistency of the header spiel, I’m trying to think of a way to only read in the ssheets from the start of the data/attribute names, i.e. dynamically, defined by the first attribute name rather than the line number (I guess). Any ideas?

Hi, I’m fairly new to FME and having some issues with the PointOnRasterValueExtractor.All datasets are in EPSG:7850 (GDA2020, zone50) and the PointOnRasterValueExtractor seems to be working as I can see the correct values when I interrogate the points.The issue is when I try to write the output to a Shapefile.  The Q__band values are all zeros.What am I doing wrong here?  

Hi all,I am looking for a transformer that does the opposite of the ListKeyValuePairExtractor.It needs to create a list with FIELD_NAME and FIELD_VALUE pairs for all the attributes on a feature.I checked the transformer gallery and the FME Hub, but could not find such a transformer.Has anybody a solution?Could be a Python script. Thanks in advance.Erik

I have a bunch of ZIP files which we download the contain data in 3 formats, shape, csv and file gdb. The zips also contain numerous other files such as pdf and xml, which we don't need to read. Now the tricky bit, I am using a PATH reader to check a directory to see what ZIPs are there and to only load the ones that have arrived in the last 24hrs. The load is triggered in a Sub workbench where the Path is passed to a FeatureReader set to Generic. I can add I file type filter to the path that is passed by adding [**\\*.shp], for example to the path of the zip found by the PATH reader and can read the ZIP 3 times with a different filter each time by building this string""@Value(path_windows)[**\\*.shp]" "@Value(path_windows)[**\\*.csv]" "@Value(path_windows)[**\\*.shp]""  but can't work out how to add filters for csv and gdb to read the file once and look for shp, csv or gdb. The above works, but I get error messages for the iterations th

Hello togetherI am currently working with two watercourse datasets from different sources, which unfortunately do not take the same course depending on the region, although in reality there is clearly only one watercourse. For this reason, I would like to merge the datasets or assign the attributes of one dataset to the line segment of the nearest neighbour of the other dataset.I've already tried a bit myself in ArcGIS Pro, but haven't come up with a clever solution. Do any of you have an idea for this?Thanks in advance for an answerBest regardsDani 

In the 2024.x versions of FME Flow, will the URL continue to contain ‘fmeserver’ or will it be changed to ‘fmeflow’? Example: https://mydomain/fmeserver vs. https://mydomain/fmeflow If, by default, the URL will continue to have ‘fmeserver’ in it, can we change that in a configuration file?Asking as we may need to run both FME Server 2022.x and FME Flow 2024 in parallel while migrating some legacy 32-bit Esri solutions. Thanks,Mark

I have a somewhat large (~180k lines, 100 cols) set of features coming out of a database reader that I'm loading into a PythonCaller to run some heavy processing on. I've been doing some profiling and it's a big contributor to slowdown in my workbench. To my surprise, though, the number crunching only represents about 10-20 seconds of the 90 seconds runtime for that node. Most of it is actually spent in the hot loops that run feature.getAttribute (another 25-30s) and feature.setAttribute (about 50s). Meanwhile, using a FeatureWriter and a FeatureReader, all these features can be written to and read from Parquet files in seemingly less than a second. It's not exactly easy due to how FeatureReaders don't output the path of the file they've written to, and PythonCallers only have one input node, making it difficult to handle passing a temporary output file name, but it cuts down my translation time from 90 seconds down to 9 seconds. Are these the only two ways of d

A few co-workers have left the company and have forgotten to share their workspaces on the FME server with myself and others. Is there a way for the FME admin to share those workspaces that are being used in automation and schedules with us?

Hello everybodyI am currently working with a watercourse network dataset (lines), which is divided into a new segment each time a new watercourse branch branches off or is integrated. Unfortunately, the dataset contains very obvious "errors" as the width of the watercourse between two consecutive segments is much too large and the orthophoto also clearly shows that there must be an error here.I am not that experienced in FME yet and so far I have simply determined the points between the segments and was able to assign the different values of the touching watercourse arms to them. My main task is actually to provide the person responsible with an extensive data set that quickly shows where the difference between two watercourse widths is greater than XX metres (parameterisable). I have currently arrived at the status in the screenshot below, where the intermediate points with the water widths are listed for each line. Ideally, however, I would like to have only one line per point with t

HiI need to update several Excel files within a zip file. I have contacted support and they have created a problem report for the development team (FMEENGINE-83267,  I have reproduced the problem with updating multiple Excel files within a zip file). FME Form 2023.2.1.0Build number: Build 23774Meanwhile I need a work around, any ideas?BrFelipe Verdú

Hello,Currently, I have a process where I am doing a PointOnAreaOverlayer. I then create about 23 List Attributes. As of now, I have 23 List Summers to achieve my requirements. I then port all the List Summers into one Attribute Manager, remove all the non-summed fields, aggregate all the points grouped by the Primary Key, and then I join that back to the area layer so that it holds the summed values and stays an FMEPolygon and not a MultiFMEPolygon.Is there a way to do this “better”? I have to redo this process on another Polygon Feature Type and it’s cumbersome.  Kind Regards,Senad

HiI have 2 transformers (A and B) they have to provide a Sorter with inputs.If there isn’t any output from A, then this workflow C has to stop, but not the entire workspace.  If there is output from both A and B, it has to continue.If there is only output from A and not B, it has to contiunue. Is it possible?   

Note: I already solved this issue by forcing everything in “MGA2020-55_FME”, however the way FME writer handles GDA2020 data seems strange.I am trying to update an “EPSG7855” table from SQL to an “EPSG7855” feature service in ArcGIS Online. After checking the log, FME seems do not think EPSG7855 is GDA2020 Zone 55 and trying to reproject the data. Which cause the GDA2020Zone55 layer not align with GDA2020 Zone 55 basemap.   Log:  2024-06-20 09:27:58| 0.9| 0.1|INFORM|The ESRIWKID number of the FME coordinate system 'MGA2020-55_FME' is '7855'2024-06-20 09:27:58| 0.9| 0.0|INFORM|ArcGIS Online Feature Service Writer: Requesting metadata for Feature Service at 'https://services-ap1.arcgis.com/w6r4Ll*/arcgis/rest/services/Property/FeatureServer'2024-06-20 09:27:58| 0.9| 0.0|INFORM|ArcGIS Online Feature Service Writer: Found layer/table 'property_view' with ID 4 for feature type 'property_view'2024-06-20 09:27:58| 0.9| 0.0|INFORM|ArcGIS Online Feature Service Writer: Requesting me

In FME Flow, you can set up automation so that a workspace restarts if the job fails. However, if a job is canceled (for instance, it exceeds the max. queue time), this is not possible. Or have I missed something?

Hi!Does it exist an easy way (1 transformer) to compare 2 lists from differents dataset ?For example :dataset 1 - feature 1list{0}.NAME = Alist{1}.NAME = Bdataset 2 - feature 1list{0}.NAME = Blist{1}.NAME = CI would like to have the difference so here :=>on the dataset1, feature1 “A” is missing=>on the dataset2, feature1 “C” is missingthe index of the value doesn’t matter, juste the presence of the value is important.I succed with 2 ListExploder and 1 FeatureMerger, and I imagine It would be working too with  ListExploder, FeatureMerger and ListSearcher, but maybe it exist a transformer to do that more quickly.Thanks!

I'm working on enhancing an FME Workbench to be more interactive.Currently, my focus is on a project aimed at creating study area polygons.Depending on their purpose, these polygons can vary from one another.Is there a way to incorporate a dropdown menu or a list at that junction to select which writer to run and which not to?  

Hello everyone Im playing around with FME FLOW and uploaded my workspace. The workspace is running well with several parameters and writing me an OBJ file into my ressources and finally writing an HTML file (which opens a 3dviewer which opens the OBJ file).When im running the workspace in FME FLOW i choose datastreaming Service, and after success it opens the HTML file in my Browser.When i create a WebApp it is also running well and in the end opening the HTML file and showing the OBJ in the 3DViewer.But since the WebApp is quite limited with layout etc. i created an easy HTML Website on my Server. Here i added a send request with the webhook url of that workspace and the get method.And actually it is running, but after success its giving me a link to download a zip with the HTML and OBJ file.To me it seems because im using the Get method, it is just putting all the results into that zip to download. I tried a bit around and also searched in forum but didnt find an answer.Am i missing

SpatialFilter gives more intersections than expected, any clue?For a parcel I want to compute the area covered by buildings on that parcel. The start situation, with one parcel and some buildings. My next plan was to use a SpatialRelator to create a list of buildings located at the yellow parcel.I tested this approach using a SpatialFilter first to see whether the intersect function works. I expected to get back only the 2 red buildings within the parcel polygon. However, I got this:A subpolygon of one the buildings is also selected. Did I something wrong?​​​My settings of the SpatialFilter:Any ideas how to solve this? I tried other Predicates to test as well but so far no success. 

Hi. I have created contour lines from DEM rasters and I’m getting outliers (straight lines to random points). What is the best way for me to remove these lines? 

Hi, I’m looking for the best way to let end users decide whether to trigger a second workspace based on result (html data stream service) from first workspace. Is it possbile at all using eg. an automation app? If possible I also want to make use of the same parameters in both workspaces to make sure the geographic extent is the same.My case is that workspace 1 runs some calculations to get costs. These costs need to be accepted by end user (Yes/No) before ruinning next workspace which produces som files. If possible I want to make use of the same parameters in both workspaces since it should make use om the same geographic extent.Thanks for any ideas

Hi i am trying to read lots of excel using the feature reader transformer,  passing in the locations form a directory path reader. all the excel have different tab names but the data always start on row 10. As the dataset is a file path the option for telling it to start on row 10 are blanked out. anyone know how i get around this?Many thanks,Andy  

Currently I am working on writing to an IFC-file. One of the classes I would like to write is IfcZone. However, when I try to do that, I get the warning: IFC: Unable to write objects of type 'IfcZone'Now I am wondering whether I did something wrong and I am missing some settings or whether FME does not (yet) support writing to IfcZone?@DaveAtSafe

I am trying to write PDF file using PDF writer, when I add @Value(Scan_Location) in fanout dataset it creates 2 different files as output. And that is not what i want . I just want this name ….20240621 NI2-HK-L03 As-built_PDMS Comparison Report F1.pdf and just one file     

Hi all,I am trying to read a json file, that contains a collection of objects. It is NOT an array, and the objects have no name, they have just a number. It’s that number I am interested in, but I can’t seem to find a way to get it exposed. My Json looks like this:{ "1": { "name": "msg_status", "data": { <snip> }, "port": 4, "timestamp": 1717497996, "timestamp_parsed": "2024-06-04 12:46:36" }, "2": { "name": "msg_ublox_location", "data": { <snip> }, "port": 2, "timestamp": 1717498735, "timestamp_parsed": "2024-06-04 12:58:55" }, "3": { "name": "msg_ublox_location_short", "data": { <snip> }, "port": 13, "timestamp": 1717498741, "timestamp_parsed": "2024-06-04 12:59:01" }, "4": { "name": "msg_ublox_location", "data": { <snip> }, "port": 2, "timestamp": 1717499651, "timestamp_parsed": "2024-06-04 13:14:11" }}and so on, for a couple of thousand objects per file. The d