Transformers

Hello Team,I am loading data from .JXL to SDE, While loading data i got following error, Could somebody help me out with some resolution for the issue.|ERROR |An error occurred while attempting to add a shape to a feature buffer. The error number from ArcObjects is: '-2147220936'. The error message from ArcObjects is: {The coordinates or measures are out of bounds.} Thanks...

Hi I have been provided with a dwf file with pipeline information. I would like to extract the pipeline and attribute data. I was thinking I can use nearest neighbour method for this but I can't even extract the text or specific pipeline data. Could someone guide me with what I need to do to expose the attribute to get this information.

Hoping someone can help with this. Since upgrading to 2019.2 our existing workbenches have begun to fail. Each time a coordinate system is called on it appears to be missing a curly brace at the end. E.g. "{EPSG:27700 is not a valid key name." or "{OSGB-GPS-2015 is not a valid key name.... Last line repeated 11 times ..."These are only warnings until eventually the workbench fails under:"No definition was found for coordinate system `{EPSG:27700' "Wondering if this is a bug or if we are missing something? Let me know if I need to provide more info.

Hello,  I try to connect points to assess certain river characteristics. I used LineBuilder > connection break attributes (to the attricube that speficies one specific profile along river). However, it's not one, line but split up in several parts, even though the attributes do have exactly the same number.  What is the reason for these 'cuts'? And moreover, how can I connect the lines?  Thank you very much!   

I'm trying to generate a cell averaged DEM to generate smoothed contours within FME. After converting bare earth las points to a DEM using the Raster DEM Generator (1' cell), I want to average the values of those cells for smoother contours and it seems that the Raster Convolver is my best bet. Within the Raster Convolver I'm using a 5x5, weights all set to 1, Divisor set to 1 and Operation set to Mean but my results arent really matching what I can create in ArcGIS, they appear to be shifted to the side, about 2.5'. The Focal Statistics tool in Arc can be used to average the cell values of my initial DEM in a 3 cell radius with proper results. Are there different settings I should be using in the Raster Convolver or is there a better way to go about this?

I have approx 600 points based on top of a surface. I want to be able to generate a 5 meter long line in each of these which is in the normal direction of that surface.This is to be used for planning boreholes in a tunnel.Finding the normal of a surface is ok - but the normal of the point on a surface seems to be more difficult. The lines that needs to be generated is created manually on the last image. 

Hi I have a GeoTif file and need to convert it to RAW format for import into Unity as a terrain. Anyone know how to do that? Tried different options but nothing seems to work.

Hi. A calculation has been completed in FME and a PDF of the results has been generated. The results are shown in tabular form. We also want to generate a graph/chart from some of the data and add this graph/chart to the PDF that is produced. Can anyone provide any guidance on how this can be done?

I have two MicroStation Files, one is a parcel map with parcel numbers inside each parcel polygon. The second file is a right of way polygon that intersect the parcels. How do I create individual parcel polygons of just the right of way intersections and attribute each polygon with the parcel number?

"2046": {        "ID": "020935",        "Address": "Bagg Close 9, 29643 Churchtown",        "Provider": [            "D2 - GSM09",            "D2 - LTE08"        ],        "Locationdocuments": {            "stob": {                "date": "/Date(1412546400000)/",                "Applicant": "Vodafone",                "STOB": "c8859eec-63b2-4a75-a2c2-00a586110005",                "TD": "74c192b2-0067-40fc-a41d-f5b5f73afbf1",                "BZ": "0eb422f8-0561-4f4f-8324-d7110ff56ff0",                "LP": "0b37ed04-4d01-4f07-b67f-d8bd2590a66c",                "AD": "c019cc03-c812-4816-8024-407cedeb461c",                "IBA": "9684e283-10e6-4e95-8931-3906fd3a62cb"            },            "12.09.2014": {                "date": "/Date(1412546400000)/",                "Applicant": "Vodafone",                "STOB": "c8859eec-63b2-4a75-a2c2-00a586110005",

 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