FME Form

Hello community, I have a street dataset with 2139 records, with each one being a line (for those in UK LAs, note that it is the LSG). It includes a field called ‘street or numbered street’.  For 2040 of the records the value in the ‘street or numbered street’ field is a named street (e.g.: Acacia Avenue). For 28 of the records the value in the ‘street or numbered street’ field is an A road (e.g.: A312). For 14 of the records the value in the ‘street or numbered street’ field is an B road (e.g.: B204). For 57 of the records the value in the ‘street or numbered street field is an C road (e.g.: C5840044).  I want to filter out the three separate road types: A roads, B roads and C roads. I want to ignore the 2040 named street records.  What’s the best way to do this? A filter? Query via the Text Editor within the Writer? What would the code be?

I have a series of 2D polygons with attributes for slope and aspect. I want to rotate them about a horizontal plane (using a 3DRotator) so that they become 3D shapes with these properties of slope and aspect. However, I want the spatial extent of the shape to stay the same, i.e. if I were to force it to 2D them again, they would look identical to how they did before. Effectively, this means that all of the vertices need to be elevated/dropped in the vertical plane. This is not so much a rotation as a stretch. As an example, if the polygon has a slope attribute of 80 degrees, by the time the shape has been made into a 3D sloping polygon, the planar extent of the shape would be much smaller and, if it were forced to 2D again, it would be also much smaller. The higher the "slope" value, the more the shape would shrink in its planar extent. Does anyone have any suggestions for how to achieve this? I effectively want the reverse of a 2D forcer.

