FME Form

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 does not contain an Umlaut. I use the tran

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/overview but i am getting authorisation errors - HTTP/1.1 401 Unauthorized Here are the paremeters as i have set them At 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/@name When 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.6 Can 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 LL84 b. 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 guys im 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?

Hello everyone, I am currently working with .DGN files. My goal is to create a new DGN file with new values in the "igds_cell_name" field. I would like to know if it is possible to modify the "igds_cell_name" attribute value??? Because at the moment,

Hi, I'm looking for some additional explanation on parallel processing using the workspacerunner transformer. There's 20 batches of GDB-data (all separate gdb's to prevent locking). When I use the workspace runner to use 1 workspace to run 4 parallel instances using different input and output geodatabases (no locking is occuring) for all 20 batches something goes wrong. I cant tell what is causing issues because the logs are incomprehensible. Does every instance keep overwriting the log file? I see that it executes the command to run in a rapid order while each feature is expected to run around 5 minutes. After waiting and seeing all FME processes finish in my Task Manager i only see around 4 output geodatabases made. I need to see: 20. However: I tried to fix it. I use Text-reader and Text-writer to create 1 .fmw for each batch: so 20 fme models. I use each model 1 time in each parallel process. Meaning: unique input gdb, unique output gdb, using unique fme workspace. This way: i have