FME Form

Hello FMEers,Welcome to What's Up Wednesday. Academy UpdateThis week, the FME Server Authoring Trail has been updated on the FME Academy. As you might know, a "Trail" is an extensive course composed of multiple modules, so this is a comprehensive update.  In fact, you can see it's 7 hours of content, worth 4,000+ points, and even consists of multiple smaller trails: Publish Workflows to the Web trailWhat is FME Server?Publish Workflows to the WebCreate Data Integration Apps trailBuild Basic Self-Serve WorkflowsManage FME Server Data and ConnectionsBuild Versatile Self-Serve WorkflowsAutomate Data Integration Tasks trailBuild Basic AutomationsBuild Versatile AutomationsCreate No-Code Web AppsConnect Automations with Job Orchestration I think there's something there for all FME Server users and - as always - this content is free to access on the FME Academy. Esri ArcGIS Online Hub TransformersI may have mentioned these already, but, just in case you weren't awar

Hello FME'ersWelcome to What's Up Wednesday FME User Conference NewsIf you're attending the upcoming conference, then you'll be happy to know you can now officially create your FME UC Profile & Personal Schedule online and in the mobile app!  Basically, you can see all of the sessions, mark which ones you'll be attending, browse the speaker list, look at event maps, and check out our sponsors. One event on the agenda is the FME Hackathon, 6pm-9pm on Thursday evening, and for which I'm now pleased to announce the themes:  There are 4 themes (or categories, if you prefer), and you can choose which to take part in: The Peak of Data IntegrationJust for FunFME Server AppsAugmented Reality The Peak of Data Integration is where we want to see your great ideas for Desktop functionality or projects. For example, you might make a new custom transformer or workspace to process data in a specific way. Hopefully, you'll stretch the boundaries of FME as you do. Just f

Hello There we have a set of point features we want to filter the point that has the same distance +- 5m to each other as You can see in the picture we should keep 1 ,3.5, and 7 since there are at +- 5m distance and should delete 2 ,4 and 6 If we go with a neighborhood finder with a max length 5m will work but point 2 and 4 are also located at a 5m distance, the goal is to keep only one set of points the green or the blue  

FME Desktop Version: 2022.1OS: Windows 10 Pro TempPathnameCreator is not creating the full path in file system, omitting the last part of the _pathname attribute value. Note: Basename and Extension property input values were left empty.  At run-time, _pathname returned a path C:/Users/<username>/AppData/Local/Temp/wbrun_1663507413323_13720/fmetmp_0/1663508664728_25800_d\\tor690. However, only C:/Users/<username>/AppData/Local/Temp/wbrun_1663507413323_13720/fmetmp_0/1663508664728_25800_d\\ directory was found created, not found the sub-folder tor690 inside. One more observation is, although it's Windows OS, _pathname attribute value was following the unix path pattern (forward-slash), except the last part (it was backward-slash).

We have two formats to connect with SQL Server : Microsoft SQL Server Non-Spatial Microsoft SQL Server Non-Spatial (JDBC) What is the difference between them? 

When I add a feature type reader from AGOL, I get the coded values and not descriptions. How can I expose the domains on the reader for AGOL?

Does anyone know what causes the error?

Hi, I have multiple strings that are in this format 560_20170619_0900, I would like to remove all before and after the '_', leaving me with just 20170619. Is this possible using the attribute trimmer and regex?ThanksB

could you please take a look at this question, if you have any idea how to solve it we are taking a picture every 5 m, we found some duplicated area taken more than once how could we keep all coverage without the duplicate point, the sample data show only a few features we are running this on millions of features thanks https://community.safe.com/s/feed/0D54Q00009ltB8eSAE 

Hello There I have features that intersect with each other I want to create a group based on their interconnection as you can see in the picture there 3 group each group has features that intersect with each other to create a chain Thanks 

Hi, I am using FME Desktop 2019.2 64bit so cannot use the esri layer file reader (I am not sure this would give me the info I am after anyway as I want to interrogate the data source). I want to open an xml file within the .lpkx file to get the data sources from it (these are all buried in Portal with no way to get that detail using the Rest API - it seems). I have found them on the file system. Now I know I could use some python to unpack it - but using command line and 7-zip (or maybe one of the transformers on FME Hub) but didn't really want that extra step and then delete the unpacked version afterwards. So I guess my question is: Is it possible to change some configuration file in FME itself to recognise .lpkx as an Archive file? If so I would also need to do this for FME Server. This is probably not an ideal solution and the safest would be to just unpack it, then delete it afterwards? Kind regards John

Hey - I'm using a python caller to execute this script (shortened version of original script): --------------------------------------------------------------------------------------------------------- import fmeimport fmeobjectsclass FeatureProcessor(object):  def __init__(self):    self.Types = []    self.features = []       def input(self, feature):    if feature.getAttribute('_is_ftr_type'):      self.Types.append(feature.getAttribute('Feature_Type'))    else:      self.features.append(feature)       def close(self):    # Create and output a Schema Feature    schema = fmeobjects.FMEFeature()    schema.setAttribute('fme_schema_handling', 'schema_only') # indicates it's a schema feature    schema.setAttribute('fme_feature_type_name', 'MySchema') # schema definition name    schema.setAttribute('fme_geometry{0}', 'fme_area') # geometry type definition            schema.setAttribute('attribute{0}.name', '

