A space to discuss FME Form
Recently active
I've been able to upload files to the root and to an existing path, I'm wondering if FTPCaller while uploading can create a new file path (directory)?sftp://server.com/newpath/file.txt (newpath does not exist on sftp server)ftp://server.com/newdir/file
Hi, im using neighbor finder in identifying duplicates based on XY. However, my data is stating that +/- of the value is considered as 'duplicate'. For example, stores selling 5 cars is the same with 6 or 9, but will be different if 10. So in this, I have 3 stores considered as duplicate based on their location. So I want to know the nearby data known as duplicate based on these parameters. Hope I make it clear. Is this possible in FME? Thanks in advance!
What I need to do is seperate the table by type. The types can be water, industries, woods etc. All are in the same table in postgis. So what I need to do is to get one outport for each value somehow. Later I will turn these in to raster data with 3dforcer. Can anyone help me? Best regardsJesper
I have been trying to move Point data into the adjacent parcel which is connected to its line via ESRI's Geometric network is not working out. can someone help me get through this?
Hi,Something looks to have changed on the ESRI side on how they are serving out the tiles for the basemap. Im getting alot of 301 blank tiles and have replicated it with Safe on live chat but ended up asking if there is anything else they can help with???? This looks to be a issue but i'm guessing ESRI will say update the library and it works but the functionality is coded into the transformer so should it be Safe? You dont need to do anything special, just add a esri leaflet and preview in browser. Could I ask if anyone else is also experiencing this? Thanks
Hello Experts,I have 3 files A: Point FileB : Line file (Street)C : Line file (Street2)I have extracted Street names from the A point file and transferred them to the closest street B. But unfortunately, the street names have been populated to streets within provided distance. This has caused superfluous names to the streets. I need to populate the street name to the streets where the names are missing, but it also should not be available in the polyline file C. Basically i want to identify the superfluous names.Any help would be highly appreciated
Hi All, i am trying to create some statistcis (records counts) on 10 fields in a table. I dont want to use multipule filters if i can avoid it. I want to find out how many rows in the table have valid values such as ie Depth <> "-99, NULL, BLANK, 0) ie Invert <> "-99, NULL, BLANK, 0, 0.00) ie Diameter <> "-99, NULL, BLANK, 0,) The TestFilter looks promising except the test condtions are If, Else if, Else. I want the test conditions to be IF, IF, IF. ie currenlty the test filter allows IF Depth <> "-99, NULL, BLANK, 0) Else if Invert <> "-99, NULL, BLANK, 0, 0.00) Else Diameter <> "-99, NULL, BLANK, 0,) i would like it like IF Depth <> "-99, NULL, BLANK, 0) -- port these to statscalc IF Invert <> "-99, NULL, BLANK, 0, 0.00) -- port these to statscalc IF Diameter <> "-99, NULL, BLANK, 0,) -- port these to statscalc is there another way im missing ? Many Thanks Steve
Hello,I have a shapefile representing a neighborhood of a city. It contains 455 shapes with one shape per building. Each shape contains multipolygons corresponding to the building walls or little facade elements. Some buildings have common walls but their 3D points are not equal (typically 10 cm distance between them).I would like to group the neighboring buildings and extract their hulls. In other terms, I would like to only keep the multipolygons that constitute the contours of the building blocks.I am a beginner with FME and I have tried many transformes (geometry extractor, bufferer, dissolver, deaggregator, aggregator, hullreplacer) but I could not get what I want.If you have any advice, that would be great!Thank you!
hello i would like to RUN my workbench with a batch file, so i copied the first line of the log but when i try it, it just launch FME with the workbench but he doesn't run it. how could i do that ? thanks charles.
Hello, I'm currently testing all the workspace I have after upgrading from 2020.2 to 2021.1.3. There is an issue I can't fix. I have a workspace that export data from postgresql base to an excel file. The file can be modified so I have a dynamic feature reader to get the model and a dynamic writer to write the data.In 2020.2 it works (I still have the version on my laptop, until all projects have the same version). With the same data and the same workspace, but using 2021.1.3 version of FME, my file is writen empty ....FME isn't failing but I have 95 warnings : Feature Caching is ONThe workspace may run slower because features are being recorded on all output ports.Logs_systeme_StatisticsCalculator (StatisticsCalculatorFactory): Attribute 'resultat' has no statistics requested. If statistics are expected for this attribute please ensure that they are selected in the Statistics to Calculate tableExcel Reader: Found named range '_xlnm__FilterDatabase' on she
Hello,question about SSO for FME Server 2020. Is the SAML protocol supported?ThanksRoberto
This is definitely a "New to FME" question. I'm using FME Desktop, FME(R) 2021.2.3.0 (20220131 - Build 21812 - WIN64). When I select "Check for Updates..." an alert says that I new version of 2021 is available with a link. When I go to that web page, I see that 2022.0 is available. Is there is any reason I would not want to upgrade to 2022.0? When I upgrade to 2022.0, will some of my workspaces and transformers need to change? Thanks.
I have a series of user parameters that will display when I use preview but when I run the workspace the last one won't display. I can't see any options where a parameter wouldn't be visible when running the workspace. Is there a limit to the number of user parameters that can be set?
Hello, FME'ers,Welcome to What's Up Wednesday, your weekly look at FME news. Today is May 4th, so it's Star Wars Day - and don't forget you earn a special badge for posting on the community today - or Cinco de Cuatro if you're a fan of Arrested Development (who isn't?) Either way, we're celebrating the release of FME 2022, which became available for download yesterday. FME 2022So FME 2022 is now officially released: As always, you can find it on our website's downloads page, along with the full list of updates and changes in the ChangeLog file. I'm sure there are lots of obvious changes, and you know about many of them already. But something I only noticed for the first time today is that the AttributeFilter now allows imports from Feature Caches: It was something that helped me a great deal, and I hope you find it useful too. Something else new that I'm quite fond of... The new Start Page with workspace preview image and the ability to &quo
I am updating a table in a database where I must insert, update or change value of one attribute of a record when it is deleted from source (ex: field ISDELETED is changed from N to Y when record is deleted). So in ChangeDetector I am connecting the destination table to "original" port, and new incoming data to revised port.The issue is that the attributes coming to "revised" don't have the same name like the ones from destination table, and I am using in my script a SchemaMapper tomap Source Fields to Destination fields (as the names can change and customer has access to the table used in SchemaMapper only).So because the attributes have different names, I don't think that the ChangeDetector will do it's job correctly. I attached a dummy script and dummy data to this issue.Can you give me some help here? Thanks.
I want to calculate the volume of ditches. It is do-able to determine the shore heights of these ditches, but it is not very precise. A better way would be to do a fill sink analysis. As far as I know FME has no way of doing this?
I have run some stats on a dataset where features fall into a specific polygon and have the count and the category. I now need a list that I can bring together in a single concatenated value that is {count1, cat1, count2, cat2, count3, cat3} The problem is that the number of the categories varies from polygon to polygon. The approach so far is statistics calculator => list builder => list concatenator (using category) => list concatenator (using count) which gives me two lists, comma separated but need to being them together. with the resultDoes anyone have any suggestions on how to bring together?
I have a bunch of statistics that I want to add to a HTML report similar to the image below. Not all columns have the same number of rows nor is each column / row related across the table. So was thinking that if I could create a table and each cell contain a list or similar. Any suggestions would be very much appreciated Thanks Dean
I have an ArcGIS feature layer with two tables that I'd like to backup daily. I've created workspace with two readers and two writers. The Esri ArcGIS Online (AGOL) Feature Service Readers read from the two tables. The Esri Geodatabase (File Geodb) Writers write to the same geodatabase (.gdb) folder. This works great. For the GeoDB writer I'm using Insert for the feature operation to append rows onto the destination table. Since I'm writing to the same GeoDB folder, over time I don't think that this is not the same as creating a copy. I'd like to try to append the date to the file name such as fileName_220503 for today so that I have a new gdb folder. I'm not sure how to do that. Ideally, storing no more than 30 or 60 days of backups would be best. So, maybe appending a number (instead of a date) would be better. I plan to run this from the Windows Task Scheduler (which I have not used before). I'm not sure how to limit the number of backups to 30 or
I am using a statistics calculator for a max value and then use the counter to proces new features which receives the new value thats Counter start = @value()+1. However it keeps failing due to an INVALID_PARAMETER_COUNT_START. I can't figure out why it fails. I tried setting the scope to global or local but it just doesn't want to work. So does anyone have an idea on how to avoid the Counter and get the same result? My thanks in advance! - Zoë
I have a dataset that has been collated daily over the past year but a crucial attribute hasn't been collected which would have taken the submission date of the record and looked back to see if any matching records by Name over the last 10 days and then if true write a True or false into an attribute.Is there an easy way run/play back through the dataset by day and calculate the True\\False attribute and then add to the result, I need to consider all dates cumulatively so the first date I would be just records for that day then 2nd date would be the processed records and the records for the next date etc.It feels like it should be quite a simple thing to do but I can't get my head around it at the moment, any help would be much appreciated. Many Thanks Tom
Hi, Is it possible to make a Intersection and set that, work just if the two, or three pologon contains other by 90%. Thanks
Hi, I'm creating a workbench to make some audit on GIS files. First my workbench list all files that are into a directory (including subdirectories).Then, I filter theses files to keep only the one I want to audit, for exemple every shapefiles.Finaly I get the schema of every shapefile with the <schema> output of a FeatureReader. It works really great but if I have two files with the same name in two different subdirectories my problem comes : only 1 schema is kept.That's how FME works, it unions feature types with the same name. But in my case, I need to analyse the schema of every layer even if they have the same name. This is an audit so these file can have different schema even if they have the same name. I want to have an automatic workbench and not having to create one FeatureReader for each directory. Is there anyone with an idea on how to get the schema of two files with the same name in two different subdirectories ? Thank you
Is it possible to draw a 'centerline' for a polygon but on e.g. one third from the outer edge instead of half ways?