- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
General

General

A read-only category for lost FME Form topics. We hope to move them shortly.

4,032 Posts
13,815 Replies

When you subscribe we will email you when there is a new topic in this category

4032 Posts

How to find points that aren't in a polygon (but they match on an attribute)

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

Chaining Logic to Select Same Group Roads And Upgrade

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

3 years ago

colasamkContributor

asked in General

Is there a automated way to extract data from multiple Oracle tables (thousands) to CSV files?

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.

Data doesn't align after export from SQL DB to File Geodatabase

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

3 years ago

gcarmichParticipant

asked in General

Create a table with all possible pairings of numeric values from input table.

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?

FME AGOL attachement to Emailer transformer

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

390

3 years ago

ingeContributor

asked in General

What do you guys say when you're asked: "What is FME?"

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?

How to turn off the Parameter Values prompt when running translation

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?

1090

3 years ago

deanhowellEnthusiast

asked in General

Using parameters with schema from table

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?

3 years ago

lianaolianov

asked in General

Normalizing greyscale images

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

270

3 years ago

mdaContributor

asked in General

How can I extract de data under attributes section in the JSON file?

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,,,

How to resolve "ArcGIS Online Feature Service Reader: Could not find a Feature Service item matching the Feature Service directive"

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.

2200

3 years ago

mdaContributor

asked in General

How can I transpose a column which was extracted from a json file?

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!

How to inherit AutoCAD placements

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

3 years ago

stephstedmanParticipant

asked in General

XMLAppender causing one of my namespaces to be removed and then prefixes to be added to my elements.

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 –

Creating GPX files with elevation

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

610

3 years ago

boubcherContributor

asked in General

reduce point cloud size

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

270

3 years ago

jeroenContributor

asked in General

Upgrade problems ListConcatenator: @Tcl2 -- failed to evaluate expression

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

220

3 years ago

mattwilkieSupporter

asked in General

Synchronizing web services and connections between FME Desktop & Server

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

Singlepart to Multipart

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?

I have a SQL spatial table extracted from our GIS that contains a GEOM field in projection NAD27. I need to generate an XY for these values from this GEOM. Everything I’ve tried, I don’t get the output I need. Please advise.

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"

3 years ago

phoolish_one

asked in General

Use FME Desktop to produce CIM XML

Hello Everyone,I am trying to produce a CIM XML document with FME Desktop. I found an example template here: https://community.esri.com/t5/electric-documents/sample-common-information-model-cim-xml-data-translation/ta-p/913831 The template is complex and I can't find any documentation on it other than some comments in the workspace. Are there any other documents related to the template, or a good resource for learning how to use FME for CIM XML? Thank you.

620

3 years ago

zzupljaninContributor

asked in General

Getting FME_Encoding_Argument_Exception when writing XML file with Text Writer

Hi, When writing XML as Text Writer I'm getting __FME_Encoding_Argument_Exception__ only in my output file. Literally only this set of string. Why is it happening and how to solve this issue. I'm using FME 2016.1

3 years ago

familiahihihi

asked in General

Workbench shp to s-57

How can i transfer shp to s-57. The shapefile has attribut "Wasserstnd" with value 1 or 2 or nothing. The result must be slcons with attribute watlev =4 , if Wasserstnd is 1 or slcons with attribute watlev =3, if Wasserstnd is 2 or slcons(not specific value for watlev), if Wasserstnd has not value. How to make the workbench? Thanks!

I cannot get a proper connection to an Oracle database on FME Server. I suspect it may be a TNS_names problem, but I am not sure. The link in the error is not very specific about fixing this problem on Server. I have a proper published Database Conne

error mesage - 2020-12-17 13:13:41 | Oracle client libraries (e.g. oci.dll) could not be loaded. Ensure that the 64-bit client is installed and properly configured, and the PATH environment variable includes the file path to your Oracle client. Refer to https://knowledge.safe.com/articles/FAQ/How-to-setup-an-Oracle-Instant-Client-for-use-with-FME for more information

2250

3 years ago

Page 124 / 162

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.