FME Form

Hi, I have bottom hole well locations in the attributes of surface hole well locations shapefile. I need to read those coordinates and generate a new shapefile in FME

I'm using an SQL Creator to return data from three tables (Microsoft SQL Server), one of which contains a geometry column.  Initially, I was just joining two tables and this all worked as expected with the geometry being correctly displayed within FME. When i amended the SQL to include a third table, the geometry column seems to have stopped being interpreted as geometry and is now displayed as an attribute containing binary data.  A bit more investigation, if I limit the fields being returned by the SQL creator, the geometry is interpreted correctly (bottom SQL creator). If i attempt to return all fields (explicitly naming or using *), the geometry field is returned as an attribute   Additional information, only the table I'm attempting to get the geometry from has a geometry column. Am I missing

Hello, here is my question. I have two table. The first table is like a glossary. The second table is the input data.​Table 1 (glossary)​Number Fruit1-1 banana;apple <= (meaning can be either banana or apple)1-2 orange​Table 2 (Input data)Number Fruit1-1 banana1-1 apple​So my goal is to see if table 2 match with table 1. I have a input data (table 2). Both are number 1-1 and the fruit name also match with table 1. Hence, both the result should be passed.  However, I am not sure how to do the matching. As the table 1 fruit name is "banana;apple", separating by ";". I would like to have some guidance. Thank you very much!​

Hello friends,Im a new user of FME. I have a dgn file with hundreds of points with or without tags. i need to convert this dgn to shp with unique custom ids. Is it any procedure or transformers to do this in fme. I mean each point have unique id numbers I tried with many videos and tutorials didn't solve my issue thanks

I have two variables within a script tag in the head of an html document.What's the best way to extract those two variables?Both variables are json data.  In the end I want the geojsondata and I want to add the metadata to the geojson data. I can extract the strings for the variables using regex, but is there something better to read javascript? 

When I am translating Smallworld 4.2 using a seed file that has a coordinate system set the file that is created does not have a coordinate system set. If I create a file from within Microstation using the same seed file the new file does have the coordinate system set. I verified that during the translation using FME the correct Seed file is being used. I then created a translation of a V8i Microstation file translating to another V8i Microstation file using the same Seed File and the coordinate system is unset in the created file. Am I missing some kind of setting? or is there a know problem with Coordinate systems and Microstation files?

Hello! I am using FME Desktop 2021 and I have constructed a workbench that reads a CSV file with one column field. Each CSV row is a text string, which represents an XML document. It is used as an FME attribute inside a SOAP request template (XML template) to download and parse an XML document. However, the XML document could be referencing other XML documents via their respective text strings. If I extract these strings from the XML response, is it possible to feed them back as an input for my workbench and download them before moving on to the next CSV record? Apologies if the question sounds unclear, I can provide more info if needed. Any suggestion would be highly appreciated.

Hello,  FME Desktop 2019.2.3.3 Build 19825 Win64 I'm getting a few issues when using the Directory and File Pathways reader to get the subfolds in a directory.  I have a Published Parameter that is set up for File_Path input. If I put a path with a space in the name I'm able to see all subfolders when running in FME Desktop, but once I write to csv the file paths are truncated to only show the path up to the first space. Example:  In FME Desktop I see this: \\\\unc_path\\a\\b\\a b c Here's what the csv output looks like: \\\\unc_path\\a\\b\\a  That led me to try and add double quotes "" "" around the path in the P

