Data

How can I use the Python caller transformer to call Arcpy and run the ArcGIS Repair Geometry tool? I have polygons from a file geodatabase that I'm importing into our Postgres SDE. After loading them, many of the records won't display due to geometry violations. I tried using the FME Geometry Validator transformer in my workspace, but it didn't seem to resolve the issue. Alternatively, is there a way to configure the Geometry Validator (or combine it with other transformers) to repair the data?

The Extension Dictionary information is written using C#, as shown in the picture below:

Hi, im doing a workspace to check DGN files and i would like to see the linear units as shown bellow: Is there any attribute to expose for this or do i need a python script for it? I have checked the DGN readers help page for this but cant realy find anything. Very thankful for any answer.

Hello I have set up a feature reader, reading a geopackage and have also set up a user parameter requesting the GSS code from the user to find. When i add “gsscode” = $(LOCALAUTHORITY) nothing is exited via the reader, however, if i remove the where clause from the reader and add a tester with gsscode = $(LOCALAUTHORITY) everything works as expected. Please see images below, but any ideas what is wrong. I dont mind having a tester, but would just like to remove it and use the WHERE Clause.. Regards Andy Feature Reader Parameter Tester

Bonsoir, Je rencontre des difficultés pour télécharger des données depuis la plateforme data.gouv et des données IGN (BD Topo, BD Carto) via URL en utilisant FME. Je ne sais pas si cela provient des liens url que j’utilise, des Transformers employés, ou des paramétrages de mon workflow FME. Mon objectif Je souhaite récupérer des données exploitables selon les thématiques suivantes : environnement, économie, agriculture, etc. En pj, mes traitements en détails avec des captures. Merci d’avance de votre précieuse aide

Hi, While trying to read a shapefile, I encountered the following error. Has anyone come across this issue? It stopped reading all other files: Shapefile reader: Unexpected end of file reading 'filepath\filename.dbf'. Please report this error to Safe Software GeometryFilter_InputPassThrough (TeeFactory): Failed to get block of 235 features starting at index 0 Failed to get block of 235 features starting at index 0 When I tried using the FME Data Inspector, I received the following errors: Shapefile reader: Unexpected end of file reading 'filepath\filename.dbf''. Please report this error to Safe Software FFS writer: Failed to get block of 235 features starting at index 0 Failed to write feature data to `C:\Users\--\AppData\Local\Temp\FFS_1736990572395_5844_DATA.ffs' Failed to specify the feature index as constraints on the reader Thank you for any suggestions on how this can be resolved. The file is recognized in ArcPro. Thanks, Magda

When reading a file from the web the only options available to configure the client is the Authentication section. In some cases it is needed to tweak some of the client settings in order for requests to properly get though. Sometimes it would be nice to add custom headers or change the SSL settings for example. Of course the workaround is to just stick a HTTPCaller followed by a feature reader, however, this also means that you need to deal with temp files etc etc which just adds complexity to the workspace

