FME Form

The file gdb is a handy conversion template that avoids a lot of painful domain reformatting.

Hey, I love FME so no product bashing here.... but is there a bug in FME Server 2020.2? I have a schedule that's set to "Occur Only Once" and that I enable to run on a certain/time when I need it. In the past, this has worked great. I'd move up the date to whatever needed, enable it and hit "Okay". Since upgrading to 2020.2 last year, I've noticed that when I do this, the new date I select in the calendar will not take...... and when clicking 'Okay" in haste or out of habit, it will save schedule with the old date from the past and - now enabled - start running immediately. Bug, user error?Plan to upgrade to 2022 when it comes out. So if I don't get any nibbles here, I'll see if that resolves it.

It is to identify the sum of which group. Otherwise, the result is a list of values (for sum) but not possible to identified which value is for each group of features.

Is it possible to generate a horizontal bar chart with the HTMLReportGenerator?

During one of my projects I noticed in my counts that I am missing records.  As you can see 16k entries enter the requester eand only 13k exit via either port. This is connected to missing keys entering into the requestor I know that I can solve this using a nullattributemapper to change missing into null, or by setting reject null and missing keys to 'Yes' (non-default setting). However the fact that this is largely invisible has me worried.  I have also concluded that this behaviour is not consistent. The below workspace has a test setup testing for the behaviour with simple input data. All 4 cases behave as expected. Unless I missed something, I believe this is a bug. If you can confirm, deny or reproduce, it would be highly appreciated :).  

Hi, I'm curious if anyone has found an efficient way to calculate the X nearest neighbors in a pointcloud or a set of 3D points from a single 3D point.  My current method is mathematically calculating the distance from point 1 to every point in my pointcloud with the following formula and then sorting by distance. d (P1, P2)= ((x2 - x1)^2 + (y2 - y1)^2 + (z2 - z1)^2)^1/2   It works but it's not efficient at all. I'm curious if anybody has a more efficient idea. Thanks,Mark   

Hello to all, I'm stuck since yesterday on a problem I can't solve.I want to transfer the attributes of a 2D representation of the roofs of the buildings of a city to their 3D version.I have my 2D data in .gpkg and my 3D buildings in .dwg.According to my geometryfilter, the roofs are surfaces and the 2D data are areas.Everything seems to work on the first objects, my attribute replicates correctly on the concerned roofs, but I still get an error, when processing the 1145th object in my clipper. The error is "Attempted to access the value of an uninitialized optional object".I guess some of the geometries may have a problem, but even with GeometryValidators to filter my 2 data sources, nothing changes.What method would you recommend to fix this problem? Are there better ways than GeometryValidator for this kind of problem? Thank you in advance for your answers.

I am new to Json queries. I am trying to extract the details from a arcgis feature service as a spreadsheet for the ESRI living atlas requirements. I have gotten really close but I want my features and tables to be in their own column (second screenshot is what I want). What I am getting is the feature layer AFTER its attributes, and in the same column. I am hoping the resulting table can go into the corresponding feature layers metadata page, as they are manually updated at the moment. There is probably a way to do this using substring extractor, but I was hoping I could do it using json as I have to replicate this for 10 more data products.  

Hello FME friends, Server Apps and AutomationsFME 2022.2 is coming out shortly (my estimate is about 4-5 weeks), and one of the new features is called "Automation Apps":  Automations can be started on a set schedule or by a certain event, but can also be started by a manual trigger. An Automation App is how you can set off that trigger through an app or webpage. As I understand it, it's like a workspace app, but the end user supplies information through keys, instead of parameters:  We're already working on articles and videos to go with the launch. But if you've already tried this functionality in the beta version, we'd love to hear your opinion. In fact, if you use apps of any form in a production project, it would be great if you left a comment below. We'd like to get some feedback on the value that Server apps provide to your workplace.  Best Practice Guide SurveyI recently suggested to a few users that we work together to create "A Community Guid

Occasionally the Folder (existing) parameter will change a backslash in the folder path to a forward slash when the feature is is shown in the table. This creates a major problem for reading, writing and comparing to this folder. Is there anyway to make sure this doesnt happen?

I am looking for suggestions for a user friendly database editing tool. A client of ours has a deliverable in Excel format. We feed data to it via FME from a SQL Server/SDE database. However the client does edits in the excel file and the edits never make it back to the database. I know, we can load the edited data back to the DB via FME again, but preferably, the users will edit the data directly in the database. The client is used to the editing functions in Excel so we need to offer them something very similar/easy to use. The data to be edited is a non-spatial table but related to a parent spatial object.The tool must have:Allow for bulk editing (replace drag functions in excel). Must be user friendly/no code. We have tried MS Access but it is too complex. From the user perspective they just need to:access and filter a subset of the data eyeball the values and add comments in one column.Good to have:Track editor idRead and write by FME We are flexible on the database so if there is

Dear readers, A strange thing occurs today. In an an AttributeManager, I changed the value of an output attribute, from a fixed string to using a user parameter, partly.The original string was: mkdir "Y:\\Basis\\Kunstwerken\\@Value(KWK)\\@Value(KW_CODE)" I substituted the part in bold with a user parameter (in bold, too): mkdir "$(Kunstwerkmappen)\\@Value(KWK)\\@Value(KW_CODE)" Now, here's the funny thing. If I provide the user parameter with the original string, the result is (one record as an example):copy "I:\\BEHEER\\Temp\\Ferdinand\\LM_fotos\\Pictures_LM249DrempelsZestienhoven\\061720122651.jpg" "Y:\\Basis\\Kunstwerken\\Gemalen\\KGM-231\\061720122651.jpg" All seems fine. But the idea is to be able to change the value of the user parameter. So I tried filling in "I:\\BEHEER\\Temp\\Ferdinand\\LM_fotos\\Kunstwerken" (without the quotes)I get this result: copy "I:\\BEHEER\\Temp\\Ferdinand\\LM_fotos\\Pictures_LM249DrempelsZest

