FME Form

I am reading a table in from a Microsoft SQL database with a MSSQL_ADO Reader. The table has longitude and latitude attributes, read in as float data type. I would like to write this table into a geojson format, where the geometry of each feature is defined by the longitude and latitude coordinates. I have tried using a VertexCreator Transformer, but when I then write the table to a geojson, the geometry feature is null in the whole file. What do I need to do so the geojson writer writes non-null geometries?

I have two scenarios; In Column A, I need everything before a set of string, and in Column B, I need everything after a set of string, by using StringReplacer. Below is an example of what I am trying to do: COUNTY OF PRINCESTONREGION COUNTIES OF LAMBERSON Column A: COUNTYREGION COUNTIES Column B:PRINCESTONLAMBERSON in the StringReplacer, I have the expression ^.*\\ OF for everything before \\ OF ,*$ for everything after Based on a previous forum https://community.safe.com/s/question/0D54Q000080hTpzSAE/how-can-i-remove-everything-after-in-fme-using-string-replacer  The result of this is that there are no changes to the strings, as everything before and after the ' OF ' remained in the columns. 

If the measure value provided beyond the min and max, it would snip to a point as indicated in the log file: WARN |@Snip (or FMELine::snip) was given Measures of 123625.0508 and 123625.0508, which are out of range for a line with min/max measures of 2.1792075131088495e-6 and 79907.89199766226. Snapping params to closest valid value.Can Snipper be set to reject the input?

