Transformers

Hello, I am reading a folder containing various Excel files of the same schema. The difference between the files is the date and the content, the structure is always the same. My goal is to create a line diagram in a new Excel file. I want to use the "ChartGenerator". My Problem now is to prepare the data to be used within the ChartGenerator: I will have a bunch of records as illustrated in the "Start" section of the above pic. For every additional date I will have an additional record. I need to convert the data as illustrated in the "End" section. For every additional date I will need an additional column. The various existing Posts regarding transposing data do not seem to tackle my issue. Any ideas?

I've got some continuous rectangles(polygons), each of them represents an atrribute value from 1 to 5. So after symbolization they just look like a raster. Some of the rectangles have abnormal values such as 1 rectangle has value 1 surrounded by 8 rectangles have value 5. I'd like to change 1 into 5 in order to clean the data. Due to the polygons are rectangles not squares, I can't convert them into raster to perform a Majority Filter operation in ArcGIS. Is there a way to perform same operation on vectors? I'm thinking about creating a list to store surrounded rectangles' value, then use ListHistogrammer to get most frequence value if they appear equal or more than half, then change centre value in it. I've tried to put data through SpatialRelator's requestor and candidate port to create the list, but I can't ignore the centre rectangle which creates 9 listelements. I'm struck here, if you have any suggestions or a better/more efficient method, please help me, I'm all ears, thank you.

