Transformers

I have two datasets, 1 and 2, containing addresses. The address consist of all the 4 fields.I'm trying to compare the two datasets, to find matches between the two. I have already used a stringreplacer, to remove all the spaces in the postalcodes, and to replace all the special characters in the streetnames.In dataset 2, the addition2 field contains a lot of random information, as you can see. I need help compiling a python script (to be used in the python caller transformer or any other transformer) that's able to:- detect when there's more than one character in the addition2 field (I expect that field to contain only one character) and filter that record out;-from the filtered records, detect the first (or maybe first three?) characters in the addition2 field, and use that to recheck the address in dataset 2 with address1, to see if there's a hit. - if there's no hit, I want fme to ignore the information in the addtion2 field, see it as an empty field, and then co

Hi,I am trying to scale a number of text (containing map legends) as such ; with the number of generated x coordinates within a specified bounding area the texts will be scaled up/down relatively. For example, if I have 5 'x' coordinates generated in a map area , the scale factors in X: ang Y: will be 5. I have a atrribute where it saves the nuber of generated 'x' coordinates and i would like to read the valus from there as X: and Y: scale factor in Scaler. But when I try to read the column values in Scaler transformer, it rejects the tranlation. Any idea how to solve the problen ?

I would like to exaggerate my elevations in a xyz point cloud. Is there a transformer which would simple allow me to define a simple formula e.g "z*4"?

I have a DATETIME string of the format 20180311140001Which is YYYYMMDDHHMMSSHow can I subtract 10 hours?Note: I have FME2016, so I lack the DateTimeCalculatorOnce I have calculated the above, I still need to do more tweaking, but that is string manipulation, not a math calculation

Hi,I have a special collada file is seems. FME is able to correctly read and view the model however when it comes to textures, it's falling over.We have a .dae file that uses Instance_material to refer to a target file directory and also makes reference to an object in the same call.e.g<instance_material symbol="wall" target="../materials/wall.dae#wall" sid="wall">    <bind_vertex_input semantic="uv0" input_semantic="TEXCOORD" input_set="0"/></instance_material>I found only one reference to someone with a similar issue. I used https://www.khronos.org/files/collada_spec_1_4.pdf for referenceand https://www.khronos.org/collada/wiki/Using_URIs_in_COLLADA .In theory it should work, but perhaps this is not supported in the Collada reader? Thanks.

I have a few thousand points in an SDE layer and I need to see which points intersect or overlay a polygon layer (hundreds of polygon features). Intersecting points will get a risk value assigned to them (I was thinking through a test filter and attribute creator). Non intersecting points just won't have a risk value and all points whether intersecting or not get written to a point featureclass I already have created in SDE. I've tried PointOnOverlay, Intersector, and even SpatialFilter but I must be setting this up wrong. Any ideas? Many thanks

Trying to tile a Microstation DGN file into tiles. Used Raster tiler on an ECW and that worked fine. It appears that Tiler doesn't work the same on vector files. Why is that?

First off, is there a location where I can download the dashboard pages? Our dashboards seemed to have gone missing.Secondly, I'm looking for a way to get what is coming out of the JobHistoryReader, but including FME_SERVER_REQUEST_PARAMETERS and FME_SERVER_REQUEST_HEADERS arguments with an FME job so I can run stats and be able to filter stats based on remote address or an application ID that is passed through as a parameter. Has anyone done this or have any idea of how to do it?Thanks in advance!

I have downloaded a 3D Sketchup model from Sketchup warehouse and trying to convert it into 3D pdf ... A blank pdf file is resulted.. Execution Summery:Starting translation...FME 2017.1.0.0 (20170731 - Build 17539 - WIN64)FME_HOME is 'C:\\Program Files\\FME\\'FME Database Edition (node locked-crc)Serial Number: 0Temporary License: 30 days left.Machine host name is: Anuj-PCSTART - ProcessID: 8816, peak process memory usage: 31788 kB, current process memory usage: 31720 kBFME Configuration: Command line arguments are `C:\\Program Files\\FME\\fme.exe' `C:\\Users\\Anuj\\AppData\\Local\\Temp\\wb-xlate-1517680516554_10516' `LOG_STANDARDOUT' `YES' `LogCountServerName' `{e9a3db67-8fcd-4a27-88f3-14e3fc738201}'Shared folders for formats are : C:\\Program Files\\FME\\datasources;C:\\Users\\Anuj\\Documents\\FME\\FormatsShared folders for transformers are : C:\\Program Files\\FME\\transformers;C:\\Users\\Anuj\\Documents\\FME\\TransformersShared folders for coordinate

Feature is not a 'line (spaghetti)'. Migration to 'point' attempted for feature destined for table 'ACE.T_OH_LINE'Error while generating line shape for Table 'ACE.T_OH_LINE'. Scale Factor may be too small.:SDE_ERROR_CODE(-148) The number of points is less than required for feature

