Skip to main content
  • EN

General

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

  • 4,033 Posts
  • 13,782 Replies
4033 Posts
clemensb
Contributor
clemensbContributor
asked in General
FeatureJoiner unjoined Features

Hi,I have two Tables GDB_Grund and GDB_EIG, where I join with the field EZNR with the FeatureJoiner. Now there are two unjoined features from the right(GDB_EIG) with EZNR= 651241256. I know that this is not possible because every GDB_EIG has at least one match, so I checked with the SQL manager and in both tables this value exists. So I used the FeatureManager and there were all Suppliers used, but this is super slow. I created a new Workspace with two Tester which passed only EZNR=651241256 and used the FeatureJoiner again. Here they are joined. Same reader and I copied the FeatureJoiner from the other Workspace. What is going on? Why are there 2 UnjoinedRight with the FeatureJoiner?I am using FME 2019.2x64

444
clemensb
Contributor
3 years ago
ninixink
Contributor
ninixinkContributor
asked in General
PythonCaller works fine with FME desktop but failed with FME Server

Hi,I am having issues with PythonCaller (using arcpy scripts). It works fine on FME Desktop either on my local machine or server machine, but it failed with FME Server. FME Desktop 2020.1.1.1 Build 20614 - win64FME Server 2020.1.1 Build 20608-win64The script is used for updating features from one gdb to another gdb (delete features in one gdb first, and append newly updated features from the other gdb)import osimport fmeimport fmeobjectsimport arcpyimport os.pathfrom pathlib import Path # Template Function interface:# When using this function, make sure its name is set as the value of# the 'Class or Function to Process Features' transformer parameterdef processFeature(feature):    dataset= str(feature.getAttribute('Features'))    Souce = "\\\\Mydirectory1\\DATA.gdb\\"+ dataset    Feature_Class_to_Update = "\\\\Mydirectory2\\Land\\"+ dataset    Empty_Features = Feature_Class_to_Update    Updated_features_in_VIEW = Empty_Features # Process: Delete Features    arcpy.DeleteFeatures_managem

787
clemensb
Contributor
3 years ago
lambertus
Enthusiast
lambertusEnthusiast
asked in General
Keep only part of string matching Regex

A dataset of 900 records contains a string attribute. This string varies in length and contains always a X- and Y-coordinate. Example:":5.781699137962022,"rijksdriehoekX":181934.095,"rijksdriehoekY":474580.092,"rijksdriehoekZ":0 I just want to get the part in bold and created a Regex to select this part. My idea is to replace the complete string and just keep the string part with the coordinates (bold part).  My Regex: rijksdriehoekX":[0-9]{6}.[0-9]{3},"rijksdriehoekY":[0-9]{6}.[0-9]{3}Any ideas how to solve this issue? 

10354
lambertus
Enthusiast
3 years ago
dmerrick
Contributor
dmerrickContributor
asked in General
FME Workspace for multiple spatial file types

Hi,I am trying to set up an FME Server App that accepts multiple spatial file types (json, kml, shapefile) as a "file drop" from the non-FME user, to then spatial filter against hundreds of "footprints", to then email the user back a email with the zipped "footprints".I am having an issue creating a workspace with multiple feature readers that, when published, doesn't end with a fatal error because a single reader cant read the input file. My workspace starts with a creator going to the multiple feature readers (kml, json, shapefile), they all go into a spatial filter against the "footprints". The Feature readers all have a Published Parameter for the file to be read, the workspace parameter is to "Continue Translation" for rejected features.Thanks! FME(R) 2020.0.3.0 (20200605 - Build 20252 - WIN64)FME Server 2020.0.0.1 Build 20202 - win64

634
dmerrick
Contributor
3 years ago
markcoopersdc
Contributor
markcoopersdcContributor
asked in General
Database Updater Crashing FME

HiI am running a workbench and the database updater transformer seems to crash FME every time. I was using FME Desktop 2020.1 but have now updated to 2020.2 but the results are the same. Is it likely I am doing something wrong, or is it a known issue?

31
chrisatsafe
Contributor
3 years ago
M
mathias.h
asked in General
Calculate volume from pointcloud

Hello, I have a pointcloud scan of a underground tunnel. I would like to calculate its volume. Is this possible? I am guessing I first need to make a water tight mesh out of it. Kind regardsMathias

