Transformers

 input  required output   i have duplicate ,same many id in first columnfor each duplicate has different values in attribuute worldas input excelfor id 400 has 1,2,7so i want to extract one id from the duplicated one id called 400 for the three duplicated id and in front of this id 1,2,7 change all values in attribute world that contains 1,2,7 to new value for any id not included in world attributethen chack again if we have another duplicate value in id attribute ,same method ,extract one id as 267 and it contains 3,11 in attribute world so change any value in attribute world to new value for any idso i want to check at first column if i

I would like to ask ,if I have four excel file I want at first to compare between two attributes ,Id attribute ,both of them should have the same attribute but some times one excel file has more than another.So ,I would like to check which has more and If first excel file has more than the second excel file so I want to know the new id and extract for each new Id from the third file the data in this row belongs to this id. And at the same time If the second file has more id than first time ,so I would like to extract know which Id is more in second file and add them to first file and extract the data from the fourth excel file .So I want both of excel file ,first and second should be matched in Id and each one extract the missing data from separated file .Because only common between first and second is Id and the rest of data from another two files

Is there a transformer that can easily define transformation parameters for affine transformation. What I do have is set of points with old coordinates and same set of points in new coordinates. Can this be used to compute affine transformation model.

Hi, I am trying to use the DateTimeCalculator on the calculate interval between two datetimes. The results I will get will be negative number as the date will be before the start date.  I am getting all the results rejected. Can the DateTimeCalculator output positive and negative numbers in the results? Looking to use this for stats between two dates and if under and over the target date. Thanks Kevin

Is there a way to apply local generalization? Or some other method to smooth out specific parts of lines without touching everything? I find that the generalizer algorithms are quite hard to understand. Take the example below, I would like to do something about the U-turn, preferably remove it, but the rest of the linework must not be touched. In other places I would like to smooth out 90 degree turns. Still without touching the rest of the linework. Any ideas on how to achieve this?   

In StringReplacer v5, if the 'Replacement Text' is set to % the transformer will only remove the 'Text To Replace' but not replace it with %.The workaround seems to be to enter %% instead of %. That's not the expected behavior I suspect.Have I missed something?Cheers FME 2019.2.2.0 (20200103 - Build 19817 - WIN64)

I'm looking for a way to filter a bunch of areas based on a minimum area. What I'm doing is essentially creating an area of lidar point coverage and comparing it to the AOI boundary. Any areas that have missing coverage get outputted however I would like to filter these outputted areas based on their size. Sometimes some false positive returns happen because of small gaps from no returns off of water. I tried removing these smaller areas using a test filter but I'm pretty sure the area it's looking at is the total area of all missing coverage spots and not each individual area.

It would certainly be useful to be able to CTRL+A all table results in the data preview window. At the moment I can only draw a rectangle around all the map elements or open the Data Inspector.   

Hi, I have two files,  One coordinate-file (measured rock bolts, X,Y,Z)One DWG-file containing theoretical rock tunnel.I would like to create a 3D-model of the rock bolts since i know the lenght of each bolt (3 meters). So, i would like to find the vector of each point the closest way to the surface (perpendicular), and then create a new vertex for each point and draw a line between the points. This would be the result (drawn in paint)   

I have a metadata string in a file and want to export this to its own attributes so I can export it to a database. If i use the fragmenter it gives only <missing> as output. I have elements to match: gmi:MI_Metadata and expose gmd:fileIdentifier. Same happens when i use the XMLflattener. I can't figure out what i'm doing wrong. Being stuck at this for a few days already. Only solution what worked for me wasExport to XMLOpen XML in Sublime text to Replace < for < and > for >Open the XML in a new workflow to extract to databases Sometimes i get this messagemessage:prefix 'gmi' can not be resolved to namespace URI Example:<?xml version="1.0" encoding="UTF-8"?><!-- BAG Metadata - Created with: -vSABER_5.2.0.9.5ISO TC211 schema --><gmi:MI_Metadata xmlns:gmi="

I don't know if this can be done consistently. But if anyone would know how it would be you. I would like to connect lines A and B and remove the "appendix" from line C. An AnchoredSnapper was my first thought, but there are probably plenty of occurrences where B would connect to C instead of A. Is there a way to only snap to something that is in the "forward" perimeter? If I could get the below working it might be a better idea to extend the lines and then cut away the surplus.Removing the appedix could be done with a LineOnLineOverlayer, but how do I find out which one is the shortest of the resulting lines? How would you solve this? What is the "cleverest" solution? 

Hello I would like to find the following part in a text file (originally xml file style) :<userData code="viPartListRailML" value="1">            <partRailML s="0.0000000000000000e+00" id="0"/>            <partRailML s="2.0000000000000000e+01" id="1"/>            <partRailML s="1.2000000000000000e+02" id="2"/>            <partRailML s="2.2000000000000000e+02" id="3"/>            <partRailML s="3.2000000000000000e+02" id="4"/>            <partRailML s="4.2000000000000000e+02" id="5"/>            <partRailML s="5.2000000000000000e+02" id="6"/>            <partRailML s="6.2000000000000000e+02" id="7"/>            <partRailML s="7.2000000000000000e+02" id="8"/>            <partRailML s="8.2000000000000000e+02" id="9"/>            <partRailML s="9.2000000000000000e+02" id="10"/>        </userData> 

