Transformers

My DB contains line (say street network) and points (say Bus Stops), the points has to be placed on the vertex of the lines.Would like to find out all those points which is not placed on the vertex of the snapped line.

I 'am reading a Json file that contains a timestamp. I need to convert this to a date so that I can aggregate other data on Year, Month.I've tried using an attributemananger (@value/86400)+25569+(-5/24) and DatConverter to convert the timestamp but this didn't gave me any results.Therefore my question how to do this?

In a JSONTemplater I am using fme:get-attribute to insert the value of an attribute created in the workspace with an AttributeCreator.  The attribute is a represents a status code, so it should be interpreted as an integer, however the JSONTemplater always interprets it as a string, despite all my attempts at forcing it to integer.  Using @int(fme:get-attribute("_statuscode")) results in a TCL error (apparently the @int function is being evaluated before the fme:get-attribute function).  Also tried using an ExpressionEvaluator with @int(1.0) but this is still interpreted as a string.  Any ideas? Thanks!

While working with customers and sensitive data, we on the Safe Software Support Team often run into road blocks troubleshooting issues when FME Workspaces and source data cannot be shared (nor can an NDA be arranged in a timely manner – and for this argument, neither can a screen share be arranged).There is an excellent Knowledge Center article that takes a real world example, and provides a tutorial with many actions the user can take to anonymize sensitive data.Particularly the following techniques are used:- Removing Attributes (AttributeRemover, AttributeManager) - Renaming Attributes (AttributeRenamer, AttributeManager) - Replacing Attribute Values (AttributeManager, StringReplacer) - Geographic Manipulation (CenterPointReplacer, Offsetter) What actions do you take, or what do you think is missing from this list? Are

Hi! I have one problem with coordinates of my objects. For example, I created a simple cube in Revit and exported to IFC file. After that I opened file in FME Data Inspector and I have 24 vertices or coordinates instead of 8 which I think I should have. So they are tripled. Therefore, when I calculate volume it is three times bigger. On the other hand, area calculator works fine. Is there any possibility to remove coordinates and leave only one for each vertex or maybe something else is a problem?

I have a fme_surface and I need to clip it. As long as it is not possible to clip a fme_surface, I have tried to extract triangles from that feature and then clip them. Is it possible to extract triangles from a fme_surface without using the SurfaceModeller?

I have a very simple workspace which is basically 3 steps: readers, UpdateDetector, writers. It is intended to compare changes between two ArcGIS feature classes, which represent data from different years.The UpdateDetector has 4 output ports: updated, inserted, unchanged, deleted. The outputs from the unchanged and added ports seem to be more or less what I'd expect. However, the outputs from the inserted and deleted ports are not being written out to the final feature class - although the post-run numbers show that features were routed through these ports. When I preview the output in the DataInpspector, all the features from all 4 output ports are there. I thought I may be able to workaround the non-writing by doing a 'Save As' on the data in the DataInpspector, but when I try this I get a 'fatal error' with the following message: "In order to update/delete a feature in the table/feature class 'Inspector_UPDATE_area', the FME feature must h

Greetings,I am trying to export ellipse features to an ESRI file gdb.1)Do they need any processing by a transformer first??2)Should they be exported as a line or polygon??Any suggestions appreciated.

Why does this not work?SSIS Errors (Since @DateTimeFormat(@Value(init_start_time),'%b/%e/%Y') at @DateTimeFormat(@Value(init_start_time),'%T'))

Hi Everybody,I am using FME 2016.1.3.1In date time format I used* Source Date Format = "Unknown - Automatic Detection"* Destination Date Format = "FME Date/Time (%Y%m%d%H%M%S)"Then if the input is "2017-09-13T16:30:01" it will output "20170913173001".Attached is the FME workspace I used for testing. Did I do anything wrong? I don't want to have the hour shifted.Thank you!

Hi,My Workspace two Source : 1 feature of line and a Excel file with 3 features.The goal is bring the attributes of the XLS into a line.How can you see in my Template file, i used the FeatureMerger and after ListExploder. I have 3 lines but i need just one with all attributes.Attached my Workspace.Thanks, Danilo

Hello, I have a sequence of points along a line. I have to detect change in an attribute (called "framing") of a point from its previous point. The points are sequential. Sequences are stored as an attribute too "sequence". I imagine I can use an AttributeCreator to create a new attribute called "change" and make the value conditional. Problem is, I am not good at RegEx or conditional statements to know what would be useful. I need to compare the "framing" attribute with only the previous point within the sequence. Not the one ahead. I have been trying to follow the example in the thread below but no luck. https://knowledge.safe.com/questions/33705/compare-attributes-from-two-features.html Eg, if there is a way to compute something along these lines: IF point.framing = point