for examole,I have some 3d point,how I can get near point for one point,thanks

Why isn't this easier in FME? I've tried lots of examples on the Hub, but can't get any of them to work. The Attribute Pivoter is difficult to use and never gives me the results I need. I can perform this very easily in SQL. I'm trying to turn my rows Vxx into columns with the value of Litres, grouped by all the other rows. Any idea how I can achieve this? Thanks in advance! 

Hello, Following this example as a starting point: https://community.safe.com/s/article/how-to-read-all-feature-classes-from-multiple-esri I am able to convert all of the feature classes in a file GeoDatabase to shapefiles. In production, the workflow would actually import the feature classes into an Enterprise GeoDatabase, while reprojecting the geometry as well. After making the modification to the above example so that the output is directed to our EGDB and then running the workspace, the log indicates a successful connection, however it subsequently fails with a very unhelpful message, "Error running translation".Below is a screenshot of the workflow, modified to test for particular feature classes (as well as a disconnected reprojection step, as I'm not sure if simply placing it between the FeatureReader and Dynamic Writer would work, considering the dynamic nature of the workflow that would input to sources to the reprojector).And the EGDB writer properties and para

Hi,how can i order the nodes on a line.I put line segments into the topologybuilder to generate its topology. in the result i got an orderd line (see attachment) but unfortunatly the nodes are not really ordered (see second attachment).can somebody explain how can i get the right order of the nodes on the lines?thanks in advance

Hello class!In the attached PDF (in Dutch) I have an example of what I want to do exactly but the example was made with the PostMan program (but I can't follow the same steps in FME). Mainly the part of obtaining the Token (access authorization to the Melvin database). I would like to know how to authenticate Melvin API via FME? In this case with HTTPCaller transformer. I already have the Melvin account (username and password), but I don't know how to use this information in HTTPCaller. I have 3 requests, 2 Post and a Get: https://keycloak.ndwcloud.nu/auth/realms/ndw/protocol/openid-connect/token (POST) https://melvin.ndw.nu/melvinservice/rest/area/all (GET) https://melvin.ndw.nu/melvinservice/rest/export (POST) My WS follows along. Does anyone have a model to share? Thanks in advance. Regards, Everton

Hello everyone,I have to extract information from a web page that shows a map with a database connected to a list of projects in the area, could anyone tell me how to do it? Here you are a print screen of the web page

Workspace I meant: ttps://hub.safe.com/publishers/con-terra/templates/citygml-create-solitaryvegetationobject-with-implicit-representation#description

I'm an FME newbie and am trying to do the equivalent of a join in GIS, where I have a key field in my source data and a key field in my joining data. The issue here is that the fields in these layers are of different data types (source = int, join = char). I tried to use the featurejoiner for for this, but no joined attributes came across in the output. I'm assuming this is because they are of different data types. How can I get around this without having to write a new dataset that has the char attribute converted to int as an intermediary step? Is there a way around having to do this?

Hi all,I would like to: list feature classes/layers from a file geodatabase. Sort. Keep first N tables and drop the rest.  All is good till dropping the tables . So my question is how to drop a list of tables in a File Geodatabase I looked at SQLExecutor and there is no option for Esri File geodatase. In the geodatabase writers you can only "Drop and Create" tables. This example seems promissing, except I would need to update the User Private Parameter with an sql of tables to drop, and it does not seem to be working in that direction : workspace variable => Published Private Parameter. Or does it?https://gis.stackexchange.com/questions/251542/how-to-delete-a-single-feature-class-from-a-geodatabase-using-fme Just to mention that in this example, if I hardcode the Published Private parameter with list of tables to drop it works"FME_SQL_DELIMITER ; DROP TABLE first_table; DROP TABLE second_table;"  All suggestion are welcome and thanks in advance

I am looking for suggestions on how to create Response Areas based on a Road Network and Station Points.  For example:DATA INPUTS:1) Greater Geographic Region Polygon - basically the greater region of interest.2) Road Network within Geographic Region - network has topology, along with speed and time cost attributes.3) Station locations - they may or may not fall exactly on the network. How can FME take the Greater Geographic Region and split it into sub regions; one region for each station based on the drive times out from the station. The result is a Station Response Area.

I am reading a CSV file. The data does not have a header record and in the Fields setup of the reader I select None for the field Names Line (default is 1.) The data preview shows the first record being read at that point. However, when I save the reader and preview the data it starts at the 2nd record.

I'm looking for some ideas on the best way to update an existing SDE feature class that I'm using as a reader in my workspace. Let's call it FC 1. It's a compilation of active and inactive parcels. I'm using FC 2 as a reader as well and I need to compare the two feature classes. If parcels have been removed from FC 2, then I need to update a field called "Inactive" in FC 1 to "YES". So as I'm writing it out, how do I get that end result to also be the reader for the beginning of the process? This is something that will run nightly. Thanks in advance for your ideas!

How to read a csv file that is inside the Tableaut panel on this website below: https://www.saopaulo.sp.gov.br/coronavirus/isolamento/