Transformers

I want to create a reference table within the workspace so I don't have to import another data source. I feel like I am missing something easy. I want to create a simple table ofRoleRateAdministrator£20Operative£30Manager£40Director£50 I can then join my data to it to get the rates.I would usually write the table in excel then read it in a featuremerger to match the rates in.I feel there must be a way to do this in FME rather than have to read the external data source. It must be more efficient. Thanks 

I have an ArcGIS Online Feature Layer with Fire Hydrant points, these hydrants have a unique ID from our asset management system. I am creating new points while carrying out inspection, using a mobile device, it creates a point within a few meters of the original hydrant. I want FME to grab this new point, move it over the original point, and insert the unique ID into a column of the new point. Is this simple to do? I have done some googling but nothing has jumped out at me. Thanks!

Hi, does anyone have any suggestions how to do this?I have a set of lines with measures and need to create points at each 1/10 measure value. A line with a measure range of 1 - 2.5 would result in points at measures 1.0,1.1,1.2,1.2....2.3,2.4,2.5The distance between the measure interval is NOT consistent, so length cannot be used.The functionality would be like the Chopper by measure interval.I'm using FME 2019.1. Thanks in advance!Kathy

Hello  I can't find a simple solution for the scenario below: if you look on the diagramm, I want to put my uuid value with fk_type=1 in the fk_parent_uuid field when fk_type=2 but I make a big package of spaghetti instead Would you have a brilliant idea ? thanks

Hello everyone,I'm new here, and hope I can use the friends' knowledge here.I'm trying to translate a CAD file to GDB. I have a template GDB file, and I want all the values from the CAD file to be passed by subtype and domains.I tried to move as I learned, and got stuck in some problems ...At the end of the process he writes to me: Translation was SUCCESSFUL.But the result is far from what I am looking for.There are 126329 warnings, and as a result the GDB is completely empty, not to mention that nothing entered the domain or the subtype. The transition, and its understanding, are really important to me for continuing to work, and I would be really happy if anyone could help.This is the beginning of the warnings:Then almost the warnings look like the bottom lines (104....) 

Hi Folks,I have a table CSV with these values :I would like with SchemaMapper, to transform Old componants (named src_cmp) and old attributes (named src_attr_1) and their old values (named scr_value) to New componants (named dest_cmp) and newattributes (named dest_attr_1) and their new values (named dest_value)I have used differents ways of parameters inside SchemaMapper, but didn't succeed.May anoone tell me if it's possible ?regards

Hi all,I wounder if anyone has a typical use case of the custom CoordinateSystemConvergenceCalculator ?https://hub.safe.com/publishers/safe-lab/transformers/coordinatesystemconvergencecalculator Basically my goal is to see if this transformer could handle the issue in Sketchup with the green axis versus the TrueNorth axis when geo-locating a model as discussed in this forum:https://forums.sketchup.com/t/solar-north-geolocation/18473/11  Thanks!

Hello,I have an export from callcenter software and I want to transform it like this.Original data is on the left and I want to become what's on the right. What I tried:Read the source Excel with columns A, B and C as attributes.Then with a TestFilter I created "Name", "Extension" and "Contents" port but I'm not able to join them.Any push in the right direction please? :-) Thanks and stay safe!-Jonathan

Hello everyone,  The Case: I have a 2TB Raster images source folder connected to a mosaic data set in fileGDB, I need to create/Publish workflow to clip a certain extent based on shapefile clipper to be uploaded by users on the server.  FYI: that the raster images/ mosaic dataset on a server and the FME is on another server.  The Situation:  Currently, I created the workflow below: It works fine from the desktop application a bit slow though.   When publishing I get the below:  How to make FME server connect to the file gdb with the raster mosaic dataset without uploading any files to the server?   

I have a problem using the appearance setter to apply JPEG textures to surfaces and outputting to FBX file (for input to Unity) using the attached workspace. The files appear to write out ok and I can see the textures applied in the Inspectors. But when I read the new FBX files there are no textures and I get this warning in the log. Any idea how to fix this?  "FBX_2: A texture used by mesh in node '' references a UV set named 'default', which doesn't exist"   

The starting point for my question is a table containing information about fruits and vegetables:IDNameTypeColorKcal1AppleFruitGreen522BananaFruitYellow893CarrotVegetableOrange414KaleVegetableGreen395ZucchiniVegetableGreen17 I would like to use FME to list all distinct values per column, including a count per distinct value, such as:ColumnNameVarietyNameCountNameApple1NameBanana1NameCarrot1NameKale1NameZucchini1TypeFruit2TypeVegetable3ColorGreen3ColorYellow1ColorOrange1Kcal521Kcal891Kcal411Kcal391Kcal171 I was considering to use an AttributeExploder to list all columns in separate rows, followed by a StatisticsCalculator to determine the count per variety. However, that seems to consume a lot of time for larger datasets (containing over 1.000.000 records).Does anyone have suggestions how to accomplish the above result in a better fashion?

During transformation, I don't want to change the position of attributes of blocks from Autocad.

I have multiple workspaces that are run in succession to process a job task. I need to collate some of the parameters that the user inputs into one file - csv or text doc, for QA and checking purposes. Is there a way to achieve this?

