Transformers

When I'm using this WMS service as background map in Data Inspector (FME 2018, build 18284) the meausurement tool does not seem to work. I can click and drag all I want but it's not showing any results.I think it's something specific to this service, other WMS'es don't seem to have this issue.

I'm just trying to get an epoch timestamp. I have a Creator>Attribute Creator>Inspector. I'm using @DateTimeFormat(@DateTimeNow(),%s) but am getting null returned. All other formats work. What would cause this?Seems like I'm having an issue with epoch time. I'm seeing the same results (null values or rejected features) in other transformers as well, such as the DateTimeFormater. I have tried converting both ways, from and to epoch. Interestingly the 'preview' in the transformer always works. My '%s' format is also auto-recognized as epoch too.

Dear FME community.I've a line with vertex and I want for example to move point 1 (x : 100 y: 100) to x : 102 y : 80.I've attribute with Start X, Start Y, End X, End Y and line ID.It is possible to do that ?Thank you.

I'm using a series of MSWordStylers to layout a Word document. It has multiple paragraphs and some of the paragraphs have sentences or words in bold. The rendered output:The custom paragraph option allows me to specify the font and font size and the option to use markdown to bold specific parts of the paragraph as required. However, I can't seem to use both markdown and custom fonts at the same time. The paragraph using markdown defaults to the default font, in this case Cambria, and doesn't match the rest of the document. The words and sentences marked up in markdown are rendered correctly though. So markdown is working correctly on the structure but the transformer is losing the presentation settings. A bug? A feature? Anyone else confirm this?I'm using FME 2018.0.0.3.

Hi all, I've done some data preparation of OpenStreetMap data (epsg:4326) in QGIS and as part of that work reprojected the OSM data to epsg:27700, naughtily relying on QGIS on the fly reprojection without too much thought. That defaults to a transformation that looks good in QGIS for my purposes and aligns well with the OSM web tiles in QGIS. I now want to use the 3DTiles in FME visualisation to export the data as a Cesium web map (thus going back from epsg 27700 to 4326) but I see a shift of about 1m or 2m of my OSM data when in Cesium (i.e. the product of the FME writer). I presume this is because FME is doing a different transformation to go back (appears to default to using OSTN15 grid shift) to that which I applied in QGIS.   The QGIS transformation appears to be named as EPSG:1314. https://epsg.io/1314 so I thought I could transform the data with that to 4326, before sending to the 3DTiles writer. However, I can't find epsg:1314 as a transformation in the csMapReprojec

I am trying to get NeighborFinder to match effectively two different datasets in such as why that each candidate is only matched to one base but not all bases have candidates. (Should be able to find these by utilizing the Maximum Distance Field). However, when the data gets chaotic and there are 10 measurements on top of each other, the matching candidates (which are labels) are often not the closest candidates. I am wondering if anyone has an idea about how to match a cluster of measurements with their candidates in such as way that it produces the lowest average distance between the bases and candidates and makes sure that each candidate finds a reasonably close base. The post: https://knowledge.safe.com/questions/59605/neighborfinder-and-excluding-candidates-after-matc.html gives me an idea, but I do not think that it provides a complete answer to my problem. This image illustrates the problem. I bet that using a waterfall technique would get about 20% of this wrong.

Not sure if I am even asking this correctly, but I pretty much want to move the effective point of my text object to the middle of the current position of the text. When I use Neighborfinder, I want my labels to be matched to their respective objects based on the positions that their center of gravity occupies, not that annoying little point in the lower left corner. My thoughts were that I would use the BoundsExtractor to find the min and max coordinates of the text and then use have the difference between these to move the text object in the Affiner. Trouble is that the BoundsExtractor seems to find the extent of the point, not the text since its output is not making the Affiner move it at all (I assume because min =max). I do know that FME can read a Max and Min associated with the text however because in the inspector on the reader, it shows such an extent (see image below Min and Max Extents). How do I extract that informantion?

