Transformers

Thanks to ideas from @takashi that I discovered here, I have a ChangeDetector to discover differences in table schemas, which works as expected.For a logical value of 'No Changes' or 'Changed' I want to feed the ChangeDetector output into a tester, but I don't come to grips with the way the Tester works with the fed results:The way it is wired now always leads to 'Failed'

Thanks to @david_r, I am able to calculate CRCs from schemas now.The next problem arises when comparing those CRCs in the following setup:My deliberation is that the CRCs are calculated one after the other and the tester waits for both results to arrive. But as you can see from the attached log , it does not happen in that sequence so the test does not give the expected results. What's wrong?

To compare database table structures, I try to calculate the CRC of the table schema like this.However I seem to be unable to set the parameters for the crc calculator to do what I want. In the end I only need that one number of the CRC to compare it with the equally retrieved CRC of the same table in a different database

Hi there,I've been having some severe difficulties (and google has proven fruitless) in something I'm trying to achieve.So in a nutshell, I have a point layer, and in this point layer, SOME of them are duplicates, geometrically. However, these duplicates can have different attribute values. For example, two points may be geometrically on the exact same location, but they have a field called "color", where one is attributed as "Yellow" and the other "Red". What I need for these cases, is to have the point merged into a singular point, but have the attributes concatenated so that it will end up being one point, saying "Color: Yellow; Red".Aggregator seems to kind of do this, but the problem is that my output needs to be Shape file, which does not support mulitpart geometries, and for the life of me, hours of googling have not given any answers as to an elegant way (at least as far as my competence goes) to "flatten" my aggregated

Can someone upload an example workspace using the MRF2DCleaner to clean CAD data,Example of MRF2DCleaner to clean CAD data

Hello,I'd like to know how to remove overshoots using the MRF Cleaner I have tried the MRFIntersector followed by MRFShortGeometryRemover but this didn't work properly? I didn't also understand what does the MRFIntersector cleaning tolerance mean. thank you.

In 2017, I would use dates like 'today', 'last month', etc in the DateFormater to create dates in FME and other formats. The new DateTimeConverter no longer recognizes natural language dates. Was this an oversight?

I have a CSV file showing Bus Stop Codes in one column and Bus Route Numbers in another column.As you can see there are multiple Bus Stop Codes for each Route..I want to create a table which shows the followingI am very new to FME and only learning the basics. Is there an easy way to do this in FME for all the Bus Stop Codes ??I've attached an example CSV fileJames

How would you mosaic many disjointed jpg tiles along several different routes within a city area and write resultant to a File Geodatabase? Does FME create the FGDB on the fly?

I have a Workspace that generates a .jpeg file with a named coordinate file. wld. Is there no way to generate the .jgw file or rename it to .jgw after translation?

Here is a screenshot of my XML Formatter:and this is the Output:<CABS_EINGRIFF xmlns="http://schemas.webs.idu.de/cardo3/Ikx/IkxBase"> <EINGRIFF_EINGRIFF xsi:nil="true"/> <EINGRIFF_INDEX xsi:nil="true"/>...Why does the first tag get all the schema information added to it and how can I stop FME doing it?

