FME Form

I have set up a dynamic workbech with the follwoing setup. Its from SQL Server to geopackage. It has been working fine daily for months until today when i noticed one record was missing geometry (geometry was null in the target geopackage databse). Why does this single record fail to write? Checking the geometry types in the source database (STGeometryType ( ) ) for the feature type they areGeometryCollection LineStringI dont understand why it is failing when I am using a dynamic workflow in the first place?Where should i start to look for errors, is there anything i can do? I have been poking around for a long time to try to make sense of it. One thing i have found is if i look at the feature with the Feature information window there is a “fme_geometry” attribute with a value of fme_aggregate. The attribute fme_type is of fme_collection.The failing feature is the only one whch is a fme_aggregate, so i am assuming that has something to do with the problem? But why would it be an issue

Hello everyone,I'm looking to place the maximum number of points within an irregular polygon, ensuring a minimum distance of 250 meters between each point. Initially, I considered using a grid, but I've realized that this method doesn't optimize the space within the polygon very well.Do you have any suggestions or more effective methods for solving this problem?Thanks in advance for your help!

I am trying to write polygon features into a Esri Geodatabase writer where the layer name is NV_NATURRESERVAT. But, the writer is trying to add a suffix “surface” so the output name will instead be NV_NATURRESERVAT_surface. This is not correct.First of all I dont want the a layer with a name like that. And second, before it reaches the writer the script filters out if theres a need to create a layer or not in Esri Geodatabase.If theres a need to create a layer it will create on in another writer. If there exist a layer with that name the flow will continue to the second writer. In this case the layer exist, I just want to update it with new data. So, up until writer(s) the layer name is set to NV_NATURRESERVAT. But when it reches the writer it gives me error messages saying that no such layer exist:“Esri Geodatabase Writer: Feature Class or Table 'NV_NATURRESERVAT_surface' must exist when Table Handling is set to 'Use Existing'GEODATABASE_SDE writer: An error has occurred. Check the lo

Hi list.I'm tasked with importing a lot of feature sets, each with its own set of fields/attributes. So I'm using dynamic output mode, utilizing the schema features read.Unfortunately the request is to add a "job ID", so I tried to append an entry to the attribute list of the schema features, but suddenly the proces fails, not recognizing the schema features anymore. And this without changing anything in the data features flow nor the writer.An example of the error message is:Microsoft SQL Server Spatial Writer: A feature has arrived with 'fme_feature_type' of DAF_DAGI.afstemningsomraade_908308, but the feature type is not recognized. Halting translationMy writer setup is shown in the attached image. Why does the writer suddenly confuse the fme_feature_type with the requested table name ?Or is the error message false/misleading ?The "fme_feature_type" of the data features are the exact same, I just manipulated the schema features in a parallel "stream".Any insights are appreciated.Chee

Hi guys,I am trying to automate a process which requires to write into a new file-geodatabase everytime I run a translastion. Essentially I am reading data from 1 database trying to stage it in a new geodatabase and then moving it to its final destination. I am using FeatureWriter to continue the translation but i am getting a geodatabase is locked error. That is why I am trying to create a new file geodatabase for the staging part of the process as this is where the error keeps on occurring. Is there a way that FME workbench can create a new file geodatabase for my feature classes in a same workbench?Thanks!

A small follow-up question, the prompt button on the toolbar has vanished for me since FME 2024.0. It also disappeared from the Toolbar options. Same goes for the Stop at breakpoint button.Any ideas how to get it back?

I'm reading in ECW file to get the Filename, X Y Min, X Y Max. Write to excel, I do not want the image/raster in my excel file.How do I get rid of the image?

Good morning,I am trying to do a spatial join between two polygon files.  One is the property boundaries and the second is conservation easements.  The goal is to combine the parcel id from the property boundaries to the conservation easement polygon, where a new polygon will be created for each intersection.  I am trying to recreate a model I built in ArcGIS Pro.  Screen shots below.  

