Best Answers

This has been bothering me for a long time. I keep avoiding it because I just end up using a SQL executor. to find errorsHow is the Writer transformer different than a SQLExecutor when performing MSSQL inserts? [or other functions]. Don’t they use the same driver?Here is an example: I recently inserted a row into a table where the string length was too long got the field. The Writer transformer just inserted the string successfully, but it truncated. The SQLExecutor threw a SQL error saying, ‘string or binary data would be truncated’ and then failed\rejected the insert. I have also run across other odd behavior in the past. Such as the writer having the ability to insert duplicate foreign keys, but the SQLExecutor will fail with error. Is there a good resource for this or a good explanation? Thanks!

Hi everyone, I am now doing data quality inspection to an esri personal geo database with multiple layers, and I have to calculate how many 0 or null values there are in every attribute of each layer(or table) in the database. I have tried to figure out some automation method with FME but in vain. Can anybody give some instructon or advice? 

Hi,I haven’t been able to find this question asked anywhere, but I’m sure it has been. I’m at a lost though. I have a unique attribute in a group of features. I wish to find unique combinations of all possible pairs in my group of features.For example, if I have three features. Their ID’s are 1, 2, and 3. The result I want to find is a feature with a new ID of: 1-2, 1-3, and 2-3In reality my groups can be up to 20 features in size.I can’t work out how to accomplish this in FME. Though I’m sure its very easy.Does anyone know how I would do this?

So this is going to be a dumb (yes, really their are dumb questions) but I can't for the life of me find a way to simply "print" or export my workspace to PDF for documentation purposes.   Sure, there are screenshots but a screenshot of a massive workbench is illegible.  When I go to "print" it will let me choose a paper size... but all I want is the ability to a) choose a custom size  or b) "print" or export the entire workbench at (say 300 dpi) or something of that nature.  Currently the "best" I can do when using Adobe to "print to PDF" is 47 ANSI E sized pages on export! Seriously, there has to be a better way????  Any ideas or suggestions? Note, I've tried programs like "snagit" to do a rolling screencapture but that doesn't work either.     Matt

HelloCould not able to write “Esri Geodatabase (File Geodb Open API)” facing Error Geodatabase Error (-2147219884): this so frustrating form last 2 days i am suffering from this issue.

Hi, I get warnings when running some automations in FME Flow. Running just the workspaces manually does not give these warnings and all data is written as expected in both cases. Any ideas for what is causing these to appear? Thanks Automation log:1 2024-04-04T22:00:00+02:00 | 803022 : Dependent parameters: [] 2 2024-04-04T22:00:00+02:00 | 803018 : Expected parameters: [DestDataset_GEODATABASE_SDE, SourceDataset_MSSQL_ADO_3] 3 2024-04-04T22:00:00+02:00 | 803019 : Provided parameters: [SourceDataset_MSSQL_ADO_3] 4 2024-04-04T22:00:00+02:00 | 803019 : Provided parameters: [SourceDataset_MSSQL_ADO_5, SourceDataset_MSSQL_ADO_6, SourceDataset_MSSQL_ADO_7] 5 2024-04-04T22:00:00+02:00 | 803022 : Dependent parameters: [] 6 2024-04-04T22:00:00+02:00 | 803018 : Expected parameters: [] 7 2024-04-04T22:00:00+02:00 | 803022 : Dependent parameters: [] 8 2024-04-04T22:00:00+02:00 | 803018 : Expected parameters: []

I saw recently that in FME Form 2024.1 dynamic scripted parameters have been introduced. While I was excited to see this new feature, I was curious if these parameters work the same when published to FME Flow?I searched the FME Flow documentation, but was unable to find further information regarding this. Is this functionality only limited to FME Form?Documentationhttps://docs.safe.com/fme/html/fpkg-sdk/advanced/scripted-selection/https://docs.safe.com/fme/html/fmetools/fmetools/scripted_selection.htmlFME Related IdeaFME Form User Parameter  