I am currently processing a bunch of DWG files where the majority of them are working fine. There are a handful that result in the above question title as the error message no matter what transformer I use, how few or many CAD layers I involve, whether it is a new blank workspace or not. The error even shows up when I select 'OK' in the 'Add Reader' window and before I even select what layers to load in the following individual feature types window.  Any ideas on why this might be happening for some dwgs and not others? TIA

This error occurs once and and while and the issue resolves itself on it's own, sometimes the next day or sometimes it persists for several days. The issue seems to be with any transformer/reader that reads in oracle non-spatial tables.

I am doing the FME Server Authoring 2021.1 trainig and I see video day 3 is completely irrelevant to the FME server training modules. Now I started day 4 it seems few modules skipped as day 3 was not the correct video.Is there any other source to the trainig video that match with course modules?

Hi all, I am new to FME and am struggling with how to clip a raster and keep the z values. The raster is an ESRI ASCII file and contains flood depths around buildings. I want to keep the raster cells within x meters of he buildings and then calculate statistics based on the kept cells only (z_max etc). Any ideas on how to achieve this? Thanks in advance!

I have 3 counters in my workspace. And I want them to produce a single count. The documentation says : "When multiple Counters have the same name and Count Scope is Global, they produce a single count."  In my workspace the Scope of the Counter is set to Global but, I cannot figure it out how to write the same name for the three counters! When trying to write the same name for the counter transformers, FME (2021.1) automatically changes the names to Counter_2, Counter_3, Counter_X .... so I'm not getting a unique count for my workspace, what I have is three different counts starting from 0.  This is a basic question, Is the name of the transformer what I have to change to get a unique count? I'm sure I'm missing something and maybe someone can help me with this.  Thanks!

I've recently been getting an SFTP login failure when running my FME workspace. This was working back in July, but is now throwing the following errors:FTP info:  Trying 'SFTP IP ADDRESS'...FTP info: Connected to SERVERNAME ('SFTP IP ADDRESS') port 22 (#0)FTP info: SSH MD5 fingerprint: 'FINGERPRINT'FTP info: SSH authentication methods available: publickey,gssapi-with-mic,keyboard-interactive,passwordFTP info: Failure requesting identities to agentFTP info: Authentication failureFTP info: Closing connection 0FTP/FTPS/SFTP transfer error: Login denied Now, this I can still connect via my same SSH key using an FTP tool such as WinSCP no problem. I'm loading the private key via a SystemCaller and the following command beforehand:Start cmd /c "C:/Program Files/PuTTY/pageant.exe" C:\\PrivateKeys\\PrivateKey.ppk

Hello, I have build a simple Workspace App that copies folders for my users. Currently I provide the users with the network path to the Excel template in the Description section. Example: \\\\my_network\\Excel_template Ideally I'd prefer to house the Excel template in my resources folder on fme server and provide a link for them to download it from there eliminating any issues if a user didn't have access to the network path and thus couldn't download the template.  Is this possible without creating a custom html document?

Hi,I would like to sent a shapefile that is created with the workbench. When i use it without attachment the mail is sent. An mail with the attachment is rejected. What goes wrong? I tried with authentication but no succes.Who can help me?

Hi, I have two files one containing the solid of the building top and another has the solid of Building foot prints. I would like to subtract the top view solid from building foot print solid.  Can any one please help.

 Hello Community I’ve made effective use of HTTPCaller to connect to an external secure FTP. I then download that data to process downstream in the workspace. But can I use FME Desktop to upload to a secure FTP, or perhaps to an external API? Thanks,

Hi there,I have a database containing a BUILDING table which is related to a BUILDING_FUNCTION table.A building can have 0-n functions associated to it (i.e. Schools, Public buildings, etc).But it's more complicated than that. The functions are timely (Origin, Intermediary, Present)And there are three levels of details in the functions (I-basic, II-medium, III-detail) Here is an example simplied dataset for only one building, number 14...I need to denormalize this table to get only one entry per building.Here is the desired result. Note that in INTERMEDIARY functions, there are two functions listed. This is due to the fact that the a building can have more than one set of functions for each timely period. In the example above, where the TIME attribute has "2 Intermediary", you have two sets of basic-medium-detail FUNCTION_LEVEL. I'm joining an excel spreadsheet as sample data.Thanks a ton in advance for your help ! PS. This is somewhat related to my previous post but

I'm getting the "Error running translation" when using a JSONExtractor. I checked my api call that is getting the JSON from Salesforce and the POST to get the token/Auth in Postman and they return the data/auth fine. I've attached a logger to the in between of API caller and the JSONExtractor and the data is there. Been staring at this for a few hours now, any help is appreciated.JSONExtractor Custom Transformer that the JSONExtractor is apart ofWhere the transformer is getting called in main

Hello everyone, I have a question with regard to preserving the pattern style of hatches in DWG files.  I have a simple DWG file with two lines (blue), one text (yellow), a dimension (magenta), and a polygon (blue) which is filled with a hatch (cyan):  If I now simply read the DWG file with a REALDWG reader and do nothing but write it again with the REALDWG writer, the hatching pattern looks very different in the result - which is basically because the lines of the hatching pattern are much closer together than they were in the original DWG file:More details below. Does anyone know how I need to parameterize reader and/or writer such that the pattern style of the hatch is preserved 1:1? In the REALDWG reader, I already linked the read-in DWG file as a "Template File". This helped to preserve the styling of the dimension but unfortunately not with regard to the pattern style of the hatch.  Here some more details:Regarding the parameterization of the REALDWG reader, I only unch