Best Answers

Dear Sir / Madam, I have an indoor data set. As shown in the figure below.  Red line represents network path.Blue circle is the POI (Point). Black dot is just the vertex. As I have an indoor data for the entire building. I would like to find network that is unnecessary (not linked with any POI), as shown as Yellow Circle. I am just wondering what transformers I can use to find these path?I cannot just simply break the lines as some vertex are necessary for turning. I would really need some hand. Thank you very much!

Basically, I want to match meter IDs from two different datasets: shapefile and excel file. Meter IDs in both datasets might have typos such as dashes, dots, letters, slashes, which I need to remove first. Then I want to match MTR_NO from Excel against Mother_1 , Child_3, & Child_4. My idea is to export an excel table that will include only matching meter IDs.   

is there any reader where i read the Google analysis data ?

Hello , i am using Esri feature service reader to read map service but it does not work with me .when I click on layer to show them ,it is written that token error ,499 error i have admin user and keyword but it does not work to access .could someone advice me ,how could I read map service from ArcGis server ?

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?

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

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?

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.Below, the successful usage of HTTPCaller, but with a resulting file.Many thanks for your time,Robert  

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. 

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.

I'm an FME newbi. Feel like it's something very basic but couldn't come up with a solution on my own.What I want to achieve is to get 80% of the value from column B to column A, but some of the features have multiple values separated by a comma, soo they come out as NULL. I went through previously asked questions but couldn't find anything. Appreciate any help! 

I would like to extract 'Orientation' >>  Plz any idea what setting i use so that i could see those value in table in filter the data according.  

Hi everyone!In order to reduce increases, we want to move the FME Server in the cloud, currently on the AWS platform, to the Digital Ocean platform.The best options are installation on top of Linux.I know FME will work great with Linux, our problem is that we work continuously with ESRI systems (sde,gdb), and I know it requires an ArcPro or Enterprise license, at least on Windows.Is the situation similar in Linux?I ask, because ArcGis Pro does not have a Linux deployment option.Would appreciate help!Thanks!

