General

To put this into context I have a google sheet which has hyperlinks to photos. It shows the shared link but not the filename. I need to be able to extract the filename (and ideally the directory path from Google drive) so I can relink the photo to the new location. Hope this makes sense

FME 2020: Which tool can be performed to display where the lines overlaps (duplicates) are, I couldn’t figure out Which tool can be performed to display where the lines overlaps (duplicates) are. For example, in the screenshot below, there are 4 lines and overlapped in the place marked in orange. How this overlap can be displayed? the data is attached  

FME 2020: How to get lines extended to centers of circles? In the screenshots below, this is how surveyors draw parcels. What I wanted here is to extend the lines that touch the circles to their centers so that all lines get connected at these centers How this might be performed in FME? Which tool can help on this?Sample data is attached   

I have a shapefile, it is all lines with only two points in each line. Ultimately I'd like to expose the X and Y, start and end, of each line. CoordinateExtractor seems to be able to expose the X and Y of all the points but is there a way to filter that list, like Start X, Start Y; End X, End Y?

I'm trying to create a validation routine that tells me what points are not in their expected polygon. I have two tables with an areaid common to both- one has point geometry (building b) and the other has polygons (area a). something along the lines of the following badly phrased pseudocode!select * from building where building point does not exist in area and a.areaid = b.areaidAll help appreciated! Thanks in advance

Hi Community, I have a road network where roads are defined in road classes (1-5). While comparing the road from two different geometries(local and client), I need to upgrade my road network on the basis of client's road class. In the image attached, the yellow lines are road class 4 and grey ones are road class 5. So, I need to upgrade road class 5 to class 4.In the image shared, the one selected road element (in cyan), needs to be upgraded from the top (hanging geometry) to till the yellow line in the down south, and rest all data remains same.In other situations, one side of the road can be a hanging geometry, so the road selection can be unidirectional to bidirectional. But, the upgradations has to be limited to only one road class update (4 to 3, 3 to 2 etc.,) This is because road class 1 (road of international importance) can directly only be connected to class 2(national/regional importance) and so on. So there has to be a chaining logic where I can select the road elements

Hello, I'm trying to extract data from Oracle database with several thousand tables to CSV files.Because of the number of tables, extracting each table to CSV file is not an option. Is there an automated way to read the list of tables from Oracle DB (non-spacial) and extract each table to CSV files? I haven't been able to find any articles or forum questions to do that. Any help will be appreciated. Thanks.

Hello,I am extracting data from a sql DB and exporting as file geodatabase. But when I compare them in Arcmap the data is not aligned it is next to each other but not on top of each other why would that be? I have same projection on both the data sets. ThanksNikki

 I have a .csv table with 35 numeric values in increments of 5 (5, 10, 15,..). I need to create a table that list all possible unique pairings of these values in two columns ((5,5), (5,10), (5,15),...) . I've tried joiners, mergers, and combiners but can't get the output I need. Is there a transformer that would do this?

Hello, How can i get the attachment of a AGOL layer to the Emailer transformer? Keep getting errors...Please help :)

I find it very difficult to explain in a few sentences. I never know how to comprehensibly explain what FME does/can do, without giving a 20 minute monologue on all the possibilities I can remember at that moment. So what do you say when someone asks you what FME is?

This translation Parameter Values box has started poping up when i run the translation. I have set the prompt & run to No  and purged the temporary files but this still pops up when I run the translation.  Where do I turn this off please?

Is it possible to incorporate a parameter in a spreadsheet to be used with a dynamic schema in a feature​ writer?​We want to be able to use a parameter to name the output feature class i.e. line_$(date) but also have that match to a schema table?

Hi,Can anyone please help me on how to normalize a set of greyscale images using FME ? (Transforming the scale range of radiometric values to the [0,1] interval) thank you very much

Hello everyone, I need to extract data from a json file. The problem is that I cannot use json extractor becuase the format of the json is a pit different. Can anyone of you guys help me with this?. I have attatched an example of the json file. I need to get all values under "attributes". When I try to extract the needed values I get an empty fields. @takashi​ I hope you have sometime to have a look 🙏 Kind Regards,,,

I have a survey123 application. i am trying to connect the feature class connected with this application in ArcGIS Online to my local database. For this i am using FME Workbench. I have previously conencted Arcgis online feature class using fme desktop and it worked fine. This time however i am getting the following error. ArcGIS Online Feature Service Reader: Could not find a Feature Service item matching the Feature Service directive I am using FME 2020.1When i added the AGOL reader and chose this feature class i am getting column names in reader which means it is able to connect to feature class, when i press the see source data on reader I can see the data as well. It gives me error when i run the FME even if i don't have any transformer and just inspector.