Again I hope the title is self explanatory, but below is a sum up;Say you start of by creating some attributes with an attributecreator;Then, when you connect an AttributeManager, it looks something like this;If you now want to create or include some extra attributes from another AttributeManager, you can 'paste them in'.First you select the row from another AttributeManager which you want to copy the row (right click on the row, and choose 'Copy Row' (or use either the Ctrl+C shortcut or the dedicated copy button));However, the problem then arrives when you paste this row into the original attribute ma

I am looking to filter out specific types of addresses from a full dataset of addresses. These addresses include points that can represent the main address (ADDRESS_BASE) (ex: 123 main street), or addresses that include a suite addresses (LVAPT_ADDRESS) (ex: #3, 123 main street). Scenario 1: If the main address and the suite address are all stacked at the same XY, then I want to select the main address (this isn't hard)Scenario 2: If there are groups of suite addresses with the same main address on a building but with each slightly different XYs then:Option A: if the group with the same main address is all on one building then select the main addressOption B: if the group with the same main address is on more than one building then keep all addresses. My brain is getting tired of running through different ways to make these different kinds of selections/filters. I have tried the Matcher because it includes a MATCH_ID

Hi, I have a landscape colored after value, and when I press inspector before features are written I can see them in perfect colors as they should, but when I open the written dwg in AutoCAD or Bentley Viewer everything is just red, and I dont know why. Pictures: The lines in wireframe view and conceptual view etc is just the same color in Autocad even when the look fine when inspected jsut before written, I tried using Regions instead but doesnt work. 

Hello, i want to use as input for the pointcloudcombiner certain files, which i have written in different attributes (neigbor_[0-7] of one feature (eg 2671_1262). These are the neighbouring tiles of lidar data. So far I have not found a way how I can pass the attributes (complete file path + filename) or a list as input to the PCCombiner. Is there an elegant way for this in FME?

HelloAfter an "attributeKeeper" transformer I try to obtain a selection with distinct value for each row like a "select distinct" sql command. But I fail to find a good solution. (I didn't find the DuplicateRemove transformer)Do you know to do it ?Thanks   

I am downloading my survey123 data from ArcGIS Online Feature Layer, and trying to convert the stored UTC into Local Time, and I have been provided this code, from this thread: @TimeZoneSet(@TimeZoneSet(@Value(shift_start),local),utc,convert) It initially looked good, but now I am looking closer at the results I am seeing the converted data is all out by +2hr. Where I should be seeing it converted to 8.30am,  they are all showing as 10.30am. And today we have started 'daylight savings' where we adjust our clocks by 1hr, my dates are instead showing as +4hr out! I am pulling my hair out as I have no idea where to start looking to resolve!I am unsure why this could be? Is there an adjustment I should be making? Is it a setting in FME? I am in Sydney Australia time zone.

Hi,i am using an AttributeValueMapper where i import an excel file. In the preview the encoding is correct, but when i complete the import steps, the encoding gets destroyed. I dont find any option to change this. Are there options to correct this or is this not possible or is this a bug?i am using FME(R) 2019.1.0.0 (20190710 - Build 19608 - WIN64)RegardsClemens

I am needing to test a DWG contains certain features for example a north point. If the drawing contains the layer that the north point is on I can use a range of functions to test if it exists i.e. tester, statisticsCalcultaor, etc But what if the north point is missing and therefore there is nothing on that layer, how do you test for its non-existence? 

Hi,I am using FME DonutHoleExtractor to identify (and eventualy remove) the inner shell of donut polygons on Cadastral Maps.Isolated inner shells are easily removed but in my data there are many encircled polygons that share one or two boundaries with the outer shell. In the image below I show two examples of this situation (A and B) and also an isolated inner shell (C).Is there a way to select/identify this kind of encircled polygons with FME?Thanks, Oscar

Hi Community, No question, just a tip to share... For a workflow we have to check for new observations in an ArcGIS Online Feature Service and send an email to relevant stakeholders. AGOL time is in UTC whereas the email is send in local time. To notify the right times we had to convert the AGOL time to local time and the email time to UTC. We use AttributeCreators for that. Below we share the code used for these conversions: # Convert input time (in UTC) to local time## Author: Egge-Jan Pollé, Tensing GIS Consultancy B.V.# Date: 24 October 2018## The date we get from ArcGIS Online (SRNL_CREATED_DATE) is in UTC.# To convert it to local time we first have to set the time zone to utc:## Step 1: @TimeZoneSet(@Value(SRNL_CREATED_DATE),utc)## Next we can convert it form utc to local:## Step 2: @TimeZoneSet(<Output from Step 1>,local,convert)

Trying to use DateTimeConverter to conver Oracle Date to PostgreSQL timestampz. Have tried multiple formats.Value of attribute 'start_date' could not be converted to type 'timestamptz'. Feature will be logged and skipped

The "Datos" table stores weather stations data. This query retrieves data from 00:00 to 05:00 (2020-03-29).This is my FME workspaceThe inspector window shows:In the "Fecha" column, dates from 02:00 to 02:50 are duplicated. Is it a MSSQL_JDBC_NONSPATIAL driver issue?