Transformers

Hi,I'm trying to create Index on attributes for a feature class inside FGDB. I'm using SQL to run after write option available in Feature writer. But i'm getting invalid sql statement. But it works fine when I tested in sql developer. Below is the sql, FME_SQL_DELIMITER ;DECLARE strColumnNames VARCHAR(200); P_COLUMN_NAME VARCHAR(200); strStatement VARCHAR(2000); P_INDEX_NAME VARCHAR(200); P_TABLE_NAME VARCHAR(200); ind NUMBER; indexCount NUMBER;BEGIN strColumnNames := '@Value(idx)'; P_TABLE_NAME:= '@Value(processname)_WM'; ind := instr(strColumnNames,','); indexCount:= 1; WHILE ind > 0 LOOP P_COLUMN_NAME := SUBSTR(strColumnNames,1,ind-1); P_INDEX_NAME:= P_COLUMN_NAME || '_' || indexCount; strStatement := 'CREATE INDEX ' || P_INDEX_NAME || ' ON ' || P_TABLE_NAME || '(' || P_COLUMN_NAME || ')'; dbms_output.put_line('Statement is : ' || strStatem

Hello, I'm having issues when trying to get the BulkAttributeRenamer to perform the following: I need trim all attribute names down to only 10 characters in length. When I set the Parameters for Action: to Regular Expression Replace and use this regular expression:^.{10} I'm able to match all the first 10 characters, but I actually don't need to replace these, I just want to use the matches to become the new attribute name. Am I going about this the wrong way with a regular expression? Any help is greatly appreciated.  Example:Old Attribute Name ----> AREA_IMP_TEAMNew Attribute Name ----> AREA_IMPL_ 

Hi, I am having a litlle trouble on labeling the road network using mapnikrasterizer.I am looking for some advise on this matter.So I am creating a tilled map for UK on a large scale, unfortunately I am not being able to label the road network, I have tried a lot of parameters, but I haven't reached my goal so far. please see the image bellow, as you can see the roads doesn't have labels at all. the image bellow show the parameters, used for labeling please let me know if you have any idea on how to manage this thanks for your help

I have a dwg circa 1998 that contains among other things contours and spot elevations. All of these features exis in 3d within the dwg I have confirmed this using AutoCAD viewer as well as the FME inspector. The only place I see the elevation value is in the coordinates section in FME Inspector. I would like to covert these features to a shapefile and capture the elevation as an attribute but don't know how to expose this elevation value. 

Hello everyone, I have a street centerline dataset and I would like to identifying where there are T intersection (3 centerlines intersect at same point). Here is the image and I would like to find the highlighted lines. Thanks in advance. Best,