Hello: I have an oracle query that I need to generate as a json file. The query contains all of the feature necessary for the output however, there can be multiple addresses for a given project name. For projects that have multiple addresses, I need to repeat the following attributes: street, cagisID, addressID I had this structure in a JSONTemplater but when a project contains multiple rows (with the differing address), it generates all of the elements below multiple times. I tried to configure the "SUB" feature of the transformer but I must need to only send a project query to the ROOT and all of the possible address variations for a project to the SUB. But then I could figure out how to link the two for this to work. { "totalInvestment": fme:get-attribute("totalInvestment"), "squareFootageRetail": fme:get-attribute("squareFootageRetail"), "squareFootageOffice": fme:get-attribute("squareFootageOffice"), "squareFootageManufacturing": fme:get-attribute("squareFootageManufacturing"), "r

Hi everyone, I looked up at some forum posts, I saw people excluding the content within squarebrackets with square brackets itself or deleting some funny characters, but I couldn't really find something which suit my situation or I just didn't understand the forum posts quite well. The case is, I have got a column with strings such as "[]" or "[Park5, Park4]" and ideally I would like to remove the square brackets. I tried it with the stringreplacer with the regualr expression, however that didn't work, it has to be said that I am not that familiar with regular expression, so the way how I formulated it, might be wrong. In my case, I want to keep the content within the square brackets, while only deleting the square brackets itself. Thank very much in advance!

Hi FMErs, I have a question related to the use of the ListElementFilter transformer by @takashi that is a continuation of this question. I'm open to any recommendations for alternate transformers that may be able to match the conditions, but I cannot find any to date. Attributes for line length, line name, line date have been successfully extracted from an initial text string. Attributes for line geometry such as total length, start x,y, end x,y and azimuth have been successfully extracted from the autocad polyline. Now trying to match the text to the correct polyline using a combination of 1) Proximity (neighbour finder within 5m, line as base, text as candidate generating list of potential matches shown Figure 1), and 2) Length (by matching geometry length to text sourced length) Referring to Figure 1 - A previous attempt using the first match only, and testing line length with a 1m tolerance yields about 50% success. In attempt 2, using a list of all potential matches within 5m, I g

Hello, I would like to read all attributes for some specific fields and then compute some satistics. I know that it is possible with multiple statistics calculators and feature mergers. How can I do this inside a python caller? Thanks

I have a non-spatial data, want to compare every 2 rows: if they has A, B columns same then compare Column C Start, Column D End has the overlap, if it overlap with another row, write that row id to this row column. See attached image, any suggestion for the task? Thank you very much.

I have got the following structure: Three Attributes and a feature with three different values Attr1 Attr2 Attr3 X Y Z The result should be: Attr1 NewAttr X Y X Z In my initial table (Excel) I have more features of course, but this is the way I have to deal with each feature. Any ideas?

I want to move all different sorts of geometry (points,lines,areas, 3D, surface, faces +++) to a local origo. I can find the correct x,y,z and I can use the 3DAffiner to move most of the data to the correct spot. However it seems that the complex 3D-geometries that has a Transformation Matrix does not get updated (https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/!FME_Geometry/Transformation_Matrix.htm) . Is there any easy way to also 3DAffine these Matrixes or do I need to "unwrap" all these geometries and then re-wrap them again. Using deaggregating on all the complex geometires, and then aggregating them again afterwards?

Dear FME community. I would like to duplicate lines who contains a specific character in a specific field and split the attribute of this field. For example in this case I would like to duplicate and split the lines who contains the character * in the filed Field 3 and split it like that : For begining I used a tester for make a filter on the Field 3 who contains the character * Do you know how can I do that ? Thank you.

I have a file GeoJSON. I need upload this file as s BLOB or NCLOB(as just binary file) to column in Azure SQL DB Table. How i can upload this file with FME? Please share you knowledge about it

I'm trying to find optimal area of interest (AOI) polygons to make request for image tiles. I have my service territory (an irregular shape) tiled and each tile knows how many request would be required as a numeric attribute. What I want to do is group the tiles so that each group has as close to a sum of 150,000 without going over. Then the outline of each group forms a polygon that can be used as an AOI. The Dissolver just does too much. All the polygons are adjacent. Or I could have one giant polygon and figure out a way to split it, and if the value (sum) is still too large, split it again. Ideas?

I have a folder with many shape files in many CRSs. When I read each file using "FeatureReader", I can use CoordinateSystemExtractor to retrieve the feature 's CRS, but the returns are not very useful as they are not standard ESRI coordinate system names. Is there a way for FME read the associated prj file and get the standard coordinate system name that I can attached to the feature as a new attribute?

Hi, I'm trying to make an indoor map, to use with this leaflet plugin: https://www.cbaines.net/projects/osm/leaflet-indoor/examples/ (data.json is found here: https://github.com/cbaines/leaflet-indoor/tree/master/examples) Input data is complete indoor maps in shapefiles with offices, hallways etc. each object with room numbers. I also have a large table of all employees with name, title, organisation, phone, and room number. These get joined by room number attribute with a Databasejoiner, and because some share rooms, turned into a list attribute. So far so good. I've tried, with very limited success, to use Jsontemplater. As I've worked with geojson only once or twice I'm at a loss how to continue. I have gotten as far as writing a geojson, but not with the right structure. Pleeeeease push me in the right direction as to setup the Jsontemplater. (renamed from .json to .txt because of security(?)) Please Update: Below is an example of the result json (which couldn't be accessed... hrm

I thought I could use the data file input and a binary decoder, but I need some help!

Hi, I would like to have access et this page from the FME help please https://knowledge.safe.com/questions/58672/where-can-i-find-the-csrs-transformation-grids-for.html as referenced here: https://knowledge.safe.com/articles/19461/canadian-spatial-reference-system-csrs-high-precis.html I am trying to get the transformation grid files for NAD83 et (CSRS)NAD83 Thanks, Martin

Hello all, I am trying to use a Workspace Python Startup Script and I get the message from the subject line.I am using FME 2017.1 on MacOS. I changed the Python Compatibility to: Python 3.5+ and I also changed the Translation setting Preferences to "Python Preferred Interpreter: FME Python 3.5+". I am not sure if I need to tweak something in the workspace or it has to do with something it cannot find on my Mac. Can anyone please advise on how to fix this little mishap? I appreciate the help!

Hi, my python code below does not work in python 3, I receive a " Unicode-objects must be encoded before hashing" error message. Any tips? import sys, getopt, hashlib, os from hashlib import sha1 import hmac import base64 import time import requests import subprocess import json import fme import fmeobjects import datetime def calculate_signature(feature): # get input values from feature attributes api_key = FME_MacroValues['API'] host = feature.getAttribute('host') method = feature.getAttribute('method') shared_secret = FME_MacroValues['SharedSecret'] timestamp = feature.getAttribute('timestamp') #timestamp = datetime.datetime.utcnow() url = feature.getAttribute('url') # set access_key #access_key = FME_MacroValues['AccessKey'] access_key = 'A0F66A0E-0CC9-7ABE-24CC-F8807E2829AB' # copied code from calcualte_signature sig_block = "{}\\r\\n{}\\r\\n{}\\r\\n{}\\r\\n{}\\r\\n{}\\r\\n".format( method.upper(), host, url.lower(), timestamp, api_key, access_key) print("\\n\\n -- sig block -- \\

A workspace has an aggregator that is aggregating features using multiple group by attributes. One of the group by attributes is ordered, but the others are not. Any suggestions on how this could be processed so that the ordered feature could be considered, rather than the aggregator holding on to everything?

Hi All, I have a total number of n (points) spatially divided over a given area. I want to group them into x clusters using y members per cluster. This has to be as spatially optimal as possible. So I would like set the following parameters in the transformer: - The number of clusters - The size of the clusters or the min. and max. size of cluster Anyone got any ideas? I already tried working with the cluster modeller, K-means & RClusterCalculatowith no success. Thanks in advance!

Hi I am trying to convert attribute values from PascalCase or camelCase to underscore_separated in FME 2018.1. I've tried StringReplacer in "Replace Regular Expression" mode. Text To Replace is [A-Z] and Replacement Text is _\\1. It is matching the text to replace correctly but rather than substituting the capture group it is replacing with literally _\\1 so schoolCode becomes school_\\1ode instead of school_Code. I've also tried to use @ReplaceRegEx(@Value(name),[A-Z],_\\1 ) on an attributecreator with exactly the same result. Everything I can find (including StringReplacer help) suggests that \\1 is the way to do what I want, but I just can't get it to work! Any help would be really appreciated. Thanks Tom

My FMETEMP folder keeps growing. I can free up about 1GB by using the purge temporary files feature. However, my entire temp folder is nearly 54GB. Is it safe to manually delete these files? I was thinking they are supposed to go away when I restart the machine, but they seem to stick around.

Hello, I am looking for a transformer that is much like the "merge" function in ArcGIS. I need to be able to merge two polygons that do NOT touch into one feature. It is possible to do this manually in ArcGIS, is there a way to do this in FME? I cannot add area to either of the features in order to do this sort of merge (ie: bridge them together with a small polygon), since area is a sensitive attribute for this feature class. Dissolver did not work! I could only get it to merge polygons that physically touch. Thanks!

I have been given the following python code but get errors every time i try to run it, anyone know what is wrong... import fmeobjects def FeatureProcessor(feature): to_concatenate = ("buildingNumber", "throughfare", "dependantthroughfare") # Modify as needed join_string = "," # Modify as needed result = join_string.join([feature.getAttribute(attr) \\ for attr in to_concatenate if feature.getAttribute(attr)]) feature.setAttribute("CONCATENATED", result)

I get the following message which I do not understand. fme_expression_warnings{0}.message (string): Failed to evaluate expression '@DateTimeCreate(2018,11,5,6,9,14,0)'. Result is set to null I tried filling the values as string values and converted to @int() and get the same result. Also tried with -0 as the last value.