Dear FME users.I maked a buffer with Bufferer transformer with a group by ID but it doesn't work on all lines.So I tried to dissolve my buffer with Dissolver but I've the same result like you see on this draw :(Blue : My original 10 buffers - Red : My result)I give you a workbench example : Do you know how I can't d othat correctly ?Thank you for your help.

hello, I have Dissolve Line features and I want make a fishnet with my complete dissolved area. I tried with tiler but it shows. FileGDB Writer: Failed to write Geometry to feature class 'TILED_V3' with geometry type 'esriGeometryPolygon'. Dropping containing feature Storing feature(s) to FME feature store file `D:\\FME\\Envelope_log.ffs' +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Feature Type: `TILED_V3' Attribute(32 bit unsigned integer): `OBJECTID' has value `43' Attribute(32 bit unsigned integer): `_column1' has value `25' Attribute(32 bit unsigned integer): `_row1' has value `77' Attribute(string) : `filegdb_type' has value `geodb_polygon' Attribute(string) : `fme_feature_type' has value `_polygon_' Attribute(string) : `fme_geometry' has value `fme_aggregate' Attribute(entangled: string) : `fme_type' has value `fme_area' entangled to [file

Schema is coming from the schema port of the feature reader and data is coming from the generic port. If I change the structure of the table connecting transformers to the schema port those changes are not reflected in the output data that is coming out of generic port. Any help is appreciated for more information please see attached image called "sample". Thanks in advance.

Please find attached the workflow diagrams and csv file used in FME.

I am already familiar with: https://knowledge.safe.com/questions/4717/fme-server-email-entire-log.html but it isn't what I want. I want to know how to send the job stats at the bottom of the log file to a user like this:

Hi, I have a need to set ImageRasterizer's ground extents based on one of the DWG layers bounding box! Is it possible? Please tell me so! It's a deal breaker for me to decide if FME is usable for us.

I want to apply color to 3D features via FME attributes.To my disappointment I found that AppearanceSetter does not allow attribute values for color setting. AppearanceStyler does however.Problem now is I have to split my stream of features in order to get one stream with the features, the other stream with the appearances so I can use the AppearanceSetter to finally apply the appearances.Do I need to create unique Ids for each feature in order to get this working properly, or is there an easier way to do this ?Any reason why AppearanceSetter doesn't allow me to do this directly ?Thanks for any hint

I have a pipeline featureclass from SDE that I would like to create points on top at every 100 feet. I've tried Snipper, LineDivider, etc but not getting desired results. Thoughts?Thank you

Hello,I created a workflow that takes several FGDBs into a directory and dynamically exports them as Geojson files with their jsonschema, and it works well. But ...The result for attributes with a type "date" is something like "20180205152004" (which is, I suppose, the string in the FGDBs files)What I want is a rfc3339 format like "2018-02-05T15:20:04".As my files do not have the same structure, I would like to be able to detect any attribute of type "date", to modify it so that it respects the standard rfc3339.Of course, if I could know what are the good attributes I could use the DateTimeConverter!All my efforts remained vain. Does anyone have an idea?

My actual project is to read layers dynamically and set schema before writing it into target database. Just to understand how schema mapper works, I used schema mapper between layer and target database. I passed csv file with source field name and desired destination field name. When I ran the workspace the output has all the fields of the input. Please see the attachements for better understanding.

I am trying to convert an image I have that is in TIF format to a JPG format. I've done it before but just forgot the path. If anyone has any suggestions of tips please let me know thank you!

I am accessing a web service that returns the date/time attribute (OldTime) in the following epoch/timezone format: 1352984400000+1100. The format is Milliseconds+hours. I have successfully created created the following workflow:1) Split the attribute using "+" 2) Expose the _list{0} and _list{1} values3) Create new attribute to hold milliseconds to seconds EpochNoZone: @Evaluate(@Value(_list{0})*0.001)4) Create new attribute to hold time zone hours to seconds called TimeZone: @div(@Value(_list{1})*60*60,100)5) Create new attribute called NewTime which is the sum of EpochNoZone and TimeZone. NewTime now contains the epoch time in seconds.6) Finally, feed the NewTime attribute into the DateTimeConverter using the Input Format: %s$ 7) NewTime will now hold the value 20121116000000 - correct time in %Y%m%d%H%M%SHowever, it would be much simpler if I could feed in the initial OldTime attribute into the DateTimeConverter transformer with the following input format: %s + %HIs it p

i have two sets of data: a lidar point cloud and dgn files with some 3D lines/polylines.How can i check if these lines are close (lets say within 4 m from surface)/under/touches the surface created with pointcloudsurface?

I have dissolved line feature which I have to cut down from the administrative boundary I used line Dissolve areas and a tiler (with fix seed coordinate) are in Clipper port and the administrative boundary areas in the Clippee port, Clipper type (multiple clipper), no group by. Now it running very slow and showing Performing low-level intersection at phase #1... 100% doneFinished clipping group 22 / 4558have anyone any suggestions?

How can I convert a csv file in lat/long data into an Esri Shapefile that is BNG easting/northing?