General

I am reading many jxl files. Each jxl has a "CoordinateSystemRecord". 1 for each file. howver this is not a standardized CS as recognized by fme.It has an attribute for ZoneName which is a text value like "New Mexico East 3001" and a SystemName attribute like "US State Plane 1983". How can I use these to set the coordinate system value as the file is read?i currently have the coordinatesystemextractor transformer in my wb. but the value is empty. 

I'm trying to process multiple features (OBJ files) through the same transformer (Rotator). The default workbench is set to start with Reading all the features one by one and applying the transformer. Only after the reading and transforming is complete, starts the writing. how to make each individual Reader-Transformer-Writer process to finish, before continuing to the next one?

Hi everyone I am trying to use FME for a project where I upload GIS data into Minecraft. However, to do a test run I download the maze game on the FME website just to see how the software works. The thing I am stuck on is that I don’t know how to get the FME file into my Minecraft game. Any help would be greatly appreciated!

I have 3 shapefiles and and 1 spreadsheet I need to import into 1 PostgreSQL/PostGIS table ADM1_area (Shapefile) is linked to the spreadsheet via a name column however due to differences in spellings this may need manual intervention How Do I bring up both the Shapefile name column and the spreadsheet name column and where necessary manually map the values across the two? for instanceMyPlace = My Place (Or one source might have diacritics ) This is probably a manual process as REGEX would take to long The preferred name spelling will then map to the name column in PG table and all other spelling concatenate to a list in alt_names column  The other 2 shapfiles are ADM2_area and ADM2_pointthese form 1 database row that has both geometry and point_geometry columns and are linked to the ADM1_area row via ADM1_name column this needs to be the same name used before and may need intervention When I created the PostGIS connection I could only see how to had 1 geometry column not two? T

I have 2 point shapefiles having 1 common ID but there is some shift between them, I want to calculate the distance between the points with the same ID, how should I do that? I tried some methods but they didnt work out, please help !

Hi! I'm using the HTTPCaller to get records from CSW. I'm using POST as HTTP Method and posting:Request URL: https://www.geonorge.no/geonetwork/srv/nor/csw-dataset<?xml version="1.0"?><csw:GetRecords xmlns:csw="http://www.opengis.net/cat/csw/2.0.2" service="CSW" version="2.0.2"    resultType="results" outputSchema="csw:IsoRecord" startPosition="1" maxRecords="1000"><csw:Query typeNames="gmd:MD_Metadata"><!--            <csw:ElementSetName>brief</csw:ElementSetName><csw:ElementSetName>summary</csw:ElementSetName><csw:ElementSetName>full</csw:ElementSetName>        --><csw:Constraint version="1.1.0"><Filter xmlns="http://www.opengis.net/ogc" xmlns:gml="http://www.opengis.net/gml"/></csw:Constraint></csw:Query></csw:GetRecords>The thing is that I want maxRecords to be 10000 to get all records. Max records in the database is between 7000-8000 but I want to build this for expansion.When I'm setting max

So in the Coordinate System Gallery, one can see what units that coordinate system uses (ex: foot, meter, etc.). I need to access the unit of the picked system programatically so I can perform conversions if needed, but I don't see this information available as a feature attribute or property. Is this possible in any way, perhaps with some custom python? Thanks.

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

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

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?

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

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 DynaWriteChannel::putFeatur

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

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

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