Transformers

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?

Hi, I want to dissolve all polygons that are under 1.5m2 into neighbouring polygons. I have managed to merge the 1.5m2 polygons that only intersect one other polygon. But with regards the rest, I want them to dissolve into the largest polygon it intersects. For example, if a 1.5m2 polygon intersects a 100m2, 200m2 and 300m2 polygon I want it to always chooose the 300m2. Thanks very much for any help. Kind regardsB

HiI have a tiled point cloud.I want to be able to test/check what tiles are intersecting, within, touching etc with polygons from a shapefile.If a tile is overlapping then the part that's inside the polygon needs to be ground filtered. The other part needs to stay the same.It seems that the spatialfilter doesn't work with a point cloud. I get the wrong geometry message. Is there another way or another transformer I can use?  *** Dont forget the World Tour Webinars: TUESDAY, MAY 5 2020***

Hello,I am converting a sewer network from CAD to GIS, and am attempting to convert flow arrows to flow direction in the output GIS geometric network. I have already successfully built out the conversion of the actual sewer features to GIS, and all I have left to do it get the flow direction set up.The flow arrows are drawn as triangular solids with separate lines (on the same CAD layer). Does anyone have any advice on how to convert this to flow direction in a GIS geometric network? I'm assuming the workflow will involve snapping the flow arrows to the corresponding lines, but beyond that I'm not sure how to approach this; I'm way outside of my FME experience level here. I'm guessing the Angle attribute of the line component of the flow arrows may come in to play as well. Any suggestions of transformers and order of operations are appreciated. Thanks. 

My duty is to read multiple CSV-Files my means of HTTPCaller from an online source into an attribute each, subsequently zip the CSV-file inside the very attributes, and finally write the binary attribute content (zipped CSV) to a PostgreSQL bytea-Attribute.I know how to read the HTTP source and write into the bytea destination attribute.QUESTION: How am I to zip a CSV-file inside a binary BLOB FeatureType attribute within the FME Desktop Workspace.Hint: I tried to use the ZipArchiver, but that one needs a file as source, as well as destination, but wouldn't work on attributes. Many thanks for any effort!