Transformers

I need to create a list (or repository) of all the unique words in multiple data sets attribute tables. I was able to create a list of all the unique attributes, but now I need to go one more level and break out those attributes into individual words.For example, let's say my unique list of attributes are:The Dog The Cat Bird Three DonkeysI need to take that list and create this list with it: The Dog Cat Bird Three DonkeysDoes anyone know how I might achieve that?Thanks.

Hello, Is there any way to use SystemCaller to call on the terminal of a remote server?We have FME server hosted on a computer. We have another program hosted on a Google virtual machine. It is a linux based machine and I run a couple of simple commands there. I would like to be able to do that using FME Server.Thanks.

Hi,Is there a way to replace a point (Origin was from a point cloud) with a symbol from a DWG file?And I also want to scale the symbol in x, y and z with values from a attribute from the point.For example the attached And the output format can be a Shape or DWG file.Best regards,Jonas

I'm attempting to process 1,000's of Mastermap native Gz files in to TAB format. As the maximum file size for standard Tab files is 2Gb is there a way to get FME to split output in to multiple 2gb files?

Hi, I have a geometric topology with nodes and lines. Some lines have not the right end coordinate and are therefore not "connected" with it's node (shown on the left side). I'm looking for a solution to "snap" somehow the lines to the respective node depending on the line-attribute Node_Reference (shown on the right side). Is there a matching transformer available? For example: the red node has the attribute Name: ID_1. The blue lines has an attribute Node_Ref: ID_1. I would like to replace the end coordinate of the blue lines (nearest end of the line) by the coordinate of the matching node.

How do I set an attribute value in attribute manager that does not include quotations once I load it into Smallworld?

Hi,Has anyone looked into logging to a Gibraltar Loupe logging service ?My company is currently looking into creating a central logging facility for all our applications and services, and FME conversions are not exempt from this.It may be converting normally generated FME logs, or preferably, logging directly inside the workspace, e.g. by using a PythonCaller or a a custom transformer.Any insight on this issue is most welcome.Cheers Lars

What is the best method to remove 75+ attributes from a file with 500 attributes? Is there a way to use a list of the attributes 75+ attributes to parse from the 500?

I am parsing a very large xml file. After using the XML reader, my intention is to widdle down the data by using a series of constraints before writing to a database. I first tried to do this by stringing together multiple attribute filters, however I was unable to get my results from the first attribute filter transformer passed to my second, etc. Documentation suggests the Test filter would be a better route anyways. Despite knowing that my data satisfies the query statements (I tested this in another environment) I have added to the test filter transformer, I cannot get the transformer to pass any data through.I have also tried to achieve the same task via stringing together testers, as well as stringing together test filters (1 statement a piece). Does anyone know why I cannot get this to work? Thank you ahead of time for addressing this post.

Hello,  I want to use Point on area overlay transformer but it does not work and I don't know why. As You can see here some points are overlaying the buffer I created but output is collapsing.