I'm trying to create an attribute ("incorporated") whose value is 0 or 1, depending on the value of another attribute ("Code"). I'm trying to do this in Attribute Manager. But I can't seem to get it to evaluate. I've tried many different permutations of the expression. The attempt shown in the attachment uses Python syntax highlighting which I would assume means it would be interpreted as Python code. Anyway, it doesn't work, as you can see in the breakpoint data.

Hi All, I am using a linked Transformer, creating an attribute, let's say Z. Attributes X and Y already exist on the object. On FME Desktop, the three attribute values X, Y, Z are passed by the Linked Custom TransformerOn FME Server, where the same version of the Linked Transformer is installed (double checked), the X and Y attributes are lost. Attribute Z, created by the Linked Transformer is the only remaining attributeIf I Embed the Linked Transformer and republish to FME Server, the X, Y Z values are all retained.Does anyone have an idea why this happens?best regards, Jelle

Hi guys,I am trying to use point overlay to get a point count over polygons, but everytime the Point Area Overlay transformer seems explode the multi-parts polygons. Is there anyway i can avoid this?Thanks!

We recently updated NTLM from v1 to NTLM v2. After this changes we getting '401 Client Error: Unauthorized' when we are trying to read SharePoint list with "Microsoft SharePoint List" reader. Our FME version is 2016.1.3.1 (Build 16716) Does FME support NTLM v1 and v2? Any suggestion here?  Thanks in advance Yarko

Hello all, I have a question for which I feel like the answer should be simple. But for some reason I cannot find anything in Knowledge Center or think of a way to do it. I have a network of lines with points all along them. The points are not necessarily at the start or end of a line but along them. I need to sequence the points starting from the start of a line segment to the end (it doesn't matter which direction). The first point along the start of a line should be flagged as point 1, the next as point 2 and so on. If a line branches off, the first point on that line will be point 1 again and so on. In the above example, we can also start from point 4 and go downwards in a sequence. Any help will be much appreciated. ThanksEdit: I am using 2016.0 fme desktop

Good afternoon, I'm working on a project where I am doing an area analysis for a set of polygons. The area is calculated in hectares in MapInfo and converted to a shapefile in FME; however, when the area is recalculated in ArcMap, the results are different at a consistent rate of 1.0039 (i.e. MapInfo: 34.6516368 ha; ArcMap 34.7855988 ha). The projection & coordinate system remain unchanged during the conversion so the area should remain the same. The same discrepancy occurs when an Esri shapefile is converted to MapInfo and calculated. Would you be able to provide insight as to the discrepancy?Thanks!

I have two point featureclasses and want to snap the points from Point_01 to Point_02. Both Featureclasses have 261 points, but after the translation, there is always only 245 snapped points and 16 which are untouched. I have tried many tolerances and snap-to-Vertex as well as snap-to-endpoints, but something is stopping the 16 points from snapping to the next point.If anyone can shed some light I would be most grateful

I am looking for a way to have a "default value"  if there is no data in a subtemplate.  Consider the house, village example from the help documentation.  If we have multiple villages with an id, and multiple houses with a village_id,  we can set the Root template to <village><name>{fme:get-attribute("name")}</name><population>{fme:get-attribute("population")}</population><houses>{fme:process-features("HOUSE", "village_id", fme:get-attribute("id"))}</houses></village>and the correct houses will be associated with the correct village. and you could end up with an output like <village> <name>Anytown, USA</name> <population>2568</population> <houses> <house> <address>123 Main Street</address> <owner>John Doe</owner

Hi,I want to know in detail about How to style DGN file based on attributes?What are Cell file and Cell Names?What is use of seed file and cell file?Thanks in advance.

Hi, all:  I have a huge MS SQL Server Non-spatial database,each record has a "datetime" time stamp. Now I'm using "SQLCreator" to read the data. In the SQL Statement, I wrote:  SELECT * FROM mytable WHERE  ID='1007' AND YEAR(datetime)=2015 AND MONTH(datetime)=1  But I cannot get the data and FME say: MS SQL Server Reader: Query failed, possibly due to a malformed statement. Provider error `(-2147217871) Query timeout expired'   Does anyone know the reason?  Thanks in advance, Ariel