711
kailinatsafe
Safer
3 years ago
dbaldacchino1
Contributor
dbaldacchino1Contributor
asked in General
Coordinate System lost after using GeometryReplacer (GeoJSON)

So I am noticing that after using a GeometryReplacer, the coordinate system property is lost and gets set to "Unknown" if I first extract with GeoJSON encoding and replace with it later. Is this to be expected? For context, I have a feature with Coordinate System LL84. I used a GeometryExtractor first (GeoJSON encoding), then replaced the geometry with a BoundingBoxReplacer (coordinate system is retained), then replaced the geometry and that's where I noticed the coordinate system being lost. If I use FME Binary encoding when extracting, the coordinate system is retained after replacing geometry. I don't know enough about coordinate systems but thought that the coordinate system should be preserved without having to re-set again, regardless of the encoding used. Thanks.

394
dbaldacchino1
Contributor
3 years ago
LizAtSafe
Safer
LizAtSafeSafer
asked in General
What's Up Wednesday: FME News for the Week Ending 19-February-2021

Welcome to the 26th edition of What’s Up Wednesday! It’s already been half a year of your weekly FME News. Let us know in the comments about your thoughts on this weekly update. Do you like it? Want to see something more specific? Tell us your thoughts.  We’re Hiring! Are you an FME Server Guru and live in Canada? Apply to become a Technical Support Specialist (or as we like to call them Experts). We’re also hiring for other teams as well, so check it out!  Gartner Peer Review ResultsThank you to all who submitted a review back in October! The results have been published if you’d like to check them out.  BlogIf you use ArcGIS Online, check out this blog post about how to integrate FME and ArcGIS Online. This post features a real-world example about mapping COVID-19.  FME 2021 BetaThe release of FME 2021 is fast approaching! Now is the time to put the 2021 beta to the test with your workflows. Download the beta today and try out new features or hunt for bugs. Report any issues you may f

30
LizAtSafe
Safer
3 years ago
S
safeonx
asked in General
Can I use FME desktop with any third party server, lets say we are creating own instead of FME server will it work. If yes what modification or do safe provide the API.

Can I use FME desktop with any third party server, lets say we are creating own instead of FME server will it work. If yes what modification or do safe provide the API.

71
redgeographics
Celebrity
3 years ago
masonb12
Contributor
masonb12Contributor
asked in General
Fatal error when writing a shapefile to an sqlserver database

