Data

Hi all, I am experiencing an issue with writing dynamically to SDE for large datasets (i’m unsure of the exact number, but above ~5000 features seems to cause a fail).  My flow reads in a dataset name from an SQL table, matches it to a dataset that has been downloaded as part of a previous flow, checks if it has been updated and if so drops and recreates the Feature Class using a name given in the SQL tables.When running the flow in batch using a Workspace Runner, ~half of my datasets ran successfully, and ~half failed to be updated in the SDE. I have looked into this is some depth and the only pattern I can see is the datasets that are failing are larger. The error message I am getting is below. I have tried using a sampler on the data just before the FeatureWriter and the flow works correctly, which validates my findings. What could be the potential reasoning behind this behaviour? or has anyone else experienced similar? If there are any other suggestions of settings I could change t

We have several FME Server services that runs nightly to update hosted services. This all works well but every month or two the services all fail because they have lost their authentication to AGOL even though there were no account changes. I can re-authenticate the connection and then the services run for a month or two and then they lose their authentication again. Is there a way to set up the authentication so that they do not have to be periodically re-authenticated? Thanks in advance,David

A bit of a subjective question, but what are fast file-based geospatial data formats to read in FME?I have a set of geodatabases (10GB) covering the whole country, and it’s located locally on the C-drive of  the FME Flow server. Users specify a bounding box to extract the data for their area of interest.To make the current setup faster, I have played with indexes and made sure that I’m doing a bounding box intersect on the FeatureReader, etc. But it still takes at least 10-15 minutes to get the output.One other idea that I’m playing with is to use a different format for the source data instead of geodatabase. GeoPackage got a mention somewhere; FlatGeoBuf apparently is fast; and I have heard good stories about GeoParquet. Any other formats I should consider?Has anyone done any comparison on this? Any pitfalls / drawbacks I should be aware of?At the moment I’m looking more at file-based formats, as formats that require additional (database) software would involve IT too much.I will do t

Hello ,I need a help I successfully updated a point geometry in the ArcSDE writer within a specific version. I encountered an issue.When I select "Update Mode" and set "Row selection - Columns " to ObjectID, I get an error translation  running  . But if I leave "Row seletion - Columns" empty, the translation runs successfully. The "Row selection - Columns " field turns red when left empty, and I’m unable to click "OK." To work around this, I temporarily set "Row Selection - Columns" to ObjectID, click "OK," and then use a Remover transformer before the writer to remove ObjectID—and when I run the workspace ,it  works great and translation is successfully . But ’m unclear on how FME identifies the correct point to modify it ,how to resolve my issue ? Update Spatial columns : Should be yes or no ?FME version: 2021, 64-bit.Thanks in advance

I would like to use 2 UserParameter values as attribute names in my workbench. Is this possibe?Current situation:What I would like to have: 

Hi everyone,I’m working on an FME workbench where I download a full dataset file geodatabase daily. I also have a CSV file that lists daily changes.My goal is to remove files from the main dataset based on the CSV and add updated files from file geodatabase back into the main dataset.I’ve tried using the FeatureMerger and FeatureJoiner transformers to identify changes, but they were not effective due to time constraints. Since this needs to be done daily, time efficiency is crucial.Do you have any suggestions, Python scripts, or SQL queries, or any other ideas to speed up this process?Thank you!

Hi, Is there a way to remove build pyramids when converting geotiff images to mbtile? I just need the image to display and improve mbtiles creation time 

Snowflake recently released their new "geometry" data type. Not to be confused with the existing "geography" data type. The geometry data type can contain geometries in other coordinate systems, not just WGS84. Whereas geography is specifically WGS84. See Geography vs Geometry data types documentation hereGeospatial Data Types — Snowflake Documentation When will FME support writing of the new snowflake geometry data types? Is there a way to do this right now, or will it be a future release of the Snowflake Spatial writer?

I am reading dynamic data and sometimes there is text fields that contain newline characters and I would like to replace them with just a space. How would I go about this?   

Hi all,I see some strange behaviour when converting a simple 2D box from PostGIS to Geopackage in a dynamic mode (using schema). I have attached a simple workspace which demonstrates the strange behaviour. A simple box is created in 2D and writen to PostGIS as a postgis_polygon. I ckecked the table in the database and is has the correct definition for  the geometry (geometry(Polygon, 28992)). After the creation the table is read wit a FeatureReader of type PostGIS with the same connection parameters. It is set to read the schema and the features. The result is directly written to a geopackage with a FeatureWriter. Geometry is from schema definition. When i open the result in the Data Inspector i see the geometry type has become geopackage_multisurface where i would expect it to be of type geopackage_polygon. At the moment we are upgrading our FME environment (Form and Flow) from FME 2021.2.6 to 2023.1.2 and ran into this problem. In FME 2021.2.6 i did not see this behaviour. This parti

Hi,I have a annotation class in a file geodatabase. I want to convert it to a polyline or point in a file geodatabase. I could not fine any transformers in FME.  I really appreciate your assistance.

Hi I have a requirement to connect to the new Ordnance Survey (GB) WFS service in FME, their system responds with 100 records at one time, there doesn't appear to be an option in the reader to facilitate this paging implementation as in other products Any help to be able to access this API would be greatly appreciated

