General

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

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? 

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

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?

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

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.

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

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.

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 Dyn

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.

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 :)  

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

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.

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.c

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

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!

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

 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

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 in

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!

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

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! 

I am trying to find line geometry that has been changed between two dataset. I know there are minor and major changes (Tolerance set to 0 at the moment). But the result does not make sense to me. Nothing comes out the Updated channel. Just Intersted and Deleted. Does the Change detection transformer work on lines?All the Deleted features come from Original stream. All Reviced come as Inserted.Is it something to do with datatypes?I just did a test and took a feature from the Delete stream and it does exist in both original and reviced dataset.I am matching on a UUID key example: A53B8017-9987-4636-B941-737AF58C5F08 EDIT: Since I am matching on UUID i was not sure FME handel them as strings. But I did a AttributeValidation on Type String and that came out possitive. EDIT: This is the WKT of the objekt with same id, from two different sources.The result is going to Deleted. But as you can see the WKT is identical. Ju

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)

Hello,I am a youth volunteer with a medieval boys camp. Since Covid hit, we have not been able to attend any camps for safety reasons. I have been given a DEM and an aerial image of the property where we hold the camp and I would like to build a Minecraft World to scale, so we could attend virtually. I found some info about how to use FME to translate the DEM into a Minecraft world, but I need help. Is there someone or some way that you could use your software to help us create this? I am an expert with Minecraft but as a 15-year old, I have no idea how to use FME. Thanks For Your Time, Kaleb McNeil