please see below the json response from a httpcaller transformer.  I want to extract the items (only id and type attributes are interested) and format them to new fme features with 2 separate fields id and type. I have tried JSONFragmenter (setting like below). However the output gives me a flat table with 704 records (352*2) like below. How to output a table of 352 records with two fields id and type?{"total": 352,"start": 1,"num": 352,"nextStart": -1,"items": [{"id": "5c6729ea37f84ffbb9ece1f428d83bf4","owner": "Admin","created": 1425413285228,"modified": 1547658596161,"guid": null,"name": null,"title": "World Population Density","type": "Map Service","typeKeywords": [6 items],"description": "","tags": [5 items],"snippet": "World Population Density data service provided by ESRI","thumbnail": "thumbnail/World_Populations.PNG","documentation": null,"extent": [2 items], 

I'm new to FME. Just upgraded to FME2019 and since then seems that stability issues have multiplied. Workbenches that worked fine, not crash in the middle of the process. Most of the issues seem to be related with temp files. Provably FME is trying to go through temp files stored in the previous version? Are there any recommendations you would make in order to prevent these errors from happening? Maybe making a clean-up of FME temp files?

Hello,I have an external code in PythonCaller that generates a segment_id for each feature. and I would like to understand what it is doing exactly and what does the  if (feat_i*self.sampinv) % self.count==0.0 expression mean. It looks likedef close(self):             group=0        for feat_i in range(len(self.feat_list)):            if (feat_i*self.sampinv) % self.count==0.0:                group+=1            self.feat_list[feat_i].setAttribute('segment_id',group)            self.pyoutput(self.feat_list[feat_i])

Hi all,I'm quite new with FME, so I hope you can help me. I would like to change the value of multiple rasters. I know you can do that for one raster, but I have a lot of rasters (>200). Is there a way to this?I'm using FME desktop 2018.1.Many thanks in advance.Kees

Hello, I'm using sampler to reduce the output. If some parameters are set then I want to only read n rows and then move on with processing without reading all the rest. I know that in feature reader there is option to set: max features to read but then I perorm some polygon filtering so there is a chance that if i set it to 1000 then 0 features will be stored because none is inside filter polygon. Sampler works great but problem with it is that after sampling first n records it still keeps on reading new features but it forwards it to notSampled port.  So is there any option that would stop reading more features after reaching given number?

Hi, I'm trying to expose attributes from a JSON file using JSONFragmenter and it's working perfectly fine for all attributes except one which is stored in [] brackets. This is an example of how the JSON is structured:  [{"id":"5cad42","nummer:"697582","name":"place name","position":[51.51146259999999,11.5696619],"status":false}]  And once I have exposed the attributes I see all values except "position" value is missing, so I assume it has something to do with the [] brackets.  These are the JSONFragmenter Parameters:  Should something be changed here? I know it must be easy :) Thank you! Cheers,Linda

FME Server 2018, running distributed engines, mix of 32 bit and 64 bit. What I am seeing is that the some features when reprojected (using ESRI Reprojector NAD83 to North_America_Albers_Equal_Area_Conic or using the FME Reprojector Read from feature (ll-83) to say UT83-N for example, a few of the resulting coordinates are different about the 9th decimal place (from what i have seen only the Y coord gets tweaked) . Not enough to really mean anything, but enough to cause a different CRC value or for the ChangeDetector to see them as different. Any thoughts on why 64 bit Engine might result in very slightly different coordinate values ?

 HI there. I'm fairly new to FME and very new to the 2019 version. I know that ChangeDetector has undergone a revamp and so I have replaced my updateDetector transformer with it. I have read that you can use an optional feature in the Parameters box which will generate a list of the changes that have been detected between datasets. I've added a List Name but i'm unsure where to view this list? Does anyone have any ideas? I've checked in the attribute table for the Updated output layer but there is nothing in there. Thanks for your help!

Hello, is there a way to finish job under given condition before processing all features? I know that there is terminator but when job is started from job submitter then probably result will be on failed port while it is a completely valid situation. Thanks for help :)

Hi there,I'm trying to convert a set of shapefiles to DGN (microstationV8) format. I do have a Seed file which I can specify in the writers. However, I'm not sure how to actually read the seed.Truth is, I don't quite understand what attribute relates the source data to an entry in the seed file. My mind says that if the seed has an entry for a blue line classified as "motorway", I still need to specify what in my shapefiles qualify as "motorways".Is it perhaps based on the name of each writer? Or am I misunderstanding these DGN seed files completely?What I do understand is the the Seed functions as a template. Still, as with any template, there must be some kind of attribute that dies the seed to the designated feature.Any help on the topic will be greatly appreciated.

I need to create a heat map that splits up square polygons into all of their overlapping portions and attributes each with a count of how many overlaps there are.First I ran a dissolver and assigned IDs to each region:And then I ran an AreaOnAreaOverlayer with a Group By assigned to the IDs for each region. This meant that the polygons were only compared against other polygons that they might actually intersect rather than everything in the whole world. From this I got a count per box which I can use to create a heat map:The problem is that in the Middle East region of the map, there are so many polygons (~14,000) that the AreaOnAreaOverlayer is failing long before it has managed to process all of the polygons in that area. This means that this is the only area for which I cannot create a heat map. Going forward, it might be that there are far more polygons than that that all overlap so potentially this problem is going to get even worse.Does anyone have any tips on how I can create a

Does any know of a method of finding all 'kickbacks' within a polyline or polygon dataset, and then repairing/removing these?A kickback is defined as:The internal and external angles between two segments are less than the set parameter in degrees e.g. 45 degreesThe distance between the external spike and the external polygon boundary and the internal spike and the internal polygon boundary is less than the set parameter in metres e.g. 10mFME has a transformer that deals with Spikes, but I cannot see an equivalent for kickbacks.Thanks in advance

Some of my team attended the World Tour in Austin yesterday, and we wanted to share some of the AR presentations with our directors. Are these available anywhere? The AR leveraging the indoors mapping for intraoffice route finding was especially interesting.

Hi all, I have a JSON file. Each object in the file has the coordinate of the start and end point of a line. I would like to transform it to geojson file with linestring. Any ideas how can i do this? Example:{        "cityName" : "Brussel",        "endPoint.x" : "4.31888222694397",        "endPoint.y" : 50.79171001911163,        "startPoint.x" : "4.3186622858047485",        "startPoint.y" : 50.79149007797241 }Best

Hi! I'm new to work with Autocad and SVG-files in FME. I'm trying to convert 500+ Autocad-files to SVG-files and most of the SVG files get correct. Attached is a workspace with an Autocad-file that doesn't get correct. Open the Autocad file in Autocad to see how it should look like. Why does the SVG get incorrect, and is there anything I can do to get it correct?  Best regards, Ken Karlsson

Is it possible to keep the order of the query fields when you get the attributes using 'Populate from SQL Query...'? I use it very often and the attributes are ordered alphabetically instead of the order in the query.Thank you

I am trying to use the 2DEllipseReplacer, with the same minor and major axis properties but different rotation angles(30 vs 60). The output received doesn't look right. Please see attachments for more details on parameters being used and result received. Thanks in advance for inputs and suggestions to fix this issue

Hello All, I am using API for retrieving data, post call need be formatted to specific format I have used template to create and upload by post call in HTTPCaller. Template created from ESRI Shapefile it is working fine. The problem that everything is being loaded into the JSON upload body. But i would like it to be split by e features before it hits the HTTPCaller. If the count is limited it is working but with heavy data API get overloaded so I would like to hit one by one does any one have solution how could I can be done please find attached FME Workbench for reference.  

Hi,I have a big workspace that can potentially stop at different steps because the workspace is going through multiple readers and some of them can have no features.Is there a way to execute a SQL script whenever the workspace is stopping ?The goal of this script is to check some integrity rules in the database (Postgres).Maybe the python shutdown script could do that but maybe there is a simpler way.Thank you for any help.

I'm trying to create a word doc report containing photos and tables for each feature in a points shape file. I've managed to get 1 photo and relevant table per feature using MSWordStyler transformers and grouping/sort to pass in order. But some features have 2 photos which I'd like to display side by side (above the table). Can anyone advise? Thanks Chris