FME Form

Hi, Im struggling a bit with finding nearby points to another point layer. I want the Neighborhoodfinder to find the two closest points within a distance. The output file only includes the nearest point even though I have set the neighbors to find parameter = 2.  I want the output file to include the two closest points and their distance. Any suggestions?Thanks in advance!

I have a shapefile with numerous columns that I need to calculate a mean for on a row by row basis. Within the data there are a lot of values equal to 0 that are skewing the mean - how can I set up a calculation in the ExpressionEvaluator to remove the 0's from my calculation?

Hello , i have around 800 tables at my oracle database and I would like to ask if there is a method that I can find which tables has the same object id .i think ,if I read each table then use feature merger between one table and others and so on .it will take time is there a quick method that compare between all tables and eachother to find which tables has common id and show me the name of tables that has common id.my target to find the name of tables that has common id.FME 2021  

I have set the timeout to 1800 seconds but i fails after about 10 minutes. I have asked the guy who administers the webservice and he says that on the API side it seems to go well and it sends the response after about 12 minutes. I have attached the log file of me trying to run the httpcaller. Edit: I can see that i some months ago made a similar thread, so if you (administrators) prefer I can delete this and respond in the old one.  In short I was asked in that thread wether I was sure that there should be a response, and I am sure of that. Sorry about the double post! Kind Regards Rasmus Raun

Hello everyone! I struggle with understanding how ArcByCentrepoint (and Circle) are implemented in AIXM 5.1/GML. I ingest exactly the same dataset in FME and QGIS. However, in FME everything looks correct whereas QGIS butchers the geometry. I tried this with class C airspaces around Munich and other airspaces. The system behavior is the same regardless of the airspace. These discrepancies are not just ugly, but they also lead to partially invalid geometries. I have attached example screenshots.In FME In QGISI believe that these discrepancies may occur due to each application utilizing a slightly different projection, e.g. UTM, AZMED, AZMEA, and other local coordinate reference

In Ideas @bilal​ said "One of the benefits of having a creator attached to such a transformer is the ability to define the order that the creators run in a workbench." https://community.safe.com/s/bridea/a0r4Q00000HbroNQAR/dont-require-creator-for-transformers-that-read-data How?

We are running desktop and server at version 2022.1.2.0 (20220831 - Build 22627 - WIN64). One particular workbench that we published runs to completion in desktop, but fails in server. I've checked some other cases and articles (such as this one), but none of the causes (including available memory) or workarounds seem applicable.When reviewing the job's log it seems to consistently fail at this step:156 2023-5-4 15:09:41 | AttributeFilter_NBI <MISSING> Transformer Output Nuker (TeeFactory): Cloned 0 input feature(s) into 0 output feature(s)157 2023-5-4 15:09:41 | AttributeFilter_NBI <NULL> Transformer Output Nuker (TeeFactory): Cloned 0 input feature(s) into 0 output feature(s)158 2023-5-4 15:09:41 | StringForma

Hello,I have a workbench that uses a tester to copy files into a folder and zip them based on the create date. This works fine however after I have the files in the new zip file I can't seem to figure out a good way to then use a FTP caller to upload the files since you can't do anything after you have used the filewriter. Looking for ideas of how to upload this zip file to an FTP in the same workbench?    

Hello FME Community,Although I was very happy to have successfully used HTTPCaller for the first time by writing the data to a CSV file, I seem to be stuck in using HTTPCaller to read the data from the "_response_body" to continue the processing. I can see the data loaded in the "_response_body" but I couldn't manage to pull it out to continue the processing (tried FeatureReader, TempPathnameCreator, AttributeFileWriter). I always fail to pull the data. Can anyone help me out with an example of usage? I read the documentation, forum posts and other internet posts but I still fail to use it as exemplified below. Basically, I would like to replace the CSVReader (below) with the HTTPCaller data, as to load the data automatically and not have to download manually the CSV file every time.

I have tried using the combination of this transformers to discard or filter out compoundCurve geometry but the issue still persist I would like to find a way to discard these geometry ("CompoundCurve".) to avoid the WB stops when I am inserting data to postgis table. GeometryFilterGeometryValidatorArcStrokcerGeometryRefiner

Hello, Recently we attempted to adopt single sign-on through our Windows AD. However, we are having difficulties getting it to work. I have followed the steps outlined by: https://docs.safe.com/fme/html/FME_Server_Documentation/AdminGuide/IWA.htm It worth noting that we have also switched our server to using HTTPs Whenever a user clicks "Use windows credentials" they get an error "Login failed, please try again". Its worth noting if a user manually inputs their AD credentials, the login is successful. When checking the fmeserver.log file I do see the message "Unauthorized request by user <User> due to lack of proper permissions or the object does not exist." I have also noticed that when using the generate token URL:

