Transformers

Hello all,I have a large number of points (over 15,000) in the same geographical (x,y) location that I need to filter out. I cannot do this spatially and there is no coordinate data in the points. There is only one attribute within the data I can use to filter on (Address).I have a spreadsheet that has a "Town" column that has over 3500 rows.Is there anyway of bulk testing the Address attribute against the Town column from the spreadsheet to filter down the data? I don't want to copy and paste 3500 Town names into a Tester if I can avoid it!Thanks,Jeff.

I'm running 2018.1 Desktop on a Mac (OSX). I decided to test the Word writer so I created a Word Writer, an MSWordStyler to create some content (a simple text string), and a creator to kick the thing off. When I run it I get 6 errors which begin with 2018-07-19 08:08:49| 0.3| 0.0|ERROR |Python Exception <ImportError>: No module named FMERasterSaver 2018-07-19 08:08:49| 0.3| 0.0|ERROR |Could not create Python Writer `MSWORD' 2018-07-19 08:08:49| 0.3| 0.0|ERROR |A fatal error has occurred. Check the logfile above for details I can't find any reference to "FMERasterSaver" using Google or Safe's knowledge center. Any ideas what is wrong? I'm guessing this bit never got installed.

hello there we are using the dynamic workflow by reading form geodb and writing to MS SQL Server DBbut each fme_ feature_type will be written to a different schema in the databasehow can configure the writer to do so Thanks

HiI need to reformat some csv file (so rename use conditional value ecc ecc) but at the end I want also to remove the fields that are empty (I mean every fields without any value inside)thxFrancesco

I have a workbench where features are updated in my postgresql database using the SQLexecuter. I am wondering if it is possible to view weather the update was successful or not? When SQLexecuter runs into an error I get the error message in the log but what I am looking for is more of what you see when you run a query in PGadmin "query executed successfully 250 features updated". what I really am interested in for QC purposes is "query executed successfully 0 features updated"

My features have an attribute containing an XML document and a list attribute. As an example, imagine the XML attribute containing this document:<?xml version="1.0" encoding="UTF-8"?><root>  <foo bar="aaa"/>  <baz>    <foo bar="bbb"/>    <foo bar="ccc"/>  </baz></root>And the list attributes containing these values:list{0}.ident = "aaa"list{0}.value = "xxx"list{1}.ident = "bbb"list{1}.value = "yyy"list{2}.ident = "ccc"list{2}.value = "zzz"What I want to achieve is to update the XML attribute so that it contains this modified XML document:<?xml version="1.0" encoding="UTF-8"?><root>  <foo bar="xxx"/>  <baz>    <foo bar="yyy"/>    <foo bar="zzz"/>  </baz></root>I think this should

Hello, I have a problem with the calcul of a sum (expression evaluator, statistic calculator..). The result is not correct. I make this calcul : 10000+10000+1+100+0.1+0.01 and the result is 20101.109999999997 . I have this problem in fme 2018 and 2017 but in 2015 the result is correct . Have you got any idea to solve my problem? Thanks a lot.

Hello! I'm a first time poster and newbie FME user and hoping someone might have some ideas to help me solve what it a fairly simple task but incredibly time intensive without coding or the use of FME.  I need to download and then process just over 150 shapefiles that are posted on an open website. The state of Massachusetts posts building footprints on their website for download. I need to download each file and combine them into one large geodatabase. I have some additional processing and attribute changes I need to do in the middle but have a good handle on that stuff.  What I'm thinking is: - Store the URL strings for each of the file downloads in a CSV file - Somehow leverage the HTTP caller to iterate through each of the URLs in the CSV and pull the shapefiles into my workspace.  - From there feed each file into a shapefile reader and then move forward with my processing and writing to geodatabase.  Her

Hello everybody,Im trying to solve problem with analysis. I need to proceed analysis only in situation when features came from both inputs. If features will come only from one input, analysis will not be processed.E.g. attached pic belowI want to process PointonPointoverlayer analysis only in situation when features will come from Creator and Creator_2. In situation when Creator or Creator_2 output no features, overlay analysis will not be processed.Do You have any idea how to solve this issue please?Thank You so much!Lubo

Hello, any idea on how to read/write from/to Jira Atlassian data using FME desktop ?

Hi,How can I draw a polygon (shp) using azimuth and distance in FME?Thank´s

Hi everybody,It is possible to distract objects automatically?For example:

I´m using the FeatureColorSetter for create color and fill features, but the output file don´t change. Why?Thank´s

I am running a workspace that generates contours on a point cloud and writes them to dwg.Workspace stalls indefinitely, doesn't crash, I get some warnings. Only message is "Sorter(SorterFactory): Completed 7.17% of intermediate processing" in the status bar.The .fmwt can be downloaded from here (OneDrive)