Hi, I am getting a fatal error when I use a shapefile reader and an sqlserver writer. I am simply trying to create a new table in an existing sqlserver database. The projection is LL84 in the shapefile. I can select the database in the writer, so I know there is a connection. Any advice welcome. thanks, Here is some of the log file: TABLE SDF_2_Schema.[SHIM_STREAMS_line] ([Name] varchar(254), [Url] varchar(254), [Key] varchar(254), [Autogenera] integer, [GEOM] geometry)'. Provider error `(2760) The specified schema name "SDF_2_Schema" either does not exist or you do not have permission to use it.'2021-02-14 14:15:26|  1.1| 0.0|ERROR |Microsoft SQL Server Spatial Writer: Failed to create the destination table for feature type `SDF_2_Schema.SHIM_STREAMS_line'2021-02-14 14:15:26|  1.1| 0.0|ERROR |MSSQL_SPATIAL writer: A fatal error has occurred. Check the logfile above for details2021-02-14 14:15:26|  1.1| 0.0|ERROR |auto __cdecl DynaWriteChannel::putFeatur

106
masonb12
Contributor
3 years ago
F
fmesafejde
asked in General
Unable to connect Delete Writer to Reader

HiAdded Reader to extract from Access db source and then insert into destination SQL db (right hand side) and it worked fine:Wanted to add a writer to delete all db records (on the far left) before the reader. However, unable to connect that writer to the reader. Any advice on how can I execute that Delete Writer before the Reader? Thanks.

62
F
3 years ago
hugues
Contributor
huguesContributor
asked in General
Export excel with source

Hi. I've export table in XLSX writer and i want that excel sheet have the name of the table ( not the complete path of source). I know it's probably easy but i can't reach my goal.Thank you for help :)  

111
danilo_fme
Evangelist
3 years ago
ronnie.utter
Contributor
ronnie.utterContributor
asked in General
[Solved] Export attributes and value from JSON that are not in the documentation for the output but exists in the query

Edit: The DateTime did exist in the output in the "Time" attribute as a ISO8601 format.  Problem.I want to add starttime and endtime as attributes to the export. I have a working simple workspace that reads a JSON from: https://earthquake.usgs.gov/fdsnws/event/1/query?format=geojson&starttime=@Value(date_sub)&endtime=@Value(date)  where starttime (value) and endtime(value) are in the format "yyyy-mm-dd" and is created as FME parameters.  The string original looks like thishttps://earthquake.usgs.gov/fdsnws/event/1/query?format=geojson&starttime=yyyy-mm-dd&endtime=yyyy-mm-dd I am exposing the attributes I want with attribute exposer and it works at it should according to the documentation "GeoJSON Summary Format (usgs.gov)" The starttime and endtime attributes is the date window where I want to read the event data from USGS.  So I guess there is timedata from the earthquake event that stores the date when its monitored. That is the data and

407
ronnie.utter
Contributor
3 years ago
cwisse
cwisse
asked in General
To decrease the size of a CityGML-file, I use a coordinate rounder to limit the decimals, but the CityGML-writer adds the decimals back to the coordinates. For example: after the coordinate rounder 440879.7927, after the writer 440879.7927000031.

To decrease the size of a CityGML-file, I use a coordinate rounder to limit the decimals, but the CityGML-writer adds the decimals back to the coordinates. For example: after the coordinate rounder 440879.7927, after the writer 440879.7927000031.

20
cwisse
3 years ago
boubcher
Contributor
boubcherContributor
asked in General
Extract specific text from doc

Hello there, I need to extract a all text between   var layer = L.geoJson and addTo(map)  from the below structure,any suggestion, please  <!DOCTYPE html><html>  <head>   <title>Report</title>   <meta charset="UTF-8">   <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css" rel="stylesheet">  </head>  <body>   <div id="mapHTMLReportGenerator_41" style="width:100%;height:500px;"></div>   <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/leaflet/1.3.4/leaflet.css" />   <script src="https://cdnjs.cloudflare.com/ajax/libs/leaflet/1.3.4/leaflet.js"></script>        <script src="https://unpkg.com/esri-leaflet@2.2.3/dist/esri-leaflet.js"></script>   <script>     var map = L.map('mapHTMLReportGenerator_41').setView([0, 0], 3);           L.esri.base

63
J
3 years ago
C
cardiofaz
asked in General
Python Exception <ModuleNotFoundError>: Error when attempting use Sharepoint connector in FME Server but works in FME desktop.

Hi all, I am running a workbench which I have scheduled in FME Server. The workbench when running from same location in desktop works fine. The issue seems to be with the sharepoint connector. I use this to download a specific file. When it tries to connect to it, I get the error below, any ideas what that might suggest for FME server?  2021-2-8 22:15:04 | Python Exception <ModuleNotFoundError>: No module named 'fmepy_microsoft_sharepoint'902021-2-8 22:15:04 | PythonFactory failed to load python symbol `fmepy_microsoft_sharepoint.connector.SharepointOnlineConnector'912021-2-8 22:15:04 | Factory proxy not initialized922021-2-8 22:15:04 | SharePointOnlineConnector_CALLER (PythonFactory): PythonFactory failed to process feature932021-2-8 22:15:04 | SharePointOnlineConnector_CALLER (PythonFactory): A fatal error has occurred. Check the logfile above for details

462
C
3 years ago
J
julpet
asked in General
Is it possible to see the complete flow of mapping attributes through a third file/system?

Hi, I am stil quite new to FME Desktop. I want to map my data/attributes through a third file/system. So it should be always comprehensible how the different attributes are called in each file/system (see screenshot). So far, I mostly used Reader/Writer but each of them has either just an input or just an output. I also couldn't find any transformer which allows me to do that. I hope the screenshot makes clear what I am looking for. It's actually just the functionality of "System2" (receiving input, having own attribute names and sending the output). So I can see the whole flow and just convert them with transformers. Thank you in advance!

65
chrisatsafe
Contributor
3 years ago
I
ianmtq
asked in General
Cut polygon to the wanted length

Hello, I would like to cut multiple polygon the wanted length. I was wondering if there was a transformer or multiple transformer who would do the same operation on polygon as a line divider can do to line feature.  Thank you

282
I
3 years ago
R
rhona
asked in General
I'm trying to extract spatial data from Oracle to an ESRI file geo database in ireland 1965 tm 29902 projection but it writes out 29903.

 Even when I specify the projection in the writer it writes out to ireland 1965 29903.  Any ideas how I fix this? thanks in advance Rhona