Hi, I'm looking to update a value of an existing JSON structure once it has already been constructed.I feel I'm using JSONUpdater for its correct purpose, but might be messing up the syntax. Attached is how it looks for me:Does this appear to be the correct syntax for trying to modifying a nested key/value pair?I also wonder if using the attribute "ProgramProfile" for the JSON Text field would be a better approach, as it does show up in the list of selectable attributes. I have not had luck with this approach either though. JSON sample being used:{   "UserInfoList" : [      {         "IntegrationUserID" : "123456789",         "UserProfile" : {            "FirstName" : "Johnny"         },         "ProgramProfile" : {            "UserCategoryName" : "PLAC

Hi, I'm fairly new to FME. I'm curently trying to set up a workbench that reads data from multiple sources and merges it. However, I have to be able to work repeatly within a specific extent which is provided with a shapefile (see pic below). For now, I just wan to manually input a shapefile with one feature ( hopefully I manage to find a way to loop the procedure with many features but that might be for another question). Right now, I can't seem to be able to pass the extent coordinate (which I get from a BoundsExtractor) to the search envelop of a FeatureReader. This post (https://community.safe.com/s/question/0D54Q000080hXiFSAU/assign-bounding-extents-to-reader-search-envelope) talks about using spatialFilter after the Feature Reader but that means I have to read ALL the data and then filter it (which I do

Hello all,Since updating to FME 2020 (FME(R) 2020.0.1.0 (20200407 - Build 20218 - linux-x64)) the columns filter in the data inspector table view does not work most of the time.When clicking on the "Columns" button then selecting some columns to display, on clicking "ok" the columns displayed in the table view are filtered to what appears to be a random set of columns. eg. After selecting the following in the column selector:  Clicking ok results in the following columns being displayed in the table view: As can be seen, they are not the same columns. This happens most of the time, though it does occasionally work correctly. I do not know what is different when it does work. This happens when Data Inspector i

I received a sample data file from a client who wanted me to convert all their files from CGI's OMS .gis extension or called the M3i format, data is for Electric utility. Though you can open the file in Notepad++, I tried to read it as well using Json Reader to be able to extract the attributes and geometry, but it seems it's hard to interpret the data structure from inside, to be able to parse it.. I also found this Safe webinar slides (here) talking about this format, and it looks like t's supported FME format thoughhere's a snippet of how this file looks like:GIS M3I standard data, version 1621295625593D702{GEOMETRY{SYMBOL{default;361368.971591387;194906.787360248;1;178621295625593D702{CONNECTIVITY{NODE{621295625593D702C1;621295625593D702C26212956

Hello, I'm using a WMS Reader to convert the wms to mbtiles. The workbench is called repeatedly for all my polygons (Bounding Box) with "FMEServerJobSubmitter" from a second workbench. The first conversions run succesfully but after a few iterations the process stops with the error:    HTTP/FTP transfer error: 'SSL connect error' Please ensure that your network connection is properly set up |No proxy settings have been entered. If you require a proxy to access external URLs, please ensure the appropriate information has been entered   The error occurs only in FME Server, in FME Desktop 2017.1 I do not have this problem.

Hello Friends, I'm new to FME.   How can I assign GIS Attribute field types in FME Attributes while converting.While Im converting ROAD_NAMEE given as character, after conversion its came as string in GIS. how can I get the same? PS. Converted from dgn to shp. dgn file elements are attached with tag. please help someone Thanks  

I'm using the EsriReprojector with source RD_New to destination GCS_WGS_1984 and geographic Transformation Amersfoort_To_WGS_1984_NTv2. Later I need my features to go back to RD New so I use the EsriReprojector again with the source and destination switched and the geographic transformation direction set to Reverse. But this gives me a different coordinate system: _Netherlands-RDNew-2008_0 instead of Netherlands-RDNew-2008 (what it used to be). Why is this a problem? Everything is projected with an offset of 100m.  When using geographic transformation Amersfoort_To_WGS_1984_2008_MB in reverse it seems to be fixed. Yet it still gives me the new coordinate system _Netherlands-RDNew-2008_0 Why, how, and will this give me problems when overwriting layers with Netherlands-RDNew-2008?  Any dutchies with the same question? 

hi，everyone,Thanks for browsing my question。I want add below map frame for my polygon,red is my polygon。how I cad export result to cad​.​

Hello friends, I’m new to FME. I have two dgn files for roads. One file for the central line of roads with all tag details. The other one is a new file, filled roads (create as region in microstation) based on the center line file. I would like to combine these two files and the output should be only one shp file. Not required the center line on the final shp. All tags should be as attributes in shp. Only the tags to copy from centerlinefile to new file which is falling on the top of the filled shapes. (like spatial join in GIS) Using Products : Microstaion SS4, FME Trial Thank you Chithra

Hello FME-Users,I have a problem with my CityGML Data. I want the final results to look like clean OBJ Files. When I load them into e.g. 3Ds Max they should have no errors. I also do not want faces to be seen in my 3D software. Instead I would like to see proper polygons (if quads are possible, I want to see them; they can be made out of triangles, but these triangles should be hidden).I found this image on Wikipedia showing the different possible Elements of a mesh:   My current FME workflow looks like this:  I have buildings made out of 3 elements: Groundsurface, Wallsurface and Roofsurface. I would like to bring all of these together as a mesh (with polygons). I used the GeometryCoerc

We all want better performance from our workspaces and often that comes down to our design. Sometimes very subtle design changes can produce a big performance difference and this is one example of that. Workspace ComparisonHere is a workspace that renames incoming attributes with the AttributeManager:  That workspace takes 1.1 seconds to run. Here's another workspace that produces exactly the same output: Instead of using the AttributeManager to rename the attributes, they are renamed on the writer schema and a value assigned to it. That workspace takes 5.5 seconds to run! ExplanationSo the second workspace is five times (is that 500%?) slower. Unsurprisin

the AreaOnAreaOverlayer efficiency is very slow compared with arcgis,is there any other replace?

Looking to use these building footprints from Google, and they're in a format I haven't heard of before, a 'spatially sharded CSV'. Has anyone ever worked with this dataset or know how I could read in the spatial data? Here's more info from the page at Google Research: Building polygonsBuilding polygons are stored in spatially sharded CSVs with one CSV per S2 cell level 4. Each row in the CSV represents one building polygon and has the following columns:latitude: latitude of the building polygon centroid,longitude: longitude of the building polygon centroid,area_in_meters: area in square meters of the polygon,confidence: confidence score [0.5;1.0] assigned by the model,geometry: the building polygon i

We just upgraded from 2018 to 2021 and like the new option of "Streams". Using this for a RabbitMQ job and working great! But my question is around creating a stream for a job without a stream mode transformer.  The documentation says the following: "The workspace must contain a transformer that can run in Mode: Stream" This made me think it would not work, but tried it in place of a job we currently use the "Run Until Cancelled" option with and it seems to be working fine. The job is just constantly polling a REST API with an HTTPCaller for updates to real-time data (wish the vendor had an event based option but do not).  I like the idea of having all our near real-time integrations running in this separate grouping of streams. And that you can dedicate an engine to it vs. Run Until Cancelled just grabbing any which one and holding on to it. Any concerns with using streams lik

So I was given a workbench that was quite extensive and it has a lot of junctions. These junctions were only added so that annotations could be placed on a specific location for readability. This doesn't sit well with me because feature caching is on and the workbench is prone to memory issues already. Also, I don't like the cluttering. But it makes sense to get the annotations where you want. However, after reading several posts it is still not clear to me whether junctions add to the cache or not. Can somebody tell me whether they do add to the cache or not?

 I have the following installed:ArcPro 2.7.4ArcGISDesktop 10.8.1Background Geoprocessing 10.8.1FME 2021.2.1.0 (20211203 - Build 21797 - WIN64) I also have a workbench that used to work. It simply took a couple of old-school Esri SDE features plus two new-school features that have attribute rules applied on them, and therefore need ArcPro Translation turned on, which it is, and exported them to a file geodatabase. What used to work now gives me the dreaded "Unable to perform any licensing related tasks. Please check your Esri ArcGIS Compatibility setting. This 64-bit version of FME requires ArcGIS Desktop along with 64-bit Background Geoprocessing; ArcGIS Pro; or ArcGIS Enterprise" error. What else do I need to look for?http://fme.ly/qua

Dear Community, I have the following issue: My ultimate goal is to build a CityGML file from roof polygons. To build the buildings and separate the walls and stuff is fine. But the buildings are commonly have structures (as I call roof on roof structure) above the roof. I'm able to project the roof - and roof on roof's roof - to the ground, but then I receive this: What I would like to achive is kind of this:This seems kind of hard to me. I read over the whole forum, but no sign to be able to cut the roof on roof's wall with the angled roof plane. Also extrude would not fit, because t