I'm using a path in an Esri geodatabase writer that contains a space in the path name - \\\\xxxxx\\gis\\SheriffsOffice\\Camera Information\\SO_Camera_Info.gdb. The workbench completes successfully (2019.1). When the workbench is published to FME Server and run, the path is truncated at the space form '\\\\xxxxx\\gis\\SheriffsOffice\\Camera.gdb' Is there a way to fix this?

Hello,I am new to FME but have some overall experience with coding and I know there has to be a simple way to solve the issue of automatically creating the file name based on an attribute. I am trying to create an excel file with multiple sheets and I have tried using the fan out parameter (along with anything else I can find online) but its been making multiple files or crashing, instead of just one file with multiple sheets. I have been researching this issue for far too long with absolutely no head way so any help will be greatly appreciated. I will also need to create a kmz/kml file with the same naming parameters if that changes anything.Thank you in advance,Sam

I have an ETL workbench and would like to create a text file where I can write some information while running the workbench. The information I would like to write includes:The path to individual readers The feature counts of each reader The coordinate system of the each reader How many objects have been written to the databaseI don't want to use logging per se because it writes basically all information.What alternatives do I have? Can I only do it with python`? 

Hello, I am a first-time poster on the FME forum. My goal is to read data stored in a plain view from a non-spatial Oracle database and then write it to an Oracle SDE geo_dbtable. The issue is that my Oracle Non-Spatial Reader slows down, taking more than 30 minutes to execute the SQL Statement when I include two comment fields that are long, 2000 characters. When I run the same query in SQL Developer, the result is back in a few seconds.   The log message that gets stuck on is:  ORACLE Reader: Executing SQL Statement `SELECT…<field names> to obtain features for feature type <Oracle View Name>If I uncheck the comment fields in the User Attributes tab the reader returns quickly, within a minute.  So I’m skeptical that it is caused by network distance.  Given these challenges, I need some guidance. I’ve tried using an Oracle NCLOB to hold the comments in the view, but the result remains sluggish. I'm eager to learn how to optimize my workbench's performance when dealing with

Hi,  This subject is discussed already quite some times but I don't get it working. I have a loop where a feature enters with 3 fields (field_name, field_value). I want to use the AttributeCreator to make a field that is named after the value in "field_name" and gets the attribute value from "field_value". As there is an option inside the AttributeCreator "Attribute Name from Attribute Value" is supposed this would do the trick. But this does not create a new attribute. If I type the actual field name in the "Attribute Name" field in the transformer it just works fine.  The attribute names are like this: net_elements{0}.xlink_href net_elements{1}.xlink_href net_elements{2}.xlink_href net_elements{3}.xlink_href ...

I am trying to set up a TCPIP Receiver to read raw data from a specific port on another host machine. On the box I am authoring the workspace with I can use Windows PowerShell to ping that location and have another technician confirm with Wireshark that data is being sent through this port.  So in using the TCP\IP Receiver transformer I can ‘Successfully connect to host’ per the log but the translation immediately shuts down per the attached snip. Why is it doing this? It should be streaming data and to do so needs that transporter open. Thanks for any help.     

I have a Microsoft SQL Server database and need to mirror/copy some tablez to another Microsoft SQL Server.For most attributes it is working, but not for numeric(width, precision) values it is not. The numbers after the decimal do not show in the new database. This might has to do with the decimal / language setting; I am not sure what the problem is. I read about the use of 'native_data_type'https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Form/Workbench/Deriving-Destination-Schema-from-Schema-Feature.htm'To instruct the dynamic writer to apply the native_data_type to the schema feature, instead of the fme_data_type, specify attribute fme_format_short_name and set the value to the Format Type Identifier ("short name") of the format. For example, fme_format_short_name = “GEODATABASE_FILE”.'But do not know how to implement this. Where do I need to put this 'fme_format_short_name'?Hope someone can provide some insights.ThanksStefan

Hi All,Im trying to do a spatial join of attributes from the red line (running parallelish) to the black line, not the attributes from the red line running down Duke Street.I have tried a range of thingsbuffering the black line and seeing what it contains ( it contains a piece of Duke Street) and the parallel red line but i cant work out which record to take getting the polar angle of the lines and looking at the list of records that spatially join it - im struggling to sort the list to find the correct record. I think i need a Spatial Angle Join but am struggling with the logic on the listsAny help or suggestions appreciated. Thanks Steve

Hi All, I am trying to call a fmw file using bat file which will run on fme quick translator. Here for a testing i created a fmw file with “path” reader and changing the input value as user parameter which i newly added in workbench. I created a testing bat file to call that fmw file but i am facing “Undefined environment variable”.  I referred old case regarding and changed into ${variable} format but no change yet I’m facing the same. I attached workbench file and bat for your reference.I am using FME Desktop 2020.1.1.1 32bit version 

I am using an SQLExecutor to write spatial data into an ArcGIS Enterprise database table.It took me a while to get it done, and there is still more work to do but currently a smaller chunk of data is for the first time written into the table. What bugs me is the 4 lines of warning that I get for every feature written.Microsoft SQL Server Spatial Reader: Getting Custom SQL schema failed. Custom SQL query 'INSERT    INTO    building (OBJECTID,SHAPE)VALUES (27, geometry::STGeomFromWKB(here is of course the binary, 25832))' may execute in an unexpected manner. Make sure all columns are named (any ambiguous columns, e.g. GEOM.STBuffer(1), must have an AS clause). If there is an ORDER BY clause, either remove it or add a TOP clause. If this warning is generated in a SQLCreator or SQLExecutor, you can avoid it by picking Data Features in the Features to Read field the message coming from Microsoft SQL Server Spatial Reader seems strange how can I avoid this in the SQLExecutor? Should I set th

It used to work in older versions (2020?), but now will only use the value set in the writer. If I set it to 0 for automatic width, it results in "Error running translation"I need the cell size to be a specific decimal value, but the writer will only let me set an integer for the cell width.

DATA analysis of different types data to map.Here below is  all of data related work that I have finished!https://www.gnvcompitservices.com/gis

Hello,Context : FME 2024.0.3, Windows 11I'm currently working on a project with source data and files “.shp” files within it. Each of these files has several columns, one of which is called “IdGen”. Only this column is not written in the same way according to the “.shp” file, example: IDgen, idgen, IDGEN, idGen……To insert it into our GIS, I would like to know if there was a way to change, at once and with a single transformer, all the columns having “idgen” regardless of how it is written to “ IdGen” as I wish ? All this with the aim that my FME project can work automatically during the next updates without having to use AttributeManager behind each of the files…Thank you !Antoine

Hello FME enthusiast,  I exported a data from SW to SHP using FME workbench and after exported i used FME inspector to view exported shp file which don’t have geometry.  but when i open  same shp file in QGIS which showing geometry as MultiPoint. But in writer (Shp) mentioned shape_file point not multipoint.  Does anyone come across this case ?.Thanks in Advance!

Hi All,Am attempting to read a feature service (actually several) that are open to the public on ArcGIS Online (AGOL).  I have created a new web connection using an existing user in AGOL for our organization (getting a token, client id, etc).The data that I am attempting to read is the ACS Census data (several different feature services).  When entering the copied URL from the AGOL website, and then attempting to select a layer from the feature service, I get the following errors.  I see that that it is looking in the content of my user, but this data is open to all.  This used to work for me before the changes in the web connections.  Where do I look from here?  I have tried this in FME 2022 and Flow 2024.Thanks,LorindaCreating reader for format: Esri ArcGIS Online (AGOL) Feature ServiceTrying to find a PYTHON plugin for reader named `ARCGISONLINEFEATURES'Using Python interpreter from `C:\Program Files\FME Flow\fmepython312\python312.dll' with PYTHONHOME `C:\Program Files\FME Flow\fme