Hi FME Community,I have an error when trying to replace some geometry from GML encoded geometry with the GeometryReplacer transformer :xml-donut Geometry Builder: unable to adopt the below geometry because construction for its own geometry has already been finalized+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `'Attribute(string: UTF-8): `fme_geometry' has value `fme_polygon'Attribute(string: UTF-8): `fme_type' has value `fme_area'Coordinate System: `'Geometry Type: IFMEPolygonName(UTF-16LE): `surfaceMembers'Boundary:   Geometry Type: IFMELine   Number of Coordinates: 5 -- Coordinate Dimension: 2   (1.2582468599656544,45.82094218175942)(1.2582468599656544,45.82094217549903)(1.2582638025631208,45.82094217549903)(1.2582638025631208,45.82094218175942)(1.2582468599656544,45.82094218175942)The cause seems to be multi-polygon geometries. However, the GML syntax seems correct (I can visualize it with Data Inspector tool) :<?xml version="1.0" encod

I can read this geojson below in fme.  In this example (I & J) at the end of the string Fjson&I=800&J=422It will give me back a responds.However looking to loop through all possible values of I & JImax=1073&Jmax=571 = 612683 values. where I and J is a variable in the geojson string. xxx/geoserver/ows?SERVICE=WMS&VERSION=1.3.0&REQUEST=GetFeatureInfo&BBOX=50.46754657502329877%2C-1.82577500000000015%2C51.03245342497670123%2C-0.76422499999999971&CRS=EPSG%3A4326&WIDTH=1073&HEIGHT=571&LAYERS=public%3Axxxxxxx&STYLES=&FORMAT=image%2Fpng&QUERY_LAYERS=public%3Asolent_currents_direction&INFO_FORMAT=application%2Fjson&I=800&J=422

We have processes in place for ArcGIS Enterprise patching but none for FME Server.  Occasionally there is a hotfix that is released that is security related. Or last month there was an update from our vendor on their website related to CVEs and upgrading. Is there a central place that we can get this information from? Preferably without having to do a manual check on a website page etc.  I have signed up our support email to the Stay Informed email list on safe.com/downloads. Would this email list suffice or are there any other feeds that we could check in relation to security patches?

Hello , i have to write my output from ArcGis sde to excel file .but I have empty fields at many columns. i would like to have only fields that have only values .so how could I remove empty fields ,?i have read many topics about that but it does not work with me .could someone provide me with template workspace to remove the empty fields .Thanks in advance FME 2021

Hello i am reading many tables from oracle non spatial tables name Table_ATable_B Table_Ci have around 30 table and I would like to get the Output from all tables when Id= 45 i am not sure ,how to write the condition in where clause to test it in all tables and In case it did not find the id in any table so I will not get any output from this table .But in case also ,no id as attribute name in any table so I get nothing better than error ,if it is possible .Fme 2021 

@takashi I have a list of Hotels. I need to check spelling is correct or not. As I am new for FME & Python, could you please help me. Thanks

I'm creating a cruciform for biodiversity monitoring and I'm having trouble setting the distances from the centre. I need to do this for 50+ areas so it would be good to get some batch processing going.The inner nodes start at 5m from the centre. From then onwards, they are set at 10m intervals. Each arm of the cruciform is 45m long. So there are five nodes on each arm resulting in a 90m total length on the x & y axis.Node labels are as follows: 5m, 15m, 25m, 35m, 45m.The problem is, the southern, eastern and western arms are showing the distances backwards i.e. 45m label starts at the inner node and the 5m label is at the outer node.The workbench works as follows:Calculate centre point of areaCreate vertices around centre point so LineBuilder can create 4 x arms of cruciform( N,S,E,W)Create points on lines using DistanceMarkerLabel points based on Counter The northern arm always seems to come out correct so it must be something to do with line/point orientation. I have tri

I have got 8 coordinates and I wanted to extract mid-point / center point that has XYZ of EACH side of surface of 3dCube .  Please highly obliged with your help or input  

Hello, See picture below for example, I wish to remove the green vertex while ensuring that the end point vertexes remain.  I need to remove these as they are treated as being stacked, which is causing major issues with my ESRI Utility Network Model.  These points are within < 0.001m of each other. I have tried using a generalizer, which is not appropriate for this situation, as the lines become much too generalised. I wish to only remove these vertexes that are treated as being stacked upon each other.  I have also tried using the geometryValidator -> issue to detect: remove consecutive points without success.  What other ways can I remove these points? I have thought about creating a custom set of transformers that could do the job, i.e. Find all vertexes -> identify any vertexes that are connected to other Line st/end points or any devices (as I want to keep these) -> find vertexes that are within 0.001m of each other -> single match these -> output. Although with

Hello, I have configured FME-Server for httpS. following this description https://docs.safe.com/fme/html/FME_Server_Documentation/AdminGuide/configuring_for_https.htm. But now is the file upload no longer working. "There was an error uploading the file"(https://docs.safe.com/fme/html/FME_Server_Documentation/WebUI/Uploading_data_files.htm) Any help is highly appreciated. Thanks.

Hi everyone,We are using this web connection MS Graph Type Application https://hub.safe.com/publishers/supporter/web-connections/microsoft-graph-type-applicationWe have the required details below: - Tenant-ID- Client-ID- Client SecretHowever, this keeps expiring every hour and we have to re-authenticate every time. Screenshot of the expiry time below:Is there a solution to this? There are other articles about Microsoft Graph Teams but the configuration is different.In our configuration, we keep the default setting and I notice the grant_type=client_credentials. 1. Do we need to ask our Cloud team to grant us a refresh token & grant_type = refresh_token?2. Also, do we need to ask them to add the fmeoauth URL to the Redirect URI in the MS Graph App like how we normally do with other Oauth2 App?If these need to be added, should they be mentioned in the hub?Many thanks!

Hi, We have been trying to set up a process where our users can email their files to a shared mailbox and FME can extract the attachment &  process the attachment  from emails in our FME server fault tolerant deployment without success as neither STMP nor IMAP option is possible. Our IT  tech lead wanted to check if we can use EWS with FME server. I have read an old thread that this can be done through XML & httpCaller but I couldn’t find any further details of how to set this up. I also saw there is the Microsoft Graph API option and wonder if it’s recommended. Our IT Tech lead prefers EWS as we have another application that was already using EWS. Would be much appreciated if you could point me to the right direction.Many thanks!