I was experimenting with the OSM PBF reader, and I noticed that I get different results when I filtered on the Map Features vs the Feature types. In my sample data, if I selected building in the OSM Map Features, it read in 47691 features.If on the other hand I left the Map Features blank and selected building in the Feature Types to Read, only 45050 features were read in.Thoughts on why the mapping is different?  I assume it has something to do with Multiple Map Feature Resolution, and I would expect extra features if it was set to Duplicate Features, but since it was Use First, I&

The List Date in the bottom photo contains a field called ListDate which is stored in a SQL database. We're using their WFS to download the data however due to the validation in Pro we can't see any date fields so we're using FME. I'm trying to use the transformer 'date time converter' but I get the prompts asking which fields I want & as you can see the software is splitting out 1 field into several which are all 'missing'. Which list elements should I select? Also in the select list elements box what number should be entered there? I just need the date so can strip out the time element. 

I am trying to write a bunch of shape files to a geopackage but am getting a strange error.  'OGCGEOPACKAGE writer: sqlite3_exec(CREATE TABLE "table_name" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL' There seems to be a problem when the writer constructs the primary keys for the database, but I have no idea how to address this. There is no id attribute in the source data, I actually tried adding one and the writer handled this by changing the name of the primary key to id_0. Still got the same error though. I am using fme_feature_type to set the table names and schemas.

Is there a similair function as DateTimeNow() which takes only the current date and not the time part? I know I can make use of Timestamper but I'm curious if there are other even more simple ways of naming by date in the writer using Date functions.

Has anyone got a method to rebuild a flattened json file using the dot notation? Essentially it would be the JSONAttributePacker but with a iterative approach?

I have upgrade from FME 2016 to FME 2021.2.When I am running the FME script, if I don't give source dataset in SCHEMA READER then I am facing "No Schema Dataset found" issue. But the same script runs fine on FME 2016. I think FME 2021.2 is not accepting empty string (i.e. no dataset) as input.Is there anything I can do to fix this issue ?

I get this error periodically when running a workbench copying from Oracle to SAP HANA. Only a handful of tables here and there, I've yet to establish a pattern. There are no issues with the permissions, and no queries left in the tables on the Oracle side, as far as I know.

I have many vue 3D model, how to convert them to fbx, so i can use it to many applications.

Hello,I have several website from which I need to read data, mostly stored in tables.For the public website, no issue as I am using I am trying to reader 'HTML Reader'.For the secured website, the sequence would need to navigate first to the login page, (https://members.embuild.be/fr/user/login)enter credentials, navigate to the secured page containing the desired table and read the html table.After reading several posts, my designed workflow would:HttpCaller URL: https://members.embuild.be/fr/user/login, method: POST with body 'Mulitpart / Form data' and the upload: Name - Type - Value = name - String Upload - my@email.com and Name - Type - Value = pass - String Upload - myPassword.HttpCaller (En Serie from the first one), URL:

Hello there I have a published workspace that generates WebSocket stream, and I need to consume the data into ArcGIS geo event using input (subscribe to an external web socket for JSON ) I cannot figure out the URL structure that should be used to expose the WebSocket stream to an external app.   This web socket configuration and this is the Geovevent configuration. Note: I need the correct URL to put in the (remote server websoket) filed

The Reading JSON tutorial demonstrates using Feature Reader to fetch and parse data from a bare url. However I need to fetch from a url that requires a token in the http header. I've used HTTPCaller transformer to do this successfully and I have json data in `_response_body`. However when I feed response body to FeatureReader it treats that as a *path* and not *content*. (It took me hours to figure out this what the error message meant). How do I read the `_response_body` from the http call as *content*? https://community.safe.com/s/article/json-reader-configuration

I have a shapefile with 1000 polygon data and shapefile includes 50000 unique lines. I want to connect both lines that are inside the polygon. I used the spacialfilter but it couldn't detect properly endpoint of the lines which are inside of the polygon

Having issues with info being extracted into the CLOSED 45 DAY attribute-that is created with the ATTRIBUTE CREATOR. Thanks for all recommendations.

To create a web service for CKAN connecting to the Open Canada server, I have tried various permutations around https://open.canada.ca/data/en but no luck. Thanks!