I am fairly new to FME and Python. I have written the python script to extract emails from our outlook server. It is successfully pulling down each email from a mailbox and separating out the body, subject, attachments , etc. These I have placed into attribute elements without any issues ( code below ). The problem I have is returning each email in the transformer as a separate row. I only get the details of the last email I am downloading. I would like each email to be returned as a dataset - eg the data inspector should show 7 rows for 7 emails. Any assistance on how I do this thru the pythoncreator transformer would be greatly appreciated.Many thanksOlly import fme import fmeobjects import sys import email import imaplib import os import base64 def process

Hi, I have to insert some data from an ArcSDE GeoDatabase to a SAP Hana database.  The next step should be to add a second Geometry columns with another geometry that will contain a reprojection of the current geometry.  Don't ask me why they want that.  Here my ID Was to insert the "normal" data, then reproject and update the table with a new name but I don't have the possibility to give another name.    First of all is it possible to do that in SAP Hana ? I'm not SAP Developer so it's not my business ...  Thank's for your help.

XY tolerance in FME,  As the end product of my workbench is ESRI feature class, I couldn’t figure out which option allows me to select the XY tolerance (resolution) of this feature class.      Thank you  Best  Jamal

I need to combine the attached drawings following this procedure:drawing A contains geometry);drawing B contains some attributes defined in AutoCAD with the ATTDEF command, but doesn't have any geometry featuresHow can I build, inside FME, the drawing C using the geometry stored in drawing A and the attributes defined in drawing B?How can I extend this kind of workflow to have in input an entire directory (in which there are hundreds of .dwg files) instead of a single drawing A?So far I tried toconnect directly a reader and a writer, setting drawing B as template file but it didn't work.Thanks for your help.

How would i go about converting single tiff and multipage tiffs to pdf?

Hi, I need to convert some heights from WGS84 (GPS) to CGVD2013. I am trying to use CsmapReprojector and for vertical handling I used Geocentric or ellipsoid height -> Orthometric height and selected BCGG2013-ITRF2008_CGVD2013.gdc height grid. But I have no idea if this is the correct way to go.  Thanks!

HiI use FME mostly for conversion of dwg/dxf/Shape files and changing their coordinate system with the help of GtransReprojector In Sweden all the county’s have different types like, SWEREF 99 15.00, SWEREF 99 14.15 SWEREF 99 16.30 SWEREF 99 18.45 and so on and we use SWEREF 99 TM Sometimes I haven’t been told the source coordinate system and I have trouble finding (guessing) what it isIs there a way that I can identify the source coordinate system with the data inspector or any other tool?

Hi,I have multiple GeoPackage files with different schemes.I want to store them in a zip folder, but in separate GeoPackages not in one.Which transformers can I use for that? Thanks and best regards? 

I am trying to create a simple scripted parameter that creates a unique random id to insert into a DB for reporting purposes.I am following step by step the example in the FME help pages:https://knowledge.safe.com/articles/60080/python-scripted-parameters.htmlI create a variable and I assign to it a UUID using the python module (interpreter 3.4+)https://docs.python.org/3.4/library/uuid.htmlimport uuidimport fmecustom_uuid = str(uuid.uuid4())# I tried both with and without conversion to string # custom_uuid = uuid.uuid4()return custom_uuidFME workbench does not read the parameter as the result of what is returned in the script, but reads

Hi, I have polygon datasets, where I would like to filter one object based on id and I would like to set the parameter of Search Envelope based on this filtered object. I will extract the bbox of the polygon. How can I pass these values to Search Envelope? Thanks in advance.  Best, N

Is the naming of EPSG 29903 incorrect? On the website https://epsg.io/ , EPSG:29903 is labelled as TM75/ Irish Grid. Whereas within FME EPSG:29903 is labelled as TM65 (See below). I understand the epsg.io is correct (but I may be wrong). Thanks for the help. Bepsg.ioFME

  ID DIESEL last 1 2 2 23 5  4 5  5 3 1 1 1 6 5 10 3 2 1    i want to check for every id ,if it has a value in last attribute or not if it has soit should check also if this id is repeated in same attribute ID or notif yes so it will check which value in last attribute that it hasbcs both of them has the same id so i want to take the two values that it has found as example above 1 and 2and search in Diesel attribute which contains 1 and 2 and change to new value say 15 but it is important the new value not include in Diesel attribute any number does not matter but new value not include in diesel attribute but if the id has only one value in last attribute and no common id in id attribute soi want to t

I have census data in csv format and would like to rename several fields. Basically I want to rename fields by renaming specific words Private to Pvt, Dwelling to Dwlg. I also want each word in Proper case so the fieldnames aren't so long. Hopefully someone can help me with how to tackle this.