Transformers

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

I see how to update individual fields of a record in a database at https://community.safe.com/s/article/update-only-certain-columns-in-a-database-table which seems straight forward enough. However, when I try this workflow on a SharePoint List I get an error. Does anybody know if this workflow works with SharePoint? If not, any pointers on how to update individual fields in a SharePoint List? Thank you.

Hi all,I have attributes streets for example below. I want to extract the attribute14 Le Thanh Nghi >> 1412B Gia Quat >> 12B3 Ngach 6 Ngo 12 >> 3Tran Hung Dao >> Null (Have not number) Could you tell me how to use regex function to make it?Thank you

i would like to reduce the features from dgn file to write in Adobe Geospatial PDF , any ideas please .thanks in advance .

I am working on a pipeline that will take unsanitised Revit and Rhino models to IFC to GDB. The discussion I would like to have is:I have looked at the older threads about this, and have found some good FME workbenches. the best of the workbenches do have unpredictable problems, for example i got this error "Expression: edgeCurves_[edge].has_value()". I will begin recording the fatal errors here and see if people have ways to address it.I havent found a way to build a GDB file that retains the layering in the original file. Anyone have done this before? Or is it not possible because of the IFC format?

Hello, I have polygon from postGIS DB and raster file. I want to use clipper to get part of raster file that is inside polygon which is used as clipper. Here is the clipper: It should be a 10x10 km box.Please take a look at min extents: 520000.0 , 6160000.0  And here is the clippee (raster file) And now I'm very surprised with clipper output (inside):  I don't know why that .3 appeared at decimal place? Do you know what am I doing wrong?My expectation is that it should start with border of clipper which is exactly 6160000.0  

Hi, I'm trying to create a single xml template that can handle dynamic attribute names. The attribute name to be used is stored in another attribute. Please have a look at how i set up the xmltemplater to write the attributes names:ROOT:<root> <a>head</a> <feat>{fme:process-features("SUB")} </feat></root> SUB:<f> <{fme:get-attribute("attr")}>{fme:get-attribute("value")}</{fme:get-attribute("attr")}></f> Where 'attr' holds the attribute name and 'value' the value.  I get the following error:The following error occurred near line 2, column 6 of the query: invalid expression: syntax error, unexpected character "{"An error occurred while parsing the 'SUB' sub-templateSo clearly this is not the way to go. Is this possible in anyway or do I have to define specific SUBs (conditional) for every possible feature schema? Thanks! 

I'm using FME Server and Desktop version 2018.1.2, I have a webhook in Cityworks when a service request is closed it should trigger a FME server process where it generates a pdf report and emails it to the requesterI have a parent workspace that gets the JSON from FME Server topic message. The workspace checks if a file exists and then runs two workspaces based on yes-no tree. The child workspace reads the same JSON and uses a cityworks connector transformer to authenticate to cityworks api to get service request details. The child workspace runs as a stand-alone process and successfully authenticates to Cityworks to get a token. However when run as achild workspace fails with the following error CityworksConnector_HTTPCaller(HTTPFactory): HTTP/FTP transfer error: 'Couldn't connect to server'CityworksConnector_HTTPCaller(HTTPFactory): Please ensure that your network connection is properly set upCityworksConnector_HTTPCaller(HTTPFactory): No proxy settings have been entered. If you requ

I noticed some strange behavior - when inspecting the data with the wild card to view all records with any value per attribute (in the Visual Preview or in the separate Inspector window) when there are couple of hundreds of records and tens of attributes (71 in this particular case) the tool is mixing the selected attribute and displays count of filtered records for the second one to the right (like in the picture below: I filter for all records with ObjSyleVoc value, and it is giving me the number of ObjUsageContextVoc. It also displays the updated table view for ObjUsageContextVoc, not the selected in the filter bracket. ) Any ideas why it is happening? It works for smaller tables...   

Hello all, I have a table that I need to pad with missing ranges following a small, specific rule set. Lets say I have the following table (in the attached spreadsheet):I would like to result in this table, which has new rows inserted with start and end values whos ranges were not represented in the initial table. These new rows have been flagged as "free" (also in the attached spreadsheet):The knowns and the rules are as follows:The quantity of groups is not knownThe quantity of subgroups is known, in this case 1,2,3The allowed range is known for each subgroup, in this case 0-10, 10-20, 20-30As a rule, ranges should not cross subgroup boundaries (see row 9 in output table)All values from 0 to 30 should be represented in each group To simplify the example, the ranges overlap. The real data type has decimal precision, which would result in the following ranges:0 <= SUBGROUP1 < 1010 <= SUBGROUP2 <2020 <= SUBGROUP3 <=30 Thank you in advance for the help.

Hey,I would like to know how I can split a Line from FeatureType A at the Intersection with the Line from FeatureType B. But then just keep the Lines from FeatureType A.With the Intersector I keep the lines from both the Feature Types. How can I keep the lines from only one of those FeatureTypes? Is there any Transformer I can use?Thank you,Best regards.

Can anyone help me with creating a workspace for comparing two DEM models? Let's say that an area was scanned twice and now my task is to create a map showing elevation difference. I would like to export a raster with RGB colour scale.

 Ideally I can read in the whole gdb and export to a csv that simply states the feature subtype and its total count of features. I know that exposing the "geodb_subtype_name" needs to happen to get those values. Can I avoid importing all of these and simply go from my single gdb reader, to the transformers that will give me the totals of each subtype? Below shows all the features that will then have subtypes within each one. I need to know the total of each subtype.

I was trying to write data from a JDBC connection to an ODS via a JDBC connection. Some times i am facing the below issue 2021-02-25 20:34:57|1245.3| 0.0|INFORM|MS Azure SQL Database Spatial (JDBC) Writer: Committing feature 197000com.microsoft.sqlserver.jdbc.SQLServerException: Read timed out at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2670) at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1990) at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:6494) at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7741) at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7700) at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.doInsertBulk(SQLServerBulkCopy.java:1615) at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.access$200(SQLServerBulkCopy.java:58) at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy$1InsertBulk.doExecute(SQLServerBulkCopy.java:709) at com.microsoft.sqlserver.jdbc.TDSCo