I am extracting two attributes ( Naam, Value) from a json file. The contents of the "Naam"attribute are actually attributes names and the contents of the "Value"attrbute are the values. So what I need is to transpose the "Naam" attribute to columns and fill those columns with the content of the "Value"attribute (see attachments). I have tried attributepivoter and also attribute Transposer custom transformer. Unfortunatley, I keep getting nothing useful or empy output. Could you please help me with this!

We have a directory of AutoCAD drawings depicting building interiors. This directory is considered the source of truth for interior spaces and the GIS team has created World files for each one. Other departments take these drawings and add their own data on top of it. An example of the data would be the locations of drinking fountains, emergency exit signs, and wifi access points. They maintain these drawings in their own department directory and did not copy over the original world files.Here is the question: when the GIS dept places the original WLD files in these dept directories and bring the data in, there are instances where the location is not the same as the original drawings. Most are, but not all. Instead of creating custom wld files for these (there are 1000's) is there a way in FME to apply the characteristics of the original drawings to the new, department-specific, drawings to the data is in the correct location.I did my best to try and describe the situation bu

Hi everyone I have an issue when using a series of XMLAppenders to combine various XML fragments into 1 document which is causing one of my namespaces to be removed and then prefixes to be added to my elements. The first appender works as expected, but then the subsequent one seems to remove one of the tablespace names, and then cause all the existing elements from the document XML to then get the prefix “rsml”. The XML fragment in the 2nd appender doesn’t get the “rmsl” prefix however. I then use a 3rd appender and again this new xml fragment is added fine but still the original and 1st appended XML still have the “rmsl”. My original XML document has the following 3 namespaces:<railsysml version="0.7" extension="4" xmlns="http://www.rmcon.de/XMLSchema/railsysml/2019/infrastructure_0_7" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:rsml="http://www.rmcon.de/XMLSchema/railsysml/2019/infrastructure_0_7"> 1st appender –

I would really appreciate some help with the process I am trying to write.  I have a shapefile of routes, I need to create a GPX file for each route. However what I am stuck on is why the 'elevation' tag in the GPX is blank and I need to fix this. I assume I can use PointOnRasterValueExtractor with the Terrain50Raster which I have in a raster GRID file? The routes will change so I need the process to be repeatable on a regular basis hence why I am trying to do it the 'correct' way.  Many thanks

Hello there we have a large dataset of Point cloud for an entire city, is there a way we could split it into small sizes in order to work with it in FME we try to read it using FME but its taking long hours Thanks 

I'm working on updating an (old) workflow that was made with at least version 2018 (but could be earlier) to 2020.1.2.1 (20200909 - Build 20624 - WIN64) . Both in FME 2018.1 and 2020.1 this flow and its Custom Transformer work like a charm. When upgrading a ListConcatenator in one of the transformers from version 2 to version 3 it stops working. I also checked in 2018 and it had the same problem so it is not just my 2020 installation. I'm getting the following error:2021-01-08 13:10:44|   0.6|  0.0|ERROR |@Tcl2 -- failed to evaluate expression `set Titelblok_koppelen_validatieRegels_en_TagValidatie._ListConcatenator__separator [FME_DecodeText {<comma>}]; regsub -all "{}" [FME_DecodeText {_list<opencurly><closecurly>._listTags<opencurly><closecurly>}] [FME_DecodeText {<opencurly><backslash>d+<closecurly>}] Titelblok_koppelen_validatieRegels_en_TagValidatie._ListConcatenator__listPattern; set Titelblok_koppelen_validatieRegels_en_TagValidat

How is this done? We want to define the services and dependent connections once in a single place and have all the FME Desktop users use this single known and tested working good copy. And then when that authoritative service or connection is updated a way for the desktops to fetch the refreshed configuration. The doc pages I've read so far only talk about a one at a time process.https://docs.safe.com/fme/html/FME_Server_Documentation/WebUI/Web-Connections.htmhttps://community.safe.com/s/article/Web-Connections-and-FMEhttps://community.safe.com/s/article/fme-server-troubleshooting-connections-web-and-dat

Hello everyone, I have road that I have aggregated based on the number of lane. I would like to split the untouching feature. In arcgis, that would be singlepart to multipart. Using the deaggregator would only recreate all the feature that I had before.  What would be the process?

Here is the SQL query that I use in SSMS that gets me the XY but I have not been able to translate the query into FME to get the same results."select RiserObjectID, Premise, GEOM.STX as X, GEOM.STY as Y from RiserPrem_NAD27"