Hello, i have a problem with the stringconcatenator. i would like to combine several values of text attributes with the stringconcatenator as a new attribute. the values should be separated by a comma, empty attributes should be ignored and there must be no comma at the end. how can this be achieved? I always get two or more comms if the attribute is emtpy. Thanks a lot.

I  have an “Extras” attribute that is XML-like with different number of attributes in different order within the attribute value.. When I use the , XMLXQueryExtractor* and configure a  query, it only returns rows that has one tag only called <PAGE_TITLE>, like below.  The query returns this query result in the list attribute. THe resr of the rows are rejected as invalid XML Queries.For the other failed queries, they have multiple tags, as shown below.What I’d like to do is aplit the tags into field::values regardless of number. This attribute value:<PAGE_LINKS>https://p3tips.com/community/</PAGE_LINKS><PAGE_PRECISEPUBTIMESTAMP>20240905151800</PAGE_PRECISEPUBTIMESTAMP><PAGE_TITLE>Lynchburg Police searching for suspect after armed robbery at Family Dollar</PAGE_TITLE> Woud look like below with all the attributes in the Extras value split into however many tagged attributes.PAGE_LINKS PAGE_PRECISEPUBTIMESTAMP PAGE_TITLE https://p3tips.com/com

Hi All, I am trying to reproject some .e57 files containing LiDAR scans and oriented imagery collected with a terrestrial scanner. Reprojecting the point cloud is straightforward, but I am having some trouble with the imagery.I can see in the Feature Information window that the image locations seems to be stored in the e57_translation_x, y, and z Geometry Traits (Geometry->Raster->Geometry Traits), here’s a screenshot from Data Inspector:I’m working from a local coordinate system, hence the low translation values.My goal (I think) is to extract these translation values, reproject them in the same way I’m reprojecting the point cloud, and then write the new values back in to these traits, but I’m not sure how to access these trait values, and was wondering if anyone had experience with this. Thanks for looking!

Hello everyone,I'm looking for a way to check if the ending character of a string attribute is an uppercase letter, and if so, convert it to lowercase. For example:Foo1K → Foo1k BAR4 → BAR4  BAZ → BAzWhat's the best way to accomplish this in FME? Are there any specific transformers or approaches that I should use to achieve this result?

Hello there, How can I read a tsv file in FME? Do we need  to use csv format only:? Thanks,Siva

Hi,I have an NDVI raster and need to clip it with many polygons. After that, I need to calculate the standard deviation for each piece of the raster (clipped by the polygons), and in the end, I need to correctly assign the deviation value to the attributes of the corresponding polygon. Thank´s

