Transformers

With FME Server 2019, I'm using a workspace that runs fine in FME Desktop, which uses a Published Parameter used with a regex select in an Oracle query. If i try to use the default '^\\w' parameter value with Automations, it is changed to '^w' before running in FME Server. Is there a problem using the '\\' character?

Default units when writing to FBX is cm (according to the logfile). I need to write to meters. I have tried using the Scaler, Affiner etc, but the "header" of the FBX still gets written as cm. I also tried to write to ASCII FBX and see if I could scale up the file afterwards - but with no luck. Now I tried to create a new coordinate system that is a copy of an existing one - but with units cm instead - to see if this "tricks" FME to think it is already in cm - even if it is in meter.The issue is that the opening software (Navisworks) seems to try to convert the geometry but not the material/texture/raster-coordinates. Anyhow it might be usefull to be able to write to m instead of cm.

I am using a sorter in 2019.0 right after a FeatureJoiner. I have two fields where all the values are changed after the Sorter. I create the fields using the sub() function in an AttributeManager before the join and sort. Many of the values are null. On the other side of the Sorter they're numeric with a maximum of 255 (telling). Anyone else observed this? If I run the Sorter prior to the Joiner I do not see this error. I'm sorting on a couple of other fields, and neither of the fields that are being updated.

Hi,I would like to replace the texts in my excel list (possibly also different formats).for example:in Python it looks like this:in Attribute "street"def replace(field):if"straße" in field:return field.replace("straße", "str.")elif"Straße" in field:return field.replace("Straße","Str.")elif"strasse" in field:return field.replace("strasse","str.")elif"Strasse" in field:return field.replace("Strasse","Str.")elif"ä" in field:return field.replace("ä","ae.")elif"ö" in field:return field.replace("ö","oe.")elif"ü" in field:return field.replace("ü","ue.")else:return fieldwhich transformer should I use, and how? I have no experieces with it.Thanks

Hi thereMy first post here, so be gentle. I have made FME workbench to calculate different kind of attributes from DWG file (line lengths, areas etc.) and export the results to Excel file. The idea is that the workbench calculates the chosen things from DWG file and distributes them according to the divider area. Calculating part is working like a charm, but I have a problem with arranging results to form I want. It is hard to explain (in English what I mean, so here is the picture that hopefully explain what iam looking after. I have spent way too much time to solve this problem by myself, so I am more than happy if someone could push me to right way.Thanks in advance!

A client at the FME World Tour in Singapore has the following questionIf I have 2 rasters (jpegs) of same image BUT different resolution and scaleWhat would be the process in FME Workbench to align them@darkspatiallord @brianatsafe

Hi allI have been tasked to try to autogenerate 4 districts based on the values of a number of points that fall within a polygon boundary.Basically I have to split a polygon into 4 parts where the sum of a number value of the point dataset is a close to equal as possible.I cant upload the real data as it is sensitive but I have created a polygon dataset and a point dataset500 random points inside a box polygon. The points all have an attribute called "value" that is also a random number.Does anyone have an idea for a workspace that can split the polygon in the box shape file into 4 coherent parts where the sum of the points falling withing the split polygons are approximately equal?Best Regards Morten

Hi all,I think I have a quite simple question here. But i'm stuck in my thoughts.I have a dataset (see left table in picture below) and I want to have an overview of which numbers are in a certain cluster. Does anyone have some hints for me?Thanks in advance!

S3-connector - what happened? Do we have a murder case - its gone?

I want a polygon that contains all points per group. (postcode)BUT the polygon may NOT contain points from another group.I want the maximum area. but it must not overlap.I have used the HullAccumulator but I get an overlap with that.the red line is what i want.

Hello FME community,I am quite a beginner with FME and I have point shapefile includes country names. Each country name divided into 2 parts and the 1st part ended with (-).How can I combine a country name and remove (-) in the following list?To this:For each name sometimes 1st part sorted at end, for example Camb-Does anyone have any ideas or potential solutions?@takashi @david_r @jlutherthomas @egomm @mark2atsafe

I've received this error -- Implicit NAD27<->NAD83 grid shifts may not be performed until Canadian or US grids are chosen -- running a workbench in FME Server that contains a CSMapReprojector reprojecting from NAD83 to NAD27. I remember choosing the US grid shift when installing workbench on my desktop, but don't recall an option for choosing this when installing FME Server. I think some information is given on how to rectify this in FME Server in the log file, but it is not adequate for me. 

I am supplying a list of 113 list attributes from a ListBuilder to a ListConcatenator How do I get this to concatenate into one long string with comma separator characters.My Results output is just    

I have two separate flows for a process as shown below (upper and lower). These two flows are separate but it is required that the lower workflow must be executed after the upper workflow has executed. To handle this, I have created two separate workbenches for each flow and i am calling the second workbench after the upper workbench has been run. Is there any way, I can merge these two workflows in a single workbench and have control on which workflow executes first? 

I have a lot of points, like a grid, that I would like to transform to polygons. Any point that is closer to 0.5m should be joined to forme the polygon. Any point with no close neighbor can be ignored. Any suggestion is welcome :) 

