Transformers

Hi,I have 2 lines which overlap. Every line has start width and end width.Ex: line_id_1 with start_width 1m, end_width 5m, from measure 0 to measure 100Line_id_2 with start_width 2m, end_width 4m, from measure 50 to measure 80I’m using LineOnLineOverlayer to get 3 events from measure 0 to measure 50 and from measure 50 to measure 80 and from measure 80 to measure 100.What I need is to have the width of line_id1 from measure 0 to measure 50, also width from measure 50 to 80 and finally width from for the line_id_1.I used LineOnLineOverlayer, then listIndexer, then MeasureExtractor and then aggregator (the Aggregator is to get the information that I have 2 events from 50 to 80).It is not important to use the same approach, if there is another solution to do the overlap between the 2 lines. thanks

Hello! I have several fields in a file that contain consecutive spaces. I want to replace the consecutive spaces (generally just 2) with one single space. But I've tried several ways with String Replacer to denote 2 spaces and I can't seem to figure it out. Can anyone help?  Example: What I have: 123  Main  Street What I want: 123 Main Street

Hi!I've used the instructions on this page https://knowledge.safe.com/questions/21627/finding-percentage-of-a-area-within-other-areas.html (clipper), since I'd like to know how much recreational land is within a certain service area (buffer zone) of each city in a region. The problem is that the method in the link above does'nt work for this, as far as I know, since the geographical buffer zones of the cities overlap each other. I'd like the final result to be a file with all of the cities and an attribute column with a number for the amount of recreational land (hectar) available. I wonder if you could help me figure out how to achive this in FME? I am not looking forward to calculating this individually for each city, even though that would of course be an option.Thank you!

Version information: FME Desktop 2017.0.1.1 build 17291 win64 FME Server 2017.0.1.1 build 17291 win64In FME Desktop I created a linked custom transformer with looping capabilities. I saved the custom transformer as a fmx file, installed the file and implemented the transformer in an existing workspace. .After installation it was available in the workspace by searching for it on the canvas. When editing the transformer it opened correctly the right fmx file. That shows to me that linkage should be correct. Running the workspace in FME Desktop gives proper results.After that, I published the workspace to FME Server. During publishing, I selected the fmx file and picked as saving location the repository where the workspace would be saved. This is according to the steps in the FME Server documentation: 

Hello Safers. Hope all is well.Im wanting to use the InlineQuerier to do a WITH RECURSIVE select.Trying to make a path from a tree stored in a relational model. Very much like this example: https://academy.vertabelo.com/blog/do-it-in-sql-recursive-tree-traversal/Unfortunately I found that WITH support is not in version 3.8.2 of sqlite (which looks like what FMEs is using) WITH support was added with 3.8.3. Are there any plans to upgrade with future releases of FME? Or some way to patch it. Any other suggestions or workarounds? I guess I could write to a different database that supports WITH and read back. However, I was trying stay all with file based tables. Thanks in advance.

I have a bunch of Microsoft Word file i want to count word in and the use the most common word with geographic content to generate a polygon where the word file is about.My problem is that i cant read a word file in FME. I have created all the workspace to do what i want but the problem is that i have like 2 000 word file and i dont want to convert all of the into txt.Do anyone have a solution to this?

Hi Everyone,First post, so be nice :)Just doing a simple task of checking for duplicates based on polygon id within a .TAB file, (eventually I want to output as a shapefile). It has returned two polygons... How can I now amend the id's of the duplicate polygons by adding say either a or b? I've got attribute manager but not sure where to go from here?Hope that makes sense :/Thanks very much.

Hello, I am working with an excel file with lots of field where I want to remove the space before and after a "/" eg. HWY 427 / North Queen St to HWY 427/North Queen St. I have been testing using the String Replacer where Text to replace: is ([A-Z])([A-Z]). Does anyone else have any suggestions? Thanks in advance.

Im using the AttributeValidator to test words appears in my .csv file. It finds the following no problem - raised defence (man-made), but it keeps failing for the following - sea defence (man-made), even thought it appears in the list to test for. I have checked spelling and made sure there are not any extra spaces but it doesnt seem to recognize the word in the .csv file. Has anyone else had a similar problem? 

Can someone give me a hand on the RegExpression to extract a bunch of coordinates from this XML table. The column they are stored in has a lot of other information in various formats.

I have a col A which has values from 1-5. Can we get the list of all values of col A from 1-5. If so, could you please help me with the logic.Thanks!

hi,Is it possible to use TaperLineBufferer to create a buffer to only the left or the right side of line?Thanks

Within AutoCAD / Civil3D it is possible to add metadata on block definitions, not being attributes. Somehow I cannot access these metadata fields in FME. Does any one have a solution for that?Figure 1. Blocks with attributes, this information is accessible within FME. Figure 2. Metadata information of selected block shown in Figure 1.  I have tried enabling user defined properties and XDATA, but somehow I cannot acces the metadata.I am using FME2017.1.1. The final goal is to write these metadata properties into a new dwg. I know I can add these as attribute properties to the block definition, but that is not what the user wants as its final result. Added you'll find the example DWG.