I'm trying to build a service catalogue of our municipality's services (WMS and WFS) for easy search and access. I have successfully used xml readers and httpcaller along with xml flatteners to extract the information into a queryable json table and presenting it with datatables (https://datatables.net/ ). Very handy and fast. But now I've run into some trouble that I can't really understand or work around. Getting the info from well over 600 services has been easy but the last one I added does not work. See attatched workspace. "TK OPEN" works just fine. "Miljö" does not. It seems to be related to XML and HTTPS, but that really isn't my strongest field. getcapabilities.fmwAm I doing something wrong? Is there, perhaps, a simpler or other way to do this?

We are planning our 2024 upgrade and need to know when the anticipated release date is for FME 2024.2. We are looking to upgrade soon, but may delay some depending on the anticipated release date. Thank you in advance for your help!

Hi, I’m finding XMLFragmenter removes geometry, is this expected?Data Interoperability in Pro 3.3, so FME 2024.0.1.0 build 24202.Thanks.

Hello Friends!My current setup: FME(R) 2024.0.1.0 (20240328 - Build 24202 - WIN64) ...from ArcGIS Pro Data Interoperability Extension I am attempting to use the GeoJSON Reader to capture information from api.weather.gov/alerts/active (Weather.gov API).  I am not having any problems getting data.  The problem I am having is populating all of the available fields within the API - in case I ever do get them from the API.  The first time I connected to the URL from the Reader, I got most of the attributes, missing maybe 10 fields.  Adding another GeoJSON Reader and connecting to the URL an hour later, I get a different set of attributes.  I do understand that the data is changing and their API is not delivering any unnecessary nested attributes.When opening the Reader’s Properties and then User Attributes - there is no way to add attributes.  Am I missing something?  Is there another way to add attributes?Thank you,--Adam

I want to convert the format of a date-attribute from %Y%m%d to %Y-%m-%d by using the DateTimeConverter. This works fine, as long as there are no Null-values. As soon as there is just one Null-value, all other values are set to Null as well (even though the option “Passthrough Nulls, Empties or Missing” is set to Yes).I tried to filter out the features with the Null-values, convert just the features with values and merge all features after the DateTimeConverter again, but here too, all attributes are set to Null.If I set the Null-values to a dummy-date, then it works. But I don't want dummy-dates, but Null-values, so how do I do this?Thanks in advance, Vera

In a process in my company we use a Python script (PythonCaller) to call a download API, we need to modify it, but we get some errors that I don't get when running the script from Python on the Windows command line.Is there a way to debug the execution of the script in FME?

Hi, I try to upload a file to the FME Flow Shared Resource Folder via the Flow REST API. When I use Postman the request works as expected but I need to send the request in a command prompt with curl. Of course, first I tried to use the curl that can be generated in Postman but it always returns the error “curl: (26) Failed to open/read local data from file/application.  Here are the paramters for the working upload in Postman:POST https://fmeflow/fmerest/v3/resources/connections/FME_SHAREDRESOURCE_DATA/filesys/Test Headers Authorization: fmetoken token=1234 Body (form-data) file: test_upload.txt Postman generates the following curl:curl --location 'https://fmeflow/fmerest/v3/resources/connections/FME_SHAREDRESOURCE_DATA/filesys/Test' --header 'Authorization: fmetoken token=1234' --form 'file=@"/C:/Users/e059231a/Downloads/test_upload.txt"' I already tried to remove the quotes from the filename and to replace the slashes with double backslashes but still get the mentioned error. 

Where to get the FME for Home Use, like ArcGIS Home Use license?

Hi all.Today I needed to build a custom Python based transformer from scratch, after a two year hiatus, and needed to explore some new things in the FMX file part.So as always I opened https://support.safe.com/hc/en-us/p/documentationBut apart from the Format GUI Type documentation, I can only find a new “.fmxj” documentation, but not the proper FMX file ditto. And fmxj looks nothing like FMX, it seems.Why has this crucial piece of documentation been removed ?Can I find it somewhere else ?Cheers

According to several solved questions in this forum, there are two recommended ways to automatically remove attributes that only conatain NULL or empty values: using a small python script or using the NullAttributeMapper. Unfortunately both suggestions do not work for me (FME Desktop/Form 2022.2). Both the PythonCaller and the NullAttributeMapper keep the Null-Attributes and they are present when I write to Excel (see attached workspace). Is there something wrong in my workflow or is there an updated solution? Thanks for any suggestions!

Hi,I have a deployment parameter (Text) that is pointing to an SDE file on FME flow in my shared resources. When I try to set a local value in form, it ignores this value and throws an error saying it can’t access the share resources file path. I’ve tried creating a deployment parameter that is  type: database connection, but this doesn’t work either. Here’s the error:This was working a week ago and now it refuses to acknowledge the local value. Many thanks, Sam

Hello, I am using FME 2022.2 and I’m trying to load in Raster data, based on an Area of Interest (AOI), specified by the end-user in FME Server (yes my organization is not using FME Flow yet, but the old FME Server). We have a few big Raster datasets on a local drive (of the entire Netherlands), which are loaded in as regular Readers. Then, using a Creator and GeometryReplacer, the end-user can specify an AOI (using a User Parameter), and the Rasters are then clipped in the Workspace using a Clipper. However, this means that the big Raster datasets need to be loaded/processed every single time the Workspace is ran, which is bad for performance. What I want, is that the Raster data is loaded into the Workspace, but only the data which intersects the AOI, specified by the end-user. I tried using a FeatureReader and use the AOI from the end-user as trigger to load in the Raster data. However, for some reason, the entire Raster dataset is loaded every time, instead of only the Raster data