Hi, The GoogleBigQueryConnector return the error of Python Exception. I'm not too sure what should I do to resolve this exception. I'm using the new version of FME 2022.1. Previously this transformer is working well in the FME 2020.Message error detail:Python Exception <ImportError>: cannot import name 'decodeWWJDString' from 'fmegeneral.fmeutil' (/Library/FME/2022.1/python/python39/fmegeneral/fmeutil.pyc)PythonFactory failed to load python symbol `fmepy_google_bigquery.connector.GoogleBigQueryConnector'Factory proxy not initializedGoogleBigQueryConnector_CALLER (PythonFactory): PythonFactory failed to process feature Can someone help me on this please. Thanks

Is it possible to move files to an error directory when a FeatureWriter fails? Unfortunately, I have not found a way so far. Is there any other way than to use an FMEServer Automation that triggers another FME Workbench in case of an error, which only moves files to a directory? Is it possible to achieve this with only one FME Workbench?

I am using the RasterDEMGenerator transformer to create a digital elevation model. The resulting raster cells cover the entire bounding box of my point cloud. So far so good.  What I want to achieve is, that such raster cells, that do not cover any point of the point cloud will have a "NoData" value. I have tried all of the available interpolation methods, but non eof them seemed to work in this respect.  Any ideas? Thank you

Anyone know why FME when trying to run a workbench it just hangs? Sometimes I can stop and start the workbench and it runs but it just says it is starting translation and stays like this and doesn't run anything. It was working this morning but now it doesn't want to play ball.

Hi,FME seems to display a single point from Oracle at the wrong location. I have a simple workspace with a SQLCreator with the following statement:select SDO_GEOMETRY('POINT(163170.864 501575.234)',28992) from dual I would like see the location in the visual preview so I have a background map which is a WMS in the same coordinate system: http://www.openbasiskaart.nl/mapcache/?  with the layers {Openbasiskaart}|{osm}. The point is shown at the wrong location somewhere in the middle of the sea. When I add a bufferer with 200 meters it is shown at the correct location. Is this a bug? I have attached my workspace (FME 2021.1.3)

I have read in data from an ArcSDE database and I would like to update data layers on ArcGIS Enterprise with this data. I am coming across two issues: 1 - My workbench FAILS with the following error: ArcGIS Portal Feature Service Writer: 'addResults' error for a feature in 'LAYER NAME'. The error code from the server was '10500' and the message was: 'Database error has occurred.'ArcGIS Portal Feature Service Writer: 0 features successfully written to 'LAYER NAME', but the server rejected the 100 features in the last request due to errors. See warnings above. Aborting translation2 - My workflow successfully completes BUT data is only truncated and no data is written onto the ArcGIS Portal data layer, so the layer is empty. The translation log says 'Total Features Written: 0' with no errors or warnings.  I am using 'Writer Mode: INSERT' (also tested with UPDATE but still get errors) and 'TRUNCATE FIRST: YES'. I have tested a

I am attempting to build schema features, with coded value domains, from a schema specification in Excel and to write them out to geodatabase with a dynamic writer. I am almost there, but I am missing something, and I do not understand the structure and requirements for schema features quite deeply enough to solve the problem. I have read through the set of Dynamic Workflow tutorials and other pages, like Deriving Destination Schema from Schema Feature, but none of them quiiite go far enough to address my situation. As I am building and writing out coded value domains, I am specifying the fme_format_short_name (= GEODATABASE_FILE) attribute on the schema features and including the attribute{}.native_data_type on all attributes in the list, with the value in the required "coded_domain( ... )" in the case of attributes with a domain. I also want to include the attribute alias in the attribute{} list. Finally, I have set fme_geometry{0} accordingly for each schema feature.

If I write to SDF the 'Has Elevation' of the schema seems to be on 'false' by default. My data has geometry with Z values, wich are visible if i open the SDF file in the data inspector. But the SDF schema stays on 'Has Elevation = False', wich means the Z value isn't shown in autocad map3D. How can I change this?

Hello all,I come from the BIM (Building Information Modeling) world and I have been looking for solutions to extract data from 3D models for a long time now. Recently this implied I had to try extracting data from 210 Revit models with an average file size of 200Mb. After different tries, I'm now on the FME desktop path, to which I'm fairly new to..., for testing with IFC (open source) files extracted from Revit models.Essentially there are a few key parameter in Revit Basic sample project in IFC from Revit (I think you guys call them attributes) that I would like to extract. Unfortunately, I see those parameters in different "viewers" (Navisworks, Solibri) from the same files I'm using for FME Desktop but I have no luck with the latter. I can expose those attributes but never get any values for them when exported to excel, SQL or event the FME data inspector (although I can see their columns). For now, the attributes in questions are "Assembly Code" and

Hi, I have 2 global counters with the same domain in my workspace (default parameters), but each of them is producing an individual sequence. As per documentation, this should produce for example 0-9 and 10-19, but I'm getting 0-9 from each counter... see the screen attached... am I doing something wrong?

Hi all,  I am trying to log specific messages during a translation, then add these messages to an email (using the Emailer) at the end of the process. I set up a logger with my message, then later down the process run the LogMessageStreamer to try and access the previous logger messages. However, nothing is coming through. Does anyone know what settings I should configure to get this to work? I have ensured that I'm running the logger in the same run as the LogMessageStreamer. Seems like a powerful tool...if it works. 

Hi,I'm having this error when I try to write the values in postgres through fme tool. The attribute has 6 possible values (0-6). what is the best way of solving this problems.Value of attribute 'n_lane' could not be converted to type 'int2'. Feature will be logged and skipped.And then at last the tool throws an error of insufficient memory available.I mean I really don't understand how to solve this issue..Please someone help me out with this.I'm attaching a photo so that you can have a clear vision of this error.​

I have an 8-bit mixed raster, where there are numeric values from 0 to 100, and then certain values over 200 are classified, 200 = water, 205 = snow, etc.Unfortunately there is a bit of noise in the data where there are single pixels coded as water (200). I would like to remove these individual pixels, replacing them with either a mean or majority filter (of 0-100 values only), without affecting any other pixel including 200 value pixels that are contiguous (so a straight convolution of the raster is out).The closest thing I can find is the Erdas Imagine Clump (to identify contiguous pixel groups) and either Sieve or Eliminate to replace groups smaller than a given threshold. https://hexagongeospatial.fluidtopics.net/reader/fH0o7KrMKUViXGUeoilQuA/cAzM7j6Akx80Fj5zsuhRFQ Any ideas of an efficient way to do this in FME? I have approximate 275GB of data to process.

Hi, I want to run a bat file on fme server. It work perfectly on fme workbench, but I get this message when I run it on fme server : SystemCaller_6: Failed to Execute `\\\\"filedirectory"\\"mybatfile".bat' I saw this post and tried the double quotes, but got the same result. https://gis.stackexchange.com/questions/303225/how-to-run-a-batch-file-by-fme-server Is there anything else I can try? Thank you, Ian