Bonjour,Je débute encore sur FME et ma question va peut être paraître idiote mais j'ai beau tourner les configurations dans tous les sens je n'arrive pas à trouver la solution.Je souhaite étiqueter des rues à partir du nom présent dans la table attributaire de mon tronçon de rue.Lorsque j'utilise MapTextLebeller j'ai, sous mes étiquettes, une série de ponctuel dont je n'arrive pas à me débarrasser. Savez-vous comment faire pour avoir uniquement les étiquettes sans les points lors de mon export?Merci d'avance!Cordialement,

Hi allIm struggling to hit a specific gml setup and for this I need to split up a line of coordinates every 4 coordinates (I have no idea why the gml has to be this way.). I guessing i need to use regular expressions but im stumped as to how to write one that gives the right result.an example string of coordinates that i have extracted using geometryextractor -> GML v2.1.2 looks like this:711744.265,6175978.47 711791.544,6175982.446 711792.0123,6175979.7872 711792.5482,6175976.5078 711772.1563,6175974.7882 711755.5244,6175973.3985 711755.7058,6175970.729 711758.604,6175934.878 711722.2771,6175932.0269 711681.914,6175928.848 711683.786,6175998.563 711704.5651,6176000.163 711742.48,6176003.089 711744.265,6175978.47but it needs to look like this for the gml to work for its intended purpose:711744.265,6175978.47 711791.544,6175982.446 711792.0123,6175979.7872 711792.5482,6175976.5078 711772.1563,6175974.7882 711755.5244,6175

Hi,I have recently upgraded my FME to 2016 and I am getting some weird output. I am writing a MITAB file. From the last transformer I have an inspector and everything is correct and normal but then it goes to the writer and the output MITAB file would come out incomplete.Has anyone ever experienced that? How can I fix it other than maybe re-writing the whole workbench..?Thanks!

Hi,I have polyline with polyline_id with start and end measure (ex : 0 and 100). And another descriptive information (without geometry) with start and end measure (ex. 50 and 75) and the polyline_id.I did featureMerger and then snipper with measure value.But I got the whole polyline (0 start and 100 end ) but I want polyline with (50 and 75)There is something wrong. Any idea how can I get it. Thanks

I'm wondering what is planned for the first webcast on November 1st, 2017. Any details would be appreciated?

I was talking to a FME Server friend and they asked about how others are dealing with log monitoring, management and analysis for FME Server. They mentioned tools like Splunk, Solarwinds, Liberato. What tools are people using? What processes are in place? What gotchas are there? Best practices? Tips and Tricks? What are the main reasons for undertaking log monitoring, management and analysis?

Please, I’m having some challenge creating a user parameter (usable in the FME Quick translator) that allows the user to specify an ‘attribute’ to participate in a query that selects a list of settlements planned for visit on a particular day of a campaign so that only settlements with a Y (yes) value for e.g. day_1 (selected by the user) participate in the analysis for that day.Sample table:What I already did:Created a user parameter called ‘Day_of_Campaign’ (type: choice) where I have preloaded options day_1, day_2, day_3 etc. representing the attributes (tried using type: attribute name but this doesn’t allow you a drop down of the choices using the ‘FME Quick translator’ (I want less interaction with the actual workspace - need this run from the quick translator so the users don't mistakenly alter

HelloI have a lot of points with coordinates x,y in latitude,longitude.These points are grouped in records. Each record is identified with an unique identifier. Call it "Id". Each record can have multiple points In a record each point must be joined to the next one following it by 2 means :1- a straight line 2 - an arc of circleWhen the arc of circle is used, we need to have the center point coordinates and the radius. An attribute is used for that with the coordinates of the 2 points which have to be joined to form the arc. The end point has to be joined with the first one by a straight line. I have to draw this geometry for each record and i don't know the way of doing this. 1 - polygones 2 - polygones with arc of circles.Any help would be great

Hello.This might be a strange question since it does not take into account the Earth. Also, I am quite new to this topic but I did research. I found a lot of things but I never got the result I wanted from various calculators and doing it manually is hard since I am not that familliar with this math.I was wondering, is there some way to calculate XYZ -> degrees for other bodies with different radius?For example, this is one of solved:Planet Radius: 2094km, Earth Masses: 0.0541, X: -1786579.7, Y: 519690.56, Z: -959322.31This equals: Latitude: 9.2921 and Longitude: -153.9814. I figured that Y and Z are Lat\\Long.I have no idea how to get this result. Ive tried various calculators like: https://beta.ngs.noaa.gov/gtkweb/ but I just cannot get the correct numbers.If anyone can offer any insight into this issue I would be very grateful. Thank you.