Hi Jim and team, We hope this resource will be helpful as we continue to build on our partnership. You can select "New Question" from the top menu to add a new post and we can then discuss and collaborate from there. Ensure you select "Avineon" as the space you want to publish in to ensure it stays private for us. Thanks,Nick

Dear all, I have some data that looks like the first table. I usually use Microsoft Access to create a cross-tabulation as in the second table. Does anyone have an idea of how I could accomplish that in FME?  Thanks!

I have been tinkering with the /opt/fme-engine-2019/fme APPLY_SETTINGS a bit.I was wondering which other commands and options are there? How are these settings stored?Browsing the safe-documentation I only found the helpful LIST_SETTINGS and options to configure both python, R and some proxy settings.I did an upgrade (deinstall - reinstall -restore from backup) and the settings were just as they were previously.At this moment I would like to 'revert' some entries I made, but DELETE_SETTINGS is not an option apparently. Neither is PURGE_SETTINGS to restore them to the install-default.Thanks for taking notice..Martin

When using Test filter, how do I capture todays date -65?SQL Statement would read "Field_1" >=(GetDate()-65)

I am looking for a way to update/load data into a SQL Server database by using FME as an input form

Hi FME'ers,I have a dataset containing points. I would like to group them so that there is n points per group by proximity. Imagine a voroni diagram but instead of 1 point, its n. For Example, I have 30 points I have want to group them into 3's. This would give me 10 groups with three points each and they would be the nearest points to each other.Thanks,David

I'm trying to create a bunch of graphs where data comes from different data sources. As a consequence the length of the attributefields differ (i.e. some fields are missing when constructing fields af the same length). What I would like to plot is x against y and x against y_incomplete in 1 graph:x y y_incomplete 1 1 <missing> 2 3 3 3 6 7 4 9 <missing> 5 12 4 6 15 8  However, this raises the error:ChartGenerator: Non-numeric input provided. Please validate that the values of the "X Attribute","Y Attribute" and "Error Attribute" (if supplied) are numericChartGenerator_2(PythonFactory): PythonFactory failed to close properlyChartGenerator_2(PythonFactory): A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for details It would be nice if the chartgenerator could handle missing data or in the settings you could set a no data value. Or am I missing something and is the chartgenerat

 I am trying to transpose the data from rows to columns. I have attached the example of the final output and my template as well. It would be great if anyone could help me with a solution. 

FME-newby question: I selected multiple files (.dwg) and dragged them into my workbench. IFME now sees it as 1 input, so when I extract the points I need I get one output, but I want 1 output per file. How do I assign unique values to each file/layer? In short: i have surface profiles as .dwg and i want to turn every single file into a profile in excel. 

Hi all,I'm getting some errors trying to display a HERE background map in the Data Inspector. I'm trying to pull up the satellite.day map Error: (log attached) Cheers, Ed