I have a summary table of collection routes and the number of collection points on each route. Each route gets a colour value based on the number of collection points (grouped into bands of 100). I'm routing this into the ChartGenerator and using my "fill_colour" attribute to colour each bar on the chart.I have seven bands in my dataset and I'm expecting to see 7 different colours on the chart but instead I seem to get a default blue colour.My fill_colour field has values like 65,174,118 just as recommended in the help file. I've tried with and without quotes and can't get my specified colours.Any suggestion? Am I asking too much of the ChartGenerator?

Hi, I would like to convert a dataset with GPS tracking points to routes using the the LineBuilder transformer. My challenge is that I want to create separate routes based on break values/attributes. Each route start with zero (value) and ends with one (value). Based on break values/attributes I would like to add an unique routeID to each route (collection of points) and use this as connection break attribute in the LineBuilder. See attached example of attribute table.Any idea how to acomplish this?Thanks in advance,Morten

When I use the RasterCellCoercer within a workspace in FME desktop, it works fine. But when I run the same workspace in FME Server, it returns the polygons in the wrong order it seems.See example1 image, the blue polygons should be on the same position as the raster, but they aren't.Does anyone has any idea what the solutions could be?

Hi all,I want to use FuzzyStringComparer but I'm wandering is it possible to force it to rate sth like this higher? eg. Pizzeria Saracino <-> Saracino Pizzeria => 0.47So the words are correct but the order is wrong, and I need to know if the name is basically the same. In this case it is the same for me. Is there possibility to configure this transformer to check words in string separately? Thanks in advance!

Hi all,We've just upgraded to 2018.0.0.2 from 2017.1.x and a workbench that used to run in about 5 minutes is now running at 1 record per second and I have 62,000 records to process. The bottleneck appears to an AttributeValueMapper with 140 lookup values. The FileGDB and AttributeRemover read all 62,000 records in next to no time and then they hit the AVM and everything slows right down.We've tried a FeatureWriter (to CSV with DuplicateRemover) to get a file of unique values and updated this with the new mapped values and then used a DatabaseJoiner but that is still slow at 2 features per second.Any suggestions on how to speed things up?The workbench takes a FileGDB table and uses DatabaseJoiners to join two more FileGDB tables (with a common key field in each one) to build one output table in PostgreSQL with selected fields from each table.ThanksRoss

Hello, I need to transform my DWG to SHP. I have one layer that contains 2 types of elements, block reference and polyline, how can i get 2 shp files, one point shape with block reference elements and one line shape with polyline elements? All attributes must be kept in attribute list of shape files.

I'm evaluating FME Workbench for our company GIS ETL processes. It doesn't look like the SQL reader supports stored procedure data sources. Is this correct?I can work around it by using a view as source and a filter string on the reader but want to know if there's a way to use the stored procedure directly.Thanks.

Hello, I am new to FME and would like to try and obtain geotagged Flickr / Instagram posts based on specific search criteria, e.g. keywords and coordinates. This is for a conservation project. Using Yosemite National Park as an example, I would like to search for images within a 10 mile radius of Yosemite (37.8651N, 119.5383W) with the option of filtering out posts based on the keyword “black bear” and then place those queried results on a map. I have had some success using the TweetSearcher Parameters transformer for aggregating Twitter posts, but am wondering how and if this could be applied to Flickr and Instagram to reveal posts and images. From what I gather I should use the httpcaller to talk with the api, but any ideas on how to create a search query? Is such a thing possible? Thanks so much for your help. Charlie

Hi, I am not able to upload my transformers created with FME Desktop 2016 to FME hub. I tried two of them and here are the error messages:Category 'Geometric Operators' is deprecatedCategory 'Linear Referencing' is deprecatedIs there a list of current valid categories?Thanks in advance.