I need export ESRI SDE Raster-Dataset and Raster-Catalog to tiled GeoTIF. The ESRI Conection File to the DB run in FME :) . I need the setup for FME and how can i save direct (not first in temp. on C:user: ... I have not space on mashine :( ) I nned save in a extern drive.

I'm looking to generate the Getis-Ord GI* statistic in a workbench hosted on FME Cloud. I believe this can be achieved with an Rcaller, or by calling certain python packages.  Is it possible to install R, or non-built-in python packages on an FME Server instance hosted in FME Cloud?

Hi, We use FME Desktop 2021.1We read and applied the exact procedure found here, for single tenant application (custom Client ID):How to create a Sharepoint Web Connection (safe.com) However, when all the steps are followed, when we test the connection, we have an extra window asking for user authentification. However, the aim would be to use this webservice without the user to be identified : this way, the script could be executed by anyone.Moreover, when trying to identify with my personnel Azure account, it says that the approbation from an admin is required, so that FME can access the resources.Is it possible to overpass this authentification? Thanks a lot !

I'm trying to speed up the processing speed. There might be a few different ways to do this. I'm trying to make incremental changes to a workspace and every time I run it, it takes about 40 seconds. I have two tables in ArcGIS and I use a FeatureJoiner to join them in FME. One of the tables has a data field. I'd like to only process a range of dates. I have about 8,000 records total and I'd like to limit it to 1,000 or so records. Once I get my workspace functioning correctly, I'd like to remove this date range limit. I'm very new to FME.

Hello, After upgrading FME Server from 2019 to 2020 on Linux, i do have this message when i try to launch an FMEJobSubmitter : 1062021-8-5 17:39:57 | FMEServerJobSubmitter (ServerFactory): https://myserver.fr - Failed to submit request to run workspace 'Integration_Classeur_Affaire.fmw' in repository 'Affaire'1072021-8-5 17:39:57 | FMEServerJobSubmitter (ServerFactory): Reason - unable to connect to FME Server 'https://myserver.fr' Regards,Stephane

Hi! I have a question that I can't figure it out myself. I have a CityJSON (v1.0.1.) building data set which contain surfaces with type both "RoofSurface", "WallSurface" and"GroundSurface". How can I read or filter my data based on these types? Does FME support this when processing CityJSON, like it does for CityGML? I have tried eg. to extract geometry parts and deaggregate buildings, but none of these helped. Thank you a lot!

I have a user parameter getting a string of comma separated words. I would like to use that as items/arguments to filter whether or not a feature attribute contain one of those words. It would be to be used on about 10,000 features eventually with maybe up to 5 different words I can get the user parameter to a list, and then to an attribute, but I can't find a way to use those to filter my dataset, either using Like, In, or Contains Any idea how this can be done?It's basically to filter whether a path does or not contain some words

I have a bunch of records with a GroupID attribute on them. Some GroupIDs will only have a single record/geometry, while others will have multiple records/geometries. When I use the Aggregator, it aggregates ALL the records, even the ones that only have a single geometry part.How do I either aggregate only the truly multipart aggregates or deaggregate only the single part aggregates?

I am wrapping a standalone python script in a python creator and seem to be running into an issue. The script runs fine when I run it in IDLE. However, I am experiencing an error in my workbench when running the creator.  Error - error - `fme' instance does not have a method `input(self, feature)'. fme.input(self, feature) must be defined.  Script - # Import system modulesimport sysimport stringimport osimport arcgisscriptingimport loggingimport logging.config class fme:  def main():    logging.basicConfig(     filename=r'\\\\maphub-amer-vfs.azure.chevron.com\\MapHub-NA\\ETL\\FME\\SJV\\TEST\\Projects\\iDOT\\Common\\Scripts\\NetInj_NatNbr_Clip.log', filemode = 'w',     format='%(asctime)-6s: %(name)s - %(levelname)s - %(message)s')    logger = logging.getLogger('NetInjectionClip_log')    logger.setLevel(logging.INFO)      try:  # Create the Geoprocessor object      gp = arcgisscripting.create()      gp.overwriteoutput = True       logger.info(&qu

One of our technical directors wants to know more about FME, what it is / isn't, and what it does / doesn't, etc. Basically a quick overview of FME that shows off its capabilities. He's signed up for Introductory training, but I feel that that's too detailed and too technical for his position.I read about FME Accelerator. What exactly is that, and who is it for? Would that be suitable for senior management, or is it still pretty technical?I find the Accelerator web page a bit too vague (https://www.safe.com/accelerator/)

Now and then I have a need to postprocess data written by a FME Server Data Download Service. In good old days (FME Server 2015) it was possible to do this in the Python Shutdown Script. Nowadays the results are obviously auto-zipped by the writers when running the Workspace on FME Server as a Data Download Service. I have not yet found any way to postprocess the results, as they are already zipped and the result filename is unknown (in the Workspace) when the writer has finished its job. My simple example substitutes some text in the file written by the FeatureWriter. This is necessary because of some limitation in the Writer itself. Everything works perfectly well in FME Desktop. In FME Server, published as a Data Download Service, the AttributeFileReader does not find the file returned by the _dataset attribute in the Summary port. Obviously because it is already zipped and removed by the Writer. Any ideas?

I am trying to export to a geojson file (to upload to Mapbox). Unfortunately, 5 out of my 736 features have a type of GeometryCollection. The remainder of the features are MultiPolygon and Polygon. Mapbox is unable to work with the GeometryCollection. I tried using a GeometryCoercer with the Geometry Type set to fme_multi, but all of the features go through the Untouched port. I also tried running the 5 through a GeometryRefiner. This converts 2 of the 5 to MultiPolygon, but I can't seem to get the remaining 3. I have been trying to figure out how to use the GeometryPartExtractor, but I can't seem to get the syntax correct (this is all quite new to me). I'm also wondering if my lack of understanding of the Geometry XQuery syntax is the reason I can't get the GeometryCoercer to work. If anyone has any experience with this, I would greatly appreciate the advice. Thank you.

Hi,is there an easy way to straighten a line. i have created a shortest route on a grid, now i want to straighten this line as it is indicated in the picture. best with 90 degree anglethanks in advance

Hello, I have a single line, and also a set of 16 points that lie along that line.  I need to split the line into 16 different segments that start/end at these points. I found PointOnLineOverlayer that does this, and even mentions being able to apply attributes to the segments.  Its working perfectly to split the line up into segments, the problem I'm having is that those segments don't seem to be taking their attributes from the points that split them, but instead are taking them from the original line, and so the attributes for each segment are identical. How can I apply an attribute from the points to each corresponding segment of the line?

Hi FME'ers,I am using the HTTP caller to download multiple CSV files to a folder. I'd like to zip the folder and output the zip folder path as a single features to a automation writer. Can this be done? The automate writer would then trigger a second workbench to read all the CSV files and process them. I don't want to automation writer to trigger this workbench per file. Thanks, David

Hello i have Columnname A and B.I read the Excelfile with a FeatureReader. Get Columns A and B.Now i close FME. Rename Columname A to C in the Excelfile.Open FME. Read the Excelfile. Get Columns A and B instead of C and B.Why does FME cant see my renamed Column C and still sees Column A wich doesnt exist anymore?

Hello i want to change the Columnames based on the first value.Example:Column: Afirst Value: DognewColumname: Animal

While connecting to MongoDB Atlas I'm getting error TLS Handshake failed. However, when connecting via MongoDB Compass, the connection is successful.  Attached is the screenshot of the error. Could anyone please share MongoDB Atlas is supported via FME? If yes, how to connect to it? Best,Sarthak

I have DGN data with and without GRAPHIC GROUPS for Line,Point,Texts,Hatch,Polygons. I want to extract separately only graphics groups elements.

Hello,I am trying to convert from revit to cesium 3d tiles using the dynamic schema definition. I remember it working well before, but suddenly this issue comes up. When disabling the revit reader (only one in the workspace, see image below), the error doesn't pop up, but of course, the attributes are not written since no schema is found. Any idea on why this happens? Note: Revit's feature_type_names are separated by a dot character (e.g. Mechanical.MechanicalEquipment) Here is the error:The PERSISTENT_CACHE_NAME directive must be specified when creating a persistent cache.  It's value should be a valid string useable as a subfolder nameError fetching dynamic schema definitions from reader `REVITNATIVE_1'. Error reading from `D:\...\plant.rvt' reader.The PERSISTENT_CACHE_NAME directive must be specified when creating a persistent cache.  It's value should be a valid string useable as a subfolder nameMULTI_WRITER: Error fetching dynamic schema definitions from reader 'REVITNATIVE_1'Attr

Hi Guys, New to FME but really enjoying the journey to date. Today I hit my first confusing issue which although I have resolved I am pretty sure they must be a better way. I had:Created an MSSQL tableCreated an FME reader which detected the schema including attribute types and so forth.Did some processing and wrote to a file geodatabase. But:I then made some minor changes to the underlying MSSQL table i.e. changed text to decimal etc.However the reader would not detect these changes. I had to delete and recreate the reader for then changed to be detected. Is there some easier method which I am missing to get the reader to detect changes to the table schema in the database? Apologies in advance if the solution is simple but I am missing it! Thanks,Barry.

I have data that would need to be loaded into different tables. But I need to load them to load in a specific table order because of foreign key constraint. I have put on a connection runtime order which only controls the very next transformer. One of the data paths has a statistics calculator so i thought if i put a statistics calculator on the path that needs to be loaded last, this would give me the order I need but they are still going first.The first 2 are going in at the right order. The 3rd has the statistics calculator. It also has a tester where only the records that passed will be in the statistics calculator. The records that failed do not need to go anywhere. Also, all records can fail the tester. In that case, no related IDs are created for the 4th table so then the Foreign Key Constraint is not violated.I added 2 feature Holders and 2 statistics calculators on the 4th path hoping the 3rd path will finish first, but the statistics calculator for the 3rd path would stop, an