63
jovitaatsafe
Safer
3 years ago
C
christianlendl
asked in General
How do I tile a citygml-file with 3D-geometry?

Dear FME community,I have a question dealing with citygml files. I have several hundred xml-files formatted in citygml. These xml-files have information of the buildings of a city stored in them. It is a 3D model of the city in the level-of-detail 2. So there are ground-surfaces, wall-surfaces and roof surfaces of the buildings stored. Each surface has the right coordinates. A group of 4 xml-files will create one tile with a size of 2x2 km. I want to create my own tiles and decide by myself what size I want to use. So I have loaded all xml-files inside FME and I have managed to create obj-files with small circles. Each circle represents the center-point of a ground-surface. For the tiling process I extracted the center-points and tiled the resulting point-cloud using the “tiler”-transformer. Later I placed a circle on each point with the “bufferer”-transformer since I could not export the point-clouds. Then I created the obj-files. Now I wanted to combine the information of the obj-fil

250
C
3 years ago
E
eva218
asked in General
I need to use a form of testing based on the outcomes of another transformer

The image in the annex shows my workbench. This is the result that can be seen in ‘Passed from Tester_2’:NAME ; DBKOrganisation X1 ; 111Organisation X2 ; 222 This is the result that can be seen in ‘SQLCreator_3’:ID ; OWNER_ORG ; CLIENT_ORG ; MONITOR_ORG1 ; 111 ; 111 ; 3332 ; 222 ; 222 ; 2223 ; 333 ; 444 ; 5554 ; 333 ; 222 ; 3335 ; 444 ; 555 ; 111 I would like to use a transformer that uses the results from ‘Passed from Tester_2’ to check if one of these DBK values is present in the organisation columns of result ‘SQLCreator_3’.So I need the transformer to select ID 1, 2, 4 and 5. But not 3 as Organisation X1 and X2 is not present in one of the three organisation columns.  Can anyone explain to me how I can do this?Thanks in advance!

54
chrisatsafe
Contributor
3 years ago
C
clive-s
asked in General
Set the dxf_entity values

Greetings, I am exporting data from an ESRI File gdb to DXF files (fanned out). I would like to update Entity values from a list, rather than opening the DXF in a text editor and manually updating the values.The format is:1001ACAD1000type=NTI want to set the values to:1001Trimblearea1000dxf name (sourcelayername) I would appreciate anyone sharing any pointers or a simple workbench, that illustrates this. Regards, Clive

20
C
3 years ago
alc33
Contributor
alc33Contributor
asked in General
MapTExtLabeller - problem NET framework

Hi!I have a question. I would like to test MapTextLabeller but on the transformer I have an error message :"Failed to load label-EZ plug-in. please ensure .NET 4 is installed"On my machine I have the version 4.8.Do I have to install the version 4 or it supposed to works with this version that is more recent?Thanks! 

10
alc33
Contributor
3 years ago
demix
demix
asked in General
Web Connections - Access Token Response as XML

Hello everyone, I've recently been doing some work using HTTPCallers to connect and authenticate to an API. The basic flow is that the first HTTPCaller hits the login endpoint. The credentials (username & password) are passed as application/x-www-form-urlencoded values. An XML response is sent which contains a Session ID. This is then passed through to all subsequent HTTPCallers via the header as Cookie - ASessionID=<Our session ID>. This all works very well, but I've been asked if I could move the whole authentication part into a nice secure easy to use Web Connection. I've done similar before, so thought this would be a fairly easy task, but alas, I've hit a bit of a wall when it comes to the Access Token Response. Unfortunately, the login call to this particular API only returns XML and will not return a lovely JSON response for FME to parse and handle. I was under the impression that FME should be able to look at a JSON or an XML response, but I'm having no luck.  Is ther

651
demix
3 years ago
cbalmbra1
Contributor
cbalmbra1Contributor
asked in General
Continuation of feature counting

I am looking to see if there is a method of setting a 'continuation' for counting features in FME.Essentially I have 300 features with a UID of a simple number (1,2,3 etc). I wanted to see if there was a way for when I add additional features into the mix, the UID would automatically populate continuing with the next available UID (i.e. 301)

122
caracadrian
Contributor
3 years ago

Badge winners

Show all badges
30,017
Posts
Terms & ConditionsCookie settings