Hi all,I want to compare line data for change detection in attributes and in geometry. I prefer the UpdateDetector transformer but in outputs I do not get separated the changes in attributes and the changes in geometry. These are mixed in the output. For example, in the Insert output, I’ ve got insert new data and attribute changes. Do you have any idea how can I do that?Thanks a lot for your time and helpNoni

I have created a custom coordinate system using the online FME tool. I have downloaded the files and placed them in C:\\Program Files\\FME\\Reproject per the instructions, I have defined a shared path in the Default Paths. How do I get FME to recognize the custom coordinate file?

I have a polygon in a large text field (below) which should be in WKT format. I need a way to convert that WKT to a Polygon with error handling for unsupported polygons. I tried geometryextractor, but all 100 sample records failed with "INVALID_GEOMETRY_VERTICES". Here's the example of the WKT from the database: POLYGON (( -76.581093 39.315575,-76.581776 39.315554,-76.581631 40.313857,-76.581347 40.314542,-75.582766 39.314861,-75.582726 40.313963,-75.583088 39.315309,-76.582269 40.314383,-76.583239 39.315550,-76.582827 39.315085,-75.585164 39.315707,-76.584283 39.315503,-75.585379 39.315321,-76.584517 40.313984,-75.586260 39.315786,-76.585689 39.315684,-76.585819 39.315475,-75.586589 40.314790,-75.586844 39.316014,-75.587591 39.315511,-75.588035 40.314793,-75.587795 40.315077,-75.588154 40.315657,-76.587613 39.315782,-75.588892 40.315519,-75.589434 39.316231,-75.589486 39.316014,-75.589911 39.317039,-75.591006 39.316106,-76.589366 40.315024,-76.590231 40.315464,-75.591421

Hello everybody.I would like to calculate the shortest path between two points and I found this transformer : ShortestPathFinder Is it the best way for do that in FME ?Thank you.

I'm trying to set up some conditional reprojections in a workspace using the reprojector and conditional values for the destination coordinate system.I'm using a published parameter in the workspace to select different regions around the world and run some processes on features in these regions.When I try to use the values from the published parameters to conditionally set the destination coordinate system, FME fails to evaluate the input expression and the the translation fails.The error message:Reprojector_2: Reprojector_2: Failed to evaluate input expression: FME_CONDITIONAL:DEFAULT_VALUE'Mercator_World_KM'BOOL_OP;OR;COMPOSITE_TEST;<Unused>;TESTNorth America=North America'NA-ED-CONIC83_40_FME'FME_NUM_CONDITIONS2___ Program Terminating Translation FAILED. What am I doing wrong? Is there a better way to setup conditional reprojections?  Thanks for any help.

Hi,I need to update a specific value in an Oracle database. However, I'm running into trouble when trying to execute an SQL Update statement using the SQLExecutor. The very same statement works like a charm when executed in SQLDeveloper. The statement :FME_SQL_DELIMITER ;update table_a set valeur = 'New_Value' where id in (select av.idfrom table_a av join other a on a.id = av.idother and a.libelle = 'PARTNER A' join table_p p on p.id = av.idproject and p.CODE = 'xxx' ); When I execute this from FME, he connects to Oracle, but never finishes. The log get stuck at this moment :Oracle database version is '11.2.0.1.0'Environment variable ORACLE_HOME is not set.Connecting to ORACLE database `ORCL' with user name of `TESTL' and password of `***'Connected to ORACLE database `ORCL'I've tried to put the SQL in one single line without success. I've also set the environment variable ORACLE_HOME without succes (although I'm not 100%

Why replace 1 button with 2 new ones that do the same thing?

I would like to know if there is the possibility of accessing WSDL files through the SOAP protocol (same form of access of SoapUI) as reading via FME. If so, could an example be provided. Thank´s

how should I do if I want to pick out the userID with 1 row only. For example USerID Long Lat Count  001 1 1 20  001 2 2 1  002 3 3 5  003 4 4 20  003 5 5 6  004 6 6 9  I need to pick out the userID 002 and 004 and keep all attributes