Data

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!

Hi everyone, I want to create a Esri Personal Geodatabase whose structure is specified in an Excel table. Is that possible? How can I achieve that?

Using an Esri ArcGIS Online connection and the Esri ArcGIS Online (AGOL) Feature Service reader, I'm unable to read a feature service that has been shared to our organization.When looking at the select form, i’m only provided my user folder and a groups folder. The feature service i’d like to read isn’t owned by me or shared with a group. Is this as-designed or is there another way to read it? Thank you  

Hi everyone,I have a feature class in a File Geodatabase that I need to update. I have two sources for these updates: a CSV file with codes of the changed features, which I should use to remove those features from the main dataset, and separate shapefiles for each changed feature that needs to be added back to the main dataset. (I shouldn’t delete and update the whole dataset, I should update the changed features only.)What is the best way to approach this in FME?Thank u in advance for your time. 

Hi,When running a workspace with cache mode activated i can see in the Translation log that fme form writes ffs, and writes and index and so starts it with a process i am not familiar with: “Destination Feature Type Routing Correlator” and it takes so long to go through.What is this process about? is it possible to avoid?Thanks in advance!

Hi, I have a SQL Executor calling a stored procedure.  I am running FME Form FME(R) 2023.2.1.0 (20240104 - Build 23774 - WIN64) and am getting this issue:Microsoft SQL Server Non-Spatial Reader: Failed to connect using Microsoft OLE DB Driver 19 for SQL Server. Provider error '(-2146824582) Provider cannot be found. It may not be properly installed.'The transformer is not failing, but its not producing a result either. Not sure how to move forward with this one. Any thoughts?Thanks