I have 3 Excel files and each one has multiple sheets [T1(sheet1, sheet2..,etc), T2 (sheet1, Sheet2,..etc), T3(sheet1, sheet2,...etc). The names of the sheets in all files are identical and the name of the fields in each sheet are identical too but fill with different data. I need to join or merge each sheet from one Excel file with the corresponding one from the others based on a common field (ID) and have one excel file. I did different attempts but I did not get the right results. Could you help please.

Hi all, I’m facing some troubles converting IFC data to Cesium 3D Tiles. Background: I have several IFC files containing mostly 3D objects concerning civil engineering source coordinate system: EPS:2056 different, user-defined PropertySets different IFC versions Goal: Cesium 3D Tiles with all attributes (PropertySets) What I did so far (transformers in FME): Adding a dynamic reader with autodetecting IFC version Extracting PropertySets from Geometry Doing some cleaning on Geometry, i.e. removing extra Bounding Boxes and adding Vertex Normals Scanning the schema Writing dynamically to Cesium3DTiles FME Version: 2024.2.1.0 (Build 24801) Problems: some features are missing I cannot see why some features/objects are missing. They obiously run through all transformers until the writer. There are no errors, only 2 warnings saying: NOT changing coordinate system of reader identified by keyword `IFC_1' from `EPSG:2056' to `IFC_COORDSYS_0' -- mapping file setting of `EPSG:2056' overrides coordi

Hi having an issue where my FME data update job is running fine from Desktop when you click run. But when I published the job to FME server and set up an automation to run nightly, it seems to be pulling in old data when it runs. The job reads an excel spreadsheet in a folder and plots it and inputs the output data into our SDE. It seems like when I publish to FME server the excel spreadsheet is not being picked up live from its file location.

Hey. I have created a workspace on my desktop where I used source data from a local disk as part of my testing. Now I would like to have the data for all WS that use these sources in one place on the FME server, specifically on the Resources\Data path. The specific file path is "$(FME_SHAREDRESOURCE_DATA)/TopSky/AirportHeliport.BASELINE". Before publishing WS to the server I set this path on the reader as well, see attachment, however the file cannot be found when running WS from the server. Do you know where could be the problem? Thank you

Hello Guys I have a polygon we need to know the length of each segment and which direction the segment is facing north , south , East or Ouest. Thanks

I want to read some views in Microsoft SQL Server Database using a Database-Alias (not the Servername). I tried to make a DB-Connection using Microsoft SQL Server (ADO), but it didn't work with the alias (it works with the Servername).With a Microsoft SQL Server (JDBC)-DB-Connection, I can access the DB, using the DB-alias. Then I wanted to read the views, using the Microsoft SQL Server Spatial (JDBC)-Reader:I can access the database, but not the views. (In a database-application like DBeaver it works fine) TheDB- user account I use, is allowed to read the view, but not the underlying tables. Is FME not able to handle those permissions?

Hi there, Could I please have an update on if the I3S writer support point clouds after the release of 2023.1.1? If not then could I please have an update on the timeframe on this? Thanks, Shilpa

Room output from an Architectural Revit model are solids. I need room polygons and I’m not finding a transformer that will do this. Each floor of the model has a floor elevation value which would be perfect for slicing the room objects. FME version 2024.1

Hi, I have FTP Link, User, and Password How Can I download a file using FTPCaller? Thank you for your assistance

I am using Survey123 that generates a feature point at a default location. Every new point contains the name of the Road and from to information for the line segment. I am wondering whether there is a way to auto move that point right on top of the line segment using the Road Name information. Is there any functionality in FME that would allow me to move those points?

Hello, What is the best way to extract metadata from a shapefile? This would include Title, Tags, Summary, Description, Credits, Field Names, and Summaries. I want to export the metadata to an Excel spreadsheet. I am looking for some ideas on what transformers to use.

Hi, My goal is to read multiple (unknown) Hosted Feature Layers (HFLs) from an AGOL group and write those to ArcGIS Enterprise (11.3). I can successfully specify a single HFL in my FeatureReader and using an Automated schema in my FeatureWriter, specify each individual layer and write it to Enterprise. As I need this to work for multiple HFLs, most with multiple layers, I need to use a dynamic schema in my FeatureWriter. As soon as I do this, my workbench fails. Every time I switch to a dynamic writer, using the fme_feature_type as layer name and schema from schema feature, the workbench fails due to these errors: Message Type: fme::internal::_v0::py::ExceptionPython Exception <KeyError>: 'My_HFL_Name'ARCGISPORTALFEATURES writer: An error has occurred. Check the logfile above for details I’ve tried everything I can think of to get this working and cannot understand what I’m possibly doing wrong. Any help would be greatly appreciated. My workbench (so complex...) AGOL HFL FeatureReader

Bonjour, je veux d’automatiser le téléchargement et la mise à jour des données accessibles via les plateformes de diffusion de données géographiques (IGN : BDTOPO, BDCARTO, etc., OSM, DREAL…). Actuellement, je travaille sur la partie automatisation du téléchargement dans FME, qui consiste à moissonner ces données. J’ai déjà fait quelques avancées, mais je sollicite votre aide sur des conseils; liens utiles ou des pistes afin d’approfondir mes travaux.. En vous remerciant d’avance.

Bonjour, Je rencontre des difficultés depuis plus d'une semaine pour lire et transformer un fichier raster étendu au format ECW (orthophotographie avec une résolution de 5 cm et une taille de 30 Go) sur ue version FME 2020. Je sollicite des aides. Merci d’avance Mouhamed

In some tables stored in an Oracle database there are more than one spatial column.The reader can't read all the spatial columns but it reads onnly the first column it encounteres. how to read an Oracle multi spatial column table with FME Workbench? Emilio De Palma

Hello! I generated a CityGML building model from an fbx model. The model could be opened in FZKViewer but the view is very strange. I could see the textures in the back when I am on the front view. It is like the surface in front of me becomes a very transparent glass. This happens at all of the sides of the model except the roof and ground surface. When I turn off the texture, everything is back to normal. Is it the problem of the texture? How could I check if it is on the texture and how could it be fixed?

I’m trying to output all property sets from IFC files into separate Excel sheets. So far I’ve found all of the property sets, their attributes and their attribute values. This is my data: What I would like to do is transpose this list into separate lists for each property set like so: After that I could simply write each list to separate Excel sheets, but this is where I get stuck. I create the sheets by feeding the writer from a DuplicateFilter, but how do I join each PsetAttribute to Pset as well as transpose the data so each PsetAttribute is a single column? I need to do it without knowing the exact names or number of property sets existing in each IFC file as well.

Hi, After a migration to Office365, FME is unable to open Access files. The following error is given: Microsoft Access Reader: Unable to find provider 'Microsoft.ACE.OLEDB.12.0', falling back to 'Microsoft.Jet.OLEDB.4.0'. The 2007 Office System Driver might be missing from your system; follow this link for more information: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id;=23734 Microsoft Access Reader: Connection failed. Connection string `Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Engine Type=5;Data Source=K:\\dienst VR\\02_rapporten\\Lijst_SEVESO-inrichtingen 2016.accdb;User ID=admin;Password='. Provider error `(-2147467259) Onbekende database-indeling K:\\dienst VR\\02_rapporten\\Lijst_SEVESO-inrichtingen 2016.accdb.'We tried installing 2007 Office System Driver, as given via the link in the error message, but this did not solve te issue. The following error message still appears: Microsoft Access Reader: Connection failed. Connection string `Provider=Microsoft.A