Transformers

Can someone explain how FME handles raster cell origins? In the RasterNumericCreator and RasterRGBCreator changing the X|Y Cell Origin values does not affect the extents of the image, the X|Y Upper Left Coordinate is always the edge of the pixel, not the origin.Likewise changing the cell origin via RasterCellOriginSetter has no effect on the resultant raster.

Hi all, I'm trying to merge two data-sets when they don't have a common field. What I would like to do is merge them using keywords that I have in one of the lists, so it should be a kind of a Feature merger with "contains" function, but so far I'm not really successful in finding a solution. Here's an example: List of IDs and keywords (1st data set): ID Keyword 111 Mc'Donalds 545454 Starbucks 1234 KFC 222 Burger King 343434 Golden Tulip List of places that I would like to assign ID to (2nd data set): Place_name ID Mc'Donalds Amsterdam Central Starbucks Airport Stations' KFC Piazza Burger King Amsterdam Golden Tulip Hotel So in the end it should simply look like this: Place_nameIDMc'Donalds Amsterdam Central111Starbucks Airport545454Stations' KFC1234Piazza Burger King222Amsterdam Golden Tulip Hotel343434 Any suggestions? Thanks, Linda

I'm generating a large GML based on data that i get from the SQL creator. The whole workbench is meant to be database driven. There is a main workflow that triggers this one: SQL_creator has dataset part A and SQL_creator2 contain part B, both are the same dataset and should be merged by ID (only attribute that they both have). They are split because of the amount of joins that the SQLcreator can handle is reached. I have a parameter $(sql_statement) that contains the SQL statement that is used in the SQL Creator. The attributes itself are dynamically named, so they cannot be exposed by setting value "attributes to expose". The Attribute exposer exposes the ID of the records, this is the only attribute that both creators have in common. Schemasetter exposes the dynamic attributes so they will be exported in the dynamic GML export. It works with the tester directly to GML but it does not show the dynamically created attributes that are created with the SQL_creator2 after the merge is do

This seems like a fairly simple task but I'm struggling to think my way around the problem. Middle point: master = it's unique id previous = the id of the point to the left of it next = the unique id on the point to the right of it How would I connect these points to form lines by relating the master, previous and next attributes.

Is there a way to smooth a line so the resulting line passes through all the original vertices?

For the life of me, I cannot figure out today how to eliminate dangle lines. End goal here is I am looking at which fire hydrants we have, that can be easily accessed by a fire truck that are not on a dead end street. Any assistance will be greatly appreciated.

I want to compare parts of street in the same data set. Street's parts with the same value of the attribute 'street_name' and geometric shapes whose bounding box overlap or are located within a distance of less than 10 meters, should be assigned the value of a common aggregate bounding box. Hhow this could be done? I will appreciate any help.

Hello, I have one feature reader where I read filter polygons from table A. As a result I get few of them. Then I have separate reader where I read polygons from different table B. I have like 2000 of them. Then I would like to get as a result only those polygons from table B which are inside any of the polygons from tabel A or % of the area inside one of the polygons from table B is let's say 90%. What would be the best way of doing that?

I need to join 3 bands of an image, a band 3, 4 and 5 but when using RasterbandCombiner it comes out with 5 bands, why?

Hi FME'rs I would like to add land classifications stored in a polygon layer to a XYZ point cloud in an attempt to fudge an LAS-like dataset. My approach so far was been to use to PointCloudCoercer to turn to XYZ to point, SpatialRelator to add the classification attribute from the polygon, then PointCloudCombiner to turn it back into a point cloud. As you can image, this is incredibly slow going. Can anyone out there offer an alternative? David

Hi, I am trying to convert a .shp to a .dwg (RealDWG) file. I was able to successfully write all "fme_donut" to "autocad_region", however all my attempts to write "fme_aggregate" (multi-patch polygons) to "autocad_region" were unsuccessful. This is my understanding that FME can handle autocad_region by subtraction (donut) but not by addition (multi-patch). I am wondering if you have any solution to do the job. Many thanks Regards, Hani

I have a string such as: 3R3002 - Oneri finanziari su derivati - COLLAR I use the SrtingSearcher tranformer to find all after the first dash (Oneri finanziari su derivati - COLLAR) with the regular expression: -[\\s\\S]*$ but I receive an error: couldn't compile regular expression pattern: invalid escape \\ sequence

HI guys, I have a question, in FME 2017.1 when we execute a command line with the SystemCaller, the command is prompt in the log and the password is in clear .... Do you have any tips to fixe it ? (I was thinking to rewrite the log to erase or hide it) . The passwords are from private parameters and contains the word "password" inside.