(I asked this question in here, https://knowledge.safe.com/questions/1935/distance-between-points.html?childToView=64766#answer-64766but I figured I probably needed to make a separate new post, since it involves a different set of issues.)I need to calculate the distance from each point feature in a point dataset to each polygon feature in another dataset. I've used the neighbourfinder with the maximum distance set in such a way that it will include all the features involved. I also set the number of neighbours to the amount of polygon features I have.I set the list name.After that I used a list exploder to get a list of all the distances from each point to each polygon. That seems to do the job. However, how do I now transpose the list?I get a table with the amount of records equal to the number of point features multiplied by the numer of polygon features. I want a table with the same amount of records as the point featurues, and added to it the distance to each polygon feature

Hey!I have a problem with my PostGIS database. Trying to get it much more efficient. It contains information from several counties, which means I read a lot of unnecessary information that I do not need and the computer is giving up. Something similar "Fastkart.ak = '2085' and all information within 2085 from Fastkart.by" is what I need to do. But can’t figure out how. I’ve tried many hours to write clause under feature type and also by using sqlexecutor. Figure 1 shows all tables in the database. Often when I am going to read information from my municipality, it must read all the municipalities' buildings eg which makes it very big amounts. Of course, you can drive a clipper directly after the base but would be better if I could get the data base to read no information other than it by 2085. Anyone know if it’s possible to write "Where clause" directly in the database when you do not have matching information I attribute table?(That would be the best op

Hi, I am running a workbench which uses system caller to run a bat file ad that bat file in turn runs a exe file. When I run the workbench from any location other than the same folder as the bat and exe files it fails to execute. What I want to know is how can I pass through a published parameter value to the command prompt temp variable %%1 so I can set a folder for it to be run from?Thanks,Clare

I am trying to use SpatialFilter to get polygons that overlap but it also includes polygons that touch the edges since I am using the "Filter Intersects Candidate" option. Has anyone found a workaround for this issue since there isn't an option to only test for overlaps?Thanks

Hello,  I have a source file with Points of intrests and thier x/y coordinations. I would like to compare them with the database extract with also having this information. The problem is that they might not be on the same exact spot and also the names can vary a little. I was having an idea of using neighbour finder and then check the naming by using fuzzy string comparer but I struggle with doing it properly. Maybe there is better way?  Thanks,

I have a dataset consisting of polygons. The polygons represents roads. Along these roads I need to find certain points and the distances between them.  I've fed the dataset through a chopper and coordinate extractor with a point replacer to get the vertices.  Now i need to measure every single distance between all points in the dataset to find the maximum ditance between any two points in the dataset. I've tried every possible combination of transformers, but no luck.  No one else seems to have the same problem either, because after about four hours of googling and testing, I've been able to measure a whole lot of things, but not what I really want to measure.  Using the length calculator has proven to be the best shot so far, but the problem I'm facing is that the length calculator takes the vertex with the highest node number and measures the distance from that point to every other point.  Basically I would like to do the same for every point in the dataset. Any sugg

Hello FME community !I've a treatment with MDB destination and I would like to ZIP this MDB at the end of the WorkBench but with a size specification.For the moment, I used this article and the result is a unique ZIP file so fat.What I want is (like 7-zip) to divide this file in different volumes with a userdefined size.In the better world, I would like before this operation to send an e-mail with this ZIP file.Can you help me ?Thank you.

Hi everybody.I try to recept the result of a cmd code used in a SystemCaller transformer :In fact my SystemCaller works with my result (in this case : 3)But in facts, the result is not saved :What can I do for resolve this ?Thank you for your help.

Hycan you explain how can use fuzzy to detect names present in list A but missing in list Band viceversa ?  thx Francesco

I am using an existing polygon buffered dataset along with another line dataset to produce a new line dataset, where the source lines either contain or intersect the source polygon. The problem I am facing is that there are considerate gaps between the lines of the new dataset as the sources are either not fully contained in the polygon or don't intersect at a specific point.Using GIS software I can trace to join the lines, how can I automate this in FME?

I'm slowly getting this PDF to work and have made some progress, now getting stuck in another spot. Right now the process is I clip a raster and a points shapefile by the same polygon > rotate both > and export out to a PDF. I've figured out how to rotate and align the points all neatly, but I want the raster image to fill the extent I want. Examples:The extent I want (made from ArcMap) on top and the extent that FME outputs:

I want to group polylines together depending on x, y and z. Neighborhood Aggregator only seems to take into account XY. The 2D perspective snip shows the lines in 2D. Neighborhood groups polylines together regardless in they are far apart in 3D (as the second snip shows).

I need to extract a variable amount of characters from a string and would like some help.I have an attribute in the following format:id-Structure-1.1.13.1.6.1I need to extract the first 4 numbers (1.1.13.1)Where it's get tricky, is that each number can have a value that may varies between 1 and 6000so it's possible to see "id-Structure-1.5474.768.322.22.12" where I'd like to extract (1.5474.768.322)Any help would be much appreciatethanks

Tried all the "solutions" in the provided link, and changing my port. It was working 1 days prior to the errors

I simply want to create a subset of my pointcloud containing points between 2 heights. What syntax enables me to write the expression in one line?