Transformers

I have a json file with 3 lists. Zip Code, Occupation Code and Number of Jobs. The index of each array is related to the two other lists by index. I've posted a screen grab. How do I write these to excel such that the columns are ZIP, Occupation Code and Number of Jobs? I have tried hours of experimenting. Thanks in advance for help.

Hi, i have a problem to write my INSPIRE XLM-File with the attribute pointOfContact.We had create a Inspire-Writer with the Schema of GovernmentalService30.xsdThere is a Attribute inside called pointOfContact{} but I cant fill this attribute with any value. Can somebody help me what can we do .?Jens

Hi,  I georeference a few images in ArcMap and .tfwx files are generated.  For some reason, FME doesn't recognise the georeferencing until I rename .tfwx files to a .tfw extension.  Should FME be able to recognise the tfwx file directly?  Thanks,  Annette

Some software (ARCHICAD) Supports Morph geometry. Can FME create these?https://helpcenter.graphisoft.com/videos/archicad/3d-modeling/morph/advanced-morph-modeling-techniques/archicad-16-the-morph-tool-toggling-the-display-of-hidden-morph-geometry/

I need to extract from a raster imagery (Geotiff ) only the pixel with a specific range of valuesI mean I need to return points that corresponding to the pixels with these valuesRed between 245-255Green between 245-255Blue between 245-255

Hi,Using FME desktop 17 I have a series of HTTPCallers containing GET and POST SOAP requests, however I cannot find either the suitable transformer or parameters to extract the fields required.Attached sample XML file and parameter I need to extract and store are -<report_id>form_name<report_date_time><report_uprn><report_usrn><report_status><questionnaires> (all que_key & que_ans fields) Failed attempts using XMLFlattener & XMLFragmenter. Cheers

TIFF and TFW file validationThis is a bit of a cry for help as I’m still quite new to using FME. I am looking to create a FME workbench that can validate some specific parameters for TIFF and TFW files. It is a TIFF file TIFF file size – This should be equal to or greater than 46MB – Equal to or less than 47MB TIFF dimensions – they should be 4000 * 4000 pixels in size It has three colour bands It has an associated, valid TFW file I’ll roughly have to check 100 TIFF and 100 TFW files at a time. The TIFF and TFW files have the corresponding 1KM grid reference as their names, for example I have TQ7926.tif and TQ7926.tfw.What would be the best way to achieve this in FME? I’m happy to answer any questions to assist with the answering of my question.

Hello, I have a rasterdataset in a Raster-FGDB. This rasterdataset should be expanded by adding other rasterdatasets (a successive expansion as needed). Is it possible to do this expansion? Thank you very much!

Hi all,I’m trying to extract 3D data from a 3DCityDB (PostgreSQL) and write them into a sketchup file.I have no problem handling the surfaces and writing them into the .skp file as buildings.But I have an issue with the textures. I manage to get the right images on the right surfaces but they are not in the right place. I get the texture coordinates in a field, and they are stored as below (u,v coordinates list) : But I don't know what to do with these coordinates... And how ta handle them with TextureCoordinateSetter... Any ideas ?The idea would be to create a custom reader for the 3DCityDB format and a workbench to extract data from the DB in sktechup, multipatch,… It’s already done without the textures, but it would be great (and usefull) to get the textures right. Thank you in advance, Fabien Laganne

Hi. I tried a lot of formats to convert 3d tiles, but the result was not good.I mainly want to talk about some of the problems with the coordinate system during COLLADA's conversion of 3d tiles.There are two sources for my COLLADA files, the first one is exported from Blender software and the second one is exported using the openCOLLADA plugin for Autodesk 3dsmax software. In order to find a suitable coordinate system, I used a model with only one green sphere to do the test. I use the default parameter settings to read the COLLADA file and select unknown and EPSG: 4326 (wgs84) coordinate system.The coordinate system of 3d tiles file is same as source.When I load the exported 3d tiles into cesium, there are three results. 1?The model appears in the center of the earth.Cesium currently does not support placing models under the ground, so nothing can be seen. 2?The model disappears in a flash, and the camera catches the ocean. 3?There is the strange result, I do not know how to descr

Hi,Is there a transformer that undo a densifier? I used the densifier to get a better snapping with points, but after the snapping I want to get rid of all that vertex because the file is getting too heavy.Thx!

I have a problem which seems to be quite random. I am creating a Raster from polyline feature class. I use SDE Feature Class reader, AttributeCreator/3DForcer/NumericRasterizer - and SDE Raster Dataset as writer.Strangely - this arrangement works for some reader FCs - it fails for others with the message: Failed to write raster data tile when writing to raster dataset.The readers (both successful and not) - are derived from the same large FC (same attributes) - so can't find any obvious relationship on this side... Any ideas what to look for? Thanks