Hi there. First time user here so apologies if this question has been asked and answered already. I can't seem to find an answer though. I have a .dwg file that has had no set coordinate reference system and when I try to display it in QGIS it appears somewhere over the Antarctic. Is there a way to transform this file into shapefile format and assign a coordinate reference system to it so that it displays correctly? Thank you.

i am working with NWS rainfall data, and the grib file comes in as Polar Stereographic, with a custom datum. I am trying to reproject to WGS84, but so far no luck.thank you

the FME Server documentation (https://docs.safe.com/fme/2017.1/html/FME_Server_Documentation/Content/AdminGuide/AccessControl.htm) indicates than you can assign ownership of something to another user, however it doesn't describe how to do this. I see the sharing options button for the repository and I can give full access, run and download permissions there, but I can't change ownership. Can you describe the steps I need to take to do this?

Hi,I have a set of workspaces inside many directories and a workspace which call all the workspaces one by one using a workspaceRunner.Here is the picture of my hierarchical structureIn this structure you have a directory called " Livraison - Transformation globale AIXM 51". Inside this one, you have the "master" workspace which call all the workspaces one by one in the various directories you can see on the picture.Here is the picture of the "master" workspaceThe issue i have : when i changed the master directory called "Livraison AIXM 51 V2.0" in another directory, i lost the path of the workspacerunner parameter (show the picture). I would like to use "FME_MF_DIR" and i want to go in the parent directory and go inside the subfolder to reach the various workbenchs, but the absolute paths are used in my case.Is there a way to use python scripts to :- Bring in an attribut

Hello everyone, I am trying convert Shape file to cad file with annotation. I use LapelPointReplacer transformator. I received the annotation with this transformator. But I want it to stand annotation next to point as you get closer to the point. When I get the closing point, the annotaion should be positioned relative to the position. Maybe the problem occurred by labelPointReplacer has constant labelheigth, so the annotation size never getting smaller when i get close the annotation. Please help me What am I doing wrong? This picture is i got:  I want like this picture:

I am transforming a shp file from CGVD1928 to CGVD2013. Before the transformation, the ESRI WKT specifies the vertical datum as CGVD1928 but after the transformation, the vertical datum information seems to be lost.

Hi,A customer of mine would like to know if it is possible to have 2 floating licence files on the same server. By the way, these are two sister companies. They are using the same server but must use their own floating licence.I read this post :https://knowledge.safe.com/articles/22776/fme-server-licensing-walk-through.htmlIt seems to be possible. I guess i'd have to declare a second FlexLM service, but How can I be sure that users from company 1 will use its own licence and not Company 2's licence ? Could I use this post :https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Desktop_Admin_Guide/FMEInstallation/Restricting_Licenses_to_Users_or_Groups.htm

Hello,I am trying to pull pdf files from an attachment table and avoid having any duplicate documents. There is nothing in either the attachment table nor the related table that I can use as a unique identifier for the documents. I have tried two different methods and both only partially work.1) Use an aggregator grouped by DATA. This works ok but some of the DATA differs even though the documents themselves are the same.2) Use an aggregator grouped by DATA_SIZE. This works ok as well but I'm still getting duplicates. I investigated a little and it looks like even though the DATA_SIZE appears the same in the inspector table, when the aggregator runs some of the sizes are slightly different. When I pull up the properties for each of the output duplicate pdfs, the difference appears to be between the file size and size on disk.Any ideas how to get these to aggregate properly?

I have downloaded the SWF data from EA which consists of 1in30years, 1in100years and 1in1000years, all as polygon layers.What I want to do is :a) substract 1in30 from 1in100b) subtract 1in100 from1in1000resulting in 3 layers which do not overlap each other and are usable within QGIS as planning constraints.I have tried clipping to 1:10K OS tiles before clipping as above but the workspace takes hours to run in 2017.1 - any suggestions on how to improve run times?

Hy,I try to convert a DWG with OD to shapesFiles.All the OD block from the DWG are lost...I try some versions with area builder or a choper or a donut builder...Thanks for your help

Hi all, I have this SQL query in InlineQuerier that helps me join tables on specific keywords(table_b.id):  SELECT *  FROM table_a  JOIN table_b  ON table_a.id  LIKE '%' || table_b.id || '%'  but I would like to take it to the next level and also add word boundaries to my keywords, otherwise the expression is too greedy.  Can anybody help out with the syntax? (I was trying to add REGEXP and [[:<:]], [[:>:]], but so far I'm only getting syntax errors).  Thanks,Linda