I am trying to create a workflow that checks a spreadsheet with new updated information against an older feature class. I am using FeatureJoiner to determine if there are any new or added rows to the spreadsheet so that ultimately, i will be able to add the coordinate points for any new rows. I have connected the unjoined left port of the FeatureJoiner to a counter transformer to determine how many new rows were added to the spreadsheet and therefore show the user how many new coordinate pairs need to be added to update the feature class. So far I have been able to generate an error message using a logger transformer (FeatureJoiner > Counter > TestFilter) to indicate if there are new additional rows, however I would also like to generate a message if there are no new rows added so that the user knows and so that they can be directed to another workflow. I have set the TestFilter so that if the counter transformer attribute has value it will lead to one Logger, otherwise it will lead to

I want to use spatial relator to find out which building is in dangerous area. But when I run my workspace, it only runs requestor side without supplier side, and gives me a feedback that all things are rejected. My question is, how could a spatial relator work without supplier? It is really wired. Why workspace doesnt read the dangerous area at the same time? Thank you so much!

Hi. I want to make a line from a single point (based on distance in meter), and then change the direction. I want to do this for multiple point. I have the line length, x and y coordinates, and line direction. Line have to start from x and y point. I'm using FME 2015. Thanks.

Hi, Using FME Server, I am writing a large amount of data to a gdb to then be zipped up, using the custom transformer ZipArchiver. It works until it reaches its 2GB limit and then fails with the following lines: Ideas for a workaround for this would be gratefully received! Is there a quick fix? Would Gzip work better? Kind regards

Hi, I have some errors coming up in FME Server when I'm trying to read in rasters which, when I'm running locally through Desktop, do not occur. I am reading in several GEOTIFFs using S3Downloader and saving them to a location. Then from that location I use a FeatureReader and send them to a VectorOnRasterOverlayer. (The vector features coming in are fine). As I said, running locally is fine, but through Server I'm getting the following warnings and errors: I appreciate this could be a simple fix but I'm new to raster handling in FME. I've already tried a few things using a GeometryValidator after the FeatureReader, such as processing measures containing NaN, but with no joy. Thanks in advance!

I want to filter my data to find features where part of an attribute matches a predefined string. How can I do that?

I have two shapefiles populated by polygons, where several polygons of the second (Supplier) shp intersect the first (Requestor). When it does the Spatial relations and merges the attributes I need it to pick of the maximum attribute value of all the polygons that intersect the Requestor. Basically performing the Join attribute function in other softwares by spatial location picking the maximum value of the Supplier polygons intersecting the Requestor polygon, but can't figure out a way to do so. Does anyone know of a way around this? Thanks. A diagram might help, so I need a transformer that reads that there are three gardens intersecting the property and then to pick up the maximum cost of the garden and merge it into the output attribute list. It's the last bit I'm struggling with.

Hello. I realize there are several different date range topics, and I can't seem to find one that applies to my needs. My goal is to query or tag records within 90-, 270-, 365-day date ranges based on CurrentDate. I have not been able to get anything to work with FME tools, but normally the SQL query would be: Select * from [layer] where "expiration_date" >= CurrentDate+90 Any ideas? Thanks.

There is a transformer that does an operation similar to the repair geometry function of arctoolbox (ArcGis)?

Hi, I have a data set of lines that are part of polylines but i am missing attribute sequence. Attribute sequence is number (starting from 1) that represents order of lines for each polyline. Is it possible to add this attribute in a way that number 1 is first line of polyline, 2 second and so on? If not, how can I add this attribute regardless of position of lines in polylines? This is part of my data set. First column is ID of line and third one is ID of polyline. I need to add fourth column sequence that will have for example for polyline 0 line 142 value of 1, line 7 value of 2 and line 747 value of 3.

How to select a specific IFMEFace from a solid? I have created a solid and want to extract face 0 and face 5. I like to have them have a name. Later on would use those names to assign a specific texture to those two faces. "Part 0: IFMEFace " should have a name like "roof"

In our environment workspace development and published server are on different systemes, therefore the workspaces have to use not-previously-known fme web connections for communication, especially submitting calls to child workspaces. After some deliberation it seems that a scripted connection parameter that reads its value(s) from a configuration file would be the ideal solution to gain the necessary indepence of runtime environments. I found https://knowledge.safe.com/articles/844/setting-up-a-workspace-to-deploy-in-production-sta.html and https://knowledge.safe.com/questions/4296/set-published-parameters-in-a-python-startup-scrip.html but cannot figure out how to use these techniques for a connection parameter