FME Form

Currently, I have a dataset which looks like this:I am wanting to produce something that looks like this:Rather than having each different activity displayed as a separate field name, I simply want to convert this into a single field name "Activity" then list the different activity types as a value on separate rows instead of the field header. I then want to apply the relevant frequency field to each activity. Anyone have any ideas? Thanks in advance

The usage notes in ProjectWiseWSGConnector states:The FeatureReader can access ProjectWise directly (without using the ProjectWiseWSGConnector), however, a local copy of the dataset will not be created. But how is this done?  Thanks in advance.

The error in log isERROR |GEOJSON writer: Transcoding the binary string '\\xFF\\xFF\\xF9\\xFF\\x02\\x00@5^:\\xBF$)A`;\\xDF\\x0F\\xCE/)A(1\\x08,\\xC1$)A`B>\\x88\\xCE/)A\\x16\\x00\\x00\\x00E\\x00x\\x00p\\x00A\\x006\\....0' to another encoding can not be doneWhat's this mean?

I have an OS mastermap GML data file. I have multiple <osgb:changeHistory> tags for one particular featureID. Which is as below: <osgb:changeHistory><osgb:changeDate>1998-07-03</osgb:changeDate><osgb:reasonForChange>Modified</osgb:reasonForChange></osgb:changeHistory><osgb:changeHistory><osgb:changeDate>1998-07-03</osgb:changeDate><osgb:reasonForChange>Reclassified</osgb:reasonForChange></osgb:changeHistory><osgb:changeHistory><osgb:changeDate>2002-08-12</osgb:changeDate><osgb:reasonForChange>Attributes</osgb:reasonForChange></osgb:changeHistory><osgb:changeHistory><osgb:changeDate>2003-10-14</osgb:changeDate><osgb:reasonForChange>Position</osgb:reasonForChange></osgb:changeHistory> I am trying to read al

Hi,This isn't so much a question as pointing out a minor issue.The WorkspaceRunner transformer (FME 2022.1.2) doesn't allow the user to select an attribute value for the value of a parameter in the workspace to be called if that parameter is in a group:

I have a dataset of parallel lines that I have buffered (150ft) and dissolved into one polygon. My question is, is there a way I can preserve the actual flow (direction) of the main buffer, and split out where the buffer separates from the main path? I want to keep the main segment as one feature, and where it splits as a separate feature. In the image below kind of explains what I am attempting to do. Segment 1 would be one solid feature, while segment 2 would be another solid feature.    

From original source data, I already have created four corner points (in red) with correct XYZ values. I just need to connect these points and create polygons at vertical plane which will vertically intersect existing gray polygon at XY plane. Any suggestion ? Thanks.

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

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:  Th

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 th

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    sc

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