I have a list of Attributees{}.name That contains attributes for each feature. the element count is variable.I am also using the ListElementExtractor and like how it works but i need from  15-258 attributes to put the list into.is there a way to get the list values out as attributes? or at the very least mmake the list populate (i.e. attr1, attr2, - attr258) in the destination attributes? I am reading the schema from a (blank) gdb with coded domains and WAY too many attributes to use AttributeManager. the purpose is to get the attributes with the correct domain and values so a different schema can be fed into this format and output as gdb with domains intact.

Hi Everyone, I am working on a project for school and am reading in CAD data and outputting it as GIS data. However, the File Geodatabase writer is not outputting any features. I am setting it up how I’ve always done it in the past, but it is not creating the GDB where specified as the translation log says no features are being written. I have no clue on why this is happening nor how to fix it, so any help would be appreciated. Thank you in advance.

Hi all, I would like to use an existing FME reader to open a file with an unsupported extension. Is there a workaround to achieve this? Alternatively, how can I clone an existing reader and modify it to support the desired file extension? Thanks a lot! 🤓hp

Hi,I have a layer with closed polygons. On top of these polygons lies a layer with smaller areas. These areas are divided into 3 types.Each type of area needs to be assigned a year, and the total area per table type should be approximately equal within the larger area.How can I create a distribution where each type of area is used, and the total area of each type is approximately equal?How could I achieve this with FME?

I’m encountering this error and am at a loss. Everything in workbench (SQLCreator - Attribute Mgr - Excel Writer) seems to work fine, up until it gets to the writer. Excel Writer: Failed to write an attribute of type 'string' with value 'XMLDATA' to row '0' column '-1015942868'. Error message is 'col must be in range 0-16383'. Skipping featureWriter Mode: UpdateOutput Field Names: YesFormal Field Names: NoUse Attribute Names as Column Positions: YesStart Position: Start Column: 1 Start Row: 1  Any suggestions?  

I am working with a script that transfers data from one SDE to another SDE. Currently, the script does not ensure that the relationship between a feature and its attachment remains intact. To address this, I extended the workspace based on the guidelines in this article: Writing ArcGIS Geodatabase Attachments.This solution worked fine when transferring data from one GDB to another GDB using the same data model. However, when we run the script from one SDE to another SDE with the same data model and data, it fails and I encounter the following error messages: Failed to retrieve origin row for a relationship feature with OBJECTID '3' from table/feature class 'BAGGERWERK_WATERLOPEN' GeodatabaseRelationshipFeaturesPipeline::GeodatabaseRelationshipFeatures (SortFactory): A fatal error has occurred. Could you provide guidance on how to resolve this issue?

I have 4/5 layers of rasters representing the geological horizons. I want to visualize the layers in 3D voxel. what the result look something  like this. Is there a way to get this with fme? 

Hi, Im trying to write approx 17.000 rows into an existing feature service in AGOL. I get the error "entity too large for url", so I assume its too many rows. I have tested with a few rows, and that works fine.  I have tried now to use the ModuloCounter and a TestFilter to split into smaller groups, and then add multiple AGOL-writers, so they only write one group at the time. Im not sure this is the best way to go, as I would the need a lot of writers. Another is to use the FeatureWriter to do the same, but I would still need to do the setup for all the groups, so not sure if thats ideal.  Does anyone have any better suggestion? Best,Anne Kathrine

I have been having a consistent problem in FME for quite a while now, across both 2023 and current 2024 versions. I have a workspace set up which has a SQL Spatial reader, a few transformers, then a writer back to the database of origin.Any time I run this database, it goes through and successfully runs it within FME. However, as soon as I go to another source and read the database table(s) involved, such as SQL Server Management Studio or QGIS, I find that the data is still the exact same as it was originally, like FME had done absolutely nothing. Likewise, if I make a new table, it will simply make an empty table with only the columns/fields intact, with no attributes at all. I have no problems editing data from this database in QGIS or SQL Server Management Studio and have even had colleagues run the exact same FME Workspace with no such problems. I have also had two different FME installations on two different devices behave exactly like this.I'm pretty much out of ideas here. Has

Hi I'm trying to update attributes in a copy of an MS Access database. The workbench fails at the writer due to a provider error '(-2147467261) invalid pointer. Any ideas as to what the issue may be?

Hi, Currently have a process that recieves a list of record id’s from Salesforce using HTTP callouts, the record ID include the ID of records from a custom object and the id of a number of users, we are trying to create an insert in the customobject_share to create records to give the list of userId access to the records from out custom object.  We currently are getting an error,Salesforce Writer: Record 1 was not processed successfully: 'FIELD_INTEGRITY_EXCEPTION:invalid parent id: Parent ID:ParentId --' The parent id is the record Id of the salesforce record we are creating a related share record against. the record exist in salesforce and in testing we have event tried hardcoding te ID of both records, and user Id with RowCause = “Manual” and Access Level = “Edit”. The form is running as using the Salesforce reader/writer with a System Admins login details? Thanks  

I am trying to upload a tif stored in my PC locally to the contents in arcgis online. I can upload the shapefiles efficiently but not tifs. Can someone advise? Thanks!