Transformers

we only have a colored point cloud that we want a model of for example for sketchup.There is no other data such as photosFiltering and creating a model works but I have lost the color information  

Is there any way I can use the http caller without an input (Can I start a process with that transformer)? My use case is that I'm trying to create Cityworks Inspections from File geodatabase records and update those inspections with records from the same File geodatabase. In order to do this I need to fetch all the Questions and Answers from the Inspection template to get a list of all the question ID's and Answer ID's. From there I need to somehow map the FGDB records to those Answer values based on the ID's. This would be simpler if I could just call the Cityworks API through the http caller to fetch all of the information as JSON without needing to feed in my GDB s an input. Essentially I want a list of all possible questions and answers for an inspection template to be used later on without having to first feed something into the http caller. Hope this makes sense. Thanks!😀

Input: Output:linear reference worked correctly to produce the shorter segment on the left, but it also copied the other Track 1 line (mile 1 to 36.81)Track 1 was originally a multi-part feature with a gap in the middle. I broke it to single-part thinking multi-part was causing the issue.I checked the linear referenced route data, the measure limits contain the input ranges.How do I know what went wrong?

Hello everyone,I have some shapefiles(sea, lakes or etc.) of the some water bodies of the city. And for a smart city study we processed and published cityGML models of buildings as tileset. Now, I want to visualize the water bodies as in the examples that I attached and I have shape files. So, how can I create textures via Translators of FME Desktop.Thanks in advance. @Takashi Iijima​ @jdh​ @Hans van der Maarel​ @danilo_fme​ @daveatsafe​ 

I have the first two pieces worked out thanks to some support from our community. Thanks again to @jdh for the support yesterday with JSON parsing. My workbench features two API calls. GET JOBS LISTGET JOBS DATAThey both work, but GET JOBS DATA is currently hard coded for one job.  I'm trying to loop through features within an attribute (JOB_ID) so that the GET JOB DATA API call can be looped against the JOBIDs from the JOBS LIST. How can I use looping to iterate a list of features into that API call? Thanks in advance for any guidance you can provide! 

Hi.  I am trying to create a workbench that transforms a certain csv file into one that my drawing program can understand. It uses semikolons as delimiters, but it also needs every row to have two semikolons in a certain place.  This is an example of how it should be: Auto0076;490496.620;6088527.736;0.733;65;; This is an example of what I can make it write: Auto0076;490496.620;6088527.736;0.733;65 How can I insert the extra two semikolons at the end? Regards Rasmus

I have a set of lines (transport lines), which frequently overlap. I would like to create parallel segments of those lines when they do, without breaking line continuity. The result would be similar to what can be seen on mist transport maps (such as [this one]).Is this possible to do this using FME ? I am aware that this is quite a complex process.Thanks in advance !

I would like to know if I can upload a custom font library inside TesseractCaller.

I'm looking for some transformer that would help me calculate the area of each raster value.  I tried vectorizing it using "RasterToPolygonCoercer" and then using "Area Calculator" and "Statistics Calculator", but it takes too long because there are many rasters and they're quite big.  Is there any other approach I could use?

My Feature Type has several attributes (eg. a, b, c, and s). One of them (e.g. s) is special , it contains the name (string) of one of the other attributes.Now I would like to test my features. I would like to use the string value content from this special attribute s (which for example is 'b') in order to define the left value attribute for my test, for example: @Value(b).Any hints for that are very welcome! Many thanks!

