FME Form

 Hello Group, I manage a large directory of geospatial data, mostly in .tab. But times and needs are changing and I’d like to have the data available in other formats such as shp, geojson and gpkg. In an ideal world we’d have a PostGIS database, but that’s not about to happen any time soon. So, for the time being, and probably into the foreseeable, I will continue to maintain flat files.  In FME Form, I need a process where I can point a FeatureReader at a folder and, in as few steps as possible, write each one to .shp, for example. I need to maintain the name (done so through Accumulation Mode: Merge Initiator and Result, I believe). So, for example a folder may contain 20 tab files (Zones_A.tab, Zones_B.tab, Zones_C.tab etc. etc.). I would want to create Zones_A.gpkg, Zones_B.gpkg, Zones_C.gpkg, but do so in one go. I know I can read in files from a folder (via ‘Select Multiple folders/Files’ in the FeatureReader) and then publish as a different format to the same location (or differ

Dear all, Very simple question (sorry if it sounds naive, I am newbie to FME) : I would like to set to uppercase all attributes that start with a given prefix (or that match a given pattern). Is it possible to do that with the BulkAttributeRenamer ? Or what would be the ''cleanest'' way to do that without using custom transformers ? (NB : I know I could achieve this with a custom transformer (for example, inspired by this question), but I would like to avoid this kind of solution as then I face the tricky issue of having attributes that need to be dynamically exposed and I would like to avoid also the complicated things with schema mapping and so on...) I would be very grateful if you could share how you would implement that 😀 Thanks in advance for any suggestion 

I would like some inputs if possible. I want to write several thousand of rows to a database (each of these rows represent a pdf file). I have created an attribute called 'status' that should have the value 1 or 0 based on whether the particular row has been written into the database. This should be a precaution if FME breaks down. Then it is possible to see which rows have been written into the database and which haven't.  I don't expect a complete answer at all but perhaps just some ideas on how to achieve this. Thanks in advance.

Using the AttributeManager, i understand that i could create a new attribute_alias for each attribute i want to update. However, since there are hundreds of attributes and they all need to be named the same as the existing attribute name - except in TitleCase without underscores > I wonder if there is an easy way to do this?

I have an FME workspace in which input from an DWG file is read and exported into an FGBD file. I am using a dynamic FeatureWriter. Whenever a Text feature is written to a layer whose name contains an Umlaut (i.e. ä/Ä, ö/Ö, ü/Ü), the translation fails with the following error message:"GEODATABASE_FILE writer: An unknown exception occurred" Very strangely, layer names with Umlauts are not a problem for any other feature type, i.e. Point, Line, and Area features all can be written to corresponding layers without a problem. (As another rather confusing side note, Text features can actually be written to layers whose names contain 'ß' which from a technical/encoding point of view should cause the same problems as 'ä', 'ö', 'ü'). Here is a screenshot of my workspace:After reading the features from the DWG, I simply split them by geometry type. For the Text features, the Tester:DOES_NOT_CONTAIN_UMLAUT only lets features pass whose fme_feature_type do

Hi,I have been using FME 2019.1 for some months now with no issues. But strangely now I can no longer view the cached features. I have 'Run' set with 'Enable Feature Caching' but when I click on the green magnifying glass and select 'Inspect Cached Features', nothing happens. There are definitely records going trough these ports... I have probably changed some setting but can't work out what it is!Thanks,

 <mdContact><rpOrgName>AAA</rpOrgName><rpPosName>BBB</rpPosName> rpOrgName is appearing at multiple locations in the XML file.How can I update its value from AAA to CCC for all of them in a single go without having to go to each element using Xpath.

I am trying to connect the odata Equipment API for SAP Hana https://api.sap.com/api/OP_API_EQUIPMENT/overviewbut i am getting authorisation errors - HTTP/1.1 401 UnauthorizedHere are the paremeters as i have set themAt this stage i am just trying to connect and get a token.I am using a HTTP caller as we will be using the odata services to create adn update Equipment and Functionla locations in SAP as an integration between our ESRi Utility Netowrk model and SAP. I have attached the log file.I have successfully connected to and run the get call from postman on the same computer and successfully connected to movebank as per the http caller tutorial.Does anyone have any ideas on what i am missing? doen this before successfully? Thanks  

Hi, I have two polygons dataset. I would like to find the differents polygons between them. In other words, which polygons have in dataset A that do not have in dataset B. In opposite too. I used spatialrelator and PointOnAreaOverlayer already, but no success. Attached follow my datasets. Thank´s

What I want: I want to read a list of pdf files and write metadata of these files to a postgresql database. The attributes I want to export are number of pages, file name, file path and file id (which I create through the UUIDGenerator).  I start with a PATH reader to find all pdf files from this folder through all the subfolders. The problem is I also want to add the number of pages of each pdf file to the output table and I don't think I can find this with the PATH reader.  Therefore I included a PDF reader and have found the number of pages of each pdf. Now the problem is - how do I combine the output of these two readers? I have tried to use Featurejoiner and Featuremerger but both of these requires a common attribute to join on. But I can't find a format attribute in the two readers that is unique. Is there a way to index the attribute tables of each reader? Or is there some much easier way to perform this action?  I have included a screenshot of my workspace until now.

I have a very large 3D OBJ file and wanted to convert to 3D Cesium Tiles. The Cesium Writer only creates to tile outputs that are huge (650-900 MBytes). Is there a way of introducing LOD and enable more tiles to be created with smaller tile size?

 Been trying to get this working for a while, but I have to surrender... My XML:<?xml version="1.0" encoding="UTF-16"?><Surface name="Zone 101_01.01_A_020!" desc="" xmlns="http://www.landxml.org/schema/LandXML-1.2"> <SourceData/> <Definition surfType="TIN" area2DSurf="234921.542328654672" area3DSurf="238197.012906672346" elevMax="11.943587904916" elevMin="-3.839199295337"> <Pnts> <P id="2">214609.472108227172 150506.362479594914 5.162708941504</P> </Pnts> </Definition></Surface>The attribute I need is "Zone 101_01.01_A_020!". Queries I tried:/Surface/@name/string()for $c in /Surfacereturn data($c/@name)/Surface/@nameWhen I test in online extractors, it does work. When I remove the namespace it starts to work, but why?I'm using FME Desktop 2021.2.6Can someone please help?

Does FME have the ability to export Milsoft's Windmil .gdb to an Esri .gdb?

I am trying to connect to a map service hosted on another organization's ArcGIS Server. I have the credential for the service and able to connect through the REST endpoint on a browser. When I try to connect using the ArcGIS Server Feature reader, I get the error that a token is required. I read on community blog that some people had to set up a web connection using a Portal template .It looks like this requires and AppID from the Portal, which I can't obtain since I am no admin and it is from a different organization. What are my options then?  Any input is appreciated! Thank you!

hello , i would like to know if all my data are Esri objects or not How could I do that ?i am using oracle developer , and FME 2021

I'm new here and need to filter data from a Odata feed. The feed contains open data so no need for credentials. When I add an Odata reader and paste below URL, I can choose several feeds. The main one is named: TypedDataSet​https://opendata.cbs.nl/ODataFeed/odata/82062NED​​The direct link to main Odata feed is: https://opendata.cbs.nl/ODataFeed/odata/82062NED/TypedDataSet​It contains data from 2012 tot 2023 April. I only need data from 2022 and higher. I found some tips for filtering like placing?$filter=Perioden gt 2021MM12 but this doesn't work. I think I'm almost there and only need to figure out the right syntax. Can anyone help me?Thanks in advanced!Cheers Richard ​

I have several shapefiles in different UTM coordinate system. I want to:a. reproject each of them into LL84b. Then merge the re-projected feature into a single shapefile I need help in a. Merge features after reprojecting them.b. Find a better way to do it than the way I am trying to do it (see image below). As you can see, I am stuck and I do not know how to do the last part. 

I am working with a forest geopackage, in which small forest roads, rocky areas and other surfaces are not included in the forest layer. What I am looking to do is to make all these spaces part of the forest area. I tried with Area gap and overlap cleaner but I didn't get results, because the problem is that there are roads that I would like to keep as such or other surfaces that I don't want to be converted to forest. Any idea how to proceed?

I have a dynamic workflow that writes spatial data from a MS SQL Server to a postgis database. Since my inital data is not always restrictive on geometry types, I want to ensure that Geometry types are well defined in my destination database. I had an issue with mixed lines and multilines that I solved using an aggregator (destination geometry (multilinestring) ) but I had some geometry collections creating some issues when writing data so I added a GeometryFilter. Visually no feature is filtered (only lines) and the writing is doing great. Removing this filter will make the writing fail.  My question is then : Is the GeometryFilter altering the data or the way the data is presented to the writer? 

I thought I should have two lists, one with the current Xs and Ys and another with the same Xs and Ys and some defined heights as their Zs. And then make some lines between these two lists and after that make the cylinders. Can anybody help me to implement it?

Hi guysim trying to craete a workbench to backup my agol group content into local shapefiles. ideally i want to use _name (feature service name) as folder names so web layers (using fme_feature_type as dynamic shapefile name) goes into each folders by their service name.  however, for some reason the fanout option couldnt work. Also tried to create attribtue with the output file path then use it as destination esri shapefile folder on the writter - this solution doesnt work neither. wondering if anyone know a good practice for this? Thanks!

Hello, I'm currently working on .dgn files  I am using FME to make attribute changes and adjustments. However, I have the impression that FME automatically divides the objects or cells in my plan, as soon as I enter my .dgn data in the script, without any transformers being used...  Here's an overview of the data before and after FME: I also tried using an aggregator. But the objects and geometry in the output dgn file are still not aggregated as in the original dgn file (see the second photo).I would like the geometry of the objects not to be affected. Have you ever had this problem, and if so, do you have a solution to solve it? Thank you in advance.

Hi, I am trying to use the S3Connector to upload/ download from an s3bucket.  Just to test this out i have setup a AWS web connection and i am trying to list all the files in the folder FMS/ I keep getting the following error:S3Connector: There was an error connecting to Amazon S3: 'Failed to connect to proxy URL: . Confirm that your credentials and region settings are correct. Some regions are not publicly available - contact AWS for more information I have played about with the proxy settings but im not entirely sure that is the issue as i have a python script that uses all the same credentials and proxy settings and that works okay. Im on FME version 2022.0 and using s3 connector version 2.1.2 Any advice would be appreciated

Hi there,I am working on two IFC files i.e. version_4x and version_2x3. At some point, I want to get or write this version in database. I failed to find any transformer to read or get the exact .ifc version. Is there a way to do that?