When using a donut as a Clipper the Clippees on Clipper Boundary setting does not work like described in the documentation. It says:This parameter directs what action should be taken with Clippee features that lie entirely on the boundary of the clipper.Treat as Inside: These features that lie on the boundary are output via the Inside port. Treat as Outside: These features that lie on the boundary are output via the Outside port. Treat as Inside and Outside: Points and line segments on the boundary are duplicated and output as both Inside and Outside.  So the data I have is like this: The donut is the clipper, the blue lines lie entirely on the boundary of the clipper.The parameters I use are like this:Single Clipper, Clippees on Clipper Boundary: Treat as Outside.The result is like this:The green line, on the outside of the area, leaves the Clipper correctly from the Outside port. The red line comes out of the Inside port. I think this is not correct.Found this in 2017.1.2.0 (build

I would like to use the pixel values from a raster to proceed with different kind of analysis without converting to vector data. As you can see in the screenshot, in this case is the value from Band 0 (INT32) such as 50.Best regards,Felipe Verdú

Hi, I use FME desktop to generate topografic profils with Chart Generator transformer. It works well and I want to add a EPS (Adobe Illustrator EPS) writer but with many combinations of parameters, it doesn't work and I can't have a profile as eps file.The goal is to work with this eps file in Adobe Illustrator to have a wide choice of customization.Is there anyone who has already worked with this case ? And if you have any tips to help me.Pierre

I have an XML Formatter transformer translating a query out of a MSSQL Database.  My XLD does not allow empty values, thus I always need to go through with a text editor and find XML Tags which look like this:<KONTAKT2_EMAIL></KONTAKT2_EMAIL>and change them to this:<KONTAKT2_EMAIL xsi:nil="true" />This is rather time consuming and I would like to perform this validity check in fme. I would therefore need to build in the following logic into the xml formatter transformer:if Value = Null then XML Tag ends with xsi:nil="true" />Any idea how to achieve this?

Hi I would like to add different types of xdata for a layer from a .dwg with autocad.

Hello,  I hope FME community can solve my problem. I have polygons that represent parcels, polygons that represent buildings, and points that represent parcel and building numbers. I need to add unique identifier to parcels, buildings, parcel id and building id that are on the same parcel. I have attached a picture so I could explain what I need easier (1.png).I have a parcel 2375 and I need to add to new attribute, lets say ID, value 111111 to polygon parcel with id 2375, point parcel_num with parcel_id 2375, polygons buildings 1, 2, 3, 4 and point building_num with build_num 1, 2, 3, 4. All objects in one parcel need to have same identifier in their attribute lists.I will use attributeManager to add new attribute all Features, and Counter to add unique value but I don't know how to group all objects to parcel.

Is it possible to write mixed geometries to a ESRI geodatabase? I am trying to write polygon, points and polylines out to the same gdb but only points are being fed through

Hi,I am using the Geocoder for the first time and I get lot of warnings that feature must have at least 4 coordinates and then my output file has no coordinates.I start with a shp file that has postal codes and centroid for each of the postal code and then I am doing reverse look up using the OpenCage API. I set up inside x and y as my Lat and long and and entered my API Key. Those are the only set ups I did in the Transformer.Am I missing something? Can someone please help me?

I am brand new to FME and am trying to recombine text objects that were broken up by character. I am trying to learn from the transformation documentation, but ultimately am at a disadvantage due to the new jargon. I start out with geoPDF filled with layers that are in turn filled with text and other objects (see above). I need to extract these text objects into a shapefile. The problem is that when I open the layers within FME using the Adobe Geospatial PDF Reader, it breaks up my text objects into adjacent characters. Thus 56 becomes 5 next to 6. Assuming there is nothing I can do about that, I am trying to use either the Aggregator or Neighborhoodaggregator transformers to recombine these numbers. The problem is that I do not understand how to make the Aggregator's group by to work so that by putting the text object's X and Y coordinates in there the transformation would combine them based on their proximity. Neighborhoodaggregator provides a promising method, but I seemingl

I'm reading a source file and this is the output.What I would like to have instead is only one row per Name and then have one column for each number of months (as attribute name) and its RRP (as attribute value).The columns should be the following:header/attributes:Name ; 3-Months-RRP ; 6-Months-RRP ; 9-Months-RRP ; 12-Months-RRPvalues: AR201130 ; 5.82; 11.64 ; 17.46 ; 19.40Thanks for your help.

Hello,  I would like to replace the strings that only consists of number for example :11Although I have string that are for example 11 xxx which should not be replaced.  In short, if the digit is followed by any word character Stringreplacer shouldn't select it but if the number is there buy itself then select it.

Hi, can't seem to get text included in my raster output png despite whichsettings I use. Point is working ok.Valid ground extents are specified.FME Desktop 2018.0.0.2

Hi,I have an issue executing my workbench (It use to work before). I have a list of url (returning OSM XML files) which I read with a FeatureReader tranformer.I set the proxy parameters of my orgnization correctly (FME options), and it seems to work fine, until the execution fails (and never at the same stage), see the log below :XML Parser error: 'Error in input dataset:'http://api.openstreetmap.org/api/0.6/map?bbox=7.1459,43.6763,7.159,43.6858' line:1 column:1 message:invalid document structure'The XML Module halted on error, see the logfile for detailsThe XML reader has encountered an error.A fatal error has occurred. Check the logfile above for detailsThe url is valid when I test it... Does anyone have any ideas to solve this problem ?Thanks in advance,Fabien

Are there any examples of the SVG write templates being used online?I want to setup a template that allows my features to have both an id and title parameter but without any prefix.So that would be:<g id={value1} title={value2}><path fme:parameters...