I am a new FME user and am trying to create a solid model consisting of terrain, roads and buildings to be printed out with a 3D printer. With help of transformers I created an aggregate of a terrain model from a point could and clipped out the roads that run on the terrain. I have also made another aggregate consisting of buildings that are created by extrusion from roof faces to the DEMRraster. I aggregated these 2 aggregates into one it looked complete but when I printed out the object, it appeared clearly that there are two separate components set together. How can I create only one solid object? End result is to be a WaveOBJ file which I will use in 3D printing. I passed the aggregate through a SolidBuilder transformer but the resulting solid has holes. I have also tried using the Solid Dissolver instead of the Solid Builder but was also unsuccessful. Please help. I am working in FME Workbench 2017

We have numerous Statistics workspaces analysing Oracle data on a daily basis. After updating FME from Build 17259 to 17539 (also 17650), our Workspaces produced nothing anymore.The results of the statistics are written to Excel-sheets, so I began debugging the workspaces and found the statistics calculators producing only null-values.Even after creating new workspaces with simple example data (creator, randomnumbergenerator) statisticscalculator outputs null-values.

The TESTER transformer let pass only 32bit INTs when using 'type is' Integer as operand. I need to test if the value is 64bit Integer or smaller (but no double or float).I used also AttributeValidator with the same result. 

Hi,I'm trying to programmatically assign colours based on an attribute to 3D geometry features for visualisation in Data Inspector. However, I can't work out how to do this without splitting features using a filter and then branching to loads of different ApperanceSetter transformers and setting a separate colour in each of those.I discovered there is what looks to be a very helpful custom transformer called GradedColorizer which has a few algorithms for binning an attribute value then assigning a fme_fill_color property. However, setting that fill_color property doesn't actually seem to result in my model being shaded correctly in Data Inspector (ie. still appears as a wireframe, see image below).Any ideas why this might be? If I use ApperanceSetter it works fine, but I can't programmatically set the colours using that.

Hi all,I was unable to find an answer I needed so I thought I would post.I have been using the StringReplacer and am trying to learn the regex commands to no avail.I have a column with values that are mostly numeric, some alphabetical, some blank and some number with decimals. I would like to ensure that every number that does not have a decimal gets a decimal added to it.Example of value range:000625.224512566254662512566751256.335TLL003640.123CODDMy ask is how can I use the StringReplace (or any other transformer) to take the numeric values here. And insert a period in between the 6th and 7th characters. Leaving 6 before the decimal and 3 after.To note. Every numeric value that has a decimal is 10 characters. 6 before the decimal, one decimal and 3 following. Every numeric value that does not have a decimal is 9 characters. I want to keep all Alphabetical and Null values untouched.Thank you for your help!

Hi all,  In the middel of a workbench I want to do some kind of schema check for my 100+ attributes: All values of attribute 1 are composed out of less than 255 charachters All values of attribute 2 are composed out of less than 50 charachters All values of attribute 3 are integers out of maximum 10 numbers All values of attribute 4 are decimals with maximum 10 numbers before and 3 after the decimal seperator All values of attribute 1 are dates ...  For the charachter fields I can work easily with the StringLengthCalculator and statistics calculator. But the number and date fields are a bit less easy.  For the number fieds I split them at the decimal seperator and check the length of the first and last part and with a StringSearcher I check if there are only numbers.  For the date field I split it up by day - month - year and check if the value is below 12, 31 or 9999  This all seems a bit "dumb". Is there some kind of intellegent way to check type and structure of each attri

I have this topology and would like to merge the red segment with its corresponding blue segments. (Blue segments are on both side of the red segment.) I can group all red and all blue segments but I haven’t an attribute to group the related blue and red segments. Is there a way to do this with FME? Thank you for the help.

Hi,I'd like to do an offset for polylines (left or right) with starting distance d1 and ending distance d2). is-there a simple way to do that (affiner with some explication please or another method))thanks.

Hi, sorry for something probably very basic.In my geodatabase I have a polygon featureclass with a lot of attributes. On a regular basis I receive new polygondata in the form of Shapefiles which shall be written to the existing featureclass.If the new data from the shapefiles do not overlap the existing data, they are inserted to the geodatabase (via fme_db_operation = INSERT).But if the new data overlap existing data I just want to compute a new geometry for the polygons with the Dissolver and update the geometry in the geodatabase with fme_db_operation = UPDATE.The geodatabase writer is in UPDATE writer-mode, and I specify an "Update Key Field", but still run into (the probably famous) error number from ArcObjects '-2147220985'.Could be a number of reasons probably, I have a feeling it might be that my "Update Key Field" is not an ESRI ObjectID but I am really not sure. Comments, ideas, help is much appreciated. bestPål Herman 

I have managed to create fast writer for many 3D-formats - except 3ds. I am writing a terrain model, buildings, roads, water, trees. I have tried combinations of MeshBuilder, Triangulator, GeometryCoercer, Deaggregator etc. However it seems that when writing to 3ds it still takes alot of time (6 hours, compared to 15 minutes with the approx 10 other 3d-file formats).If I create the data to an IFMEMesh before writing I assumed the writing would go fast. I am using a FeatureWriter to start the writing at once. I havent added any textures on the terrain model - so that does not slow things down.Does anyone here have some tips with respect to this particular format?@takashi