How can I extract MI_STYLE and MI_PRINX from the mapinfo tab to the writer? I am trying to write mapinfo tab files to SQL Server but it doesn't extracting these two columns. In past we used to use mapinfo easyloader. Can anyone help me? Thanks Mona

Hello all, We are in the process of upgrading our software to 2021 from 2019 and I'm in the middle of UAT. I'm encountering an issue with the scripts that grab data from a Google Cloud Storage bucket using the GoogleCloudStorageConnector transformer. In 2021, when I try to reauthenticate my web connection to GCS I get this popup: I wasn't involved with the script design for the 2019 version (and my colleague who was is on vacation for another week). I did some research and found out that the stock settings for the GSC webservice need to be configured to match credentials in GSC. I created a OAuth 2.0 Client ID/Secret in the Credentials page in the GSC settings, and insert that information into the Client Information section in the GSC web service dialogue (my understanding based on documentation is that default redirect Uri here should be left untouched). After adding these credentials and applying my changes, I am still getting the same Authorization Error when I try to te

Hi, Need to transfer a csv file to the vendor SFTP site.The vendor provided the following specs:Account: xyzftpPassword: xxxxxxxxxServer Name FTPCA1.xyz.comIP Address 22.222.22.222Location Microsoft Canada Azure CloudClient IP Restrictions Not SupportedProtocols SFTP (SSH File Transfer Protocol)FTPS (FTP over SSL), Passive ports 5000-5099Certificate Yes. For FTPS SSL EncryptionAdditional Notes - You must use an FTP client which supports SFTP or FTPS for connection to our servers.- Do not use a web browser. - Do not use the DOS/CMD FTP program. It does not support SSL.- Supported Protocols--SFTP - SSH File Transfer Protocol)--Automated login by public key is supported by request. --FTPS (FTP over SSL)--Both the FTPS Explicit and FTPS Implicit protocols are supported. --F13Passive ports 5000-5099 are randomly used for FTPS encrypted data transfers. Clients must be permitted to connect outbound on these ports. See below my FTPCaller Transformer based on the above:Does it looks correct? No

Is there a way to list out which published workbenches have 1 or more webhooks set up, and if so, when the token for each webhook expires?

Hello FME'ers, Welcome to What's Up Wednesday. A Big Thank You...I have to start by saying thank you to all the folk I interacted with at the recent FMEUC22. I'm overwhelmed by your love and positive feedback. As the song says, "I second that emotion"!  My only regret is it was such a crazy week that I couldn't spend as much time with each of you as I wanted.   Oh, and thanks to those who smiled and indulged me as I tried out my Swedish! I'll be better next time. Another thing for next time, jag behöver bekvämare skor! Conference Follow UpsIt takes a while to get the recordings taken at the conference, so expect presentations to start to appear online sometime in the next two weeks. I expect we'll start to get official photos of the event around then too. As for unofficial photos, I really like this one I borrowed from the Locus team post:  If you would like to share some of your photos of the UC, I created a folder on my FME Community repository for y

First, I have straight lines that are connected, then i extract end points and mid point (which I offset in direction of Z axis). From there I use these points to manually draw arc that connects these points. I want to know is there a possibility to automate this process. These lines are representation of wires between poles. I'm new to this software and don't have much of knowledge so any help would be appreciated.

Hi All, I have script written in Py3 in ArcGIS Pro 2.8, it uses pyodbc lib to connect to Non GIS SQL Server database. ArcGIS pro needs to be a cloned env.  I want to schedule this script as FME workspace (Ver 2021.2) using Python caller to run the script. The issue that I am having is that it’s not able to find the Cloned environment and not able to reach pyodbc library. I have implemented all the suggestions from this Safe Community Article.   https://community.safe.com/s/article/choosing-a-different-python-interpreter-installati#SettingACustomInterpreterForDesktop I am looking for some feedback on hoe to have FME Desktop point to the clone env. It points to the following path:  C:\\Users\\testUser\\AppData\\Local\\ESRI\\conda\\envs\\arcgispro-py3 I need to update so that it points to the following path: C:\\Users\\testUser\\AppData\\Local\\ESRI\\conda\\envs\\arcgispro-py3-clone The error that I am getting is: Python Exception <ModuleNotFoundError>: No module named 'pyodbc&#

It is better, if Safe software application login process is unique. Since, login process was not there for attempting for certificate exams. It is asking mail and other details. Instead, it would be better, if profile is created uniquely for desktop and server