Hi all - Total FME noob here. I appreciate any assistance or advice you can offer... I am attempting to load a shapefile (https://healthyplacesindex.org/data-reports/) to SQL server. I can view this file in Data Inspector (uses CS_NAME: NAD83.CA/Teale). This file contains census data (with map polygons) for California (which I understand commonly has self-intersectors). I am getting errors when attempting to load this to a MS SQL (SSMS 18). The Writer throws many warnings but no errors. It appears to complete successfully, but no records are written to the SQL table it created. Microsoft SQL Server Spatial Writer: Coordinate system `NAD83.CA/Teale' (EPSG:3310) unknown to SQL Server; Labeling features as LL-WGS84 insteadMicrosoft SQL Server Spatial Writer: Failed to get the SQL Server native binary form for column 'GEOG' I am currently looking into adding a transformation for Geometry Validator, but I am hesitant to "correct" content if I don't know what I

I have a migration job from Oracle to PostgreSQL (PG). Null values in Oracle appear to be empty strings in PG. Null values are in both numeral and char data types. If I want all null values in Oracle to be also null value in PG, what transformer or method should I use for this migration? Thanks.

I everyone, I need to vertically shift data between two canadian orthometric heights (HT2.0 to CGVD2013). I have this conversion grid in .byn format (I get it from NaturalRessources Canada website) and create de .gdc file to use it in the CsmapReprojector transformer. However the CsmapReprojector transformer offers only orthmetric to ellipsoid or ellipsoid to orthometric handling, but the shift should be between to orthometric heights. So when I try both I get my data shifted up or down regarding to the vertical handling choice. But I have no idea wich one is the right shift ! Is there's a way to just apply (or transform) a .byn file for vertical shift ?  Thanks ! 

When using the JSONTemplater I want to be able to add a real boolean to the template and not get a string.I made a work around by replacing the text boolean by a real boolean: Has anyone figured out how to handle a boolean without the need of replacing?

I have 2 csv (these belong to Network dataset of arcgis; speed profile and daily profile). The SpeedProfile table consists of weekly patterns id (i.e for S M T W T F S) for various road links. These pattern id corresponds to hourly freeflow speed (1 hr interval). Basically this tells that for a particular road on a particular day of week what is the hourly speed variations. But arcgis needs data to be in speed factor or scale factor i.e. Freeflow speed / SpeedlimitIn order to obtain this I am trying to populate my speedprofile table with the pattern Id of each day so that I can divide the freeflow speed with speedlimit, get the scale factor, create a new table of these scale factor and repopulate fields with that table. But using FME I am not able to join the attributes for all the days, only 1 of them is getting joined. Any pointer on how can I overcome this?More details on tables: Historical traffic—Help | ArcGIS DesktopAttached is the speed profile table with column UMTWRFS being th

For my workbench I have one input dataset from an oracle spatial reader. The dataset has over 2 million features. At the moment workbench takes over 12 hours to run as the features get stuck at a featurejoiner transformer near the end of the workbench.

Hi everyone, I want to resample a raster A to a higher resolution, from 15m to 5m, in order to mosaïck it with another 5m raster B. However neither the RasterResampler on the raster A nor the RasterMosaïcker on both raster (raster B being the reference grid) allow me to do that and I always get 15m raster. Am I missing something here ? Thanks !

Hi all, I thought this would be straightforward but its proved anything but (probably its just me). I have hundreds of .csv files currently all named by a specific code. However each file also contains the name of the dataset in cell A1. Simply (i thought) I want to expose cell A1 so I can write it as the filename and bulk rename all files in the folder. Any thoughts and thanks in advance Chris

Hello, I am trying to extract a set of attributes that appear to be "grandchild" away from the parent feature. I am using the JSONFragmenter, and can extract from the parent using the JSON query: json["data"][*], but within this are four child attributes including "geometry", "properties" and "id".  I really want to split out a number of attributes within the "properties" section but don't know what I should put in the JSON query? Some of the desired attributes within properties are "laFeatureType", "reference" and "fieldName". But putting json["data"][*]["properties"]["reference"] in the query builder doesnt work.  Any help would be greatly appreciated 😀

I have an SQL reader the loads json and a geometry from a postgis tableSELECT $SQL$@Value(schema)$SQL$ AS schema,       attributes,       wkb_geometryFROM @Value(schema).features_addressesI have to do this as the database connection is dynamic as is the schema and cannot be fixed in a Reader.  My question is how do I extract the geometry as an FME geometry so it can be passed to a FeatureWriter? I tried using a GeometryReplacer and WKB format but FME rejects the WKB even though it is valid? 

Hi dear FME experts,I have a task to transform matrix style table into simple (flattened) one like on the screenshot below:I can unpivot it in Excel, but Is there a way to do this in FME with standard or maybe custom transformers?If yes could you please post some examples?Thank you very much in advance!

Bonus points if I can reproject them to UTM per layer! Thanks!

Is there a way to sequence wise send the geometry based on attribute value say "1" completely going through all the transformers and writing the output then again starting with attribute value "2" and writing the output, like in a loop. How can we do it ?

We have many geotiff files that have NoData Value specified or calculated in ArcGIS. Is there a way in FME to retrieve the NoData Value from the tiff's property?

I am working on a project involving vegetation near powerlines posing a risk. Currently I have the processed LiDAR data through VR Mesh which has classified the vegetation crowns, and an Esri shapefile containing the entire network. So far I have added a buffer of 50m and clipped the powerlines to the LiDAR area (only a small area). I now want to add them together and extract this information (distance, angle, height of trees), especially the X,Y,Z coordinates of the trees into an excel spreadsheet. If anyone has any knowledge on how to do this please share it as I'm new to FME.  Thank you,Ben